Error while uploading excel file

[Former Member]

Hi All,

Below are error i am facing while uploading excel file.

Please suggest what changes needs to do in excel file(attached) to correct errors.

Many Thanks

[Former Member]

Hi,

this is the formatting error, can you check the user profile to pass the value into SAP.

you can format the quantity field in excel as text.

[Jelena_Perfiljeva]

Highlighted message is actually not relevant, it's a generic message that appears in many BDC programs (Google it). I believe you might actually be missing the "next message" in the log. Try processing the session manually and see what the error is.

Thousand/decimal separator format is a common issue with Excel uploads, but I'm not sure it's the case here.

[JL23]

can you explain in more detail about your upload process.

do you load directly from Excel, or do you first ssave your Excel as a txt or csv file?

Looking at your excel I see actually  a kind of header in line 1 and 2,

and items in line 4,5,6, and 7.

If cell B2 is loaded into BSEG-WRBTR, then you actually loaded a date into a value field

How do you differentiate header information from item information, I usually use a H and I in column A do it.

How do you link Header with Items? I do not see any common identification?

Okay in this example it might be easy and obvious, but what if you had 2000 postings, 2000 headers with 6000 items ?

[Former Member]

hi ,

          can u post your code. how u uploading your file through bdc or gui_upload fm.before upload the file u want to fix the column width for the each and every field in format cells and also want to keep it has a text.finally convert that file in csv (comma delimited) format.

regards,

gopi.

[Former Member]

Issue Solved ... Thanks for reply

[JL23]

If you solved it yourself then you should explain it here, so that future readers of this discussion - who obviously searched for a solution as they have the same issue - could get an idea what the root cause was and how it was solved.

[Former Member]

hi,

       tell how u solve the issue may be it useful for freshers who learning in future.

Regards,

gopi

[Former Member]

The issue is in uploading file, it is not as per prescribed in the program also it miss sequence of fields..

Issue from Functional End.... altought from debgging i trace out.....

Thanks for your support