Hello, Caliper was able to provide me with a solution. The excel file of my data contained many NULL values. Maptitude trunicates the table when trying to predict the datatype. So it didn't have enough information to properly predict the type.
Thanks for the help. Case closed. --- In [email protected], "swag_ner_pth" <swag_ner_pth@...> wrote: > > Hello, > > As I said in my first post, I had tried converting the format/datatype in > Excel without any luck. The fields that aren't being detected properly do not > contain characters. Only fields that contain integers are interpreted > correctly. > > I'm not sure what else to do in terms of trouble-shooting but from my end, > this appears to be a Maptitude issue and not an issue with the data. > > --- In [email protected], [email protected] wrote: > > > > Hi: > > Maptitude simply reads in the field types presented to it from Excel. If > > a field is passed as a character field, then either there are characters > > in some of the cells in that column, or the field is not formatted as > > type numeric in Excel. > > Maptitude Mapping Software <http://www.caliper.com> Group Moderator > > > > --- In [email protected], "swag_ner_pth" <swag_ner_pth@> > > wrote: > > > > > > Some of the fields have characters, some of them are integers, and > > some of them are floating numbers. Only the address field has numbers > > and characters mixed. > > > > > > > > > > > > --- In [email protected], "Maptitude" mtinfo@ wrote: > > > > > > > > Hi: > > > > > > > > Are there any string characters in any of the cells? > > > > > > > > Maptitude Moderator > > > > Phone: +1 617-527-4700 > > > > Fax: +1 617-527-5113 > > > > Caliper Corporation > > > > 1172 Beacon Street, Suite 300, Newton, MA, 02461-9926, USA > > > > Web site: http://www.MappingSoftware.com > > > > Maptitude | Yahoo! Group | Facebook | You Tube | Twitter | Google+ > > > > > > > > > > ------------------------------------ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Maptitude/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/Maptitude/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
