- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
Exporting Headers from Visual Integrator
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
01-20-2009 01:32 PM
I just needed to do this, and thought it would be a good topic to bring over from the old forums.
Courtesy of Slade Hornick:
Assuming you are exporting a csv (comma delimited file) you can add the following perform logic to one of the data elements on "BEFORE ASSIGN"
Just save this in a text file in your ../mas90/vi directory named something like: export_headers.pl and then on the data tab select a field click the perform logic button and put ../vi/export_headers.pl in the perform logic command on BEFORE ASSIGN. It shouldn't matter which field - I had put it on the last one in the list and it worked OK for me.
! Add Column Headers to VI Export Job
! Slade Hornick
! slade@hornickconsulting.com
! 03/24/2006
!
if ct then exit
open (hfn,iol=*)"../vi/viijob.soa"
select * from lfo begin vi2_job_name$ end vi2_job_name$+$fe$
rec$+=vii_field_name$+","
next record
close (lfo)
print (1)mid(rec$,1,len(rec$)-1)
ct++
exit
Re: Exporting Headers from Visual Integrator
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
01-20-2009 03:03 PM
I don't know if you've looked at a current version of MAS but the option to "Export column headers as first line" is right in the Export Job Maintenance under the Options button.
Dawn
Re: Exporting Headers from Visual Integrator
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
01-21-2009 10:40 AM
Re: Exporting Headers from Visual Integrator
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
01-21-2009 04:38 PM
Are you trying this for a business framework file or legacy file?
Dawn
Re: Exporting Headers from Visual Integrator
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
01-23-2009 12:12 PM
Re: Exporting Headers from Visual Integrator
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
01-23-2009 01:06 PM
Inventory is still a legacy module. So, no options button.
Dawn
Re: Exporting Headers from Visual Integrator
[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
01-23-2009 02:03 PM - last edited on 01-23-2009 03:00 PM
This is the only way to get headers on VI exports until ALL modules are on the 4x framework, correct?
Re: Exporting Headers from Visual Integrator
[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
06-15-2010 05:59 AM - last edited on 06-15-2010 06:42 AM
You say this is for inventory. Will this also work on PR or will I have to change the logic?
When I attempted to run this I got a VI2Job.SOA not found Error... nevm this putting in the wrong place.
Now its telling me my own CSV file does not exsist. I just looked into the file system and it is there its just empty.
Re: Exporting Headers from Visual Integrator
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
06-15-2010 06:47 AM
What table are you trying to export from payroll?
Re: Exporting Headers from Visual Integrator
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
06-15-2010 06:58 AM
theres only 2 PR.EMPL and PR.DEPT


