Model Checker function Issues

Speckle Help
,
1

Hi, we are trying out the public function ‘Model Checker’ and having an issue with getting the function to run. The error log we are getting is this:

[prepare] 2025/04/02 15:18:10 Entrypoint initialization[c8f5484979-e4e81da91f-2e8a43] Reporting run status with content: {'projectId': '4b82917e9c', 'functionRunId': 'ead79f9bd092a6d', 'status': 'RUNNING', 'statusMessage': None, 'results': None, 'contextView': None}[c8f5484979-e4e81da91f-2e8a43] It took 0.76 seconds to receive  the speckle version 3992d2b69e[c8f5484979-e4e81da91f-2e8a43] e[92mDetected Speckle object schema version: 3e[0m[c8f5484979-e4e81da91f-2e8a43] Traceback (most recent call last):[c8f5484979-e4e81da91f-2e8a43]   File "/usr/local/lib/python3.11/site-packages/pandas/core/indexes/base.py", line 3805, in get_loc[c8f5484979-e4e81da91f-2e8a43]     return self._engine.get_loc(casted_key)[c8f5484979-e4e81da91f-2e8a43]            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^[c8f5484979-e4e81da91f-2e8a43]   File "index.pyx", line 167, in pandas._libs.index.IndexEngine.get_loc[c8f5484979-e4e81da91f-2e8a43]   File "index.pyx", line 196, in pandas._libs.index.IndexEngine.get_loc[c8f5484979-e4e81da91f-2e8a43]   File "pandas/_libs/hashtable_class_helper.pxi", line 7081, in pandas._libs.hashtable.PyObjectHashTable.get_item[c8f5484979-e4e81da91f-2e8a43]   File "pandas/_libs/hashtable_class_helper.pxi", line 7089, in pandas._libs.hashtable.PyObjectHashTable.get_item[c8f5484979-e4e81da91f-2e8a43] KeyError: 'Logic'[c8f5484979-e4e81da91f-2e8a43] [c8f5484979-e4e81da91f-2e8a43] The above exception was the direct cause of the following exception:[c8f5484979-e4e81da91f-2e8a43] [c8f5484979-e4e81da91f-2e8a43] Traceback (most recent call last):[c8f5484979-e4e81da91f-2e8a43]   File "/home/speckle/src/spreadsheet.py", line 161, in read_rules_from_spreadsheet[c8f5484979-e4e81da91f-2e8a43]     df = process_rule_numbers(df)[c8f5484979-e4e81da91f-2e8a43]          ^^^^^^^^^^^^^^^^^^^^^^^^[c8f5484979-e4e81da91f-2e8a43]   File "/home/speckle/src/spreadsheet.py", line 57, in process_rule_numbers[c8f5484979-e4e81da91f-2e8a43]     where_indices = df[df["Logic"].str.upper() == "WHERE"].index[c8f5484979-e4e81da91f-2e8a43]                        ~~^^^^^^^^^[c8f5484979-e4e81da91f-2e8a43]   File "/usr/local/lib/python3.11/site-packages/pandas/core/frame.py", line 4102, in __getitem__[c8f5484979-e4e81da91f-2e8a43]     indexer = self.columns.get_loc(key)[c8f5484979-e4e81da91f-2e8a43]               ^^^^^^^^^^^^^^^^^^^^^^^^^[c8f5484979-e4e81da91f-2e8a43]   File "/usr/local/lib/python3.11/site-packages/pandas/core/indexes/base.py", line 3812, in get_loc[c8f5484979-e4e81da91f-2e8a43]     raise KeyError(key) from err[c8f5484979-e4e81da91f-2e8a43] KeyError: 'Logic'[c8f5484979-e4e81da91f-2e8a43] e[92mFailed to read the TSV from the URL: 'Logic':'Logic'e[0m[c8f5484979-e4e81da91f-2e8a43] Automation run EXCEPTION after 1.35 seconds.[c8f5484979-e4e81da91f-2e8a43] Failed to process rules[c8f5484979-e4e81da91f-2e8a43] Reporting run status with content: {'projectId': '4b82917e9c', 'functionRunId': 'ead79f9bd092a6d', 'status': 'EXCEPTION', 'statusMessage': 'Failed to process rules', 'results': None, 'contextView': '/projects/4b82917e9c/models/e400efc912@3992d2b69e'}

My interpretation of this is that the function is struggling to read our tsv file that we have shared through a google drive link - is there a certain format this needs to be sent? We have just used the ‘copy link’ on google drive to produce a link.

2

It needs to be a published TSV that is web-shared. If you open that link, does it show up in the browser as a TSV raw text or does it take you to Google Drive.

Happy to test via DM if it helps

3

I´m having the same issue. If I put the URL for the TSV on the browser, it prompts for downloading it. What can I be doing wrong @jonathon ?

4

That in itself isnt necessarliy a problem - its just how your browser is setup to handle non html type content. The URL is a means to an end and should be pastable in the function configuration.