Resolved Import Product Description for Virtuemart

Hello Kim,

I attached the XML following your instructions ...it must not have attached properly. So here it is again attached. (com_csvi.log.211.zip)

That was not XML file but again an incomplete debug log. Please try to post template XML again or you can mail it to tharuna@rolandd.com.

BTW, there was no CSVI Pro in the first choice, only RO CSVI ...so I used that one.

Thats correct. It is RO CSVI and not CSVI Pro.

The debug file is com_csvi.log.215.zip

Debug log shows that first product has been set to unpublished and last two products are set to published. Where do you have value of the published field set? Can you post the latest import file too? You can mail it to me at the above given email if you have difficulty in posting it here.

Hi Tharuna

I attached the XML following your instructions ...it must not have attached properly. So here it is again attached. (com_csvi.log.211.zip)
Hopefully worked this time.
BTW, there was no CSVI Pro in the first choice, only RO CSVI ...so I used that one.

The debug file is com_csvi.log.215.zip

Thanks again

cheers
kim

Hello Kim,
The debug log posted is empty so there is nothing i could check. Can you run the import and post the debug log of that latest import? Also if possible send the template XML file as requested in my previous reply.

Hi Tharuna

Here you go.

thanks

cheers
kim

Hello Kim,
Would like to see what is going on with your import along with your debug log issue. Can you post the template XML file to check? To get your template XML file, in RO CSVI maintenance menu select CSVI Pro on first option, backup templates on second option, select your import template and download the XML file. Post the XML file.

Hi Thuruna

I've tried putting in either a 'No', 'N' or '0' and it still publishes every time. The only way it didn't publish is if I deleted the published column, which isn't ideal.
The import doesn't generate a debug file even though I have the template set to Enable Logging.

Thanks

cheers
kim

Hello Kim,

BTW, should a '0' mean unpublished and a '1' mean published?

Thats correct. 0 is for unpublished and 1 is for published.

Any clues?

published field in your file is empty. if you need to unpublished set this field value to 0 or no or N or n and then try the import. If you still have any problem post the import debug log to check.

Hi Tharuna

I have small glitch when uploading the products CSV file into VirtueMart.

If a product has been unpublished in VirtueMart, then I upload a file that contains that product, the product becomes published. This is regardless whether the publishing column is blank or if it contains a '0' or a '1'.

BTW, should a '0' mean unpublished and a '1' mean published?

Any clues?

Thanks

cheers
kim

Hello Kim,
Can you please post us your latest debug log and sample import file to check?

Thanks Tharuna, worked a treat.

cheers
kim

Hello Kim,

Currently we are using category_path rather than just category_name. e.g: Scotland/Speyside
So should I add the second category as a path also? e.g: Scotland/Speyside|Scotland/Old & Rare

Yes thats right, in category_path field you can add your second category as a path separated by |.

And once the file is uploaded and 2nd category is in do I still leave the template as Append Categories : Yes?

If you have no more categories to add then you can set Append categories to No.

Hi Tharuna

Thanks for the quick response.

Currently we are using category_path rather than just category_name. e.g: Scotland/Speyside
So should I add the second category as a path also? e.g: Scotland/Speyside|Scotland/Old & Rare

And once the file is uploaded and 2nd category is in do I still leave the template as Append Categories : Yes?

Thanks again

cheers
kim

......................................................................
Hello Kim,
Yes, you can import multiple categories for a product by separating them using | example category1|category2|category3 in your import file.

If one category is already in database and you want to append another one then in your import template on Options tab set Append categories as Yes and run the import. This will add new category to a product along with old one. Click on Advanced button on top if you do not see this option in your template.

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.

Hi Tharuna

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

cheers
kim

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.

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

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.

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.

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

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?