This feature is only available for PRO Connect Subscribers
SignsearchPRO support services will import your existing client, location, and project data into PRO. First some background information:
PRO is built upon a hierarchy of Client > Locations > Projects. Your client must have one or more physical locations, and each location can have an unlimited number of projects.
You may provide us with your data in either Excel or CSV format. Your data can be provided in one of the following options:
- A single CSV or spreadsheet file with one row per project. That file would have columns for client, location and project data. See Sample_A_Import_Client_Location_Project.xlsx attachment below (Column order must remain unchanged).
- Separate spreadsheets (or separate sheets within a single spreadsheet) or CSV files for your client, locations, and projects. See Sample_B_Import_Client_Location_Project.xlsx attachment below (Column order must remain unchanged).
Available fields for import, with required fields noted in bold and by *:
Clients
client name *
client id (your internal unique identifier for your client)
address
city
state
country
postal
phone
fax
contactFirstName
contactLastName
contactPhone
contactMobilePhone
contactEmail
website
notes
active (Y/N) *
timezone
Locations
location name *
location id (your internal unique identifier for this location)
location number (an allowance for an internal "friendly" location identifier unique to this client)
address *
city *
state *
country *
postal *
phone *
fax
contactFirstName
contactLastName
contactPhone
contactMobilePhone
contactEmail
website
notes
active (Y/N) *
timezone
Projects
project name *
project id (your internal unique identifier for this project)
projectNumber (an allowance for an internal "friendly" project identifier unique to this client)
projectType (if provided, valid values are: install, manufacture, permit, service, survey, other)
status (if provided, valid values are: pending, out for bid, awarded, complete, cancelled)
projectbudget
startDate
endDate
description
siteGenVendor
siteGenContactFirst
siteGenContactLast
siteGenPhone
siteGenMobilePhone
siteGenEmail
siteGenTimeZone
(Please contact us if you'd like us to import sign vendor specific project information)
Comments
0 comments
Article is closed for comments.