Alistair Williamson

Hi Stiofan,

I came up with a way of deleting duplicates for non-Devs like me.

I identified the duplicates outside of GD using MS Access, created a ‘Duplicate CSV’ and update the published date for each listing to a future month.

I can now see and select the dupes as the posts appear as ‘Scheduled’ in the backend.

I have been selecting and moving the duplicate listings to the bin. However, I keep getting the 414 error message – please see image attached. Using ‘screen options’ I have limited my selection to 100 listings but still keep getting the error message ‘Request URL too long.’

Please can you assist?

Thx

Al

Sorry. There was a problem with the website earlier, 24/7management fixed it.

Sorry about Landing page….I made a mistake. 🙁

Hi Stiofan,

I have finished the import……but now have even more problems….

I started out with c. 75,000 listings and I now have 86,000 listings.

Even the new dedicated server setup will not handle a 75,000 listing import in one go.

But after 2 months of painful importing I finished the import a couple of days ago.

86,000 listings signals dupes 🙁

I have exported them all today as 5,000 listing CSV’s more seems unreliable.

Pasted them back together in Excel = OpenOffice doesn’t handle this number of rows at all well.

Imported the Excel into Access and checked against my own unique ID and I have c. 25,000 dupes!

We can blame ‘pilot error’ but this way of working – having to split files is fraught with risk. Equally there is no way of preventing or identifying dupes on import. I had so many problems with inadequate server spec – not clear from your documentation – so many crashes I can only assume that dupes crept in.

I think the only way forward is to start the import again. I can’t think of any way to dedupe and then find the ones I didn’t import?

Is there a quick way to delete all of the listings under one CPT please?

Going to bed.

Bests

Al

Yes.