Feature Rich
Rapid Application Development
Helping you or your customers
Manage their Business

<-- Back to Help Topics

Import Definition Object

The definition of an import process


An import is very easy in theory, however depending on what you are importing it could also be very complex.

Each column of the source data might need one or more targets, a persons name might need to be split into different parts and as such assigned to different objects or a relationships might need to be added at the same time the data is imported to make the relevant connections.

For this reason, Import Definition Objects can be created to hold all of this information and then referenced in the IMPORT_FORM command.

    Header Cells
    [rel_id:part:tag:operation];...
 
    Relationship ID - Can be zero
    Part - Standard Object Part (0, 1, 2, 3, 4, 12, 13, 15, 18 and 19 are valid) Part 0 used to indicate ID of Object to Update
    Tag  - Optional XML tag name
    Operation - Optional Operation:
        +/ : add to existing with <br />, 
        +t : add to existing with tab, 
        +n : add to existing with CRLF, 
        +c : add to existing with comma, 
        +s : add to existing with space, 
        w1 : Word 1
        w2 : Word 2
        w2o: Word 2 Onwards
        fn : First Name
        mn : Middle Name
        ln : Last Name
        *  : New Related Object, 
        #  : Clean number
        ?  : Conditional Relationship (Param 2 = id of relationship: Param 3 = True Value(Default is "Y YES T TRUE") )
        @  : Cell indicates the Object Type
        "Pre*Suf" : Pattern to apply. * in pattern is replace with content
    
    Relat = Array of relationship IDs and Objects [123:456,789:1011]