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

CRM
e-Commerce
Бухгалтерия
Склад
PoS
Проекты
MRP

All apps

Все посты Люди Значки

Теги (Смотреть все)

odoo accounting v14 pos v15

Об этом форуме

Помощь

Error Can't Import Web Pages (Theres a Bug)

error import webpage

2 Ответы

3277 Представления

Johnny Solas

I tried to import some webpages data via this "Import File" in Website Module and the data came from exporting some webpages data from another odoo project. I followed this tutorial on how to do it "https://youtu.be/H2fXRXoSZiI" . Note I'm currently working in Odoo 18.

However I got this error " Missing required value for the field 'Page URL' (url) ".

I have done something to solve this problem

I tried to import the data without editing the data to be imported, got that error
tried to change the format of import file from XLSX to CSV, got that error
tried to change the header label to "Page/Page URL", "Page URL", "URL", and "url" got that error
already check the file if urls are missing, but there is a data
tried to remove "/", got that error

I'm already out of solutions to try. Please help me solve this problem. Thank you in advance.

Max Zagrebelny

This module from the Odoo App Store helps migrate website content from other Odoo instances, including static pages, blog posts, and product pages.

Link to the module:

https://apps.odoo.com/apps/modules/18.0/us_website_migration

Johnny Solas

Автор

I look more info in the logs and i found this

ERROR odoo_project odoo.sql_db: bad query: b'INSERT INTO "website_page" ("create_date", "create_uid", "footer_visible", "header_visible", "is_published", "view_id", "website_indexed", "write_date", "write_uid") VALUES (\'2025-02-15 13:41:59.952944\', 2, true, true, false, 1686, true, \'2025-02-15 13:41:59.952944\', 2) RETURNING "id"'

ERROR: null value in column "url" of relation "website_page" violates not-null constraint

DETAIL:  Failing row contains (380, null, 1686, 2, 2, null, null, null, null, f, t, null, null, t, t, null, 2025-02-15 13:41:59.952944, 2025-02-15 13:41:59.952944).

Apparently the column "url" was not in that insert query in which it lead to this problem. The page i was about to add has url of "/practice", but i could not see "/practice" as part in the query. With this i can say that this might be a bug.

Не оставайтесь в стороне – присоединяйтесь к обсуждению!

Создайте аккаунт сегодня, чтобы получить доступ к эксклюзивным функциям и стать частью нашего замечательного сообщества!

Регистрация

Похожие посты	Ответы	Просмотры
Importing Web Pages Seems Impossible Решено error import webpage	2 июл. 25	3689
Odoo12 babel error Решено error import	1 нояб. 19	8139
Bug following a contact import : column res_partner_bank.active doesn't exist error import	1 мар. 15	5253
error in installing only-office module error import bug	2 дек. 25	2376
odoo 19 import Error error import odoo19	3 нояб. 25	421

Этот вопрос был отмечен

Не оставайтесь в стороне – присоединяйтесь к обсуждению!