Re: Data transfer question

Hi Greg,

We use Sequel Viewpoint from Help Systems and works perfect for us when
downloading data to Excel including the column names, other benefits are:
- Conversion of the Date from CYYMMDD to MMDDYY or any other format
- You can change the value of the output field.. .for example instead of
showing ITTYP = 1, your query can convert this to column 'Item Type',
and the value to be : "1 - Finished Good'


We also have Linoma software for this.

Regards
Antonio.




From: Tim Rosendahl <rosetj2011@xxxxxxxxx>
To: MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
Date: 06/23/2011 09:08 AM
Subject: Re: [MAPICS-L] Data transfer question
Sent by: mapics-l-bounces@xxxxxxxxxxxx



I jave several of these and I set up a template for each of the transfers.
I the
transfer request I have unchecked the item wich includes fields headings.




________________________________
From: "JoseORivera@xxxxxxxxx" <JoseORivera@xxxxxxxxx>
To: mapics-l@xxxxxxxxxxxx
Sent: Thu, June 23, 2011 11:16:23 AM
Subject: Re: [MAPICS-L] Data transfer question

You can gather all column's field names and inside the Client Access
transfer change the name,  like below

Select area:

ORDNO as  order_number

Jose Rivera


-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Greg Wenzloff
Sent: Thursday, June 23, 2011 7:21 AM
To: mapics-l@xxxxxxxxxxxx
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.

_______________________________________________
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.

_______________________________________________
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.
_______________________________________________
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.