Re: Data transfer question

Greg,


I've used three ways regularly, all work OK, but none are "ideal" in my opinion.  


1)  For repeated extracts of the same data using the Client Access "Access data from iSeries" option, I keep the spreadsheet headings intact, clear the data, and position the cursor to below the headings, then transfer without including the headings from the extract file.  Formatting stays intact, headings are the way the user wants them.   Manual process, yes, but it's easy and works fine.  BUT.... only practical for repeated downloads of the same data.

2)  Another way to automate the process (similar), is to use a CL, keep a "canned heading" file stored in the folder, copy the canned heading file in, then copy append the data afterwards.  Then I can email the file to the user.  That's how I eliminated a lot of printed reports.  However, like option #1, this only works for repeats.

A possible alternative (if Excel is not a carved-in-stone requirement) is:


3)  I also eliminated a number of reports with Browser/PowerLink/NetLink by creating the reports as databases and letting the users access the information on demand.  That way you don't have to worry about headings and such, or emailing.  You can also easily create comment fields that users can populate during the day to pass information.  That was popular with some of the production departments and the sales and marketing people.  Again, only useful for repeats, but I really liked that when I could use it.  You don't need to get copies of Office (and yes, I used OpenOffice extensively - over 80% of the PCs had it), but you STILL have to install and set it up), so it can save you money over time (assuming your users use Browser/PowerLink/NetLink).


I'm looking forward to hearing what others have come up with for this!  :)

Dale (Cork) Gindlesperger, CPIM
Click here for my professional profile on LinkedIn

"If I'd asked my customers what they wanted, they'd have said a faster horse." - Henry Ford

________________________________
From: Greg Wenzloff <GWenzloff@xxxxxxxxxxx>
To: MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
Sent: Thursday, June 23, 2011 10:21 AM
Subject: [MAPICS-L] Data transfer question

I need to transfer the contents of a MAPICS file into an Excel
spreadsheet.
When I do this I get column headings such as ORDNO.

Is there something I can do to get different column headings other than
the field name.
Perhaps ORDER NUMBER.

I want to automate this and not go into Excel to adjust column heading
each time this transfer is run.

Thanks,
Greg
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.