Data Import
How to use Data Import in Platform Settings: access, working steps, fields, related records and troubleshooting.
Purpose and access
Review platform defaults and dependencies within the administrator’s authority. Record the reason and tested impact of changes. Authentication, session settings and security-sensitive configuration need a controlled change process.
This page is a record page in System Admin → Platform Settings. Use the link above to open the configured destination; permissions are checked by the destination service.
Before you start
Prepare the required information: Document Type, Import Type.
Confirm the company, party, dates, units and source references that apply. Select existing links carefully and check for an existing record before creating a duplicate.
Working steps
- Open Data Import from System Admin → Platform Settings, or use ERP Search.
- Filter the list and open the relevant record. To add a record, use Add/New when your role provides that action.
- Complete the editable fields described below. Required fields and validation conditions must be satisfied; read-only values are set by the system or their source records.
- Save the record and address validation messages. Reload and verify the saved values and relationships.
- Use any additional workflow actions only when the record and your role provide them. Saving this record does not automatically complete a related transaction or external action.
Field reference
These fields come from the installed ERP definition. Hidden fields and password inputs are omitted. Additional conditions, custom scripts and workflow rules can make a field required or read-only in a particular context.
| Field | Type / behavior | How to use it |
|---|---|---|
Document Typereference_doctype | Link Required | Choose an existing linked record. Check its company and ownership; typing a label alone does not create a new relationship. Linked record: DocType |
Import Typeimport_type | Select Required | Choose one of the configured list values. Status fields may be controlled by the record workflow.Available choices
|
Import Fileimport_file | Attach Optional | Upload the permitted evidence file. Confirm the record and privacy settings before sharing. |
Import from Google Sheetsgoogle_sheets_url | Data Optional | Must be a publicly accessible Google Sheets URL |
Detect CSV typeuse_csv_sniffer | Check Optional | Use if the default settings don't seem to detect your data correctly |
Custom Delimiterscustom_delimiters | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Delimiter Optionsdelimiter_options | Data Optional | If your CSV uses a different delimiter, add that character here, ensuring no spaces or additional characters are included. |
Submit After Importsubmit_after_import | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Don't Send Emailsmute_emails | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Show Only Failed Logsshow_failed_logs | Check Optional | Enable or disable the named option only when it matches the intended record behavior. |
Troubleshooting
- Not permitted: verify the account, role and source-document permission. Do not share an administrator login.
- Missing record or address: inspect the relevant Link or Dynamic Link fields; a matching title alone does not establish a relationship.
- Cannot save or change status: review required fields, read-only values, document status and the configured approval transition.
- Unexpected report or portal result: review company/date filters, source-document submission and the approved party or Employee link.