Skip to content

Manual project exporting

Brad Erickson edited this page Jul 29, 2014 · 2 revisions

There is not yet a process to automatically dump a project and it's dependencies from a Roundware database. This is a rudimentary list of what's required to export the data required for a specific project from the database tables.

  • rw_asset - project_id
  • rw_asset_loc_description - asset_id
  • rw_asset_tags - asset_id
  • rw_audiotrack - project_id
  • rw_envelope - session_id
  • rw_envelope_assets - asset_id
  • rw_event - session_id
  • rw_eventtype - all
  • rw_language - all
  • rw_listeninghistoryitem - truncate
  • rw_localizedstring - all
  • rw_masterui - project_id
  • rw_masterui_header_text_loc - master_ui_id
  • rw_project - project_id
  • rw_project_demo_stream_message_loc - project_id
  • rw_project_legal_agreement_loc - project_id
  • rw_project_out_of_range_message_loc - project_id
  • rw_project_sharing_message_loc - project_id
  • rw_repeatmode - all
  • rw_selectionmethod - all
  • rw_session - project_id
  • rw_speaker - project_id
  • rw_tag - rw_masterui.project_id -> rw_uimapping.tag_id -> rw_tag.id
  • rw_tagcategory - rw_masterui.project_id -> rw_tagcategory.id
  • rw_tag_loc_description - tag_id
  • rw_tag_loc_msg - tag_id
  • rw_tag_relationships - rw_masterui.project_id -> rw_uimapping.tag_id -> rw_tag_relationships.tag_id
  • rw_uimapping - master_ui_id
  • rw_uimode - all
  • rw_vote -> asset_id
Clone this wiki locally