Skip navigation

Photoshop Lightroom

DhammikaHeenpellaCalculating status...

Currently Being Moderated

How to stop "re-publishing" of my modified photos to Flickr

Jul 9, 2010 12:33 AM

I have uploaded some photos to Flickr through LR3 and later did some changes to some of those photos with in LR3. Now those I modified have been queued up again to be re-published to Flickr which I do not want to happen. I tried doing it by removing it off the "published" cluster. Then the photos I removed appeared in another cluster named "Photos to remove" and have been queued up to remove it from Flick completely - again which I don't want to do.

Can someone please explain how control this?

Thanks in advance.

Dhammika

Currently Being Moderated

Dorin Nicolaescu-Musteață,

Community Member

Jul 9, 2010 1:10 AM

Report

This is not possible.

|
Mark as:
Currently Being Moderated

TK2142,

Community Member

Jul 9, 2010 1:37 AM

Report

dorin_nicolaescu wrote:

This is not possible.

I've modified the Flickr Publish Service (it is part of the SDK) and after this modification I can now choose to skip images when publishing. Skipping in my version moves them back into the "Published" state.

I'm puzzled why the original publish service didn't allows something like this right from the start.

|
Mark as:
Currently Being Moderated

Dorin Nicolaescu-Musteață,

Community Member

Jul 9, 2010 1:43 AM

Report

Well, I went on and run an SQL query on the catalog (AgRemotePhoto.photoNeedsUpdating = 0) and that moved photos back to the "Published" group. But, such methods are not suitable for most users, I think...

|
Mark as:
Currently Being Moderated

njl,

Community Member

Jul 9, 2010 2:01 AM

Report

There is no way to remove the images from the 'to be re-published' section, short of actually re-publishing them, but you can drag and drop the images from the 'for deletion' section back into 'published'.

There are a number of threads regarding this issue and we are hopeful that the problem will be addressed in the first update.

Regards,
Norman

|
Mark as:
Currently Being Moderated

TK2142,

Community Member

Jul 9, 2010 4:44 AM

Report

dorin_nicolaescu wrote:

Well, I went on and run an SQL query on the catalog (AgRemotePhoto.photoNeedsUpdating = 0) and that moved photos back to the "Published" group. But, such methods are not suitable for most users, I think...
Dorin, I'd be indebted to you if you could let me know how you did that.
Did you write a plug-in that loops over the photos in the catalogue?

Where/How can I execute an SQL query that has the effect that you described?

It would be fantastic to be hearing from you.

|
Mark as:
Currently Being Moderated

Dorin Nicolaescu-Musteață,

Community Member

Jul 9, 2010 4:59 AM

Report

I use SQLiteSpy to open the catalog on Windows. On Macs, there are built-in tools, as far as I know.

This will set all photos as published:

update AgRemotePhoto set photoNeedsUpdating = 0

This will set photo identified by its Flickr url as published:
update AgRemotePhoto set photoNeedsUpdating = 0 where url = '<url>'

|
Mark as:
Currently Being Moderated

TK2142,

Community Member

Jul 9, 2010 5:11 AM

Report

Dorin, that's awesome!

I'm assuming you can just open the LR catalogue with out providing a database schema?

To everyone reading this, please be very cautios to what you do to your catalogue. It is easy to corrupt it and make it (partially) unusable.

|
Mark as:
Currently Being Moderated

Dorin Nicolaescu-Musteață,

Community Member

Jul 9, 2010 5:15 AM

Report

I'm assuming you can just open the LR catalogue with out providing a database schema?

There's only one schema in there. SQLiteSpy just show everything that's in the database.

|
Mark as:
Currently Being Moderated

TK2142,

Community Member

Jul 9, 2010 8:51 PM

Report

Dorin, I just got round to trying your workaround and it worked a treat.

Thanks ever so much for sharing this!

Much appreciated, indeed.

|
Mark as:
Currently Being Moderated

franckpaul,

Aug 22, 2010 11:30 PM

Report

Thank you for your instructions, it works as a charm :-)

I wrote some instructions for Mac users, here (but in french) : http://open-time.net/post/2010/08/23/Lightroom-3-et-les-services-de-pu blication

|
Mark as:
Currently Being Moderated

franckpaul,

Community Member

Aug 22, 2010 11:54 PM

Report

Oups double post

Message was edited by: franckpaul

|
Mark as:
Currently Being Moderated

Larban,

Community Member

Nov 10, 2010 11:49 PM

Report

Removing or replacing the keywords on photos stuck in Modified Photos Re-Publish pool and then re-publishing the photos seems to move them to Published Photos.

Just cut and paste the keywords back and re-publish. If the photo did not have any keywords, then add some. This worked for me.

|
Mark as:
Currently Being Moderated

Jasonized,

Community Member

Nov 12, 2010 2:54 AM

Report

Hey TK2142,

Could you make the changes you made available?

Cheers!

|
Mark as: