InfoQube IM - Community

Submitted by alysse on 2008/12/04 14:42

Love using the portable version, but I do have a problem referencing mht files that I create as I move the stick to different computers with different a different amount of drives or drive mappings. At the moment, I am building the database completely on a stick & the mht files also reside on the same stick.

At some point these mht files will reside in a fixed location on a network drive and perhaps I should have started out that way. But the problem begs the answer if at some point I decide to go completely portable in the future.

Is there a way (or will there be) to make a local reference to a drive that Infocube runs from that might have a different letter from machine to machine?

Thanks, al

Comments

[quote=alysse]

Can you explain what exactly you mean by referencing mht files? The HTML pane is set to automatically look into the sub-folder if the stored path is not found, so this should work

I use a seperate folder outside of where the folder for IQ lives. My data (mht files in this case) are stored in a directory that is not a subdirectory of the IQ folder (easier to manage). The reason for this is the computers that are part of the equipment that we build here are fully seperated from the data that we create or use via external servers and should remain independent as the machines are sold. This is done so that the data we create and the licenses that we will purchase will remain inhouse (which is one reason that I love the portability) and not on the machines as they leave the building.

We may decide to use IQ as part of a servicing tool in the field as well, but not yet. I can imagine doing this completely on a usb stick and migrating the generated data back at the factory. In the factory, I will use it to document the production process.

Doing it this way should provide the flexability that I need

However the sndb file is in a sub directory in a folder that contains the subdirectory that the mht files live in.

Thus the database lives here:

E:\SQLNotes Data\Final test new db

And tthe mht files live here:

E:\SQLNotes Data\Final Test new db.SNDB.Files

In the end, the mht files will most likely live completely seperate of the databes folder as I intend to reuse these files for other databases. I think.

I hope that this makes some kind of sense. Let me know. al

OK, I understand, how about if I also searched for the same path, but using the current drive letter? It should handle your special case

[edit] This is now fixed. If the file referenced in the HTML pane is not found, it first tries to do a drive swap to the same drive as the current IQBase. If it is found, it opens it. [/edit]

Pierre, First of all: InfoCube is a fantastic program - you're my hero :) I recently found IQ thanks to superboyac topic on another forum and now I'm on my way to it exclusively :) Going back to main topic: what about any other files? I'm trying to use IC on pendrive for notes and filestore (all things/documents I want to have with me all the time and be able to find them quickly :). Of course I encountered the same problem: paths to files on my usb stick are not relative... :/ As I mainly use only two computers (at home and at work) I handled that by setting fixed drive letter for my pendrive on both computers but I can easily imagine situation when I might to want find some file on another machine (i.e. internet cafe). It is possible IQ would look for a file on a given path by on the current drive? Thanks

[quote=Magnifico_]Pierre, First of all: InfoCube is a fantastic program - you're my hero :) I recently found IQ thanks to superboyac topic on another forum and now I'm on my way to it exclusively :) [/quote]

You're welcome! It is very rewarding to see users who like InfoQube. I've started thinking about this 10 years ago, when it was clear that Ecco was dead, and actually got to start coding 5 years ago. For the last year, I'm full time on this project. so hearing this is great!

[quote=Magnifico_]Going back to main topic: what about any other files? I'm trying to use IC on pendrive for notes and filestore (all things/documents I want to have with me all the time and be able to find them quickly :). Of course I encountered the same problem: paths to files on my usb stick are not relative... :/ As I mainly use only two computers (at home and at work) I handled that by setting fixed drive letter for my pendrive on both computers but I can easily imagine situation when I might to want find some file on another machine (i.e. internet cafe). It is possible IQ would look for a file on a given path by on the current drive? Thanks[/quote]

Linked files (drag-dropped to the grid) can already be relative. Simply set the FilePath value to a relative path. See Link to Files, Folders and URLs. But your suggestion is a good one!

Is it possible to do a global replace in fields? If so, then you could replace the path portion in the 2 fields where the pathing information is referenced. This would allow you to use the databases even on machines where you couldn't play with the letter mappings.

-- Mark

yes and no. There is no search and replace as such (yet) but you can use the properties pane to do something very similar

Double-click on the FilePath field to open it in the scratchpad grid
Click on the FilePath column to sort
Select all items with the same FilePath
Update the FilePath field in the properties pane (typically, remove the absolute path and replace it with the relative path as described here: Link to Files, Folders and URLs
Repeat steps 3 and 4 for the other items

I hope this helps

Hi Pierre. Thanks for the fix. Hope to be able to try it out soon. Would it also make sense to set the path as a setable option?

Thanks, al