[Yi fei] Analysis of Design import and export rules

【Abstract】 new import and export rules are added after Yifei 8.0 +, which greatly facilitates batch data import by users or administrators.

Let's open the interface to see:

So how should we use it correctly?

Import method: 1. SQL 2. Program

1. SQL import Method

Naturally, the database is updated directly in the same way as the SQL import method.

For basic data, basic data values are recorded, and SQL import is selected if the correlation is less than half.

2. Program

What about documents? Whether it is single or dual files, the program is associated in this province, and the relevant database is written when saving the documents.

Therefore, we recommend that you import documents by program.

Note:

1. Select the report form. If the document already exists, an error is reported directly. Rollback

2. Select skipped, automatically add a document number and save it

3. Overwrite and directly update the original ticket data!

Compare the SQL import results

The result is clear!

In addition, after the export is successful, the original imported text or excel file is deleted, and the import is backed up in advance!