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

BI IP ---> Planning function for File Upload - 69 Records read

Hai All,

While uploading File upload , In my text file i am having 68 records, but it is showing 69 records, after successfully loading the data in to cube.

it is showing message reading as 69 record read, file is having only 68 records(is it taking headerline also)

File Upload: Encoding = DEFAULT

File Upload: Overwrite data = No

File Upload: Skip header line = No

File Upload: Convert fields = No

File Upload: Convert amounts = No

69 records read, 0 generated, 68 changed, 0 deleted

Changed Parameter as Overwrite Data as Delta mode

After sometime, removed 67 records and I Changed only one record (Changed Fiscal year / Period) and loaded only one record, while uploading the file its shows message as given below

File Upload: Encoding = DEFAULT

File Upload: Overwrite data = Delta

File Upload: Skip header line = No

File Upload: Convert fields = No

File Upload: Convert amounts = No

69 records read, 1 generated, 0 changed, 0 deleted

Why it is showing 69 Records Read , In my text file having only one record , but it is showing 69 records read.

Any one can help me out.

Thanks,

Bhima

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 21, 2007 at 03:50 PM

    Hi,

    1) do you have records with the same characteristics? If so these are aggregated

    2) did you implement the bug fix? If I'm not mistaken there was a similar issue mentioned on the blog of Marc Bernard

    D

    ...

    . After importing the transport request, please implement the following corrections:

    Class Interface ZCL_RSPLF_FILE_UPLOAD

    Method IF_RSPLFA_SRVTYPE_IMP_EXEC~EXECUTE

    DATA:

    l_data TYPE string,

    l_chavl_ext TYPE rschavlext, "insert

    l_chavl_int TYPE rschavl, "insert

    ...

    ASSERT sy-subrc = 0.

    • Convert field value only if necessary and use correct type

    IF NOT <f> IS INITIAL. "insert

    l_chavl_ext = <f>. "insert

    CALL FUNCTION 'RRSV_EX_IN_CONVERT'

    EXPORTING

    i_chavl_ext = l_chavl_ext "change

    i_convx = l_s_iobj_pro-convexit

    i_inttp = l_s_iobj_pro-inttp

    i_intlen = l_s_iobj_pro-intlen

    i_outputlen = l_s_iobj_pro-outputlen

    i_iobjnm = l_iobjnm

    IMPORTING

    e_chavl_int = l_chavl_int "change

    EXCEPTIONS

    no_input_given = 1

    input_not_numerical = 2

    conversion_not_supported = 3

    date_not_correct = 4

    time_not_correct = 5

    invalid_format = 6

    OTHERS = 7.

    IF sy-subrc = 0. "change

    <f> = l_chavl_int. "insert

    ELSE. "insert

    add_msg_error3 'Field conversion error. Field/Line:'(048) l_iobjnm l_len.

    l_subrc = 4.

    ENDIF.

    ENDIF. "insert

    ...

    • Merge loaded data

    TRY.

    l_len = 0.

    • LOOP AT <l_t_file> INTO <l_s_file>. "delete

    LOOP AT <l_t_file> ASSIGNING <l_s_file>. "insert

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2007 at 04:40 AM

    Hi.....make

    File Upload: Skip header line = YES

    Function will read the data based on filters. I think its fine.

    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.