PortalProdigy - The Complete Internet Interaction Management System for Small Business and NonProfits
Load a Bulk List of LRCA Contacts

Load a Bulk List of LRCA Contacts

 

  1. Read the Chapter titled “Legislative & Regulatory Call to Action (LRCA) Feature in Detail” in the Administration Manual.

 

  1. Read the Chapter titled “Contacts, Members, Vendors & Companies Feature in Detail ”  in the Administration Manual.

 

  1. Read chapter titled “Import Data Features in Detail” in the Administration Manual.

 

  1. Create a CSV file using Microsoft Excel Spreadsheet application containing LRCA Contact information in the following columns: First Name , Last Name , Title , CompanyName , Company Address1 , Company City , Company State , Company Zip , Company Phone , Company Fax  , Company E-mail , LRCA Branch  , LRCA Level , LRCA  State.

 

    1. The spreadsheet must be saved in comma delimited file format for import in a later step..
    2. Portal Prodigy accepts most standard phone formats and will convert them to 999.999.9999 format.  Phone Extensions should be placed in separate field (column).
    3. States must be in two letter abbreviated format, such as “CA” for “California”.   Note that when State is not included as field in import, the default State specified in User Signup Features Management is assigned.
    4. Country must be in three letter abbreviated format, such as “USA” for “United States of America”.  Note that when Country is not included as field in import, the default Country specified in User Signup Features Management is assigned.
    5. Individual contacts are entered into concurrent rows in the spread sheet

 

  1. Click on the Utilities icon on the Site Administration Menu

 

  1. Click on the Import Contact Data icon on the Utilities page

 

  1. Click on the Add New button.

 

  1. Enter a Profile Name.

 

  1. Click the Browse button and import the CSV file created during earlier step.

 

  1. If the imported CSV file contains field (column) labels in the first row, check ‘Ignore first row which contains column headings’.  This checkbox is located to the right of the ‘Values Included’ section heading.

 

  1. For each field (column) in the imported CSV file, enter the column number in the text box of the corresponding field name on the Import Contacts Data Management page.  A zero or blank (no number) indicates that the field is not in your CSV file.

 

  1. Check all fields that should have their existing value replaced by the imported value. Empty fields in existing media contacts records will always be updated with the imported value.  If the LRCA contact is new all of the fields will be imported when the new contact record is created.

 

  1. If applicable, check one or more Special Interest Groups.

 

  1. Check desired Security Types.

 

  1. Click the Save button to save the import profile.

 

  1. Click the Import button to perform the import.

 

  1. When import has finished it will display the total number of rows that were successfully imported and it will list by row number each row that could not be imported and reason why. 

 

  1. Click Close button to return to the Utilities Menu.