AS/400 to Excel data transfer – extra

80 pts.
Tags:
AS/400
Microsoft Excel
We are using Excel Com Add in on 2010 and 2013 and this is causing intermittent adding of a ZERO to some numeric data we are downloading from AS/400. We are not sure if this is an AS/400 issue (OS v6.1) and Client Access v5.8 upwards? Any ideas what might be causing this?

Software/Hardware used:
AS400, Excel 2010 or 2013

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 11  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • azohawk
    This sounds familiar to me, but I am coming up just shy of recalling this. Is it adding leading or trailing 0s? Is the data field on the i a text or numeric (packed? maybe) data type? Is the zero being added to the same field in all records?
    395 pointsBadges:
    report
  • TekViperMM

    azohawk - it seems to add a "zero" however when you download the data a second time it disappears - very random?

    80 pointsBadges:
    report
  • TekViperMM
    Azohawk - just re-read your response the data field from the "i" series is a numeric field!!
    80 pointsBadges:
    report
  • azohawk

    doesn't sound like the issue we had; but it has been a while. Sorry.

    I think the issue we had was numeric data in an apha field and the transfer was trying to make into a numeric field and adding trailing zeros or something like that.

     

    395 pointsBadges:
    report
  • TekViperMM

    I thought the user had formatted the Excel and then imported the data, but it happens on a blank spreadsheet.

    I then thought maybe the programmer had "written" the data to the file different to other programmers but not sure that's true either!


    THANKS for replying anyway :-)

    80 pointsBadges:
    report
  • WoodEngineer
    What are the field definitions of the successful and unsuccessful exports?  Could it have anything to do with the field defined with an even number of digits, such as 6,2?
    6,365 pointsBadges:
    report
  • TekViperMM

    WoodEngineer - thanks for your response, does this matter if it looks okay on the AS400 (viewing through WRKQRY and DSPPFM) .

    From a download point of view using the COM add-in = we are not changing the download at all


    80 pointsBadges:
    report
  • WoodEngineer
    You are correct, it should not matter.  I was just throwing out an idea as a possible cause.
    6,365 pointsBadges:
    report
  • TekViperMM
    There is no way the "Client Access" version is incompatible or requires to be a certain version working with OS v6.1?
    80 pointsBadges:
    report
  • ToddN2000

    How is the field defied in the DDS on the I-series? If no DDS was this created via SQL?

    You also mentioned that on a second attempt it worked. I am curious if it always works on a second attempt? It may have something to do with the FDF that gets created as part of the transfer process.

    8,800 pointsBadges:
    report
  • TekViperMM

    ToddN2000 thanks for your reply

    The data that has been tested has been from a program output to a PF, we have downloaded this using the Excel COM add-in. We don't make any adjustments when downloading "direct" from Excel so don't know if the FDF is even created

    The other weird issue it has never been a problem on my machine, the difference is I use WRKQRY a lot.

    We have investigated different combinations of Excel and Client Access versions to ensure latest updates\incompatibilities.

    Not sure what is happening - just thought that maybe when a programmer "writes" to a file maybe there is something subtly different they can \ need to change!?

    80 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following