Changeset 3217


Ignore:
Timestamp:
25 Feb 2008, 11:44:50 (17 years ago)
Author:
Henrik Bettermann
Message:

rewrite ImportNew?.txt

Location:
WAeUP_Doc
Files:
5 added
4 deleted
1 edited

Legend:

Unmodified
Added
Removed
  • WAeUP_Doc/NewDocumentation/ImportNew.txt

    r3211 r3217  
     1==================================
     2Import of data into the portal
    13==================================
    2 Import of massdata into the portal
    3 ==================================
    4 General procedure
     4
     5General procedure
    56----------------------------------
    67
    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.
     8A 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.
    129
    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.
     10The 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'.
    1611
    17 **Caveat**:
     12There following import modes are recognized: edit, create and remove. The latter deletes the whole record. This mode is available for course results only.
    1813
    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.
     14Single fields can be cleared in edit mode by inserting 'XXX' in the respective field. Empty fields are ignored.
    2315
    24 The XXX_imported.csv and XXX_pending file has these columns added:
    2516
    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 TracChangeset for help on using the changeset viewer.