If I open my CSV file in notepad I see the following text
However if I retreive the text in workflow, it looks like this, with no commas in sight, the critical delimiter we use to separate data
What does it look like in the text view in the web or Windows client?
The text viewer does not show up in Cloud any longer. It used to be called Switch View
But I can see the text in the tokens tab and I posted a screenshot of it showing all the commas missing.
This was downloaded from Custom Reports as a CSV and when I open in Notepad it is has commas.
Workflow does not reformat the text. If you can, look at the text pages with a desktop client. If you don't have a desktop client available, export the document as a briefcase, including the electronic component and text pages, and open a case with Tech Support.
I followed up on the existing case, this is part of a larger project where we need to get the data from the business process history back into the repository. The only way the 2 connect is through comma delimited data reports.
I can reproduce this issue. It's a bug in text extraction in the web client. Reference ID #408863. We don't currently have an ETA for a fix.
What does your workflow do with this text file?
I need to match metadata from forms submissions up with the documents manually restored after a disaster event.
I have the documents restored into the repository, but the template, fields, path, and file name are all missing. There is a total of around 200 data points that need to be restored.
The only way I know to get data from BP to Repo is to create a custom report and download as a CSV, then for each new line I can split on comma to apply all the data to each entry.
Why not import the CSV into a lookup table and query that? It would be more efficient since the data would already be split for you, you wouldn't have to read the text file page by page and row by row and do the splitting yourself.
Oh of course, I will do that! Thanks!