User Manual

08.13.2024

MANUAL

Table Function: Updating Existing Records By Importing Records

**In version 1.3.11.2 and later, you can use "[Specify Key Items When Importing](/en/manual/table-record-import-key)".** ## Overview This section explains how to "[Import](/en/manual/site-package-import)" CSV data to update existing data and some points to note. Import the following CSV data. ![image](https://pleasanter.org/binaries/704fd2f993024215b2547c87a794fd2a) ![image](https://pleasanter.org/binaries/f33cca731d5a4952acb83a1cb5a87d1e) A unique ID is assigned to each record registered in Pleasanter. The data that was exported from the data that was imported earlier is the CSV file below. ![image](https://pleasanter.org/binaries/e4d81ba80add48fd86bf56450144e29c) Add and update data as follows. The three cells highlighted in green will be treated as updated rows, and the two rows highlighted in pink below will be newly added. ![image](https://pleasanter.org/binaries/1a066a2c95464d0e91390d68f1bae166) Check "Update records with matching IDs" and import the updated CSV data. ![image](https://pleasanter.org/binaries/96ffba879799494da5618bc38c0e6217) ![image](https://pleasanter.org/binaries/b02e7943177346f6a9b4a23c81492dd4) If you then want to add one more item, adding a new row to the data imported earlier and checking "Update records with matching ID" before importing will result in duplication as shown below. ![image](https://pleasanter.org/binaries/2bc710cca560493db68339e58f9feeba) ![image](https://pleasanter.org/binaries/eaab95425bb9477085f0463eaa55eacf) Records with blank "[ID Item](/en/manual/table-management-id)" will always be treated as new data, so if you are updating existing data and adding new data at the same time, you should either add the Pleasanter record ID to the existing data, or edit and add data based on the data exported from Pleasanter. ## Related Information <div id="ManualList"><ul><li><a href="/en/manual/site-package-import">Site function: Import Site Package</a><span>08.13.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-record-import">Table Function: Import Record</a><span>08.13.2024 up</span></li> <li><a href="/en/manual/table-record-import-key">Table Function: Specify Key Items When Importing</a><span>08.13.2024 up</span></li> <li><a href="/en/manual/table-record-import-and-link">Table Function: Import Records and Link Master Data</a><span>08.13.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-id">Table Management: Item: ID</a><span>08.13.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/group-import">Group Management Function: Import/export</a><span>08.14.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.