Community

Where is my problem coming from with CAMEO Tools.tbx Failure to Execute with .zip file from CAMEOfm

862
1
10-04-2019 01:08 PM
AdamIngram
by
New Contributor
‎10-04-2019 01:08 PM

When I try to import my CAMEO data into pro using the new CAMEO Tools.tbx

(C:\Users\Adam P. Ingram\Documents\ArcGIS\Packages\CAMEODataManagement_f42c66\p20\ImportCameo.py)

I run into the following data error (the .zip file i'm using was downloaded directly from CAMEOfm V3.5.1😞

<< Begin >>

Running script Import CAMEO Data...
Checking output workspace...
Creating GDB: C:\Users\Adam P. Ingram\Documents\ArcGIS\Packages\CAMEODataManagement_f42c66\CAMEO Data V3.gdb
--------------------------------------------------
Extracting zip...
zip extracted
--------------------------------------------------
Adding Table: ChemicalsInInventory
Table Added: C:\Users\Adam P. Ingram\Documents\ArcGIS\Packages\CAMEODataManagement_f42c66\CAMEO Data V3.gdb\ChemicalsInInventory
Adding new fields...
Importing data...
--------------------------------------------------
Adding Table: ChemInvLocations
Table Added: C:\Users\Adam P. Ingram\Documents\ArcGIS\Packages\CAMEODataManagement_f42c66\CAMEO Data V3.gdb\ChemInvLocations
Adding new fields...
Importing data...
--------------------------------------------------
Adding Table: ChemInvMixtures
Table Added: C:\Users\Adam P. Ingram\Documents\ArcGIS\Packages\CAMEODataManagement_f42c66\CAMEO Data V3.gdb\ChemInvMixtures
Adding new fields...
Importing data...
--------------------------------------------------
Adding Table: Contacts
Table Added: C:\Users\Adam P. Ingram\Documents\ArcGIS\Packages\CAMEODataManagement_f42c66\CAMEO Data V3.gdb\Contacts
Adding new fields...
Importing data...
--------------------------------------------------
Adding Table: ContactsLink
Table Added: C:\Users\Adam P. Ingram\Documents\ArcGIS\Packages\CAMEODataManagement_f42c66\CAMEO Data V3.gdb\ContactsLink
Adding new fields...
Importing data...
--------------------------------------------------
Adding Table: Facilities
Table Added: C:\Users\Adam P. Ingram\Documents\ArcGIS\Packages\CAMEODataManagement_f42c66\CAMEO Data V3.gdb\Facilities
Adding new fields...
Importing data...
Error occurred while loading the data
Failed script Import CAMEO Data...
Traceback (most recent call last):
File "C:\Users\Adam P. Ingram\Documents\ArcGIS\Packages\CAMEODataManagement_f42c66\p20\ImportCameo.py", line 624, in <module>
main()
File "C:\Users\Adam P. Ingram\Documents\ArcGIS\Packages\CAMEODataManagement_f42c66\p20\ImportCameo.py", line 595, in main
tables_to_gdb(extracted_file_location, out_gdb_path)
File "C:\Users\Adam P. Ingram\Documents\ArcGIS\Packages\CAMEODataManagement_f42c66\p20\ImportCameo.py", line 407, in tables_to_gdb
t = create_and_populate_table(new_file, out_gdb_path, is_spatial, latField, lonField)
File "C:\Users\Adam P. Ingram\Documents\ArcGIS\Packages\CAMEODataManagement_f42c66\p20\ImportCameo.py", line 462, in create_and_populate_table
add_data(table, new_table, lat_field, lon_field, fields, null_fields)
File "C:\Users\Adam P. Ingram\Documents\ArcGIS\Packages\CAMEODataManagement_f42c66\p20\ImportCameo.py", line 560, in add_data
cursor.insertRow(new_row)
RuntimeError: The coordinates or measures are out of bounds.
Failed to execute (ImportCameoData).

<< End >>

Any ideas on why this failure to execute is happening? Where in the data is it going wrong? I also emailed Derek Law‌ to see if he can connect me with the dev team to see if they have any ideas.

Thanks everyone!

Adam
Columbus, OH

0 Kudos
1 Reply
RyanCosby1
by Esri Contributor
Esri Contributor
‎10-07-2019 12:30 PM

We were able to handle this offline. In case anyone runs into this issue in the future, this problem can be caused by an invalid latitude or longitude value in either Facilities, Special Locations, Incidents, or Resources records in the CAMEOfm software.

To resolve the issue:

1. Extract the contents of the CAMEO ZIP file

2. Open the corresponding .mer file in Excel and identify records that have a bad Latitude (not in range -90 to 90) or Longitude (not in range -180 to 180) value.

3. For each of the records identified in step 2 search for the records in the CAMEOfm software and open the Map Data tab in the the Edit dialog menu to update the Latitude and Longitude value

4. Export the data from CAMEO.

5. Use the new export ZIP file as the input to the Import CAMEO Data tool.