Submitted by jsolka on 2009/06/12 07:15
I know I've asked that before, but it was a long time ago, and I was hoping that maybe something has changed since.
My IQ is growing, and I'm really thinking about separating some grids into different IQ files (bases). But I'm still afraid to do it, because I know it's easier to separate than to put them back together.
 
So:
1. I don't use the calendar yet, but would it be a problem when I start doing it to synchronize the calendar with different IQ files?
2. And I remember that to copy a grid from one IQ file (base ) to another wasn't very easy. (I know it's item you copy, but I'd like to be able to copy the way the are displayed, meaning copying grids, too). Has anything changed?
 
Thanks
Jay

Comments

how big is yoUr IQ file ? If it's not more than 1gb, and if it's not because you're facing hardware limitation (e.g. : your thumb drive is only 256mb), I'd advice against splitting databases.
 
1- At this moment it's really not easy to copy a large  quantity of items from one DB to another (I tried it 3 months ago because of a problem without success)
2- It's much much easier to search into one dB than several.
3- It's easier to stay organized when you only use one
4- The clipper doesn't let you choose to which DB to send your items
etc.
 
My 2 pennies.

jan_rifkinson

2009/06/12 13:37

In reply to by Armando

.. and I assume IQ doesn't search across dBs, does it?
 
--
Jan Rifkinson
Ridgefield CT USA
HP Blackbird Vista Ultimate SP-1

Pierre_Admin

2009/06/12 13:45

In reply to by jan_rifkinson

In due time it will ...

jsolka

2009/06/18 12:22

In reply to by Pierre_Admin

How about copying items?
Take care,
Jay

jsolka

2009/06/18 12:22

In reply to by Pierre_Admin

How about copying items?
Take care,
Jay

Armando

2009/06/18 13:07

In reply to by jsolka

Copying items (XML) works. But it can be a bit shaky, for some reasons, with large quantities (1000s) of items. I think that Pierre is aware of that. And it could very be that the problem is fixed.
Try it.

jsolka

2009/06/19 07:27

In reply to by Armando

And to go back to my original question: will "copying grids" is ever possible to implement?
Take care,
Jay

Armando

2009/06/19 11:01

In reply to by jsolka

It's part of the plan, according to what Pierre said in the past.
There could be different ways to implement that : Mantis issue 579 and 683 .
 
Question : why would you need that for at the moment ? (there might be an intermediary solution)
 

jsolka

2009/06/19 12:50

In reply to by Armando

I just wanted to split my IQ, and know that it will possible to transfer data later on -- should I change my mind. But I guess I'm not gonna do that yet. Another idea was also considered, as far as I remember -- tabs for grouping grids. The problem now is that I don't want to daily copy my IQbase from work to home and back, and I need to do it because otherwise I'm gonna get lost.
Take care,
Jay

Armando

2009/06/19 19:13

In reply to by jsolka

>tabs for grouping grids.
 
You know that the interface can be divided in sections, right ? Just drag and drop a tab an IQ will ask you if you want a new tab group.
 
>The problem now is that I don't want to daily copy my IQbase from work to home and back, and I need to do it because otherwise I'm gonna get lost.
 
the best thing for that is to either :
 
my 2 favorites :
1- Put your DB on a server and access it remotely from home or office
2- Carry your DB on a USB stick with your portable IQ on it. This is probably the easiest by far if you don't forget to carry your USB stick with you.
 
but you could also :
3- backup your DB at the end of each day on a USB stick and synchronize it at home/office. less convenient, more human error prone.

Tom

2009/06/20 09:56

In reply to by Armando

[quote=Armando]
1- Put your DB on a server and access it remotely from home or office
2- Carry your DB on a USB stick with your portable IQ on it. This is probably the easiest by far if you don't forget to carry your USB stick with you.
 [/quote]
 
probably best to encrypt it and give it a password - in case you're not familiar with the procedure for that see Encryption under -- link to nonexistent node ID 90 --

jsolka

2009/06/24 10:13

In reply to by Armando

1. I know about vertical or horizontal multiple windows view, but I meant something different -- some ways of grouping grid tabs under different labels, the tree-like way probably.
2. Is it using USB stick as a permanent drive quite safe?
 
Anyway, thank you all. I need to check drop box -- I didn't know about it.
 
Take care,
Jay

Armando

2009/06/24 15:25

In reply to by jsolka

>1. I know about vertical or horizontal multiple windows view, but I meant something different -- some ways of grouping grid tabs under different labels, the tree-like way probably.
 
You're talking about the grid buttons (from the grid menu, which can be shown as a toolbar), not "tabs", I believe.
Look at mantis issue 150 ; it's an old one and should probably be split since there are a bunch of requests in there.
The one you're asking for is : "Grid names could be organized hierarchically in [the] menu".
 
>2. Is it using USB stick as a permanent drive quite safe?
 
If you make backup, yes.
 
But have a look at drop box and SugarSync. These seem like great solutions if you can easily be connected most of the time.

jan_rifkinson

2009/06/20 12:30

In reply to by jsolka

I use dropbox. simple as hell & works.
 
--
Jan Rifkinson
Ridgefield CT USA
HP Blackbird Vista Ultimate SP-1

Armando

2009/06/20 13:11

In reply to by jan_rifkinson

Forgot about dropbox. Great tip, Jan. Thanks for reminding me.

gregory

2009/06/24 10:31

In reply to by jan_rifkinson

Jan uses Dropbox, and I use SugarSync, which provides:
  1. online backup
  2. synchronisation between multiple computers
  3. web-based access to my files from anywhere where there's a web connection
Why? I'm very lazy, lose or forget things (e.g. USB memory sticks) and, most importantly, want to be able to reorganise my folders in a way which carries across between computers.
 
Mark Gregory, Rennes, France - GMT +1/+2; EST +6

jsolka

2009/06/24 14:50

In reply to by jan_rifkinson

Would you recommend it (DropBox)? How do you use it? Do you keep your entire IQ folder in Drop Box folder or do you just copy a particular IQ base into it when you want it synchronized?
 
Take care,
Jay

Tom

2009/06/24 16:39

In reply to by jsolka

[quote=jsolka]
Would you recommend it (DropBox)? How do you use it? Do you keep your entire IQ folder in Drop Box folder or do you just copy a particular IQ base into it when you want it synchronized
[/quote]
DropBox can only back up the database when IQ closes. (With other apps or filetypes it can backup as soon as the file is saved).
That's possibly not a bad thing as it saves versions of each file as you save the file - with IQ that would probably make for a lot of versions...
 
I use the free version simply as a backup ( from only one computer, never tried the synching). I'm happy with it but havent actually tested it that much - once I recovered an earlier version of a file and it worked but I dont think I'd depend on it's versioning of files - best to have at least a few local backup versions as well.
 
I did a restore of my C drive lately and that seemed to confuse it - in spite of IQ and dropbox folder being on another drive -it renamed the database backup, made a second copy of my database and continued with that which worked fine and seemed the safe thing to do.
 
You have to designate a location for a 'My Dropbox' folder and then keep your database in there. I only have one database in there but also have lots of exported webpages and some other bits n pieces. 
 
Development seems to be slowish - fully deleting stuff in there is akward - maybe they've improved that since I last tried a couple of months ago, you couldnt delete folders+contents in the web interface - you had to delete the files individually. (It keeps copies of anything that was in the Dropbox folder, even if you delete it on your PC - accessible via the web interface)
 
Remember to encrypt and password protect your database - see Encryption -- link to nonexistent node ID 90 -- in manual 

jsolka

2009/06/24 17:08

In reply to by Tom

1. I understand that I keep my ONLY IQ file(.SNDB) in Drop Box folder. How about IQ back up files(.SNBKA)? Is it possible to designate a different folders for .sndb files and .snbka files?
2. Why encrypting is so important?
 
Take care,
Jay

Tom

2009/06/25 04:34

In reply to by jsolka

[quote=jsolka]1. I understand that I keep my ONLY IQ file(.SNDB) in Drop Box folder. How about IQ back up files(.SNBKA)? Is it possible to designate a different folders for .sndb files and .snbka files?
2. Why encrypting is so important[/quote]
1)
see: menu / Toools / options 
2.2.xx   Data Storage
in particular
2.2.5   Backup Folder - you can specify where backup files go - I have them going to a different partition (diff.drive actually)
 
2)  well that's your call . . maybe I'm being paranoid ?
I'm wary of trusting anything these days . . especially once it leaves my pc & goes on the tubes - I believe DropBox is safe enough but havent really researched that aspect of it.
 
Pierre promised the ability to create a shortcut which could include the password but I dont think that's implemented yet (?)

Tom

2009/07/20 12:07

In reply to by Tom

Free version of DropBox now only keeps last 30 days worth of revisions