How to read single csv file by multiple automation processes parallel

Help Activities
4

Reading a CSV file simultaneously by multiple automation processes can pose certain challenges. Here is what I found:

  1. Read same excel at the same time by multiple robots:

    • Concerns about whether multiple robots can access the same configuration files stored in Excel simultaneously. It’s a common discussion among the community.[1]

  2. Parallel http request from datatable:

    • Insights into launching multiple background processes at the same time and considerations when your dispatcher reads the CSV file.[2]

  3. Unable to read same excel file twice in the same process:

    • Discusses problems faced when trying to read the same CSV file multiple times within the same automation process and potential solutions.[3]

  4. Parallel Activity in CSV file:

    • Discusses running parallel activities on a CSV file with 5 Users for scenarios where simultaneous processing is needed.[4]

To ensure seamless operation:

  • Concurrency Control: Handle file locks well, making sure to prevent collisions or corruptions.
  • Reading Mode: Set proper reading modes as ‘Read-only’ if applicable.
  • Logging and monitoring: Implement robust logs and monitoring in case of access conflicts.

Please refer to these discussions for more in-depth community-driven insights:

Depending on your specific process requirements and environment, further fine-tuning and testing might be necessary.

If you need more detailed guidance tailored specifically to your use case, please provide additional details about your setup and process requirements.

  1. Read same excel at the same time by multiple robots ↩︎

  2. Parallel http request from datatable ↩︎

  3. Unable to read same excel file twice in the same process ↩︎

  4. Parallel Activity in CSV file ↩︎