Question
Accenture
IN
Last activity: 23 Sep 2024 9:58 EDT
Reading the TSV format attachment
Hi i have a requirement that users can attach either CSV or TSV format files, I want to read the TSV file format that is attached to the case by the user. In the next screen i need to display the contents of the TSV file in the table format and store the results in the data table.
***Edited by Moderator Rupashree S. to add Capability tags***
Pegasystems Inc.
GB
To achieve this requirement you can follow a similar approach to the one used for parsing Excel files and handling CSV files. Here is a step by step approach: 1. Upload the TSV File: Allow users to attach the TSV file to the case. 2. Read the TSV File: Use a backend processor to read the contents of the TSV file. You can create a custom activity to parse the TSV file. This activity can read the file line by line and split the contents based on the tab delimiter. 3. Display Contents in Table Format: On the next screen you can use a section to display the parsed contents in a table format. You can create a data page to hold the parsed data and reference this data page in the section to display the contents. 4. Store Results in Data Table: Once the contents are displayed you can provide an option to save the data to a database table. You can use an OOTB activity or a custom activity to insert the data into the database table. This approach ensures that the TSV file is read displayed and stored efficiently.
⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.
To achieve this requirement you can follow a similar approach to the one used for parsing Excel files and handling CSV files. Here is a step by step approach: 1. Upload the TSV File: Allow users to attach the TSV file to the case. 2. Read the TSV File: Use a backend processor to read the contents of the TSV file. You can create a custom activity to parse the TSV file. This activity can read the file line by line and split the contents based on the tab delimiter. 3. Display Contents in Table Format: On the next screen you can use a section to display the parsed contents in a table format. You can create a data page to hold the parsed data and reference this data page in the section to display the contents. 4. Store Results in Data Table: Once the contents are displayed you can provide an option to save the data to a database table. You can use an OOTB activity or a custom activity to insert the data into the database table. This approach ensures that the TSV file is read displayed and stored efficiently.
⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.
How to automatically attach a file to a work object?