Manual project exporting

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.

Core Objects

• rw_project
• rw_asset
• rw_audiotrack
• rw_envelope
• rw_localizedstring
• rw_session
• rw_speaker
• rw_tag
• rw_timedasset
• rw_uigroup
• rw_uiitem
• rw_vote

Data Analysis Objects

• rw_event
• rw_listeninghistoryitem

Non Project Specific Objects

These might best be manually merged; often no merging will be required due to full overlap.

• rw_language
• rw_tagcategory
• rw_userprofile

---

• 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