Skip ke Konten
Odoo Menu
  • Login
  • Uji coba gratis
  • Aplikasi
    Keuangan
    • Akuntansi
    • Faktur
    • Pengeluaran
    • Spreadsheet (BI)
    • Dokumen
    • Tanda Tangan
    Sales
    • CRM
    • Sales
    • POS Toko
    • POS Restoran
    • Langganan
    • Rental
    Website
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Rantai Pasokan
    • Inventaris
    • Manufaktur
    • PLM
    • Purchase
    • Maintenance
    • Kualitas
    Sumber Daya Manusia
    • Karyawan
    • Rekrutmen
    • Cuti
    • Appraisal
    • Referensi
    • Armada
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Acara
    • Otomatisasi Marketing
    • Survei
    Layanan
    • Project
    • Timesheet
    • Layanan Lapangan
    • Meja Bantuan
    • Planning
    • Appointment
    Produktivitas
    • Discuss
    • Approval
    • IoT
    • VoIP
    • Pengetahuan
    • WhatsApp
    Aplikasi pihak ketiga Odoo Studio Platform Odoo Cloud
  • Industri-Industri
    Retail
    • Toko Buku
    • Toko Baju
    • Toko Furnitur
    • Toko Kelontong
    • Toko Hardware
    • Toko Mainan
    Makanan & Hospitality
    • Bar dan Pub
    • Restoran
    • Fast Food
    • Rumah Tamu
    • Distributor Minuman
    • Hotel
    Real Estate
    • Agensi Real Estate
    • Firma Arsitektur
    • Konstruksi
    • Estate Management
    • Perkebunan
    • Asosiasi Pemilik Properti
    Konsultansi
    • Firma Akuntansi
    • Mitra Odoo
    • Agensi Marketing
    • Firma huku
    • Talent Acquisition
    • Audit & Sertifikasi
    Manufaktur
    • Tekstil
    • Logam
    • Perabotan
    • Makanan
    • Brewery
    • Corporate Gift
    Kesehatan & Fitness
    • Sports Club
    • Toko Kacamata
    • Fitness Center
    • Wellness Practitioners
    • Farmasi
    • Salon Rambut
    Perdagangan
    • Handyman
    • IT Hardware & Support
    • Sistem-Sistem Energi Surya
    • Pembuat Sepatu
    • Cleaning Service
    • Layanan HVAC
    Lainnya
    • Organisasi Nirlaba
    • Agen Lingkungan
    • Rental Billboard
    • Fotografi
    • Penyewaan Sepeda
    • Reseller Software
    Browse semua Industri
  • Komunitas
    Belajar
    • Tutorial-tutorial
    • Dokumentasi
    • Sertifikasi
    • Pelatihan
    • Blog
    • Podcast
    Empower Education
    • Program Edukasi
    • Game Bisnis 'Scale Up!'
    • Kunjungi Odoo
    Dapatkan Softwarenya
    • Download
    • Bandingkan Edisi
    • Daftar Rilis
    Kolaborasi
    • Github
    • Forum
    • Acara
    • Terjemahan
    • Menjadi Partner
    • Layanan untuk Partner
    • Daftarkan perusahaan Akuntansi Anda.
    Dapatkan Layanan
    • Temukan Mitra
    • Temukan Akuntan
    • Temui penasihat
    • Layanan Implementasi
    • Referensi Pelanggan
    • Bantuan
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Dapatkan demo
  • Harga
  • Bantuan

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

  • CRM
  • e-Commerce
  • Akuntansi
  • Inventaris
  • PoS
  • Project
  • MRP
All apps
Anda harus terdaftar untuk dapat berinteraksi di komunitas.
Semua Post Orang Lencana-Lencana
Label (Lihat semua)
odoo accounting v14 pos v15
Mengenai forum ini
Anda harus terdaftar untuk dapat berinteraksi di komunitas.
Semua Post Orang Lencana-Lencana
Label (Lihat semua)
odoo accounting v14 pos v15
Mengenai forum ini
Help

Creating a custom product.product by demo xml file?

Langganan

Dapatkan notifikasi saat terdapat aktivitas pada post ini

Pertanyaan ini telah diberikan tanda
salesproductdemodata
11 Replies
11271 Tampilan
Avatar
Tihomir Stoychev Stoychev

Hello Team im trying to create a product but by xml file, i know its possible but its giving me the next error : 


odoo.tools.convert.ParseError: "null value in column "purchase_line_warn" violates not-null constraint

DETAIL:  Failing row contains (88, Valencia Product, 1, null, null, null, service, f, 1, 1.00, null, null, t, t, 1, 1, 1, t, null, null, null, null, 1, 2019-01-17 10:52:47.369262, 1, 2019-01-17 10:52:47.369262, manual, no-message, null, no, order, 1, 0, none, null, null, null, null, null, null, null, null, null).

My code is the following:

<?xml version="1.0" encoding="utf-8"?>
<odoo>
<data>
<record
model="product.product" id="hotels_be_bago.product1">
<field
name="name">Valencia Product</field>
<field
name="type">service</field>
<field
name="purchase_line_warn">1</field>
<field
name="sale_line_warn">no-message</field>
</record>

</data>
</odoo>
Why is telling me that is null when i have value 1 set on it?

Thanks for the help    
1
Avatar
Buang
Avatar
Rakesh Vadeghar
Jawaban Terbai

I solved this error by putting 'depends': ['sale'], in manifest file

2
Avatar
Buang
Mohamed Bessou

Thanks that works

Avatar
Cybrosys Techno Solutions Pvt.Ltd
Jawaban Terbai

Hi,

The error message says that the field named "purchase_line_warn" is not getting the value and it is a required field, so it is mandatory to supply the value for that field.
Checking your data file, it seems you have given 1 for the field purchase_line_warn . The value that can be accepted by this field are 'no-message' ,  'warning' or 'block'



Sample,

<odoo>
<data noupdate="1">
<record model="product.product" id="hotels_be_bago.product1">
<field name="name">Valencia Product</field>
<field name="type">service</field>
<field name="purchase_line_warn">warning</field>
<field name="sale_line_warn">no-message</field>
</record>

</data>
</odoo>

So update the code accordingly and try. Once everything is okay, give noupdate="1" for the data file.


Thanks

1
Avatar
Buang
Tihomir Stoychev Stoychev
Penulis

odoo.tools.convert.ParseError: "null value in column "purchase_line_warn" violates not-null constraint

DETAIL: Failing row contains (96, Valencia Product, 1, null, null, null, service, f, 1, 1.00, null, null, t, t, 1, 1, 1, t, null, null, null, null, 1, 2019-01-17 11:10:42.859666, 1, 2019-01-17 11:10:42.859666, manual, no-message, null, no, order, 1, 0, none, null, null, null, null, null, null, null, null, null).

" while parsing /var/lib/odoo/modules/hotels_be_bago/demo/demoProducto.xml:4, near

<record model="product.product" id="hotels_be_bago.product1">

<field name="name">Valencia Product</field>

<field name="type">service</field>

<field name="purchase_line_warn">warning</field>

<field name="sale_line_warn">no-message</field>

</record>

Cybrosys Techno Solutions Pvt.Ltd

Can you check the same in new db also change the id of the record to 'custom_pro1' and see

Tihomir Stoychev Stoychev
Penulis

Keeps saying the same even i changed the db and the id

odoo.tools.convert.ParseError: "null value in column "purchase_line_warn" violates not-null constraint

DETAIL: Failing row contains (102, Valencia Product, 1, null, null, null, service, f, 1, 1.00, null, null, t, t, 1, 1, 1, t, null, null, null, null, 1, 2019-01-17 12:10:23.841209, 1, 2019-01-17 12:10:23.841209, manual, no-message, null, no, order, 1, 0, none, null, null, null, null, null, null, null, null, null).

" while parsing /var/lib/odoo/modules/hotels_be_bago/demo/demoProducto.xml:4, near

<record model="product.product" id="custom_pro1">

<field name="name">Valencia Product</field>

<field name="type">service</field>

<field name="purchase_line_warn">warning</field>

<field name="sale_line_warn">no-message</field>

</record>

Reinhart

Have you managed to solve this?

Avatar
Guillaume Seran
Jawaban Terbai

Hello,

this error message appear if you have already installed your module !

If you uninstalled and installed your module you will not have an error!

1
Avatar
Buang
Avatar
Maks
Jawaban Terbai

He is right (guy whit kung-fu panda image. Odoo forum is so pathetic that I cannot comment his post or address him in mine)! I had the same issue. If you want to keep updating your module, you have to add noupdate='1' in data tag, but remember that after this everything in this data tag will not be updated while module update.

0
Avatar
Buang
Avatar
Tihomir Stoychev Stoychev
Penulis Jawaban Terbai

It tells me the same...


odoo.tools.convert.ParseError: "null value in column "purchase_line_warn" violates not-null constraint

DETAIL:  Failing row contains (96, Valencia Product, 1, null, null, null, service, f, 1, 1.00, null, null, t, t, 1, 1, 1, t, null, null, null, null, 1, 2019-01-17 11:10:42.859666, 1, 2019-01-17 11:10:42.859666, manual, no-message, null, no, order, 1, 0, none, null, null, null, null, null, null, null, null, null).

" while parsing /var/lib/odoo/modules/hotels_be_bago/demo/demoProducto.xml:4, near

<record model="product.product" id="hotels_be_bago.product1">

<field name="name">Valencia Product</field>

<field name="type">service</field>

<field name="purchase_line_warn">warning</field>

<field name="sale_line_warn">no-message</field>

</record>


0
Avatar
Buang
Avatar
Reinhart
Jawaban Terbai

I'm having the same probem, didn't even have the warning config activated, but seems is a base field, but:

<field name="purchase_line_warn">no-message</field>

doesn't work at all.

Also the field is declared with a default 'no-message' value :

    purchase_line_warn = fields.Selection(WARNING_MESSAGE, 'Purchase Order Line', help=WARNING_HELP, required=True, default="no-message")

Shouldn't take the default value if the field is missed?

0
Avatar
Buang
Avatar
Kevin Cardona
Jawaban Terbai

I solved it adding to the _manifest__.py on the "depends" key the purchase module, seems like odoo creates like an "environment" when updating a module and that environment only has whatever the depends key value in the manifest  indicates, so if you have installed the purchase module and then you reinstall a module that creates a new product and you dont have added in the key depends the purchase module, it will not detect all the fields that purchase have added, in this specific case purchase_line_warn, and since the field has a not null constraint the database will raise an exception.

I dont know why odoo developed like this, but not seems to be good. Hope this helps someone who affronts this problem too.


0
Avatar
Buang
Menikmati diskusi? Jangan hanya membaca, ikuti!

Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!

Daftar
Post Terkait Replies Tampilan Aktivitas
Conditionally show or hide product attributes (Odoo Online/Studio)
sales product
Avatar
Avatar
1
Okt 25
813
Hide the cost
sales product
Avatar
Avatar
Avatar
2
Mei 25
4612
Products in multi company
sales product
Avatar
0
Nov 24
1572
how to filter out all products which got no sales with the last 3 months or a specific period?
sales product
Avatar
Avatar
1
Agu 24
2422
Difference between Product Type and Product Category Diselesaikan
sales product
Avatar
Avatar
1
Agu 24
4617
Komunitas
  • Tutorial-tutorial
  • Dokumentasi
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Terjemahan
Layanan
  • Odoo.sh Hosting
  • Bantuan
  • Peningkatan
  • Custom Development
  • Pendidikan
  • Temukan Akuntan
  • Temukan Mitra
  • Menjadi Partner
Tentang Kami
  • Perusahaan kami
  • Aset Merek
  • Hubungi kami
  • Tugas
  • Acara
  • Podcast
  • Blog
  • Pelanggan
  • Hukum • Privasi
  • Keamanan
الْعَرَبيّة 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 adalah rangkaian aplikasi bisnis open source yang mencakup semua kebutuhan perusahaan Anda: CRM, eCommerce, akuntansi, inventaris, point of sale, manajemen project, dan seterusnya.

Mudah digunakan dan terintegrasi penuh pada saat yang sama adalah value proposition unik Odoo.

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