Guys, The document below has detail on how to use easy loader with a command line
http://www.mapinfo.com/documentation/software/mapinfo_pro/english/8.0/Ea syLoader.pdf Kind Regards Jerry O'Sullivan Jerry O'Sullivan GIS Consultant ESBI Computing Ltd Stephen Court | 18-21 St. Stephen's Green | Dublin 2 Tel +353 1 7038060 | Fax +353 1 6618455 E-mail: [EMAIL PROTECTED] www.esbic.ie -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Crossley Sent: 01 December 2005 23:43 To: [email protected] Subject: RE: [MI-L] EasyLoader Ian, Let me know if there are any answers. I've been thinking of the same thing and I was going down the path of: Analyse your table to work out what fields and field types are needed. Create the table in SQL server with a sql command Execute the sp_sw_spatialize_column Open the table locally. Insert the data Save to server Execute the sp_sw_create_rtree Add an entry into MAPINFO_MAPCATALOG I may still go down this path as there is an inssue with easyloader wanting to make character fields chars instead of varchars And although it uploads integer fields into Oracle spatial as integer, when you open the table from MapInfo again, it wants to make the oracle integers floats in MapInfo. So you have to force the oracle data table to be a decimal 13,0 to retain its integer status Evidently these translations are controlled by the ODBC or Oracle Client so you can't alter them from MapInfo. The process above offers a bit more control. 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 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ian Tidy Sent: 02 December 2005 07:56 To: MapInfo-L Cc: [EMAIL PROTECTED] Subject: [MI-L] EasyLoader Hi, Is it possible to run EasyLoader from a command line? Or is there a command line version of EasyLoader? I have around 20 Tables that I want to load into SpatialWare for SQL server. Ideally I want to batch these and run them at night. Any ideas?? 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 <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. _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l * ** *** ** * ** *** ** * ** *** ** * 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. Any views or opinions presented are solely those of the author, and do not necessarily represent those of ESB. If you have received this email in error please notify the sender. Although ESB scans e-mail and attachments for viruses, it does not guarantee that either are virus-free and accepts no liability for any damage sustained as a result of viruses. * ** *** ** * ** *** ** * ** *** ** * _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
