« List of bitstream_format_id and mimetypes for DSPACE | Main | how to get rid of '\n' in an sql call »

Excel files to be derived from dspace to go into Drupal

We are going to extract the guts from dspace and put it into Drupal here are the various excel spreadsheets that must be created.
parent_id 
0 - no parent
1 - collection
2 - community


items
metadata 1  ... metadata n parent_type parent_id

communities

     Column       |          Type          | Modifiers 
-------------------+------------------------+-----------
 community_id      | integer                | not null
 name              | character varying(128) | 
 short_description | character varying(512) | 
 introductory_text | text                   | 
 logo_bitstream_id | integer                | 
 copyright_text    | text                   | 
 side_bar_text     | text                   |    <---- Blank

Excel community file
community_id name short_description introductory_text parent_type parent_id has_child


collections:


                  Table "public.collection"
         Column         |          Type          | Modifiers 
------------------------+------------------------+-----------
 collection_id          | integer                | not null
 name                   | character varying(128) | 
 short_description      | character varying(512) | 
 introductory_text      | text                   | 
 logo_bitstream_id      | integer                | 
 template_item_id       | integer                |   <--- not all filled
 provenance_description | text                   |   <--- blank
 license                | text                   | 
 copyright_text         | text                   | 
 side_bar_text          | text                   | 
 workflow_step_1        | integer                | <--- not all filled
 workflow_step_2        | integer                | <--- not all filled
 workflow_step_3        | integer                | 
 submitter              | integer                | <--- eperson_group_id
 admin                  | integer                | <--- eperson_group_id

Excel collection file
collection_id name short_description introductory_text parent_type submitter_group_id admin_group_id parent_id has_child




dspace_ir=> \d eperson;
                    Table "public.eperson"
       Column        |            Type             | Modifiers 
---------------------+-----------------------------+-----------
 eperson_id          | integer                     | not null
 email               | character varying(64)       | 
 password            | character varying(64)       | 
 firstname           | character varying(64)       | 
 lastname            | character varying(64)       | 
 can_log_in          | boolean                     |  <-- all of these are true
 require_certificate | boolean                     |  <-- all of these are false
 self_registered     | boolean                     |  <-- blanks and false
 last_active         | timestamp without time zone | 
 sub_frequency       | integer                     |  <-- blank
 phone               | character varying(32)       | 
 netid               | character varying(64)       | 



dspace_ir=> \d epersongroup;
      Column      |          Type          | Modifiers 
------------------+------------------------+-----------
 eperson_group_id | integer                | not null    <-- admin or submitter
 name             | character varying(256) | 

dspace_ir=> \d epersongroup2eperson;
  Table "public.epersongroup2eperson"
      Column      |  Type   | Modifiers 
------------------+---------+-----------
 id               | integer | not null
 eperson_group_id | integer | 
 eperson_id       | integer | 


dspace_ir=> select * from  epersongroup2workspaceitem ;
 id | eperson_group_id | workspace_item_id 
----+------------------+-------------------
(0 rows)



3 excel tables
eperson
eperson_id firstname lastname phone netid

group 
eperson_group_id name

eperson2group
eperson_group_id eperson_id

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)