## Overview By specifying key items, you can import by matching existing records in the table with record rows in the CSV file. ## Supported Versions 1. Pleasanter 1.3.11.2 or later ## Prerequisites You must specify the "[Import Key](/en/manual/table-management-import-key)" in Advance in Manage Table. ## Limitations 1. Can be set for each item: "「Description Column」", "「Title Column」", "「Body Column」", and "[Class Column](/en/manual/table-management-class)". 1. The item name in CSV must match the item name in Pleasanter. Please check [Things to check if record import does not work](/manual/table-record-import-fail). 1. Cannot be used for user tables, department tables, or group tables. 1. If you use this function to import a large amount of data using a key other than ID, it may take a long time to process and the expected response performance may not be achieved. If you are importing a large amount of data, please consider importing using ID as the key. Depending on the RDBMS you are using, you may be able to improve performance by setting an index on the item that is used as the key. ## Notes If there are duplicate import keys, an error will occur during import. Therefore, we recommend that you also set the "[No Duplicates](/en/manual/table-management-no-duplication)" setting for the columns you specify as import keys. ## Description By specifying an existing table column as a key column and importing, you can import records in the table and rows in the CSV file that you want to import. For example, if the "Customer Number" column is in the customer table, you can import it by specifying the "Customer Number" column as a key column. If the "Customer Number" column in the existing customer table matches the "Customer Number" in the CSV file, the corresponding record in the customer table will be updated to reflect the contents of the record row in the CSV. If the "Customer Number" in the CSV file does not exist in the "Customer Number" column in the customer table, it will be added as a new record. ## Operation Method In the import dialog, check "Records With Matching Keys" as shown below, select the desired key column in the "Key" pull-down menu, and then perform the import.  For more information on import operations, please refer to "[Table Function: Import Record](/en/manual/table-record-import)". It is possible to set default values ​​for key columns. Please refer to [Manage Table: Import](/manual/table-management-import). ## Related Information <div id="ManualList"><ul><li><a href="/en/manual/table-management-class">Table Management: Item: Classification</a><span>08.13.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-no-duplication">Table Management: Editor: Item Detail Settings: No Duplicates</a><span>08.13.2024 up</span></li> <li><a href="/en/manual/table-management-import-key">Table Management: Editor: Item Detail Settings: Import Key</a><span>08.13.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />