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 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.
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?