Question
2
Replies
119
Views
Posted: December 23, 2020
Last activity: January 1, 2021
Solved
How to attach a excel file present in the service export directory to a work object?
How to attach an excel file present in the service export directory to a work object?
Accepted Solution
Posted: 3 months ago
Updated: 3 months ago
set the file location to pxProcess.pyFileUpload property.
Used Uploadfile() OOTB function to get the Base64 encoded stream of excel file. set this stream text to pyAttachStream.
Created Data-WorkAttach-File instance and then Link-Attachment instance to attach this file with WO.
As you mentioned that the excel is present in service export directory, means you can read it. Read the excel file from the export directory.
1.Create an activity. In the activity, do the following.
2.Create a page of Data-WorkAttach-File class context.
3.Then encode the excel data stream into Base64.
4.copy the encoded value to pyAttachStream property under page step created in step 2
5. save the changes to WO.