Auto-Import Desks and Assets with CSV

How to Auto-Import with CSV

StaffMap can auto-import Desks and Assets with a CSV file placed in the project directory.

  1. Generate an API key. Sign in as an admin, then go Tools > Project > Project Settings and click create in the API Key field.

2. Generate a fieldmap URL. You can do this by initiating a manual desk or asset import. When the import completes, the fieldmap URL will be visible in your browsers URL bar. Edit the fieldmap to ensure that the API key generated in step 1 is included in the URL (bolded below).

e.g.

Assets:

http:/mysite.com/staffmap4/MyProject/#import_assetcsv_orPOjea9bC8BbyKeYw_{%22key%22:%22asset_id%22,%22name%22:%22name%22,%22category%22:%22category%22,%22make%22:%22make%22,%22model%22:%22model%22} 

Desks:

http://mysite.com/staffmap4/MyProject/#import_deskcsv_orPOjea9bC8BbyKeYw_{%22key%22:%22desk_id%22,%22deskname%22:%22deskname%22,%22category%22:%22category%22,%22seats%22:%22seats%22,%22bookable%22:%22bookable%22,%22phone%22:%22phone%22,%22window%22:%22window%22,%22computer%22:%22computer%22,%22monitor%22:%22monitor%22,%22printer%22:%22printer%22,%22ethernet%20jack%22:%22ethernet%20jack%22} 


3. For assets, create or rename a CSV file called importassets.csv containing your data. For desks, create or rename a CSV file called importdesks.csv, Ensure the column headings exactly match the originally imported CSV.

4. Write either CSV file to the {project}\import folder.

e.g. C:\Program Files (x86)\StaffMap 4\YourProject\import.

5. Open the fieldmap URL in a browser to initiate the CSV import.