Single user Photo Supreme to Server Edition and visa versa

[pquart]

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]

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

Windows: https://trial.idimager.com/setup64_Phot ... nge_V1.exe

macOS:
https://trial.idimager.com/PSUDataExchange_V1.pkg

[HCS]

Hert,

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

[Hert]

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

[HCS]

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 (114.63 KiB) Viewed 44620 times

[Hert]

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

[HCS]

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]

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

[HCS]

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]

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]

That's great news. Thank you for the feedback!

[liljenstolpe]

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]

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.

[liljenstolpe]

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]

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).