# \#Imports

**URL:** https://www.dolibarr.org/forum/tag/imports/84.md

[Latest](https://www.dolibarr.org/forum/latest.md) · [Categories](https://www.dolibarr.org/forum/categories.md) · [Tags](https://www.dolibarr.org/forum/tags.md)

---

## [Tools -\>Import-\> Update Third-party data fails - no updates performed, in spite of success message](https://www.dolibarr.org/forum/t/tools-import-update-third-party-data-fails-no-updates-performed-in-spite-of-success-message/30001)

<div class="topic-metadata">

**Author:** [@doli\_user\_12](https://www.dolibarr.org/forum/u/doli_user_12)\
**Replies:** 2\
**Last updated:** [February 20, 2025, 9:12am UTC](https://www.dolibarr.org/forum/t/tools-import-update-third-party-data-fails-no-updates-performed-in-spite-of-success-message/30001 "2025-02-20T09:12:35Z")

</div>

I’ve used the Tools-\>Import wizard successfully to import a large amount of Third Parties. After a while I wanted to update these same entries with additional information. When I select " Key (column) to use for updati…

---

## [Update issue P.label using Excel file](https://www.dolibarr.org/forum/t/update-issue-p-label-using-excel-file/29616)

<div class="topic-metadata">

**Author:** [@PimDolie](https://www.dolibarr.org/forum/u/PimDolie)\
**Replies:** 2\
**Last updated:** [November 22, 2024, 2:35am UTC](https://www.dolibarr.org/forum/t/update-issue-p-label-using-excel-file/29616 "2024-11-22T02:35:54Z")

</div>

HI, When i Update my product name’s From Name1 to Naaame1, Name2 to Naaame2, Name3 to Naaame3 etc . Dolibarr update’s but it’s not showing. As you can see in the picture’s (update sheet) when it passes the update…

---

## [Weird error message upon importing a child record](https://www.dolibarr.org/forum/t/weird-error-message-upon-importing-a-child-record/23325)

<div class="topic-metadata">

**Author:** [@AXELTI54](https://www.dolibarr.org/forum/u/AXELTI54)\
**Replies:** 0\
**Last updated:** [January 31, 2023, 10:36pm UTC](https://www.dolibarr.org/forum/t/weird-error-message-upon-importing-a-child-record/23325 "2023-01-31T22:36:48Z")

</div>

\> Cannot add or update a child row: a foreign key constraint fails (\`apps90094\_dol123\`.\`llxtr\_socpeople\`, CONSTRAINT \`fk\_socpeople\_fk\_soc\` FOREIGN KEY (\`fk\_soc\`) REFERENCES \`llxtr\_societe\` (\`rowid\`)) In particular, I ca…

---

## [Select "primary Key or Column" to import/Update product list](https://www.dolibarr.org/forum/t/select-primary-key-or-column-to-import-update-product-list/22572)

<div class="topic-metadata">

**Author:** [@mohamettarik](https://www.dolibarr.org/forum/u/mohamettarik)\
**Replies:** 0\
**Last updated:** [July 29, 2022, 5:46pm UTC](https://www.dolibarr.org/forum/t/select-primary-key-or-column-to-import-update-product-list/22572 "2022-07-29T17:46:42Z")

</div>

Hello, I am trying to import vendor price list to update current products, I would like to select different primary key/column than Ref or Barcode to avoid duplications and errors. Simply because i have no barcode data…

---

## [Issue with import](https://www.dolibarr.org/forum/t/issue-with-import/21827)

<div class="topic-metadata">

**Author:** [@mmamin](https://www.dolibarr.org/forum/u/mmamin)\
**Replies:** 4\
**Last updated:** [February 10, 2022, 2:33pm UTC](https://www.dolibarr.org/forum/t/issue-with-import/21827 "2022-02-10T14:33:45Z")

</div>

Hi, I’m trying to import old proposal, i managed to import Purchase orders with no errors, but when i try to import Puchase order lines i get the follwoing error 1 errors found Line 2 Unknown column ‘import\_key’ in…

---

## [How to find and edit rowid generated in export file by User export](https://www.dolibarr.org/forum/t/how-to-find-and-edit-rowid-generated-in-export-file-by-user-export/21534)

<div class="topic-metadata">

**Author:** [@dolibarrpavan](https://www.dolibarr.org/forum/u/dolibarrpavan)\
**Replies:** 1\
**Last updated:** [January 4, 2022, 2:07pm UTC](https://www.dolibarr.org/forum/t/how-to-find-and-edit-rowid-generated-in-export-file-by-user-export/21534 "2022-01-04T14:07:43Z")

</div>

After multiple imports and edits to the same user, the ID (llx\_user → rowid) generated in the export file has value which is not in serial number. For example, I have three users. I have imported another user next. Now…

---

## [Import Stocks Problem, Physical Stock still 0](https://www.dolibarr.org/forum/t/import-stocks-problem-physical-stock-still-0/21560)

<div class="topic-metadata">

**Author:** [@anggarifandi](https://www.dolibarr.org/forum/u/anggarifandi)\
**Replies:** 8\
**Last updated:** [December 13, 2021, 4:35am UTC](https://www.dolibarr.org/forum/t/import-stocks-problem-physical-stock-still-0/21560 "2021-12-13T04:35:34Z")

</div>

Hi, Currently I’m using Dolibarr 14.0.4 installed from Softaculous. I have read several post related my problem in this forum but still can’t figure it out the solution. These are the steps that I’ve taken: Import P…

---

## [Importing third parties and their properties](https://www.dolibarr.org/forum/t/importing-third-parties-and-their-properties/21515)

<div class="topic-metadata">

**Author:** [@nickp](https://www.dolibarr.org/forum/u/nickp)\
**Replies:** 4\
**Last updated:** [December 1, 2021, 9:30am UTC](https://www.dolibarr.org/forum/t/importing-third-parties-and-their-properties/21515 "2021-12-01T09:30:38Z")

</div>

Hi I’m struggling with UK addresses in my import csv for third parties and their properties. My biggest issue at the moment is column “L” State/Province code (s.fk\_departement) I am pretty sure I have set everyth…

---

## [Importing sales orders lines](https://www.dolibarr.org/forum/t/importing-sales-orders-lines/21416)

<div class="topic-metadata">

**Author:** [@shahawi273](https://www.dolibarr.org/forum/u/shahawi273)\
**Replies:** 0\
**Last updated:** [November 12, 2021, 2:28am UTC](https://www.dolibarr.org/forum/t/importing-sales-orders-lines/21416 "2021-11-12T02:28:45Z")

</div>

Hi, I am trying to import a sales order, I downloaded the template in excel format, Then deleted some unneeded columns. When I uploaded the file again with data in the import sales order lines I only get document ref in…

---

## [Import not working on Dolibarr 14.0.2](https://www.dolibarr.org/forum/t/import-not-working-on-dolibarr-14-0-2/21251)

<div class="topic-metadata">

**Author:** [@wilfrik2003](https://www.dolibarr.org/forum/u/wilfrik2003)\
**Replies:** 8\
**Last updated:** [September 30, 2021, 8:16pm UTC](https://www.dolibarr.org/forum/t/import-not-working-on-dolibarr-14-0-2/21251 "2021-09-30T20:16:36Z")

</div>

I am not able to import say product items on version 114.0.2 because the functions are greyed out. Can anyone please support
