Try 'true' instead of '1'.caseyfaber wrote:Yes, I did, they are all 1 - which is what they were with the first export, and when I re-export it they are all set to 0. Should they say "true" instead of 1?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Thanks for the quick help!
Casey
If you bring down a fresh Export when you have set known selections in admin by hand, then you can review settings made and cell formats. Set values should be consistent, such as for Enabled or category assignments, and for true/false alternatives. The CELL (field record intersect) formats should be consistent up and down through their FIELDS (columns). Notice especially the cell formats.
If you poke into the spreadsheet 0 or 1 or true or false by hand, then cell formats such as general can interfere with what is supposed to be there. Compare formats when you are done with formats that came down fresh as Exports. When mysql wants a pure integer and expects 0 or 1, pure and simple, the cell format(such as general) can mean, in effect, that the "1" you see means text one to the machine rather than numerical 1 the way the machine expects to see it.
If what you did on your own machine readying for the next Import does not match the known good Exported spreadsheet, such as where numbers are not aligned the same way, then copy a known good cell from the Export and paste its Format Only into the correct column range in the Import being readied.
There may well be version as well as table differences between the alternatives true/false and the alternatives 0/1 instead. Virtually none of us will interminably remember which are where. That sort of thing is why there is an array of tools for specific OC versions ranges.
I am unable to reproduce your problem because the Export always generates 'true' or 'false', not '1' or '0', for the 'status enabled' column in the 'Categories' or 'Products' worksheet.caseyfaber wrote:That works, which is good. The problem with that is I need it so my client can just export the file, then change things he needs to change, then re-import it. Since it exports with values of "1" not "true" that doesn't work. This is the case with the category "status enabled", category "top" and products "status enabled". That is how it worked on previous versions I've used. For now I just changed the model file myself, but thought you'd like to know since I do think that is the intended behavior.
Thanks for the quick help!
Casey
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I tried to put it on my demo site so you could test it there, but apparently that server doesn't have ZipArchive installed, so I have to fix that first before you could test it there. However, I downloaded the 1.5.6 version straight from OpenCart, installed it on a fresh OpenCart install, and pressed export, and I got all 1s in those fields.
If the client is not spreadsheet savvy, then a spreadsheet macro to reset between true/false and 0/1 pairs should still be simple enough not only to run, but also to understand how and why to run, just after Open or just before Save as the case(s) may be. Above, "Try 'true' instead of '1'," resulted in, "That works, which is good. The problem with that is I need it so my client can just export the file, then change things he needs to change, then re-import it." Be sure that your client understands to back up the database or at least the affected tables at intervals that will give you means to fix it (yet again).
Lines 1932 and 2165 in file admin/model/tool/export.php contain this for the Categories and Products worksheet:caseyfaber wrote:Hmm, that's funny. I just reinstalled the 1.5.6 version just in case and it always outputs 1 or 0. Is the correct version uploaded on the OpenCart site?
I tried to put it on my demo site so you could test it there, but apparently that server doesn't have ZipArchive installed, so I have to fix that first before you could test it there. However, I downloaded the 1.5.6 version straight from OpenCart, installed it on a fresh OpenCart install, and pressed export, and I got all 1s in those fields.
$this->setCell( $worksheet, $i, $j++, ($row['status']==0) ? "false" : "true", $textFormat );
So sorry, there is no way you can end up with a '0' or '1'!
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I have no problem downloading excel to my computer. But when I imported the data file, it does not show any images in the product section.
Any suggestions?
We can't help you, unless you give us some more details.myfgdesigns.com wrote:I am using Export/Import option by JNeuhoff.
I have no problem downloading excel to my computer. But when I imported the data file, it does not show any images in the product section.
Any suggestions?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Permissions to use the tool must be reset. In admin System / User / User Groups choose admins and then Select All permissions in both boxes, then Save. Then go back into admin Extensions / Modules and Install and Enable the tool. (Sometimes you can get away with Install and Enable before the permissions; the idea is to do all of them before you can use the tool at all.) The permissions required are ordinarily not the chmod 755 directories and 644 files that you should have on the disc, but those should also be in order.
-- Deepa Govind
Zoho Consultant
So, do u think there is something planner for .xml format?
-- Deepa Govind
Zoho Consultant
An additional wrinkle is to look in phpMyAdmin at the export and import formats available FOR the specific host and its specific mysql installation. Some (steadily fewer) hosts CANNOT use .xls or .csv or .xml -- and tiny nuances of .sql syntax can also make or break imports.
Checked phpadmin and it says will accept ods files. so tried importing that format and got:
Fatal error: Call to undefined method PHPExcel_Reader_HTML::setReadDataOnly() in /home/costacar/public_html/store/admin/model/tool/export.php on line 1738. Is there a way to cure this?
Thanks
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Users browsing this forum: No registered users and 32 guests