Changeset 3217
- Timestamp:
- 25 Feb 2008, 11:44:50 (17 years ago)
- Location:
- WAeUP_Doc
- Files:
-
- 5 added
- 4 deleted
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
WAeUP_Doc/NewDocumentation/ImportNew.txt
r3211 r3217 1 ================================== 2 Import of data into the portal 1 3 ================================== 2 Import of massdata into the portal 3 ================================== 4 General procedure 4 5 General procedure 5 6 ---------------------------------- 6 7 7 A record is read from the input-source-file and the data is checked. If the 8 record can be imported, it is **appended** to the file XXX_imported.csv, 9 otherwise it is **inserted** into the file XXX_pending.csv, if no record 10 with the exact same date already exists in the XXX_pending.csv. The check is 11 done by comparing the md5-digests of the new record with the existing records. 8 A record is read from the input source file located in the import folder of the Zope instance. The data format is validated against the import data layout selected. If the record can be imported, it is **appended** to the file [layout]_imported.csv (in the same folder), otherwise it is **inserted** into the file [layout]_pending.csv, if no record with exactly the same data already exists. Technically speaking, the md5-digests of the new record is being compared with the existing records. 12 9 13 When doing the import in pending-only-mode the XXX_pending.csv is taken as 14 input-source-file and if a record can now be imported it is appended to the 15 XXX_imported.csv file and removed from XXX_pending.csv. 10 The report files have five additional columns: import_mode, imported_by (the member who did the import), import_date, import_from (input source file name) and error (error message). The pending file can be edited and re-imported by selecting 'pending data only'. 16 11 17 **Caveat**: 12 There following import modes are recognized: edit, create and remove. The latter deletes the whole record. This mode is available for course results only. 18 13 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. 14 Single fields can be cleared in edit mode by inserting 'XXX' in the respective field. Empty fields are ignored. 23 15 24 The XXX_imported.csv and XXX_pending file has these columns added:25 16 26 :imported_by:27 28 the member who did the import29 30 :import_mode:31 32 edit, create, delete33 34 :import_date:35 36 the date and time of the import37 38 :imported_from:39 40 the filename of the input-source-file41 42 :error:43 44 the error message (empty in XXX_imported)45 46
Note: See TracChangeset for help on using the changeset viewer.