When I export csv file I see all data in a row without colomns separated by coma, but how can I get as in demo video with colomns?
In Atachments two images: the first one is how I get now, the second is how I would get
I've run into problems when exporting / importing. I now have double the amount of products and when adding new products can not upload images. Is there a way to remove the falsely created products? I've deleted them but everything is still messed up...
Excel can indeed export invalid CSV . If you don't take care you could get tab delimited or ; delimited CSV with is strange by my opinion because CSV stands for 'Comma Separated Values'.
Google documents tables works always correctly.
If import incorrectly formatted file you can not predict what could happen.
Best is to open CSV file before import and to manually check if format is ok. I can recommend notepad++ for this operation.
I didn't use any software. I simply exported from VM Exel-Like Manager using "export csv". When later I used your import from "Update from CSV" to restore that file, a whole new bunch of product IDs appeared (your .csv export file was in no way altered).
I then deleted all of the wrongly created products in VM but now am having to use phpmyadmin to make tweaks to certain tables just to be able to add new products / images.
I'm hoping that the next VM update will fix the problem, otherwise a total rebuild of VM will be needed. I'll have to manually add the products again.
For all users I'd recommend running a full back up of your database before trying to restore "Update from CSV" (after using the VM Exel-Like Manager "export csv" functionality). Unfortunately, I didn't try adding new products for a while so wasn't aware of the problem and now my back up is not totally up to date.
On another note RE: "Excel can indeed export invalid CSV?" From what I know Excel is pretty well much established as the industry standard. It is relied on daily by millions to import/export important business/financial files. Users are not required to manually check exports before importing into accounting software such as xero / MYOB. Excels developers ensure correct/automatic integration with other products based on a set of industry standards (that's what we pay for).
RE: "If you don't take care?" It sounds more like to me that the developers of VM Exel-Like Manager need to take care. If you are suggesting that your software doesn't work correctly with certain industry standard software please make these products very, very clear to all of your users.
Unfortunately I'm now finding that VM Exel-Like Manager is now costing me about 3 times the time to adjust prices without using it as I'm having to dig deep to fix issues it's creating.
I'd recommend to all users to use VM Exel-Like Manager with great caution. It can wreck your VM store in a single click.