source: WAeUP_Doc/ImportNew.txt @ 3211

Last change on this file since 3211 was 3173, checked in by joachim, 17 years ago

docu for new import procedure. (first draft)

File size: 1.3 KB
Line 
1==================================
2Import of massdata into the portal
3==================================
4General procedure
5----------------------------------
6
7A record is read from the input-source-file and the data is checked. If the
8record can be imported, it is **appended** to the file XXX_imported.csv,
9otherwise it is **inserted** into the file XXX_pending.csv, if no record
10with the exact same date already exists in the XXX_pending.csv. The check is
11done by comparing the md5-digests of the new record with the existing records.
12
13When doing the import in pending-only-mode the XXX_pending.csv is taken as
14input-source-file and if a record can now be imported it is appended to the
15XXX_imported.csv file and removed from XXX_pending.csv.
16
17**Caveat**:
18
19  if an record is inserted into XXX_pending, it will only be removed by
20  importing in pending-only-mode. If a new input-file contains a record for
21  the same object, with different data, that will not be detected at the
22  moment.
23
24The XXX_imported.csv and XXX_pending file has these columns added:
25
26:imported_by:
27
28 the member who did the import
29 
30:import_mode:
31
32 edit, create, delete
33 
34:import_date:
35
36 the date and time of the import
37 
38:imported_from:
39
40 the filename of the input-source-file
41 
42:error:
43
44 the error message (empty in XXX_imported)
45 
46
Note: See TracBrowser for help on using the repository browser.