Support is offline. We are back Monday 23 November, 09:00.

Problem export databases client & contacts #59171

Open balagneweb opened this topic Friday, 02 August 2019 · 12 replies
Author

Hello,

I installed CSVI Pro to export the list of joomla users and all customers of a virtuemart store.

However, when I launch the export I only have 3 clients saved in CSV when I have more than 200.

How should I do it ?

Regards

Support

Hello,

This is usually because of the shopper groups a user is assigned to. Please check the Options tab of the export template and make sure the selection for Shopper groups is correct. That should be the reason why you only see 3 users.

If it still won't export, please attach your debug log and we can take a look.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

Hello,

It still does not work, I can not get the list of customers.
Here is the log log

Support

Hello,
You have set export template to filter by vendor and shopper group name to All assigned shopper groups. May be all your users are not assigned with a shopper group and also have no vendor set to them. I removed the vendor filter and set the Shopper group filter to export both users who have a shoppergroup assigned and have no shoppergroup assigned. Your export gets 413 records, can you check now?

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

Hello, thank you very much for your help, now I would like to import this list into my new development site: dev.donnae.fr

how do i go because i have already managed to retrieve the customer list and password but not the accounts receivable information, can you help me again?

cordially

Support

Hello,
You can take a look at VirtueMart Users import document on how to run the import. If you have any problem with your import do post the import debug log to check.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

I can not import.
Thank you here is the debug file

Support

Hello,
Your debug log is empty so nothing to check in there. Do you see any error on import?

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

In the import log I have the message:
0 Unsupported Failure These fields were not supported by CSVI:

Author

When I choose the import via an external database here is the error message

  • Capture d’écran 2019-08-05 à 13.47.31.png
Support

Hello,

0 Unsupported Failure These fields were not supported by CSVI:

I had a look at your import on site and you are seeing unsupported fields error for three fields full_name, country_name and state_name. The field full_name, country_name and state_name are only supported in export and not in import. For import you need to use name, country and state field headers in your import file.

When I choose the import via an external database here is the error message

The table you set to import in your template, have username column?

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

normally yes she does have a username column.
Why the import does not work from the exported file

Support

Hello,

normally yes she does have a username column.

Can you load the attached patch file and check the import from database again?

Why the import does not work from the exported file

Your import is working i checked it on your site. The fields full_name, country_name and state_name are not available in import. For import these fields should be named as name, country and state. Since RO CSVI is not finding these fields in your import file, it says as unsupported fields. Hope it is clear.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Log in to reply to this topic.