News:

  • June 11, 2026, 08:04:34 AM

Login with username, password and session length

Author Topic: Wonderware .csv  (Read 21732 times)

rquin

  • Newbie
  • *
  • Posts: 2
Wonderware .csv
« on: January 04, 2008, 11:02:48 AM »
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.

franji1

  • Bit Weenie
  • Host Moderator
  • Hero Member
  • *****
  • Posts: 3827
    • Host Engineering
Re: Wonderware .csv
« Reply #1 on: January 04, 2008, 11:13:22 AM »
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).

ATU

  • Internal Dev
  • Hero Member
  • ****
  • Posts: 2126
  • YKPAIHA
    • ATU, Inc.
Re: Wonderware .csv
« Reply #2 on: January 10, 2008, 09: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.