Show Posts


Messages - castigous

Pages: [1] 2 3
1
Support / Re: Updating/Inserting images (JPG, PNG ...) via CSV file
« on: June 14, 2017, 09:36:38 AM »
Hi!

Thanks for your answer. I get 2 resource_map[0] variables from the documention link I mentioned (at http://docs.abantecart.com/pages/tools/import.html#Example4:insert) where mentions:

resource_map[0].resource_id              = leave empty
resource_map[0].object_name            = products


In that page indicates that for each image there are 8 needed variables (this 2 included) along with othere 6 variables and 5 more for each additional language --BTW can the 2nd language variables be left alone? I mean what happens if I leave them alone?

The thing with exported files is that they have a-whole-lot of columns so is difficult to know which one(s) are the needed ones to fill and/or modify. Also difficult is that since at import there could be a lot errors for not including some column so I´ve been forced to import CSV with ALL the columns even if I mean to insert or update just 2 columns.

Thank you very much for your response! I'll take a look at your attachment to figure things out more clearly.

2
Support / Re: Updating/Inserting images (JPG, PNG ...) via CSV file
« on: June 13, 2017, 05:30:23 PM »
BUMP!

Please Help!!

3
Support / Re: Updating/Inserting categories via CSV file
« on: June 10, 2017, 01:26:06 PM »
Hi!

Since it seems that the CSV file needs all columns even for updating, I tried to import by adding just 5 columns to a CSV exported by AC almost untouched -I only added the action columns with 'update' in each product I need to update, and added the info (2-digit numbers ) for these columns which were blank in the CSV file exported by AC:

products_to_categories[1].product_id
products_to_categories[1].category_id
products_to_categories[2].product_id
products_to_categories[2].category_id

I kept every othe column untouched and the resulting CSV file is about 692K.

But now I get this error:

There has been a critical error processing your request
Please check AbanteCart and webserver error logs for more details. You can check error log in the control panel if it is functional. Otherwise, refer to error log located on your web server


Report this problem to AbanteCart team (do not change email subject)


AbanteCart Troubleshooting Guide

Go to main page
Project Homepage|Documentation|Support Forums|Marketplace



My php.ini for AC folder has this:

session.gc_maxlifetime = 12000000
magic_quotes_gpc = Off
safe_mode = Off
memory_limit = 300M
max_execution_time = 259200
default_charset = "UTF-8"
upload_max_filesize = 200M
session.use_trans_sid = Off
session.use_cookies = On
register_globals = Off
mysql.connect_timeout = 20
zend_extension=/usr/local/php55/lib/php/extensions/ioncube.so
zend_extension=/usr/local/php55/lib/php/extensions/ZendOptimizer.so


What is the problem?

I attach a sample of 6 products of this file.

Thanks

4
Support / Re: Updating/Inserting categories via CSV file
« on: June 10, 2017, 01:05:53 PM »
Thanks!

Since this is an update, I didn't included this variable assuming that since every product already has this 1st category fulfilled (represented by the column products_to_categories[0]).

All i need is to add more categories to the 1st one. So I guessed that the CSV file wouldn't need to include every column that is already fulfilled.

Is this a wrong assumption?

Do I need to include every column also for updates?

Also which of the two files I attached is the correct one to use for this, the one with 'update' in the action column or the one with 'insert'?

Thanks!

5
Support / Re: Error importing CSV
« on: June 09, 2017, 03:41:06 PM »
The link is not opening even correcting the . com part

But last week I got same message so I'm quote the answer I've got:

Quote from: castigous on June 01, 2017, 05:56:04 PM


    But now AC is giving this message after uploading the file:
    Total loaded: 1. Updated: 0. Created: 0. Errors: 1
    There are some errors. Show details
    Incorrect structure of main Array node. Only table nodes are expected



Hello. Please set correct CSV delimiter when you import. In the file attached you have TAB delimiter




****************
BTW I haven't been answered to my last posts (about five) since a week ago --and the last 2 have been seen 18 times without answer.

Is there a problem?

It was wrong for me to try and help someone about a topic where I thought I could help?

6
Support / Re: Updating/Inserting images (JPG, PNG ...) via CSV file
« on: June 07, 2017, 06:48:00 PM »
Here I attach the samples mentioned in the previous post.

I attach 2 almpst identical files, 1t-file with 'update' for the action column, 2nd-file with 'insert' for the action column --I tried both in case that for images AC needed to insert instead of update.

Please somebody help

Thanks!

7
Support / Updating/Inserting images (JPG, PNG ...) via CSV file
« on: June 07, 2017, 06:41:47 PM »
Hi!

Since I haven't had an answer to my topic since last friday --maybe because I added too many sub-topics to it in the late questions. I decided to post in separate topics.

I managed to read again the documentation (at http://docs.abantecart.com/pages/tools/import.html#Example4:insert) about importing and found out that I was missing a lot columns when trying to import the references for the images of each product.

Turns out that for each image there are about 8 columns needed to include in the CSV file.

resource_map[0].resource_id              = leave empty
resource_map[0].object_name            = products
resource_library[0][0].type_id            = 1
resource_descriptions[0][0][0].language_id      = 1  (the id of installed language)
resource_descriptions[0][0][0].name             =    anyname (usually imagefile name)
resource_descriptions[0][0][0].title            =    leave empty or fill if you need title
resource_descriptions[0][0][0].description      =    leave empty or fill if you need description for the resource
resource_descriptions[0][0][0].resource_path    =    somefolder/product_image_1.jpg

So I added the correct 40 columns --differing in their ([0][0][0]) numbering ([1][0][0], [2][0][0]... and so on) for up to 5 images max.

I split into 100-rows CSV files in order to avoid a Gateway error due to a big files with too much data, but even with this small file, when uploading the CSV file I got this error:

"
Total loaded: 6. Updated: 0. Created: 0. Errors: 6
There are some errors. Show details
Insert data error for products SQL Error: Duplicate entry '127' for key 'PRIMARY'
Error No: 1062
SQL: INSERT INTO `abc_products` SET `product_id` = '127'
Missing special relation ID product_id for insert action in table resource_map. Skipping.
Missing special relation ID product_id for insert action in table resource_map. Skipping.
Missing special relation ID product_id for insert action in table resource_map. Skipping.
Missing special relation ID product_id for insert action in table resource_map. Skipping.
Missing special relation ID product_id for insert action in table resource_map. Skipping.
"

I did these CSV files following the instructions on the documentation page which all required columns which are included so I don't know what's going on? Is this a bug at the import?

Please somebody help as I'mpretty stuck at the moment for this problem.

I attach sample of the CSV files.

Thanks!

8
Support / Updating/Inserting categories via CSV file
« on: June 07, 2017, 06:19:56 PM »
Hi!

Since I haven't had an answer to my topic since last friday --maybe because I added too many sub-topics to it in the late questions. I decided to post in separate topics.

Lately what I wanted to do was to update the products already in the database with additional categories --because almost all products belong to many categories (usually up to 3) and not just one.

So I analized the exported CSV file of a products which I added manually and had these 3 categories, and saw that the categories are expressed as these columns:

products.product_id
products_to_categories[1].product_id (same number that in "product.product_id")
products_to_categories[1].category_id (additional category 1)
products_to_categories[2].product_id (same number that in "product.product_id")
products_to_categories[2].category_id (additional category 2)
products_to_categories[3].product_id (same number that in "product.product_id")
products_to_categories[3].category_id (additional category 3)

But I get an error message, no matter if have the 1st column action set as update or as insert:
"
Total loaded: 6594. Updated: 0. Created: 3035. Errors: 3559
There are some errors. Show details
Warning: Update products. All columns are keys, update action is not allowed. Please use insert.
"

I tried with a CSV that had update in al cells of the 1st columns action.

Then I tried with a CSV that had insert in all cells of the 1st columns action.

I attach samples of both options.

Thanks!

9
Hello!??? Anybody!?

I managed to read again the documentation about importing and found out that I was missing a lot columns when trying to import the references for the images of each product.

Turns out that for each image there are about 8 columns needed to include in the CSV file.

resource_map[0].resource_id              = leave empty
resource_map[0].object_name            = products
resource_library[0][0].type_id            = 1
resource_descriptions[0][0][0].language_id      = 1  (the id of installed language)
resource_descriptions[0][0][0].name             =    anyname (usually imagefile name)
resource_descriptions[0][0][0].title            =    leave empty or fill if you need title
resource_descriptions[0][0][0].description      =    leave empty or fill if you need description for the resource
resource_descriptions[0][0][0].resource_path    =    somefolder/product_image_1.jpg

So I added the correct 40 columns --differing in their ([0][0][0]) numbering ([1][0][0], [2][0][0]... and so on) for up to 5 images max-- but when uploading the CSV file I got a Gateway error:

Gateway Timeout

The gateway did not receive a timely response from the upstream server or application.


So I modified the php.ini variables like this:
session.gc_maxlifetime = 12000000
magic_quotes_gpc = Off
safe_mode = Off
memory_limit = 300M
max_execution_time = 259200
default_charset = "UTF-8"
upload_max_filesize = 200M
session.use_trans_sid = Off
session.use_cookies = On
register_globals = Off
mysql.connect_timeout = 20
zend_extension=/usr/local/php55/lib/php/extensions/ioncube.so
zend_extension=/usr/local/php55/lib/php/extensions/ZendOptimizer.so


But still got the same message. Is there something I'm missing?

Thanks!

10
BUMP!

Please someone answer my previous post from friday

Thanks!

11
Support / Re: Language Definitions not changing as expected
« on: June 02, 2017, 04:00:22 PM »
Hi!

Also choose All Languages & GO.

Then don´t change the translation in this page but click the icon Edit for the key you want to change.

This way it should you show the translation for all languages installed and you can verify AC is saving the changes in the language you´re interested to translate.

12
Thanks you´re correct.

All day I have been saving with commas and this file for some reason saved without it  :o :-[

Now, I´m trying to update the info for the already entered products.

To do that I exported the products I entered manually to check their variables and copy to the Update CSV file.

I guess in general to do an update only the action and products.product_id columns are required, right?

So I added the columns I wanted to modify and to add (images URLs)

But AC is giving this message spite that columns added are copied verbatim from the export:
There are some errors. Show details
Unknown table: "" requested in relation to table products. Exit this node

I add a sample CSV file of 3 lines to have a look.

UPDATE: I tried also a file without the images URL but with added categories but I get error too. These are the variables I used for that:
products_to_categories[0].category_id
products_to_categories[1].category_id
products_to_categories[2].category_id
products_to_categories[3].category_id


Should to add more variables to have multiple categories added to a product?

Thanks and have a nice weekend!

13
Hi!

A new question!

Of all the columns in Basara's example file I get where everything goes in each product's edit page except for the column products.subtract. What is its function?

Thanks!

14
Hi!

Thank you all and specially Basara for the attached product csv file. Yesterday after adpating it to a very small subset of my product list the CSV data was inserted fine and without issues.

Now I'm having trouble trying to update this same subset of products. It seems AC is expecting the columns to be in a pre-determined order and if one tries to reorganize columns, AC gives error at updating.

So I created an update file with the columns in the exact same order of Basara's example file --changing the first 2 columns:
- action   - with all cells [update]
- products.product_id    - with the corresponding id for the product files I imported.

But now AC is giving this message after uploading the file:
Total loaded: 1. Updated: 0. Created: 0. Errors: 1
There are some errors. Show details
Incorrect structure of main Array node. Only table nodes are expected


I attach the file to have a look

Many many thanks!

15
Hi!

So I added this columns that were missing:

products_to_stores[0].store_id (0 in all)
products.model (empty in all)
product_descriptions[0].language_id (1 in all)

But now I'm getting a message "Missing relation ID language_id for update_or_insert action in table product_descriptions. Skipping." at importing which mentions the 3rd column I just described.

Also the column products.product_id I'm leaving it empty because it seems AC don't like to be told which ID to use and prefer to assign it itself?

Still stuck even after all suggestions.


Pages: [1] 2 3

Powered by SMFPacks Social Login Mod