Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Field with empty data mean "ignore this field".
  • Put value '=' will remove the current value in system.
  • Field with data will be imported.

In case you want to assicate a contact to a criteria or structure type. You need to following these links: Contact criteria definition and Structure type definition to create records.

Global fields

Field codeField typeMandatoryDescription
INSTITText 15Yes

Institution code owning the data to be imported.

ORGANIZATIONText 15Yes

Organization owning the data to be imported.

A "*" indicates that all organizations of the given institution are concerned.

OPERATIONEnumYes

Operation to be executed

INSERT : insert the row as a new contact

UPDATE : update the contact. Can be used to link criterion to contact.

UPDATEACT: update the contact and reactivate it if needed.

DELETE: Applicable to all contacts.

  • Delete the contact address, communication mean
  • For authorization and criterion value. Only delete the value that specified in excel file.
  • The email will be empty and contact can't be login to ticketshop anymore.
  • This action is irreversible.

INVALIDATE: Applicable to contact which has no sales.

  • Just mark contact as invalid with reason: ACCOUNT_DELETED.
  • All other information are in tact (not removed).

ANONYMIZE: Applicable to all contacts (even if it has sales).

  • All contact information is deleted. Contact name is changed in to 'XXXXXXXX'.
  • Set contact as ACCOUNT_DELETED and remark contact with 'Contact anonymized'.
  • The contact's sales information are in tact (not removed).
  • This action is irreversible.

DROP : Should only be used for mis-import. Applicable to contact that imported and has no modified since then.

  • Drop the contact and all its information. The contact is not dropped if it is used in existing sales.
  • The contact row is removed from system forever.

...