Import Table¶
Warning
Support is not provided for the tables for which primary key is not set, primary key contains fields in time-stamp format.
- Click on “Site-map”.
- Click on “TableMaintenance” → “Import Table”.
Importing data in database¶
Note
If the storage (public storage) already contains imported files,enter the file path directly in “storage” instead of performing above mentioned upload process.Note
Editing will be disabled for “storage” once a file is uploaded.Open a new screen if other local file or file from storage is to be imported.After entering below mentioned option settings as per requirement, data can be imported by clicking “Execute” button.
About Option Settings¶
| File encoding | Settings for specifying encoding of CSV file. Specify after confirming the encoding of CSV file and Intramart. Following encoding can be set. MS932, UTF-8, UTF-16, EUC_JP |
| Maximum error size | Set the number of records for which the processing is stopped when error is thrown during the import process. Import will be cancelled if number of records for which import has failed, crosses the set value. E.g.) When the number is set as 10 If error count crosses the limit of 10, CSV file import process which is in progress will be aborted and import of next CSV file will start. |
| Interval between commits (records) | Commit is executed after the number of records set here are imported. If “0” is set, commit is executed once after every import. |
| Date format | While importing data of fields in date format or time-stamp format, convert the data to be imported using format character string set in this option. E.g.) yyyy/MM/dd|HH:mm:ss yyyy/MM/dd etc. ※ Error will be thrown if the conversion fails. |
| Numerical value format | While importing data of fields in numerical value format, convert the import data by using format character string set in this option. ※ Error will be thrown if conversion fails. |
| Character string treated as Null | If imported data contains the character string which is set, its value will be treated as Null. This setting can be used for data types in database other than character strings only. |
| Character string treated as Null (for fields in character string format) | Set character string to be treated as Null value. If data type in database is character string and if data being imported contains character string, its value will be treated as Null. |
| Insert . mode | [Enabled] When data of CSV file is to be imported, process the entire data in INSERT. Error will be thrown if field of primary key contains data with same value (unique constraint violation). [Disabled] If primary key field of target table already contains data with same value, process it in UPDATE. If it does not contain data with same value, process it in INSERT. |
| Replace Mode | [Enabled] Delete all records of target table before importing CSV file and process it in INSERT statement. [Disabled] Delete is not performed before import . |
| Commit when error data exists | [Enabled] Even if there is data for which import has failed, commit is executed for the part which is successfully imported. [Disabled] Commit cannot be done if there is even a single data for which import has failed. |
Warning
Please note that if specified encoding format and encoding of CSV file differs, imported data might get garbled.