Welcome to MSDN Blogs Sign in | Join | Help

Sharing Disneyland Digital pictures

A family reunion in Disneyland means bring my camera! I wanted to make sure that the digital pictures I took were saved and shared.

 

If you run out of film with film cameras, you can just buy more film wherever you are. However, when running out of digital storage, it would be nice to have backup digital storage.

 

I brought along my Tablet PC (one of the originals: a 2 ½ year old Acer TravelMate 100) as my main picture storage. My web site is set up with FTP (File Transfer Protocol) and I had web access from our room. It was a simple process to start Internet Explorer and navigate to my FTP site and just copy pictures to my home machine. My sister-in-law had a digital camera too, and I asked if I could copy her pictures to my machine.

 

I wanted to share the 350 pictures (10 rolls of film!) and movie clips with my family. However, that would be a lot of thumbnails to show on a single web page.

 

Because not all family members attended all 8 days. I divided the pictures into 8 daily groups with just 3 lines of code: (for Feb 5 thru 12)

 

FOR i=5 TO 12

      SELECT * FROM pictures WHERE DAY(datetime)=i INTO TABLE ("Reunion"+PADL(i,2,'0'))

ENDFOR

 

 

The “pictures” table was already filtered to Feb 2005 by a simple query for a date range.

 

This produced 8 tables named Reunion05.DBF through Reunion12.DBF

 

Then I just sent email to my family with 8 links to these tables. Much better than going to the photo lab for reprints/enlargements!

 

Click here for more details of how I handle my digital pictures.

Published Monday, February 14, 2005 3:00 PM by Calvin_Hsia
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# Create thumbnails of all your digital photo thumbnails in a single table

Wednesday, July 20, 2005 3:02 AM by Calvin Hsia's WebLog
At least once a week I download my photos to a new folder on one of my computers. As part of that process...

# Create thumbnails of all your digital photos in a single table

Wednesday, July 20, 2005 3:12 AM by Calvin Hsia's WebLog
At least once a week I download my photos to a new folder on one of my computers. As part of that process...

# Draw text or graphics directly onto a JPG file

Monday, July 25, 2005 5:34 PM by Calvin Hsia's WebLog
Here’s some code to manipulate photos using the GDIPlus class library that ships with VFP 9. It creates...

# Play movies with an ActiveX control

Thursday, September 28, 2006 2:28 PM by Calvin Hsia's WebLog
I’ve been using Canon Powershot cameras for years, and they take movies in AVI format as well as being...

# Recompress your digital pictures to save space

Thursday, September 27, 2007 8:41 PM by Calvin Hsia's WebLog

I have 23,000 digital pictures and movies taking many gigabytes of storage from the past decade or so.

Leave a Comment

(required) 
required 
(required) 
 
Page view tracker