Gdi import from oracle spatial ommits compound polygons geometry (gtype=1003,elem_info=1005)

Could this be because you have more than one sdo_gtype defined in the table ?

I don´t think so - I prepared a test table, where there were geometries of just one sdo_gtype = 2003 and with the spatial index with parameter 'layer_gtype=polygon' defined and it did not solve the problem. Still the compound polygons continues to be skipped :(

Sorry, the Framework I am using while attempting to compile, is ".Net Framework 4"

Jiri

...not familiar with that particular error, but at this time I would recommend the use of Visual Studio 2005 Edition when developing applications for the Bentley Map V8i (SELECTseries 1) platform. Also when adding/replacing references to accomodate your local installation, be sure and set the "Copy Local" property to "False".

The provided VBA user interface is intended for testing purposes. Your VBA application can connect to Oracle Spatial and perform queries w/o ever showing a user interface if you desire.

Thank you, the problem was exactly where you pointed - I had to change "copy local" to false. Now I succeded building your dll. Nevertheless when I open the Microstation Macro and want to add the reference to "Bentley.Geospatial.Extensions.Oracle.dll" it fails with "Microstation Visual Basic: can't add a reference to the specified file". Do you think this can be caused by compiling in VS C# Express 2010?

Jiri

...select the Bentley.Geospatial.Extensions.Oracle.tlb type library when setting your reference.

Great, it was really a Visual Studio version issue, compiling with VS 2005 succeded without any error. I managed to set the reference into VBA Microstation's macro and I wrote a simple test sub:

Sub Test()

   Dim oOracleInstance As New OracleSpatialExtensions

   oOracleInstance.connectAdhoc "publ", "publ", "publ"

   'oOracleInstance.queryClass "PUBL_JINO_HRANICE_KP_OBVODOVE", "KP_KOD=101"

   oOracleInstance.queryClass "PUBL_JINO_HRANICE_KP_OBVODOVE", "KP_KOD=101"

End Sub

I am connected without any problem, but querrying a table do nothing, I was inspecting the code in c# and "query all" should be by default.

Therefore the only problem could be in feature class. I do have in oracle table called "jino_hranice_kp_obvodove" in schema "publ" which has a collumn called "kp_kod", what then have I wrong in the function call?

Thank you very much for your help,

Jiri

Great, it was really a Visual Studio version issue, compiling with VS 2005 succeded without any error. I managed to set the reference into VBA Microstation's macro and I wrote a simple test sub:

Sub Test()

   Dim oOracleInstance As New OracleSpatialExtensions

   oOracleInstance.connectAdhoc "publ", "publ", "publ"

   'oOracleInstance.queryClass "PUBL_JINO_HRANICE_KP_OBVODOVE", "KP_KOD=101"

   oOracleInstance.queryClass "PUBL_JINO_HRANICE_KP_OBVODOVE", "KP_KOD=101"

End Sub

I am connected without any problem, but querrying a table do nothing, I was inspecting the code in c# and "query all" should be by default.

Therefore the only problem could be in feature class. I do have in oracle table called "jino_hranice_kp_obvodove" in schema "publ" which has a collumn called "kp_kod", what then have I wrong in the function call?

Thank you very much for your help,

Jiri

When I tried to work in a schema previously defined in BGA everything worked. So i have to have something badly in the class name while using ad hoc connection... I have no idea what :(

I can do it that way (prepare a XFM scheme for tables to be imported in advance), but the problem is that I am executing microstation from VB Script (command line) via COM interface (I am exporting data to approx 110 design files) and I don't know how to tell it the newly created instance should use user asociated to XFM scheme...

I am using something like:

Set myMSAppCon = CreateObject("MicroStationDGN.ApplicationObjectConnector")

Set myMSApp = myMSAppCon.Application

myMSApp.Visible = True

Set DesignFile = myMSApp.OpenDesignFile(vectorizedFileV8, False)

Is there any way how to achieve it?

Thank you very much,

Jiri

...you could try to set the _USTN_USERNAME environment variable to the name of the user workspace (e.g. SET _USTN_USERNAME=geo_example_designer) in the shell before starting your session.

Jiri,

For you adhoc connection (e.g. without a schema) code, you will need to add the following highlighted lines to the connectAdhoc method:

                public void connectAdhoc(string userName, string password, string serviceName)
                {
                    GDI.GDIExplorerOracleImportsNode oracleNode = GDI.GDIExplorerAddIn.Instance.OracleNode;
                    if (oracleNode != null && oracleNode.CountSubNodes() == 0)
                    {
                        ECSTORAGE.IECStorage storage = GDI.GeoDataInterchangeAddIn.Instance.OpenOracleStorage(userName, userName, password, serviceName, false);
                        if (storage != null)
                        {
                            GDI.GDIExplorerOracleNode node = new GDI.GDIExplorerOracleNode("Current Session");
                            node.AddStorage(userName + "@" + serviceName, storage, false, null);
                            oracleNode.AddSubNode(node);
                            if (GDI.GeoDataInterchangeAddIn.Instance.MasterFileImport == null)
                                GDI.GeoDataInterchangeAddIn.Instance.MasterFileImport = node;

                        }
                    }
                }