(API) Robot 2018 - CSV file on Results for Plates

[Anonymous]

Hi,

I am starting to use Robot 2018 and I notice that the conversion to CSV file from the table of "Results for Plates" is not following the same format as in Robot 2015. The character that is doing the separation between "Panel", "Node" and "Case" is "/" instead of ";".

This is a beat boring, because when I need to open the csv file in excel, the numbers of the panel and the node appear at the same column and cell.

Is there any way in Robot 2018 to continue to export this table in the same format as in Robot 2015?

Thank you.

Kind regards,

David

[Rafal.Gaweda]

Hi @Anonymous

My advice is to open csv file in Notepad and replace / by ; and save the file

[Anonymous]

Thank you for your reply, but a bit tricky for a CSV file which goal is to create a text file with strings separated by "," or ";"!!

If it was working fine in the previous versions, why it has changed?!

Regards,

David

[Rafal.Gaweda]

Hi @Anonymous

I guess it was changed to have exactly the same table look like in Robot. First column contains "/" sign in Robot.

[Anonymous]

hi,

Worse than the change made is the autodesk support justification, totally unacceptable.

NMV

[Artur.Kosakowski]

Hi @Anonymous

I'd say it is hard to understand why Microsoft allows you to replace /space with another character in e.g. Notepad but doesn't allow you to set it as a delimiter in Excel 

Anyway the solution proposed by Rafal is not that hard to execute:

If you find your post answered press the Accept as Solution button please. This will help other users to find solutions much faster. Thank you.

[StefanoPasquini6790]

If I'm not wrong, in excel you can set more than one limiter in the csv data importing, so you can use two or three of them, including an "user defined one" . I do this everyday.

[Artur.Kosakowski]

HI Stefano,

The only issue is that if you set / then you will 'corrupt' units as well . This is why I introduced notepad in the process as I wasn't able to set /space as the 'used defined one' in Excel 

[Anonymous]

Hi,

I keep my opinion that RSA 2018 has a "minor bug" in the conversion to a CSV file that should be corrected in the next service pack, because it doesn't make any sense spend time in opening  the csv in the notepad then replace "/" by ";" except in the units, save the file and then open it in Excel, even more when this option of convert to CSV was working fine and correctly since Robot 17 (2002)!!

Regards,

David

[Artur.Kosakowski]

Hi @Anonymous

I have forwarded your request to the development team. I hope that for a moment the workaround I provided will be acceptable for you.

If you find your post answered press the Accept as Solution button please. This will help other users to find solutions much faster. Thank you.

[Rafal.Gaweda]

Hi All

I have prepared (in fact I have modified existing on forum) macro for dumping active table with all tabs to csv \ txt replacing correctly "/" and keeping units.

Macro attached.

Feel free to modify it if needed.

PS

Sometimes it may not run on Plate and Shells Results table \ Envelope tab