Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

2

Import large file in Odoo

By
jean44
on 11/20/14, 12:07 PM 1,192 views

Hello,

When I try to import a large file of 4000 lines in the journal entries, the system is stuck at loading until it displays the message 'please press the F5 key to refresh' and nothing happen after that. I can't figure out where is the problem !

Any help would be appreciated, thank you.

@Mos, You may want to check out this post: https://www.odoo.com/forum/help-1/question/csv-product-import-issues-import-preview-failed-due-to-field-larger-than-field-limit-131072-57081 It's more of a hack than a permanent solution, however it may function as a workaround until you find a proper solution. I have not tested this in production so i'd recommend a full filesystem and database backup before trying it.

Luke Branch
on 11/21/14, 9:51 PM
4
Pierre Lamarche
On 11/20/14, 12:34 PM

Hello,

You should change the time out limit on the server configuration which is defined by default at 300 seconds.

To import large files, you can shoot it at something like 5000 seconds in order to let the file finish to import.

I know it has already solved some problem of import for us...

Hope it is going to work for you !

Pierre

 

2
Abdul Qavi
On 11/20/14, 1:00 PM

I had this problem when I was importing 300,000 records. You've two options:

 

1. First option, and better one in your case: Divide the 4000 in smaller chunks and import.

2. Use a Tool like "Navicat for Postgres" or "pgAdmin3" to import data using Postgresql. You don't have to write SQL yourself, rather these tools provide you all the fields and you can carry on without writing any SQL.

 

Hope it helps.

 

Thanks,

Abdul

1
jean44
On 11/27/14, 9:02 AM

Thank you for your replies, please where I can change the time out limit in Odoo ?

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

Asked: 11/20/14, 12:07 PM
Seen: 1192 times
Last updated: 8/19/16, 2:01 AM