Update Part Locations by File

This example demonstrates how to connect to the Sherlock gRPC service, import a project, and update part locations using a CSV file.

Description

Sherlock’s gRPC API allows users to automate workflows such as updating part locations for printed circuit boards (PCBs) using a CSV file. This script demonstrates how to: - Connect to the Sherlock service. - Import a project. - Update part locations using a CSV file.

The updated part locations can ensure consistency across various PCB designs.

import os

from examples.examples_globals import get_sherlock_tutorial_path

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

Connect to Sherlock

Connect to the Sherlock service and ensure proper initialization.

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

Traceback (most recent call last):
  File "C:\Users\ansys\actions-runner\_work\pysherlock\pysherlock\examples\01-project-configuration\update_part_location_by_file.py", line 64, in <module>
    sherlock = launcher.connect(port=9092, timeout=10, transport_mode="wnua")
  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 306, in connect
    _wait_for_sherlock_grpc_ready(channel, timeout)
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^
  File "C:\Users\ansys\actions-runner\_work\pysherlock\pysherlock\.venv\Lib\site-packages\ansys\sherlock\core\launcher.py", line 395, in _wait_for_sherlock_grpc_ready
    raise SherlockConnectionError(message="Error starting gRPC service")
ansys.sherlock.core.errors.SherlockConnectionError: gRPC connection error: Error starting gRPC service

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("Error importing project zip archive.")

Update Part Locations by File

Update the part locations for the “Card” of the “Test” project using a CSV file.

csv_file_path = os.path.join(os.getcwd(), "partslist.csv")

try:
    sherlock.parts.update_parts_locations_by_file(
        project="Test",
        cca_name="Main Board",
        file_path=csv_file_path,
        numeric_format="JAPANESE",
    )
    print("Part locations updated successfully using the CSV file.")
except SherlockUpdatePartsLocationsByFileError as e:
    print("Error updating part locations by file.")