RE: [MI-L] Auditing edits made to mapinfo tables.

[Rex Ballard]

Title: Auditing edits made to mapinfo tables.

Great idea, if MapInfo Corp are willing to consider the change.  Can I suggest that the previous value (the value being overwritten) is also recorded - that would be almost as good as a full 4-dimensional database and would allow recreation of tables at any point in the database's history as well as providing the audit trail.  It should also allow "rate of change" analysis without the need for discrete time slices which will always be a compromise between flexibility and storage space.  Imagine being able to show the spread of disease with respect to the timing of some other factor such as weather, food imports, water quality or other datasets.   With regard to a server based approach, I have (in a previous position) used MapInfo Spatialware with SQL Server and tried saving all transactions.  With five full-time GIS operators and another four officers maintaining their section's data as part of their duties, it didn't take too long before the transaction file began to have a serious effect on system storage and backup performance.   Regards Rex Ballard -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Lars I. Nielsen (GisPro) Sent: Tuesday, 4 July 2006 8:49 PM To: mapinfo-l@lists.directionsmag.com Subject: Re: [MI-L] Auditing edits made to mapinfo tables. I beg to differ. MapInfo Pro knows exactly what records and fields and graphical objects have been edited at any time. The only thing MapInfo Pro's not good at, is making this information available to everyone else. The illusive "transaction files" (TDA, TIN and TMA) contains the information of what edits have been made. Only problem: they're locked when they exist, and deleted when closed. Otherwise I think it would be perfectly feasiable to utilize these to generate an audit trail of some kind. I'll make a simple feature suggestion for MI Pro 9.0 : have Pro add some log of all edits to a <table name>.log whenever edits are committed. The log file should be in a known, dense, maybe binary, format that could be utilized programmatically. Maybe just rowid+field+timestamp. And add an option to turn this feature on. That said, I too think a more server based approach would be a smarter option for a number of reasons, although I'm sure Oracle isn't the only egg in that basket. Best regards / Med venlig hilsen Lars I. Nielsen GisPro Peter Horsbøll Møller wrote: Mathew,   MapInfo isn't that good at these kind of things, not when working in the native tab format. You would need to write your own tools for doing all the operations - that would be quite a job.   I would recommend using a Spatial Database in stead. You can then make the database system keep track of all the changes, even tore them in a separate table, so that you have access to the previous version of every record.   MapInfo 8.0 introduced support for Oracle Workspaces. This is actual exactly what you are looking for. You can setup a table to keep track of every change, and this can be done from within MapInfo. The changes at stored in a separate table that with a small amount of work can be opened and viewed in the map as well.   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   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Mathew Linnane Sent: Tuesday, July 04, 2006 1:10 AM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] Auditing edits made to mapinfo tables. I need to create an audit trail of all edits made to a certain mapinfo table. The Audit trail must include user ID, Date, Time etc. Can mapinfo facilitate any form of auditing? All ideas would help. 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]   +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ "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 This email may contain advice and comment on a matter which is currently being considered by Council or may be considered by Council in the near future. Any advice or comments are the views of the Officer sending this email and should not be construed as a formal Council position. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. This footnote also confirms that this email message has been swept by McAfee for the presence of computer viruses.

_______________________________________________
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l