CSV Import Error

ZeroHero · Post by **ZeroHero** » Tue Apr 06, 2010 10:18 pm

When I try to import a previously export of found duplicate files I get "Incorrect CSV file type/version".
I've found out, that this occurs, if you are running DC in non-English locale support, when the export is carried out.
During import - I take - the column headers are validated in respect to the vanilla english column headers!

dazedandconfused · Post by **dazedandconfused** » Fri Apr 09, 2010 12:29 pm

I've had the same error importing the list of all scanned files. When trying to import duplicates though I'm getting run time errors - run-time error 13 type mismatch. This has happened with two completely different files - both of which look fine in Excel. I don't think this is anything to do with language as I'm not running in any language other than English.

ZeroHero · Post by **ZeroHero** » Sat Apr 10, 2010 8:07 am

dazedandconfused:
I'm pretty sure that the error, I've encountered isn't caused by same as the error you describe. As soon as I manually translate the column headers from danish to english,
I can import the CSV file smoothly!

DV · Post by DV » Sun Apr 11, 2010 8:57 am

I've checked this and DC needs to have the language set the same for the import and export - so if you exported it in Danish, you need to import in Danish - it validates the column headers against the currently set language.

DV · Post by DV » Sun Apr 11, 2010 9:00 am

dazedandconfused:
I managed to replicate this by modifying a group number to a blank. If you have modified the file in excel and saved back out it might cause issues as well, eg date format.

dazedandconfused · Post by **dazedandconfused** » Mon Apr 12, 2010 11:48 am

Thanks for the reply. This is a great program but the import issue is driving me to distraction as I'm trying to rationalise a slow networked drive which has files from lots of other drives stored on it and thousands of duplicates. It takes a long time to identify the duplicates and longer to work through them so being able to use th import feature would be very helpful. It's not an excel issue as when I export the file from Duplicate Cleaner and immediately try to import it and it won't work. It picks up the first 4 or 5 matches but then gives the error (on the duplicate file display this is indicated 'behind' the error message by the filename of the 10th file appearing in the path column).

I only tried loading the file in excel to make sure it was OK.

If it makes any difference I am running 64bit Windows 7.

DV · Post by DV » Mon Apr 12, 2010 3:22 pm

If it's ok with you, you could send me the failing import file and I should be able to tell where the problem is and hopefully see if a bugfix is needed.

You can zip it and send to software AT digitalvolcano.co.uk - i'll treat the data as confidential.

dazedandconfused · Post by **dazedandconfused** » Tue Apr 13, 2010 9:10 am

Ok will do tonight when I get home. One thing I forgot to mention is that all the files are music files so it's using the audio search. I have deleted a lot of suplicates now so I'm running another scan today.

DV · Post by DV » Thu Apr 15, 2010 8:23 pm

The problem seems to be double quotes in song/artist titles. Working on a fix!

DV · Post by DV » Sun Apr 25, 2010 5:14 pm

Export double quotes is fixed in v1.4.5

http://www.digitalvolcano.co.uk/content ... loaddcmenu