OpenStudio import
This page will explain how to import your OpenStudio data into Costasiella. Please note that the import might override some information like details of your organization. It’s therefore strongly recommended to create a database & file backup of your Costasiella installation before proceeding any further.
Manual import
A few items can’t be migrated automatically and should therefore be migrated manually.
Settings
Mail templates
Events without a school location set
Event ticket earlybird discounts
School subscription price glaccount and costcenter information
Prices for drop-in classes & trial classes
Groups and group permissions
Data imported
Organization (school)
sys_organizations > organization
accounting_glaccounts > finance_glaccount
accounting_costcenters > finance_costcenter
tax_rates > finance_tax_rate
payment_methods > finance_payment_method
school_memberships > organization_membership
school_classcards > organization_classpass
school_classcards_groups > organization_classpass_group
school_classcards_groups_classcard > organization_classpass_group_classpass
school_classtypes > organization_classtype
school_discovery > organization_discovery
school_levels > organization_level
school_locations > organization_location (Add one room for each added location)
school_shifts > organization_shifts
school_subscriptions > organization_subscription
school_subscriptions_groups > organization_subscription_group
school_subscriptions_groups_subscriptions > organization_subscription_group_subscription
school_subscriptions_price > organization_subscription_price
Customer accounts
auth_user (customers) > account & all_auth_email
auth_user (businesses) > business
auth_user (teacher info) > account_instructor_profile
customers_classcards > account_classcard
customers_notes > account_note
customers_orders > finance_order
customers_orders_amounts > finance_order
customers_orders_items > finance_order_item
customers_orders_mollie_payment_ids > integration_log_mollie
customers_payment_info > account_bank_account
customers_payment_info_mandates > account_bank_account_mandate
customers_subscriptions > account_subscription
customers_subscriptions_alt_prices > account_subscription_alt_price
customers_subscriptions_blocked > account_subscription_block
customers_subscriptions_credits > account_subscription_credit
customers_subscriptions_paused > account_subscription_pause
Invoices
invoices_groups > finance_invoice_group
invoices_groups_product_types > finance_invoice_group_default
invoices > finance_invoice
invoices_amounts > finance_invoice
invoices_customers > finance_invoice
invoices_items > finance_invoice_item
invoices_items_customers_classcards > finance_invoice_item
invoices_items_customers_subscriptions > finance_invoice_item
invoices_items_workshop_products_customers > finance_invoice_item
invoices_payments > finance_invoice_payment
invoices_mollie_payment_ids > integration_log_mollie
Payment batches
payment_batches > finance_payment_batch
payment_batches_export > finance_payment_batch_export
payment_batches_items > finance_payment_batch_item
payment_categories > finance_payment_batch_category
alternativepayments > account_finance_payment_batch_category_item
Class schedule
classes > schedule_item
classes_mail > schedule_item
classes_attendance > schedule_item_attendance
invoices_items_classes_attendance > schedule_item_attendance
classes_otc > schedule_item_weekly_otc
classes_otc_mail > schedule_item_weekly_otc
classes_school_classcards_groups > schedule_item_organization_classpass_group
classes_school_subscriptions_groups > schedule_item_organization_subscription_group
classes_teachers > schedule_item_account
Staff schedule
shifts > schedule_item
shifts_otc > schedule_item_weekly_otc
shifts_staff > schedule_item_account
Events / workshops
workshops > schedule_event
workshops > schedule_event_media
workshops_mail > schedule_event
workshops_activities > schedule_item
workshop_activities_customers > schedule_item_attendance
workshops_products > schedule_event_ticket
workshops_products_activities > schedule_event_ticket_schedule_item
workshops_products_customers > account_schedule_event_ticket
Announcements
announcements > organization_announcements
customers_profile_announcements > organization_announcements
Import data
OpenStudio data can be imported using the openstudio_import management command.
./manage.py openstudio_import --db_name=<openstudio> --db_user=<user> --db_password=<password> --db_host=<openstudio db server> --os_uploads_folder=<path/to/web2py/applications/openstudio/uploads>
Review import log
After the import a new log file containing import errors (if any) will be available in the logs directory in the Costasiella application root folder.