Re: [MI-L] Connect to AS/400 via ODBC
On 5/3/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: I'm not really sure how this works. I'm trying to get Tech Support, but MapInfo Support - which I pay for) says that they do not support my issue. Here is what I submitted to them: I am trying to connect to a remote database on an AS/400. I'm using IBM Client Access ODBC driver version 9.00.10.00. I'm running Windows XP Pro. When I connect to the data source, I don't get any errors, but my tables do not display in the Open dialog. Please help! I have never tried to connect from MapInfo directly to an AS/400 with IBM Client Access. I use Microsoft Access & IBM Client Access to connect to an AS/400. In MS Access I save the data into a linked dbf file, and then I open the dbf in MapInfo. You can even set it up as a script, or batch file, to run every night. Not pretty, but it's proven to be quite reliable for many years now. Note: If I am doing this wrong, please let me know. You are doing it exactly right. Welcome to the list. 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] Off-Topic (just a little): Software Version Control
When I wrote & sold software commercially in the 1990s, I used PVCS. Not cheap, but nothing better at the time. Don't know about current stuff, though. Clifford J. Mugnier, C.P., C.M.S. National Director (2006-2008), Photogrammetric Applications Division American Society for Photogrammetry and Remote Sensing and Chief of Geodesy, CENTER FOR GEOINFORMATICS Department of Civil Engineering CEBA 3223A LOUISIANA STATE UNIVERSITY Baton Rouge, LA 70803 Voice and Facsimile: (225) 578-8536 [Academic] Voice and Facsimile: (225) 578-4474 [Research] Honorary Life Member of the Louisiana Society of Professional Surveyors == http://www.asprs.org/resources/GRIDS/ http://appl003.lsu.edu/eng/ceeweb.nsf/$Content/Mugnier == Ian, We have a preference for open source stuff that operates over the web as our team is geographically spread, preferably php/ My SQL or Postgress. Both of our choices use a web server as its repository, allowing us to work (although I am not so sure about Subversion). We are using subversion for version control, although I haven't really started using it as much as I should (I still like to have sub directories with previous versions and code - but I largely work alone). My programmers have been using it and are impressed. Its TortoiseSVN windows interface makes it all pretty simple. We can use the same product for all the programming platforms and documents. Its even accessible over the web if you install it on a web server. For bug reporting/ ticketing, have a look at zero to one. We're only getting up to speed on it now, but my old partner uses this extensively and while its simple, it does the job. We're also looking at a to do list manager, and while zero to one can be made to do it, it is not intrinsically a project management tool. I would be interested in your findings on options for combined bug control/ project management/ Timesheet? Tool. R --- Robert Crossley Agtrix P/L Australia Far Southern Queensland Office: 9 Short Street PO Box 63 New Brighton 2483 P: 61 2 6680 1309 F: 61 2 6680 5214 E: [EMAIL PROTECTED] W: www.agtrix.com Brisbane Office: 109 Milsom St Cooparoo 4151 Queensland P: 61 7 3843 3363 _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ian Tidy Sent: 03 May 2006 12:41 To: MapInfo-L Subject: [MI-L] Off-Topic (just a little): Software Version Control I have been looking at version control software for managing our MapBasic (and other) development code. And I have a few questions: - What are other people using? - Do you worry about version control? - How do you manage bug reports? - How many developers work on the same project? - We normally only have 2. - Any comments about version control (the good, the bad, and the ugly)? Cheers Ian Ian Tidy GIS Administrator Works Asset Department Napier City Council Hastings St, Private Bag 6010, Napier, New Zealand Phone +64-6-835-7579 Ext. 8115 Fax +64-6-835-7574 mailto:[EMAIL PROTECTED] http://www.napier.govt.nz ## Attention: This e-mail message and accompanying data may contain information that is confidential and subject to legal privilege. Any information provided is given in good faith. However unless specifically stated to the contrary, Napier City Council accepts no liability for the content of this e-mail or for the consequences of any action taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that any use, dissemination, distribution or copying of this message or data is prohibited. If you received this e-mail message in error, please notify us immediately and erase all copies of this message and attachments. Thank you. << File: ATT00324.txt >> - winmail.dat ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l winmail.dat Description: Binary data ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] Connect to AS/400 via ODBC
I'm not really sure how this works. I'm trying to get Tech Support, but MapInfo Support - which I pay for) says that they do not support my issue. Here is what I submitted to them: I am trying to connect to a remote database on an AS/400. I'm using IBM Client Access ODBC driver version 9.00.10.00. I'm running Windows XP Pro. When I connect to the data source, I don't get any errors, but my tables do not display in the Open dialog. Please help! Is anyone out there able to help me? Note: If I am doing this wrong, please let me know. I have never encountered a forum like this before. Usually forums are a website that you post messages to. Please pardon my ignorance. Domenick J. Mariano Database Marketing Director Trump Plaza Casino Resort Mississippi Avenue at the Boardwalk Atlantic City, NJ 08401 www.trumpplaza.com voice 609.441.7896 fax 609.441.7706 [EMAIL PROTECTED] The information transmitted via this e-mail 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 pursuing of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you are the recipient of this in error, please contact the sender and delete the material from any computer. ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
Re: [MI-L] File Types
Andrew, I think that the CRV extension is used by Cities Revealed (formerly GeoInformation) in the supply of their aerial imagery. The data is actually in SID format. Change the extension of a file to *.sid and MapInfo will recognise it. The CRV version is needed for their free viewing software. I suspect that the SDW files provide georeferencing information in the same way that JGW does for JPG images. Do you not have any documentation on the subject? If not have a look at: http://www.citiesrevealed.com/aware/aware_fr.htm Ian >>> "Andrew Tracey" <[EMAIL PROTECTED]> 03/05/2006 10:53:09 >>> Dear AllI have been provided with some Aerial photos in a crv format, is there any easy way of registering these i n mapinfo v8?With the data was a series of .sdw files which seem to contain the coordinate information, is there any way of converting these into a MapInfo format.Thanks in advanceAndrew TraceyInformation Support OfficerInformation TeamChief Executive OfficeSouth Tyneside CouncilWestoe RoadSouth ShieldsNE33 2RLTel: 0191 4247561E-Mail : [EMAIL PROTECTED]Please do not print this e-mail if you can help it - and help protect the environment.This email and any files transmitted with it are confidential and intended solely for the named recipient. If you have received this e-mail in error, please immediately notify the sender by e-mail and delete from your system, you are not permitted to disseminate, store, disclose or copy. E-mail transmission cannot be guaranteed to be secure or error-free as they could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses and therefore the Council accept no liability for any such errors or omissions. Views or opinions expressed in this email are solely those of the author and do not necessarily represent those of the Council.South Tyneside Council, Town Hall & Civic Offices, Westoe Road, South Shields, Tyne & Wear, NE33 2RL, Tel: 0191 427 1717, Website: www.southtyneside.info The Council's web site address is www.southtyneside.info ___MapInfo-L mailing listMapInfo-L@lists.directionsmag.comhttp://www.directionsmag.com/mailman/listinfo/mapinfo-l ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] SUM: MapBasic StdCall DLL usage
Yesterday I asked how to code a C function in a DLL that returns a "pointer to void" (void *) value for a MapBasic application. The answer is that any pointer is just a 32-bit integer and its value is the address of whatever structure it points to, so you use an Integer in MapBasic and pass it ByVal to subsequent routines in the DLL that need it. Thanks for the help! - Bill Thoen ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE: [MI-L] Summing up areas of several layers, exclusive of overlap
Nathan, I think you should go in a different direction. Way not combining all the records in your tables into one table. Then you can select all records and combine them into one single object (Unless the number of nodes gets to big ...) And finally you can do an areacalculation of this single object. You could also insert one layer at a time into the new table and for each new layer you want to insert, you first select everything from the new table, set this as target, then you select everything from the layer to insert and do an erase. Now every part of the objects in the new layer tha overlap any part of the objects in the layer to insert will be deleted. Finally you insert the records from the layer into the new layer. Again you finish by doing an area calcualtion, this time by Selecting "Sum(CartesianArea(OBJ, "sq m")" or Sum(Area(OBJ, "sq m"), depending on your coordsys HTH, 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 Nathan Carr Sent: Wednesday, May 03, 2006 12:51 PM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] Summing up areas of several layers, exclusive of overlap Hiya, I've got a nice task of adding up the areas of several layers excluding multiple counts of those polygons that overlap. In other words... I need to get the cumulative sum of all the areas of features in several layers, but not counting twice those layers that overlap. I imagine that I can do it with a combination of the SQL functions of CASE and SUM and AREA and the MapInfo/Spatialware commands of INTERSECTS and ENTIRELY WITHIN... But, I thought I'd see if anyone has any other ideas or anything I can base things on. One problem I can initially see is that how do you seperate into two areas the two parts of a polygon that lie inside and outside of another. And the CASE conditional must be repeated in a quite a complex way when dealing with about six layers. Thanks for any pointers, Nathan ---(\./)--- Nathan Carr GIS Developer LLPG/LSG Custodian & ALO Swale Borough Council Email : [EMAIL PROTECTED] Phone : 01795 417 337 Mobile : 07957 461 685 This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager at [EMAIL PROTECTED] This message has been scanned for viruses by BlackSpider MailControl - www.blackspider.com I.T. Services Swale Borough Council Visit http://www.swale.gov.uk ___ 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
[MI-L] QAS or Quick Address
Title: QAS or Quick Address Hi all, Does or has anyone every used QAS/Quick Address with MapInfo? We have QAS Pro and Pro Web including the API's and would like to use it within MapInfo does anyone have any starting points? Thanks Nick Boon Information Systems Gloucestershire Police County Police Headquarters No 1 Waterwells Waterwells Drive Quedgeley Gloucester GL2 2AN (01452 752016 (x.2016) * [EMAIL PROTECTED] ** This email, together with any files or attachments transmitted with it, is intended solely for the addressee. If you are not the intended recipient, please delete the email and notify the originator immediately. Please note that any unauthorised copying, disclosure or other processing of this information may be unlawful. Unless otherwise stated, any opinions expressed in this email are those of the originator and not necessarily of Gloucestershire Constabulary. Although the sender has taken steps to protect the material sent, there is no guarantee that the communication will be virus-free. Gloucestershire Constabulary reserves the right to monitor all email activity and content in accordance with current legislation. ** ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] Summing up areas of several layers, exclusive of overlap
Hiya, I've got a nice task of adding up the areas of several layers excluding multiple counts of those polygons that overlap. In other words... I need to get the cumulative sum of all the areas of features in several layers, but not counting twice those layers that overlap. I imagine that I can do it with a combination of the SQL functions of CASE and SUM and AREA and the MapInfo/Spatialware commands of INTERSECTS and ENTIRELY WITHIN... But, I thought I'd see if anyone has any other ideas or anything I can base things on. One problem I can initially see is that how do you seperate into two areas the two parts of a polygon that lie inside and outside of another. And the CASE conditional must be repeated in a quite a complex way when dealing with about six layers. Thanks for any pointers, Nathan ---(\./)--- Nathan Carr GIS Developer LLPG/LSG Custodian & ALO Swale Borough Council Email : [EMAIL PROTECTED] Phone : 01795 417 337 Mobile : 07957 461 685 This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager at [EMAIL PROTECTED] This message has been scanned for viruses by BlackSpider MailControl - www.blackspider.com I.T. Services Swale Borough Council Visit http://www.swale.gov.uk ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] File Types
Dear All I have been provided with some Aerial photos in a crv format, is there any easy way of registering these i n mapinfo v8? With the data was a series of .sdw files which seem to contain the coordinate information, is there any way of converting these into a MapInfo format. Thanks in advance Andrew Tracey Information Support Officer Information Team Chief Executive Office South Tyneside Council Westoe Road South Shields NE33 2RL Tel: 0191 4247561 E-Mail : [EMAIL PROTECTED] Please do not print this e-mail if you can help it - and help protect the environment. This email and any files transmitted with it are confidential and intended solely for the named recipient. If you have received this e-mail in error, please immediately notify the sender by e-mail and delete from your system, you are not permitted to disseminate, store, disclose or copy. E-mail transmission cannot be guaranteed to be secure or error-free as they could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses and therefore the Council accept no liability for any such errors or omissions. Views or opinions expressed in this email are solely those of the author and do not necessarily represent those of the Council.South Tyneside Council, Town Hall & Civic Offices, Westoe Road, South Shields, Tyne & Wear, NE33 2RL, Tel: 0191 427 1717, Website: www.southtyneside.info The Council's web site address is www.southtyneside.info ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
[MI-L] Snap texts to points
Hello, we have several hundreds of texts and lines. Texts are nearby of nodes of lines. We need to move automatically texts to end nodes of lines ( result would be definition point of text placed as snapped to the end of nearest line ). Is there some solution or tool for it? Thank you in advance Regards Tomas Renco ^^^ GAMO a.s. Tomáš Renčo Kyjevské nám. 6 974 04 Banská Bystrica Slovakia Tel: 00421 48 4372046 Web: www.gamo.sk E-mail: [EMAIL PROTECTED] ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l