EXCEL ISSUE

[Peter Hatton]

Hi all

    Has anyone had trouble with Excel files in Mapinfo V10.0. I am running Office 2003 and am having trouble with an Excel file that contains 36462 records in total. When I open the excel file in Mapinfo v10.0 I get the following and only 16384 excel records in Mapinfo. This appears as though it could be a v10.0 bug as Mapinfo should support the version (up to 2007) of Excel you run and in my case a little over 65000 records.

 

 

 

 

When I amend the "named range" to "other" and change my "H" value to 36462 Mapinfo imports 36462 records but data is only included for the first 16384 and the surplus rows contain no data.

 

 

Has anyone else experienced similiar with 10.0 or can someone advise what I am doing wrong .......... It's Monday morning but my weekend wasn't that big ...............

 

Many thanks ..............

 

 

Peter HATTON

Senior GIS Officer

Greater Taree City Council

PO Box 482 TAREE NSW 2430

 

email; peter....@gtcc.nsw.gov.au

phone: 02 6592 5227

 

This e-mail has been scanned for viruses by MCI's Internet Managed
Scanning Services - powered by MessageLabs. For further information
visit http://www.mci.com

[Gentreau]

Is line 16385 in your file a blank line by any chance?

If not, is there anything different about that line?

Are there any special characters in line 16384 which might be fooling the import filter ?

---

From: mapi...@googlegroups.com [mailto:mapi...@googlegroups.com] On Behalf Of Peter Hatton
Sent: Monday, July 20, 2009 2:31 AM
To: mapi...@googlegroups.com; alg...@yahoogroups.com
Subject: [MI-L] EXCEL ISSUE

[Mats Elfström]

Hi Peter!

I agree with Gentreau but you should also consider the number and length of columns in your spreadsheet. I may be that summed up, they hit another limit in MI Pro long before the number of records become a problem.

Perhaps you should consider storing your data in a database instead of in a spreadsheet?
I think you are likely to stumble over more problems than this, having so many rows in your spreadsheet program.

Regards, Mats.E

2009/7/20 Gentreau <goo...@gentreau.com>

[Bill Thoen]

Peter Hatton wrote:
> Has anyone had trouble with Excel files in Mapinfo V10.0. I am
> running Office 2003 and am having trouble with an Excel file that
> contains 36462 records in total. When I open the excel file in Mapinfo
> v10.0 I get the following and only 16384 excel records in Mapinfo.
> This appears as though it could be a v10.0 bug as Mapinfo should
> support the version (up to 2007) of Excel you run and in my case a
> little over 65000 records.
>

When you see a number that's an even power of two in association with an
error running an operation that references every record in a file, you
should think "limitation" and WAD (Works As Designed). With 16384 being
exactly 2^14 my guess is that MapInfo can only import that many Excel
records. I'd call it a bug too, because even though MI may be designed
with this limit, it's not supporting the expanded capabilities of the
Office 2003 version of Excel and therefor it doesn't meet the requirements.

But with that many records maybe you should consider using a DBMS anyway.

- Bill Thoen

[Gentreau]

Fortunately, not everyone has the decimal value of all the powers of 2 in
their heads....

Thankfully someone does, good point Bill.

-----Original Message-----
From: mapi...@googlegroups.com [mailto:mapi...@googlegroups.com] On

[Hankins, Michael D.]

If v10 can't even import 17,000 records from excel, they can kiss my
upgrade money goodbye. That would be a deal breaker for me

Mike

-----Original Message-----
From: mapi...@googlegroups.com [mailto:mapi...@googlegroups.com] On
Behalf Of Bill Thoen
Sent: Monday, July 20, 2009 8:30 AM
To: mapi...@googlegroups.com
Subject: [MI-L] Re: EXCEL ISSUE

[Gentreau]

I'm sure that's not the limitation though.
I just successfully opened an Excel 2003 sheet with over 30k rows in MI 8.5

[Bill Thoen]

Gentreau wrote:
> Fortunately, not everyone has the decimal value of all the powers of 2 in
> their heads....
>

I can do other tricks too...

But I guess that's a hold-over from when I worked in FORTRAN augmented
with Assembler, when knowing things like that was actually useful. Over
time one collects a lot of toys that end up in one's attic.

[CDR Group]

Not only can he do decimals of powers of 2 - but he also remembers FORTRAN!  Well done that man!

 

Tony Witham

CDR Group
www.cdrgroup.co.uk
www.puredotnet.co.uk
Tel: 01433 621282
Fax: 01433 621292
Specialists in Geographic Information Systems

CDR Group is the trading name of Contract Data Research Ltd.
Registered address Eccles House, Eccles Lane, Hope, Hope Valley, S33 6RW.
Registration No. 1972376
VAT No. GB373 3117 67

----- Original Message -----

From: Bill Thoen

To: mapi...@googlegroups.com

Sent: Monday, July 20, 2009 4:24 PM

Subject: [MI-L] Re: EXCEL ISSUE

[Hankins, Michael D.]

I have never had any issues with excel and MI Pro. I am using office
2003 and MI Pro 9.0.

My questions for those who already have 10.0:
1. IS THERE A PROBLEM IMPORTING LARGE EXCEL FILES INTO MAPINFO PRO 10.0?

2. The links to several servers using the WMS are broke in MI Pro 9.0,
Has anyone used some of the links in 10.0?

Mike Hankins

[Greg Driver]

On Jul 20, 6:48 pm, "Hankins, Michael D."

<michael.d.hank...@countryfinancial.com> wrote:
> I have never had any issues with excel and MI Pro.  I am using office
> 2003 and MI Pro 9.0.  
>
> My questions for those who already have 10.0:
> 1. IS THERE A PROBLEM IMPORTING LARGE EXCEL FILES INTO MAPINFO PRO 10.0?

I tried it earlier on and imported an Excel spreadsheet containing
65,000 rows (approx 15mb) using MI Pro v10 and it worked fine. I also
tried it using MI Pro v8.5.1 and it worked as well. We use Excel 2002
Sp3, if that makes a difference?

> 2. The links to several servers using the WMS are broke in MI Pro 9.0,
> Has anyone used some of the links in 10.0?  

Sorry, can't help on that one.

Greg.

[Hankins, Michael D.]

Greg,

Thank you for the info about the Excel. I thought it would be odd for Excel not to work since it has worked fine for years. Maybe my PBMI rep will contact me with information about the WMS links.

Mike

-----Original Message-----
From: mapi...@googlegroups.com [mailto:mapi...@googlegroups.com] On Behalf Of Greg Driver
Sent: Monday, July 20, 2009 2:21 PM
To: MapInfo-L
Subject: [MI-L] Re: EXCEL ISSUE