AbanteCart Community

Shopping Cart Operations => Support => Topic started by: shawnlg777 on January 04, 2016, 12:33:16 AM

Title: Importing and Exporting
Post by: shawnlg777 on January 04, 2016, 12:33:16 AM: I am having problems importing and exporting information. When export I cannot open the document no matter which zip program I use. I will tell you when I first downloaded the software I could open the tar.gz files but can no longer. When I try to upload the (Product Information) file it kicks me out and says I have encountered and error and sends me back to the home page. If someone needs me to I can send them the data offline.
Title: Re: Importing and Exporting
Post by: Basara on January 04, 2016, 01:36:06 AM: Hello.

Check for the import/export related errors in the AbanteCart errorlog (System > Logs > Error log)
Title: Re: Importing and Exporting
Post by: shawnlg777 on January 04, 2016, 10:46:27 AM: 2016-01-04 10:10:51 - database error: AbanteCart core v.1.2.5 Error:
SELECT count(*) AS total FROM `ab_products` WHERE `product_id` = '123' in /home/cafetab/public_html/table-themes/core/database/amysqli.php on line 105
2016-01-04 10:21:34 - database error: AbanteCart core v.1.2.5 Error:
SELECT count(*) AS total FROM `ab_products` WHERE `product_id` = '123' in /home/cafetab/public_html/table-themes/core/database/amysqli.php on line 105
Title: Re: Importing and Exporting
Post by: shawnlg777 on January 04, 2016, 11:54:21 PM: 2016-01-05 9:31:36 - database error: AbanteCart core v.1.2.5 Error:
SELECT count(*) AS total FROM `ab_product_descriptions` WHERE `product_id` = 'new_id' AND `language_id` = '1' in /home/cafetab/public_html/table-themes/core/database/amysqli.php on line 105

Here is the latest. I tried tweaking the data hoping this would fix it. Any help would be appreciated. I am really close to getting this sore up. Please help!
Title: Re: Importing and Exporting
Post by: eCommerce Core on January 05, 2016, 07:12:32 AM: Do you actually have tables ab_products and ab_product_descriptions in your database?

Try to run these queries manually to see full error.
Title: Re: Importing and Exporting
Post by: abolabo on January 05, 2016, 07:15:17 AM: You should to check what is this
Code: [Select]
product_id` = 'new_id' product_id cannot be a string. It's integer (digit)
Try to search "new_id" in your import-file
Title: Re: Importing and Exporting
Post by: shawnlg777 on January 05, 2016, 12:46:54 PM: Ok I have questions for each of you.

First to eCommerce Core - By database... Do you mean the actual sql database or are you talking about the csv I am trying to upload? How would you recommend finding it. I am a newby to this solution.

Second to abolabo.. Where do I find the import file.. Or again around you talking about the csv file?

Thank you for helping me with this. I am so close to launching this site i can taste it. Thanks!
Title: Re: Importing and Exporting
Post by: abolabo on January 05, 2016, 02:30:36 PM: Quote from: shawnlg777 on January 05, 2016, 12:46:54 PM

Where do I find the import file.. Or again around you talking about the csv file?

yes.. i meant your CSV. (i didn't understood what you try to do, import or export)

what size of it? how many rows?
Probably you should split it in a few parts
Title: Re: Importing and Exporting
Post by: shawnlg777 on January 06, 2016, 02:36:20 PM: Ok I think I figured it out. I found a import template online and used that and it worked. However I am still having problems exporting. The file downloads but is corrupt or not recognizable. I have used a couple zip options. Once upon a time the export function worked.