Community mailing list archives

community@mail.odoo.com

Re: Import large file in Odoo

by
Abdul Qavi
- 11/20/2014 12:49:44
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.

Hope it helps.

Thanks,
Abdul

On Thu, Nov 20, 2014 at 10:38 PM, Jean-Sébastien Suzanne <jssuzanne@anybox.fr> wrote:


2014-11-20 18:32 GMT+01:00 Brian Martin <thebrianmartin@gmail.com>:
Almost better off to script it using the xmlrpc interface but even that will take time for a few thousand records. At least it won't crash. You can also tag stuff on insert easier if you script it.  
+1 
The other option is to generate SQL calls to insert the data. 
-1 
  

On Thu, Nov 20, 2014 at 12:23 PM, Mohammad Alhashash <alhashash@alhashash.net> wrote:

You may split the file into smaller batches and import them one after another.

Also, you create a modules that imports all files and watch the process through the log.

- Mohammad Alhashash

On 11/20/2014 07:07 PM, R&B Consulting wrote:
<blockquote cite="mid:CAO-dsHbVzkksq1LY41m_BkVBGkGhqXiRj==h+g5_3HkuNYwWSQ@mail.gmail.com" type="cite">
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.


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe




--
Jean-Sébastien SUZANNE
jssuzanne@anybox.fr

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe