Skip to Content
author's profile photo Former Member
Former Member

Flat File Load Problem

Hi All,

Has anyone come across where flat file uploads cuts out the last 1 or 2 columns from the upload.

This happens in the preview and in the actual load.

The data separators(,) and the Escape sign (") are OK

This are sample lines below:

"60 ","105906 ","A","253215 ","2005052700000000","516007 ",".TonyA ","1.17 ","0.20 ","2005050600000000","7 ","1 "

"102 ","42577 ","A","560194 ","2005070400000000","825293 ","A.HARCOURT ","23.95 ","4.19 ","2005062300000000","8 ","56 "

"149 ","103179 ","A","254010 ","2005020900000000","208864 ","Paul Glew ","2.16 ","0.38 ","2004121300000000","9 ","1 "

It only loads up to the column with 0.20,4.19,0.38 and cuts it out from the date onwards (3 last columns).

Anybody seen this???

Add a comment
10|10000 characters needed characters exceeded

Related questions

9 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 26, 2005 at 09:45 AM

    Hi Guys,

    I really don't have much of a leeway in manipulating the file for upload. It is generated by a legacy system and the upload will be automated.

    However, I am using a subset of the data for testing which I have been changing to troubleshoot the errors. What confuses me in this situation is that I have similar data structures with the same spaces, date formats etc. that is working. To answer your questions:

    In the preview the data is displayed OK and first date in the line is displayed without the suffix zeros up to the last 3 columns which is blank completely, the following column shows 4 zeros and the last column is blank as well.

    I have tested the data by physically removing the last 3 columns from the file. When I preview that it also gives me zeros in the 2nd last column even though there is no data to be read.

    I have also tested it by removing unwanted spaces and it did not make a difference.

    I have also tested via a logical path as well as pc file.

    I am thinking other ways to test this......any ideas still......

    K

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 25, 2005 at 04:41 PM

    My best guess is that your transfer structure does not have those last 3 columns.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 25, 2005 at 04:48 PM

    It has!!

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 26, 2005 at 04:05 AM

    Hi Koffi,

    Remove the trailing zeroes from the date field. The date should be 20050506, 20050623, 20041213 in all the 3 rows. Retry the load and let us know.

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 26, 2005 at 08:44 AM

    Hi Dinesh,

    I have done that already and it has not made a difference. However the preceding date on the same load comes through OK and I have other structures with the same date format that are OK.

    I am suspecting a bug?? What do you think??

    K.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 26, 2005 at 08:57 AM

    Hi Koffi,

    It should not be a bug I think. You tend to face strange problems with flatfiles. Did you try the preview option in the infopackage. If so, were all the data in the correct columns.

    You can remove the " from the file and also the unwanted spaces.

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 26, 2005 at 09:46 AM

    Hi,

    Shooting in Dark -

    60 ","105906 ","A","253215 ","2005052700000000","516007 ",".TonyA ","1.17 ","0.20 " -- It loads upto here only & Not This --,"2005050600000000","7 ","1 "

    >> Are you sure whole thing is signle line & there is no break after "0.20"

    >>try using ; as escape sign

    hope it helps

    Regards

    Vikash

    PS- Dinesh please check your gmail & let me know if you could help?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 26, 2005 at 03:55 PM

    Yes, It's just a coincidence that it wrapped at that point in the forum. I have already checked that as well.

    I am still trying other options. If anything works I will inform you all cos this is really a strange one!!

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2005 at 10:08 AM

    Hi Koffy,

    check the settings for:

    -Sep for Thousands

    -Char used for Dec Point

    -Curr Conv for Ext Sys

    /manfred

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.