OpenCart Community

JNeuhoff wrote:

Notice: Undefined variable: fileHandle in
C:\..\www\o\system\PHPExcel\Classes\PHPExcel\Reader\CSV.php on line 147Notice: iconv(): Detected an illegal character in input string in

C:\..\www\o\system\PHPExcel\Classes\PHPExcel\Shared\String.php on line 386Notice: iconv(): Detected an illegal character in input string in

The Export/Import tool doesn't support CSV format, please use XLS format.

I import the same file that I exported. I change nothing on the file.
I mean it is XLS file.

conq wrote: I import the same file that I exported. I change nothing on the file.
I mean it is XLS file.

Since you are using Opencart 1.5.6.1 with its matching Export/Import tool, the Export should create an XLSX file, not XLS. Please use the correct version of the Export/Import tool. If you do, and the Import doesn't work, I'd need your Opencart and a working FTP login in order to examine it further.

JNeuhoff wrote:

conq wrote: I import the same file that I exported. I change nothing on the file.
I mean it is XLS file.

Since you are using Opencart 1.5.6.1 with its matching Export/Import tool, the Export should create an XLSX file, not XLS. Please use the correct version of the Export/Import tool. If you do, and the Import doesn't work, I'd need your Opencart and a working FTP login in order to examine it further.

yes it is XLSX file. The file is here. Please check it : http://ul.to/lpf06wm3
I sent your FTP data but you can't get in. I don't know why.
I really need this import. Please help

conq wrote: yes it is XLSX file. The file is here. Please check it : http://ul.to/lpf06wm3
I sent your FTP data but you can't get in. I don't know why.
I really need this import. Please help

Your file imports just fine on a Opencart 1.5.6.1 server.

Quick question.

I am attempting to call up image files via this tool.

Essentially I am going to dump 3k pictures in my data/image folder via FTP.

Those pictures are labeled by part number.

I have copied and pasted each part number into the image slot. For the life of me, I can't figure out how to make it so I have data/part #.jpeg, gets displayed in excel.

Is there a function in the tool I am missing?

Thanks a bunch for the great tool.

No missing function. Use the tool to draw down an Export of what you have, so the example is there to follow.

Not so minor point of lingo. If ALL are simply in /image/cache/data, then that can be added to fronts of all images. If they're in subdirectories, that will complicate the task below. You upload originals into /image/data/ but the spreadsheet and OC are looking instead at thumbnails generated into /image/cache/data. Notice that in the example Export drawn down before you start, and follow it.

Each image will have its address path (which if you're lucky in prepending them will end with the data/ part), and if there are spaces in the names you'll wish there weren't but you can cure that by editing a command line directory list shunted into a text file (change all " " to "_"). You can Sort another column in the spreadsheet (such as product name) for the numbering sequence, separately sort the image list, then draw latter into former in the correct column. You must set up the numbered images to match the spreadsheet. With paths on their fronts, they wont Sort by number without some macro gymnastics (ignore nose, sort other end). You can try adding paths after the images' column has them in sequence, since you can follow between tree and blocks of common products, then tell Excel to add each path.

Got a problem with permissions that I don't think has been covered here before - I've had a good search on this forum.

I've installed Export/Import on 1.5.6 and it shows at the bottom of the System menu OK. The problem is I cannot give myself permission as 'Top Administrator' in 'Access' and 'Modify' rights as there is no entry for 'tool/export' in the drop-down. Of course if I try to access the tool in the main menu it gives me the 'Permission Denied!' message.

I don't think it is an issue with the tool install as I have in fact now installed it twice via VQMOD and also by manually editing the header files (as a result it appears twice in the menu now). So why is there no 'export' to tick in the rights drop down areas? Probably something really simple but I have run out of ideas so its over to you clever guys for some suggestions...

butte wrote:No missing function. Use the tool to draw down an Export of what you have, so the example is there to follow.

Not so minor point of lingo. If ALL are simply in /image/cache/data, then that can be added to fronts of all images. If they're in subdirectories, that will complicate the task below. You upload originals into /image/data/ but the spreadsheet and OC are looking instead at thumbnails generated into /image/cache/data. Notice that in the example Export drawn down before you start, and follow it.

Each image will have its address path (which if you're lucky in prepending them will end with the data/ part), and if there are spaces in the names you'll wish there weren't but you can cure that by editing a command line directory list shunted into a text file (change all " " to "_"). You can Sort another column in the spreadsheet (such as product name) for the numbering sequence, separately sort the image list, then draw latter into former in the correct column. You must set up the numbered images to match the spreadsheet. With paths on their fronts, they wont Sort by number without some macro gymnastics (ignore nose, sort other end). You can try adding paths after the images' column has them in sequence, since you can follow between tree and blocks of common products, then tell Excel to add each path.

So say I have product numbers

1
2
3

The image location is
data/image/product1.jpg
data/image/product2.jpg
data/image/product3.jpg

I could make columns with
Data/
Image
Jpg

Add them together via a formula to get data/image.jpg

Copy that into my product numbers

Copy that onto a new spreadsheet, delete the formulas and then add the product numbers which should be surrounded by data/image.jpg and then upload that.

Do I need to have the images located on my image directory, prior to import upload. I did what I described earlier and attempted to upload, without the pictures on my image directory and got an error.

I tried the next day without the images process I described earlier and it uploaded fine.

I have problem with the module, it can't work with my 50 000 products store. It load much time and load nothing.

I have increased:
memory_limit 5120M
post_max_size 160M
upload_max_filesize 160M
IN php.ini file from my xampp apache, but no success.

Can you suggest me what i can do?

export/import for opencart 1.5.6.1 installed.
(copied over admin and system folders)

- made changes in the four files indicated in the readme.
- as well as enabling Top Administrator Access and Modify rights

The following error appears after clicking SYSTEM->EXPORT/IMPORT

Warning: require_once(/var/www/admin/controller/tool/export.php): failed to open stream: Permission denied in /var/www/system/engine/front.php on line 35

ilwis wrote:export/import for opencart 1.5.6.1 installed.
(copied over admin and system folders)

- made changes in the four files indicated in the readme.
- as well as enabling Top Administrator Access and Modify rights

The following error appears after clicking SYSTEM->EXPORT/IMPORT

Warning: require_once(/var/www/admin/controller/tool/export.php): failed to open stream: Permission denied in /var/www/system/engine/front.php on line 35

Assuming it has actually been uploaded correctly, give the file /var/www/admin/controller/tool/export.php exactly the same Unix/Linux access rights as the others, such as /var/www/admin/controller/tool/backup.php.

jjqi, did you upload its /upload/ directory or just the contents of its /upload/ directory? Did you upload using an Apple machine, and send up directory contents by directory contents, rather than trees en masse (there's a longstanding difference in how Apples do ftp)?

barnone, yes, you can assemble paths that way rather than tediously typing them, and you can utilize the unassembled paths to sort first rather than losing track of which suites of names are scattered where relative to products' own sequence.

No, the images do not have to be uploaded first. Importing the .xlsx is completely independent of the images themselves. If the images happen to be absent when products happen to be brought up in the storefront, then the images missing won't display, but the database will already know where the images are supposed to be.

crazymaster, memory should be in powers of 2 and that value is way too high for most servers, post must exceed upload, and those two values are way too low for times when elevated values are needed.

memory_limit 512M
post_max_size 999M
upload_max_filesize 998M

Good afternoon.

I found a bug in the module and would like to know how to fix it? In my shop in the lines "Model" I put numbers such as 7890 or 0548, and when the first digit of the model number zero, such as 0548, when exporting the database and 0 disappears in the file corresponds to the field is the number 548 instead of 0548.

Tell me, please, how can I fix it?

In your spreadsheet software, such as Excel or OpenOffice Calc, when you enter the numbers into the cells, you need to format them as strings, not numbers!

Hi,
my version of opencart 1.5.5.1

In my case, when I export the DB (System->Export / Import) to xlsx file I see that some columns in Product list: name, models, seo_keyword have the numbers without zero
for example:
in my database oc_product.model = 08346 in exported file (xlsx) Product:model = 8346
in my database oc_product.description = 08346 in exported file (xlsx) Product:name = 8346
in my database oc_url_alias.oc_url_alias = 08346 in exported file (xlsx) Product:seo_keyword = 8346

How can I fix it?
Thanks.

Hi,

THank you for the nice extension. I only have a problemen. I can export with the extension, but it dosnt import on a new opencart installation after i installed VQmod and the Export/Import tool.

It looks like it dosnt have permission to add queries to mySQL. It uploads the xlsx file and then says : Success: You have successfully imported your categories and products!

Anyone knows the solution or what i did wrong/forget ?

Thanks already!

Flexa wrote:Hi,

THank you for the nice extension. I only have a problemen. I can export with the extension, but it dosnt import on a new opencart installation after i installed VQmod and the Export/Import tool.

It looks like it dosnt have permission to add queries to mySQL. It uploads the xlsx file and then says : Success: You have successfully imported your categories and products!

Anyone knows the solution or what i did wrong/forget ?

Thanks already!

The first thing to do is to look at the server's error_log (ask webhost for it), and OpenCart's system/logs/error.txt.

It was working fine for me but all of a sudden I get this error:

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 76 bytes) in /home/mysite/public_html/system/database/mysql.php on line 30

Can you please help me?

It only takes a few seconds on Google to find out what to do to increase the PHP memory_limit.

barnone, I thought this was answered in Jan. but just noticed that evidently Submit hadn't taken. Yes, you can set up columns for path segments, rightward to files on the rows, then combine them. You can gain a dir *.* /s /b > list.txt on the command line (at the prompt) in Win (another OS will allow similar), copy/paste that into a spreadsheet, and on its left add paths (such as image/data/). You can copy and paste the entire block (few to several columns wide) of cells into an ascii editor (or a word processor doing ascii), where the original columns will be instead tab-delimited, then replace every tab with /, then replace every // with / till there are only / left, then copy/paste that entire block of rows (a block one cell wide) back into a spreadsheet (n rows, 1 column).