| View previous topic :: View next topic |
| Author |
Message |
arcray
Valued Contributor
Joined: 13 Jul 2001
Posts: 242
Location: Aude, France
|
 Posted: Thu Nov 15, 2012 8:51 am Post subject: Converting standard CSV files to XML files |
 |
|
Is there an easier way of doing this? Is there a tool that can be used with VDS?
Many thanks in advance
_________________
Andrew GRAY
If you don't know I am looking for work, I won't get the job.
andrewrcgray.com |
|
| Back to top |
|
 |
arcray
Valued Contributor
Joined: 13 Jul 2001
Posts: 242
Location: Aude, France
|
| Posted: Thu Nov 15, 2012 2:47 pm Post subject: Re: Converting standard CSV files to XML files |
|
|
| arcray wrote: | Is there an easier way of doing this? Is there a tool that can be used with VDS?
Many thanks in advance |
Found a DOS EXE called csv2xml which works fine from a CMD window, but I can't get it to work using the VDS RUN command:-
RUN csv2xml -m=1 < OUT6.csv > OUT6.xml
Any pointers?
Cheers
_________________
Andrew GRAY
If you don't know I am looking for work, I won't get the job.
andrewrcgray.com |
|
| Back to top |
|
|
cnodnarb
Professional Member
Joined: 11 Sep 2002
Posts: 765
Location: Eastman, GA
|
| Posted: Sat Nov 17, 2012 1:39 am Post subject: |
|
|
I've had those types of troubles 
Sometimes directory change,@path(%0) gets it
But sometimes I have to use
Shell Open,command,parameter (look at the help)
I've never had anything that wouldn't work with enough fiddling. |
|
| Back to top |
|
|
Dr. Dread
Professional Member
Joined: 03 Aug 2001
Posts: 1065
Location: Copenhagen, Denmark
|
| Posted: Sat Nov 17, 2012 2:36 pm Post subject: |
|
|
... or you could use your string.dll. Make an XML template with placeholders and put that in a variable, loop through your file, extract CSV cells and inject them into your template by S&R.
Greetz
Dread
_________________
~~ Alcohol and calculus don't mix... Don't drink and derive! ~~
String.DLL * advanced string processing |
|
| Back to top |
|
|
Aslan
Valued Contributor
Joined: 31 May 2001
Posts: 589
Location: Memphis, TN USA
|
| Posted: Sun Nov 18, 2012 2:36 am Post subject: |
|
|
| Code: | | RUN cmd /c <path>\csv2xml -m=1 < OUT6.csv > OUT6.xml |
- or -
| Code: | directory change,@path(%0)
# or "directory change,@path(<path to exe>)
RUN cmd /c csv2xml -m=1 < OUT6.csv > OUT6.xml |
|
|
| Back to top |
|
|
arcray
Valued Contributor
Joined: 13 Jul 2001
Posts: 242
Location: Aude, France
|
| Posted: Thu Dec 20, 2012 9:41 am Post subject: |
|
|
Hi Aslan
| Code: | | RUN cmd /c <path>\csv2xml -m=1 < OUT6.csv > OUT6.xml |
worked very well! Sorry to not say so before, but I had been out of touch.
Cheers
_________________
Andrew GRAY
If you don't know I am looking for work, I won't get the job.
andrewrcgray.com |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
@vdsworld