1. Chigolo
  2. RO CSVI
  3. Wednesday, 23 November 2016
  4.  Subscribe via email
Hi guys,

I wanted to export my Joomla content, especially this fields: https://gyazo.com/d3912a26e5b8965a9510873bdd9cc077 the file was exported with NO addition, so I added ".csv" by myself after the export. As I imported the file, the artciles were looking like this: https://gyazo.com/06465cdbdcc5499292c78c18701bf1b9.

I am newbie. I want to export and import all Joomla menus, categories and articles, after that Virtuemart...

Can you please help me? I have read the tutorials, but I can't find the issue.

Thx, B.
Accepted Answer Pending Moderation
  1. more than a month ago
  2. RO CSVI
  3. # 61
Accepted Answer Pending Moderation
Good morning from Germany,

in the meantime, I have all the imports tested. In the category overview, I do not see any products pictures although these are on the server. I thought first it was the attitude of the "available pieces", unfortunately this was not the case. You can see it here: http://new3.beast-supplements.de/index.php/shop/arginin

Then I've tried to import the menus, there I got several issues with ordering and links...

Please see:
live shop: https://gyazo.com/5944a945ff27a178e9f75f4570be5dc3 (correct VM category link)
correct ordering https://gyazo.com/9c0510a178dea01faac4c2de9463f06d

nerw shop:link https://gyazo.com/a18003d7b126a4b1ee6815f43c199aa8 ("Weight Gainer" is wrong, it's in every case)
wrong ordering: https://gyazo.com/366bec4a65b1136521fc31492267240b

And then finally I can't import any VM users...

A lot more things to dol, bute hope we will get it fixed :-)
Have nice start into the week, best wishes.
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 62
Accepted Answer Pending Moderation
Hello,
Lets us focus on one issue at a time, first lets fix the problem with product images. Your product images are not published and it is not seen on front end. I published the first image on your site and it is shows on front end In your import you can add a field media_published and set the default value to 1 to publish all your product images during import. Try and let me know if it solves this issue.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 63
Accepted Answer Pending Moderation
Hello,

I've set the value to 1 into the import template, but this doesn't fix the problem, pleawse see:

Backend: https://gyazo.com/4b0fbfaae712c7fa43d68b277ce897c0
CSVI settings: https://gyazo.com/ee29e1ffd49c80325312580ee8a97472
  1. more than a month ago
  2. RO CSVI
  3. # 64
Accepted Answer Pending Moderation
Hello,
Can you post the debug log of the import?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 65
Accepted Answer Pending Moderation
  1. more than a month ago
  2. RO CSVI
  3. # 66
Accepted Answer Pending Moderation
Hello,
In your template settings, on file tab you have set Use file for configuration: Yes, this option will read the headers from your import file and so media_published did not work. You either need to add media_published field in your import file or set Use file for configuration to No so CSVI reads headers from your template fields.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 67
Accepted Answer Pending Moderation
Allright, I have tried to set the config to "no", but this doesn't work, cause everything is changed then... https://gyazo.com/27ec8629312d92c2a3a4937758c2021d I have deleted all products.
Next try: I have then added the feld: media_published without any values to the import file, and also tried with value 1 (in both templates: export & import). The import wasn't succesfull. Is there a chance to fix the media_published field after importing the files? I saw the media files aren't published in manufacturers and the vm categories, too. Or do i have to import them again?

here are thw two logfiles (online in 2 minutes!!):
http://www.beast-supplements.de/com_csvi.log.104.txt
http://www.beast-supplements.de/com_csvi.log.105.txt
  1. more than a month ago
  2. RO CSVI
  3. # 68
Accepted Answer Pending Moderation
Hello,
Forgot to mention in my previous reply that you don't have to import your manufacturer or categories again as with this solution you are trying to update publish field directly in your database. Hope it is clear.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 69
Accepted Answer Pending Moderation
Hello,

this would be the best solution. I've asked my hoster, I'm getting error message: https://gyazo.com/1e6d2622974fc14aa772d5e88e1d842d

I'll be back soon! Thx for helping!
  1. more than a month ago
  2. RO CSVI
  3. # 70
Accepted Answer Pending Moderation
Thx! Done and working (products, manufacturers and vm categories). This solution was great! I only can i say: Your support ist best ever. Hope you've read my review.

Nest stops:

[color=red]Then I've tried to import the menus, there I got several issues with ordering and links...

Please see:
live shop: http://gyazo.com/5944a945ff27a178e9f75f4570be5dc3 (correct VM category link)
correct ordering http://gyazo.com/9c0510a178dea01faac4c2de9463f06d

nerw shop:link http://gyazo.com/a18003d7b126a4b1ee6815f43c199aa8 ("Weight Gainer" is wrong, it's in every case)
wrong ordering: http://gyazo.com/366bec4a65b1136521fc31492267240b

And then finally I can't import any VM users...[/color]
  1. more than a month ago
  2. RO CSVI
  3. # 71
Accepted Answer Pending Moderation
Hello,
To order your menu you need to have menuordering field in your import file. Try import adding this field and if you have any issues post the debug log and import file to check.

And then finally I can't import any VM users...

Post me the debug log and sample import file to check.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 72
Accepted Answer Pending Moderation
Hello,

menueordering field was still available in the import file, I have added the file and log, also from the user import (I wanted to have all VM user fields!). User import doesn't generate a logfile... please see: https://gyazo.com/8e5cea031495e65b10415b8873a4fd01

I have also discovered an issue in the VM category import... The maincategories don't have any products in it and were getting "switched"... Live shop: "Protein/Eiweiß"
https://gyazo.com/77529f6e3ca5662be00c24cd12254b9f#

new one "Protein" & Eiweiß" as an own category
https://gyazo.com/9a464e56ddf16049c6b847d7a11caeae
https://gyazo.com/aff402dd9ee5b36606260f7b7c86f3ec

This happend also by "Triblus/Maca" and others... Is the error caused by the "/"character? I could rename the categories in the live shop if needed.
Attachments (3)
  1. more than a month ago
  2. RO CSVI
  3. # 73
Accepted Answer Pending Moderation
Hello,
Can we go through one issue at a time? This way we solve all issues without any confusion.

menueordering field was still available in the import file,

I dont see menuordering field in your import file you have attached.

I have added the file and log, also from the user import (I wanted to have all VM user fields!).

The Joomla-Users.csv file you have attached has no data in it. It just says "No data has been found for the selections made". Make sure that you export the users from your live site without any filters set for your user export template.

User import doesn't generate a logfile... please see: http://gyazo.com/8e5cea031495e65b10415b8873a4fd01

Please check Where to get the debug information? section on top of this page to know on how to get the debug log.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 74
Accepted Answer Pending Moderation
Hello,

sure! Ok so this are the settings in the live shop: https://gyazo.com/8566944966e9cf6dde2288c1a638d40d and this in the new one: https://gyazo.com/a242126d02990a3a048331cf8ffbe282. Menuordering field ist available.

I have the changed the logifle of the user import to "enabled" now. Again export and import- result: It's funny, now the import worked... lol
I can see the users in Joomla now, but the fields here are missing: https://gyazo.com/a5f3f308be6f48b0fb26c09e620d473a adress and so on...

I didn't find how to import the users as "VM users"
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 75
Accepted Answer Pending Moderation
Hello,
sure! Ok so this are the settings in the live shop: http://gyazo.com/8566944966e9cf6dde2288c1a638d40d and this in the new one: http://gyazo.com/a242126d02990a3a048331cf8ffbe282 . Menuordering field ist available.

menuordering field is supported only for import and not in export. If you don't see this field in import update your available fields and check.

I have the changed the logifle of the user import to "enabled" now. Again export and import- result: It's funny, now the import worked... lol
I can see the users in Joomla now, but the fields here are missing: http://gyazo.com/a5f3f308be6f48b0fb26c09e620d473a adress and so on...

Please check the import VirtueMart users document. You are missing the address data fields in your import file and so these fields are not there in your VirtueMart.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 76
Accepted Answer Pending Moderation
Hello,

menuordering field is available in import and activated but doesn't work. PLease see logfile and my further settings in the last post under.

I didn't noticed that "VM Userinfo" stands for the import. I've imported the "JOOMLA users". Now I've tried to fix it with importing the userinfo for VM, but that doesn't work either. Please see logfile.

One question, is it possible that you will do the imports... I really appreciate your support, but I guess it would be much easier and faster for you than for me and you illsave a lot of time... I'm really newbie in importing... I will spend a fee of course!

The imports are:

whole VM (users, categories, manufacturers and mf categories) and the Joomla menus.
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 77
Accepted Answer Pending Moderation
Hello,
menuordering field is available in import and activated but doesn't work. PLease see logfile and my further settings in the last post under.

You have the menuordering field in your template fields but it is missing in your import file. Your debug log shows only the below fields are imported

Use field value for field type
[DEBUG] Use field value for field path
[DEBUG] Use field value for field menutype
[DEBUG] Use field value for field title
[DEBUG] Use field value for field alias
[DEBUG] Use field value for field component
[DEBUG] Use field value for field link
[DEBUG] Use default value for field menu-meta_description
[DEBUG] Use default value for field menu-meta_keywords


I didn't noticed that "VM Userinfo" stands for the import. I've imported the "JOOMLA users". Now I've tried to fix it with importing the userinfo for VM, but that doesn't work either. Please see logfile.

May i know issue you are having with Users? The debug log shows the user has been processed in VirtueMart too.

One question, is it possible that you will do the imports... I really appreciate your support, but I guess it would be much easier and faster for you than for me and you illsave a lot of time... I'm really newbie in importing... I will spend a fee of course!

The imports are:

whole VM (users, categories, manufacturers and mf categories) and the Joomla menus.

Please email all your details to Roland at contact@csvimproved.com and he will get in touch with you on these imports.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 78
Accepted Answer Pending Moderation
Thx, I will send an email to him.
  1. more than a month ago
  2. RO CSVI
  3. # 79
Accepted Answer Pending Moderation
Hello,

I checked the templates and the shops now. I found the problem about the VM categories. I had categories like "Proteine / Eiweiß" or something like "Guarana / Maca / Taurin" in my live shop. The "/" characters created the issues in the import. Par example: The liveshop categorie "Proteine / Eiweiß" - new shop: 2!!! categories like "Proteine" and "Eiweiß". I deleted all VM categories and products, changed all the categories with the "/" characters.in my live shop and tried a new import of the VM categories in my new shop after making the changes. Then I imported the products again and published them.

At the moment I can't find any issues anymore. The products are all imported into the correct categories and the categories are also shown correctly. At last I've executed the SQL order "UPDATE `xxxxx__virtuemart_medias` set `published`=1" to get published all the VM mediafiles. This works also.

I will check everything about the VM manufacturer categories, the manufacturers, the VM categories and the products. At the moment I think the import was succesfull.

If everything will be correct, after checking the imports tomorrow, the next think will be the mainmenu. Users are secondary.

I will also send the post to Roland.

Thx and have a nice day, Benny
  1. more than a month ago
  2. RO CSVI
  3. # 80


There are no replies made for this post yet.
Be one of the first to reply to this post!