Hi all,
I have a job where I need to create two output files from one file just with a different sort order.
The input is a .csv file and I need two .csv file as the output, one in Sort order and one in Proof Order
I have set up a two Data mapper templates (sortorder and prooforder) and when I view this within datamapper the sorting works perfectly, when I run this through workflow I get this error:
[0005] W3001 : Error while executing plugin: The specified name is invalid: “_vger_fld_First Name”
I’ve tried removing my headings within workflow and then adding them back in within workflow with no joy.
Have tried the different output options within execute data mapper with no joy, it either works with no sort, works but with the error but fails to sort or splits out an XML file that is sorted but i want a .csv
Any tips?
This error tends to point to a field name FirstName that would be missing.
Can you share your Datamappers and data file (after removing any sensitive information) so we can look at them?
Hi jchamel,
I dont think it like the space in the field so i went and removed all spaces in the field names, this removed that error but now nothing is sorted.
Will try and remove any sensitive information and post up the file.
We use sort quite a bit but normally data mapper is sorting and passing straight to print and this works like a dream, it seems to not like taking a .csv, sorting and then spitting out a .csv
Make sure the issue is reproducible once you have removed the sensitive information prior to posting it 
For a Datamapper to output CSV, you need to do so in the Post-Processor as a script.
Datamapper can output the following:
Before you had a CSV as output because your Datamapper was in error and that is the default behavior of the intput file not being replaced by something else when a Datamapper errors out.
You can search this forum for example of outputting CSV from a Datamapper.
