Problem with special_item_id column

Suporte Dúvidas
,
1

Hi there!

First of all, thank you so much for your work, it’s been a pleasure to develop using your platform.

I’m writing this because I’ve been having an issue where the items in my collection are being duplicated instead of updated after uploading an excel, even though it has an special_item_row column.

Could you help me figure out why?

2

Hey @ouhenio, welcome to our Discourse :slight_smile:

Could you please share your CSV file (or at least a couple of lines of it), so we can take a look? One basic test to be done is to check if the IDs present on the column refer to your existing items IDs.

Also, do you see anything worth noting on the importer logs? You can access them at the Processes list.

BTW, thank you for posting in English! We can discuss in Spanish if you prefer (I use DeepL translator sometimes and we may even understand each other in Portuguese), but our developer team is probably more prepared to respond in English and may also be useful for new foreign users.

3

Hi @mateus.m.luna! I’ll stick to English for reference for future users. :blush:

It’s very likely were not using the internal IDs of the items in the db, since we just used our own invented ids in the special_item_id column. Where can I check the internal IDs of the items in Tainacan?

4

Oh, that explains the issue. You can obtain Tainacan internal IDs by simply exporting your Collection to CSV.

  1. Access the menu “Exporters” on the repository sidebar; OR
  2. Click on the Top Right corner inside your collection admin page, there should be an export icon.
5

It worked! Thank you so much for the help :blush:

1 curtida