Host Engineering Forum
 
*
Welcome, Guest. Please login or register.
Did you miss your activation email?
May 18, 2012, 06:14:11 pm


Login with username, password and session length


Pages: [1]
  Print  
Author Topic: Wonderware .csv  (Read 796 times)
rquin
Newbie
*
Posts: 2


« on: January 04, 2008, 12:02:48 pm »

Direct Soft gives 3 ways to export to a .csv file. The problem I have is none of these is coming close to what I need for Wonderware. Is there a way to export a .csv for the WW format? Right now I have to enter 1 tag at a time manually and if it is large size project, it eats up a lot of time.
Logged
franji1
Bit Weenie
Host Moderator
*****
Posts: 1032



WWW
« Reply #1 on: January 04, 2008, 12:13:22 pm »

No, it does not support it.  Do you know what the import format is for Wonder Ware (or have a link to where it is described)?

If it's relatively simple (e.g. the columns are just swapped), you could just load the CSV into Excel, swap the columns, then export it as another CSV file.

Regardless, let us know what it is and maybe we can help you out (or someone else out there may already know how to do this).
Logged

ATU
Internal Dev
****
Posts: 722


YKPAIHA


WWW
« Reply #2 on: January 10, 2008, 10:18:42 am »

If you can't find a spec for importing the tag names, I have found working with packages like that, if you can do an export from the software and look at the results, you can usually figure it out. Most have problems with spaces  and non-alphanumeric characters. Make a test application up with a few tag names using these and see how it treats the characters in the exported file. Then you can use search/replace in excel and/or concatenation to get the desired tag name format. Hope that helps.
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.16 | SMF © 2011, Simple Machines

Valid XHTML 1.0! Valid CSS! Dilber MC Theme by HarzeM