Guidelines for bulk import of FirmFlow folders
Follow these guidelines when using the Bulk Import feature in GoFileRoom.
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
Follow these guidelines for adding data to a spreadsheet.
important
- The bulk import or bulk update processes only permit the upload of FirmFlow import files in the Microsoft Excel XLSX format. XLS is not supported. XLS files can be saved in the newer XLSX format from within Excel.
- The following fields are required: Client Number, Workflow Description, Type of Engagement, Period End, and Year.
- The bulk import or bulk update process requires all 5 fields to be populated, including the Period End and Year fields.
- These fields are required for bulk import process, regardless of the Drawer index requirements configured by your firm. This is a safeguard to avoid situations that may require several manual updates, post importing, and assures proper document indexing. If your firm’s unique Drawer configuration doesn't require the Period End and Year index, it's possible to Create a New Folder from within the GoFileRoom user interface.
- 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.
Related Content
-
Import FirmFlow folders
Format:
Article,
2 min read
-
Bulk update a FirmFlow folder
Format:
Article,
3 min read
-
Create a bulk import spreadsheet with FirmFlow
Format:
Article,
1 min read
-
Import a checklist from an Excel file
Format:
Article
-
Troubleshoot FirmFlow folder import errors
Format:
Article,
8 min read
Related Content
-
Import FirmFlow folders
Format:
Article,
2 min read
-
Bulk update a FirmFlow folder
Format:
Article,
3 min read
-
Create a bulk import spreadsheet with FirmFlow
Format:
Article,
1 min read
-
Import a checklist from an Excel file
Format:
Article
-
Troubleshoot FirmFlow folder import errors
Format:
Article,
8 min read