Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
importing data from excel fileodoo12
3 Vastaukset
5689 Näkymät
Avatar
Szymon Wajerowski

I have created a simple table to import stock moves data into my Inventory app (I tried to do this according to the "How to import" FAQ; I'm creating new moves, not updating existing ones). You can take a look at the table which I uploaded as XLS file at following link: imgur.com/ExALwFn

I can't solve the red errors visible after testing the import.

    Ad. 1
    The WH/Stock record does exist for sure​ and is visible in the list after clicking the ​Get all possible values​ hyperlink (although it is red, if it matters)

    Ad. 2
    I have no idea what is the "name field" and why is it null. I have both external ID and reference fields filled​ with data.

    I'm working on Odoo 12.0 SaaS.

    I would be really grateful for any suggestion how to solve above issues and import the transfer successfully.

    Thanks!

    Avatar
    Hylkää
    Szymon Wajerowski
    Tekijä

    I have found a workaround - this table can be imported (with small amendments) to the Sales app as a quotation draft, which can be easily converted into a stock move. Although, this is not the best solution to solve this, so if anyone has an idea how to do it, suggestions are highly appreciated. Thanks!

    Avatar
    enerkey
    Paras vastaus

    You can check your external ID and update the setting also check your stock location. Sometimes such types of error I also faced and I changed my excel sheet setting. Next, I got a solution. But I have been faced another error [url=https://msofficetechnicalsupportnumbers.com/blog/how-to-fix-ms-excel-has-stopped-working-error/]MS Excel Has Stopped Working Error[/url] and could not be got a solution. got solution. Now I have done my excel sheet work properly. So if you got such types of error then you can access this site.

    Avatar
    Hylkää
    Avatar
    Chris TRINGHAM
    Paras vastaus

    You can set the stock location by using the External ID rather than the name (WH/Stock = stock.stock_location_stock).  

    Avatar
    Hylkää
    Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
    Problems when importing inventory adjustments
    inventory importing data from excel file odoo12
    Avatar
    Avatar
    		3
    heinäk. 19
    		2393
    Find database field names for Import/Export
    importing data from excel file
    Avatar
    		1
    maalisk. 25
    		117
    Import journal entries Excel Odoo.com
    importing data from excel file
    Avatar
    Avatar
    Avatar
    Avatar
    Avatar
    		4
    toukok. 24
    		8324
    Odoo Mail Sending Limit Ratkaistu
    odoo12
    Avatar
    Avatar
    Avatar
    		2
    jouluk. 23
    		16696
    (Document type: Invoice, Operation: write) - (Records: [], User: 2)
    odoo12
    Avatar
    		0
    lokak. 23
    		33