{"action":"created","issue":{"url":"https://api.github.com/repos/OCA/OpenUpgrade/issues/400","labels_url":"https://api.github.com/repos/OCA/OpenUpgrade/issues/400/labels{/name}","comments_url":"https://api.github.com/repos/OCA/OpenUpgrade/issues/400/comments","events_url":"https://api.github.com/repos/OCA/OpenUpgrade/issues/400/events","html_url":"https://github.com/OCA/OpenUpgrade/issues/400","id":117329118,"number":400,"title":"Migration scripts for v9","user":{"login":"pedrobaeza","id":7165771,"avatar_url":"https://avatars.githubusercontent.com/u/7165771?v=3","gravatar_id":"","url":"https://api.github.com/users/pedrobaeza","html_url":"https://github.com/pedrobaeza","followers_url":"https://api.github.com/users/pedrobaeza/followers","following_url":"https://api.github.com/users/pedrobaeza/following{/other_user}","gists_url":"https://api.github.com/users/pedrobaeza/gists{/gist_id}","starred_url":"https://api.github.com/users/pedrobaeza/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pedrobaeza/subscriptions","organizations_url":"https://api.github.com/users/pedrobaeza/orgs","repos_url":"https://api.github.com/users/pedrobaeza/repos","events_url":"https://api.github.com/users/pedrobaeza/events{/privacy}","received_events_url":"https://api.github.com/users/pedrobaeza/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-11-17T10:50:10Z","updated_at":"2015-11-23T12:49:41Z","closed_at":null,"body":"This issue summarizes the development of the migration scripts for v9. Please write down a comment if you want to develop a migration script for one module, to avoid duplicating efforts between the contributors. I have extracted the module list to have it as a reference for tracking the progress:\r\n\r\n* [ ] base\r\n* [ ] account\r\n* [ ] account_accountant\r\n* [ ] account_analytic_default\r\n* [ ] account_asset\r\n* [ ] account_bank_statement_import\r\n* [ ] account_budget\r\n* [ ] account_cancel\r\n* [ ] account_check_printing\r\n* [ ] account_tax_cash_basis\r\n* [ ] account_tax_python\r\n* [ ] account_test\r\n* [ ] account_voucher\r\n* [ ] analytic\r\n* [ ] anonymization\r\n* [ ] association\r\n* [ ] auth_crypt\r\n* [ ] auth_ldap\r\n* [ ] auth_oauth\r\n* [ ] auth_signup\r\n* [ ] barcodes\r\n* [ ] base_action_rule\r\n* [ ] base_gengo\r\n* [ ] base_geolocalize\r\n* [ ] base_iban\r\n* [ ] base_import\r\n* [ ] base_import_module\r\n* [ ] base_setup\r\n* [ ] base_vat\r\n* [ ] board\r\n* [ ] bus\r\n* [ ] calendar\r\n* [ ] claim_from_delivery\r\n* [ ] crm\r\n* [ ] crm_claim\r\n* [ ] crm_partner_assign\r\n* [ ] crm_project_issue\r\n* [ ] decimal_precision\r\n* [ ] delivery\r\n* [ ] document\r\n* [ ] event\r\n* [ ] event_sale\r\n* [ ] fetchmail\r\n* [ ] fleet\r\n* [ ] gamification\r\n* [ ] gamification_sale_crm\r\n* [ ] google_account\r\n* [ ] google_calendar\r\n* [ ] google_drive\r\n* [ ] google_spreadsheet\r\n* [ ] hr\r\n* [ ] hr_attendance\r\n* [ ] hr_contract\r\n* [ ] hr_equipment\r\n* [ ] hr_expense\r\n* [ ] hr_gamification\r\n* [ ] hr_holidays\r\n* [ ] hr_payroll\r\n* [ ] hr_payroll_account\r\n* [ ] hr_recruitment\r\n* [ ] hr_timesheet\r\n* [ ] hr_timesheet_sheet\r\n* [ ] hw_escpos\r\n* [ ] hw_posbox_homepage\r\n* [ ] hw_posbox_upgrade\r\n* [ ] hw_proxy\r\n* [ ] hw_scale\r\n* [ ] hw_scanner\r\n* [ ] im_livechat\r\n* [ ] im_odoo_support\r\n* [ ] l10n_ae\r\n* [ ] l10n_ar\r\n* [ ] l10n_at\r\n* [ ] l10n_au\r\n* [ ] l10n_be\r\n* [ ] l10n_be_hr_payroll\r\n* [ ] l10n_be_hr_payroll_account\r\n* [ ] l10n_be_intrastat\r\n* [ ] l10n_be_invoice_bba\r\n* [ ] l10n_bo\r\n* [ ] l10n_br\r\n* [ ] l10n_ca\r\n* [ ] l10n_ch\r\n* [ ] l10n_cl\r\n* [ ] l10n_cn\r\n* [ ] l10n_cn_small_business\r\n* [ ] l10n_cn_standard\r\n* [ ] l10n_co\r\n* [ ] l10n_cr\r\n* [ ] l10n_de\r\n* [ ] l10n_de_skr03\r\n* [ ] l10n_de_skr04\r\n* [ ] l10n_do\r\n* [ ] l10n_ec\r\n* [ ] l10n_es\r\n* [ ] l10n_et\r\n* [ ] l10n_eu_service\r\n* [ ] l10n_fr\r\n* [ ] l10n_fr_hr_payroll\r\n* [ ] l10n_generic_coa\r\n* [ ] l10n_gr\r\n* [ ] l10n_gt\r\n* [ ] l10n_hn\r\n* [ ] l10n_hr\r\n* [ ] l10n_hu\r\n* [ ] l10n_in\r\n* [ ] l10n_in_hr_payroll\r\n* [ ] l10n_it\r\n* [ ] l10n_jp\r\n* [ ] l10n_lu\r\n* [ ] l10n_ma\r\n* [ ] l10n_multilang\r\n* [ ] l10n_mx\r\n* [ ] l10n_nl\r\n* [ ] l10n_no\r\n* [ ] l10n_pa\r\n* [ ] l10n_pe\r\n* [ ] l10n_pl\r\n* [ ] l10n_pt\r\n* [ ] l10n_ro\r\n* [ ] l10n_sa\r\n* [ ] l10n_sg\r\n* [ ] l10n_si\r\n* [ ] l10n_syscohada\r\n* [ ] l10n_th\r\n* [ ] l10n_tr\r\n* [ ] l10n_uk\r\n* [ ] l10n_us\r\n* [ ] l10n_uy\r\n* [ ] l10n_ve\r\n* [ ] l10n_vn\r\n* [ ] link_tracker\r\n* [ ] lunch\r\n* [ ] mail\r\n* [ ] mail_tip\r\n* [ ] marketing\r\n* [ ] marketing_campaign\r\n* [ ] marketing_campaign_crm_demo\r\n* [ ] mass_mailing\r\n* [ ] membership\r\n* [ ] mrp\r\n* [ ] mrp_byproduct\r\n* [ ] mrp_operations\r\n* [ ] mrp_repair\r\n* [ ] note\r\n* [ ] note_pad\r\n* [ ] pad\r\n* [ ] pad_project\r\n* [ ] payment\r\n* [ ] payment_adyen\r\n* [ ] payment_authorize\r\n* [ ] payment_buckaroo\r\n* [ ] payment_ogone\r\n* [ ] payment_paypal\r\n* [ ] payment_sips\r\n* [ ] payment_transfer\r\n* [ ] point_of_sale\r\n* [ ] portal\r\n* [ ] portal_gamification\r\n* [ ] portal_sale\r\n* [ ] portal_stock\r\n* [ ] pos_cache\r\n* [ ] pos_discount\r\n* [ ] pos_mercury\r\n* [ ] pos_reprint\r\n* [ ] pos_restaurant\r\n* [ ] procurement\r\n* [ ] procurement_jit\r\n* [ ] product\r\n* [ ] product_email_template\r\n* [ ] product_expiry\r\n* [ ] product_extended\r\n* [ ] product_margin\r\n* [ ] product_uos\r\n* [ ] product_visible_discount\r\n* [ ] project\r\n* [ ] project_issue\r\n* [ ] project_issue_sheet\r\n* [ ] project_timesheet\r\n* [ ] purchase\r\n* [ ] purchase_requisition\r\n* [ ] rating\r\n* [ ] rating_project\r\n* [ ] rating_project_issue\r\n* [ ] report\r\n* [ ] report_intrastat\r\n* [ ] report_webkit\r\n* [ ] resource\r\n* [ ] sale\r\n* [ ] sale_crm\r\n* [ ] sale_expense\r\n* [ ] sale_layout\r\n* [ ] sale_margin\r\n* [ ] sale_mrp\r\n* [ ] sale_order_dates\r\n* [ ] sale_service\r\n* [ ] sales_team\r\n* [ ] sale_stock\r\n* [ ] sale_timesheet\r\n* [ ] stock\r\n* [ ] stock_account\r\n* [ ] stock_calendar\r\n* [ ] stock_dropshipping\r\n* [ ] stock_landed_costs\r\n* [ ] stock_picking_wave\r\n* [ ] subscription\r\n* [ ] survey\r\n* [ ] survey_crm\r\n* [ ] theme_bootswatch\r\n* [ ] theme_default\r\n* [ ] utm\r\n* [ ] warning\r\n* [ ] web\r\n* [ ] web_analytics\r\n* [ ] web_calendar\r\n* [ ] web_diagram\r\n* [ ] web_editor\r\n* [ ] web_kanban\r\n* [ ] web_kanban_gauge\r\n* [ ] web_planner\r\n* [ ] web_settings_dashboard\r\n* [ ] website\r\n* [ ] website_blog\r\n* [ ] website_crm\r\n* [ ] website_crm_claim\r\n* [ ] website_crm_partner_assign\r\n* [ ] website_customer\r\n* [ ] website_event\r\n* [ ] website_event_questions\r\n* [ ] website_event_sale\r\n* [ ] website_event_track\r\n* [ ] website_form\r\n* [ ] website_forum\r\n* [ ] website_forum_doc\r\n* [ ] website_gengo\r\n* [ ] website_google_map\r\n* [ ] website_hr\r\n* [ ] website_hr_recruitment\r\n* [ ] website_issue\r\n* [ ] website_links\r\n* [ ] website_livechat\r\n* [ ] website_mail\r\n* [ ] website_mail_channel\r\n* [ ] website_mass_mailing\r\n* [ ] website_membership\r\n* [ ] website_partner\r\n* [ ] website_payment\r\n* [ ] website_portal\r\n* [ ] website_portal_sale\r\n* [ ] website_project_issue\r\n* [ ] website_project_issue_sheet\r\n* [ ] website_quote\r\n* [ ] website_rating_project_issue\r\n* [ ] website_sale\r\n* [ ] website_sale_delivery\r\n* [ ] website_sale_digital\r\n* [ ] website_sale_options\r\n* [ ] website_sale_stock\r\n* [ ] website_slides\r\n* [ ] website_twitter\r\n* [ ] web_tip\r\n* [ ] web_view_editor\r\n"},"comment":{"url":"https://api.github.com/repos/OCA/OpenUpgrade/issues/comments/158925345","html_url":"https://github.com/OCA/OpenUpgrade/issues/400#issuecomment-158925345","issue_url":"https://api.github.com/repos/OCA/OpenUpgrade/issues/400","id":158925345,"user":{"login":"pedrobaeza","id":7165771,"avatar_url":"https://avatars.githubusercontent.com/u/7165771?v=3","gravatar_id":"","url":"https://api.github.com/users/pedrobaeza","html_url":"https://github.com/pedrobaeza","followers_url":"https://api.github.com/users/pedrobaeza/followers","following_url":"https://api.github.com/users/pedrobaeza/following{/other_user}","gists_url":"https://api.github.com/users/pedrobaeza/gists{/gist_id}","starred_url":"https://api.github.com/users/pedrobaeza/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pedrobaeza/subscriptions","organizations_url":"https://api.github.com/users/pedrobaeza/orgs","repos_url":"https://api.github.com/users/pedrobaeza/repos","events_url":"https://api.github.com/users/pedrobaeza/events{/privacy}","received_events_url":"https://api.github.com/users/pedrobaeza/received_events","type":"User","site_admin":false},"created_at":"2015-11-23T12:49:41Z","updated_at":"2015-11-23T12:49:41Z","body":"Sorry, but this is not very easy to achieve. There's a lot of work to do. You have to at least check that there are no changes on each of the modules you have installed in your v8 DB, and the ones that have changed their data layout, provide the corresponding scripts that transforms and manipulate data to adapt to the new layout. You have a bunch of examples in the migration scripts from previous versions, and basically is to programatically perform that changes via SQL, ORM or whatever you need. Check the available documentation: https://doc.therp.nl/openupgrade"}}