Not all items are being imported

Hi Dairrell,

Can you look into the history tab of that importer, can you paste in how many inserts, updates, and deletes were ran?

James

Hi James,

Sure. Is this what you need?

Status: complete, Inserts: 377, Updates: 40, Time: 28s

Thanks,

You said you set the unique identifier to the content of the each record, which based on the history, you have 40 records that have matching content.

The unique identifier is used by the importer to find a record, and if a record exists then it will update it, otherwise it will insert it.

You should use a column or node in your file that is unique to each record, does your file have something like this? if not can you send your file over so i can look at what you are working with?

James

If the text might be the same for the desc, but not desc and category, you could select for the unique identifier "Select data from your import file to be used as the unique identifier per record", and set it to use all columns:

{0}-{1}-{2}

because you are changing the unqiue identifier, the previosly imported records will not match so it will create duplicates, i would recommend deleting the previously imported records.

Thanks for taking a look for the reply.

I deleted all of the current entries, changed the unique identifier as suggested, and ran the import again. This time it added 380 of the 416 entries. I've wasted a lot of time on this and I keep getting the same results. 

I looked at an old import from about a year ago and the permissions area didn't look like the current one. Has that changed in updates  to your software? You can see from the attachment below it appears there was an option for a default setting, but I don't see that now.

I feel like I don't have control over what I can import. If I have 416 entries that I KNOW that I want imported, why is the software making a determination for me? At least that's what it seems like.

Yes, the permissions unique identifier field has been updated, the default option would use the ID, post_name or post_title to identify each record from the template.

To let me see what you have setup with the unique identifier set to "{0}-{1}-{2}", can you please export and attach your importer settings to this ticket by going to Tools > Import WP > Settings / Tools > Import / Export and select and export your importer as a JSON file.

Thank you, Running that import locally i get the same amount of inserts and updates.

Looking through the history it shows me that there are many duplicates , when going through the csv for example i have just gone few some of them and there are many duplicate rows:

Lines: 6, 31

Lines: 117, 5,147

Lines: 13, 204

Thanks. The original file I had did have some duplicates, but in different categories. I ran the file through Claude.ai for a little help on categories and apparently that affected some of the entries.

Thanks for your help in finding the issue. May I ask what you used to find the duplicates?

If you click on the history tab of the importer, and view the history, search in the browser for the word "update", and it will show you each row of the csv table that is a duplicate.

Thanks for your help and your prompt responses. I appreciate your patience, considering it was not the software that was causing the issue. I'll be more diligent in the future about double checking my document before initiating an import.

AI is helpful, but not infallible, as I'm finding.