Writing data from excel to sap application

Learning Initatives Automation Starter
1

Hi,

Trying to write the processed data into sap application, but its not fetching the processed data, its writing the unprocessed data into sap.

list_array= (From row1 in Generate_Dt.AsEnumerable() select convert.ToString(row1(0))).tolist()
image

It should write row1 data into sap but its writing unprocessed data from input file.
Please help me.

Thanks & Regards,
Lakshmi

2

Hi @lakshmi.mp ,

Could you explain what is meant by unprocessed data ?

Also, you could Check the value by using a Write Line Activity, to confirm if the list_array contains the required value.

3

Hi @supermanPunch ,

In sap able to write only 64 characters in one single the text field has 20 lines, the processed data stored in text file and same data stored into excel. Trying to copy excel data into sap but its taking the old excel data (unprocessed data).

Taking unprocessed data into sap.

Thnaks,
Lakshmi

4

@lakshmi.mp , As mentioned above could you Check the value in list_array if it contains the processed data or the unprocessed data ?

5

@supermanPunch list_array contains the processed data.
On text file also its writing proper data but not writing on sap.

Thanks,
Lakshmi

6

@lakshmi.mp , What is the activity you are using to Write Data to SAP ?

7

@supermanPunch
set to clipboard and send hotkey ctrl+v.
image

8

Have you deleted the existing text and then copying?

9

@lakshmi.mp , Could you show the Send Hotkey activity Properties as well ? Also, Try to use Debug upto the Set To Clipboard Activity and then perform the Paste(Ctrl+v) operation manually on SAP and Check if the data is the processed data.

10

@Lak_Ui , yes using delete range, deleting the previous data but its taking the unprocessed data.

11

@supermanPunch

image
image1242×643 53.1 KB

Please check.

12

@lakshmi.mp , This should be fine. Maybe you could Debug as mentioned in the above post and Check the value being pasted manually ?

13

@supermanPunch ,

Again writing same unprocessed data.

14

Hi,

Only first row data not writing properly its writing unprocessed, for rest of the rows its writing correctly.
image
Directly passing stringBuild.ToString() in set to clipboard, stringBuild.ToString() this contains the processed data.
Please provide solution.

Thanks,
Lakshmi

15

@lakshmi.mp ,

In that case, can we get a closer look at the Data present in the First line ? You could also provide the Unprocessed data and processed data in separate text files to analyse the data further.

16

@supermanPunch ,

row 1 data procesed and unprocessed data. SAP screen should write processed data but its writing unprocessed data from input excel only performing string operation for that particular row and not removing the date followed by characters. From next row its writing properly. Only issue with first row.

Thanks,
Lakshmi

17

@lakshmi.mp , Is the below Highlighted data the one that needs to be removed ?

image
image783×581 15.8 KB

In that case, your processed data looks alright, we would have to check your workflow if it contains any duplicate variables.

Also Try removing the Set to Clipboard activity and use a new Set to Clipboard Activity and try executing again.

18

Hi @supermanPunch,

Processed data is correct, i removed and used new set to clipboard activity and executed same issue, from next row its taking properly.

19

@lakshmi.mp , Could you provide your workflow?