How to connect ACTPro to Ronspot

---

Contents

1. Prerequisites
2. Configure the ACTpro Integration in Ronspot
3. Generate the CSV file from ACTpro

4. Upload the CSV File to the Ronspot S3 Bucket

1. Prerequisites

ACTPro on-premise is a local access control solution used to manage secure entry for employees and visitors. To track access control activity, Ronspot requires daily data imports from ACTPro. This integration is achieved through a daily CSV file transfer into a Ronspot-hosted S3 bucket.

Before starting, ensure you have:

• An active ACTPro account and subscription

• Access to the ACTPro on-premise software

• IT support if required for S3 bucket access

 

2. Configure the ACTpro Integration in Ronspot

Step 1: Log in to Ronspot admin panel

• Sign in to your Ronspot admin panel using your administrator credentials.

---

Step 2: Navigate to Account > Integrations

• In the left-hand menu, go to Account > Integrations 

---

Step 3: Add a new integration

• Click  Add integration button at the top of the screen.
• IIn the pop-up window, choose ACTPro from the list of available integrations.

---

Step 4: Configure the ACTPro integration

• On the configuration screen, enter the following details:

  • Name: Enter a name for the integration (e.g., ACTPro– Ronspot Integration)

  • Status:  Set to Active

• Press Save

---

Step 5: Generate access and secret keys

Ronspot uses a secure S3 bucket to receive the daily CSV file from ACTPro.

• In the list of integrations, locate the ACTPro integration you just created.

• Click the key icon in the Actions column. 

---

Step 6: Save your keys

• Click the pencil icon in the Actions column. 
• Copy the following details into a secure location:

• • Access Key

  • Secret Key (click the eye icon to reveal it)

  • Path Name

• Click Cancel to return to the previous page once you’ve saved the information.

---

Step 7: Associate your Ronspot zones

You can now link specific Ronspot zones to ACTPro. This determines which zones will use access control data from ACTPro.

• In the list of integrations, locate the ACTPro integration you just created.
• Click the camera icon in the Actions column to manage zone associations.

---

Step 8: Add an association

• Click the Add association button at the top of the page.
• Configure these fileds: 

  • Zone: Select the Ronspot zone you want to connect

  • Access Location(s):

    • Type each access location name exactly as it appears in ACTPro, then click Add to the list.

    • Repeat as needed to add multiple locations. All added access locations will appear in the panel on the right.

    • To remove a location, click it and select Remove selected values.

• Click Complete to save the association.

• Repeat this process to add more zone associations as needed.

 

3. Generate the CSV file from ACTpro

1.File Format

This section defines the CSV format used to export access control events for integration with Ronspot. Each row represents a single access event generated when a user credential is used at a door or turnstile.

• Encoding: UTF-8

• Delimiter: Comma (,)

• Header row: Required

• File extension: .csv

---

2. File Naming Convention

Each exported CSV file must follow a strict naming structure so that files can be processed automatically.

• Format: ACTExport_YYYYMMDD_HHMM.csv
• Example: ACTExport_20260305_0830.csv
  • This indicates a file generated on 5 March 2026 at 08:30 (24 hour format).

Component	Description
ACTExport	Fixed prefix. Every file must begin with this text exactly as written.
YYYY	Four-digit year the file was generated.
MM	Two-digit month (01–12).
DD	Two-digit day of the month (01–31).
HH	Two-digit hour in 24-hour format (00–23).
MM	Two-digit minute (00–59).
.csv	File extension.

Rules:

• File names must follow the exact structure shown above.

• The prefix must be ACTExport.

• The timestamp must reflect the actual time the file was generated.

• Only one file per timestamp is allowed.

• No additional characters or separators may be added.

Validation Rule:

• Before processing a file, the system should validate that the file name matches the following pattern:

  • ACTExport_[0-9]{8}_[0-9]{4}\.csv

• Files that do not match this pattern should be rejected and not processed.

---

3. Column Definitions

---

4. Door Name Consistency

• DoorName must represent a stable identifier for a physical door.

• The same door must always export the same DoorName value.

• Examples: Main Door, Turnstile 1.

---

5. Data Quality Rules

• Trim leading and trailing whitespace from all string fields.

• Reject records missing required fields (EventID, When, Event, DoorName, Email).

• Email is treated as the primary user identifier.

• First name and last name are optional and may be blank.

• EventID should be unique for each row.

---

6. Example CSV

 

4. Upload the CSV File to the Ronspot S3 Bucket

Using the Access Key, Secret Key, and Path Name from Step 6, upload the CSV file to the Ronspot S3 bucket.

If you need further help, please reach out at support@ronspotflexwork.com