Preparing the Excel Spreadsheet

  1. Ensure all data is set out in excel including columns such as:
    - Account Name
    - Primary Address (Street, suburb, postcode, state)
    - Primary Phone Number
    - Contact Name
    - Rep/territory
    - Account Group

  2. Save Excel Spreadsheet.



Uploading Account to existing Account List

  1. Log into Perenso Administration.

  2. Click on System Config > Imports.
    The below screen will display with a list of previously imported file.

There are two ways to import accounts:

a) Importing accounts List using existing import rules.

b) Importing a New Accounts List

Note: If the account imports file is the same as a previous upload, you can choose to select the previous upload file form the list. This will enable the system to auto map fields accordingly.


Import using a previous Import 

  1. Select the Import Name from the list.
    This will then load the information inputted during the last upload.

  2. To select the file for Import, click Select File.

  3. Select the file you wish to import.

  4. If there is more then one sheet of data in you file, select the excel sheet from My data is on the following sheet.

  5. Select if your file has a heading or field names.

  6. Click Next to continue.

  7. Map the fields in the file to corresponding fields in Perenso.
    NOTE: The previous mapped fields will display and the option to update or map new fields are available.
    For a detailed guide to Field Mapping, read the article ''.

  8. To continue import, click Next.  

  9. Perenso Administrator will check the excel sheet to ensure there are no issues. If there are some issues, the system will warn users and the rows that are affected will be displayed in a table.
    Users can choose to update the spreadsheet with the correct data and upload the file again or to Add the changes directly from this screen.

  10. When there are no changes to be made, the sheet can be selected for imports. To import the file, click Next.
    A summary of the Import will display showing the number of lines that will be imported and the lines that will be ignored.

  11. Click Start Import.
    A confirmation message will display once the import has been completed.



Importing a new File

  1. In Import Type, select Account Imports.

  2. Select from the list of import types. e.g. excel, pdf, words.
    The import screen will display. A import description can be entered to describe the type of import. This description will be save for future imports.

  3. Select the file you wish to import.

  4. If there is more then one sheet of data in you file, select the excel sheet from My data is on the following sheet.

  5. Select if your file has a heading or field names.

  6. Click Next to continue.
    The Field Mapping page will display. This is where you can choose to map your spreadsheet data to the relevant fields.

  7. Once the fields have been mapped, click Next to continue

    Perenso Administrator will check the excel sheet to ensure there are no issues. If there are some issues, the system will warn users and the rows that are affected will be displayed in a table.
    Users can choose to update the spreadsheet with the correct data and upload the file again or to Add the changes directly from this screen.

  8. When there is no changes to be made, the sheet can be selected for imports. To import the file, click Next.
    A summary of the Import will display showing the number of lines that will be imported and the lines that will be ignored.

  9. Click Start Import.

A confirmation message will display once the import has been completed.

Accounts can now be viewed in Perenso Administration under Accounts.