Need Easier Way to Include CSV Column Headings

Post any question you may have in regards to GoAnywhere MFT and let our talented support staff and other users assist you.
2 posts Page 1 of 1

T_Bekker

Posts: 8
Joined: Fri Aug 10, 2012 11:55 am

Post by T_Bekker » Thu Oct 15, 2015 3:37 pm
This is the most common problem I have with GoAnywhere. I need to extract data from an iSeries file, output the data to a CSV, but the recipient requries a column heading record, with their specific column headings, according to their provided specifications.

The options in the Write to CSV task simply allow me to include the column headings, or not. When I do, I get the iSeries field names from the source file. I tried using the Data and Column sub-tasks, and specifying the value they want in the Column Name field, but that clearly does not do what I need.

The workaround that I have used is to create a text file containing the delimited column names they want, and in the GA project, I first copy that file to my output file. Then I use the Write CSV task to append the data to that file, with the column headings option off.

I'd like to know if there is an easier way to do this, and if not, could I suggest an enhancement to the Write CSV task, to be able to put the column heading I want somewhere on the Column sub-task? That would really cut out a lot of additional work.

Support_Rick

Support Specialist
Posts: 592
Joined: Tue Jul 17, 2012 2:12 pm
Location: Phoenix, AZ

Post by Support_Rick » Fri Oct 16, 2015 8:28 am
Troy,

Currently, that's one option to putting those column headers into your CSV doc. You could also select them from a pre-defined table in the order you want as well. Either works ...

I'm emailing you an enhancement request form. Please fill that out with your request for an update to the product for the CSV Headers.

Thanks!
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
2 posts Page 1 of 1