IMPORTANT:
this is not a Support Forum! Experienced users might answer from time to time questions posted here. If you need a professional and reliable answer, or if you want to report a bug, please contact Altova Support instead.

Multiline CSV row Options · View
TBlackbird
Posted: Friday, February 12, 2021 9:07:27 PM
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,
Scott

File Attachment(s):
XRay_test.mfd (14kb) downloaded 45 time(s).


K101
Posted: Tuesday, February 16, 2021 10:54:21 AM
Rank: Advanced Member

Joined: 2/27/2009
Posts: 438
Could you attach an example file?
TBlackbird
Posted: Tuesday, February 16, 2021 3:41:50 PM
Rank: Member

Joined: 1/16/2008
Posts: 14
Here is the MapForce diagram transforming the CSV file to one XML file per row.
Users browsing this topic
guest

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Use of the Altova User Forum(s) is governed by the Altova Terms of Use.