Cannot get Hexdata to work

More
11 years 10 months ago #59 by Richard Lavallee
I have redshop and virtuemart installed, now what I wish to do is take the products and catagories from redshop and import them into virtuemart,
I cannot get a working csv file out of the exporter, and opening it I get this in the csv
"Warning: mysqli_query(): Empty query in /hermes/bosweb26b/b2406/nf.computermechanicca/public_html/libraries/joomla/database/database/mysqli.php on line 382:
null given Warning: array_unshift() expects parameter 1 to be array in /hermes/bosweb26b/b2406/nf.computermechanicca/public_html/plugins/hexdata/custom/custom.php on line 223
Warning: Invalid argument supplied for foreach() in /hermes/bosweb26b/b2406/nf.computermechanicca/public_html/plugins/hexdata/custom/custom.php on line 232
any help would be appreciated, thank you.

Please Log in to join the conversation.

More
11 years 10 months ago #60 by Daniel
Replied by Daniel on topic Cannot get Hexdata to work
Hi,

You are doing something wrong with the profile settings, Please send us your back end login credentials at support@hexsystechnologies.com, We'll look into it.

Thanks
Danish Babu

Thanks
Daniel

Please Log in to join the conversation.

More
11 years 10 months ago #67 by Daniel
Replied by Daniel on topic Cannot get Hexdata to work
Hi,

Please check now your backend. I've corrected one of your profile i.e. Redshop categories. You can now import/export the data from this table. You need to correct the other profiles in the same way. You weren't including the fields in the profiles which are to be exported/imported. You can do so just by entering some name in the textfields.

Thanks

Thanks
Daniel

Please Log in to join the conversation.

More
11 years 10 months ago #71 by Richard Lavallee
thanks for setting that up but after running the job I get this error.
DB function failed with error number 1062
Duplicate entry '' for key 'slug' SQL=INSERT INTO `btjzd_virtuemart_categories_en_gb` (`virtuemart_category_id`,`category_name`) VALUES ('4282','Axle - Rear Both Sides')

Please Log in to join the conversation.

More
11 years 10 months ago #72 by Daniel
Replied by Daniel on topic Cannot get Hexdata to work
It's because you are trying to import the same records which are already there in database, "slug" is a unique table key, so remove this record from CSV and then try to import. If it doesn't solve your problem tell us what exactly you are trying to do?

Thanks

Thanks
Daniel

Please Log in to join the conversation.

Cron Job Starts