MapInfo Pro

Good morning, a pleasure to participate in this forum.

Recent institution updated licenses to mapinfo 16.0, I would like to know how to create a text table to object and store it in a database engine SQL server 2016.

Thank you very much

Thanks for joining, Alexander. Welcome!!

Can you please elaborate on what do you mean by Text Table? Is it text file with spatial coordinates information for which you would like to create an object. A sample or a snapshot of text table would help to understand better, if you could share.

Storing in a database engine such as SQL Server, Oracle, Postgres is an easy step in MapInfo Pro through use of MapInfo EasyLoader Tool. The help section of MapInfo Pro provides details on connection steps.

Meanwhile I will create a few step-wise snapshot for you to navigate through the process a bit easier with the assumption that object layer is created in MapInfo Pro.

Hope this helps!

-Thanks

Thank you very much Dr Neena, I appreciate the answer, attached video about what you want to do.

Or if possible, how to store the labels in the database, since we have many workspace with labels and we need to move it to SQL 2016.

I send a sample in pdf of a Primary Unit of sampling that we have stored in a database in SQL 2008 through the spatialware and with mapinfo 12.5.

Best regards

Link to video download

https://takeafile.com/?f=givabihoci

Steps to upload an object layer in SQL Server Database

• On the HOME tab, in the Tools group, click Tool Extensions to open the Tool Manager which contains list of Mapbasic tools to perform various operations such as duplicate removal, coordinate information extraction, data upload etc.

• Select MapInfo EasyLoader Tool from the Tool Manager which will help to upload MapInfo® TAB files to SQL Server/other databases.

• Run the MapInfo EasyLoader tool to display the MapInfo EasyLoader window

• Create a new connection by selecting New Connection from the Database Connection list by clicking Database connection icon. Select ODBC (Other Database Connection) and Click on icon next to DSN Name:

• Click New and follow wizard panels to set-up SQL server connection (Attached GIF for this section of information)
• Once connection is set-up, verify by clicking Connect.

• Go to Source Table which Lists the data tables to upload to the database. Select Add Tables to upload tab file(s) present in map window (Earthquake_Magnitude.tab is uploaded here)

• Select for each table what you would like to do in the database. I have selected create a New Table in illustration below.
  • Create a New Table ­ creates a new table in the database using the source table name.
  • Replace Existing Table ­ replaces an existing table in the database that has the same name as the source table.
  • Append to Existing Table ­ appends the contents of the source table to an existing table in the database that has the same name as the source table.

• By default, upload tables are added to the map catalog on the database unless you clear the check box in the Catalog column. 
• Start the upload process by clicking play button.

• Once upload is completed (shown as check mark under upload status or upload progress bar), message on upload success/failure, time taken for upload and error or warnings information is displayed at the bottom panel of MapInfo EasyLoader window

• To verify availability of uploaded table, On the HOME tab, in the Content group, click Database Table to open the database connection in which table has been uploaded

• Select the existing DSN name and click OK
• Database connection opens up and shows the uploaded table

GIF file attachment mentioned in above discussion thread as "Attached GIF for this section of information"

Hi Alexander

The steps outlined for Text/Label upload is similar to those outlined for Object Layer as illustrated in discussion thread above.

I did look at your shared video and to answer your query regarding "storing labels in the database where many workspaces are available with the labels ", I would suggest to select all label layers in one go by selecting files and bulk upload through MapInfo EasyLoader.

If you question is different then what I have replied, please clarify. I would be happy to assist in resolving your query.

-Thanks

Hi Alexander

Unfortunately, MS SQL Server doesn't support text features in a spatial table. That's why you can't save a MapInfo table with text features to a SQL Server table.

The process to move these tables to SQL Server would be to:

• Create a new text column in your table to hold the text from the text feature
• Update the new column with the text from the text feature
• Convert the text features from text to either a point or a line, depending on the requirements: should it appear rotated use lines. If not, you can stick with points
• Save the changes to the table
• Upload the table to SQL Server, for example using EasyLoader

Thanks a lot Peter for clarifying!!

Good morning, Thank you very much peter as well as neena, for your valuable answers to my doubts. excellent medium for clarifications and consultations.

We are in contact, have a good day

regards