Importing and Exporting

[shawnlg777]

 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.

[Basara]

Hello.

Check for the import/export related errors in the AbanteCart errorlog (System > Logs > Error log)

[shawnlg777]

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 <b>/home/cafetab/public_html/table-themes/core/database/amysqli.php</b> on line <b>105</b>
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 <b>/home/cafetab/public_html/table-themes/core/database/amysqli.php</b> on line <b>105</b>

[shawnlg777]

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 <b>/home/cafetab/public_html/table-themes/core/database/amysqli.php</b> on line <b>105</b>

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!

[eCommerce Core]

Do you actually have tables ab_products and ab_product_descriptions in your database?

Try to run these queries manually to see full error.

[abolabo]

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

[shawnlg777]

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!

[abolabo]

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

[shawnlg777]

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.