Problem importing ArcGIS XML geodatabase schema from EA to ArcGIS

[iggdi]

First of all hello everyone!

I have a problem with importing xml file created in EA (v13) to ArcGIS using ArcCatalog. I created a database schema in EA, validate an ArcGIS workspace (no errors) and exported it using ArcGIS extension (checked ArcGIS in xml type window) to ArcGIS Workspace xml. When I try to import that xml file into ArcGIS I just got a general warning 'Import xml data failed' - invalid xml file, nothing specific. Tried both with personal and file geodatabase. The structure of exported xml file seems fine.

Im pretty new with EA, so any suggestions are welcome.

Thanks!

[qwerty]

I'm not sure how many users here are familiar with ArcGIS (I'm not). If you don't hear back anything here the next days you should contact Sparx support via mail.

q.

[Nabil]

Did you try with Export Package to XMI file with ArcGIS format from publish option?

there is webinar on ArcGIS http://www.sparxsystems.com/resources/webinar/arcgis/geodatabase-large-scale-design/large-scale-arcgis-design-models-with-uml-and-enterprise-architect.htm from Sparx give a try

[iggdi]

I did try that too, Nabil, it's still the same.

Thanks for the webinar, but it's no use for my problem as I already have modelled geodatabase in EA.

[amousa79]

I have the same issue. exporting the uml to ArcGIS XML is successful and there is no validation errors.
but when I try to import the xml into the geodatabase it fails

did you get any solution for that.

[[email protected]]

This is a tough one.  It used to happen all the time to me, and it's a tough spot to be in because there is no help in that error message. 

Here is a python script I use frequently along with the sparx geodatabase validation.


'''
Created on Jun 22, 2016
use this when you have an issue importing from Sparx EA
first pass validation
next, see if you can do this. 
You might have to use it a lot it you are learning sparx.
things to look for:
domain values have the correct field type for the values
SmallInteger domains have code values less than about 30000

dont be tempted to go changing all the xml around in one session without frequently using this script

@author: kyleg
'''

if __name__ == '__main__':
    pass

def ValidatetoFileGDB():
    from arcpy import ImportXMLWorkspaceDocument_management, Exists, CreateFileGDB_management, Delete_management
    xmlIn = r"C:\temp\ValidateThis.xml"
    gdbname = "Validate5"
    GDB_In = r"C:/temp/"+gdbname
    gdbin = GDB_In+".gdb"
    if Exists(gdbin):
        Delete_management(gdbin, "Workspace")
        CreateFileGDB_management(r"C:/temp", gdbname, "CURRENT")
        print("new geodatabase created")
    else:
        CreateFileGDB_management(r"C:/temp", gdbname, "CURRENT")
    ImportXMLWorkspaceDocument_management(gdbin, xmlIn, import_type="SCHEMA_ONLY")
ValidatetoFileGDB()
print("validated")



Thats the end of the script.  When facing this situation, you can either retrace your steps back to when you had it working, or you can start a new sparx project and step-copy from the broken project into the new project.


One other tip I can offer is to attempt importing to file geodatabases.  I've run into issues where I can NOT successfully import a model to a SQL Server/enterprise geodatabase, but can import to file geodatabase, then copy the file geodatabase to enterprise gdb.