Resolved Joomla Content: Wrong export file with issues

Hello,

the file was exported with NO addition

That means you did not add the extension to the filename. CSVI doesn't add any extension because there are systems that don't use an extension. So if you want a file extension, you need to provide it.

You did not post the information requested at the top of this page under Looking for a useful answer? so I can't say what has happened. However it kind of looks like you did not set any text enclosure in your export file. This is needed because you are dealing with HTML tags. So the field delimiter you would set to ; or , and the text enclosure needs to be set to " and this will give you a CSV file that should be readable.

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.

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.

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.

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... 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,
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

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,
There is one simple solution, if you know how to do, go to your phpmyadmin >> select your database >> look for #__virtuemart_medias table >> on SQL tab paste the query below and click Go. Dont forget to replace #_ with your table prefix in the query. This query will publish all the images of products, manufacturer and category.

UPDATE `#__virtuemart_medias` set `published`=1

Hello,
You shouldn't be having the 'SELECT * FROM s4z67_virtuemart_medias WHERE 1' statement above the 'UPDATE s4z67_virtuemart_medias set published=1' statement. Please remove that and run only the query i sent above and click on Go.

Hello,

I first thought it's in case of the "/" characters, so I've changed the names of some categories, but this wasn't it. As you see the ordering of the subentries are wrong, and also the links don't work. You can see it here. Live shop: http://gyazo.com/fb0854a61817b186b96abd02815cd02c , new shop:https://gyazo.com/371ca75db0285bd30c70525e2c214866 ("Wählen Sie eine Kategorie".

As i mentioned earlier, menu ordering is missing in your import file though it is there in your template fields. You need to have this menuordering field added to your Joomla-Mainmenu1.csv file so your menu entries are ordered during import. Also your menus are not published and so i think links don't work. The debug log shows that links are entered correct. Try publishing the menus by adding published field to your import and by setting default value to 1. Let me know if this helps.

Hello Benny,

If I have understood correctly, the setting in the import template must be set to "no".

This depends of course on what you want to do, by setting this option to No, the fields will be used in your template and not the column headers in your file.

The "menuorder" and "published" fields must also be entered in the export template as a field or not?

Yes, because you want to import them again.

The fields of the export and the import file must be identical?

They don't have to be but if you are exporting from one site to another it is best to keep them the same. It just makes things easier

Hello,
The problem with 'Select a category' option in the menu is with the link you are importing for the category. Say for example the link column for path sportnahrung/aminosaeuren in your import file has value index.php?option=com_virtuemart&view=category&virtuemart_category_id=71&virtuemart_manufacturer_id=0&categorylayout=0&showcategory=1&showproducts=1&productsublayout=0, if you see the virtuemart_category_id=71 in the link and there must be no category_id with id as 71 in your VirtueMart categories table and so it selects wrong category option. You may need to put in the correct category_id in these links from your VirtueMart category table so the category is selected correct in the menu page after import.

HI,
thx for answering. I'm using Joomla 3.4.8 to export, with CSVI 6.6.4. The settings for export are like this: https://gyazo.com/9c24d2a7476f8187ea5d721105ad42a3 I've changed the text enclosure to ". Altough I'm getting no .csv-file (I change the file to .csv manually). I Have added the file I got and also the log.

When I'm trying to import it is looking like this: https://gyazo.com/75be2712331dafcff0ac69503042feb3

Hope to get a solution. Thx!

Hello,

Altough I'm getting no .csv-file

That is because you have set the Filename for exported file to Joomla-Content and not to Joomla-Content.csv.

When I'm trying to import it is looking like this

That is looking good to me. What problem do you see?

Thx Roland!
1. "CSV-file" Export is working now.

2. Yeah!!!! I think the import of the content has worked!

I will now try to import the joomla menu, categories and at last: VM.

Hi Roland,

I've now tried to export the Joomla menu & categories and also the VM products. The Joomla content has worked, but the menu doesn't work, categories either and by importing the VM file -- empty page when I'm clicking on "Preview". Please see here: https://gyazo.com/c63b81f8e48a3f7c8c7ae2284fe23cb1
By the way, the Vm file has about 15MB.

Hello,
Can you check your preview page using firebug console to check if you see any Javascript error? Please post the screenshot of firebug console.

Hello,

Uploading a 15MB file usually doesn't work because of server upload limits. Either increase this upload limit in your php.ini file or place the file on the server and let CSVI read it from the server. This way you work around the upload limit.

As for the imports that are not working, let's take one issue at a time, doing multiple at once will confuse too much. So for the category import you need to post the information requested at the top under Looking for a useful answer?. Only then are we able to help you further.