User Manual

09.02.2026

MANUAL

Table Function: Importing Records in Migration Mode

## Overview In migration mode, you can import the values of "Created by", "Created at", "(Last) Updated by", and "(Last) Updated at". ## Prerequisites On the [Import](/en/manual/table-record-import) tab of the [Manage Table](/en/manual/table-management) screen, enable Allow migration mode. ## Description When you import a CSV file in migration mode with the columns "Created by", "Created at", "Updated by", and "Updated at" set, those values will be reflected in the added record. However, if the setting is "Update records with matching keys", the values will only be reflected in the added record, not the updated record. ### Setting value in case of invalid value The following shows the columns that will be set in the added record if the target field does not exist in the CSV or an invalid value is set. |Columns|Invalid value|Setting value| |-|-|-| |Created by|ID or name of non-existent user|Blank| |Created date and time|String that cannot be converted to date and time, or date and time outside the range of "MinTime" and "MaxTime" in "「General.json」"|Current date and time| |Updated by|ID or name of non-existent user|Blank| |Updated date and time|String that cannot be converted to date and time, or date and time outside the range of "MinTime" and "MaxTime" in "「General.json」"|Current date and time| ### Setting value for update record In the case of update record, migration mode is not applied, and the same value as normal import is set. ## Operation Method Perform an import with "Migration mode" checked in the import dialog. ![image](https://pleasanter.org/binaries/70126747513041929fe6013a92ad032c) For details on the import operation, please refer to "[Table Function: Importing Records](/en/manual/table-record-import)". ## Supported Versions |Supported versions|Body| |:--|:--| |1.4.16.0 and later|Added function| ## Related Information <div id="ManualList"><ul><li><a href="/en/manual/table-record-import">Table Function: Importing Records</a><span>09.22.2025 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management">Manage Table</a><span>12.09.2025 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />
support_agent 本格運用を、もっと安心・安全に

安定運用や活用拡大を見据えるなら、年間サポートサービスをご活用ください。

年間サポートサービスの詳細はこちら →
school プリザンターを使いこなす近道はこちら

基本から実践まで、プリザンターをしっかり学べるトレーニングをご用意しています。

トレーニングサービスの詳細はこちら →
TOP