Sql server version of Photo Supreme

Hert
Posts: 5857
Joined: 13 Sep 03 7:24

Re: Sql server version of Photo Supreme

Post by Hert » 26 Sep 13 18:48

In IDimager:
1. From the main menu, select Tools -> Catalog maintenance
2. Import/Export
3. Export Catalog Structure
4. Save to a file

In PSU:
1. From the main menu, select Data -> Import Formatted Vocabulary File
2. Select the file as create in IDimager

Hope that helps
Hert
This is a User-to-User forum which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

stefanknoll
Posts: 7
Joined: 23 Oct 12 17:09

Re: Sql server version of Photo Supreme

Post by stefanknoll » 27 Sep 13 10:19

Hi Hert

Thanks a lot, I think I can cope with that, I already tested it yesterday. Made some changes on the synchronization settings in both applications and will have to re-write my keywords in IDImager first, but I'm fine with that.

Kind regards
Stefan

stefanknoll
Posts: 7
Joined: 23 Oct 12 17:09

Re: Sql server version of Photo Supreme

Post by stefanknoll » 02 Oct 13 16:26

Hello Hert

I'm not sure whether this is the correct thread for my question, but somehow I hope that running PSU on SQL Server has some effect on the solution to my problem: I've migrated my keyword structure from IDImager 5 (desktop) to PSU and most of it worked fine, however I lost the setting of whether parental stucture elements should be assigned or not (in the German GUI, this is what's behind the element attribute 'auch' respectively - on database level - [idProp].[ParentAssign]). Please correct me, if I'm wrong with this.

Is there a way to perform a mass correction of this attribute? I have only few elements that I actually don't want to have assigned, so updating them all to 'Yes' by an sql statement / batch program an changing the particular ones back to 'No' (using the GUI) would save me a lot of time, compared to doing it all manually.

Kind regards
Stefan

PS: I have the SQL Server Management Studio installed

Hert
Posts: 5857
Joined: 13 Sep 03 7:24

Re: Sql server version of Photo Supreme

Post by Hert » 02 Oct 13 17:30

I never recommend updating the database directly. You never know what depends on it. Tomorrow I'll send you a script that updates all catalog labels and sets the Parent Assign flag on
This is a User-to-User forum which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

thenetstriker
Posts: 45
Joined: 05 Jul 10 19:24

Re: Sql server version of Photo Supreme

Post by thenetstriker » 28 Oct 13 11:25

Just for info, my Android Application (https://play.google.com/store/apps/deta ... .idbrowser) does now also support PhotoSupreme databases. Is is possible to just copy the sqlite databases from the PhotoSupreme standalone version to the sdcard of an android device and open this database directly, or to start a webservice on a computer which access the SQL database of PhotoSupreme SQL directly and then provides the data for the Android application over the network.

Hert
Posts: 5857
Joined: 13 Sep 03 7:24

Re: Sql server version of Photo Supreme

Post by Hert » 28 Oct 13 12:42

That's great. I was trying it on my nexus7 and want to connect to my sqlserver database. How do I setup the SQLServer connection?
This is a User-to-User forum which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

thenetstriker
Posts: 45
Joined: 05 Jul 10 19:24

Re: Sql server version of Photo Supreme

Post by thenetstriker » 29 Oct 13 12:07

IDimager wrote:That's great. I was trying it on my nexus7 and want to connect to my sqlserver database. How do I setup the SQLServer connection?
As it is not possible to connect directly to an sql database in Android I had to create an webservice so that the data can be loaded over http. (The advantage of this is that it is also possible to reach your database from outside your network) You can download the webservice from this link: https://www.dropbox.com/sh/l9w5ft5hyfc2lzu/svpMltTUif

IDBrowserService.zip is for IDImager and IDBrowserServiceV2.zip is for PhotoSupreme. There is a small guide inside the zip file how to start the service. It is possible to run the service in an IIS webserver for advanced users and there is also a simple exe which can be started for simple use. (Must be started after every reboot or be added to the autostart) Please also take a look at the .config file if the database connection is correct. It should match the default database name on the local machine, but if you chosen another database name or the database is running on another server you will have to modify the connection properties.

stevehughes
Posts: 76
Joined: 19 Jan 13 3:46
Location: Brisbane, Australia

Re: Sql server version of Photo Supreme

Post by stevehughes » 20 Dec 13 1:49

IDimager wrote:
stevehughes wrote:a brighter glimmer of hope that you might be able to produce a MacOs version of this. Obviously a Windows machine would be needed for the database, but it would be fantastic to have a professional multi-user, multi-platform DAM I can suggest to clients.
It is possible for me to release a Mac version for SQLServer. Currently I don't expect demand for a SQLServer version for Mac users though.

Hert
Hi Hert,

I'd like to purchase SQL version and run it on both PC and Mac. Are you still able to release and support the Mac Version ? Please advise how I get a Mac licence. Can you also provide setup instructions ?

Thanks,
Steve

Hert
Posts: 5857
Joined: 13 Sep 03 7:24

Re: Sql server version of Photo Supreme

Post by Hert » 20 Dec 13 21:21

Hi Steve,
Are you still able to release and support the Mac Version ? Please advise how I get a Mac licence
That is possible. For sales questions, please send an email to sales@idimager.com
Can you also provide setup instructions ?
If you mean SQLServer setup and configuration instructions for PSU then read here:
http://www.idimager.com/Trial/QuickInst ... upreme.pdf

If you mean "setup the Mac version" then that's a matter of running a package.

Hope that helps

Hert
This is a User-to-User forum which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

stevehughes
Posts: 76
Joined: 19 Jan 13 3:46
Location: Brisbane, Australia

Re: Sql server version of Photo Supreme

Post by stevehughes » 20 Dec 13 23:48

Thanks Hert.

That's fine. I thought I remembered you saying something about the Mac SQL version being a bit fiddly to set up on the users machine. But I can't find that reference now so I'll just go with the public perception that, being a mac, it will 'just work'. :-)

Steve.

thenetstriker
Posts: 45
Joined: 05 Jul 10 19:24

Re: Sql server version of Photo Supreme

Post by thenetstriker » 03 Jan 14 14:50

IDimager wrote:Hi Steve,
Are you still able to release and support the Mac Version ? Please advise how I get a Mac licence
That is possible. For sales questions, please send an email to sales@idimager.com
Can you also provide setup instructions ?
If you mean SQLServer setup and configuration instructions for PSU then read here:
http://www.idimager.com/Trial/QuickInst ... upreme.pdf

If you mean "setup the Mac version" then that's a matter of running a package.

Hope that helps

Hert
I am also interested in an SQL Server version of IDImager for Mac. Are you working on such a version or is the demand for this still to low?

Hert
Posts: 5857
Joined: 13 Sep 03 7:24

Re: Sql server version of Photo Supreme

Post by Hert » 03 Jan 14 16:06

After Steve, you'd be the second. If you already own a license for Windows SQLServer then please send me an email at support@idimager.com and I'll send you further details
This is a User-to-User forum which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

Post Reply