Gnarly Core Mapper Error

[harry spark]

Hello John, 

My name is Harrison a post graduate student in China, I was making use of the Circuitscape Gnarly tool (the Core Mapper tool) and I have been running through some problems which I would greatly appreciate if you could help me out to rectify. when I upload the excel worksheet containing the HCA parameters, it encounters some errors give below 

Messages

Executing: CoreMapper2 E:\BaiduNetdiskDownload\Gnarly_Landscape_Utilities_0_1_9\Gnarly_Landscape_Utilities_0_1_9\CoreMapperDemo\CoreMapperDemoParameters.xlsx

Start Time: Sat Aug 17 16:34:48 2019

Running script CoreMapper2...

Core Mapper version 0.1.9

-----------------------------------------------------------------

If you use this software, please cite it so others can find it!

See www.circuitscape.org/gnarly-landscape-utilities 

for preferred citation

-----------------------------------------------------------------

***************************************

READING E:\BaiduNetdiskDownload\Gnarly_Landscape_Utilities_0_1_9\Gnarly_Landscape_Utilities_0_1_9\CoreMapperDemo\CoreMapperDemoParameters.xlsx

***************************************

PROCESSING Demo1 run.

Starting core processing for output: Demo1

Habitat model is C:\Gnarly\CoreMapperDemo\habitat

Resistance model is C:\Gnarly\CoreMapperDemo\resistance

Base folder is C:\Gnarly\output

Calculating average habitat value within a 500.0 Meter moving window radius

Converting moving window result to binary habitat model based on moving window average >= 0.8

and per-cell habitat values >= 0.8

Expanding cores by 2000.0 Meters in cost-weighted distance

Done expanding cores.

****Python error. Details follow.****

Python error on **line 230** of Core_Mapper.py

RuntimeError: ERROR 999998: Unexpected Error.

Completed script CoreMapper2...

Failed to execute (CoreMapper2).

Failed at Sat Aug 17 16:34:56 2019 (Elapsed Time: 8.07 seconds)

I also tried editing the parameter replacing the original parameters with my project parameters and I also encountered errors with the message shown below.  

Messages

Executing: CoreMapper2 E:\BaiduNetdiskDownload\Gnarly_Landscape_Utilities_0_1_9\Gnarly_Landscape_Utilities_0_1_9\Coremapper\CoreMapperDemoSample.xlsx

Start Time: Sat Aug 17 16:42:22 2019

Running script CoreMapper2...

Failed script CoreMapper2...

Traceback (most recent call last):

  File "E:\BaiduNetdiskDownload\Gnarly_Landscape_Utilities_0_1_9\Gnarly_Landscape_Utilities_0_1_9\Toolbox\scripts\CoreMapper.py", line 57, in <module>

    wb = load_workbook(filename=tables[0])

  File "E:\BaiduNetdiskDownload\Gnarly_Landscape_Utilities_0_1_9\Gnarly_Landscape_Utilities_0_1_9\Toolbox\scripts\openpyxl\reader\excel.py", line 149, in load_workbook

    _load_workbook(wb, archive, filename, read_only, keep_vba)

  File "E:\BaiduNetdiskDownload\Gnarly_Landscape_Utilities_0_1_9\Gnarly_Landscape_Utilities_0_1_9\Toolbox\scripts\openpyxl\reader\excel.py", line 236, in _load_workbook

    color_index=wb._colors)

  File "E:\BaiduNetdiskDownload\Gnarly_Landscape_Utilities_0_1_9\Gnarly_Landscape_Utilities_0_1_9\Toolbox\scripts\openpyxl\reader\worksheet.py", line 327, in read_worksheet

    fast_parse(ws, xml_source, shared_strings, style_table, color_index)

  File "E:\BaiduNetdiskDownload\Gnarly_Landscape_Utilities_0_1_9\Gnarly_Landscape_Utilities_0_1_9\Toolbox\scripts\openpyxl\reader\worksheet.py", line 315, in fast_parse

    parser.parse()

  File "E:\BaiduNetdiskDownload\Gnarly_Landscape_Utilities_0_1_9\Gnarly_Landscape_Utilities_0_1_9\Toolbox\scripts\openpyxl\reader\worksheet.py", line 94, in parse

    dispatcher[tag_name](element)

  File "E:\BaiduNetdiskDownload\Gnarly_Landscape_Utilities_0_1_9\Gnarly_Landscape_Utilities_0_1_9\Toolbox\scripts\openpyxl\reader\worksheet.py", line 291, in parse_data_validation

    dv = parser(tag)

  File "E:\BaiduNetdiskDownload\Gnarly_Landscape_Utilities_0_1_9\Gnarly_Landscape_Utilities_0_1_9\Toolbox\scripts\openpyxl\worksheet\datavalidation.py", line 225, in parser

    dv = DataValidation(**element.attrib)

TypeError: __init__() got an unexpected keyword argument '{http://schemas.microsoft.com/office/spreadsheetml/2014/revision}uid'

Failed to execute (CoreMapper2).

Failed at Sat Aug 17 16:42:23 2019 (Elapsed Time: 0.73 seconds)

I would greatly appreciate it of you could tell me where and what exactly could be causing the errors and also how to correct them. 

Thank you so much for your time and I look forward to hearing from you soon. 

[John Gallo]

Hello Harrison,

it is likely that you still need to edit your CoreMapperDemoParameters.xlsx file so that it points to the locations of your inputs.

Right now it is saying your habitat data layer is at 

C:\Gnarly\CoreMapperDemo\habitat

but it may really be at:

E:\BaiduNetdiskDownload\Gnarly_Landscape_Utilities_0_1_9\Gnarly_Landscape_Utilities_0_1_9\CoreMapperDemo\habitat

IF that is the case, you'll need to update the other two columns too.

Was that the trick?

Thanks,

John

[harry spark]

Hello John, 

Thanks for your reply I edited the file locations on the parameter spreadsheet but still got the same error. I even tried using my own data but the same error still popped up. So what i did was to uninstall my microsoft office 2016 and installed an earlier version (2013) after that I also encountered a different error message saying "an unexpected error occur". when I removed the demo resistance file location, I was able to run the program. Is it possible that the Demo Resistance file has a problem?

[harry spark]

[John Gallo]

Hello Harrison,

It is possibly but highly unlikely, since it has worked fine for me and everyone else that has tried it.  it is possible it has been recently corrupted somehow.  I'll keep an eye out to see if anyone lse has the error.  Also, I can now offer paid workshops and webinars that are the same price for 1-5 people, and a slightly higher price for 6-10 people. The students choose the duration of the class and the specific topic. If you are interested contact me off list.

Thanks,

John

[harry spark]

Hello John 

Thanks so much for your reply, I later figured out the problem wasnt the tool but rather my computer I observed the tool works best if you using a Windows 7 operating system. It was actuallly failing because the operating system of my laptop was windows 10 when i tried the tool with an earlier windows( windows 7 it worked perfectly fine). So I suggest other should take note of that. 

Thanks 

[John Gallo]

Update to all reading this thread, after some hiccups,  I just ran the Core Mapper Demo successfully on my C drive using Windows 11 and Arc GIS 10.8.1 and Office 19.

[John Gallo]

Gnarly Landscape Utilities Core Mapper is very fragile when using more recent versions of Microsoft Office.  Here is what looks to be a temporary workaround until we or the Circuitscape team fix the code:

https://github.com/linkagescape/linkage-mapper/issues/172

--
You received this message because you are subscribed to the Google Groups "Linkage Mapper" group.
To unsubscribe from this group and stop receiving emails from it, send an email to linkage-mappe...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/linkage-mapper/7d8ac001-236b-4dee-b181-ae42e3358b73n%40googlegroups.com.

--

John A. Gallo, Ph.D.

Project Director

LinkageMapper.org

and

Senior Conservation Scientist

Conservation Biology Institute