Import Data into Cityworks

Bulk Import allows you to import large quantities of data into Cityworks.

TIP: If you want to update existing data, you can download the existing table data first, edit the data as needed, then import the updated file.

  1. From the General tab, click Bulk Import.

  1. Select the Table you are importing data to. The tables available for bulk import are:
  • Codes
  • Customer Accounts (see Import Customer Accounts for more information)
  • DescScores
  • Street Names
  • TV Observation Code Scores
  1. Click Browse, find the .csv file that you are importing the data from, and click Open.

NOTE: Depending on your browser, the name of this icon will vary.

NOTE: Only .csv files can be imported. Other file types will not be accepted.

  1. If desired, select Delete existing records before appending to delete existing records when you import the file.

IMPORTANT: If you select this option, you may want to save a record of your previous data. To do this, click Download Existing Records and save the old file under a different name before you import the new file.

  1. If for any reason you do not want to import the information, click Clear to clear all the information.
  2. Click Import.