1. coolmango
  2. RO CSVI
  3. Tuesday, 31 October 2017
  4.  Subscribe via email
Hi Guys

Is there an any way to import product descriptions into Virtuemart? Both long and short would be great.

I'm not sure weather I need to use a seperate template for this or can I add to my current one which is...
product_sku : product_name : manufacturer_name : product_price : category_name : category_path : published : product_in_stock : shopper_group_name

If I need a new template then where can I find one?

Thanks in advance
cheers
kim
Accepted Answer Pending Moderation
Hello Kim,
Please send the import file as requested. I will run the import the file on my local server and check.
Kind regards,

Tharuna

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

Sorry, I meant to attach that and forgot. :)

here you go.
The fields, ABN, newsletter, creditApproved, creditLimit, approved and active are not necessary.

thanks again
kim
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 22
Accepted Answer Pending Moderation
Hello Kim,
Do you have Wholesalers user group created from Users >> Groups page? That is the reason your users are not imported. Can you confirm you have this user group created?
Kind regards,

Tharuna

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

Yes, I have a Wholesalers user group in Joomla.
In Joomla Users there are 2 groups, Wholesalers and Registered.
In Virtuemart they correspond to Wholesale and Default Shoppers (COM_VIRTUEMART_SHOPPERGROUP_DEFAULT). I had to change Default Shopper Group to COM_VIRTUEMART_SHOPPERGROUP_DEFAULT in the csv file so the tag in Virtuemart would show.
All the shoppers have imported just not all the info.
The weird thing is that the template imports address info into some and not others, (Wholesale or Default Shoppers). It seems random, though none of them have the phone numbers or passwords imported.
I've split the shopper list for import into 13 seperate files (200 each) as the full 2500 file will not import (500 error message).
I actually only need to do this once as an initial import (transferring info from old site to new Joomla site) as shoppers will register individually after that on the new site.

Hope this helps

cheers
kim
  1. more than a month ago
  2. RO CSVI
  3. # 24
Accepted Answer Pending Moderation
Hello Kim,
Yes, I have a Wholesalers user group in Joomla.
In Joomla Users there are 2 groups, Wholesalers and Registered.
In Virtuemart they correspond to Wholesale and Default Shoppers (COM_VIRTUEMART_SHOPPERGROUP_DEFAULT). I had to change Default Shopper Group to COM_VIRTUEMART_SHOPPERGROUP_DEFAULT in the csv file so the tag in Virtuemart would show.
All the shoppers have imported just not all the info.
The weird thing is that the template imports address info into some and not others, (Wholesale or Default Shoppers). It seems random, though none of them have the phone numbers or passwords imported.

I tried importing your file on my local server and could see all users imported. Can you send me a private message of your site administrator login details? I will take a look at your site.

I've split the shopper list for import into 13 seperate files (200 each) as the full 2500 file will not import (500 error message).
I actually only need to do this once as an initial import (transferring info from old site to new Joomla site) as shoppers will register individually after that on the new site.

Did you try batch import as explained in Manage timeout document? I sent link to this document in my previous post. Didn't that work for you?
Kind regards,

Tharuna

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

I've sent you login details via your contact page.

Yes, I tried the batch import but that didn't work either. Hopefully you can find the gremlin. :)

thanks
kim
  1. more than a month ago
  2. RO CSVI
  3. # 26
Accepted Answer Pending Moderation
Hello Kim,
I've sent you login details via your contact page.

Will take a look at your site and give an update on what i find.

Yes, I tried the batch import but that didn't work either. Hopefully you can find the gremlin. :)

2500 lines to import is not a huge one but since that is not working for you, you can try setting your import as a cron job and see how it goes.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 27
Accepted Answer Pending Moderation
Hello Kim,
I had a look at your site and could see the all Joomla users created but i am not able to check the VirtueMart shopper groups as i don't have access to that page. Is it possible that i get access to that page?

Also for batch imports, I wanted to know what was the limit you had set in Lines per import on Limit tab? Did you try setting it to 100 or 50 and you see the same 500 error?
Kind regards,

Tharuna

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

You access has bee fixed so you should be ok now.

I originally tried 200 lines at a time and the 100 for the batch, without any error messages, but it still seems to randomly select who get addresses and phone numbers. Some get neither. It's a puzzle.

Thanks for looking.
cheers
kim
  1. more than a month ago
  2. RO CSVI
  3. # 29
Accepted Answer Pending Moderation
Hello Kim,
I picked few random users from your import file, checked address details at VirtueMart shoppers page and see the address details added. Can you give emails of few users for whom address and phone numbers are not added? That will help me to track the issue.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 30
Accepted Answer Pending Moderation
Hello Kim,
Also i wanted to tell you that address and phone numbers of few users are not there in your import file. I am talking about Members list 1.csv file which you sent us earlier. I hope you are not talking about those users.
Kind regards,

Tharuna

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

Seems your right about the addresses (my apologies), it's phone numbers and passwords that aren't loading.
This is for both Default Shopper Group and Wholesale.

On the file Members list 1.csv (a few examples)
anthony.cowie@gmail.com: Imported Address but not Phone (file contains only 1 ph. number)
antony@rsq.com.au: Imported Address but not Phone (file contains only 1 ph. number)
ajm@audaxlegal.com: Imported Address but not Phone (file contains 2 ph. numbers)

On the file Members list 3.csv (attached)
dalli@iprimus.com.au: Imported Address but not Country, State or Phone (file contains only 1 ph. number)
This could just be a one off though.

thanks for you help
cheers
kim
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 32
Accepted Answer Pending Moderation
Hello Kim,
Seems your right about the addresses (my apologies), it's phone numbers and passwords that aren't loading.
This is for both Default Shopper Group and Wholesale.

Passwords are added for all users you are just not seeing them. That is not an issue because by default password fields don't show the value in the fields.

On the file Members list 1.csv (a few examples)
anthony.cowie@gmail.com: Imported Address but not Phone (file contains only 1 ph. number)
antony@rsq.com.au: Imported Address but not Phone (file contains only 1 ph. number)
ajm@audaxlegal.com: Imported Address but not Phone (file contains 2 ph. numbers)

On the file Members list 3.csv (attached)
dalli@iprimus.com.au: Imported Address but not Country, State or Phone (file contains only 1 ph. number)
This could just be a one off though.

I found a strange issue on your site. I wanted to check if user details were added in your site database so i created a CSVI custom table export template on your server and exported all the users details saved. To my surprise i see that each user has been duplicated several times in the database and the first record of these users don't have phone numbers added. This first record is the one selected by default and shown in VirtueMart Shoppers page. That explains why you don't see phone numbers for these users. I need to find out why you have so many duplicates in your database. Can you send me a private message of your database access details? I will clean the table and run the import again to see how these duplicates happens.
Kind regards,

Tharuna

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

I've sent you a message via your contact page.

cheers
kim
  1. more than a month ago
  2. RO CSVI
  3. # 34
Accepted Answer Pending Moderation
Hello Kim,
Have sent a reply to your email with screenshot of issues i see in your VirtueMart userinfo table. Take a look and let me know.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 35
  • Page :
  • 1
  • 2


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