Single user Photo Supreme to Server Edition and visa versa

Post Reply
pquart
Posts: 58
Joined: 18 Aug 08 20:34

Single user Photo Supreme to Server Edition and visa versa

Post by pquart » 08 Aug 14 22:49

Is there a tool to allow moving from the standalone version to the postgresql version? I have over 70K images and really don't want to have to import all of them again.

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

Re: single user photo supreme to postgresql version

Post by Hert » 11 Aug 14 20:00

Here are the links to the tools that convert data between different editions:

64 bits Windows: http://www.idimager.com/trial/setup64_P ... nge_V1.exe
32 bits Windows: http://www.idimager.com/trial/setup_Pho ... nge_V1.exe
MacOSX: http://www.idimager.com/trial/PSUDataExchange_V1.pkg
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

HCS
Posts: 143
Joined: 19 Feb 14 22:08

Re: single user photo supreme to postgresql version

Post by HCS » 22 Aug 14 18:59

Hert,

Sorry to bother you, but will this conversion program be available to OSX?

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

Re: single user photo supreme to postgresql version

Post by Hert » 22 Aug 14 23:02

Hans, I've added a link to a Mac version in my earlier reply. I haven't been able to test it thoroughly so please let me know if you can get it to work.
Thank you
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

HCS
Posts: 143
Joined: 19 Feb 14 22:08

Re: single user photo supreme to postgresql version

Post by HCS » 26 Aug 14 21:43

IDimager wrote:Hans, I've added a link to a Mac version in my earlier reply. I haven't been able to test it thoroughly so please let me know if you can get it to work.
Thank you
Thanks, i did try today, but the program failed (sent you an email as well) with the following error:
Screen Shot 2014-08-26 at 22.41.34.png
Screen Shot 2014-08-26 at 22.41.34.png (114.63 KiB) Viewed 6226 times

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

Re: single user photo supreme to postgresql version

Post by Hert » 26 Aug 14 23:13

Hans,

Try this in the standard version:
1. Open Tools -> Scripter
2. Start a new script
3. Copy Paste this script

Code: Select all

var
  ADs: TDBXOMClientDataSet;
begin
  ADs := Catalog.NewDataSet;
  ADs.CommandText := 'delete from idSearchData';
  ADs.Run;
  ADs.Free;

  Say ('Done');
end;
4. Wait for it to finish
5. Run the conversion again
6. When successful, start the Server Edition and run this script:

Code: Select all

Catalog.BuildSearchData;
Say('Done');
7. Wait for it to finish (can take a while)

Does that help?
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

HCS
Posts: 143
Joined: 19 Feb 14 22:08

Re: single user photo supreme to postgresql version

Post by HCS » 27 Aug 14 18:48

Thanks for the quick solution, but you (or someone else) needs to get me on the right track (again :-( ).

I have no clue how to open the old, stand alone, database. When i open PSU, always the server catalog is chosen, even if i open from the old catalog file itself.

By the way, i did find that the majority of the migration had actually been completed to the server, in spite of the error. I didn't check for completion though.

Thanks again for your help.

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

Re: single user photo supreme to postgresql version

Post by Hert » 27 Aug 14 20:21

Hans, I've updated the PSUDataExchange tool. Can you download and try it again?

Hope this fixes your issue. If so, then ignore my previous reply about running the scripts.
http://www.idimager.com/trial/PSUDataExchange_V1.pkg
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

HCS
Posts: 143
Joined: 19 Feb 14 22:08

Re: single user photo supreme to postgresql version

Post by HCS » 28 Aug 14 12:45

Thanks!

I read your last post while i was busy preparing for the other action (with the scripts).

I'll give the updated program a run before i resort to the script approach.

HCS
Posts: 143
Joined: 19 Feb 14 22:08

Re: single user photo supreme to postgresql version

Post by HCS » 29 Aug 14 18:29

Hi Hert,

The migration run ended successful !

I'l be checking the content over the coming days, but i expect that everything transferred. Thanks !

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

Re: single user photo supreme to postgresql version

Post by Hert » 29 Aug 14 18:49

That's great news. Thank you for the feedback!
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

liljenstolpe
Posts: 9
Joined: 19 Jun 15 5:18

Re: Single user Photo Supreme to Server Edition and visa ver

Post by liljenstolpe » 19 Jun 15 5:24

I'm curious as to if this tool may help the following use case:

I go on long trips where I am disconnected from my database server. If I want to do my initial cataloging, etc, I think I need to do that with the standalone version. However, when I am back, I want to use the server version. Could I use this tool to migrate the standalone dataset to an existing library in the server version?

Also, can the server version be used "offline" (i.e. showing someone part of the library w/o being connected to the database)?

Christopher

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

Re: Single user Photo Supreme to Server Edition and visa ver

Post by Hert » 20 Jun 15 12:44

Hi Christopher,
The tool converts a complete database so you can't use it to add a stand alone database to your server database as it will replace the server database with the database from the stand alone version. Optionally export the catalog structure from the server and import on your laptop (Data menu->Formatted Vocabulary).

You can use the server version while traveling. Just install it with a database (I recommend PostgreSQL over SQLServer) on your laptop. Then enable ICS writing on the laptop and ICS reading on your server. When returning from your trip, make sure that all your images are in-sync on your laptop (with ICS). Then copy the images to the server folder. There import the images in the PSU-Server. The data from ICS will be read.
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

liljenstolpe
Posts: 9
Joined: 19 Jun 15 5:18

Re: Single user Photo Supreme to Server Edition and visa ver

Post by liljenstolpe » 20 Jun 15 18:46

Greetings,

I was also thinking of using Bucardo (www.bucardo.org) and running two copies of the database (one on the server, one on the laptop), then, when re-connected, do the replication. Has anyone tried that?

liljenstolpe
Posts: 9
Joined: 19 Jun 15 5:18

Re: Single user Photo Supreme to Server Edition and visa ver

Post by liljenstolpe » 20 Jun 15 18:52

Actually, that's a nice db equivalent of the disconnected, but for the database, rather than the images. When you trigger the "connected state" also trigger a bucardo resync (and optionally an image move).

Post Reply