Stickies
« join merge two databases togeteher - any way »

Welcome Guest. Please Login or Register.
Jan 18th, 2018, 11:47pm


Click for the

Zhorn Software Web Site

Search Knowledge Base:

Search:
  All terms Any terms  

« Previous Topic | Next Topic »
Pages: 1  Notify Send Topic Print
 thread  Author  Topic: join merge two databases togeteher - any way  (Read 715 times)
Tom Revell
Administrator
ImageImageImageImageImage


member is offline

Avatar




Homepage PM

Gender: Male
Posts: 3588
xx Re: join merge two databases togeteher - any way
« Reply #5 on: Mar 21st, 2017, 2:35pm »

Yes, you can copy the RTF content from one instance to the other. If there are any name clashes, just rename the incoming file to something else. You can call the files "tom", "bob" and "leo" if you want, they just need to be unique.

When Stickies next starts, it will see all those new files it knows nothing about and ask to adopt them. The content will come across, but the title, colour, date, position, sleeping details etc will not.

For desktop/stacked/sleeping/closed I suggest you look at the format of the stickies.ini file, and both copy the RTF files and merge the text files. That gets most of the work done. The RTF for stored notes is inside the MDB file, so you can then work to address those separately perhaps.

Tom
User IP Logged

leopoldus
Full Member
ImageImageImage


member is offline

Avatar




PM


Posts: 98
xx Re: join merge two databases togeteher - any way
« Reply #6 on: Mar 22nd, 2017, 03:24am »

on Mar 21st, 2017, 2:35pm, Tom Revell wrote:
Yes, you can copy the RTF content from one instance to the other... they just need to be unique. When Stickies next starts, it will see all those new files it knows nothing about and ask to adopt them. The content will come across, but the title, colour, date, position, sleeping details etc will not.

Thank you again, but I use the all functionality or your application, so the most of my notes has the title, sleeping details, alarms. Notes colours and positions are not random at me, but they have certain system and are relative to the essential information. So it is not a solution to save notes content only, while loosing all their properties. sad

Quote:
For desktop/stacked/sleeping/closed I suggest you look at the format of the stickies.ini file, and both copy the RTF files and merge the text files. That gets most of the work done.

Do you mean to manually merge two files stickies.ini under "merging the text files"? If I concatinate them such way the resulting stickies.ini file would have double set of the sections [Options], [Stacks] and [Stickies]. Will Stickies.exe be able to understand such structure?

Quote:
The RTF for stored notes is inside the MDB file, so you can then work to address those separately perhaps.

Is there any specific reason for such design? Or it is only legacy format which will be changed in the future versions? Would not it be more reasonable to use subfolders in order to save stored notes categories structure?
User IP Logged

Tom Revell
Administrator
ImageImageImageImageImage


member is offline

Avatar




Homepage PM

Gender: Male
Posts: 3588
xx Re: join merge two databases togeteher - any way
« Reply #7 on: Mar 22nd, 2017, 3:32pm »

Why is it the way it is? Yes, legacy. There used to be a companion app to Stickies named "Store" which put its information into an MDB file. Then after a while I folded the functionality into the one app, and in order to avoid everyone who used Store having to mangle their data, I just left the data storage as it was. There was no need to change.

Those reasons still persist - there's no real need to alter the structure now. There is one good reason why you couldn't use folders - what if the user tries to use a character which isn't possible in a folder name. Perhaps were I starting over the data structure on disk would be different, but so far it seems to be working pretty well.

To better explain how to get the contents merged, open stickies.ini.

There are really just two relevant sections - [Stickies] and [Deleted Stickies], again a legacy thing. [Stickies] comprises Desktop, Attached, Sleeping and Recurring. Each line in both sections relates to one file in one of two subdirectories:

o If the line has <IMAGE> on it, then it refers to a file in the "images" subdirectory.
o If the line does not have that, then it refers to a file in the "rtf" subdirectory.

The filename in each case is the same as the string after <ID> on each line.

Before doing anything, make sure that Stickies is not running.

You could copy all the lines from one [Stickies] section in the source ini file, and add them to the same section in the target. Then do the same thing with [Deleted Stickies] lines. Now that the extra lines are present, Stickies will expect to find files with all those <ID> values as well.

Were you to run Stickies without copying the files, then you'd end up with lots of desktop/sleeping notes which all say "Missing content" in them.

Were you to copy the files without editing the stickies.ini, you'd end up with the Orphan dialog popping up, asking you what to do with the new files Stickies has just found.

The one area which is different is Stored notes. All Stored text note content and the metadata for those notes, is inside the MDB file. All stored image notes metadata is in the MDB file, but the content is instead held as PNG files, again in the "images" subdirectory.

Tom
User IP Logged

Pages: 1  Notify Send Topic Print
« Previous Topic | Next Topic »

Donate $6.99 for 50,000 Ad-Free Pageviews!

| |

This forum powered for FREE by Conforums ©
Sign up for your own Free Message Board today!
Terms of Service | Privacy Policy | Conforums Support | Parental Controls