User Manual

08.13.2024

MANUAL

Table Function: Import Record

## Overview This is an example of importing data from a simple employee list managed in Excel so that it can be managed in Pleasanter. In Pleasanter 1.3.11.2 and later, it is now possible to import data by specifying key fields. [Table Function: Specifying Key Fields When Importing](/manual/table-record-import-key) ## Operation Procedure The general procedure is as follows. 1. Open the employee list Excel data, select "Save As", select "CSV (Comma Separated Values) (.csv)" or "CSV UTF-8 (Comma Separated Values) (.csv)" as the file format, and save it. 1. Create a record table for "Employee list". 1. Set items in "Editor". 1. Import "Employee list.csv". 1. Set the display items on the list screen in "[List](/en/manual/table-management-grid)". **[Notes] ・The title of the CSV data to be imported (first line of the CSV data) must match the item name in Pleasanter.** (Please match the item names displayed in the "[Editor](/en/manual/table-management-editor)" instead of "[Manage Table](/en/manual/table-management)" - "[List](/en/manual/table-management-grid)") **・For time-limited tables, the "Complete" item is required.** (For record tables, there are no required items) ### Import Procedure We will explain the following Excel data configuration as an example. ![image](https://pleasanter.org/binaries/eb47c88c6b154726822ccb8549916093) Select the "Manage" - "[Manage Table](/en/manual/table-management)" - "[Editor](/en/manual/table-management-editor)" tab. Due to the specifications of Pleasanter, "ID" and "Version" cannot be disabled, so leave these two items and disable the others, then enable each item as follows. [Pleasanter "[Editor](/en/manual/table-management-editor)" setting screen] ![image](https://pleasanter.org/binaries/c66509d3836246348dedaced07a39b2f) Change the settings for the enabled items as follows. Select the enabled items and click the "Advanced Settings" button to set each item. Item name|Data type|Pleasanter item|Setting item ---|---|---|--- Employee ID|String|DescriptionA|Style: Normal Name|String|Title Birthplace|String|DescriptionB|Style: Normal Gender|String|CategoryA|Options list: Male (Line break) Female Birth date|Date|DateA Age|Number|NumberA The contents of the "Gender" category A option list are set as follows. ![image](https://pleasanter.org/binaries/2ae8f7de9e6c4bc2a69a120d150e09bd) [Editor screen after setting item names] ![image](https://pleasanter.org/binaries/aaac00736ef44bb28fef0d2e0e6847ae) When importing data into Pleasanter, the item names in the original data (CSV) must match the item names in Pleasanter. ![image](https://pleasanter.org/binaries/a8966ba2d588466bb999b1225e390962) Please set the item names on the Pleasanter side in "[Editor](/en/manual/table-management-editor)" rather than "[List](/en/manual/table-management-grid)". ![image](https://pleasanter.org/binaries/a1ef7de8abd6404f8580d83bd59f8a01) Please be careful not to confuse the item type and item name in Pleasanter. Once you have finished setting the items, click "Update" to return to the list screen and click the "[Import](/en/manual/site-package-import)" button. When the dialog box appears, select the CSV file to import. Select the character code for the corresponding CSV file and click the "[Import](/en/manual/site-package-import)" button. **[Notes] Check whether the CSV data you want to import is saved in Shift-JIS or UTF-8 format, and select the saved format in the "Character Code" field displayed in the Pleasanter import dialog box below.** ![image](https://pleasanter.org/binaries/b21b1884770e4d368fb70f35e1f2036d) When the import is completed, it will be displayed on the list screen as shown below. ![image](https://pleasanter.org/binaries/7841de6549244ed487ba09dcb4cf58fb) Next, set the list screen to display the same content as when it was managed in Excel. Select the "Manage" - "[Manage Table](/en/manual/table-management)" - "[List](/en/manual/table-management-grid)" tab. The default settings are as follows. ![image](https://pleasanter.org/binaries/60a30fa58f284767a729c386939dd3ee) Set it to display all the items imported this time as follows. For this data example, enable the following items. (All others will be disabled.) * Employee ID * Name * Birthplace * Gender * Date of birth * Age After activating the items, click the "Update" button, then click "Back" to display the list screen. ![image](https://pleasanter.org/binaries/28a95bceebef42a38e46cda81d3e61a3) The list will look like the original Excel data. ![image](https://pleasanter.org/binaries/463603c5073c4e5f8ee04248cd8afcef) You have now transferred the Excel data to Pleasanter. ## Things to check if the import does not go well ・Data cannot be imported, or only part of it has been imported …… **→Check that the item name set in "Editor", not "Manage Table"-"List", matches the title of the CSV data.** ![image](https://pleasanter.org/binaries/8c7db93f5e964bc8b69cb88f5d0d9d6b) **→Check that the character code is selected correctly when importing.** ![image](https://pleasanter.org/binaries/7d55616f15fa452ea2d86cd142817769) If you can import alphanumeric characters but cannot import Japanese, the character code may be incorrect, so if this does not work, try the other one. **→For time-limited tables, a value is required for the "Complete" item.** When importing data into a time-limited table, be sure to enter a value in the "Complete" item. *There is no "Complete" item for record tables. **→At pleasanter.net, the number of records that can be imported in one import process is 10,000 rows.** If you want to import more than 10,000 rows of data, please import them in groups of 10,000 rows. **→Some items will not be imported even if values ​​are set in the CSV file.** See the table below for details. |Item name|When adding a record|When updating a record| |:---:|:---|:---| |ID|Automatic numbering by Pleasanter|Do not update| |Version|Automatic numbering by Pleasanter|Automatic numbering by Pleasanter| |Creator|User who performed the import operation|Do not update| |Created date and time|Date and time of import operation|Do not update| |Updater|User who performed the import operation|User who performed the import operation| |Update date and time|Date and time of import operation|Date and time of import operation| |Comment|Value in CSV file|Do not update| ## 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-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">Manage Table</a><span>10.02.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.