Submitted by martym on 2012/03/08 14:23
Hi folks,
 
  New to IQ but long time URP user. I really like the grid concept (kind of like ZOOT programmable folders) but I really miss not being able to store actual files within the database. In URP, I have 3 years of data (email, PDF, Excel, Powerpoint, Word, web pages) stored in a DB. I only have to back up one file and I'm never impacted by linked files being erased or moved. I've survived 4 computers and never lost any data.
 
  I know that linking to files is advertised as a feature. Any chance that you could also add storing the actual files within IQ? The information I manage is much more than text and I can't depend on a file link to remain accurate. I know I could make a copy of every file I wanted to save in the same folder as my IQ database but that is not quite the same as having them nicely compressed within the database.
 
Marty

Comments

Hi Marty !
 
First a warm welcome to the IQ Community forum.
 
IQ currently cannot save files in the database. If the demand is sufficient, it may be added. File linking is encouraged. IQ has "smarts" however when it comes to linking:
  • If a link is not found, it will try substituting drive letter
  • It supports relative links
  • It supports field defined links (FilePath + FileName fields), so you can batch update links
  • And last, it support NTFS shortcuts. This means, it will find the file, even if you move it. To use this, check "Create a Windows Shortcut" when dropping a file
HTH !
 
Pierre

Tom

2012/03/09 08:30

In reply to by Pierre_Admin

[quote=Pierre_Admin]
  • And last, it support NTFS shortcuts. This means, it will find the file, even if you move it. To use this, check "Create a Windows Shortcut" when dropping a file[/quote]
 
Just did an experiment with a shortcut on the desktop -
I change the name of the destination file & it still found it...
 
Is that the case then for IQ + Shortcuts as well?
 
(Also wondering how well shortcuts work when moving machine?)

Pierre_Admin

2012/03/09 09:47

In reply to by Tom

>Is that the case then for IQ + Shortcuts as well?
 
Yes, of course. That's the point. You can rename, move a file and the link still works
 
 
>(Also wondering how well shortcuts work when moving machine?)
No, I believe this works within an NTFS drive only