CSV Resource Library's and Images

[quenncy]

Is there a way to upload images to a certain folder in your /resources/ image folder and incorporate it in to your CSV Resource File so you can gain a Resource ID to include in your Product CSV file?  This will be helpful on the thousand of items I have to enter. I also already have the images setting on my server for my items.


Thanks in Advance, 
Quenncy

[abantecart]

Yes you can import to resource library. There is a small typo in 1 file that you need to change in version 1.1.1 and prior.

Fix:
open file: /admin/model/tool/table_relationships.php
Find line 35:

Code: [Select]

$this->sections['resource_library'] = array(
'id' => 'resource_id',
'relation_ids' => array( 'resource_id', 'type_id' ),

Replace with:

Code: [Select]

$this->sections['resource_library'] = array(
'id' => 'resource_id',
'relation_ids' => array( 'type_id' ),

Steps to import
1. FTP new images to /resources/image/ directory. Do not replace existing
2. Create CSV import file (see example attached)
NOTE: resource.type_id for image type is 1
3. Load CSV 
4. Check Recourse Library for new added images.

Similar any other types can be loaded. In version 1.1.2 resources can be loaded together with products, categories, etc. Improvements are coming
 

[quenncy]

Oh great thanks so much for the answer, it is greatly appreciated.

I do have another question, I use AbanteCart via my hosting server and I have downloaded the upgrade only to manually install 1.1.0 to 1.1.1 but there is nothing in the downloaded upgrade (abantecart.googlecode.com/files/abantecart_v1.1.1.zip) except the XML file with any data shown in the properties but the rest of the files/folders are empty.
Is this all that is needed to upgrade my server files manually from 1.1.0 to 1.1.1 prior to using your instructions above for ver. 1.1.1?

Thanks,
Quenncy

[abolabo]

Oh great thanks so much for the answer, it is greatly appreciated.

I do have another question, I use AbanteCart via my hosting server and I have downloaded the upgrade only to manually install 1.1.0 to 1.1.1 but there is nothing in the upgrade (abantecart.googlecode.com/files/abantecart_v1.1.1.zip) except the XML with any data,  meaning the rest of the files/folders is empty except for the package.XML file. Is this all that is needed to upgrade my server files manually prior to using your information above?

Thanks,
Quenncy

upgrade package for v1.1.0 contain only php-files. Just replace files.
p.s. do not forget do backup.

[quenncy]

upgrade package for v1.1.0 contain only php-files. Just replace files.
p.s. do not forget do backup.

An may I please have that URL for this upgrade (php-files) that you are speaking of?  The ver. 1.1.1. Upgrade that I downloaded (abantecart.googlecode.com/files/abantecart_v1.1.1.zip) did not have no PhP files, just simply 1 XML file & 7 empty folders as shown in the screen shoot.

Thanks so much for the education,
Quenncy 

[abolabo]

You have trouble with your unarchiver.
Our package is correct and contains files.
try to install this stuff http://www.7-zip.org/ and unpack

[quenncy]

You have trouble with your unarchiver.
Our package is correct and contains files.
try to install this stuff http://www.7-zip.org/ and unpack

I downloaded your new zip program and replaced my winrar program and the upgrade unzipped just fine now. I really don't know why winrar was not unzipping it correctly?

Ok so after unzipping file I attempted to manually upgrade to ver 1.1.1 from 1.1.0 on my server I get only text showing up and no images (Screen Shoot).
Here is what I did, I made a back up copy of all 4 folders first that I was going to replace on my server, then I took the four folders in the "Code" folder and uploaded them to where my others existed (public_html) replacing all the folders and contents.
What should I do now or better yet what am I doing wrong?

Thanks as always in advance my friend,
Quenncy

[quenncy]

You have trouble with your unarchiver.
Our package is correct and contains files.
try to install this stuff http://www.7-zip.org/ and unpack

I downloaded your new zip program and replaced my winrar program and the upgrade unzipped just fine now. I really don't know why winrar was not unzipping it correctly?

Ok so after unzipping file I attempted to manually upgrade to ver 1.1.1 from 1.1.0 on my server I get only text showing up and no images (Screen Shoot).
Here is what I did, I made a back up copy of all 4 folders first that I was going to replace on my server, then I took the four folders in the "Code" folder and uploaded them to where my others existed (public_html) replacing all the folders and contents.
What should I do now or better yet what am I doing wrong?

Thanks as always in advance my friend,
Quenncy

Ok friend, I have found my error it seems. Just as you said earlier "Only the PhP files". I have replace ONLY the PhP files in the upgrade file to my server in the same folders they came from and all works very well it seems.

Thanks so much as you where wonderful.

Thanks again,
Quenncy

[quenncy]

Yes you can import to resource library. There is a small typo in 1 file that you need to change in version 1.1.1 and prior.

Fix:
open file: /admin/model/tool/table_relationships.php
Find line 35:

Code: [Select]

$this->sections['resource_library'] = array(
'id' => 'resource_id',
'relation_ids' => array( 'resource_id', 'type_id' ),

Replace with:

Code: [Select]

$this->sections['resource_library'] = array(
'id' => 'resource_id',
'relation_ids' => array( 'type_id' ),

Steps to import
1. FTP new images to /resources/image/ directory. Do not replace existing
2. Create CSV import file (see example attached)
NOTE: resource.type_id for image type is 1
3. Load CSV 
4. Check Recourse Library for new added images.

Similar any other types can be loaded. In version 1.1.2 resources can be loaded together with products, categories, etc. Improvements are coming

My friend,  well I am still having a bit of trouble if you could straighten me out on the issue it would be greatly appreciated.
I first upgraded from ver. 1.1.0 to 1.1.1 by merely updating all the PhP Files ONLY on my server and all works well there then I done just as directed in the quote above by correcting the typo issue in ver 1.1.1. on line 35,36,37 of  the /admin/model/tool/table_relationships.php & then used your example and created about a 50 lines in a csv file then attempted to import but continue getting this error "Data is empty or corrupted."  I have also attached my a pic of the CSV file that was formed from your example.

Any thoughts or ideas,
Quenncy 

[quenncy]

Just checking in to see if anyone might have a answer to the above problem.

Standing by, Thanks
Quenncy

[andrew.mikhailyk]

Hello.

Please give me example of your CSV file.
Screenshot is not enough, sorry.

[quenncy]

Hello.

Please give me example of your CSV file.
Screenshot is not enough, sorry.

How would you like me to give you a example if not by screenshot?

Awaiting,
Quenncy

[quenncy]

Update:  It has something to do with Office (Excel 2007) because if I save it in a tab delimited txt format it works fine uploading but in any form of comma delimited csv format (mac, ms-dos or delimited csv) it fails every time. Wonder what could cause that issue?

Thanks,
Quenncy

[andrew.mikhailyk]

In my experience Excel may modify file in unexpected way.
Different versions of Excel may use different symbols/methods to enclosure columns, delimit them, define line end, etc.
You wrote that with TAB delimiter it is OK. Is it fine to you to use TAB delimiter?

[quenncy]

In my experience Excel may modify file in unexpected way.
Different versions of Excel may use different symbols/methods to enclosure columns, delimit them, define line end, etc.
You wrote that with TAB delimiter it is OK. Is it fine to you to use TAB delimiter?

Thanks Friend