topic Re: Error while uploading excel file in Application Development and Automation Discussions

Error while uploading excel file

Former Member — Wed, 11 Dec 2013 10:36:18 GMT

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

Re: Error while uploading excel file

Former Member — Wed, 11 Dec 2013 10:48:23 GMT

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.

Re: Error while uploading excel file

Jelena_Perfiljeva — Thu, 12 Dec 2013 03:32:35 GMT

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.

Re: Error while uploading excel file

JL23 — Thu, 12 Dec 2013 05:59:22 GMT

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 ?

Re: Error while uploading excel file

Former Member — Thu, 12 Dec 2013 06:37:34 GMT

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.

Re: Error while uploading excel file

Former Member — Fri, 13 Dec 2013 10:28:04 GMT

Issue Solved ... Thanks for reply

Re: Error while uploading excel file

JL23 — Fri, 13 Dec 2013 11:23:39 GMT

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.

Re: Error while uploading excel file

Former Member — Fri, 13 Dec 2013 11:48:26 GMT

hi,

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

Regards,

gopi

Re: Error while uploading excel file

Former Member — Wed, 18 Dec 2013 14:45:17 GMT

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