<aside> ⚠️ The current function is under development and may change by the MVP release. What is described below is a preliminary solution within the design framework.

</aside>

The CMS supports exporting and importing the database through xlsx (Excel) files.

On the right side of the interface, there is an Export/Import button. Clicking on it opens a sidebar where the mapping of fields in the CMS and columns in the xlsx file is set up.

Main Elements

  1. Setting control buttons Save settings — apply current field settings for export/import. Reset — resets settings. Even after resetting, you need to click on Save settings to apply these changes.
  2. Excel sheet name The field where the sheet name is written, which will be recorded in the exported file.
  3. Key Field The field by which data will be matched during export and during data import.
  4. List of fields Fields that will participate in the export. They can be moved between each other and remove the unnecessary ones.
  5. Add fields button Clicking adds a new row for settings.
  6. Export and Import buttons Clicking on export starts the unloading process. Clicking on import opens a window for selecting a file, after which the data update process starts.

Fields participating in the export/import

  1. Text
  2. Rich text
  3. Numbers
  4. Date
  5. Boolean
  6. Array
  7. E-mail
  8. Select

Import Process

  1. When you click the Import xlsx button, a file selection window opens from your device. Currently, only the .xlsx format is supported.

    <aside> ⚠️ It's important that the sheet name inside the imported file matches the name in the Exel sheet name field. Otherwise, the data update will not occur.

    </aside>

  2. The file upload begins. A modal window opens, which can't be closed until the process is finished. The progress is indicated in percentages.

  3. The data update in the collection begins.

  4. After the data update is finished, we can close the modal.

Export Process

  1. After clicking Export xlsx, a modal window appears with a record processing counter. There is also a hint that the window can be closed and the file will download upon completion.

  2. After the records are processed, the document will start to form.

  3. The file is formed and the download begins.

Export Result

  1. We write the sheet name, set up the fields for export, and click on Export .xslsx.

  2. Open the formed xlsx file and see all the set fields.

<aside> 🔖 Read more on this topic ——————————— Collection Saving views

</aside>