Importing Users

Follow

 

To import users, you'll need to create an import file with the same format as the sample file below:
Click here to download the sample import file (Excel)

 

The document linked above has 2 tabs.  One tab is the actual template to be utilized for the people that you want to import or update.  The other tab contains the validation guidelines for the various fields in the template.  

 

Once you have your file ready, please put in a support request to have the file imported for you. If they are existing users, use the FSP People GUID and user profile will be updated with any new contact information.

 

Please note the following:

  • All columns you see in the template must be included in your import file and must be in the proper order. For the non-required fields, you need the column present and in order, however you do not need to import values for non-required fields.
  • All Required fields must have import values for each user, or the user will not be created.  Fields required to create people can be found in the 'Required to Create People' column of the import document linked to above.
  • Some fields allow you to populate fields that must be set up in settings before hand (Role, Location, Default Location, Add to Group).  For these items, the objects must be set up in Flight Schedule Pro already and the values submitted in the import template must match the existing object exactly.

If you want to import addresses with your users, you'll need to match the format of your addresses to our address tables format. To see the proper formats, here is an Excel sheet you can download (please note there are multiple sheets on this file). Address Formats

Please note the following:
Country column must use country codes found in the Address Formats excel sheet above. If the country code does not match, NONE of the address will be imported
The states, provinces, and counties must match values in the excel sheet above. If they do not match perfectly, this information will not be imported.

 

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.