Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Error in LSMW

Former Member

‎2009 Dec 17 7:04 AM

0 Likes
3,192

Hi! Good day!

I am currently using standard/direct input LSMW for uploading data. When I reached the step for Create Batch Input Session, I can not proceed because of the error I am encountering stating that "Source file could not be read/found". What could possibly be missing in my source file?

Thank you.

Hi! Good day!

I am currently using standard/direct input LSMW for uploading data. When I reached the step for Create Batch Input Session, I can not proceed because of the error I am encountering stating that "Source file could not be read/found". What could possibly be missing in my source file?

Thank you.

Reply
8 REPLIES 8
Read only

Former Member

‎2009 Dec 17 7:08 AM

0 Likes
2,130

Hi

Check with step Specify Files while creating LSMW.

Regards

Srilaxmi

Read only

Former Member
In response to Former Member

‎2009 Dec 17 7:14 AM

0 Likes
2,130

I have attached the source file properly in the specify files step. What could possibly be missing?

Read only

Former Member
In response to Former Member

‎2009 Dec 17 7:39 AM

0 Likes
2,130

hi

Keep ur file on Desktop than try to attach that file in specify files...

make sure u are converted Excel(in Excel convert format cells to text) to Text File and delete first line in the text file than u cal the text file...

Regards

smitha

Read only

Former Member
In response to Former Member

‎2009 Dec 17 8:07 AM

0 Likes
2,130

Hi Smitha!

Yes. I saved my file in the desktop and convert it to text file. But then, this was the result.

Read only

Former Member
In response to Former Member

‎2009 Dec 17 8:29 AM

0 Likes
2,130

hi

have u converted ur Excel file to Text tab Delimited?

and also u have to delete first line in the text file...

ur file should begin with field names only.....

make sure u have not opend Text file while uploading....

Edited by: Smitha KB on Dec 17, 2009 9:32 AM

Read only

VivekG
Participant

‎2009 Dec 17 8:17 AM

0 Likes
2,130

Hi Marlo,

In the specify fie tab of LSMW, check the file format if its TB delimited or some thing else and accordingly save ur file on desktop. I guess as the file format that u are specifying the LSMW is not getting that format of file on desk top or vive versa.

Hope it helps

Vivek Gupta

Read only

Former Member

‎2009 Dec 17 8:23 AM

0 Likes
2,130

Hi,

Following things need to be taken care of while specifying file for LSMW.

1) Either all fields in the file should be in the same order as it is in the Source Structure ( defined in step 2 and 3 of LSMW ). IF not then the source field names should appear in the first row. Tick the check box accordingly in the Specify File Step of LSMW.

2) Do not use the excel file directly. Save it as text ( tab delimited ) and then use it.

3) When batch/direct input method is used, many structures ( linked to each other ) are used. In that create separate fie for each source structure and keep some common field in each of the source structure so that the data is linked properly.

E.g If the LSMW is used to load purchase order data, then 3 structures may come into picture viz. Header data, Line item data and Schedule line data. We can keep Order Number field common in all the three files so that the for each Order Number correct Line item data and Schedule line data is picked.

Regards,

Bhavesh.

Read only

Former Member
In response to Former Member

‎2009 Dec 17 8:30 AM

0 Likes
2,130

1) Check you have specified correct File in the LSMW

2) Make sure the file exists in the correct path

3) Check the file is not opened