User Manual

08.13.2024

MANUAL

Table Function: What To Check If Records Are Not Imported Properly

## Overview When "[Import](/en/manual/site-package-import)" data into Pleasanter, the item names in the original data (CSV) must match the display names in Pleasanter. ![image](https://pleasanter.org/binaries/be19f1a8673247e696b347257b0e1ceb) Set the display name on the Pleasanter side in "[Editor](/en/manual/table-management-editor)" rather than "[List](/en/manual/table-management-grid)". ![image](https://pleasanter.org/binaries/9344820074314e3da03763a55254e8e0) Check whether the CSV data you want to import is saved in Shift-JIS or UTF-8 format, and select the format in which it is saved in the "Character Code" field displayed in the Pleasanter import dialog below. ![image](https://pleasanter.org/binaries/a3b48023e7e84288b467106c6b1d2481) ## Things To Check If The Import Doesn't Work ・If the data can't be imported or only part of it is imported. →Please check that the correct character code is selected when importing. ![image](https://pleasanter.org/binaries/b6c8ff66508541ed97530e7fb3100552) If you can import alphanumeric characters but cannot import Japanese characters, it may be that the character code is incorrect, so if this doesn't work, please try the other option. ## Things To Check If Your Imported Data Doesn't Link Properly ・Import the master table first before importing the child table  →If you have already imported the child table, after importing the data into the master table, export the child table data and import that file with the "Update records with matching IDs" check box checked. ・Import the child table's link field name as the child table's field name, not the parent table's field name. →For time-bound tables, a value is required for the "Complete" field. When importing data into a time-bound table, be sure to enter a value in the "Completed" field. *There is no "Completed" field for record tables. ## Limits When Using pleasanter.net 1. pleasanter.net can import up to 10,000 records in one import process. If you want to import more than 10,000 rows of data, please import in chunks of 10,000 rows. ## 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-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-editor">Table Management: Editor</a><span>08.13.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-grid">Table Management: List Screen</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.