Submitted by Tom on 2017/02/21 17:38
My Dropbox folder has a different path on each machine -- I checked the Dropbox sync page to see if it should have the same path on each machine. It  does use the same path for each machine, but doesnt say I *have* to use the same path.
 
My problem though goes a little deeper than that, and is:
 
If I send an email with attachment to IQ, it gets saved with a link to the file in the HTML pane.
The file is stored in e.g.
Dropbox/IQBases/MyFile.SNDB.Files/ItemID337_files/FILENAMEhere.xyz
 
As said, my Dropbox folder has a different path on each machine, and the link is not relative -- it starts thus:
file:///F:\Dropbox\ etc.
 
So the link only works on the original machine, or one using exactly the same paths, and makes no allowances for possible movement of the IQ files & folders in the future.
=>  Ideally IQ would take into account that the MyFile.SNDB.Files folder is in the Dropbox folder, and be able to find that path from the Options. But even without Dropbox, a relative path would be preferable:
This would also make the IQ file more future proof, in case the file and/or MyFile.SNDB.Files folder is moved again at a later date. <= this seems very important to me
Do you think that's possible?
 

Comments

Hello. I just want to see if there is a configuration item I missed to ensure that Images I pasted into the Document Pane aren't lost when/if I move the location of my database. Thanks.

Hi Ceedee,

First a warm welcome to the IQ Community ! Your account is now fully enabled (you can create threads and reply)

Image pasted in IQ will be stored in the YourIQBase.SNDB.Files folder

By default, the folder is located in the same folder as the IQBase, but this can be modified in Tools > Options

If you move the database:

  1. If the .Files folder is in the same folder as the IQBase, simply move that folder too, along with the IQBase, to the new location
  2. If the .Files folder is set in Tools > Options > 2.4.10, simply ensure that this path is still correct after the move

IQ will do a "smart" search for files if it doesn't find it, but it is clearly best to have the corrects paths 👍

Pierre_Admin
IQ Designer

Thanks for the quick reply Pierre_Admin! I did a quick test and found that image in the Document pane becomes broken if I move the folder. I am not sure if I messed up somewhere or if this is by design.

Repro step:

  1. Open InfoQube (0.9.117h), click File->New->New IQBase (with sample data)
  2. Enter a new file name.  I picked "Sample" in "C:\Data\Sample\"
  3. In the Welcome Tab, click the top entry, then in the Document Pane on the left, paste in an image
  4. Close InfoQube
  5. Rename the data folder to "C:\Data\Sample1\"
  6. Open "Sample" in the newly renamed folder
  7. Observe that the image is broken.

I also checked Tools->Options->2.4.10 and found that the folder path has been automatically updated to "C:\Data\Sample1\Sample.SNDB.Files"

I examined the html inside and see that the image is linked from "C:\Data\Sample\Sample.SNDB.Files\ItemID1383_files\ItemID1383.jpg". If I manually add the "1" in there, then I get my image back.

I will look into the MHT or MD format and see if they handle images differently.