[AccessD] Photo Management

Darryl Collins darryl at whittleconsulting.com.au
Sun Feb 3 16:59:03 CST 2013


Ok.. For doing batch stuff to images (such are renaming, copying, resizing, rotating etc) I use the batch processing function in irfanView.  It is very fast, flexible and easy to set up when processing many images automatically.

For storage management, touch-ups, and general day to day stuff I use Picasa.  The combination of the two has never let me down yet with photo management.

Hope you are enjoying Oz :)

Cheers
Darryl



-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins
Sent: Monday, 4 February 2013 9:53 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Photo Management

Picasa is awesome Bill.

You can choose to upload your pix to the web (it is made by Google so you would need to use a gmail account), but you don't have to and can do everything locally if you want.  You can control which folders Picasa looks at and how often they are scanned.  The touch up tools are excellent and easy to use.  The only thing that pisses me off about it is the Face Tag nonsense.  Even when you turn it off it still wants to tag folks and comes up with that annoy box.  You can get rid of them 1 by 1, but I just want it gone forever. Clearly this is my issue and might be fine if you like tags, but I don't.  Anyway, a moot point really.

Picasa I would highly recommend.

Cheers
Darryl

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Benson
Sent: Saturday, 2 February 2013 3:59 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Photo Management

Thanks Jim, I am aware of that program's existence but not so much its function. I had rather imagined it was more relative to cloud storage. I wanted some way to be sure I was moving (or planning moves) of items on my hard drive, not on the internet. No doubt you've found that you can arrange items on your hard drive without having to put them on the cloud to create your albums, and just synchronize as you go along.

Currently all my files have names like 2010-12-31 21.47.16.jpg, which doesn't help organize. So I wanted to, let's say, have a listbox showing files of this nature, loaded from one or more folders, click on one or more, tag them in a way to help me organize them later... then I could search by tags or combination of tags and all the files tagged with words like family or travel could appear in one location in my dashboard with a preview window and a text box which after selecting any of the returned items, lets me rename it which would affect its true name on the file system, as well as give me some meta data. Essentially this is everything that windows explorer already does except for the deficit that windows explorer does not really show items from more than one folder (ie,
location) at a time, unless in Search mode.

I am trying to create something which acts like windows explorer and also lets me establish list boxes representing new target locations which I can drag and drop or move items to through button clicks, which won't actually move them until I click Execute... and even after doing so, stores in a database table, where the item came from, where I put it, when I did that (note, file last moved is NOT a date field stored by Windows, whereas file last accessed is.... the former being more important to me).

I think I can build an application like this in MS Access so long as I can cause an image control to show a jpg or launch a video in a little window (perhaps via a Flash plug-in). I don't really need to store the file(s), the OS is doing this... I would just be keeping a history of the meta data and giving myself a transport mechanism to move selected items from location to location.

I'll have a look at what Picasa does and see if I am really adding any value or not.

Thanks!!!




On Sat, Feb 2, 2013 at 5:18 AM, Jim Lawrence <accessd at shaw.ca> wrote:

> Hi William:
>
> I am not sure precisely what you want but the wife (and I for a small
> part) keep a lot of photos; many from travelling, art and family. We 
> have well over 30,000 photos.
>
> The program we use to manage all these photo, from anywhere in the 
> network, has an excellent cataloguing system, a good set of filters, 
> format options, sending, emailing, printing, even face recognition, is Picasa, from Google:
>
> http://picasa.google.ca/
>
> It can also, to the best of my knowledge work or be made to work on 
> any platform.
>
> Jim
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William 
> Benson
> Sent: Friday, February 01, 2013 1:10 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Photo Management
>
>  I would not be surprised if this has been tackled either here or on 
> other forums, but I am looking for a way to manage photos and move 
> them from wherever I encounter them in the windows explorer (often 
> showing in preview
> mode) to distinct folders in a variety of locations without performing 
> all required actions at one time. For example, if I encounter 6 among
> 36 files which I think should be moved to a folder called "Friends" I 
> would like to tag them in a way that I can move them all at one time, 
> wherever they are, even when I am no longer looking at the folder they 
> are located in. So I am envisioning some sort of file managing system 
> which is part database, part OS file system manager. I thought Access 
> might be able to do this, perhaps showing me the contents of folders 
> (items which are images) and loading an image control with the image, 
> then I would choose something from a drop down which would help me tag 
> the item while also storing information about where it had been, what 
> it had been named, perhaps giving me a field which lets me rename it 
> (while testing that I am not duplicate naming it) - but doing nothing 
> to the original file until I am ready to execute the operation hich moves and renames all files at one time.
>
> I have found I cannot do this conveniently through the Operating 
> System, and I cannot review planned changes without of course actually 
> executing the changes - by which point in time it is too late. Such as 
> moving something from folder A to folder B and renaming it from X to 
> Y... all the original information is lost and there is no way to undo the change later.
> But if I could retain the old name and location, I could "reset" the 
> operation" by reversing what I had done.
>
> I think a VBA application would help with a project of this nature. 
> Anyone have any ideas how to approach this without reinventing the wheel?
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



--
*Regards,*
**
**
*Bill Benson*
*VBACreations*
**
PS:  You've gotten this e-mail *because you matter to me!*
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list