Sv: RE: [MI-L] Extracting Table information.
Hi guys! Put this in your registry and the XP Search Companion will look into your wor files as well. No need to re-extentionalize them which would be absolutely impracticable. [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\ContentIndex] FilterFilesWithUnknownExtensions=dword:0001 As always, the usual disclaimer about hand editing the registry applies. If someone knows how to to this in a safe GUI, please step forward. HTH, Mats.E ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Extracting Table information.
Title: Extracting Table information. Joe Nunn wrote: Problem is if it ends in .wor it will not be searched as a text file so temporarily rename your workspace files with .txt at the end with a handy program A.F.5 rename your files. I guess there is a simpler way out there though. There are ways to search for content within WOR files eg, Google Desktop, as previously suggested; or setting the registry flag FilterFilesWithUnknownExtensions=dword:0001 (the attachments here may be renamed from TXT files to REG and will change the registry with this flag either ON or OFF this affects Indexing Service only), and using the Windows search dog (Search Companion). Matthew I thought there was a MBX that did something like this. But a suitable solution for you depends on how many WOR files you have, and what you want to extract or is it just to list all occurrences of Open Table statements? My thoughts: Search: just use Windows Explorer in Windows XP, OR install and use a desktop search tool of your choice (I use Microsofts Windows Desktop Search v3 Beta2 but Google DTS or Copernic DTS or earlier versions of Microsofts Desktop Search like MSN DTS are OK) and configure so that .WOR is searched and indexed. The filter thats used will default to text at least, with Windows DTS where a text iFilter is used. All of these search tools will locate the ?filenames (Open Table statements) that you want, as text within the .WOR file. Making a list: deriving a usable list of the .WOR files that have the particular Tables youre interested in is a further problem, which could require some coding. I think that the proof-of-concept user interface for the Windows Desktop Search called PHLAT (Prototype for Helpful Lookup and Tagging, and created by Microsoft Research) might do the job without coding though. Change: If necessary for those .WOR files located by the search, you can open each for a search/replace with a suitable text editor. I use the free TextPad which can open multiple files, and has good facilities. Again, a VB6 / _vbscript_ / VB.NET application to do this could be coded but why not do it the ad hoc way (text editor or grep)? Another approach would be to write a routine even with MapBasic to do the search. But only if you have a small number of .WOR files. The advantage of the interactive desktop search tools is that theyre very much more efficient, unless youre a moderately competent coder and call the functionality of Windows inbuilt Indexing Service (which Windows Explorer makes use of, by the way). But its not really very hard to code a specific application which uses the Indexing Service, and produces such a list (a VB6 / _vbscript_ / VB.NET application; someones probably done it). IL Thomas GeoSciSoft- Perth, Australia PHLAT - http://research.microsoft.com/adapt/phlat/default.aspx (doesnt work with Windows DTS v3 though) Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\ContentIndex] FilterFilesWithUnknownExtensions=dword:0001 Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\ContentIndex] FilterFilesWithUnknownExtensions=dword: ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
Re: [MI-L] Extracting Table information.
Hi Mathew, Yet another option to look at is a command line or batch file based solution - useful if this will be a regular task: For searching for files containing a certain string, look at the 'find' or 'findstr' commands. To replace strings in a file, I'd use the ssed utility (http://sed.sourceforge.net/grabbag/ssed/) Andrew Mathew Linnane wrote: Is it possible to determine the use of a table within a workspace? * Problem: * I have a mapinfo table and I want to know what workspace /s contain /s this table . Note: There may be many workspaces. Regards, Mathew Linnane GIS/LIS Assets Officer. Queanbeyan City Council. 257 Crawford Street Queanbeyan NSW 2620. Bus: (02) 6298 0205 Fax: (02) 6297 4044 Mob: 0412 565 552 Email: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] + This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily the views of Queanbeyan City Council, unless otherwise stated. For the purposes of the Copyright Act, the permission of the holder of copyright in this communication may be taken to have been granted, unless stated otherwise, for the copying or forwarding of this message, as long as both the content of this communication and the purpose for which it is copied or forwarded are work related. + ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l -- Andy Harfoot GeoData Institute University of Southampton Southampton SO17 1BJ Tel: +44 (0)23 8059 2719 Fax: +44 (0)23 8059 2849 www.geodata.soton.ac.uk --- For further information about GeoData's Training Courses, please visit: www.geodata.soton.ac.uk/training --- ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
Re: [MI-L] Extracting Table information.
On 10/9/06, Mathew Linnane [EMAIL PROTECTED] wrote: Is it possible to determine the use of a table within a workspace? Problem: I have a mapinfo table and I want to know what workspace/s contain/s this table. Note: There may be many workspaces. Regards, Windows 2000 and prior let you search for files *.wor containing an arbitrary text string. But that doesn't work in XP without the registery hack already posted to this thread. An alternative is a handy freeware tool called Agent Ransack http://www.mythicsoft.com/agentransack/ Once you know which workspaces reference the table, you can open them all directly from Agent Ransack into a text editor such as Ultra Edit, or (my preference) TextPad and do a global search, replace, save. Rich -- Richard Greenwood [EMAIL PROTECTED] www.greenwoodmap.com ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Extracting Table information.
A couple of solutions come to mind, but one requires you have a particular application installed. 1) The easiest, most workable method comes with a big IF... IF you happen to be an Ultra Edit text editor user, you can search within files specifing only to search inside of *.WOR files and to search for just the table you're looking for. Set the output to an editable window and you will have a real working list you could copy, paste. The useful results can allow a mulitude of possibilites. 2) You could use the Windows search mechanism, or at least you once could. By searching for all instances of *.tab within the files of a specific directory. I don't think you could just search within specific files. 3) I seem to recall, there may be some function you could right into the Mapbasic Window within Mapinfo, one that would list all the workspaces where your table is found. HTH David Reid From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mathew Linnane Sent: Monday, October 09, 2006 1:18 AM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] Extracting Table information. Is it possible to determine the use of a table within a workspace? Problem: I have a mapinfo table and I want to know what workspace/s contain/s this table. Note: There may be many workspaces. Regards, Mathew Linnane GIS/LIS Assets Officer. Queanbeyan City Council. 257 Crawford Street Queanbeyan NSW 2620. Bus: (02) 6298 0205 Fax: (02) 6297 4044 Mob: 0412 565 552 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] + This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily the views of Queanbeyan City Council, unless otherwise stated. For the purposes of the Copyright Act, the permission of the holder of copyright in this communication may be taken to have been granted, unless stated otherwise, for the copying or forwarding of this message, as long as both the content of this communication and the purpose for which it is copied or forwarded are work related. + ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Extracting Table information.
I guess you could use Google Desktop to find these workspaces as well, if you trust Google ;-) Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Reid Sent: Monday, October 09, 2006 8:52 AM To: 'Mathew Linnane'; mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L] Extracting Table information. A couple of solutions come to mind, but one requires you have a particular application installed. 1) The easiest, most workable method comes with a big IF... IF you happen to be an Ultra Edit text editor user, you can search within files specifing only to search inside of *.WOR files and to search for just the table you're looking for. Set the output to an editable window and you will have a real working list you could copy, paste. The useful results can allow a mulitude of possibilites. 2) You could use the Windows search mechanism, or at least you once could. By searching for all instances of *.tab within the files of a specific directory. I don't think you could just search within specific files. 3) I seem to recall, there may be some function you could right into the Mapbasic Window within Mapinfo, one that would list all the workspaces where your table is found. HTH David Reid From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mathew Linnane Sent: Monday, October 09, 2006 1:18 AM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] Extracting Table information. Is it possible to determine the use of a table within a workspace? Problem: I have a mapinfo table and I want to know what workspace/s contain/s this table. Note: There may be many workspaces. Regards, Mathew Linnane GIS/LIS Assets Officer. Queanbeyan City Council. 257 Crawford Street Queanbeyan NSW 2620. Bus: (02) 6298 0205 Fax: (02) 6297 4044 Mob: 0412 565 552 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] + This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily the views of Queanbeyan City Council, unless otherwise stated. For the purposes of the Copyright Act, the permission of the holder of copyright in this communication may be taken to have been granted, unless stated otherwise, for the copying or forwarding of this message, as long as both the content of this communication and the purpose for which it is copied or forwarded are work related. + ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Extracting Table information.
Title: Extracting Table information. Workspaces are text documents so in windows you can search for files with .wor in the filename containing the name of your tab file (right click on a folder in my documents and search). Problem is if it ends in .wor it will not be searched as a text file so temporarily rename your workspace files with .txt at the end with a handy program A.F.5 rename your files. I guess there is a simpler way out there though. Joe From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mathew Linnane Sent: 09 October 2006 07:18 To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] Extracting Table information. Is it possible to determine the use of a table within a workspace? Problem: I have a mapinfo table and I want to know what workspace/s contain/s this table. Note: There may be many workspaces. Regards, Mathew Linnane GIS/LIS AssetsOfficer. Queanbeyan City Council. 257 Crawford Street Queanbeyan NSW 2620. Bus: (02) 6298 0205 Fax: (02) 6297 4044 Mob: 0412 565 552 Email: [EMAIL PROTECTED] + This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily the views of Queanbeyan City Council, unless otherwise stated. For the purposes of the Copyright Act, the permission of the holder of copyright in this communication may be taken to have been granted, unless stated otherwise, for the copying or forwarding of this message, as long as both the content of this communication and the purpose for which it is copied or forwarded are work related. + ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l