データベースにデータをインポートする

データは、データベースに簡単にインポートできます。このガイドでは、コンテンツのアップロードからインポートされたエントリの微調整まで、順を追って説明します。

データベースにコンテンツをアップロードする

構造化されたコンテンツをデータベースにアップロードするには、主に次の 3 つの方法があります。

1. コピーして貼り付ける:

   • Directly copy the content from a database and paste it into another database.

2. 接続する:

   1. Select the Templates and import option

      in the ••• (More) menu of your database. This will open the Database setup panel. Under the Connect heading, you’ll see options for connecting to Jira or Confluence.

   2. Using these options, you can import Jira issues or Confluence pages directly into your database. This will replace the current database, removing any fields and values in it.

3. インポートする:

   • Select the Templates and Import option of your database. This will open the Database setup panel.

   • Under the Import heading, you can upload files in CSV format.

Setting up your database structure

When using the Import option, field types and headers will be automatically detected, removing the need to set up your database structure prior to import and allowing you to configure the structure after import as you see fit.

If you are importing to an empty database, the imported content will replace the existing database once you upload your file. If you are importing to a non-empty database, you’ll see an additional dialog step with two options:

1. Add values to this database: Values will be added as new fields to the right and bottom of the existing data, offering flexibility to compare the new data side-by-side with existing data or re-arrange the new data.

2. Replace the existing database: Deletes all existing values and fields.

Once you make a selection, select Confirm to apply the changes to your database.

Fine-tune imported data

The import process will automatically detect field types for numbers, tags, and Smart Links, defaulting to text. Note that importing larger CSVs will result in a more accurate conversion for the tag field.

The first row of the CSV will be used as field names, using default field names for any empty values and renaming duplicates as needed.

After import, you can further modify your database structure:

1. Use the field settings panel to convert field types, rename your field, or otherwise change field settings.

2. Use copy/paste to re-arrange the data.

3. Delete content as you see fit.

By following these steps, you can efficiently import and integrate data into your database.