Flat File data source
Data Manager is included in all Service Collection Premium and Enterprise plans.
The Flat File data source is a general connector to fetch data from a publicly accessible google sheet, CSV or TXT file into Data Manager . To use it, you create a Flat file job.
This task requires Data Manager & Adapters admin permissions to complete. See how permissions and roles work in Data Manager.
Please note that this data source is cloud enabled where Source type - API, therefore the fetch can be ran from within the Data Manager UI fetching data without the need of the Data Manager Adapters client.
Formatting a CSV file for Data Manager
To ensure Data Manager can understand your data, follow these basic standards and specify them when you configure the job:
Formats – supported encodings:
UTF‑8 (default)
UTF‑16
ISO‑8859‑1
ISO‑8859‑15
Windows‑1250
Windows‑1252
Header – the CSV file must have a header row.
Delimiter – file must include a single‑character delimiter.
Multiple values – use
||(two pipe characters) to represent multiple values in a single field (useful for multi‑value attributes).Qualifier – a unicode character that wraps text with spaces so it’s treated as a single value (for example,
"Microsoft Windows").
Example CSV:
"Name","Owner","Service Category","Hosts"
"Confluence","Ellen McDonald","Finance","Oracle-E-Business-Server"
"Email Service","Bea Owenstein","Infrastructure","http://exchange.prod.main1"
"Partner portal","Les Weinen","Marketing","http://mysql.prod.app7"Was this helpful?