Difference between revisions of "Usermanual/ImportCSV"
old>Admin |
old>Admin |
||
| Line 3: | Line 3: | ||
All normal restrictions are in place, so there will be no difference between imported and data entered manually through regular forms. | All normal restrictions are in place, so there will be no difference between imported and data entered manually through regular forms. | ||
During import each line in the import file is handled as a seperate job. Consequently some lines may fail and some lines may succed: The results can be retrived after the import where a modified version of the import file including the succes/failure status information, will be returned to the user. | During import each line in the import file is handled as a seperate job. Consequently some lines may fail and some lines may succed: The results can be retrived after the import where a modified version of the import file including the succes/failure status information, will be returned to the user. This file makes it easy to error correct, as the the format is exactly the same as the import file. | ||
Imports can have certain options included that change what happens during the import | Imports can have certain options included that change what happens during the import | ||
* | * Continue on errors: Do not stop processing on single field errors | ||
* | * Ignore empty values: Empty values are never processed (default: treat as "" or null) | ||
* | * Disable codeunits: Disable custom functionality | ||
* Disable validation: Disable field restrictions | |||
Warning: Do not use the last two options (codeunit/validation), unless you 100% certain how the solution works. | |||
Revision as of 13:53, 10 April 2013
The import function allows selected users to upload data, for either creation of new or update of existing records.
All normal restrictions are in place, so there will be no difference between imported and data entered manually through regular forms.
During import each line in the import file is handled as a seperate job. Consequently some lines may fail and some lines may succed: The results can be retrived after the import where a modified version of the import file including the succes/failure status information, will be returned to the user. This file makes it easy to error correct, as the the format is exactly the same as the import file.
Imports can have certain options included that change what happens during the import
- Continue on errors: Do not stop processing on single field errors
- Ignore empty values: Empty values are never processed (default: treat as "" or null)
- Disable codeunits: Disable custom functionality
- Disable validation: Disable field restrictions
Warning: Do not use the last two options (codeunit/validation), unless you 100% certain how the solution works.