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.
Hello Lasse, Have you reached out to our Support Team?They may be able to provide assistance in what you are seeking to accomplish. I did find the following information links regarding Input/Export Elements via Automator Processes with the documentation.
I think the process you may be looking to create is File Input -> workspace -> Export-Rebecca------------------------------Rebecca CroninCustomer Success & Community ManagerDatawatch CorporationBedford MA(978) 275-8203-------------------------------------------------------------------------Original Message:Sent: 05-08-2019 10:17 AMFrom: Lasse KaikkoSubject: Automating excel to csv conversionHiI have been trying to build a visual process to convert .xlsx-files to .csv-format.I guess the process is simple as Database Input -> Workspace -> DataPrep Export.The problem is that Database Input and Workspace ask for table name. In my case table names may vary. All I want is that the process would convert .xslx files first table to .csv format.Would anyone have an idea of how to proceed with this?Automator version is 15.3.Thanks,Lasse"
Inside your visual process, create a database input node and connect it to your workspace.Click on the database input node and for the data source, you can specify the path using a wildcard character (\\server\share\*.xlsx).You can then click on your workspace, and if you expand the load plans section, you should be able to see your original file name. Select the drop down button and choose "Database Input" (or whatever the name of the database input node is).Hope this helps.------------------------------Chris PorthouseSenior Implementation & Integration EngineerAltair-------------------------------------------------------------------------Original Message:Sent: 05-08-2019 10:17 AMFrom: Lasse KaikkoSubject: Automating excel to csv conversionHiI have been trying to build a visual process to convert .xlsx-files to .csv-format.I guess the process is simple as Database Input -> Workspace -> DataPrep Export.The problem is that Database Input and Workspace ask for table name. In my case table names may vary. All I want is that the process would convert .xslx files first table to .csv format.Would anyone have an idea of how to proceed with this?Automator version is 15.3.Thanks,Lasse"
Hi Chris,I had a similar question and your response helped a lot. To complicate just a bit - is it possible to define a global variable [&date] in a global script and use it in the Database Input path instead of wildcard, i.e. \\server\share\myfile_[&date].xslx?If yes, can you please help with a sample. We just purchased Automator and learning on the fly.Thank you, Leonid------------------------------Leonid ShteyngardtApp Dev ManagerCanaccord Genuity Inc.New York NY(212) 389-8176-------------------------------------------------------------------------Original Message:Sent: 05-15-2019 07:35 AMFrom: Chris PorthouseSubject: Automating excel to csv conversionInside your visual process, create a database input node and connect it to your workspace.Click on the database input node and for the data source, you can specify the path using a wildcard character (\\server\share\*.xlsx).You can then click on your workspace, and if you expand the load plans section, you should be able to see your original file name. Select the drop down button and choose "Database Input" (or whatever the name of the database input node is).Hope this helps.------------------------------Chris PorthouseSenior Implementation & Integration EngineerAltair------------------------------Original Message:Sent: 05-08-2019 10:17 AMFrom: Lasse KaikkoSubject: Automating excel to csv conversionHiI have been trying to build a visual process to convert .xlsx-files to .csv-format.I guess the process is simple as Database Input -> Workspace -> DataPrep Export.The problem is that Database Input and Workspace ask for table name. In my case table names may vary. All I want is that the process would convert .xslx files first table to .csv format.Would anyone have an idea of how to proceed with this?Automator version is 15.3.Thanks,Lasse"
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…
