Migration scripts for v9

[pedrobaeza]

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:

• base - Done by @coleste, @hbrunn
• account - Partial covered by @coleste, completed by @hbrunn
• account_accountant - Nothing to do
• account_analytic_default - Nothing to do
• account_asset - Done by @hbrunn
• account_budget - Nothing to do
• account_cancel - Nothing to do
• account_chart (del) - By @cubells - [ADD] account_chart: migration scripts to 9.0 #1070
• account_check_writing > account_check_printing - Done by @hbrunn
• account_tax_cash_basis
• account_tax_python
• account_test
• account_voucher - Assigned to @jbeficent
• analytic - Assigned to @hbrunn
• anonymization
• association - By @pedrobaeza - [ADD] association: Nothing to do #911
• auth_crypt - Nothing to do
• auth_ldap - Nothing to do
• auth_oauth
• auth_signup - Done by @hbrunn
• barcodes - Nothing to do
• base_action_rule - Nothing to do
• base_gengo
• base_geolocalize
• base_iban - Nothing to do
• base_import - Nothing to do
• base_import_module - Nothing to do
• base_setup - Nothing to do
• base_vat
• board - Nothing to do
• bus - Done by @hbrunn
• calendar - Nothing to do
• claim_from_delivery - Done by @hbrunn
• crm - Completed by @hbrunn , @coleste
• crm_claim - Done by @hbrunn
• crm_partner_assign
• crm_project_issue
• decimal_precision - Nothing to do
• delivery - Done by @hbrunn
• document - Completed by @hbrunn
• event - By @cubells - [MIG] event: Migration scripts #712
• event_sale
• fetchmail - Nothing to do
• fleet - By @cubells - [MIG][9.0] fleet: add migration scripts #831
• gamification - By @cubells - [MIG][9.0] gamification: add changes in noupdate data #830
• gamification_sale_crm - By @cubells - [MIG][9.0] gamification_sale_crm: add migration scripts #832
• google_account
• google_calendar
• google_drive
• google_spreadsheet
• hr - Done by @coleste, @hbrunn
• hr_attendance - Done by @hbrunn
• hr_contract - Done by @hbrunn
• hr_equipment
• hr_expense - assigned to @jbeficent
• hr_gamification
• hr_holidays - Done by @hbrunn
• hr_payroll - Assigned to @jbeficent
• hr_payroll_account - Assigned to @jbeficent
• hr_recruitment - by @cubells [MIG] hr_recruitment module migration script #682
• hr_timesheet - assigned to @jbeficent
• hr_timesheet_sheet - assigned to @jbeficent
• hr_timesheet_invoice - obsolete. Create sale orders for any remaining invoicable lines
• hw_escpos
• hw_posbox_homepage
• hw_posbox_upgrade
• hw_proxy
• hw_scale
• hw_scanner
• im_livechat - By @NL66278 - [FIX] Add move of xml_id's to im_livechat. #737
• im_odoo_support
• l10n_fr - By @cubells - [ADD] l10n_fr: migration scripts #1068
• l10n_nl - By @StefanRijnhart - [IMP] Map more account types #1203
• link_tracker
• lunch
• mail - Completed by @hbrunn, @coleste
• mail_tip
• marketing - Nothing to do
• marketing_campaign - By @pedrobaeza - [ADD] marketing_campaign: Migration script #708
• marketing_campaign_crm_demo
• mass_mailing - By @cubells - 9.0 [MIG] mass_mailing migration scripts #677
• membership - By @mreficent - [9.0][ADD] membership: Nothing to do #919
• mrp - Assigned to @jbeficent
• mrp_byproduct - Nothing to do
• mrp_operations - Nothing to do
• mrp_repair - Nothing to do
• note - Nothing to do
• note_pad
• pad
• pad_project
• payment - By @cubells - [MIG] payment module migration script #675
• payment_adyen
• payment_authorize
• payment_buckaroo
• payment_ogone
• payment_paypal - By @pedrobaeza - [ADD] payment_paypal: Migration script #719
• payment_sips
• payment_transfer
• point_of_sale - By @sergio-teruel - [9.0][ADD] point_of_sale: Add script for migrate from v8 #694
• portal - By @cubells - [9.0][MIG] portal: migration scripts #1029
• portal_claim (deleted) - By @cubells - [9.0][MIG] portal_claim: Renamed to website_crm_claim #1021
• portal_gamification
• portal_sale
• portal_stock - By @cubells - [9.0][ADD] portal_stock: Migration to 9.0 #1018
• pos_cache
• pos_discount
• pos_mercury
• pos_reprint
• pos_restaurant - By @legalsylvain - [9.0] pos_restaurant : nothing to do #1645
• procurement - By @cubells - [MIG] procurement module migration scripts #672
• procurement_jit
• procurement_jit_stock - By @pedrobaeza - [ADD] procurement_jit_stock: Merged on procurement_jit #927
• product - Completed by @hbrunn
• product_email_template
• product_expiry
• product_extended
• product_margin
• product_uos
• product_visible_discount
• project - Completed by @hbrunn
• project_issue - Done by @hbrunn, @vincentcoll
• project_issue_sheet - Assigned to @hbrunn
• project_timesheet
• purchase - Assigned to @StefanRijnhart
• purchase_double_validation (del) - By @pedrobaeza - [9.0][ADD] purchase_double_validation: Migration scripts #2137
• purchase_requisition - Assigned to @StefanRijnhart
• rating
• rating_project
• rating_project_issue
• report - Nothing to do
• report_intrastat
• report_webkit - Nothing to do
• resource - Nothing to do
• sale - Completed by @coleste + @StefanRijnhart
• sale_crm - Assigned to @StefanRijnhart [ADD] Migration of sale_crm #625
• sale_expense
• sale_layout
• sale_margin - Nothing to do
• sale_mrp - Nothing to do - By @mreficent - [9.0][Upd] module coverage list #913
• sale_order_dates - Nothing to do
• sale_service - By @cubells - [MIG][9.0] sale_service: add migration scripts #833
• sales_team - Completed by @StefanRijnhart
• sale_stock - Completed by @StefanRijnhart
• sale_timesheet
• stock - Completed by @hbrunn
• stock_account - Done by @hbrunn
• stock_calendar
• stock_dropshipping
• stock_landed_costs - By @pedrobaeza - [9.0][OU-ADD] stock_landed_costs: Migration scripts #2971
• stock_picking_wave - By @cubells - [9.0][ADD] stock_picking_wave: Migration scripts #1016
• subscription - Nothing to do
• survey - By @cubells - [MIG] survey module migration script #674
• survey_crm
• theme_bootswatch
• theme_default
• utm - Nothing to do
• warning - Nothing to do
• web - Nothing to do
• web_analytics
• web_calendar - Nothing to do
• web_diagram - Nothing to do
• web_editor
• web_kanban - Nothing to do
• web_kanban_gauge
• web_planner - Nothing to do
• web_settings_dashboard
• website - By @pedrobaeza - [MIG] website: Migration scripts + changes for website #711
• website_blog - By @pedrobaeza - [ADD] website_blog: Migration scripts #720
• website_crm
• website_crm_claim - By @cubells - [9.0][MIG] portal_claim: Renamed to website_crm_claim #1021
• website_crm_partner_assign
• website_customer
• website_event
• website_event_questions
• website_event_sale
• website_event_track - By @pedrobaeza - [ADD] website_event_track: Migration scripts #721
• website_form
• website_forum
• website_forum_doc
• website_gengo
• website_google_map
• website_hr
• website_hr_recruitment
• website_issue
• website_links
• website_livechat
• website_mail
• website_mail_channel
• website_mass_mailing
• website_membership
• website_partner
• website_payment - By @cubells - [9.0][ADD] website_payment: Migration to 9.0 #1019
• website_portal
• website_portal_sale
• website_project_issue
• website_project_issue_sheet
• website_quote
• website_rating_project_issue
• website_report - By @pedrobaeza - [ADD] website_report: Migration script #722
• website_sale - By @cubells - [MIG] website_sale module migration script #676
• website_sale_delivery
• website_sale_digital
• website_sale_options
• website_sale_stock
• website_twitter
• web_tip - Nothing to do
• web_view_editor

OCA modules

• OCA/bank-statement-reconcile: bank_statement_period_from_line_date - Merged in account - By @cubells - [ADD] bank_statement_period_from_line_date: migration scripts to 9.0 #1071
• OCA/stock-logistics-workflow: stock_dropshipping_dual_invoice - Merged in stock_dropshipping - By @cubells - [ADD] stock_dropshipping_dual_invoice: merged into stock_dropshipping #1082
• OCA/sale-workflow: account_invoice_reorder_lines - Included in core - By @pedrobaeza - [9.0][ADD] account_invoice_reorder_lines #1210
• OCA/product-attribute: product_pricelist_fixed_price - Merged in product - By @pedrobaeza - [9.0][ADD] product_pricelist_fixed_price: Merged in product #1471

[Yenthe666]

@pedrobaeza and @StefanRijnhart I soon need a migration script from V8 to V9 so I was wondering how I could help and how this works. Note that my database knowledge is very limited but I would love to help in this. Could you guys give me information about how I should do this?

[pedrobaeza]

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

[dreispt]

I'm in a similar position to @Yenthe666 , but I think the base module is the place to start.

[coleste]

I started working on base

[pedrobaeza]

Cool! @StefanRijnhart, did you start also with that task for not duplicating efforts?

I started working on Project module today.

[pedrobaeza]

I assign you then on the main text. Tell us any doubt about it, but please open a new issue for specific things on a module migration.

Understood, thanks!

[dreispt]

@coleste @mel-microcom You're welcome to open a [WIP] PR, so that we can follow progress.

[coleste]

Done in #404 but there are bootstrap issues I think.

[mmalorni]

@pedrobaeza @StefanRijnhart please have a look at PR #405 and #407 as they are needed to get #404 to pass the tests.
Anyone else want to review?
Thanks,

[luanads]

Hi guys, what do you think about using zenhub.io to manage the migration scrips in different issues on a kanban board?

[mileo]

@luanads Take a look at: https://waffle.io/OCA/OpenUpgrade