Uploading photos Automatically....

  • Thread starter Thread starter Wes Conner
  • Start date Start date
W

Wes Conner

Ok, after some research, it appears that this is completly possible,
but is not so easy to set up. My problem is I have little to no skill
with VB scripts, so hope fully someone will be able to lend me a
hand. Regardless of the outcome I would like to thank everyone in
advance.

Photo Upload
On the switchboard there will be a “Photo Upload” button.
On click the script will search for a mounted SD Card. The SD card
will have photos located in the
DCIM folder. All photos will be in jpeg format.
Example: F:\DCIM\photo1.jpeg
Once the photos have been located by the script a prompt will appear,
asking “Do you want to upload XX photos?”
If “No” is selected; The process will be terminated and DCIM will
be opened in Explorer.

If “Yes” is selected; A prompt will appear with the following
Blanks; “Job Number” “Job Address” “Client” and a “Select” button.
These blanks will correspond with the existing record in the
database. Based on the information typed into the blanks a matching
record will be “selected”
Note: Not all of these field will be completed; only one needs to be
completed to define the correct record.
After selecting the record, all the photos will be attached to the
record.
Will I need OLE field for each photo attached to the record?
Once all the photos are attached, a message box will appear confirming
“XX Photos Uploaded”.
If the procedure fails a message will appear “Procedure Failed.”
Once the photos have been attached to the record I would like them to
be moved from the DCIM folder to a new folder named the current date.
The newly generated folder will be located in root with the DCIM
folder, not inside the DCIM folder.

Notes
MS Access 2007
All photos will be in jpg format.
Assume a record will have no more than 100 photos attached (I hope
this is grossly exaggerated)
The Drive letter assigned to the SD Card will not always be the same,
it will range from D through Z
 
Wes

All the best luck in finding someone here (we're volunteers) able/willing to
devote the kind of time to building this for you (or helping you learn how
to build it yourself). If you are under time constraints, you may need to
consider seeking paid help on it.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

Ok, after some research, it appears that this is completly possible,
but is not so easy to set up. My problem is I have little to no skill
with VB scripts, so hope fully someone will be able to lend me a
hand. Regardless of the outcome I would like to thank everyone in
advance.

Photo Upload
On the switchboard there will be a “Photo Upload” button.
On click the script will search for a mounted SD Card. The SD card
will have photos located in the
DCIM folder. All photos will be in jpeg format.
Example: F:\DCIM\photo1.jpeg
Once the photos have been located by the script a prompt will appear,
asking “Do you want to upload XX photos?”
If “No” is selected; The process will be terminated and DCIM will
be opened in Explorer.

If “Yes” is selected; A prompt will appear with the following
Blanks; “Job Number” “Job Address” “Client” and a “Select” button.
These blanks will correspond with the existing record in the
database. Based on the information typed into the blanks a matching
record will be “selected”
Note: Not all of these field will be completed; only one needs to be
completed to define the correct record.
After selecting the record, all the photos will be attached to the
record.
Will I need OLE field for each photo attached to the record?
Once all the photos are attached, a message box will appear confirming
“XX Photos Uploaded”.
If the procedure fails a message will appear “Procedure Failed.”
Once the photos have been attached to the record I would like them to
be moved from the DCIM folder to a new folder named the current date.
The newly generated folder will be located in root with the DCIM
folder, not inside the DCIM folder.

Notes
MS Access 2007
All photos will be in jpg format.
Assume a record will have no more than 100 photos attached (I hope
this is grossly exaggerated)
The Drive letter assigned to the SD Card will not always be the same,
it will range from D through Z
 
Wes

All the best luck in finding someone here (we're volunteers) able/willingto
devote the kind of time to building this for you (or helping you learn how
to build it yourself).  If you are under time constraints, you may needto
consider seeking paid help on it.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


Ok, after some research, it appears that this is completly possible,
but is not so easy to set up.  My problem is I have little to no skill
with VB scripts, so hope fully someone will be able to lend me a
hand.  Regardless of the outcome I would like to thank everyone in
advance.

Photo Upload
On the switchboard there will be a “Photo Upload” button.
   On click the script will search for a mounted SD Card.  The SD card
will have photos located in the
   DCIM folder.  All photos will be in jpeg format.
   Example:  F:\DCIM\photo1.jpeg
Once the photos have been located by the script a prompt will appear,
asking “Do you want to upload XX photos?”
     If “No” is selected; The process will be terminated and DCIM will
be opened in Explorer.

     If “Yes” is selected; A prompt will appear with the following
Blanks; “Job Number”  “Job Address”  “Client” and a “Select” button.
These blanks will correspond with the existing record in the
database.  Based on the information typed into the blanks a matching
record will be “selected”
Note: Not all of these field will be completed; only one needs to be
completed to define the correct record.
After selecting the record, all the photos will be attached to the
record.
   Will I need OLE field for each photo attached to the record?
Once all the photos are attached, a message box will appear confirming
“XX Photos Uploaded”.
     If the procedure fails a message will appear “Procedure Failed.”
Once the photos have been attached to the record I would like them to
be moved from the DCIM folder to a new folder named the current date.
The newly generated folder will be located in root with the DCIM
folder, not inside the DCIM folder.

Notes
MS Access 2007
All photos will be in jpg format.
Assume a record will have no more than 100 photos attached (I hope
this is grossly exaggerated)
The Drive letter assigned to the SD Card will not always be the same,
it will range from D through Z
Click to expand...

I do not have a serious time constraint, and I will be working on it
also. I am learning as I go, I am used to useing the wizard and
useing little scipts, this is alot more than I am used to, =) Thank
you for all the help you have given me in the past.
 
Wes,

Okay, not to be sarcastic but where is the *lend a hand* part? I don't see
where you have any tables, queries and/or forms built. I have to agree with
Jeff, this is kind of over the top for volunteers. So let's try something a
little different.

Some information on pictures storing databases...
http://www.granite.ab.ca/access/imagehandling.htm

Here some information on Data Modeling, might help...
http://www.databasedev.co.uk/data_models.html

Review the above, build some forms and come back with some specific
questions, we'll be here.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Wes

All the best luck in finding someone here (we're volunteers) able/willing
to
devote the kind of time to building this for you (or helping you learn how
to build it yourself). If you are under time constraints, you may need to
consider seeking paid help on it.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


Ok, after some research, it appears that this is completly possible,
but is not so easy to set up. My problem is I have little to no skill
with VB scripts, so hope fully someone will be able to lend me a
hand. Regardless of the outcome I would like to thank everyone in
advance.

Photo Upload
On the switchboard there will be a “Photo Upload” button.
On click the script will search for a mounted SD Card. The SD card
will have photos located in the
DCIM folder. All photos will be in jpeg format.
Example: F:\DCIM\photo1.jpeg
Once the photos have been located by the script a prompt will appear,
asking “Do you want to upload XX photos?”
If “No” is selected; The process will be terminated and DCIM will
be opened in Explorer.

If “Yes” is selected; A prompt will appear with the following
Blanks; “Job Number” “Job Address” “Client” and a “Select” button.
These blanks will correspond with the existing record in the
database. Based on the information typed into the blanks a matching
record will be “selected”
Note: Not all of these field will be completed; only one needs to be
completed to define the correct record.
After selecting the record, all the photos will be attached to the
record.
Will I need OLE field for each photo attached to the record?
Once all the photos are attached, a message box will appear confirming
“XX Photos Uploaded”.
If the procedure fails a message will appear “Procedure Failed.”
Once the photos have been attached to the record I would like them to
be moved from the DCIM folder to a new folder named the current date.
The newly generated folder will be located in root with the DCIM
folder, not inside the DCIM folder.

Notes
MS Access 2007
All photos will be in jpg format.
Assume a record will have no more than 100 photos attached (I hope
this is grossly exaggerated)
The Drive letter assigned to the SD Card will not always be the same,
it will range from D through Z
Click to expand...

I do not have a serious time constraint, and I will be working on it
also. I am learning as I go, I am used to useing the wizard and
useing little scipts, this is alot more than I am used to, =) Thank
you for all the help you have given me in the past.
 
Thank you for the links I will read them and return with what I have.
What would be an acceptable way to share the database I have so far?
Mediafire, rapidshare ect. ect.
 
Wes,

Share??? As much as we all would love to look at every database that
everyone has created... okay <slapping my hand> No sharing... sometimes I
make offers for folks to send me their database so I can have a peek, when I
have time, as I know others do, BUT we don't look at every database. So
unless someone makes the offer, no sharing. Please keep in mind, most of us
have day jobs or business' and this is just because...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Im sorry I misunderstood your previous post,

"... I don't see where you have any tables, queries and/or forms
built..."

I thought you were asking to see them. I also understand that most of
the people here are professionals who have their own problems to
attend to, and do this out of the kindness of their hearts, or the are
very very bored, I did not intend to seem imposing or pushy.
Regardless, thank you again for the reading material.
 
Wes,

That was a reference to your description of what you wanted. It appeared
you had done nothing and expected us to build those objects for you. SInce
then I believe you just want to be pointed in the right direction not have
us *do the building*.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Here's some links about using the Access2007 attachments field (if you go
that route). You can have multiple attachments in one field (don't happen
know what the limit is off the top of my head). You could also store the
photos outside the database.

A good deal of articles about Access and storing pictures are going to based
on Access2003 and earlier and using OLE fields (since the attachment field
is new in Access2007).

http://blogs.msdn.com/access/archiv...-the-new-attachment-field-in-access-2007.aspx

http://msdn.microsoft.com/en-us/library/bb258184.aspx

To be honest, sounds like you are over your head if you have never written
any VBA code.
However if you want to be a programmer you gotta start somewhere.
Wish U luck.

Perhaps an off the shelf image program would work for you needs (not sure if
any allow for slight customizations in how they categorize sets of images)?
People store images for all the vacations they went on, so storing images
for each customer job is not that different. Just an idea. I use google
picasa3 it allows for a few extra bits of info on every folder on images.
Lots of extra functionality as well and it's free. You could tie the image
directory in the database and have a button to launch the image program.
Sorry just rambling now, maybe some of these ideas will help?

HTH,
Mark Andrews
RPT Software
http://www.rptsoftware.com
 
Thank you everyone, I trust it was a pleasant week-end for
everyone.

I have to agree I do believe I am in over my head on this one. I have
an attachment field, and it is incredible simple to use, but my boss
believes that the end users will have to much trouble with it. ( That
worries me ) I have a idea of how to make this easier ( I hope ).
What I need help with is the portion where one button will scan for
the SD Card and offer to attach all photos in the DCIM folder, then
relocate them once complete. I think I have a firm grasp on how to do
everything else. Assume the photos will only go to the current
record, always be Jpg format, using Access 2007, the attachment field
is "photos1411". If anyone is inclined to help me with this I will be
very grateful. I know I am asking for alot, and if I don't find my
solution here I will understand, thank you very much for the help,
links and advice offered so far. This has been the most help I have
ever gotten on the internet. I will be working on this, and have this
page open so I can respond quickly to any comments made. Thank you
again.
 
Back
Top