How can we convert the csv file into pagelist in constellation?
Hi all, We are looking for solution where when we upload a CSV file and it should have to convert into page list.
In Theme cosmos we are using File Path and using the activity "pxUploadCSVResults". it will automatically convert CSV into page list but in Constellation the file path is missing is their any other approach?
In constellation we are using attachment field, we know the their is no action sets in constellation. That's why we can't fetch the data from CSV file.
You can see the attachment below that file is missing form the Source.
Accepted Solution
Updated: 1 Nov 2024 8:41 EDT
Infosys McCamish
IN
@Sai Nadh the activity you are referring "pxUploadCSVResults" trying to get the file from browser. if you are looking to access file from repository you can use D_pxGetFile data page which copies data from provided file path to property in base base64-encoded and then you can call the function to decode it Base64Decode() ( ref. below url)
https://support.pega.com/question/what-are-functions-used-convert-string-base64-activity
Pegasystems Inc.
GB
In Constellation, since the File Path control is missing and action sets are not available, you can use the following approach to convert a CSV file into a page list:
- Use the Attachment Field: Upload the CSV file using the attachment field.
- Custom Activity: Create a custom activity to handle the uploaded file. This activity should: - Retrieve the file from the attachment. - Read the CSV content. - Convert the CSV content into a page list.
- Invoke the Custom Activity: Ensure that this custom activity is invoked after the file is uploaded.
This approach allows you to handle the CSV file and convert it into a page list without relying on the File Path control or action sets in Constellation. Please ensure that the custom activity is thoroughly tested to handle various CSV formats and potential errors during file processing.
⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.
I'm not able to upload the Result set of the CSV excel file
Accepted Solution
Updated: 1 Nov 2024 8:41 EDT
Infosys McCamish
IN
@Sai Nadh the activity you are referring "pxUploadCSVResults" trying to get the file from browser. if you are looking to access file from repository you can use D_pxGetFile data page which copies data from provided file path to property in base base64-encoded and then you can call the function to decode it Base64Decode() ( ref. below url)
https://support.pega.com/question/what-are-functions-used-convert-string-base64-activity