Results 1 to 6 of 6

Thread: Batch upload + my sql update.

  1. #1
    Member
    Join Date
    Jul 2003
    Location
    Cornwall
    Posts
    138
    Thanks
    0
    Thanked
    0 times in 0 posts

    Batch upload + my sql update.

    Hi,

    I have the job of organizing 30 000 odd pictures onto a web based system. What I need is a tool to upload a set of pictures with common features to a server and then update the database on that server with those characteristics. E.g the database may be (Imagename, ImageURL, Location, Topic, Weather) So each batch will all have the same tags which need to be added to the DB.

    As I understand it php only offers to do one at a time - as in browse for one after the other and I know enough php to do it that way but its hardly the most efficient considering the volume.

    I've read that a client side script may be in order? Anyone got any ideas? Something like flickr for a private business would be ideal.

    Cheers
    Fix

  2. #2
    HEXUS.net Webmaster
    Join Date
    Jul 2003
    Location
    UK
    Posts
    3,108
    Thanks
    1
    Thanked
    0 times in 0 posts
    try gallery2. It's got lots of picture uploading options and addons although it won't work with a custom database without some tweaking

    http://gallery.menalto.com/

  3. #3
    Member
    Join Date
    Jul 2003
    Location
    Cornwall
    Posts
    138
    Thanks
    0
    Thanked
    0 times in 0 posts
    Thanks i'll have a look at it, if its easily adaptable it looks like something I could use! Any other suggestions if this doesn't work out?

    Thanks!

  4. #4
    Member
    Join Date
    Jul 2003
    Location
    Cornwall
    Posts
    138
    Thanks
    0
    Thanked
    0 times in 0 posts
    Hi that system is so close to what I need. Even lets me set custom fields for the photo. However the batch uploader doesn't adapt to these custom fields and still requires me to update each field individually anyway.

    Any other suggestions?

  5. #5
    Member
    Join Date
    Jul 2003
    Location
    Cornwall
    Posts
    138
    Thanks
    0
    Thanked
    0 times in 0 posts
    P.s The exact kind of thing i'm looking for is like Flickr's uploader. Drag and drop a load of images and select common tags for those images.

  6. #6
    HEXUS.net Webmaster
    Join Date
    Jul 2003
    Location
    UK
    Posts
    3,108
    Thanks
    1
    Thanked
    0 times in 0 posts
    Try this article as a stepping stone http://www.sitepoint.com/article/pho...cakephp-flickr

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. SQL Server Connection string?
    By Stoo in forum Software
    Replies: 7
    Last Post: 04-05-2005, 05:48 PM
  2. Trojan leaps from bogus Windows Update site
    By Steve in forum HEXUS News
    Replies: 1
    Last Post: 12-04-2005, 05:28 AM
  3. STEAM update today
    By ERU in forum Gaming
    Replies: 9
    Last Post: 06-08-2004, 12:58 PM
  4. Have you done all of your windows updates ?
    By Moby-Dick in forum General Discussion
    Replies: 33
    Last Post: 05-05-2004, 01:23 PM
  5. Windows Update flaw 'left PCs open' to MSBlast
    By Bunjiweb in forum Software
    Replies: 10
    Last Post: 19-08-2003, 02:44 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •