Resolved Joomla Content: Wrong export file with issues

Ahhhhh, I understand. So field in export and import template have to be the same, is this right? I will try all my templates at the weekend. I also have more like: VM manufactueres, products and so on. I will try it and get back to you on monday. Thx fur your support and have a nice weekend.

Hello,

So field in export and import template have to be the same, is this right?

Yes, you have to export all the fields you need from your old shop and use the file to import into your new shop so you move all the data.

Good morning,

I have tested the settings with exporet and import fields being the same, please see: https://gyazo.com/149914a65442006e92c4adf69bf5eefe

But no "alt-text" again... https://gyazo.com/8b48a1a7d60dfd61ef72f24a6fa204f8

I have sent you the export file and the logfile via e-mail, hope we will get it fixed!

Have a nice weekend,
B. Braun

Hello Braun,
There is still no file_meta field in your import file, you need to have this field in your import file like other fields so CSVI imports it into your database. Please add this field to your import file and then try the import.

Hello Braun,
The problem was that all media fields were not supported in VirtueMart category export and so you were not seeing file_meta field in your export file which in turn did not import this field in to your new shop. I applied a patch in your live shop site in CSVI maintenance menu and now your export file shows file_meta field. Try doing a fresh export from your old shop and do an import to your new shop. That would solve your issue problem with alt-text.

There you go!!! https://gyazo.com/98c0c3d33b3671ef252c8334320e9822

Great, thx! So do I have to input the field also in the VM product export or is it now still available and activated?

Hello,

So do I have to input the field also in the VM product export or is it now still available and activated?

These fields are already available in VM product export, you need to add them to your template fields and export it so you can import to your new shop.

Allright, thx. At the momnent I have one issue with the category import, the pics in the "category layout" view are missing, please see: https://gyazo.com/ed4b0cd00f8e814d0b191a0e9c3ab6da

I have attached the export file for you. I have also problems with importing the manufactueres. I guess I firt havo to import the categories and manufactueres BEFORE the procuts, cause they need the datas, right?

Hello,

At the momnent I have one issue with the category import, the pics in the "category layout" view are missing, please see: http://gyazo.com/ed4b0cd00f8e814d0b191a0e9c3ab6da

Is your medias published? Check if your media files are published else use media_published field in your import file and set the value to 1 so your images are published.

I have also problems with importing the manufactueres.

Can you post the manufacturer CSV file too? Debug log shows there is nothing processed so need to check what is in import file.

I guess I firt havo to import the categories and manufactueres BEFORE the procuts, cause they need the datas, right?

Yes, this way product will be linked to manufacturer and categories if data is already there.

Hello,

Is your medias published? Check if your media files are published else use media_published field in your import file and set the value to 1 so your images are published.
Where do I have to look for (published)? I have used media_published now, but can't see them either.

Can you post the manufacturer CSV file too? Debug log shows there is nothing processed so need to check what is in import file.
Sure, my fault! There you go.

Yes, this way product will be linked to manufacturer and categories if data is already there.
Allright, thx, this is what I want to do.

Hello,

Is your medias published? Check if your media files are published else use media_published field in your import file and set the value to 1 so your images are published.
Where do I have to look for (published)? I have used media_published now, but can't see them either.

You can see the published field in VirtueMart >> Product categories >> click on category >> Images tab, under image information, file published? as a checkbox. Can you post the debug log of import with media_published field?

For manufacturer import you don't have any manufacturer related fields. The import file just has file_url and file_url_thumb which is not enough. Please have a look at import VirtueMart manufacturer to know on the required fields for manufacturer import. You need to have the required fields along with file_url and file_url_thumb so manufacturers are created in your new shop and the corresponding images are linked.

Hello,

OK I see the problem now... https://gyazo.com/5070f057a8e742a47901d77dfba2764d file is not published and the field: "Einzigartiger Dateiname" is missing. I have now made a new importfile. The field "published" is now activated and the pics are here https://gyazo.com/432348839d3e7ff603536e79f72e1846. Which field do I have to add for "Einzigartiger Dateiname"?

I looked at your tutorial for the manufacturers, thx for that.The field "mf_name" was missed... I can now see the manufaturers, but no pics and also no "alt-text" and "Einzigartiger Dateiname", please see.https://gyazo.com/7ca2c1366301cea7a271f08037958d16

You can look tino the files here. Thx, ave a nice day, I'll be back tomorrow.

Logfile: http://beast-supplements.de/com_csvi.log.41.txt

Hello,

OK I see the problem now... http://gyazo.com/5070f057a8e742a47901d77dfba2764d file is not published and the field: "Einzigartiger Dateiname" is missing. I have now made a new importfile. The field "published" is now activated and the pics are here http://gyazo.com/432348839d3e7ff603536e79f72e1846 . Which field do I have to add for "Einzigartiger Dateiname"?

You need to use file_title field for "Einzigartiger Dateiname".

I looked at your tutorial for the manufacturers, thx for that.The field "mf_name" was missed... I can now see the manufaturers, but no pics and also no "alt-text" and "Einzigartiger Dateiname", please see. http://gyazo.com/7ca2c1366301cea7a271f08037958d16

The manufacturer image was taking duplicate path in import so images has not worked. Please load the attached patch file using CSVI maintenance menu and update your available fields in both of your sites, the old shop and new shop. After that add file_meta and file_title fields to your export fields in your old shop to get alt-text and Einzigartiger Dateiname and import in to your new shop.

patch_manufacturer_media_2016_12_06.zip

Hello,

OK I see the problem now... http://gyazo.com/5070f057a8e742a47901d77dfba2764d file is not published and the field: "Einzigartiger Dateiname" is missing. I have now made a new importfile. The field "published" is now activated and the pics are here http://gyazo.com/432348839d3e7ff603536e79f72e1846 . Which field do I have to add for "Einzigartiger Dateiname"?

You need to use file_title field for "Einzigartiger Dateiname" [color=red]Working!![/color]

The manufacturer image was taking duplicate path in import so images has not worked. Please load the attached patch file using CSVI maintenance menu and update your available fields in both of your sites, the old shop and new shop. After that add file_meta and file_title fields to your export fields in your old shop to get alt-text and Einzigartiger Dateiname and import in to your new shop. [color=red]That was easy to fix and is also working![/color]

We are coming closer and closer. So at the moment I have one more issue in the category import and the manufacturer import. The path of the minithumb URLs are incorrect. Please see here:

Live shop: https://gyazo.com/c1153f243c8f19a510dfc50be7153641
New shop: https://gyazo.com/8b1c5229a5a0c8fcb5de7ddf4950c99d

I think that is the last little thing before I can try to import the whole products.

Hello,
Can you load the attached patch file from CSVI maintenance menu in your new shop and try doing the import again? See if the thumb image path goes correct.

patch_thumb_path_2016_12_06.zip

Good morning,

I have laoded and executed the patch file. Results as following.

VM Manufacturers
live shop https://gyazo.com/590c17a2717fb0faa1423e7025e8e489
new shop
[color=red]Same, so working![/color]

VM Categories:
live shop https://gyazo.com/96252c9e7c8a2ccaf3482b7820a54ce8
new shop https://gyazo.com/d5f5964c4c0a444b3e7eb75df9cf81ed
[color=red]Not working! Do I have to update the available fields. I only have updated with the patch file. Manufacturers had worked so...[/color]

So next stop (and biggest thing): VM Product export.

Thx fot the patch file!

Hello,

VM Categories:
live shop http://gyazo.com/96252c9e7c8a2ccaf3482b7820a54ce8
new shop http://gyazo.com/d5f5964c4c0a444b3e7eb75df9cf81ed
Not working! Do I have to update the available fields. I only have updated with the patch file. Manufacturers had worked so...

You need to have file_url and file_url_thumb in your import file. That is missing and so the old image paths are not updated. Try to add these fields to your import file and do a import.

Hello,

both fields were activated. I have deleted them and added the field again, now it's working, I guess https://gyazo.com/77e067860d573cbecb7cf145a5b394c6.
I will now try to import the products and get back to you. Thx for your help.

Hello,

as I promised I'm getting back to you. I have totally forgotten to import the manufacturers categories. I only have 5 categories for the manufacturers, so I mae it manually. At the moment I have the 5 categories of the old shop in the new one (manually). IDs are the same. You can see it here (live shop) https://gyazo.com/55e054aaf287fa40a305baeffdcf032e and here (new shop) https://gyazo.com/144881532fd5a424ca8efb10223627a4.

Ok, so now it was time to export and import the manufacturers for categories again. Unfortunatelly it didn't work. I've added the two fields irtuemart_manufacturercategories_id and virtuemart_manufacturer_id. They are needed, sure? I'm getting SQL Error message.

I've also tried to do the product import. I'm getting the same error message like in the import above:
https://gyazo.com/dadaf3bdd5071a501374f0ca3ae8dcaf

Hello,

Ok, so now it was time to export and import the manufacturers for categories again. Unfortunatelly it didn't work. I've added the two fields irtuemart_manufacturercategories_id and virtuemart_manufacturer_id. They are needed, sure? I'm getting SQL Error message.

No you should not use fields ending with _id. These are primary key fields of database and are not supposed to be used for import. Please try import without these id and see how it goes.

I've also tried to do the product import. I'm getting the same error message like in the import above:
http://gyazo.com/dadaf3bdd5071a501374f0ca3ae8dcaf

Post your import file to check. if you have used ids in product import file, try import after removing them.