FAQs
Frequently Asked Questions
Q: What file formats are supported?
A: Only CSV (Comma-Separated Values) files are supported. Excel files (.xlsx) must be saved as CSV first.
Q: Can I upload multiple files at once?
A: During initial setup, upload one sample file per data type. For regular uploads, you can upload multiple files for the same data type but 5 files can be uploaded at a tme.
Q: How often can I upload data?
A: As often as needed. There’s no limit on upload frequency.
Q: Is my data secure?
A: Yes. Files are uploaded to secure storage with encryption. Only authorised users in your organisation can access the data.
Q: Do I need to set up a connector for each data type?
A: No. One connector can handle multiple data types (Users, Groups, Licenses, etc.). Select all data types you need during initial setup.
Q: Can I change field mappings after setup?
A: Yes. Mappings can be edited after setup. The validation need to happen again if you want to save updated mappings.
Q: What if my CSV columns change?
A: Edit the mapping configuration before for the connector before you proceed to upload.
Q: Can I have multiple connectors?
A: Yes. You can create multiple connectors for different data sources or applications.
Q: What happens to existing data when I upload?
A: The existing data is updated if it exists. If the data doesn’t exists it will create new entries.
Q: How do I update existing records?
A: If you provide updated data for the same records, the data will be updated.
Q: What if I have duplicate rows in my CSV?
A: If multiple rows resolve to the same identifier(depends on the entity), the latest processed row overwrites earlier values within the same upload.
Q: Why did some rows fail validation?
A: Common reasons:
- Missing required fields
- Wrong data format (text in number field, etc.)
- Invalid enum values
- Transformation errors
View or Download the error report to see specific issues.
Q: Can I import rows with errors?
A: No. Only valid rows are imported. Fix errors and re-upload the complete file.
Q: How do I fix validation errors?
A:
- View or Download error report
- See exact error for each row
- Fix issues in your original CSV
- Re-upload corrected file
Q: What if I don’t understand an error message?
A: Contact support with:
- The error message
- Your error report
- Sample of your CSV file
Q: Can I use semicolons instead of commas?
A: No. Only comma as a delimiter is supported.
Q: How do I handle commas in my data?
A: Enclose values containing commas in quotes:
Name,Description
"Smith, John","Senior Engineer"Q: What date format should I use?
A: YYYY-MM-DD format is recommended (e.g., 2024-01-15). Or use data format functions to change the format to a the required output.
Q: Can I use formulas in my CSV?
A: No. CSV files should contain plain text values only. Calculate formulas in your spreadsheet before saving as CSV.
Q: My upload is stuck. What should I do?
A:
- Wait 15 minutes (upload time limit)
- If still stuck, refresh the page
- Try uploading again
- Contact support if issue persists
Q: Validation failed but I don’t know why.
A:
- View or Download the error report
- Check the error messages column
- Look for patterns in errors
- Contact support with error report if unclear
Q: Can I cancel an upload or validation?
A: Yes. You can cancel the upload by clicking on cancel. If by any chance the page get’s refreshed or reloaded, go to the connector uploads page and abort running syncs to start a new upload.
Q: What’s the best way to prepare my CSV files?
A:
- Use consistent column names
- Include headers in first row
- Test with small sample first
- Remove empty rows at the end
- Ensure required fields have values
Q: Should I test with sample data first?
A: Yes! Always test with a small sample file before uploading large files.
Q: How can I avoid validation errors?
A:
- Review field requirements during mapping
- Use consistent data formats
- Map enum values correctly
- Test with sample data first
- Use correct transformations
- Clean your data before upload
Q: What if I need help with complex transformations?
A: Here’s a document that outlines complex and advance transformations. If it’s still not helping for your use cases, contact support for assistance.
Updated about 3 hours ago