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

Question

Question

Update Word Document - Merge is Truncating One Column

Workflow Version 10
Updated March 8, 2022
asked on February 25, 2022

So I have a WF that runs a query in Laserfiche and creates a .csv report. That is working fine. The output is great! From there, I query for the .csv file and merge it with the Update Word Document.

Here's my issue, when merging, it truncates ASLReportColumn5. As you can see below, my PDF output on the left truncates the data from the .csv input source. I have a lot of data going into other columns and do not have any issue. Don't know why it's happening.

This report actually has just under 100 rows but I'm providing the one row that's giving me a problem. BTW, I did a manual merge usng the .csv file with the merge file (removed the merge for reference info on the bottom of page 1) and it worked beautifully. So the issue is the "Update Word Document" in Laserfiche Workflow.

The attached file is actually a zip file (rename .doc to .zip after saving). Once unzipped, there are three files:

Approved Suppliers List for PDF.csv - Input File
Approved Suppliers List (ASL).dotx - Merge File for "Update Word Document"
Approved Suppliers List (PDF) Printed on 2022-02-25.pdf - My Output

Any help here would be greatly appreciated.

ASL Files.doc (382.82 KB)
0 0

Answer

SELECTED ANSWER
replied on March 8, 2022 • Show version history

Tried the Custom Data Query. No luck, same problem where the data truncated for my Column 5. I now populate a SQL table with the exact data and use the Query Data tool to retrieve the same data that was in the CSV file. The Query Data tool seems to like my table better than it liked my CSV file. Success!

0 0

Replies

replied on March 2, 2022

UPDATE! It is not the "Update Word Document" activity that is the problem ... it is the "Query Data" activity. I ran the following test:

Added a "track token" activity before running the query for the .csv file:

After the query, updated the value of Column 5 and tracked the new value:

I have submitted this as an issue to our Laserfiche vendor to review and escalate, if necessary. In the meantime, I'm going to try to create a Custom Data Query to see if that'll query properly.

0 0
SELECTED ANSWER
replied on March 8, 2022 • Show version history

Tried the Custom Data Query. No luck, same problem where the data truncated for my Column 5. I now populate a SQL table with the exact data and use the Query Data tool to retrieve the same data that was in the CSV file. The Query Data tool seems to like my table better than it liked my CSV file. Success!

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Attachments
Related Posts
Loading ...