Exercise 12: Appending data to a table

In the following exercise we see how the row attribute can be used to overwrite or update the contents of table fields.

  1. First create an Import data file with the following values:

    Column Name

    (Row 1)

    Record 1

    (Row 2)

    NamPartyType

    Person

    NamLast

    [Your login name]

    NamOtherNames_tab(1)

    A

    NamOtherNames_tab(2)

    B

    NamOtherNames_tab(3)

    C

  2. Save the Import data file as exercise12_base_train1.csv, where Train1 is your login name.

    Note: Keep this file handy as we'll be using it from time to time to return the record to a base state.

  3. Perform a Typical import in the Parties module.

    When successful, your newly imported record will be similar to:

    mod_parties_append_train.gif

  4. Note the IRN of your newly imported record (which will be referred to as [Your IRN] for the remainder of this exercise):

    ________

  5. Modify and save exercise12_base_train1.csv, where Train1 is your login name as follows:

    Column Name

    (Row 1)

    Record 1

    (Row 2)

    irn

    [Your IRN]

    NamOtherNames_tab(1)

    A

    NamOtherNames_tab(2)

    B

    NamOtherNames_tab(3)

    C