PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > General Forums > General Discussion

General Discussion General use discussion forum for PhotoPost products.

Reply
 
Thread Tools Rate Thread Display Modes
Old July 31st, 2004, 08:03 AM   #1
nbenton
Member
Verified Customer
 
Join Date: Jun 2004
Posts: 30
Is there a way to do global edits of the database?

Is there a way to do a global edit of the database? For example, can I select all of the pictures in a category, and have an additional keyword inserted, or change a particular keyword to a different keyword?

If there is not a direct PhotoPost approach, is there a desktop approach? I know that I can back up the database. Is there an application that converts the database to a desktop file format (like a spreadsheet) and then converts it back to the PhotoPost format?

Ned Benton
nbenton is offline   Reply With Quote
Old July 31st, 2004, 12:53 PM   #2
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 75,143
The only way to mass edit the database is through the mysql replace command where you do a search on a field and replace all keywords with something else.

Now I would be very careful when doing this and backup your database before doing this

UPDATE pp_photos SET keywords = REPLACE(keywords, 'oldkeyword','newkeyword');

Note I used pp_ as the prefix you may need to change it.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old August 1st, 2004, 02:01 PM   #3
nbenton
Member
Verified Customer
 
Join Date: Jun 2004
Posts: 30
Using the same strategy, could I insert a keyword in all of the photos in a category (but not all the the photos in the dataset?

Could I do this in a field that I defined myself?
nbenton is offline   Reply With Quote
Old August 1st, 2004, 02:05 PM   #4
donb
Guest
 
Posts: n/a
Yes, you could. Just tag a WHERE cat=X to the end of the above.
  Reply With Quote
Old August 1st, 2004, 02:17 PM   #5
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 75,143
As Don said

UPDATE pp_photos SET keywords = REPLACE(keywords, 'oldkeyword','newkeyword') WHERE cat = 'X';
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old August 2nd, 2004, 06:00 AM   #6
nbenton
Member
Verified Customer
 
Join Date: Jun 2004
Posts: 30
If there is no keyword (so I'm not replacing, I'm inserting a new one) do I leave the "oldkeyword" variable blank, or is there a different command?

Is there a basic summary of the mysql commands somewhere?

Can I copy the image filename into a field, so that when I change the title the filename is still in a field?

Thanks

Ned Benton
nbenton is offline   Reply With Quote
Old August 2nd, 2004, 07:02 AM   #7
donb
Guest
 
Posts: n/a
UPDATE pp_photos SET keywords='blah' WHERE cat = 'X';

www.mysql.com
  Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Global Register Off neopiper Before You Buy 1 January 15th, 2005 09:55 AM


All times are GMT -5. The time now is 07:42 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.