İçereği Atla
Odoo Menü
  • Portal
  • Ücretsiz deneyin
  • Uygulamalar
    Finans
    • Muhasebe
    • Faturalama
    • Masraf Yönetimi
    • Elektronik Çizelge (BI)
    • Belgeler
    • İmza
    Satış
    • Müşteri İlişkileri Yönetimi (CRM)
    • Satış
    • Satış Noktası Mağaza
    • Satış Noktası Restoran
    • Abonelikler
    • Kiralama
    Web Sitesi
    • Web Sitesi Oluşturucu
    • eTicaret
    • Blog
    • Forum
    • Canlı Sohbet
    • eÖğrenme
    Tedarik Zinciri
    • Envanter
    • Üretim
    • Ürün Yaşam Döngüsü Yönetimi
    • Satın Alma
    • Bakım
    • Kalite
    İnsan Kaynakları
    • Çalışanlar
    • İşe Alım
    • İzin
    • Değerlendirme
    • Referans
    • Filo Yönetimi
    Pazarlama
    • Sosyal Medyada Pazarlama
    • E-posta ile Pazarlama
    • SMS ile Pazarlama
    • Etkinlikler
    • Pazarlama Otomasyonu
    • Anket
    Hizmetler
    • Proje Yönetimi
    • Çalışma Çizelgeleri
    • Saha Hizmeti
    • Yardım Masası
    • Planlama
    • Randevular
    Verimlilik
    • Sohbet
    • Onay
    • Nesnelerin İnterneti
    • VoIP
    • Bilgi Bankası
    • WhatsApp
    Üçüncü taraf uygulamalar Odoo Stüdyo Odoo Bulut Platformu
  • Sektörler
    Perakende satış
    • Kitapçı
    • Giyim Mağazası
    • Mobilya Mağazası
    • Gıda Marketi
    • Hırdavat Dükkanı
    • Oyuncak Dükkanı
    Gıda ve Konaklama
    • Bar ve Pub
    • Restoran
    • Fast Food Restoranı
    • Konuk Evi
    • İçecek Distribütörü
    • Otel
    Gayrimenkul
    • Emlak Acentesi
    • Mimarlık Firması
    • İnşaat
    • Emlak Yönetimi
    • Bahçe Tasarımı
    • Mülk Sahipleri Derneği
    Uzmanlık
    • Muhasebe Firması
    • Odoo Partner
    • Pazarlama Ajansı
    • Hukuk Firması
    • Yetenek Kazanımı
    • Denetim ve Belgelendirme
    Üretim
    • Tekstil
    • Metal
    • Mobilyalar
    • Gıda
    • Bira fabrikası
    • Kurumsal Hediye
    Sağlık ve Spor
    • Spor Kulübü
    • Optik Mağazası
    • Fitness Merkezi
    • Sağlıklı Yaşam Merkezi
    • Eczane
    • Kuaför Salonu
    Ticaret
    • Tamirci
    • BT Donanım & Destek
    • Güneş Enerjisi Sistemleri
    • Ayakkabı İmalatçısı
    • Temizlik Hizmetleri
    • HVAC Hizmetleri
    Diğerleri
    • Kar Amacı Gütmeyen Kuruluş
    • Çevre Ajansı
    • Reklam Panosu Kiralama
    • Fotoğrafçılık
    • Bisiklet Kiralama
    • Yazılım Bayisi
    Tüm Sektörlere Göz Atın
  • Topluluk
    Öğrenim
    • Eğitim Araçları
    • Dokümantasyon
    • Sertifikasyonlar
    • Eğitim Etkinlikleri
    • Blog
    • Podcast
    Eğitim ve Gelişim
    • Eğitim Programı
    • Scale Up! İşletme Oyunu
    • Odoo'yu Ziyaret Edin
    Yazılım
    • İndirin
    • Sürümleri Kıyaslayın
    • Sürümler
    İş Birliği
    • Github
    • Forum
    • Etkinlikler
    • Çeviriler
    • Partner Olun
    • Partnerler için Hizmetler
    • Muhasebe Firmanızı Kaydettirin
    Hizmetler
    • Partner Bulun
    • Muhasebeci Bulun
    • Bir danışmanla görüşün
    • Kurulum Hizmetleri
    • Müşteri Referansları
    • Destek
    • Sürüm Yükseltme
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Demo randevusu alın
  • Fiyatlandırma
  • Yardım

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

  • Müşteri İlişkileri Yönetimi
  • e-Commerce
  • Muhasebe
  • Envanter
  • PoS
  • Proje Yönetimi
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Etiketler (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Etiketler (View all)
odoo accounting v14 pos v15
About this forum
Yardım

Discussion on Data Migration Methods

Abone Ol

Get notified when there's activity on this post

Bu soru işaretlendi
migrationdatamigrationv15v18
2 Cevaplar
683 Görünümler
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
Vazgeç
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
Üretici

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
En İyi Yanıt

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
Vazgeç
Avatar
Ray Carnes (ray)
En İyi Yanıt

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
Vazgeç
RGonzalez
Üretici

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

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Üye Ol
İlgili Gönderiler Cevaplar Görünümler Aktivite
Odoo Community 15 to 17 migration procedure ? Çözüldü
migration v15 v17
Avatar
Avatar
Avatar
Avatar
Avatar
5
Haz 25
19486
How to migrate Odoo 14 DB to Odoo 15 DB Çözüldü
migration odoo v15
Avatar
Avatar
1
Oca 23
14209
Module migratior error Çözüldü
migration v14 v15
Avatar
Avatar
Avatar
3
Eyl 22
4968
How to migrate custom addons from odoo12 to odoo15 from odoo.sh with existing data?
migration odoo12 v15
Avatar
0
Tem 22
3171
Migration from bitrix24 CRM to Odoo
crm migration v15
Avatar
Avatar
Avatar
2
Kas 23
5316
Topluluk
  • Eğitim Araçları
  • Dokümantasyon
  • Forum
Açık Kaynak
  • İndirin
  • Github
  • Runbot
  • Çeviriler
Hizmetler
  • Odoo.sh Hosting
  • Destek
  • Sürüm Yükseltme
  • Özel Geliştirmeler
  • Eğitim
  • Muhasebeci Bulun
  • Partner Bulun
  • Partner Olun
Hakkında
  • Şirketimiz
  • Pazarlama Gereçleri
  • İletişim
  • Kariyer
  • Etkinlikler
  • Podcast
  • Blog
  • Müşteriler
  • Hukuki • Gizlilik
  • Güvenlik
الْعَرَبيّة 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, müşteri ilişkileri yönetimi, eTicaret, muhasebe, envanter, satış noktası, proje yönetimi gibi şirketinizin tüm ihtiyaçlarını karşılayan bir açık kaynak işletme uygulamaları paketidir.

Odoo’nun eşsiz değer önermesi, aynı anda hem kullanımının çok kolay olup hem de tamamen entegre olmasıdır.

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