User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by WCNZ » Thu Jul 23, 2009 9:36 am

Hi there,

Thanks for creating this module - the idea is excellent! Will this release work with 1.2.9? I've had a bit of trouble with the 1.2.x version version of this mod - the buttons do not show up correctly
FireShot capture #7 - 'Export _ Import'.png

Buttons broken - FireShot capture #7 - 'Export _ Import'.png (2.01 KiB) Viewed 3402 times

Also, when hitting the export button, I get a slew of errors:

Code: Select all

Warning: set_time_limit() [function.set-time-limit]: Cannot set time limit in safe mode in /var/www/vhosts/*********************.co.nz/httpdocs/admin/controller/tool/export.php on line 61

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/renwickroyale.co.nz/httpdocs/admin/controller/tool/export.php:61) in /var/www/vhosts/*********************.co.nz/httpdocs/admin/Spreadsheet/Excel/Writer.php on line 68

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/renwickroyale.co.nz/httpdocs/admin/controller/tool/export.php:61) in /var/www/vhosts/*********************.co.nz/httpdocs/admin/Spreadsheet/Excel/Writer.php on line 69

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/renwickroyale.co.nz/httpdocs/admin/controller/tool/export.php:61) in /var/www/vhosts/*********************.co.nz/httpdocs/admin/Spreadsheet/Excel/Writer.php on line 70

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/renwickroyale.co.nz/httpdocs/admin/controller/tool/export.php:61) in /var/www/vhosts/*********************.co.nz/httpdocs/admin/Spreadsheet/Excel/Writer.php on line 71

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/renwickroyale.co.nz/httpdocs/admin/controller/tool/export.php:61) in /var/www/vhosts/*********************.co.nz/httpdocs/admin/Spreadsheet/Excel/Writer.php on line 72

Warning: tmpfile() has been disabled for security reasons in /var/www/vhosts/*********************.co.nz/httpdocs/admin/Spreadsheet/Excel/Writer/Worksheet.php on line 477

Warning: tmpfile() has been disabled for security reasons in /var/www/vhosts/*********************.co.nz/httpdocs/admin/Spreadsheet/Excel/Writer/Worksheet.php on line 477

Warning: tmpfile() has been disabled for security reasons in /var/www/vhosts/*********************.co.nz/httpdocs/admin/Spreadsheet/Excel/Writer/Worksheet.php on line 477
(I've replaced the site name in the code above, as I don't want google to pick it up).

The above errors are then followed by an absolute heap of this:

Code: Select all

��ࡱ�����������������;���� ���������������!�������������������������"��������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������� ���� �A������B���=�������%r8������X"����1���������������Arial1���������������Arial1���������������Arial1���������������Arial1���������������Arial1��������������Arial��� ��######0.00�����##0.00��
Could there be a conflict with the Backup / Restore module (that's not working either - same problems)? Regarding the button issue, I have checked that all images are in the correct place and the folder is readable etc.

What should I do? Feel free to move my post, if this is the wrong spot to ask...

Thanks for your time! :)
PS. I'm running PHP5 on a linux server.

New member

Posts

Joined
Mon Mar 24, 2008 11:21 am

Post by JNeuhoff » Thu Jul 23, 2009 7:31 pm

This release will NOT work with 1.2.x versions of Opencart. If you use 1.2.x, get a matching release of the Export/Import module for it!

Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by op_sjo » Fri Jul 24, 2009 7:40 pm

The import/export and backup/restore buttons are broken on mine too (1.2.9). They were on the old release and the current one.

Also my backup function no longer works.. but not sure when this broke.

Newbie

Posts

Joined
Thu Jul 02, 2009 6:14 am

Post by JNeuhoff » Fri Jul 24, 2009 8:04 pm

Just be sure, I did a fresh install of Opencart 1.3.0 and the Export/Import module from here, and it works just fine. Tou should see something like this:
opencart-1-3-0-backup.png

opencart-1-3-0-backup.png (25.84 KiB) Viewed 3382 times

opencart-1-3-0-export-import.png

opencart-1-3-0-export-import.png (25.63 KiB) Viewed 3382 times


Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by op_sjo » Sat Jul 25, 2009 9:27 pm

Is there a working version for 1.2.9 that supports DBPREFIX?

I think I am using your version for 1.3.0 on a 1.2.9 installation and it appears to be working okay with DBPREFIX.


Also, a couple of questions :-

1) I cannot add new products by importing from the spreadsheet. It appears that if you leave the product id column blank, it does not get imported.

2) SEO tags - any reason why these can't be imported/exported in the same way for categories and products? Right now I have to flip between using the spreadsheet and manually editing each category in the UI.

Thanks!

Newbie

Posts

Joined
Thu Jul 02, 2009 6:14 am

Post by JNeuhoff » Sat Jul 25, 2009 10:50 pm

I think I am using your version for 1.3.0 on a 1.2.9 installation and it appears to be working okay with DBPREFIX.
Don't do it! Use the matching version for 1.2.9 instead which includes support for the DB_PREFIX, too, and it won't break the buttons.
1) I cannot add new products by importing from the spreadsheet. It appears that if you leave the product id column blank, it does not get imported.
You have to specify your product_ids in the spreadsheet, otherwise it won't work.
2) SEO tags - any reason why these can't be imported/exported in the same way for categories and products? Right now I have to flip between using the spreadsheet and manually editing each category in the UI.
At the moment (as of the 1.3.0 version) the Export/Import only has the SEO_keyword supported for the products, not for the categories. However, I agree with you, it is a good idea to include support for the SEO_keyword for the categories, too, so I'll put it on my to-do list.

BTW.: As long as you don't change the category IDs, their SEO keywords should be preserved because their are in a separate DB table which the Export/Import doesn't touch at the moment.

There are few other things which I plan to add to the Export/Export, like the special prices, discounts, and related products, when I find the time.

Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by jules_nz » Thu Aug 13, 2009 9:40 am

Hi

I have this installed but the spreadsheet it is exporting doesn't look right
When I try and open it it says the format is different than the specified extension

Any idea what could have gone wrong?

Thanks
Julie

(Edit - Just a note that I have office 07)

Active Member

Posts

Joined
Tue Aug 11, 2009 12:58 pm

Post by JNeuhoff » Thu Aug 13, 2009 5:00 pm

Use OpenOffice 3.x instead. Looks like MS Office has backward compatibility problems.

If anyone on this forum knows an Open Document writer in PHP let me know, it would be useful in the long run to use that format rather than the proprietory MS format.

Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by jules_nz » Thu Aug 13, 2009 6:44 pm

Hi JNeuhoff

I installed openoffice and that seemed to get rid of all the weird stuff
But it still has an error at the stop that seems to be stopping the rest of the file from working

The error is
Warning: tmpfile() has been disabled for security reasons in .../Worksheet.php on line 477

Thanks
Julie

Active Member

Posts

Joined
Tue Aug 11, 2009 12:58 pm

Post by JNeuhoff » Thu Aug 13, 2009 7:32 pm

This appears to be an issue with your webhost and its overly restritive PHP configuration. What is the URL of your Opencart server?

Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by jules_nz » Fri Aug 14, 2009 3:44 am

The shop url is http://one.sharpedesigns.co.nz
And I have placed a php info page at http://one.sharpedesigns.co.nz/php.php

Active Member

Posts

Joined
Tue Aug 11, 2009 12:58 pm

Post by JNeuhoff » Fri Aug 14, 2009 5:15 am

Open a support ticket with your webhost and kindly ask them how to remove the tmpfile function from the disable_functions PHP setting.

Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am

Who is online

Users browsing this forum: No registered users and 3 guests