Thanks Tom for the tip on the keys.
I added in the keys, and it works perfectly.
How did you know or where to did you look for the file key info?
Weston
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Tom E Stieger
Sent: Thursday, November 18, 2010 2:30 PM
To: 'MAPICS ERP System Discussion'
Subject: Re: [MAPICS-L] Exporting data from PowerLink to Excel 2007
I think that the key being only on IQCVNB (shouldn't it be JQCVNB) might
be the problem. If you run the sql from the monitor, does it show the
extra data and does the row count match power-link's count?
If the object is directly on phsyical file AMFLIB/MTHACTE then the file
definition doesn't have any keys on it so you have to manually add the
unique key structure that describes that data. For this Object it is
JQAENB, JQDCCD, JQCVNB, JQFCNB, JQDRNB, JQAASZ, JQKWNB (Company, Order
type, Order Number, Line Item Sequence, Release Number, Kit Release
Sequence, Release Sequence Number). We are currently at 7.7 and I know
some changes happen at 7.8 with kits so I'm not sure if the Kit Release
Sequence is applicable.
For our environment I have two objects for bookings data. One over
MTHACTE so that I can see every record in the file and one over a
logical that only shows the net change (quantity or price) per line item
in a given day if the net change is not 0. This is so when sales looks
at these numbers it makes sense and doesn't have to do the totals
themselves.
-Tom
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Weston Wheat
Sent: Thursday, November 18, 2010 12:50 PM
To: mapics-l@xxxxxxxxxxxx
Subject: Re: [MAPICS-L] Exporting data from PowerLink to Excel 2007
Tom , Kevin
Yes the object is good old mthacte.
I am exporting to a text comma delimited file, then bring it into excel.
It only has one key , iqcvnb Quote/order number.
When I turn on the SQL monitor, the monitor show that its select the
correct data.
What else should the monitor show?
Weston
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Tom E Stieger
Sent: Thursday, November 18, 2010 12:17 PM
To: 'MAPICS ERP System Discussion'
Subject: Re: [MAPICS-L] Exporting data from PowerLink to Excel 2007
You had mentioned boookings data, is this object over the MTHACTE file
or do you have a different file or view that the object is looking at?
What keys did you assign it in integrator? What does the SQL monitor
show when you have that turned on and open up the object?
-Tom
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Weston Wheat
Sent: Thursday, November 18, 2010 11:05 AM
To: mapics-l@xxxxxxxxxxxx
Subject: Re: [MAPICS-L] Exporting data from PowerLink to Excel 2007
Tom.
We are just export a primary object. And the row counts are not correct.
But sometimes the totals on the $ fields are correct. It seems to drop
random records for some reason.
Weston
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Tom E Stieger
Sent: Thursday, November 18, 2010 11:12 AM
To: 'MAPICS ERP System Discussion'
Subject: Re: [MAPICS-L] Exporting data from PowerLink to Excel 2007
Weston-
If your total in excel don't match the totals and row count in powerlink
check the custom relationships you have, any key info on the objects and
the SQL that is run.
Powerlink will not show duplicate keys. When you have a many to 1
relationship define (translated to left join in SQL) that actually works
out to more than one record in your object. The totals in powerlink
will show from these record, but they won't be exported.
If you run SQL monitor and paste the SQL into another program (ie I
Series Navigator Run SQL Scripts) you can see these extra records. If
a relationship is causing the problems then fix that. Also if you just
you the fields in your view from the primary object is your row count
correct?
Finally, I have an open incident for broadcast to a list view with
column totals that doesn't work right. If this is the case let me know
and I can work through it with you. My incident has been open since
March so I don't think support is ever going to fix it.
-Tom Stieger
Engineer
California Fine Wire
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Weston Wheat
Sent: Thursday, November 18, 2010 9:42 AM
To: mapics-l@xxxxxxxxxxxx
Subject: [MAPICS-L] Exporting data from PowerLink to Excel 2007
Hello All.
I have this weird problem. I cannot get a large record set of data to
export correctly into Excel
from powerlink.
It is leaving out records in the exported text file.
We are trying to export bookings data to Excel and the totals
are not matching up. Also the row count is off so we know that it is
skipping records.
I have up'ed on the Limit clipboard export to first K Chars, setting to
the max. But that didn't help.
Does anyone have any tricks that work? We are at R7.8 .
Thanks
And p..s. Please don't flood this tread with a bunch of Marketing for
Excel
linked financial type appl's.
_______________________________________________
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) 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.
midrange.com
