SQL Server not writing IPTC keywords

Post Reply
moritz
Posts: 14
Joined: 02 Jul 12 21:59

SQL Server not writing IPTC keywords

Post by moritz »

I am currently running the trial version of Photosupreme with SQL server. After tagging an image the IPTC keywords are not being written into the file even after doing a manual metadata write. Has this something to do with the trial version?

Also, the search does not work. It does not find any of the keywords currently used. I have started to rebuild the search database based on another post with the script "Catalog.BuildSearchData;". The script window has been unresponsive for over an hour now but the SQL Server process is churning in the background so I'm hoping it does its job.
moritz
Posts: 14
Joined: 02 Jul 12 21:59

Re: SQL Server not writing IPTC keywords

Post by moritz »

Update: the rebuilding of the search data finished but has not made a change. Any tag entered in the upper right search comes out empty.
moritz
Posts: 14
Joined: 02 Jul 12 21:59

Re: SQL Server not writing IPTC keywords

Post by moritz »

After looking into this a bit more I found the problem. The images are on a network drive in our office and are "Read & Execute" only for Users. I tested on an image where I had "Write" access and keywords were written fine into the image.

So, does every PhotoSupreme user need Write access or is it enough if the account hosting SQL Server Express has Write access?
Hert
Posts: 7870
Joined: 13 Sep 03 6:24

Re: SQL Server not writing IPTC keywords

Post by Hert »

For the client to write directly to the file would indeed need write access to the file. If that's not feasible then you can also opt to a dedicated person (with write access) regularly synchronize all out of sync images with "Tools -> Save metadata to file for all Out of Sync images"
This is a user-to-user forum. If you have suggestions, requests or need support then please send a message
moritz
Posts: 14
Joined: 02 Jul 12 21:59

Re: SQL Server not writing IPTC keywords

Post by moritz »

Thank you. Any suggestions on what to check why the search is not working? The SQL Full-text Filter Daemon Launcher is running and setup per the instructions.
vlad
Posts: 895
Joined: 01 Sep 08 14:20

Re: SQL Server not writing IPTC keywords

Post by vlad »

moritz wrote:Also, the search does not work. It does not find any of the keywords currently used.
Are you talking about labels or keywords? Could you give an example of a search and where is the looked up item stored?
moritz
Posts: 14
Joined: 02 Jul 12 21:59

Re: SQL Server not writing IPTC keywords

Post by moritz »

I am talking about any search query entered in the upper right search bar. I have images that are assigned to categories. When looking for a category name I do not get the drop down of possible category options and after hitting enter the search result is empty. The same if I search for an image name, no result.
The loupe is set to search "All".

I am guessing it has something to do with the SQL Express database setup but do not know for sure. I had followed the instructions carefully during setup.
vlad
Posts: 895
Joined: 01 Sep 08 14:20

Re: SQL Server not writing IPTC keywords

Post by vlad »

Sorry, I can't help you with the SQL Express db setup. Just wondering: is only the search bar broken for you or other functionality too? How are the filters faring, in particular the label filter and the text filter?
moritz
Posts: 14
Joined: 02 Jul 12 21:59

Re: SQL Server not writing IPTC keywords

Post by moritz »

Catalog Label filters work fine as well as Rating and Color filters. Text filters are not working.
vlad
Posts: 895
Joined: 01 Sep 08 14:20

Re: SQL Server not writing IPTC keywords

Post by vlad »

moritz wrote:Text filters are not working.
I am not surprised. Based on repeated observations, I have inferred that the search bar and the text filter share the same underlying functionality.
Post Reply