Help - Search - Members - Calendar
Full Version: CSV files
Forums.MrPLC.com > PLCs and Supporting Devices > Omron > CX-Designer
pfort
I tried to save excel sheet on CSV format then import it in CXD, because it is more efficiency for editing about 150 alarms.
I was not able to import it in CXD.
CXD need something like this:

"Field 1","Field 2",'"Field 3","Field 4","Field 5" etc

But when i convert from Excel to CSV i get something like this:

Field 1; Field 2; Field 3; Field 4; Field 5 etc

Finaly i entered my 150 alarms 1 by 1 in the Alarm/Event table... disgust.gif
But for the next time i would like to learn how to do so any help welcome

scottmurphy
QUOTE(pfort @ Mar 4 2009, 07:40 PM) [snapback]79568[/snapback]

I tried to save excel sheet on CSV format then import it in CXD, because it is more efficiency for editing about 150 alarms.
I was not able to import it in CXD.
CXD need something like this:

"Field 1","Field 2",'"Field 3","Field 4","Field 5" etc

But when i convert from Excel to CSV i get something like this:

Field 1; Field 2; Field 3; Field 4; Field 5 etc

Finaly i entered my 150 alarms 1 by 1 in the Alarm/Event table... disgust.gif
But for the next time i would like to learn how to do so any help welcome


Create a couple of alarms in different formats that you want, export to csv, add the extras to the csv file in the same format as the ones you entered manually, then re-import the csv back into CX-D.



pfort
Yes that is what i want to do, but, for easyer editing, i formated it in Excel so i have 1 column for each field. But i can not get it back to each field separated by quotation mark and comma.
pfort
Someone at OMRON helped me, i just had to change Windows Regionals Settings from "french Canada" to "English United States" and now it work fine. dancered.gif
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2010 Invision Power Services, Inc.