Se rendre au contenu
Odoo Menu
  • Se connecter
  • Essai gratuit
  • Applications
    Finance
    • Comptabilité
    • Facturation
    • Notes de frais
    • Feuilles de calcul (BI)
    • Documents
    • Signature
    Ventes
    • CRM
    • Ventes
    • PdV Boutique
    • PdV Restaurant
    • Abonnements
    • Location
    Sites web
    • Site Web
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Chaîne d'approvisionnement
    • Inventaire
    • Fabrication
    • PLM
    • Achats
    • Maintenance
    • Qualité
    Ressources Humaines
    • Employés
    • Recrutement
    • Congés
    • Évaluations
    • Recommandations
    • Parc automobile
    Marketing
    • Marketing Social
    • E-mail Marketing
    • SMS Marketing
    • Événements
    • Marketing Automation
    • Sondages
    Services
    • Projet
    • Feuilles de temps
    • Services sur Site
    • Assistance
    • Planification
    • Rendez-vous
    Productivité
    • Discussion
    • Validations
    • Internet des Objets
    • VoIP
    • Connaissances
    • WhatsApp
    Applications tierces Odoo Studio Plateforme Cloud d'Odoo
  • Industries
    Commerce de détail
    • Librairie
    • Magasin de vêtements
    • Magasin de meubles
    • Épicerie
    • Quincaillerie
    • Magasin de jouets
    Food & Hospitality
    • Bar et Pub
    • Restaurant
    • Fast-food
    • Maison d’hôtes
    • Distributeur de boissons
    • Hôtel
    Immobilier
    • Agence immobilière
    • Cabinet d'architecture
    • Construction
    • Gestion immobilière
    • Jardinage
    • Association de copropriétaires
    Consultance
    • Cabinet d'expertise comptable
    • Partenaire Odoo
    • Agence Marketing
    • Cabinet d'avocats
    • Aquisition de talents
    • Audit & Certification
    Fabrication
    • Textile
    • Métal
    • Meubles
    • Alimentation
    • Brewery
    • Cadeaux d'entreprise
    Santé & Fitness
    • Club de sports
    • Opticien
    • Salle de fitness
    • Praticiens bien-être
    • Pharmacie
    • Salon de coiffure
    Trades
    • Bricoleur
    • Matériel informatique et support
    • Systèmes photovoltaïques
    • Cordonnier
    • Services de nettoyage
    • Services CVC
    Autres
    • Organisation à but non lucratif
    • Agence environnementale
    • Location de panneaux d'affichage
    • Photographie
    • Leasing de vélos
    • Revendeur de logiciel
    Browse all Industries
  • Communauté
    Apprenez
    • Tutoriels
    • Documentation
    • Certifications
    • Formation
    • Blog
    • Podcast
    Renforcer l'éducation
    • Programme éducatif
    • Business Game Scale-Up!
    • Rendez-nous visite
    Obtenir le logiciel
    • Téléchargement
    • Comparez les éditions
    • Versions
    Collaborer
    • Github
    • Forum
    • Événements
    • Traductions
    • Devenez partenaire
    • Services for Partners
    • Enregistrer votre cabinet comptable
    Nos Services
    • Trouver un partenaire
    • Trouver un comptable
    • Rencontrer un conseiller
    • Services de mise en œuvre
    • Références clients
    • Assistance
    • Mises à niveau
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Obtenir une démonstration
  • Tarification
  • Aide

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Comptabilité
  • Inventaire
  • PoS
  • Projet
  • MRP
All apps
Vous devez être inscrit pour interagir avec la communauté.
Toutes les publications Personnes Badges
Étiquettes (Voir toutl)
odoo accounting v14 pos v15
À propos de ce forum
Vous devez être inscrit pour interagir avec la communauté.
Toutes les publications Personnes Badges
Étiquettes (Voir toutl)
odoo accounting v14 pos v15
À propos de ce forum
Aide

Discussion on Data Migration Methods

S'inscrire

Recevez une notification lorsqu'il y a de l'activité sur ce poste

Cette question a été signalée
migrationdatamigrationv15v18
2 Réponses
761 Vues
Avatar
RGonzalez

Hello everyone, I hope you're all doing well.


I have an interesting requirement to discuss. I'm trying to migrate data from V15 to V18. The main problem is that the company that sold us V15 no longer exists, so I don't have the updated code for V18, which prevents me from using the Odoo.sh update process.


With this in mind, I only have the following options left: 

1. Pay for a perpetual V15 subscription for local or web use, maintaining data persistence.

2. Perform a schema-to-schema mapping to migrate all the information.

3. Manually upload all the data to the system using CSV and UI, setting computed data as editable to facilitate the loading of auto-generated data (sequences, amounts, etc.).


Each option has its advantages and disadvantages, both objectively and subjectively. 


1. Subscription Payment.

The company doesn't want to pay an extra membership fee just to maintain persistence. I tried a local installation, but the community version is obviously not compatible with our enterprise version, and this version requires a license. 


2. Schema-to-Schema Mapping.

This is a considerably lengthy and extremely methodical task, especially if data integrity is to be maintained. For our database, this would involve validating a total of 200 tables for mapping, with any number of columns. After this, migration scripts would need to be created for each model, although this is easier with AI. 


3. Manual Loading.

This, like the previous option, is considerably lengthy, but more mechanical than methodical. It would involve a total of two years' worth of data, and would only require manually setting up financial and inventory transaction data, since data such as customers, products, opportunities, quotes, and tickets can be easily handled via a script. In total, this would involve approximately 3,000 accounting entries. The good thing is that we could use an RPA to handle the setup record by record. The complexity lies in the computerized data; doing things manually could cause problems if the procedure isn't followed in the order it was executed. A practical example of this would be inventory operations, where the receipt date field is automatically assigned the current date. 

I've been thinking a lot about which of the last two options would be the most practical for a migration with a 3- to 4-month timeframe, and I'd love to have more perspectives to determine an option, or a new alternative.


Thank you in advance. Have a great weekend.

0
Avatar
Ignorer
Creyox Technologies

Hello,

Do you have access to your current Odoo.sh instance? How much customization have you implemented in v15?

Let us know, and we'll do our best to help you migrate to v18 with your existing data, without any unnecessary steps.

Thanks,
info@creyox.com

RGonzalez
Auteur

Hello, I hope you are well.


Thank you very much for your prompt response.


We have several customizations, practically the entire localization; however, we have developed our own localization and what we want is to migrate from one version to another using this new data schema as our target.

Avatar
Cybrosys Techno Solutions Pvt.Ltd
Meilleure réponse

Hi,


Migrating from Odoo 15 Enterprise to Odoo 18 without access to the original vendor’s code or Odoo.sh repository is indeed complex, especially since the enterprise version requires a valid license and code compatibility. Of the three options you’ve outlined, each has trade-offs depending on your priorities, cost, accuracy, and time.


Maintaining a perpetual subscription is the easiest way to preserve data integrity and ensure legal access to the codebase, but if the company refuses to pay, it’s not a viable path. The schema-to-schema migration (option 2) is the most technically accurate approach since it preserves relationships and dependencies across tables, but it demands deep database knowledge and time to validate all models. It’s best suited if data consistency and accounting traceability are top priorities.


The manual loading option (option 3) is more practical if you can tolerate some data loss in non-critical areas and rely mainly on high-level historical data (e.g., balances, inventory valuations, or sales summaries). Using RPA scripts or import templates could make this feasible within your 3–4 month timeframe, though care is needed with computed fields and transaction order.


In short, if your goal is accuracy and continuity, go with schema mapping and scripts; if you prioritize speed and simplicity, opt for manual imports with automation support. A hybrid approach, automating imports for master data and scripting key financial and stock movements,often offers the best balance for migrations like this.


Hope it helps

0
Avatar
Ignorer
Avatar
Ray Carnes (ray)
Meilleure réponse

You have several options:

1 - IDEAL / NO WORK AT ALL

It may be possible to keep a single read only license to your old system

  • Pros - easy to look things up, nothing new to learn
  • Cons - it is another system, so now things are in two places

2 - QUICKEST / EASIEST

Import Excel sheets of the relevant information into Odoo Spreadsheets via the Documents App

  • Pros - get access to what you need without much work to import
  • Cons - harder to search for things, not integrated well

3 - MORE WORK

Create a Studio App and import tables of CSV data

  • Pros - can use Odoo filtering and search, form and list and kanban views, can link to Customers via Smart buttons
  • Cons - takes more time

4 - EVEN MORE WORK

Import Monthly Trial Balances

  • Pros - you can run year on year comparisons
  • Cons - takes even more time

5 - THE MOST WORK

Import Transactions

  • Pros - works as if you were using Odoo the whole time
  • Cons - VERY VERY VERY time consuming, needs scripts, very advanced knowledge required, may not have a good return on investment 
0
Avatar
Ignorer
RGonzalez
Auteur

Hello, I hope you are well.

Thank you very much for your quick response.

I hadn't considered the idea of ​​having a single-user license, and it's not expensive at all, around $160 per year with all the applications.

Now, I'm wondering where to get the Enterprise version code to perform a local installation, because I've searched the official Odoo website, and it only shows up to version 16, and the GitHub link for Enterprise isn't working. And since the Community version doesn't have the Studio app, it will conflict with my database dump.

I was told this weekend that there's a page for Odoo partners where you can access the Enterprise version code.

I appreciate your previous help, and if you could help me with this last question, I would be very grateful.

Ray Carnes (ray)

Anyone with a valid subscription can download Odoo Enterprise from odoo.com/download

Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !

Créez un compte dès aujourd'hui pour profiter de fonctionnalités exclusives et échanger avec notre formidable communauté !

S'inscrire
Publications associées Réponses Vues Activité
Odoo Community 15 to 17 migration procedure ? Résolu
migration v15 v17
Avatar
Avatar
Avatar
Avatar
Avatar
5
juin 25
19684
How to migrate Odoo 14 DB to Odoo 15 DB Résolu
migration odoo v15
Avatar
Avatar
1
janv. 23
14243
Module migratior error Résolu
migration v14 v15
Avatar
Avatar
Avatar
3
sept. 22
4982
How to migrate custom addons from odoo12 to odoo15 from odoo.sh with existing data?
migration odoo12 v15
Avatar
0
juil. 22
3189
Migration from bitrix24 CRM to Odoo
crm migration v15
Avatar
Avatar
Avatar
2
nov. 23
5341
Communauté
  • Tutoriels
  • Documentation
  • Forum
Open Source
  • Téléchargement
  • Github
  • Runbot
  • Traductions
Services
  • Hébergement Odoo.sh
  • Assistance
  • Migration
  • Développements personnalisés
  • Éducation
  • Trouver un comptable
  • Trouver un partenaire
  • Devenez partenaire
À propos
  • Notre société
  • Actifs de la marque
  • Contactez-nous
  • Emplois
  • Événements
  • Podcast
  • Blog
  • Clients
  • Informations légales • Confidentialité
  • Sécurité.
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo est une suite d'applications open source couvrant tous les besoins de votre entreprise : CRM, eCommerce, Comptabilité, Inventaire, Point de Vente, Gestion de Projet, etc.

Le positionnement unique d'Odoo est d'être à la fois très facile à utiliser et totalement intégré.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now