OpenCart Community

Moonwalker wrote:Does it work with Dependent Options module?
Checked it: after importing the base back all links in options died (((

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.

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

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

JNeuhoff wrote:

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

Your error description is aboslutely confusing and non-reproduceable by others. Each worksheet has only exactly one header row with unique column names.

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?

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?

	public function language($language) {
		return $this->language->load($language);
	}

$this->language->load( 'tool/export' );

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.

JNeuhoff wrote:

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.

I am looking into it, seems to be an issue with PHPExcel_Worksheet::getCellByColumnAndRow method used by the Import.