Sql server version of Photo Supreme

[Hert]

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

[stefanknoll]

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]

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]

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

[thenetstriker]

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]

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?

[thenetstriker]

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]

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]

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

[stevehughes]

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]

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]

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