CSV importer is broken and functionality is worse than DMO
The letter which you sent out back in December said that Click and Drop has all the functionality of DMO - and more. It does not and the functionality that's there is broken or incomplete.
When I try to import a CSV file which has empty columns in some of the rows (eg. Address 2 and Address 3 might be blank in some cases), the importer is incorrectly ignoring the columns for that row, thereby shifting the subsequent columns to the left. The CSV file is done to the normal specification, eg.:
"12 High Street","","","Newtown","NT1 1NT"
But if you just import that one, it doesn't see columns 2 and 3 at all. If you import a file with a mixture of 1, 2 and 3 line addresses and set up the columns for 3 line addresses, anything with less than 3 has the City, Postcode and any other subsequent columns shifted along to the left.
Next problem, there's no mapping for service enhancements to come from the CSV to Click & Drop. I was told this can be done manually, but this is not an option.
Another problem is that a DMO shipment could contain a number of items and one label would be printed for each. There's no way of setting the number of items with Click & Drop.
Everything I'm reading on here confirms my initial statement that with just over two weeks to go until the deadline, Click & Drop does not currently replace DMO and until it performs all of the functionality of DMO properly, you need to extend DMO's availability indefinitely.
We're not interested in an order processing system, which is what Click & Drop seems to be. We just need to be able to book shipments in from a CSV file like DMO does. Having to go via Dropbox has added another layer of complication to things and if that goes down (which it does from time to time), that will break the import process. It's an unnecessary over-complication.
An update has been made to the file import functionality in Click & Drop:
- It is now possible to save a file mapping as default so that any files uploaded with empty columns will be recognised
- Alternative date formats can be selected
- Service Enhancements can now be mapped
If you have any questions regarding this please do not hesitate to contact the Support Team at firstname.lastname@example.org
The Click & Drop Team
+1 Dan, use a header line. Also if your having problems try switching to semicolon as the deliminator
Have exactly the same problem with shifting parameter positions, when some positions are blank...Thought we were going mad. Was never a problem with DMO on demand. It's a good thing we have PPI as a backup solution in our software, because Click n Drop on Demand / Import is not ready.
Also, why is there not a weight (grams) option as an alternative to weight (kg) - Our software always provides weight in grams!
Dan Austin commented
2 things regarding your csv; Am I right in assuming you are using quotation marks as in the example?
I've not had this issue myself but I am using a header line. As the header has all values populated, it seems that it avoids this problem. Maybe give that a try?
I agree it shouldn't foul up with empty entries though. Sill not sure what the whole reason is for using Dropbox instead of something like FTP.
R Candy commented
Agreed the implementation is incomplete and a bit of a dogs dinner. It seems to be designed for people who only need to occasionally generate postage labels. Anyone doing 100s of orders a day is worse of with this system. I don't need something that tries to manage my orders and inventory. I have all that in a better system already. I just one something that quickly and easily generates a shopping label with the same options that I have in DMO. We're contacting our account manager and asking for a better solution ./ stay of execution