File import function, usually used for Excel table import.

Use the data import component in Tables as a process.

This chapter introduces the Excel import function.

{
  "setting": "/api/xiang/import/ticket/setting",
  "mapping": "/api/xiang/import/ticket/mapping",
  "mapping_setting": "/api/xiang/import/ticket/mapping/setting",
  "preview": "/api/xiang/import/ticket/data",
  "preview_setting": "/api/xiang/import/ticket/data/setting",
  "import": "/api/xiang/import/ticket"
}

Add the table directory file /tables/ticket.tab.json:

Application directory structure:

├── apis # Used to store interface description files
│
├──tables
| └──ticket.tab.json #import excel table
|
├── models # Used to store data model description files
│
├── db
└── imports #map file for importing data
| └── ticket.imp.json
|
|──scripts
| └──imports
| └──ticket.js
|
|
└── app.json

Write the code ticket.imp.json:

Write the code /scripts/imports/ticket.js:

function Import(columns, data) {
  // todo handles import logic

  // print the implicit relation
  console.log(columns);

  // print the obtained data
  console.log(data);

  var success = 0;
  var fail = 0;

  return [success, fail];
}
function Output(data) {
  // todo handles the logic after import, this function will be called automatically after import: "output": "scripts.imports.ticket.Output",
  return data;
}

• /api/xiang/storage/upload

 "20220411/0C3A5E7FCA0FE897710DE2CA00240FFE.xlsx"

• /api/xiang/import/ticket/mapping

• /api/xiang/import/ticket