The next release of the Export/Import tool will have quite a few changes because of the need to support multilingual and incremental import.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Does it work with Dependent Options module?
Checked it: after importing the base back all links in options died (((
Checked it: after importing the base back all links in options died (((
Hello,
We need help. Extension is very nice, but it override products and categories.
Its possible to import products and categories without overriding ? We have 3 small eshops and we want import all products from this shops to one bigger. Small shop have about 50-70 products. Problem is with category and products ID. When some products have same ID, it will not import them. Best way for us will be to import all and then manualy delete or move categorie and products to needed place.
We need help. Extension is very nice, but it override products and categories.
Its possible to import products and categories without overriding ? We have 3 small eshops and we want import all products from this shops to one bigger. Small shop have about 50-70 products. Problem is with category and products ID. When some products have same ID, it will not import them. Best way for us will be to import all and then manualy delete or move categorie and products to needed place.
No, it won't export nor import the dependent options changes. If you send me a PM with more details about the underlying DB changes done by the Dependent Options module, I can give a quote for the needed work in order for the Export/Import tool to support these changes.Moonwalker wrote:Does it work with Dependent Options module?
Checked it: after importing the base back all links in options died (((
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
How do you do multiple imports without overwriting the data?
For example, due to memory errors, I can only import ~1000 records at a time, which works fine.
But, when I import the next 1000, it drops the database before inserting the new.
Need an option to append instead of always drop and assume the one file is the entire database.
For example, due to memory errors, I can only import ~1000 records at a time, which works fine.
But, when I import the next 1000, it drops the database before inserting the new.
Need an option to append instead of always drop and assume the one file is the entire database.
butte wrote:To save time, kianograph, please insert the actual complete error (or quick set of errors) exactly as they appear in the log.
From that snippet in isolation it seems somehow to have gone through nearly 1,300 rows and there through 1.2 alphabets before balking on one cell with apparently no usual sorts of php errors. That does not compute.
You were exporting rather than importing, so this part may not help unless an error was already imported this way and tainted a database cell (a field/row intersect cell) corresponding to spreadsheet AE1277. Just for kicks, look at cell AE1277 to see whether its format is goofy in comparison to those lying above and below it -- if so, then just copy/paste FORMAT ONLY onto it and retry ("General" may be wrong for it). Also see whether the value in it approximates very closely (but is not) the actual conversion factor between miles and kilometers (1.4..., 0.6...) -- if so, an Excel gremlin is back (Excel can't handle the number), change the value by hand. Granted, those ways out are perhaps too easy, and, again, you exporting rather than importing.
Code: Select all
2014-01-05 13:29:18 - PHP PHPExcel_Exception: Products!AE1277 -> Formula Error: An unexpected error occured in D:\xampp\htdocs\japehkian\system\PHPExcel\Classes\PHPExcel\Cell.php on line 307
Tnx. At AE1277 it has already gone through 1276 records but apparently upon returning one more foredoomed tie through line 307 one more time it then tripped. The solitary cell' format for either Excel purposes or phpMyAdmin purposes is probably wrong.
Odd / irritating / worrisome error with the import / export tool.
Somehow some of the headers are duplicating in the header cell on an export.
I have about 6 headers that look like this one:
length unitlength unitlength unitlength unit
Of course the just started to happen without any known changes by me.
Thought? Fixes? help?
(I'm going to go into my database shortly to see if I can see something there.)
Mike
Somehow some of the headers are duplicating in the header cell on an export.
I have about 6 headers that look like this one:
length unitlength unitlength unitlength unit
Of course the just started to happen without any known changes by me.
Thought? Fixes? help?
(I'm going to go into my database shortly to see if I can see something there.)
Mike
cue4cheap not cheap quality
Your error description is aboslutely confusing and non-reproduceable by others. Each worksheet has only exactly one header row with unique column names.Cue4cheap wrote:Odd / irritating / worrisome error with the import / export tool.
Somehow some of the headers are duplicating in the header cell on an export.
I have about 6 headers that look like this one:
length unitlength unitlength unitlength unit
Of course the just started to happen without any known changes by me.
Thought? Fixes? help?
(I'm going to go into my database shortly to see if I can see something there.)
Mike
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Cue4cheap, are you seeing that in the spreadsheet when you open it (yes), but ALSO in the concurrent .sql whether as Export above or as Backup in OC (apparently no, but you might be one to look, most wouldn't)? Which alarmed you, or both (apparently the spreadsheet)? The difference goes to whether (1) and (2) next are v. important or instead are for peace of mind while (3) next is the problem.
Three wild guesses, albeit guesses for cause. (1) In phpMyAdmin main pain lower left Select All tables, ask it to Check, if all are OK then stop, else ask it to Repair, if all are OK then stop, else look at the residual tables. (2) Unless you can do so yourself, depends upon how well stocked your control panel tools are, ask support to "flush" the database (no, don't turn pale, it's quite normal, it should happen automatically scheduled). (3) Tedious, true, but reboot your own machine, run the basics (anti-malware, anti-virus), defragment, interrogate the little ones in the house, see whether Excel has a problem, etc..
Under the circumstances I would start with (3) as the perhaps most likely problem.
Three wild guesses, albeit guesses for cause. (1) In phpMyAdmin main pain lower left Select All tables, ask it to Check, if all are OK then stop, else ask it to Repair, if all are OK then stop, else look at the residual tables. (2) Unless you can do so yourself, depends upon how well stocked your control panel tools are, ask support to "flush" the database (no, don't turn pale, it's quite normal, it should happen automatically scheduled). (3) Tedious, true, but reboot your own machine, run the basics (anti-malware, anti-virus), defragment, interrogate the little ones in the house, see whether Excel has a problem, etc..
Under the circumstances I would start with (3) as the perhaps most likely problem.
SorryJNeuhoff wrote:Your error description is aboslutely confusing and non-reproduceable by others. Each worksheet has only exactly one header row with unique column names.Cue4cheap wrote:Odd / irritating / worrisome error with the import / export tool.
Somehow some of the headers are duplicating in the header cell on an export.
I have about 6 headers that look like this one:
length unitlength unitlength unitlength unit
Of course the just started to happen without any known changes by me.
Thought? Fixes? help?
(I'm going to go into my database shortly to see if I can see something there.)
Mike
I'll try to be more clear.The header cells do not repeat only the text in the header is repeated.
So instead of just saying
"length unit"
the header cell says
"length unitlength unitlength unitlength unit"
It has happened on 6 of the columns.
But I cleared my VQmod cache and tried again and now it is no longer doing that.
Why it did in the first place may have been because of uploading and trying a different export tool but I don't know how.
Either way solved and happy to have it solved.
Mike
cue4cheap not cheap quality
Thanks for that, it seems to be a first. You found another problem. It also means that the vqcache is concatenating what is not meant to be concatenated and the consequence is going into the data Export, not to the browser and screen.
I'm tring to import this XLSX file in my Opencart 1.5.6 version.
XLSX file can be downloaded here - https://mega.co.nz/#!mAMwFaYI!edD93RmX- ... 9hXBA25VRA
Import goes okay - Success: You have successfully imported your categories and products!
But in ACP when I try to view Products or Categories page it says - No results!
I cant open or view a single product or category.
On the front-end I see the products and categories are imported correctly.
What can be wrong?
XLSX file can be downloaded here - https://mega.co.nz/#!mAMwFaYI!edD93RmX- ... 9hXBA25VRA
Import goes okay - Success: You have successfully imported your categories and products!
But in ACP when I try to view Products or Categories page it says - No results!
I cant open or view a single product or category.
On the front-end I see the products and categories are imported correctly.
What can be wrong?
The Import is by replacement rather than incremental addition. The Import shows in the storefront but not in admin.
In admin, then, the categories and products are simply missing outright? (Seems yes.)
Since you can export and import this should not need to be done at this stage, but . . . In admin System / User Groups / Top Admin / Edit / Permissions in both boxes Select All of them and Save.
In admin, then, the categories and products are simply missing outright? (Seems yes.)
Since you can export and import this should not need to be done at this stage, but . . . In admin System / User Groups / Top Admin / Edit / Permissions in both boxes Select All of them and Save.
I am simply unable to reproduce your error because you are not providing enough details. For a starter, the Export/Import tool only supports one language, and your Opencart's 'config_language' (set in System > Settings > tab Local > Language) should be the same as the language specified in your language_id columns in your worksheets. You may also want to try to set the 'config_admin_language' (set in System > Settings > tab Local > Language) to the same one as your frontend language to see whether it makes any difference.Impaler wrote:I'm tring to import this XLSX file in my Opencart 1.5.6 version.
XLSX file can be downloaded here - https://mega.co.nz/#!mAMwFaYI!edD93RmX- ... 9hXBA25VRA
Import goes okay - Success: You have successfully imported your categories and products!
But in ACP when I try to view Products or Categories page it says - No results!
I cant open or view a single product or category.
On the front-end I see the products and categories are imported correctly.
What can be wrong?
As I said, without further details there isn't any thing else I can think. Try above suggestions, if it doesn't help, send me a PM with your Opencart and PHPMyAdmin login details, and I can take a look at it.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Im having a problem, installed it all up and get this error when i click import/export
PHP Fatal error: Call to undefined method Loader::language() in D:\Domains\powertoolsolutions.co.uk\wwwroot\test.powertoolsolutions.c\admin\controller\tool\export.php on line 6
But there is nothing in the error log at all.
Iv tried re-uploading everything but no joy
Any ideas?
PHP Fatal error: Call to undefined method Loader::language() in D:\Domains\powertoolsolutions.co.uk\wwwroot\test.powertoolsolutions.c\admin\controller\tool\export.php on line 6
But there is nothing in the error log at all.
Iv tried re-uploading everything but no joy
Any ideas?
Assuming you are using Opencart 1.5.5, add this to the system/engine/loader.php file:chris010804 wrote:Im having a problem, installed it all up and get this error when i click import/export
PHP Fatal error: Call to undefined method Loader::language() in D:\Domains\powertoolsolutions.co.uk\wwwroot\test.powertoolsolutions.c\admin\controller\tool\export.php on line 6
But there is nothing in the error log at all.
Iv tried re-uploading everything but no joy
Any ideas?
Code: Select all
public function language($language) {
return $this->language->load($language);
}
Alternatively, you change line 6 of admin/controller/tool/export.php to this:
Code: Select all
$this->language->load( 'tool/export' );
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hi, when i export data and open it in excel column, EAN has bad format. For example in database i have 1234567890123 and in excel cell is 1.2345+12, then when i upload it back to store, all data in EAN column are rewrited to bad format. I try change model file export.php and add textFormat to EAN, now it has text format, but still is displayed as 1.2345+12.
Can you give me advice, how to fix it? Thanks for reply.
Can you give me advice, how to fix it? Thanks for reply.
I am looking into it, seems to be an issue with PHPExcel_Worksheet::getCellByColumnAndRow method used by the Import.freddy87 wrote:Hi, when i export data and open it in excel column, EAN has bad format. For example in database i have 1234567890123 and in excel cell is 1.2345+12, then when i upload it back to store, all data in EAN column are rewrited to bad format. I try change model file export.php and add textFormat to EAN, now it has text format, but still is displayed as 1.2345+12.
Can you give me advice, how to fix it? Thanks for reply.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
OK, I implemented a workaround for this PHPExcel bug. Please re-install.JNeuhoff wrote:I am looking into it, seems to be an issue with PHPExcel_Worksheet::getCellByColumnAndRow method used by the Import.freddy87 wrote:Hi, when i export data and open it in excel column, EAN has bad format. For example in database i have 1234567890123 and in excel cell is 1.2345+12, then when i upload it back to store, all data in EAN column are rewrited to bad format. I try change model file export.php and add textFormat to EAN, now it has text format, but still is displayed as 1.2345+12.
Can you give me advice, how to fix it? Thanks for reply.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Who is online
Users browsing this forum: No registered users and 13 guests
