Import Parts List

This example demonstrates how to connect to the Sherlock gRPC service, import a project, and import parts lists.

Description

Sherlock’s gRPC API allows users to automate workflows such as importing ODB++ archives and parts lists. This script demonstrates how to: - Connect to the Sherlock service. - Import a project. - Import parts lists with different settings.

These functionalities enable users to prepare projects with ECAD data and associated parts lists for further analysis.

import os

from examples.examples_globals import get_sherlock_tutorial_path

from ansys.sherlock.core import launcher
from ansys.sherlock.core.errors import (
    SherlockImportPartsListError,
    SherlockImportProjectZipArchiveError,
)

Connect to Sherlock

Connect to the Sherlock service and ensure proper initialization.

sherlock = launcher.connect(port=9092, timeout=10)

Traceback (most recent call last):
  File "C:\Users\ansys\actions-runner\_work\pysherlock\pysherlock\examples\02-importing\import_parts_list.py", line 65, in <module>
    sherlock = launcher.connect(port=9092, timeout=10)
  File "C:\Users\ansys\actions-runner\_work\pysherlock\pysherlock\.venv\Lib\site-packages\ansys\sherlock\core\launcher.py", line 324, in connect
    raise e
  File "C:\Users\ansys\actions-runner\_work\pysherlock\pysherlock\.venv\Lib\site-packages\ansys\sherlock\core\launcher.py", line 298, in connect
    channel = _connect_grpc_channel(
        host=LOCALHOST,
    ...<4 lines>...
        certs_dir=certs_dir,
    )
  File "C:\Users\ansys\actions-runner\_work\pysherlock\pysherlock\.venv\Lib\site-packages\ansys\sherlock\core\launcher.py", line 369, in _connect_grpc_channel
    channel = create_channel(
        transport_mode=transport_mode,
    ...<9 lines>...
        ],
    )
  File "C:\Users\ansys\actions-runner\_work\pysherlock\pysherlock\.venv\Lib\site-packages\ansys\sherlock\core\utils\cyberchannel.py", line 149, in create_channel
    return create_mtls_channel(host, port, certs_dir, cert_files, grpc_options)
  File "C:\Users\ansys\actions-runner\_work\pysherlock\pysherlock\.venv\Lib\site-packages\ansys\sherlock\core\utils\cyberchannel.py", line 364, in create_mtls_channel
    raise FileNotFoundError(error_message) from e
FileNotFoundError: Certificate file not found: certs\ca.crt. Ensure that the certificates are present in the 'certs' folder or set the 'ANSYS_GRPC_CERTIFICATES' environment variable.

Delete Project

Delete the project if it already exists.

try:
    sherlock.project.delete_project("Test")
    print("Project deleted successfully.")
except Exception:
    pass

Import Tutorial Project

Import the tutorial project zip archive from the Sherlock tutorial directory.

try:
    sherlock.project.import_project_zip_archive(
        project="Test",
        category="Demos",
        archive_file=os.path.join(get_sherlock_tutorial_path(), "Tutorial Project.zip"),
    )
    print("Tutorial project imported successfully.")
except SherlockImportProjectZipArchiveError as e:
    print(f"Error importing project zip archive: {e}")

Import Parts List

Import parts list for the “Test” project and “Card” CCA.

try:
    parts_list_path = os.path.join(os.getcwd(), "partslist.csv")

    sherlock.parts.import_parts_list(
        project="Test", cca_name="Main Board", import_file=parts_list_path, import_as_user_src=False
    )
    print("Parts list imported successfully.")
except SherlockImportPartsListError as e:
    print(f"Error importing parts list: {e}")