The Siemens Community Catalyst program was co-created with our community to acknowledge technology leaders who consistently contribute to the Siemens Community. Nominations are accepted on a rolling basis.
Hi Team,
Could some one please help my problem, i created a process in Monarch Automator to extract data from PDF and export to Database, some of the numeric column values of PDF are exported to Database as scientific notation and In database column format is in VarChar(255). My question is how to export the exact pdf data to Database ?
Regards,Syed
Hi Syed,
What do you mean by exact PDF data? If scientific notation numbers are stored as character in Monarch, you can use the Val() function and convert them to numbers and yoy specify the number of decimals (from 1 to 9 decimals.) optionally hide the scientific notation field.
When you export Monarch numeric data type to a SQL table, the Automator exports them as float. If you need a different data type such as the Decimal, you need to create the table schema. In the Automator export wizard, map model fields to the SQL table fields (or if field names in the SQL table are the same field names in Monarch model, than you can export all with mapping).
Regards
Mo
Join us for a community conversation on how High-Performance Computing (HPC) and Simcenter PSIM work together to meet the increasing demands of modern power electronics simulation. During this one-hour technical session, you'll discover how leveraging HPC can speed up simulations, improve scalability, and empower engineers…
Join us for a community conversation on accelerating your motor simulation workflow with Simcenter Simlab. In this beginner-friendly session, we'll introduce the platform's automated model-building capabilities and show how easy it is to set up your first electric motor analysis. You'll see the basic steps of geometry…
Join us for a Community Conversation where we'll discuss practical approaches to analyzing complex electromagnetic models using hybrid solver techniques. This session will provide a general overview of how different computational methods can be combined within a single simulation to address models containing varied…
