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

Question

Question

Merge Tif Images with Workflow

asked on January 22, 2016

OK, so we would like to create a tax packet for our employees and email them out. We have a few different scans. Each has the same template with a unique field identifier. We would like to have all documents with the same identifier merged into one packet.

 

Example, W2 from Payroll provider 1, W2 from payroll provider 2, 1095 form. Each employee can have up to 3 different documents, some may only have 1.

All documents have been ran through Quickfields and assigned the Tax Documents Template that includes SSN, EMP ID, First Name, Last Name, Email Address

I want all documents with the field that states EMP ID "XXXXX", merge all documents into packet that is names "First Name" "Last Name" - 2015 Tax Documents

 

What is the best way to  do this?

 

0 0

Replies

replied on January 22, 2016

You could search for all documents with the same identifier and then use the Move Page activity to merge them.

You could either create a new doc and move all pages into it or pick on of the existing docs and append pages from the other docs.

0 0
replied on January 22, 2016

Without knowing about your infrastructure and what resources you have available it is kind of difficult to respond in detail.  I am going to assume that you want to use Workflow to do this as opposed to manually searching for and creating new documents in the client?

If so, a couple of thoughts in addition to Miruna's feedback;

I would assume that you want to create a 'tax packet' for each employee, therefore you will need a way to step though a list of employees, grab their EmpID, then do a specific search for matching documents that Miruna suggests and merge or append the appropriate pages.  In order to step through a list of employees the easiest way would be to do a lookup into SQL where those records hopefully exist.  You would use the workflow Query Data or Custom Query activities to do that lookup then step though the resulting recordset, get the specific EmpID, search for all documents where 'EMP ID' = EmpID, step though all of those returned documents and append/merge per Miruna's feedback.

My guess is that you will also need to add some type of search criteria in addition to the EmpID to only pull back tax documents from the appropriate year (2015).

In addition I would assume that you would want the merged pages in some type of order?  ie the W-2's first then the 1095's so you might have to do a couple of searches for each employee.  The first returning the W-2's and the second returning the 1095. 

Finally, I am not sure that I would email the tax packets unless you make allowances to protect any sensitive information contained in the documents (SSN's etc).

 

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

Sign in to reply to this post.