Skip to main content
Import tasks
Search
Search e-Form RS Support Help and Support.

This article applies to:

  • Product: e-Form RS
  • Subject: Documents,tools

Import clients' form data to e-Form RS

You can import multiple copies of a form to a client or import a form to multiple clients. Make sure you have 2013 Microsoft Access Database Engine (32-bit) installed.
  1. Create an Import Task
  2. Select
    File
    , then
    Import Client Data From Spreadsheet
    .
  3. Select
    Create Task
    .
  4. Select an Import Type
  5. Select one of the following that describes how the Excel spreadsheet datafile you will import is organized:
    • Multiple copies of 1 form per Client
    • One Row per Client
    • One Sheet per Client
  6. Select
    Next
    .
  7. If you chose multiple copies, enter the number of copies, choose whether the worksheet contains a header row, then select
    OK
    .
  8. Choose A Tax Form
  9. Select
    Browse
     and select the location of your datafile.
    note
    1. The datafile path defaults to
      C:\Importfiles
       directory, but you can browse to a different location.
    2. The directory path is not case sensitive.
    3. An Excel spreadsheet file must be present in the directory.
  10. Select the form, then
    Next
    .
    tip
    You can enter the form name in the search box under Tax Form Description.
  11. Link Datafile to Client
  12. Select your Excel datafile and the client, then select
    Add
     to link them. Repeat this step for each client and datafile that need to be linked.
    note
    You can have multiple datafiles for multiple clients.
  13. If you need to unlink Excel datafiles and clients, select the linked datafiles and clients combination, then
    Remove
    .
  14. Select
    Next
    .
  15. Map data to forms
  16. Select the linked datafiles and clients combination from the list, then
    Map Data to Form
    .
    note
    You create only one map for each Import Task.
  17. Select a cell in the spreadsheet.
    The column that contains the selected cell is selected.
  18. Select a data entry field in the form.
    The data entry field of the form is linked to the selected spreadsheet column.
  19. Take the following steps if you want to test the linked data:
    1. Select
      Test Data
      .
      The data appears in the selected fields on the form.
    2. Select
      Coordinates
       to clear test data.
  20. Select
    Save Mapping
    .
  21. Enter a name for the form mapping, then select
    OK
    .
  22. Complete the mapping process for all the listed forms, then select
    Finish
    .
  23. Enter a name for the import task, then select
    OK
    .
tip
If you have problems with an import, check the Excel datafiles for the following:
  • Inconsistent data.
  • Data is in the same location in each datafile.
  • A datafile name must not contain any of the following 8 characters: pound sign, asterisk, at sign, quotes, forward slash, backward slash, comma, or period (# * @ " / \ , .).
  • A datafile must have no more than:
    • 256 columns
    • 65,536 rows
    • 80 characters in a cell
You can now run the import task, edit it, and delete it.

Related Content