yusufjee 15 years ago

Hello JNeuhoff

I am running into a problem where the exported xls file has funny characters inside. I am not sure how to solve this. Is it possible to help me out in this matter? If you can suggest what is the structure so i will try to import my own xls file and test.

Thanks Yusuf

Pascal 15 years ago

I found out, that the "pd.description" which gives me this error.

Pascal 15 years ago

Second Part:

LEFT JOIN `product_to_category` pc ON p.product_id=pc.product_id LEFT JOIN `url_alias` ua ON ua.query=CONCAT('product_id=',p.product_id) LEFT JOIN `manufacturer` m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN `weight_class_description` wc ON wc.weight_class_id = p.weight_class_id AND wc.language_id=2 LEFT JOIN `length_class_description` mc ON mc.length_class_id=p.length_class_id AND mc.language_id=2 LEFT JOIN `product_related` pr ON pr.product_id=p.product_id LEFT JOIN `product_tags` pt ON pt.product_id=p.product_id AND pt.language_id=2 GROUP BY p.product_id ORDER BY p.product_id, pc.category_id;

Pascal 15 years ago

Here is the query:

First Part
Error: Incorrect key file for table '/tmp/#sql_7804_0.MYI'; try to repair it<br />Error No: 126<br />SELECT p.product_id, pd.name, GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR "," ) AS categories, p.sku, p.location, p.quantity, p.model, m.name AS manufacturer, p.image AS image_name, p.shipping, p.price, p.date_added, p.date_modified, p.date_available, p.weight, wc.unit, p.length, p.width, p.height, p.status, p.tax_class_id, p.viewed, p.sort_order, pd.language_id, ua.keyword, pd.description, pd.meta_description, pd.meta_keywords, p.stock_status_id, mc.unit AS length_unit, p.subtract, p.minimum, p.cost, GROUP_CONCAT( DISTINCT CAST(pr.related_id AS CHAR(11)) SEPARATOR "," ) AS related, GROUP_CONCAT( DISTINCT pt.tag SEPARATOR "," ) AS tags FROM `product` p LEFT JOIN `product_description` pd ON p.product_id=pd.product_id AND pd.language_id=2

Pascal 15 years ago

I have 1.4.9.4 installed
MySQL: Server: Localhost via UNIX socket
Server version: 5.0.92-community-log

Incorrect key file for table '/tmp/#sql_7804_0.MYI'; try to repair it

If I run this query with phpMyAdmin I get the same error. Even if I create a new DB and run then the query, I get the same error. I have only about 250 products in the DB. If I run the query against the original DB with about 20 Products it works. What could be the problem?

asphole 15 years ago

Are there any plans to upgrade this to 1.5 now its been released? (RC version) (I haven't tested it yet with 1.5 but will hopefully do so soon)

Brad 15 years ago

@fealldagal I have 1.4.9.4 installed and this plugin worked as expected. As per the readme.txt I just copied the folders over and then checked System > USers > User Groups > Top Administrator > tool/export

Now when I choose System > Export/Import I see the update with the text "Use this function to export or import all your categories and products to or from a XLS spreadsheet file" rather than the old text.

Maybe you were expecting it to appear under Extensions > Modules. It doesn't

Brad

noisesensei 15 years ago

I have a problem with cyrillic symbols (Russian) in ocStore 0.1.4. When I export my data, it looks like total chaos in .xls file. (I have installed version for OpenCart 1.4.9.2). If anybody have a sollution, please, contact me noisesensei@gmail.com
Thank you.

fealldagal 15 years ago

I try 1.4.9.1 and it is the same, is anyone getting this work on 1.4.9.1,2,3,4 if you do please let me know what I need to do thank you.

fealldagal 15 years ago

Hi,

I am using 1.4.9.4, I upload the module for it and it is not show up in the backend, I checked System > Users > User Groups > Top administrator > Edit please can anyone help thank you.

adriankoooo 15 years ago

My exported XLS is empty. Yes, I have products. Why?

freni32 15 years ago

Here is error when trying to upload:

Fatal error: Call to undefined method PHPExcel_Reader_CSV::setReadDataOnly() in /home/delivery/public_html/admin/model/tool/export.php on line 1170
Fatal Error: Call to undefined method PHPExcel_Reader_CSV::setReadDataOnly() in /home/delivery/public_html/admin/model/tool/export.php on line 1170

freni32 15 years ago

I am trying to upload an excel .csv file but get a long list of errors when trying to load it, what file extension should I be uploading?

atelecom 15 years ago

Hello,

I am receiving the following error when trying to import a file:

Notice: iconv_substr() [function.iconv-substr]: Unknown error (0) in /var/www/html/system/PHPExcel/Classes/PHPExcel/Shared/String.php on line 306

Any suggestions?

Thanks!

futurestudios 15 years ago

@ joyce-c Did you check the checkbox to "on" under your User menu ? System > Users > User Groups > Top administrator > Edit

futurestudios 15 years ago

I also have options plus from Qphoria and would love to see this work with the additional fields used in options plus (redux) happy also to pay as options data being rubbed out when using this excellent add on

joyce-c 15 years ago

Hi,

I've just installed the module onto my eStore, but the export/import tab isn't showing on my products page at the backend, I'm using opencart ver.1.4.9.4. the entire installation was perfect without any errors.

Seuldieu 15 years ago

JNeuhoff - Magnificent work my friend... really helpful module!

Do you offer bespoke developments? I can pay you via Paypal if you can modify 'import/export' to pull 1 extra column from my product options table... my inexperienced attempts all yield errors.

I have Options Plus from Qphoria, and it adds an "info" column to the "product_option_value" table... the problem currently is that 'import/export' wipes the table clean before uploading the new data--this wipes the "info" field clean.

You can reach me at gremlin.ca@gmail.com if you'd be willing to help. Thanks!

tenerifestudios 15 years ago

JNeuhoff - thanks for your work on this - I hope to build something to give back into the community soon. I agree Great Great Great!!!!

Hook61 15 years ago

Great Great Great !!!!!