I've had luck outputting the Mapinfo table from Oracle including the MI_STYLE that picks up the symbology. The issue I'm having is the tables are coming out as a native table rather than linked. I'm using FME 2012 Desktop and I've not found anywhere in the Oracle reader or the MITAB writer where the metadata tags can be exposed.
We parse the U:P to our tables so we can refresh them in Mapinfo when required rather than outputing a new table.
Below is the tab contents that I'm expecting to see. What I'm currently getting is the attributes sans the metadata at the bottom of the file.
What have I missed???
Thanks
Michael
!table
!version 550
!charset WindowsLatin1
Definition Table
Type LINKED Charset "WindowsLatin1"
Fields 56
DOP_UID Decimal (10, 0) ;
DPR_UID Decimal (10, 0) ;
DRILLING_OPPORTUNITY_NAME Char (30) ;
CASED_AND_SUSP_EST_COST_JV1 Decimal (13, 3) ;
CASED_AND_SUSP_EST_COST_JV2 Decimal (13, 3) ;
DRY_HOLE_COST_EST_JV1 Decimal (13, 3) ;
DRY_HOLE_COST_EST_JV2 Decimal (13, 3) ;
GL_ELEV_OR_WATER_DEPTH Decimal (9, 0) ;
KB_OR_RT_HEIGHT Decimal (9, 0) ;
LATITUDE Char (20) ;
LONGITUDE Char (20) ;
PROPOSED_DRILLING_YEAR Date ;
PROPOSED_FOR_DRILLING_FLAG Char (1) ;
SEISMIC_LINE_NAME Char (20) ;
SEISMIC_POINT_NUMBER Decimal (10, 2) ;
SSU_UID Decimal (10, 0) ;
TOTAL_SUBSEA_DEPTH Decimal (7, 0) ;
COU_BUDGET_COUNTRY_CODE Char (2) ;
CYD_BUDGET_YEAR Date ;
EDP_PERSON_ID_INSERT Char (8) ;
DATE_INSERT Date ;
EDP_PERSON_ID_UPDATE Char (8) ;
DATE_UPDATE Date ;
PDD_OPP_DESIGNATION_TYPE Char (40) ;
PDD_OPP_DESIGNATION_CODE Char (40) ;
PDD_OPP_STATUS_TYPE Char (40) ;
PDD_OPP_STATUS_CODE Char (40) ;
PDD_SEIS_POINT_TYPE_TYPE Char (40) ;
PDD_SEIS_POINT_TYPE_CODE Char (40) ;
GEOLOGICAL_SUMMARY Char (254) ReadOnly ;
READY_TO_DRILL_YEAR Date ;
CASED_AND_SUSP_EST_COST_JV3 Decimal (13, 3) ;
CASED_AND_SUSP_EST_COST_JV4 Decimal (13, 3) ;
CASED_AND_SUSP_EST_COST_JV5 Decimal (13, 3) ;
DRY_HOLE_COST_EST_JV3 Decimal (13, 3) ;
DRY_HOLE_COST_EST_JV4 Decimal (13, 3) ;
DRY_HOLE_COST_EST_JV5 Decimal (13, 3) ;
PDD_DRILL_TYPE_TYPE Char (40) ;
PDD_DRILL_TYPE_CODE Char (40) ;
PLOT_SYMBOL Char (12) ;
COORD_SYSTEM_ID Char (12) ;
PARENT_DOP_UID Decimal (10, 0) ;
PDD_PROJECT_SCOPE_CODE Char (40) ;
PDD_PROJECT_SCOPE_TYPE Char (40) ;
FACILITIES Char (254) ReadOnly ;
CONTINGENCIES Char (254) ReadOnly ;
PREVIOUS_EVENT_DOP_UID Decimal (10, 0) ;
BH_LATITUDE Decimal (11, 7) ;
BH_LONGITUDE Decimal (12, 7) ;
READY_TO_DRILL_FLAG Char (1) ;
PORTFOLIO_PROJECT_FLAG Char (1) ;
PROSPECT_NAME Char (30) ;
GPR_GEOLOGICAL_PROVINCE_CODE Char (10) ;
PDD_CURRENT_STATUS_CODE Char (40) ;
CS_USED Char (12) ;
OBJECT_TYPE Char (10) ;
begin_metadata
"\\IsReadOnly" = "FALSE"
"\\MapInfo" = ""
"\\MapInfo\\TableID" = "30d202e6-9475-4815-97c2-f175bb03cfd8"
"\\DATALINK" = ""
"\\DATALINK\\MapReadOnly" = "TRUE"
"\\DATALINK\\DataReadOnly" = "TRUE"
"\\DATALINK\\ConnectionString" = "SRVR=GISPROD;UID=miread;PWD=<hidden>"
"\\DATALINK\\ToolKit" = "ORAINET"
"\\DATALINK\\Autokey" = "OFF"
"\\DATALINK\\Query" = "select ""DOP_UID"", ""DPR_UID"", ""DRILLING_OPPORTUNITY_NAME"", ""CASED_AND_SUSP_EST_COST_JV1"", ""CASED_AND_SUSP_EST_COST_JV2"", ""DRY_HOLE_COST_EST_JV1"", ""DRY_HOLE_COST_EST_JV2"", ""GL_ELEV_OR_WATER_DEPTH"", ""KB_OR_RT_HEIGHT"", ""LA"
"\\DATALINK\\Query\\+1" = "TITUDE"", ""LONGITUDE"", ""PROPOSED_DRILLING_YEAR"", ""PROPOSED_FOR_DRILLING_FLAG"", ""SEISMIC_LINE_NAME"", ""SEISMIC_POINT_NUMBER"", ""SSU_UID"", ""TOTAL_SUBSEA_DEPTH"", ""COU_BUDGET_COUNTRY_CODE"", ""CYD_BUDGET_YEAR"", ""EDP_PERSON_ID_"
"\\DATALINK\\Query\\+2" = "INSERT"", ""DATE_INSERT"", ""EDP_PERSON_ID_UPDATE"", ""DATE_UPDATE"", ""PDD_OPP_DESIGNATION_TYPE"", ""PDD_OPP_DESIGNATION_CODE"", ""PDD_OPP_STATUS_TYPE"", ""PDD_OPP_STATUS_CODE"", ""PDD_SEIS_POINT_TYPE_TYPE"", ""PDD_SEIS_POINT_TYPE_CODE"""
"\\DATALINK\\Query\\+3" = ", ""GEOLOGICAL_SUMMARY"", ""READY_TO_DRILL_YEAR"", ""CASED_AND_SUSP_EST_COST_JV3"", ""CASED_AND_SUSP_EST_COST_JV4"", ""CASED_AND_SUSP_EST_COST_JV5"", ""DRY_HOLE_COST_EST_JV3"", ""DRY_HOLE_COST_EST_JV4"", ""DRY_HOLE_COST_EST_JV5"", ""PDD_"
"\\DATALINK\\Query\\+4" = "DRILL_TYPE_TYPE"", ""PDD_DRILL_TYPE_CODE"", ""PLOT_SYMBOL"", ""COORD_SYSTEM_ID"", ""PARENT_DOP_UID"", ""PDD_PROJECT_SCOPE_CODE"", ""PDD_PROJECT_SCOPE_TYPE"", ""FACILITIES"", ""CONTINGENCIES"", ""PREVIOUS_EVENT_DOP_UID"", ""BH_LATITUDE"","
"\\DATALINK\\Query\\+5" = " ""BH_LONGITUDE"", ""READY_TO_DRILL_FLAG"", ""PORTFOLIO_PROJECT_FLAG"", ""PROSPECT_NAME"", ""GPR_GEOLOGICAL_PROVINCE_CODE"", ""PDD_CURRENT_STATUS_CODE"", ""CS_USED"", ""OBJECT_TYPE"", ""MI_STYLE"", ""OBJECT"" from ""EDIGISDB"".""MIV_DRIL"
"\\DATALINK\\Query\\+6" = "LING_OPPORTUNITIES"""
"\\OracleWorkspace" = ""
"\\OracleWorkspace\\Versioned" = "OFF"
"\\OracleWorkspace\\Name" = ""
"\\OracleWorkspace\\ParentName" = ""
end_metadata