Importing Data

Import Data

The Import function imports data from a .csv file into the FotoNotes portal. Data is imported into a template format set up in the portal. Once imported, data is converted into work orders or projects using that template format.

Importing Data

  1. Start by ensuring that your excel spreadsheet is a CSV file type
  2. Delete any rows that are not data (i.e. headers)
  3. Add two blank rows to the top of your spreadsheet
  4. To import data into the preset template you will need to have the field keys from that template.

There are two ways to do this:

  1. Export template data from the portal. See Export Data

         a. The first row will be the field name.

         b. The second row is the corresponding field key.

     2. You can also find the field keys by going to your template under Settings>Templates and selecting           your template. Under each field name will be a field key.

5. Now enter the field keys exactly as they appear in the template or export spreadsheet into the second row and corresponding data column. You can add the field name to the first row but it is not necessary

 

6. You can also add new data columns to your import file for Status, Priority, Assign User, Customer, Manager, and Due Date

     a. Status field key= status

     Data in the status column should be one of the statues you have set up in your template.

     You can find the statuses and their value (that will be entered into the data column of your import                spreadsheet) by going to Settings>Templates and selecting your template. Select Edit Template.             

     Your statuses will be listed under Manage Status Options. To obtain the Status value click edit next  to    the Status.

b. Priority field key = priority

Data in the priority column of your import file should be one of the following:

  • Critical
  • High
  • Medium
  • Low
  • None

c. Due Date field key= due_date

*All dates must be in a formats of yyyyMMdd (i.e. 20161231), MM/dd/yy, or yyyy-MM-dd

d. Assign User = assign_user

Data in the Assign User column of your import file should be the username from the FotoNotes portal.

e. Customer Username = customer

f. Manager Username = manager

7. Once the import spreadsheet is set up correctly (see Common Errors below before uploading) go to Admin>Import.

8. Choose what you would like to import and select the template. If your file contains invalid characters please check, "Remove invalid characters from your data". Choose a .csv file from your computer and click "Next".

Screen_Shot_2019-04-30_at_3.53.37_PM.png

9. An Import Summary will appear and show if there are any rows with errors. Rows with errors can not be imported so fix them in your file and upload it again. Once you don't have any errors, click on "Import Data". *If you have an error please see Common Errors below

Screen_Shot_2019-04-30_at_4.06.36_PM.png

10. While the import is in progress, it will show you the number of rows imported.

Screen_Shot_2019-04-30_at_4.07.13_PM.png

11. Once the import is complete you can click on the work under list of items created. You can either start a new import or "Close and view items".

Screen_Shot_2019-04-30_at_4.07.46_PM.png

Common Errors

If there are errors in the import spreadsheet an error message will be displayed. Common errors include incorrectly formatted data:

  • All dates must be formatted as yyyMMdd (i.e. 20161231), MM/dd/yy, or yyyy-MM-dd
  • All Boolean values must be input into the import spreadsheet as TRUE or FALSE
  • Money field should NOT include the $ sign.
Have more questions? Submit a request

Comments

Powered by Zendesk