Back

Document Assembly: Distribute a Unique File to Each Client

Contents

Introduction

Prepare Your Files for Upload

Use the Correct File Name Format

Create the Zipped (Compressed) File

Upload Your Files to the Tamarac FTP Site

Verify the Upload Was Successful

Add the Custom Files to a PDF Template

 

Introduction

With document assembly, you can bundle one or more client-specific documents with your PDF reports.

For example, let's say that you want to send a personalized quarterly newsletter to each of your clients in addition to a quarterly report and invoice. Instead of creating a complex mail procedure, you can simply upload a single zipped file of all your newsletters and each letter will be added to the correct client's PDF report.

The following are the steps in the document assembly workflow.

Prepare Your Files for Upload

By using an intelligent file naming convention that integrates with your internal file creation systems, Tamarac Reporting can identify where a file belongs and add it to the a PDF report for the correct client.

To ensure Tamarac Reporting routes the file to the appropriate client, you need to specify the account number in the file name. Tamarac Reporting uses to file name to determine where to add the file. By adding the client account number in the file name, Tamarac Reporting identifies the correct account and adds the files to the correct PDF report.

Use the Correct File Name Format

When you create your files, specify the following format: [prefix_][accountnumber][_suffix][file name extension].

Example: quarterly_newsletter_1234-5678_08162011.pdf

Create the Zipped (Compressed) File

After you've created your files and specified the correct file name format, right-click the folder where you saved your files, point to Send to, and then click Compressed (zipped) folder.

A new compressed folder is created in the same location. To rename it, right-click the folder, click Rename, and then type the new name.

Upload Your Files to the Tamarac FTP Site

Once you've prepared your files for upload, you upload them to Tamarac Reporting via the Tamarac FTP site. After you upload the files to the FTP site, they'll be available for use in Tamarac Reporting.

To upload your files, follow these steps:

  1. In the Address bar on your web browser, type sftp.tamaracinc.com and then press ENTER.

  2. Type your user name and password for the Tamarac FTP site and then click Login. If you do not have a password, contact Customer Support.

  3. Select the destination folder on the FTP server where you want to upload the file. The name of the folder will vary by client. For more information, contact Customer Support.

  4. Click Upload Files.

  5. In the Open dialog, browse to the ZIP file you want to upload and then click Open.

  6. Click OK to upload the file to the Tamarac FTP server. It may take up to an hour for this file to appear in Tamarac Reporting.

Verify the Upload Was Successful

After you upload the file to the Tamarac FTP site, follow these steps to verify the file upload was successful. Please note that it may take up to an hour for recently uploaded files to appear in Tamarac Reporting.

  1. On the Client Reporting menu, click Upload Custom Files. Your file should appear in the list. If it does not, the upload was not successful.

  2. Click Edit next to the file you uploaded.

  3. In the File name format box, specify the naming convention you used for the file name.

  1. Click Save.

Add the Custom Files to a PDF Template

Once you've uploaded your files, you can include them in the Custom section of your PDF template. For more information, see Add a Letter or Article as a Custom Section and PDF Custom Section.

To add custom files to the PDF report template, follow these steps:

  1. On the Client Reporting menu, click Templates.

  2. In the Select a template list, choose the PDF template you want to modify.  If you haven't created a PDF template, choose Create new template.

  3. In the Add a section list, click Custom and then click Add.

  4. In the Custom section, choose the compressed (zipped) file in the Choose a custom file as background list.

  5. Click Save.