CA SDM Loading location

Document created by TMACUL Champion on Jan 24, 2017
Version 1Show Document
  • View in full screen mode

HowItWorks.jpgLoading ca_location

 

The first thing what you need know: VERY Important! Using pdm_load can be destructive so always back up your database before you perform a pdm_load, and use pdm_userload unless instructed to use pdm_load.

 

Important! Make a backup copy of the database before running pdm_load with this option. After old database records are removed, you must restore the CA SDM database with this backup copy if you want to recover any deleted records, use pdm_extract for this procedure.

 

1. BACKUP

 

BACKUP COMMAND
pdm_extract ca_location > ca_location.txt

 

2. Structure table

 

bop_sinfo -dq loc

Factory loc < ca_location, usp_location >
Attributes:
id <location_uuid> UUID UNIQUE
producer_id LOCAL STRING(20)
persistent_id LOCAL STRING(60)
last_mod_by last_update_user STRING(64)
last_mod_dt last_update_date DATE
version_number INTEGER
creation_user STRING(64)
creation_date DATE
exclude_registration INTEGER
delete_time DATE
name location_name STRING(100) REQUIRED
delete_flag inactive SREL -> actbool.enum REQUIRED
description comment<comments> STRING(255)
site site_id SREL -> site.id
address1 address_1 STRING(50)
address2 address_2 STRING(50)
address3 address_3 STRING(50)
address4 address_4 STRING(50)
address5 address_5 STRING(50)
address6 address_6 STRING(50)
mail_address_1 STRING(50)
mail_address_2 STRING(50)
mail_address_3 STRING(50)
mail_address_4 STRING(50)
mail_address_5 STRING(50)
mail_address_6 STRING(50)
pri_phone_number STRING(40)
fax_number STRING(40)
city STRING(50)
state SREL -> state.id
primary_contact primary_contact_uuid SREL -> cnt.id
zip STRING(20)
country SREL -> country.id
county STRING(50)
contact_address_flag INTEGER
parent_location_uuid UUID
location_type_id INTEGER
service_groups BREL <- lrel_svc_locs_svc_groups.loc (LREL cnt) {loc = ?}
service_chgcat BREL <- lrel_svc_locs_svc_chgcat.loc (LREL chgcat) {loc= ?}
service_pcat BREL <- lrel_svc_locs_svc_pcat.loc (LREL pcat) {loc = ?}

service_isscat BREL <- lrel_svc_locs_svc_isscat.loc (LREL isscat) {loc= ?}
audit_userid LOCAL SREL -> cnt.id TENANCY_UNRESTRICTED
timezone SREL -> tz.code
linked_id_usp_location id<location_uuid> UUID UNIQUE

 

 

 

Structure load: pdm_extract ca_location

TABLE ca_location
address_1 address_2 address_3 address_4 address_5 address_6 city comment contact_address_flag country county creation_date creation_user delete_time exclude_registration fax_number geo_coord_type geo_coords id inactive last_update_date last_update_user location_name location_type_id mail_address_1 mail_address_2 mail_address_3 mail_address_4 mail_address_5 mail_address_6 parent_location_uuid pri_phone_number primary_contact_uuid site_id state tenant version_number zip
{ "5th Avenue" ,"" ,"" ,"" ,"" ,"" ,"NY", "comments" ,"" ,"255" ,"" ,"10/25/2016 18:11:12", "ServiceDesk" ,"" ,"" ,"" ,"" ,"" ,"42D7422F19E0D44499DCDA586339CC72" ,"0", "12/05/2016 17:28:12" ,"ServiceDesk" ,"NAME" ,"" ,"" ,"" ,"" ,"" ,"" ,"", "" ,"" ,"" ,"" ,"" ,"" ,"3" ,"" }

 

 

 

3. Example

 

loading_location.txt - Content

TABLE ca_location
location_name
{ "TEST"}

 

 

 

 

know_more.png

pdm_load 

1 person found this helpful

Attachments

    Outcomes