This page contains information about PAHMA's data migration of Groups and related info.
See parent page on PAHMA data migration ETL work.
Groups extract
field mapping
TMS table name |
TMS field name |
CSpace field name |
notes |
---|---|---|---|
ObjectPackages |
name |
title |
|
ObjectPackages |
notes |
scopeNote |
|
ObjectPackages |
owner |
owner |
FK to Users; reference to Person Authority |
sql query
view: cs_groups
SELECT p.objectPackageID groupID, p.name title, p.notes scopeNote, (CASE WHEN u.MTB_ConstituentID = -1 THEN NULL ELSE u.MTB_ConstituentID END) owner FROM ObjectPackages p LEFT OUTER JOIN Users u ON p.owner = u.login ;
notes
- "global" field does not need to be imported, per Michael (1/12/12)
Object-Group Relationship extract
field mapping
TMS table name |
TMS field name |
CSpace field name |
notes |
---|---|---|---|
ObjPkgList |
ObjectID |
reference to Object |
|
ObjPkgList |
ObjectPackageID |
reference to Group |
|
sql query
view: cs_objectgrouprelationships
SELECT CAST(o.objectID AS VARCHAR) objectID, o.objectPackageID groupID FROM objPkgList o ;