Highlighted

Data Import Tool

Genius
Genius

Hello,

While importing excel Data in AMESim with the import tool, I have the possibility to select rows for header and units.

While the row unit can be automatically updated in the *.dat file, I cannot automatically update the name of the Y values.

 

For instance if I import an excel file with time[s]; pressure[bar]; flow rate[l/min]

At the end of the import process I get a plot with item 1[bar] and item 2 [l/min]

I wanted to have directly pressure[bar] and flow rate[l/min].

Is it possible ?

 

Thank for any tipp

 

Maxime

10 REPLIES 10

Re: Data Import Tool

Siemens Phenom Siemens Phenom
Siemens Phenom

Hi @mAx ,

 

what you describe has been implemented in Amesim 17 Smiley Wink

 

Re: Data Import Tool

Genius
Genius
Ok I have to move on REV17 then....
Thanks

Re: Data Import Tool

Genius
Genius

Hi @Emmanuel_D ,

I am writing right now a python script for importing customer measures in amesim.

I come again across this issue by renaming "item"

I can work with a workaround in rev16 by exporting the plot file in *.plt and then editing this file.

 

I switched to rev17, by I don't see the feature you mentionned, eg: using header_row in import xls for automatically renaming items

 

Do you have an example?

 

Maxime

Re: Data Import Tool

Siemens Phenom Siemens Phenom
Siemens Phenom

Hi @mAx ,

 

I just tried with a 1D table:

image.png

 

Did I miss something?

 

Re: Data Import Tool

Genius
Genius

@Emmanuel_D 

If you plot your 1D Table (New Plot/load 'yourfile.dat')

Do you have then the label "Height" in the legend, or do you still have item 1 of yourfile.dat ?

Re: Data Import Tool

Siemens Phenom Siemens Phenom
Siemens Phenom

No I don't... They are still named "item 1.." and "item 2 of example".

image.png

It's worth raising an improvement report.

 

Re: Data Import Tool

Genius
Genius

Ok, then I have to go on my workaround...

Thanks anyway

Re: Data Import Tool

Genius
Genius

Alright my workaround works.

Now I need to import all the *.plt files in the plot manager.

Is there a python function for that?

Smiley Happy

Re: Data Import Tool

Siemens Phenom Siemens Phenom
Siemens Phenom

Not that I know...

 

But there is a plot API which does allow you to create custom plots. In a way it would allow you to script what you have done to create the plt file in the first place...

 

See this demo:

image.png

 

And the associated documentation at this address in the help:

qthelp://lmsimagine.lab/ame_dir/doc/html/manuals/AMESim/Customization/Plot_API/Graph.html