You are viewing limited content. For full access, please sign in.

Question

Workflow reading CSV file saved to repository limitation question....

Workflow Laserfiche Cloud

Updated August 5

asked on April 28

We have a workflow that reads a csv file saved to the repository, pattern matching on row, then runs a rule to import into our local SQL table.

We are running in the cloud

My two question are:

- When saving the file via a business process, the workflow does not sense any data in the file. If I manually save the file to the repository location, select generate text, the file is then ran in workflow. Is this expected behavior?

- When the file is processed, it consistently stops importing 59 lines of text, then 2 blank entries into SQL (total of 61 new entries into SQL table). Is there a limitation on how many rows/tokens can be used in the workflow?

thanks,

Brian

0 0

Replies

replied on August 5

There isn't enough information to troubleshoot, but it sounds like you are importing the CSV file as an electronic document and not extracting text from it while your workflow is expecting to find text.

So you'll want to look at how the file gets into the repository for that.

When importing CSV files as text (or extracting text from CSV files), line breaks are added if lines are too long and the text is broken into pages every 60 lines.

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked April 28
Updated August 5
97 views