adccommunitymod (AutomationDirect) asked a question.
Import Tag Database
Created Date: April 10,2006
Created By: jstohr
**** This post has been imported from our legacy forum. Information in this post may be outdated and links contained in the post may no longer work.****
I used DirectSoft5 to export the element documention to the C-More content format. During this process I noticed that DS5 uses the .csv format to export and C-More is looking for an .xls format to import. So I opened the .csv and saved it as an .xls. When I tried to import the tag database I recieved the error "Import Error. Please check import file. ". What am I doing wrong?
Created Date: April 11,2006
Created by: franji1
Keep the extension .CSV, but on the import dialog, change the filter from *.XLS to *.* (or *.CSV if it is there). Then open the .CSV file.
The extension tells the import facility what type of file it is, so it thought it was literally an Excel Spreadsheet file, but it is just a text file containing "comma separated variables ", hence why it failed.
I think in a future version they are going to add the .CSV extension as part of the filter list so it will "just work ".
Created Date: April 12,2006
Created by: jstohr
I tried that originally but it only offers the *.xls format. I have no other options.
Created Date: April 12,2006
Created by: franji1
Then in the file text box, just literally type in the file name without clicking on the file, e.g. MYPROJ.CSV
You can still browse to the folder, but then just type in the file name instead of finding it in the dialog.
Created Date: April 12,2006
Created by: Tech Guy
Check your tags to see if they are uppercase characters. If they are not, then you will need to change them to uppercase. The easiest way is to open the .csv file in Word, select all and then go to Format -> Change Case. Save the file and then open in Excel and save as an Excel format.
We are working to get this changed in a future version.
Created Date: April 12,2006
Created by: jstohr
I tried both ideas and I got it to import the data by just typing in the file name with the .csv extension, but I got the error "Tag with TagName and Address -- Unable to add to TagData Base.
DataType is Data Range Error. " for all 500 plus tags. Capitalizing did nothing to resolve the problem.
Created Date: May 11,2006
Created by: jdw1996
I had the same problem. I think there is some sort of bug in the Directview export process because the export only exports three fields (tagname, type, and address). I resolved it by exporting the database from CMore to a XLS or CSV file so I had a template of what it was looking for in its import format (lots of fields in addition to the critical tagname, type, and address). I then exported the tag database from the PLC side to a different CSV or XLS file. I opened the PLC export file and copied the tagname, type, and address into the appropriate fields in my template file, saved it, and then re-imported it back into the CMore tag database. It was a round-about process but it saved a lot of typing on 500 tags.
Created Date: November 01,2006
Created by: engineerrock
Does anyone know if the export link has been fixed? I tried to export from Directsoft to C-more micro and it gives me a database corrupt error.
Created Date: November 03,2006
Created by: HMI Eng
Make sure you are using version 1.21.6.18E. It has the selection for the CSV file extension and there are no issues with file export from DS5 and Import to C-more (except for special characters, we discovered DS5 allows characters such as "'s, that C-more will not import or ignore at this time)
Created Date: April 10,2006
Created by: jstohr
I used DirectSoft5 to export the element documention to the C-More content format. During this process I noticed that DS5 uses the .csv format to export and C-More is looking for an .xls format to import. So I opened the .csv and saved it as an .xls. When I tried to import the tag database I recieved the error "Import Error. Please check import file. ". What am I doing wrong?