Example Import File

This example import file shows how the import objects and object definition elements fit together. It imports three addresses and one site into the database, and it deletes one address. In doing so, it references four existing objects: country, state_prov, time_zone, and bus_org.

REFERENCE TYPE="country", NAME="USA", UNIQUE_FIELD=name

 FIELDS

  name="USA";

 END_FIELDS

END_REFERENCE NAME="USA"

REFERENCE TYPE="state_prov", NAME="Texas", UNIQUE_FIELD=name

 FIELDS

  name="TX";

 END_FIELDS

END_REFERENCE NAME="Texas"

REFERENCE TYPE="time_zone", NAME="CST", UNIQUE_FIELD=name

 FIELDS

  name="CST";

 END_FIELDS

END_REFERENCE NAME="CST"

REFERENCE TYPE="bus_org", NAME="BO", UNIQUE_FIELD=objid

 FIELDS

  objid=-2;

 END_FIELDS

END_REFERENCE NAME="BO"

DELETE TYPE="address", NAME="Ship_1", UNIQUE_FIELD=address, address_2, zipcode

 FIELDS

  address="1255 Redbud Creek";

  address_2="Apt 123";

  city="Austin";

  state="TX";

  zipcode="78759";

 END_FIELDS

 RELATIONS

  TO_NAME="USA" REL="address2country";

  TO_NAME="Texas" REL="address2state_prov";

  TO_NAME="CST" REL="address2time_zone";

 END_RELATIONS

END_OBJECT NAME="Ship_1"

OBJECT TYPE="address", NAME="Prim_1", UNIQUE_FIELD=address, address_2, zipcode

 FIELDS

  address="125 Main St";

  address_2="Apt 623";

  city="Austin";

  state="TX";

  zipcode="78759";

 END_FIELDS

 RELATIONS

  TO_NAME="USA" REL="address2country";

  TO_NAME="Texas" REL="address2state_prov";

  TO_NAME="CST" REL="address2time_zone";

 END_RELATIONS

END_OBJECT NAME="Prim_1"

OBJECT TYPE="address", NAME="Bill_1", UNIQUE_FIELD=address, address_2, zipcode

 FIELDS

  address="8900 Business Park Dr";

  address_2="Suite 555";

  city="Austin";

  state="TX";

  zipcode="78759";

 END_FIELDS

 RELATIONS

  TO_NAME="USA" REL="address2country";

  TO_NAME="Texas" REL="address2state_prov";

  TO_NAME="CST" REL="address2time_zone";

 END_RELATIONS

END_OBJECT NAME="Bill_1"

OBJECT TYPE="site", NAME="site_1", UNIQUE_FIELD=site_id

 FIELDS

  site_id="DT";

  name="Dovetail Software";

  type=1;

  site_type="CUST";

  status=0;

 END_FIELDS

 RELATIONS

  TO_NAME="Prim_1" REL="cust_primaddr2address";

  TO_NAME="Bill_1" REL="cust_billaddr2address";

  TO_NAME="BO" REL="primary2bus_org";

 END_RELATIONS

END_OBJECT NAME="site_1"

Did this topic help you? Email us your feedback.
Last updated: 8/1/2007 9:09:51 AM
© by Dovetail Software, Inc.