Automated Import of Assets

Tim Shelton

Updated July 20, 2026 19:22

File-Based

Task	Responsible Party
Provide decision on delivery method: FacilityOS hosted SFTP With IP Access List Without IP Access List Client Hosted SFTP	Client
Provide SFTP access details and credentials, as applicable	FacilityOS or Client (based on client’s decision above)
Specify type of email notifications and email addresses of recipients	Client
Upload to SFTP an import file that meets the formatting requirements	Client
Set up automated job to import data	FacilityOS
Review data and confirm accuracy	Client
Set up automated job to send data file	Client
Enable respective jobs for scheduled import	FacilityOS & Client

The first step is for the client to select a delivery method. Please select from the following:

File to FacilityOS SFTP – FacilityOS establishes a dedicated SFTP folder with unique credentials and client uploads file (MOST COMMON)
1. With IP Access List (RECOMMENDED)
  1. For scenarios where machine uploading file will have a static IP address or IP range
  2. Customer must provide IP address or IP range
2. Without IP Access List
File to client’s SFTP – Client establishes a dedicated SFTP folder with unique credentials and FacilityOS-built job retrieves files

Category	Requirements
Content	Any asset data needing inserted or updated
Header Row	Required
Columns	See grid that follows for supported columns Column names in header row must match the grid that follows Not case-sensitive Order of columns does not matter Customer may add or subtract any columns not marked as required at any time without needing to consult FacilityOS
SFTP Folder	/AssetImport
File Name	(Any value)
File Format	Must be one of the following: .csv .txt
Field Separators	Must be one of the following: Comma If using comma separators, ensure commas are removed from field values during file creation or employ double-quote text qualifiers Pipe Tab
Text Qualifiers	Must be one of the following: Double-quotes (none)
Line End	Must be one of the following: CR LF CRLF

Column Name	Data Type	Description
AssetID	Nvarchar(50)	Required Unique ID/tracking number for the asset
Timestamp	DateTime	The timestamp used for the status update. If not provided, the current date/time at time of import will be used. Use UTC time zone
Status	Nvarchar(50)	Must be a valid LogisticsOS status; if not provided, a default will be used
OwnerID	Nvarchar(50)	EmployeeID of the asset's owner
Location	Nvarchar(50)	EmployeeID of the asset's location
Name	Nvarchar(50)
Description	Nvarchar(50)
Condition	Nvarchar(50)
Manufacturer	Nvarchar(50)
Model Number	Nvarchar(50)
Serial Number	Nvarchar(50)
Weight	Nvarchar(50)
Capital Asset	Nvarchar(50)
PO Number	Nvarchar(50)
Acquisition Date	DateTime	Use local time zone
Next Maintenance	DateTime	Use local time zone
(Additional asset metadata fields)	(Varies)	Additional asset metadata fields may be included for import, and the column name and data type must align with the field configuration within LogisticsOS. If multiple metadata fields use the same name, the enabled field with the lowest # is used.
(Additional historical metadata fields)	Nvarchar(50)	Additional historical transaction metadata fields may be included for import. The column name must use the prefix hist: and the rest of the name must align with the field configuration within LogisticsOS. For example: hist:Signed By If multiple metadata fields use the same name, the enabled field with the lowest # is used.

The standard import logic is as follows:

Using the status In Serivce:
- Add new records
- Update existing records that have changed

The import job may be configured to send standard email notices for the following events:

After a successful import, the source file will be archived to a dedicated directory
Archived files will be deleted after 14 days