MI-L Importing XL into MI V7.0

2003-11-17 Thread Richard Hill
Hello everyone, Is there any limit on the size of an XL spreadsheet that can be opened in MI V7.0? I tried opening about 33000 lines of assay and geology data and only the first 32500 or so came up in the browser window, the rest come up very slowly as zeros as I scroll down. Would it be better

MI-L unsubscribe

2003-11-17 Thread David Bell
** This email and any attachments have been checked for viruses. It is confidential and intended solely for the use of the addressee. If you have received this in error please notify the sender

Re: MI-L Importing XL into MI V7.0

2003-11-17 Thread Uffe Kousgaard
MI up to v7 can open 32000 rows. MI v7.5 can open up to 65000 rows. CSV is good choice for importing your data. - Original Message - From: Richard Hill [EMAIL PROTECTED] To: 'Mapinfo-List' [EMAIL PROTECTED] Sent: Monday, November 17, 2003 7:23 AM Subject: MI-L Importing XL into MI V7.0

RE: MI-L Importing XL into MI V7.0

2003-11-17 Thread Peter Horsbøll Møller
MapInfo 7.0 or older can only import the first 32K records from an Excel file. MapInfo 7.5 can import all 64K (!!) records Peter Horsbøll Møller GIS Developer Geographical Information IT COWI A/S Rugårdsvej 55 DK-5000 Odense Denmark Tel +45 6313 5013 Direct +45 6313 5008 Mob +45

MI-L Export to *.TXT

2003-11-17 Thread Eagle, David A
Hello Mappers, On this dull and dreary Monday I would like to output some data to a TXT file or similar (CSV, DBF)... I have written some MB code to report info on a point of interest. When clicked on, attribute info is passed into variables and then displayed on a custom dialog. I want the

RE: MI-L Export to *.TXT

2003-11-17 Thread Peter Horsbøll Møller
I would recommend that you just use the Print #nFile, statement to print directly to a file. Start by opening the file using Open File .. for Output .. Now you can create string to print using you varables And filanlly the Close File #... Closes the file. Peter Horsbøll Møller GIS Developer

MI-L MapBasic and MS Access in the Mystery of the Crashing Application

2003-11-17 Thread Bill Thoen
I'm trying to debug a rather large MapBasic application that mysteriously crashes sometimes (and takes MapInfo down with it.) Evidence from numerous autopsies indicates that it dies in different places, but sometimes it makes it through the region of suspect code without a problem. It also works

RE: MI-L MapBasic and MS Access in the Mystery of the Crashing Ap plication

2003-11-17 Thread Peter Horsbøll Møller
Hi Bill, One thing that has annoyed me when creating MB application opening Access tables thru DAO is that MapInfo sometimes recreates the index on these tables. I have not been able to figure out when or why. In the beginning I thought it only occured when opening the tables, but this teory

Re: MI-L Labeling

2003-11-17 Thread Jorge Cordero
Hi Michael, In the layer control choose: Label Label With Expresion and the text box write: TYPE = MJA TYPE replace to name of column with attribute data Jorge Cordero - Original Message - From: Michael Smith [EMAIL PROTECTED] To: MapInfo-L [EMAIL PROTECTED] Sent: Monday,

RE: MI-L Labeling

2003-11-17 Thread Peter Horsbøll Møller
Try this neat little label expression Left$(CLASSIFICATION, (Int(CLASSIFICATION = mja) * Len(CLASSIFICATION))) This could also be used to label the roads with the road name if the classification is mja: Left$(ROADNAME, (Int(CLASSIFICATION = mja) * Len(ROADNAME))) The trick is that Int() returns

RE: MI-L Labeling

2003-11-17 Thread Michael Smith
Thanks Peter it worked. You guys on this list are awesome!! I even have the expression set up where I can label all of the roadway classifications if need be: Left$(ROADNAME, (Int(CLASSIFICATION = any (mja,”mjc”,”mnc”,”mna”)) * Len(ROADNAME))) -Original Message- From: Peter Horsbøll

RE: MI-L Labeling

2003-11-17 Thread Lemah GIS
Dear Michael, This Hifazat from riyadh. Dear I have some questions related to mapinfo. I have one parcel layer with mor ethan 1000 parcels . I need to maek a layer of parcel number with sequece of number on parcel number layer from 1 to 1000. How can this be done using MapBasic. Please reply

MI-L A question

2003-11-17 Thread lixiaohui
hello, I sent a question to you yesterday, but I receive several irrelative emails just like virus this morning . Could you tell me where can I post my question about Professional7.0 and where can I see the answer. My question like this: I intalled both professional6.5 and

MI-L A question

2003-11-17 Thread lixiaohui
Thank you very much for your reply at length.And thanks for your kindness and patience.I get it clear now. I am sorry I didn't express myself clearly .Could you do me a favor again? I write a program using visual basic and run professional through OLE.Under VB,I create professional object

RE: MI-L A question

2003-11-17 Thread Simmonds, Ashley (PTB)
this will most likely be determined by what version of the MI OLE automation library is referenced in your project. i can't say for certain as i only have a single version of mapinfo installed on my machine, but i think having two versions and attempting to register them both in your project may

MI-L MI 7 and multi monitors

2003-11-17 Thread Matt Bolton
Hi all, This is not a big issue, just a little annoyance that probably has an easy fix. I have both MI 6.5 and MI 7 installed on a PC which has multi monitors. When applications are opened they normally do so in the primary (right) monitor, and MI 6.5 also does this. However, MI 7 ALWAYS

MI-L MB Compiler

2003-11-17 Thread Upinder Mutti
Hello List This will no doubt sound like a stupid question to many, but please bear with my lack of knowledge and naiveity if you dare. As I am trying to get into learning Mapbasic, I'm wondering if there are any options for shareware/trialware compilers or any other alternative for where I can

Re: MI-L MB Compiler

2003-11-17 Thread B. Thoen
On Tue, 18 Nov 2003, Upinder Mutti wrote: This will no doubt sound like a stupid question to many, but please bear with my lack of knowledge and naiveity if you dare. As I am trying to get into learning Mapbasic, I'm wondering if there are any options for shareware/trialware compilers or any