42 Content pages with 420 photos distributed among the 42 pages.
What I'm working on:
Trying to put it together now
42 Content pages with 420 photos distributed among the 42 pages.
Need to associate several fields of data with each photo.
Each of the 42 content pages images need a click on/drilldown that progess to an individual node with one photo (of the 420 photos)
A detailed description and information regarding the photo needs to be on each of the individual node pages.
Example-----------Node 1 contains approx 10 photos with link/drilldown on each of the photos to one of 10 individual photo nodes with detailed information.
I been looking over all the possibilities and quite frankly I am neg'd.
It looks like a formidable job to go through this using the images mod or CCK.
The CCK looks like the best go at this point, but my gosh what a pain uploading 420 images one by one. Ugh!
Also, remember there are 420 individual photo pages with data/descriptions and 42 content pages that show appx 10 reduced size images with summary data ability.
Imagecache should take care of reducing the photos for placement on the 42 content pages with appx 10 each pics on each page.
I've spent the last two days just compiling and editing the photos.
This looks like a huge task at this point without some better way of working drupal than I'm aware.
If this was just a Gallery it would be tough enough, but having to place descriptions and data with each page.. a bugger as far as I can tell.
I sure would appreciate suggestions or ideas on a way to work this out where I could save some time.
Thanks
let me do a wild guess ... 10
let me do a wild guess ...
10 photos of countries (i.e UK, US, China) .. total 42 countries
10 city photos for UK, 10 city photos for US, 10 for china ...total 10 x 42 = 420 photos of cities ..
sounds interesting ...
We go the drupal way. How about you?
http://www.drupalway.com
Actually... automobiles to
Actually... automobiles to start
moving onward and upward to aftermarket autoparts.
i do this all the time
i use exhibit module to along with lightbox to manage images.
exhibit can associate info & the link to the enlarged image. This is all done in excel then copy pasted into a .js
You could then put in properties to sort your 42 categories in a facet, all done on one page.
if you are interested in this i can put a more detailed tutorial up for you.
what you would need.
excel
photoshop (batch process your images into proper sizes)
a way to copy & paste the names of the images into excel
exhibit module.
lightbox js
i've got this process down to about 10-15 minutes
I am very interested to know more
I am very interested to know more.
I have the Expression2 studio and several graphic edit programs (no photoshop)
My images are already done and ready to go.
I use the infranview that allows me to do resizing batches and renaming,etc.
I do have Excel. This morning I created over 400 unique names with ID numbers I have assigned to images.
Ford-taurus-6cyl-1964-8233291, etc.
The last number 8233191 is actually the file name of the image, ie. 8233291.jpg
I've not heard of an exhibit module for 6.x drupal. I'll look into that.
That sounds unbelievable... I've been working on this for weeks.
Lets do it!
first lets make an exhibit on locally
make two files new text files, renaming to
test.js
test.html
in your excel you need to make a few columns
id
type
label
image
thumb
sort
id: this should be unique, copy & paste your list of image names here, all 420, you can leave the .jpg
type: image
label: paste your image names here then remove the .jpg
image: images/8233291.jpg
thumb: thumb/8233291.jpg
sort: this will be your facet, what ever your 42 categories are, ie chevy, ford, ect
select entire excel sheet (top left corner)
copy & paste here http://simile.mit.edu/babel/
from format: Tab-Separated Values
to formate: Exhibit JSON
data to convert: the data is text
results mime-type: text/plain
upload & preview, select all (cntl A) then paste into your test.js file.
next in the html file
paste this
<html>
<head>
<link href="test.js" type="application/json" rel="exhibit/data" />
<script src="http://static.simile.mit.edu/exhibit/api-2.0/exhibit-api.js"
type="text/javascript"></script>
</head>
<div id="body">
<div style="width: 100%">
<table cellpadding="0" cellspacing="10" border="0" id="exhibit" width="100%">
<tr>
<td id="left-column" valign="top" width="20%">
<div ex:role="facet" ex:expression=".sort" ex:facetLabel="Filter" id="sort-facet" ex:height="20em"></div>
</td>
<td id="middle-column" width="80%">
<div role="view"
ex:viewClass="Thumbnail"
ex:showAll="false"
ex:possibleOrders=".label">
<table ex:role="lens" class="itemThumbnail" style="display: none;">
<tr>
<td valign="bottom" class="itemThumbnail-thumbnailContainer">
<div> <a ex:href-content=".image"><img ex:src-content=".thumb" /></a></div>
</td>
</tr>
</table>
</td>
</div>
</div>
</div>
</html>
that will get you started, more on how to do the slideshow ect & drupal later
i will be back in 6-7 hrs.
read this for more modifications
http://simile.mit.edu/wiki/Exhibit
slideshow
if you hadn't noticed the code isn't well formed (tables ect), i mostly copy paste & then poke at it till it works. Firefox & chrome are much more forgiving than IE in this regard.
to do the slideshow add the rel= into the lens
<div> <a ex:href-content=".image" rel="lightbox[roadtrip]" ><img ex:src-content=".thumb"> </img></a></div>& add the lightbox javascripts into the header.
<script type="text/javascript" src="js/prototype.js"></script><script type="text/javascript" src="js/scriptaculous.js?load=effects,builder"></script>
<script type="text/javascript" src="js/lightbox.js"></script>
and lightbox css
<link rel="stylesheet" href="css/lightbox.css" type="text/css" media="screen" />this will give you a slideshow of your current facets (ie just the 10 selected or the whole 420)
Maybe... it would be best if you just give me the way to set up
I've been playing with the above.
I cannot use the db I've been working on, can't take out of office.
Been working with one from a past project.
You mentioned a few things to do in excel - here is my visualize of what you mentioned.
Is it correct?
ID--------------------------------|-type-------|-label-------------|-image-------------|--thumb-----------|---sort------------------------------|
franklin-d-roosevelt-833329----- --- Image------ 823339-------------images/823329.jpg--thumb/823329.jpg-----president-of-record-734444-823330
My data is in following form:
Each image name is basic an identifier and URL = franklin-d-roosevelt-823329.jpg names that will be used on site to descibe the image
The actual actual image name is a number which is called by the applicaton = 823329.jpg, this number is placed on the end of the image name to make it easy working with data on the site.
Each Category name = president-of-record-734444-8233330,etc.
hyphens are used as name separators in database.
I'm not to sure how to do the concatenation in Excel of the image.jpg to make it: images/8233329.jpg and thumbs/8233329.jpg
I know it can be done, just been years since I've done it. LOL
Since I only have about 40 records to change in the category separating the name from the number range should be pretty easy to do manually.
Maybe you should peek at the way my db is constructed.
I do not have a way to sort the Image Names to correspond to the image numbers, maybe you have an idea on that.
Something about doing a character count from the right, etc. in Excel. The problem is.. there is a difference in number sizes throughout the data.
Maybe... it would be best if you just give me the way to set up my data and I'll do that, then we can go from there.
The reason I set numbers behind the names was for SEO, but I still need the numbers to work quicker with the data.
Thanks
a little help
i usually try to leave something to do a find/replace in my image name list, but i actually have a program that will export a list of files to a .csv that includes the local path.
the excel formula concat is =CONCATENATE(E4, F4), i would do that in a separate file & then copy the values into your excel db.
did you take a look at the exhibit examples, they have an excellent presidential one.
http://simile.mit.edu/exhibit/examples/presidents/presidents-2.html (firefox is being really slow, they might be working on something today, edit i think its only exhibits with the google maps js)
if you notice the little orange scissors on the top right you can look at their json data & then look at the source to see how they using it.
I would recommend just making a simple exhibit using some fill in info to get a feel for things & then populate the columns when you get into work.
once you get everything going getting it into drupal is fairly simple. The exhibit module has a area to put your feeds in, i had success with this url for the feed.
./sites/default/files/yourfolderstructurehere/data01.js
& this url for the images
/sites/default/files/yourfolderstructurehere/imagename.jpg
node urls are easy, just the node #
40
Sorry I haven't gotten back
Sorry I haven't gotten back on this.
I got put off on another project and haven't had time to work on this one for over a week.
Hopefully, next week I'll be able to get back on it.
This is one mod I have to conquer.
I've got two more additions coming up that haves over 600 database items with pictures and associated data.
I appreciate your help
no problem
Exhibit was built to be shared. Enjoy.