Calguns.net  

Home My iTrader Join the NRA Donate to CGSSA Sponsors CGN Google Search
CA Semiauto Ban(AW)ID Flowchart CA Handgun Ban ID Flowchart CA Shotgun Ban ID Flowchart
Go Back   Calguns.net > GENERAL DISCUSSION > Technology and Internet
Register FAQ Members List Calendar Mark Forums Read

Technology and Internet Emerging and current tech related issues. Internet, DRM, IP, and other technology related discussions.

Reply
 
Thread Tools Display Modes
  #1  
Old 02-24-2010, 12:20 PM
DavidRSA DavidRSA is offline
Senior Member
 
Join Date: Dec 2009
Location: SFV
Posts: 1,258
iTrader: 32 / 100%
Default Excel gurus - How to make picture catalog

Hi there... I am trying to find if there is a way to automatically pull images into excel. Let's say I have a database of images. If I put the filename of the image into excel, is there a way to automatically have the image appear in an adjacent column? (Kinda like a vlookup but pulls images instead of data.)

Any help will me much appreciated. Thanks!
Reply With Quote
  #2  
Old 02-25-2010, 5:17 PM
Rivers's Avatar
Rivers Rivers is offline
Senior Member
 
Join Date: Feb 2007
Location: Poway, CA
Posts: 1,201
iTrader: 5 / 100%
Default

I know that you can with Filemaker. That's a real database program, not a spreadsheet program.
Reply With Quote
  #3  
Old 02-25-2010, 7:44 PM
aGunForEachHand's Avatar
aGunForEachHand aGunForEachHand is offline
Member
 
Join Date: Nov 2009
Posts: 331
iTrader: 15 / 100%
Default

No function to do this that I am aware of, and I consider myself an Excel power user.
Reply With Quote
  #4  
Old 02-25-2010, 8:30 PM
command_liner command_liner is offline
Senior Member
 
Join Date: May 2009
Location: Heart of the Valley, Oregon
Posts: 855
iTrader: 0 / 0%
Default

Quote:
Originally Posted by DavidRSA View Post
Hi there... I am trying to find if there is a way to automatically pull images into excel. Let's say I have a database of images. If I put the filename of the image into excel, is there a way to automatically have the image appear in an adjacent column? (Kinda like a vlookup but pulls images instead of data.)

Any help will me much appreciated. Thanks!
In general this is not possible. The MS image processing tools fail to
operate on images with more than 2^32 pixels, cannot make low res
images and fail. And they take a long time to do it. Lots of real images
have more than that many pixels. I deal with about 1000 a day.

A quick way to get a basic functionality is to open a _directory_ of
images with the Windows image viewer. Naturally you can just use
Explorer under Windows or Finder on the Mac to do something similar.

** 23 years of working with high-resolution digital images every day **
Reply With Quote
  #5  
Old 02-25-2010, 8:35 PM
Corbin Dallas's Avatar
Corbin Dallas Corbin Dallas is offline
Veteran Member
 
Join Date: May 2006
Location: SD
Posts: 4,387
iTrader: 80 / 100%
Default

images in excel, no.

Access, yes.
__________________
NRA Certified Instructor: Pistol - Rifle - Shotgun - PPITH - PPOTH - NRA Certified RSO

WTB the following - in San Diego
--COLT Delta Elite 10mm Blued
--Steyr M357A1 357SIG
--Five Seven IOM (round trigger guard)

Never forget - השואה... לעולם לא עוד.
Reply With Quote
  #6  
Old 02-26-2010, 11:40 AM
Funbaby's Avatar
Funbaby Funbaby is offline
Senior Member
 
Join Date: Nov 2009
Location: Oakland
Posts: 1,764
iTrader: 0 / 0%
Default

Never found a way to do it automatically.
Reply With Quote
  #7  
Old 02-26-2010, 9:43 PM
Macadelic4's Avatar
Macadelic4 Macadelic4 is offline
Member
 
Join Date: Jul 2008
Location: The free state of Georgia
Posts: 427
iTrader: 12 / 100%
Default

May I suggest a web-based "Content Management System"? I know that may be kinda overkill depending on what you want to do, but in the long-run you'll probably have more flexibility.

And if you're doing this for a business, getting a local webserver/DB running now will make those future "gee, wouldn't it be nice if we had a <xyz> system..." moments a LOT easier to deal with. PM me for details.
__________________
Former (graduated ) Financial Officer of the Marksmanship Club at UCSD. CHECK THEM OUT!

Quote:
Originally Posted by wcnones View Post
Should I give them booze? I have Ralph's brand Kahlua and some Half and Half. Kids like chocolate milk, right?
Reply With Quote
  #8  
Old 06-25-2013, 8:46 AM
stilly's Avatar
stilly stilly is offline
Calguns Addict
 
Join Date: Jul 2009
Location: Currently in a shanty I made in the river bottom by Eastvale.
Posts: 9,615
iTrader: 44 / 100%
Default

Quote:
Originally Posted by DavidRSA View Post
Hi there... I am trying to find if there is a way to automatically pull images into excel. Let's say I have a database of images. If I put the filename of the image into excel, is there a way to automatically have the image appear in an adjacent column? (Kinda like a vlookup but pulls images instead of data.)

Any help will me much appreciated. Thanks!
I am a bit confused. Perhaps the terms are not being used properly.

Excel is a SPREADSHEET, not a database. You can manipulate data in it once you have entered it, but if you already have an image database, then...

What exactly are you doing with this stuff? Limited number of phtos or ever growing? For catalogging images I would go with an already made photo manager that allows you to TAG them with words/names. I would recco ACDSee but well, they have fallen from the graces.

Excel is meant to display textual data from what I understand. You CAN insert photos, but that would be a LOT of work to shrink them down and manipulate them. NOT recommended.



Quote:
Originally Posted by merryflip View Post
Well, I just find one useful tutorial: http://www.xflip.com/tutorials/creat...rom-excel.html
well, great topic, our company would give it a try, thanks!



That is not a tutorial for Excel. Welcome to calguns...

I just found the cracked enterprise version of that program and will be seeing if it is as good as it says it is...
__________________
`Twas brillig, and the slithy toves...

Need GOOD SS pins to clean your brass? Try the new and improved model...


Author of the NY Times Best Selling book: How to Cheat and Win Like a Pro at Solitaire

Last edited by stilly; 06-25-2013 at 9:03 AM..
Reply With Quote
  #9  
Old 06-25-2013, 9:30 AM
ocabj's Avatar
ocabj ocabj is offline
Calguns Addict
 
Join Date: Oct 2005
Location: Riverside
Posts: 7,210
iTrader: 40 / 100%
Default

If you already have a database with images, why not just create tables in that database with the data from your spreadsheet and link/join the tables/columns as necessary to generate the desired output?
__________________

Distinguished Rifleman #1924
NRA Certified Instructor (Rifle and Metallic Cartridge Reloading) and RSO
https://www.ocabj.net | http://jocabphoto.com

My AR15 Service Rifle - Used for CMP/NRA High Power Service Rifle Competitions
My Eliseo R5 (Remington 700) Tube Gun - Used for NRA High Power (Match Category) Competitions
My M1 Garand Service Rifle - Used for JCG Matches, rebuilt by Dean's Gun Restorations
Reply With Quote
  #10  
Old 06-25-2013, 3:04 PM
stilly's Avatar
stilly stilly is offline
Calguns Addict
 
Join Date: Jul 2009
Location: Currently in a shanty I made in the river bottom by Eastvale.
Posts: 9,615
iTrader: 44 / 100%
Default

Quote:
Originally Posted by ocabj View Post
If you already have a database with images, why not just create tables in that database with the data from your spreadsheet and link/join the tables/columns as necessary to generate the desired output?
No doubt. I am not an expert in this area, but it seems like someone is trying to upgrade from the wheel to walking...

Link tables, sounds like a job fast approaching sql server...
__________________
`Twas brillig, and the slithy toves...

Need GOOD SS pins to clean your brass? Try the new and improved model...


Author of the NY Times Best Selling book: How to Cheat and Win Like a Pro at Solitaire
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT -8. The time now is 2:48 PM.




Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2016, vBulletin Solutions, Inc.
Proudly hosted by GeoVario the Premier 2A host.
Calguns.net, the 'Calguns' name and all associated variants and logos are ® Trademark and © Copyright 2002-2016, Calguns.net an Incorporated Company All Rights Reserved.