List of Contributions

Dhanushka Sandanuwan

Contact Details

My Content

1 to 15 of 15 total

How to get R,G,B value for embedded colours

Posted By Dhanushka Sandanuwan 10-29-2025 01:14
Found In Egroup: MapInfo Pro \ view thread
Dear All, I have a MapInfo file where the colours are embedded as follows. I want to know the R,G,B colour code for each attribute in order to configure a web application. How can I do that? ------------------------------ Thanks & Regards Dhan VIC, Australia ------------------------------

How to convert Mapinfo annotation tab file to a tab file which contains points the annotation text as an attribute in the table?

Posted By Dhanushka Sandanuwan 06-05-2025 00:27
Found In Egroup: MapInfo Pro \ view thread
Dear All, We need to convert TAB files that contain annotations similar to the following into new TAB files with points and the annotation as an attribute (text) in the table. What is the easiest way to do that? ------------------------------ Thanks & Regards Dhan VIC, Australia ------------- ...

RE: Registering SQL Server Spatial DB View with MAPCATALOG

Posted By Dhanushka Sandanuwan 04-22-2025 21:45
Found In Egroup: MapInfo Pro \ view thread
Thank you, Peter & James, I was assuming the tables and views are displayed in alphabetical order in the "Database Table" dialogue box, but it is not. Considering we have more than 1000 tables and views, it is nice to have a search or filtering option to select the tables or views based on their ...

RE: Registering SQL Server Spatial DB View with MAPCATALOG

Posted By Dhanushka Sandanuwan 04-21-2025 20:09
Found In Egroup: MapInfo Pro \ view thread
Hi James, Thank you for the information and the detailed explanation. I have added the new database view (AM_PIPES_DL_VW) to the MAPINFO_MAPCATALOG, but I can't see it when I open the "Database Table" dialogue box in MapInfo Pro (2023 build 142). What could be the reason for this? MAPINFO_MAPCATALOG ...

Registering SQL Server Spatial DB View with MAPCATALOG

Posted By Dhanushka Sandanuwan 04-16-2025 02:07
Found In Egroup: MapInfo Pro \ view thread
I have a database view that contains SP_GEOMETRY and the following fields When I open the "Make DBMS Table Mappable" dialogue box under Table > Database, I cannot see this DB view. I understand that the table or view should be registered under MAPINFO.MAPCATALOG in order to view the table/view ...

RE: MapInfo Monday: Creating the MapInfo MapCatalog in a spatial database

Posted By Dhanushka Sandanuwan 04-09-2025 02:02
Found In Egroup: MapInfo Pro \ view thread
This is an excellent article, Thanks for that! I found few tables in our SQL Server spatial database which are not registered under MAPINFO_MAPCATALOG. Hence, I'm unable to add them to MapInfo. Is there a way I can register existing spatial tables with the MAPINFO_MAPCATALOG using Mapinfo Pro? --- ...

RE: How to re-link broken linked tables

Posted By Dhanushka Sandanuwan 04-08-2025 21:34
Found In Egroup: MapInfo Pro \ view thread
Hey Pete, Thank you for your response. You are correct! When I compare both TAB files, I notice that the one with the broken link lacks everything after the "begin_metadata." (including) I can find the relevant tables & DB views in the database. Is there a way to re-link the TAB files to relevant ...

How to re-link broken linked tables

Posted By Dhanushka Sandanuwan 04-04-2025 00:48
Found In Egroup: MapInfo Pro \ view thread
Dear All, I have many tables located in different folders that were previously linked to a DBMS, and the link later became broken. Therefore, I cannot refresh the TAB files using "Table > Database > Refresh DBMS Table" In the following example, AMT_xxxxxx.TAB file is linked. AM_xxxxxxx.TAB file is ...

RE: Change feature styling

Posted By Dhanushka Sandanuwan 04-04-2025 00:21
Found In Egroup: MapInfo Pro \ view thread
Hi Peter, Thank you for sharing the above information. I was able to resolve my issue. ------------------------------ Dhan VIC, Australia ------------------------------

Change feature styling

Posted By Dhanushka Sandanuwan 04-02-2025 19:48
Found In Egroup: MapInfo Pro \ view thread
Dear All, I have copied a polygon from another TAB file, but it retained the same styling as the old TAB file from which I copied it. I wonder where the styling information is stored in the TAB files and how to override it for individual or all features in a TAB file. Thanks & regards, ...

RE: Update column expression to make the first letter of every word capital (Title Case)

Posted By Dhanushka Sandanuwan 03-25-2025 02:18
Found In Egroup: MapInfo Pro \ view thread
Hi James, Thank you for your support. I was able to update the data using Proper$. Is there a document you tumbled upon to find more details about expressions and functions currently available on MapInfo Pro? Cheers! Dhan ------------------------------ Dhan VIC, Australia ------------------- ...

Update column expression to make the first letter of every word capital (Title Case)

Posted By Dhanushka Sandanuwan 03-25-2025 01:15
Found In Egroup: MapInfo Pro \ view thread
Dear All, I'm trying to update a data set that is currently in capital to title case (Table > SQL > Update Column). I could only find the following function to make all data lowercase. Please support me in building an expression to make the first letter of every word capitalised (Title Case) ...

RE: Erro loading polygon in MapInfo Pro

Posted By Dhanushka Sandanuwan 01-21-2025 23:48
Found In Egroup: MapInfo Pro \ view thread
Thank you, James! That really helped :) ------------------------------ Dhan VIC, Australia ------------------------------

Erro loading polygon in MapInfo Pro

Posted By Dhanushka Sandanuwan 01-21-2025 19:34
Found In Egroup: MapInfo Pro \ view thread
I was getting the following error message. Then I added "MI_STYLE" column in the SQL Server using the following script ALTER TABLE ADD MI_STYLE varchar(254) NULL; Now, I'm able to add the polygon layer to MapInfo. However, when I zoom in or pan, I get the following error message Please ...

Reprojecting existing Mapinfo objects in the database (SQL Server)

Posted By Dhanushka Sandanuwan 01-06-2025 00:08
Found In Egroup: MapInfo Pro \ view thread
Dear All, I want to convert existing tables and views in the MapInfo (SQL Server) database from GDA94 to GDA2020. What would be the best approach? I was thinking of the following method but its time consuming: Download all tables from the database Save them one by one with the new projection ...