When importing data into the system, some fields may contain commas within the actual values, for example, a location field like "Admin, UK". If you use a comma (,) as the delimiter in your import file, the system may misinterpret the data or fail to import it correctly.
To ensure a successful import when your values contain commas, use a semicolon (;) or a tab character as the delimiter.
Correct format (semicolon as delimiter):
Computername;Notes;CustomfieldTest
Device123;Admin, UK;ThisisaTest
Invalid format (comma as delimiter):
Computername,Notes,CustomfieldTest
Device123,Admin,UK,ThisisaTest
Avoid using commas as delimiters when your data includes comma-separated values. Instead, use semicolons or tabs to prevent import errors and ensure accurate field mapping.
Related Articles
Importing data from Tanium fails if any of the following columns in XML data contain special characters: installerEvidence… 4Number of Views Importing data from Tanium fails if any of the following columns in XML data contain special characters: computer.computer… 4Number of Views Importing computer inventory data from a spreadsheet/file may fail with a validation error if 'InstanceCloudID' field is m… 4Number of Views Import computer data in Snow Atlas 15Number of Views Calculating First Name, Middle Name and Last Name values in business import from User Name values may perform poorly when … 7Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Case id: 00001065
Activity: Status change: 2 hours ago