Rank: Member
Joined: 1/16/2008 Posts: 14
|
We have a routine generated with MapForce that is working except for multiline CSV rows. The problem isn't MapForce but I'd like to use MapForce to overcome it if possible. Currently, we open the CSV file, read the header, read a line, put both of those together in a StringImput and have the MapForce generated code produce an XMLDocument. We use this document to build a path to a file we need to copy so that there is a pair of files for our imaging system to pickup and import. Can we modify this so that we supply MapForce with the entire CSV file (about 1/3 million rows) and it will allow us to copy the pair file prior to generating the next file? We have the mapping set up correctly to generate one file per row of the CSV file but need to copy a second file along with the one MapForce just generated.
Generated code is in C#
Appreciate any help or pointers, ScottFile Attachment(s): XRay_test.mfd (14kb) downloaded 79 time(s).
|
Rank: Advanced Member
Joined: 2/27/2009 Posts: 558
|
Could you attach an example file?
|
Rank: Member
Joined: 1/16/2008 Posts: 14
|
Here is the MapForce diagram transforming the CSV file to one XML file per row.
|