Guidelines for bulk import of FirmFlow folders

General guidelines

The bulk import process requires data values to exactly match the existing data in GoFileRoom. For example, if a PIC user name in GoFileRoom is "David Warner," then a value of "Dave Warner" will cause the folder to be rejected.
Use the Copy and Paste Windows functions to ensure that the values in the Microsoft Excel spreadsheet (XLSX) are identical to the GoFileRoom values (Ctrl + C and Ctrl + V).
If the spreadsheet is a data dump, copy all cells with data in your spreadsheet and paste them into a new spreadsheet to make sure that no binary data is included.
Make sure that your checklists are finalized prior to importing FirmFlow folders. We aren't able to append the checklists after import.

Data import guidelines

Client number (required)

The Client Number must exist in the client Lookup list.
Don't use formulas to calculate the Client Number (for example, "Client Number & "." & Client Engagement).

Workflow Description (required)

A description of the workflow within the folder (free form text).

Type of Engagement (required)

Specify a Type of Engagement (File Section index value) that's already configured in GoFileRoom.

PIC

The PIC field must exactly match the full name of a GoFileRoom user that belongs to the PIC group (for example, "David Warner," not the email address). The PIC user also needs to be part of the PIC group in GoFileRoom.

Period End (required)

Make sure the Period End (Year End) cells aren't formatted as date fields. Enter the Period End values as a five character text field: "MM/DD". Change the cell to text format before entering the values.

Year (required)

Enter the Year as a four digit number (for example, 2019).

Form

The Form field is optional. You can leave the Form and Due Date blank to create a folder that contains no Forms.
Values of forms must exactly match values in the FirmFlow Deliverables list. Use the Windows Copy and Paste function to ensure exact spelling.
If the deliverable you need isn't in the FirmFlow list, you can create it prior to running the bulk import process.
To add multiple deliverables to the workflow, create an additional row for each form in the spreadsheet with identical field values except for the Form and Due Date information.

Due Date

This field is required if a form is specified. The Due Date field needs to be in a full date format (for example, 4/15/2019).

Workflow Steps

Create a column header for each workflow step you have defined in FirmFlow (for example, Folder Setup, Preparation, Scanning, etc). The number of columns must exactly match the number of workflow steps.
The user names assigned to the steps must exactly match the GoFileRoom full user names (not email addresses). Use the Copy & Paste function from the GoFileRoom Manage Users & Groups Administration screen to ensure that the spelling is accurate. These users must also be members of the FirmFlow User group.

Custom Fields

Date Fields
: Values must follow a mm/dd/yyyy format.
Dropdown fields
: Values must be exactly as specified in the list.
User List fields
: Values must match the user name (not email address) as defined in the User Administration screen.
Test fields
: This field will accept any valid text value.