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()
It should write row1 data into sap but its writing unprocessed data from input file.
Please help me.
Thanks & Regards,
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.
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.
@lakshmi.mp , As mentioned above could you Check the value in
list_array if it contains the processed data or the unprocessed data ?
@supermanPunch list_array contains the processed data.
On text file also its writing proper data but not writing on sap.
but not writing on sap.
@lakshmi.mp , What is the activity you are using to Write Data to SAP ?
set to clipboard and send hotkey ctrl+v.
June 8, 2022, 6:59am
Have you deleted the existing text and then copying?
send hotkey ctrl+v.
@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.
@Lak_Ui , yes using delete range, deleting the previous data but its taking the unprocessed data.
@lakshmi.mp , This should be fine. Maybe you could Debug as mentioned in the above post and Check the value being pasted manually ?
Again writing same unprocessed data.
Only first row data not writing properly its writing unprocessed, for rest of the rows its writing correctly.
Directly passing stringBuild.ToString() in set to clipboard, stringBuild.ToString() this contains the processed data.
Please provide solution.
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.
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.
@lakshmi.mp , Is the below Highlighted data the one that needs to be removed ?
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.
Processed data is correct, i removed and used new set to clipboard activity and executed same issue, from next row its taking properly.
@lakshmi.mp , Could you provide your workflow?