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 :(

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

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.

...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;

                        }
                    }
                }