× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MAPICS-L
  3. June 2011

Headings on Data Transfer

I use the "results" field in QRY to rename the headings. Just be sure to select the renamed field in your report. See this example:
STORE T02.LLOCN Location
Everytime you run this qry the heading STORE will come down instead of LLOCN.


-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of mapics-l-request@xxxxxxxxxxxx
Sent: Thursday, June 23, 2011 1:00 PM
To: mapics-l@xxxxxxxxxxxx
Subject: MAPICS-L Digest, Vol 9, Issue 78

Send MAPICS-L mailing list submissions to
mapics-l@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/mapics-l
or, via email, send a message with subject or body 'help' to
mapics-l-request@xxxxxxxxxxxx

You can reach the person managing the list at
mapics-l-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific
than "Re: Contents of MAPICS-L digest..."


Today's Topics:

1. Data transfer question (Greg Wenzloff)
2. Re: Data transfer question (Chuck Mick)
3. Re: Data transfer question (Tom E Stieger)
4. Re: Data transfer question (Dale Gindlesperger)
5. Re: Data transfer question (JoseORivera@xxxxxxxxx)
6. Re: Data transfer question (Tim Rosendahl)
7. Re: Data transfer question (ARojas@xxxxxxxxxxx)


----------------------------------------------------------------------

message: 1
date: Thu, 23 Jun 2011 10:21:23 -0400
from: "Greg Wenzloff" <GWenzloff@xxxxxxxxxxx>
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


------------------------------

message: 2
date: Thu, 23 Jun 2011 10:28:18 -0400
from: "Chuck Mick" <Micklc@xxxxxxxxx>
subject: Re: [MAPICS-L] Data transfer question

Greg,

This may not be the desired option...

We often create a refreshable file with the standard XA names...but we
then insert a pivot table that contains the user desired information /
report. Within the pivot table, we rename the column headings to be
more friendly. Users can then refresh the data and the
pivot...retaining the headings.

Alternatively, we have several 'reports' that have standard headers and
the imported information displays before the headers. We set Excel to
not include the field names...

Other times (and I know this probably not the most efficient...but is
effective for us)...we create logical views and rename the columns as
desired. We then refresh using the logical.

I would like to see if anybody gives a direct answer...but we have
'worked around' it as above...

Chuck


Chuck Mick
Diversified Machine Inc.
(o) 248.277.4315
(m) 517.643.3548



?
Confidential: This electronic message and all contents or attachments contain information from Diversified Machine, Inc. which may be privileged, confidential or otherwise protected from disclosure. The information is intended to be for the addressee only. If you are not the addressee, or have received this message in error, any disclosure, copy, distribution or use of the contents of this message is prohibited. If you have received this electronic message in error, please notify us immediately (248-277-4311) and destroy the original message and all copies.?Thank you for your assistance in this matter.
?
** Please consider the environment before printing this e-mail **
?
-----Original Message-----

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



------------------------------

message: 3
date: Thu, 23 Jun 2011 07:37:49 -0700 (PDT)
from: Tom E Stieger <testieger@xxxxxxxxxxxx>
subject: Re: [MAPICS-L] Data transfer question

Greg-

How are you doing the transfer?

I've been semi-successful using some properties on a JDBC Connection URL to bring over the column headings.

JDBC Driver:
com.ibm.as400.access.AS400JDBCDriver
JDBC URL:
jdbc:as400://myas400.name;translate binary=true; extended metadata = true;

This would bring over a column heading looking like this: 'Order Number'

I'm not sure if there something similar with ODBC.
I think I have also had success using some of Chuck's suggestions.

-Tom Stieger
IT Manager
California Fine Wire

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



------------------------------

message: 4
date: Thu, 23 Jun 2011 08:06:01 -0700 (PDT)
from: Dale Gindlesperger <dale_gindlesperger@xxxxxxxxx>
subject: Re: [MAPICS-L] 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.





------------------------------

message: 5
date: Thu, 23 Jun 2011 11:16:23 -0400
from: <JoseORivera@xxxxxxxxx>
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.



------------------------------

message: 6
date: Thu, 23 Jun 2011 09:07:48 -0700 (PDT)
from: Tim Rosendahl <rosetj2011@xxxxxxxxx>
subject: Re: [MAPICS-L] Data transfer question

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.

------------------------------

message: 7
date: Thu, 23 Jun 2011 09:24:03 -0700
from: ARojas@xxxxxxxxxxx
subject: Re: [MAPICS-L] 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.





------------------------------

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) digest 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.



End of MAPICS-L Digest, Vol 9, Issue 78
***************************************

This email and any files transmitted with it are confidential and intended solely for the use of the individual to whom they are addressed. If you are not the intended recipient, be aware that disclosing, copying, distributing, or taking any action in reliance on the contents of this information is strictly prohibited. Please notify the sender immediately by email if you have received this email in error and delete this email from your system.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.