Image data String for CSV Import

note you can delete the similar topic that apparently got filed under guest. I wanted this under my topics. Sorry....

gteigland 1. What does the first '13' mean

ID of the record in DB

gteigland 2. Is this 1457593200_07d3ee4aedbda1928fb58f4609bb7b24.jpg the thumbnail that is created --- is that necessary when creating csv import

This is name of the file it was saved on the HDD.

gteigland 3. I see this ,mood-girl-camera-hd-wallpaper.jpg,jpg so must i have file extension as well in there as a seperate thing.. as you can see .jpg shows up twice

It is not twice. You can see coma in between. First jpg is part of new file name and secong jpg is the separate column file extension.

gteigland 4. Then at the end a see a 1680.. what is that?

Please look at column name of the table you export from. It is probably size or width or height I cannot say for sure.

ANYWAY

Anywway you do not need any of that information. In your import CSV you have to have images field only names separated by coma. Eg.

myid,images,title
1,"im1.jpg,im2.png","Article 1"
2,"im3.jpg,im4.png","Article 2"

Upload all your images into joomla_root/tmp folder in whatever structure. I mean it might be inside other folders or subfolders. Cobalt imput will look for files recurcevly. Now when you import just indicate tmp as root folder fo images and make sure there are in1-4.jpg somewhere there.

ok. Great thanks. Just a little more clarification as it involves article ID. What if thsee are new and we do not know what the article will be. We are creating a code structure for each article called MCK Code while will be the reference point for the csv import so in case records are updated etc. So for example Article 1 will have refernced code 23-A-309

So as it relates to images what would we put in the "1" and "2" as you referenced in your last example.

Thanks!

gteigland Article 1 will have refernced code 23-A-309

Perfectly fine. You may have anything in your article ID column. Just unique field. It is used for update. If you import the same import rule set, all articles with IDs that was before will be updated instead of creating new.

gteigland So as it relates to images what would we put in the "1" and "2" as you referenced in your last example.

Any iage name. That should fit file name on the disk. That is it.

Sergey

gteigland 1. What does the first '13' mean

ID of the record in DB

Related question: I have created a test export with CSV-formatter plugin and the gallery pack.
Which results in the following columns:

"Title","Created","Modified","Expired","Access","Published","Rating","Hits","Pictures","Album descritpion"

Example excerpt of the first record and first image:

(plugin option set to STRING)
"Christmass is coming","2012-12-21 10:15:08","2012-12-21 10:47:16","","1","1","0","24","21,

(plugin option set to JSON)
"Christmass is coming","2012-12-21 10:15:08","2012-12-21 10:47:16","","1","1","0","24","[{""id"":18,

Obviously, the 21 and 18 are an ID of a particular image inside the gallery field value.
Hence the DIFFERENT ID# for the same record/image! But why are they different?
How and where is this info used and generated? Probably if an image got a rating and comment...
Does it really work with UPDATING a gallery? I mean, am I able to update a part of a gallery or does it update/replace ALL images?

Another thought:
Where is the actual Record ID? IMHO this has to be a separate column in each CSV export. Currently there is no ID.

HI. I am still having an issue importing images via csv using the image gallery field.

Here is what I have under "Images" field in my spreadsheet cell. (again using the image gallery field setup in Cobalt)

"Logo1.png, Title for Logo1, Description for Logo1, Logo2.png, Title for Logo2, Description for Logo2"

Unfortunately nothing shows while everything else imports fine.

As far as images I used this for file image path in uploader: Values seperator , Path to files http://dev.mckcamera.com/mckimages (I created a folder "mckimages" in root of joomla directory and uploaded my images there)

None of my images are showing even though the rest of the data imports fine.

What am I missing here?

Thanks! Gene

gteigland "Logo1.png, Title for Logo1, Description for Logo1, Logo2.png, Title for Logo2, Description for Logo2"

There should not be any spaces and only file names witout titles.

ok thanks. So you are saying that title and description cannot be imported via csv?

gteigland So you are saying that title and description cannot be imported via csv?

Title and descritpion of the files, canot be imported.

I understand your way of thinking. Cobalt have export to CSV and import form СЫМю So I have to be able to export it and then fully restore date from it.

That make sense. But unfortunately it is not true. Cobalt CSV import and export are not compatible and not interchangable.

ok thanks for the clarification. I have figured out a work around and will share that later after I test it.

ok see here is my resolution.

1. On csv under images I simply put in img1.jpg,img2.jpg,img3.png etc. So that will import propertly Note:as long as you uploaded the images into the proper folder AHEAD OF TIME. I created a folder called "mckimages" in my root so on the csv import function I only had to put in mckimages. So my images uploaded properly.

2. Now for Title and Description I created another excel sheet with image file name, Title, Description. So it will be:

column 1: fieldheading is realname - img1.jpg

column 2: fieldheading is title Title you want for image

Colum3: is description Description of image (See screenshot)

http://www.awesomescreenshot.com/image/1114024/03f7e830b684a955b4d680834080aa15

3. Then I'm going to import that excel sheet directly into the mysql database callsed js_res_files using the filename as my unique identifier. So make sure each image file you create is unique in its name which will have to be the case anyway if you are uploading into one folder.

That is also an option.