Database size

[dcwul62]

Being a newbie:

is there a limit to the database size?
where to set it?

Actually, I'd like the size to be UNlimited. Similarly as to whát I am sending to clipboard.
When the database starts to exceed than -say- 1,5-2GB or so, I'd then like to :
- export clips to text files (add create date-time to the filenames), so they can be indexed by my desktop search tool
- then selectively remove clips

Is this possible?
=

[mouser]

Right now there is no set limit and it should be able to support as large a database as you can throw at it.
I really need to add an export feature, which I will move up on my todo list.

[dcwul62]

Thanks a lot Mouser.

[mouser]

Edit:

I forgot I already added an export feature, it's in the file menu.  Sigh sometimes i wonder how i find my feet in the morning.

[dcwul62]

Thanks.

Yes indeed, it is there.

What I meant is to have the  -contents-  of all (or selected) clips exported to:
a. separate files
b. txt format
c. export files with titles something like "Exported Clip-ddmmyyyy-hhmmss.txt"

Such files can be indexed by a desktop search engine.

Because of the date/time added, in case of exporting again at a later date, CHS will skip or overwrite existing files.

=

[mouser]

Interesting ideas.. let me consider..  i'm definitely open to the idea of supporting more ways of exporting if there is some consensus about which export options would be most useful.

[dcwul62]

Hi Mouser, I coincidentally discovered that each CHS seems to create a new database folder. Is that correct?

My 'settings' are as per below:

=

=

but eh .. the below _really_ indeed what has been created sofar...  
(clipboard copy of the path)

N:\ClipboardHelpAndSpellPortable\Database\Database\Database\Database\Database\Database\Database\Database\Database\Database\Database\Database\Database\Database\Database\Database\Database\Database\Database\Database\Database\Database\Backups

Am not sure how to correct this and/or what I have wrongly tagged or untagged.

The backup size, it seems a bit small, compared to database.

=

=
Cud you shed some light on this?

Thanks.
=

[mouser]

Yipes! Something is definitely going weird.  Can you experiment a bit more and see if you can figure out what it's doing?

[dcwul62]

CHS is creating a new database every day and then a backup of that database.

Database size

and a lot is 'double'

=

=

I am not sure how to solve this.

Guess, export all clips.
Delete the enitre folder.
Unzip the portable version again there.


It is the portable version and I first had it on another drive.
Thereafter I relocated the entire folder to another partition, created a shortcut on my desktop.

Maybe it got confused somewhere? I don't know.

I checked the CHS folder on the original drive, but no files have been changed since July, so that version could be deleted.

=

=
thanks.

p.s.: later, ooops, I thought only a thumbnail would be displayed of the foldertree and one should click on it to view it.
it is stored on Photobucket, as I felt it would be too big here.

[mouser]

that is just insanity..

I wouldn't have thought it was possible to cause CHS to do this, so i'm keen to figure out what in your settings might be causing it.

But one thing that jumps out is in your ConfigDir.ini file, you should not have the \Database part.  it should be
N:\ClipboardHelpAndSpellPortable

And then the program will automatically know to use the Database subdirectory for the database, and the main directory for its settings.

That would explain why you get one level of repeated directories (N:\ClipboardHelpAndSpellPortable\Database\Database) but not the infinite recursion.. that's surely a bug..  i'll try to find it.

Meanwhile you can backup and then fix your ConfigDir.ini and delete all those folders and start again, and see if it comes back.

Can you also check the "Image Capture" tab and see what it says for "Image File Naming"?

[mouser]

Also you mention ConfigDir_Default.ini.
Can you check if you have a ConfigDir.ini also?

You should be editing ConfigDir.ini to customize it, and leave the Configdir_Default.ini alone.  It will work if you edit ConfigDir_Default.ini, but that file might get overwritten if you accidentally unzip a new portable version.

[mouser]

Before you try to fix it as we've discussed -- i've sent you a debug version i'd like you to try, to see if we can identify the problem.

[dcwul62]

a)  already changed the ConfigDir_Default.ini to
CONFIGDIR = N:\ClipboardHelpAndSpellPortable\
exit relaunched

b) changed the folder under backup/maintenance accordingly.

=

=

c) managed to restore a database-backup

d) when I clipboard anything and EXIT CHS then indeed only
N:\ClipboardHelpAndSpellPortable\Backups and
N:\ClipboardHelpAndSpellPortable\Database

are being updated.

e) I noticed that all the files in those N:\ClipboardHelpAndSpellPortable\Database\Database\Database\Database\Database-subfolders, actually, they were identical.
I ran Duplicate File Detective and all sizes/dates/hashes are the same - I delete those - they are small as well, 12,0kb 20kb etc. and july dated.

f) I did not touch the
ClipboardHelpAndSpell.ini
ClipboardHelpAndSpell_UserTools.ini

I guess everything is okay now.

My mistake by adding \database to the configDir.ini   ahum .. 

As always many thanks for the help!
=

[cranioscopical]

Sigh sometimes i wonder how i find my feet in the morning.

-mouser (August 23, 2013, 02:16 AM)

Tried removing your socks before sleeping?
 

[mouser]

An important tip:

If you are saving to the same directory as the app runs from, as suggested by your paths,
then you do not have to put these hardcoded full paths everywhere.

In the backups tab of options, just put "Backups" as the directory -- no need to specify the full path!

And in ConfigDir.ini, just put
PORTABLE = TRUE
or
CONFIGDIR = .

There is no need to specify the paths explicitly unless they are pointing somewhere other than the location of the ClipboardHelpAndSpell.exe.

Even if your ConfigDir.ini file is specifying an explicit path, the backup options tab can just specify "Backups" as the backup directory and it will go into a subdirectory named Backups of where the configuration file is stored.  The only time to specify a full path there is if you are putting it in some backup location on a totally different path.