Sites Property Import Fields

Part of successfully importing items/objects into PSA is the PSA Microsoft Excel Import template (in .xlsx), which contains the necessary predefined tabs which allow you to specify the item/object properties to import.

Click here to view the article detailing how to import items/objects using Excel.

PSA Microsoft Excel Import Template: Sites sheet

This article is designed to facilitate the smooth import of sites into PSA using the Excel Import Template (.xlsx). It outlines the available fields, offering administrators concise descriptions to populate their Excel templates effectively. This resource aims to simplify the process, ensuring seamless site imports.

Let us delve into the key fields and empower you to efficiently transfer your site data into PSA.

Caution: Please be advised that it is recommended to fill all fields, even if no changes are intended. Leaving fields blank may result in some values reverting to their default settings.

Site Property Import Fields Definitions
Tenrox_Excel_Process_Status Import status (populated by the system after the site import is processed)
UniqueId - Upon Creation: The Unique ID of a new Site is automatically populated by the system once the creation process is completed.
- Upon Update: The Unique ID of Sites being updated must be entered by you, ensuring it matches the one initially generated by the system during the initial import. For further details on how to extract this Unique ID refer to Create a Report to View Unique Ids.
Note: Do not edit this column if you are creating a new Site using Excel Import.
Name * Defines the Name of the Site (required field)
Site_Parent_Name Defines the Name of the Site under which a new site is created/Site being modified or moved
Id Defines the Site ID
Language Defines the Language of the Site. Possible value:
E (English)
F (French)
Timezone_In_Seconds Timezone in GMT
60 1 minute
3600 1 hour
32400 9 hours
Example: 3600 = GMT +1, -3600 = GMT -1
Tax_Group_Name Defines the Name of the Tax Group that applies to the site
Holiday_Name Defines the Name of the Holiday associated to the site.
Site_Administrator_Logon_Name Defines the Logon name of the Site administrator.
Site_Administrator_Last_Name Defines the Last name of the Site administrator.
Site_Administrator_First_Name Defines the First name of the Site administrator.
Site_Alternate_Contact_Logon_Name Defines the Logon name of the Alternate contact.
Site_Alternate_Contact_Last_Name Defines the Last name of the Alternate contact.
Site_Alternate_Contact_First_Name Defines the First name of the Alternate contact.
Address1 Defines the first line of the site's Address.
Address2 This is the second line of the site's Address.
Telephone Defines the site's Telephone.
Fax Defines the site's Fax.
Is_Placeholder Defines whether or not the site is a placeholder
Note: Enter 1/0 for Yes/No.
Is_Suspended Defines whether or not the site is suspended
Note: Enter 1/0 for Yes/No.
Description Description of the site.
City Defines the site's City.
State_Code Defines the site's State Code.

AL Alabama
AK Alaska
AZ Arizona
AR Arkansas
CA California
CO Colorado
CT Connecticut
DE Delaware
DC District Of Columbia
FL Florida
GA Georgia
HI Hawaii
ID Idaho
IL Illinois
IN Indiana
IA Iowa
KS Kansas
KY Kentucky
LA Louisiana
ME Maine
MD Maryland
MA Massachusetts
MI Michigan
MN Minnesota
MS Mississippi
MO Missouri
MT Montana
NE Nebraska
NV Nevada
NH New Hampshire
NJ New Jersey
NM New Mexico
NY New York
NC North Carolina
ND North Dakota
OH Ohio
OK Oklahoma
OR Oregon
PA Pennsylvania
RI Rhode Island
SC South Carolina
SD South Dakota
TN Tennessee
TX Texas
UT Utah
VT Vermont
VA Virginia
WA Washington
WV West Virginia
WI Wisconsin
WY Wyoming

AB Alberta
BC British Columbia
MB Manitoba
NB New Brunswick
NF Newfoundland
NOWET Northwest Territories
NS Nova Scotia
NUNAVUT Nunavut
ON Ontario
PE Prince Edward Island
PQ Quebec
SK Saskatchewan
YUKON Yukon

THU Australian Capital Territory
NSW New South Wales
NTER Northern Territory
Country_Code Defines the site's Country:
USA USA
CANADA Canada
AUSTRALIA Australia
FRANCE France
Zip_Code Defines the site's Zip Code.
Is_Default_Billing_Address Defines whether or not the site is the Default Billing Address
Note: Enter 1/0 for Yes/No.
Is_Override_Regional_Settings Defines whether or not the Regional Settings is overridden at the Site level.
Note: Enter 1/0 for Yes/No.
Thousands_Separator Defines the site's Thousands Separator.
Decimal_Separator Will be applied in case IsOverrideRegionalSettings is set to 1.
The applicable values are: (.) and (,).
Date_Separator Will be applied in case IsOverrideRegionalSettings is set to 1.
he applicable values are: (.), (-) and (/)
Date_Format Will be applied in case IsOverrideRegionalSettings is set to 1. Possible Value:
0-DD/MM/YYYY
1-MM/DD/YYYY
2-YYYY/MM/DD