Back to overview
Integrations

How to Automate Contact Imports from Your ERP (Without a Big Integration Project)

You don't need middleware or consultants. A simple script and an API key can keep your contacts flowing from any system — automatically.

Every business has contacts scattered across systems: ERP, accounting software, membership databases, partner portals, industry directories. Getting those contacts into a shared directory usually means one of two things: manual CSV exports (tedious) or a custom integration project (expensive).

There's a third option that most people overlook: a simple script, an API key, and a scheduled task. Total cost: 2 hours of IT time. Total recurring cost: zero.

The Contact Ingress Pipeline

Contact Central provides a full REST API with API key authentication. Any system that can export data — even just to a CSV file — can feed contacts into Contact Central automatically.

The pattern is simple:

1. **Export:** Get contacts out of your source system (CSV export, database query, API call).

2. **Transform:** Map the source fields to Contact Central's contact schema.

3. **Send:** POST each contact to the Contact Central API with your API key.

4. **Schedule:** Run the script on a schedule (daily, hourly, on-demand).

That's it. No middleware. No integration platform. No consultant.

Example: PowerShell + Scheduled Task

Here's what a typical setup looks like for a Windows environment:

Step 1: Create an API Key

In Contact Central, go to Admin → Settings → API Keys → Create. You get a key like `cc_abc123...`. This key authenticates all API requests.

Step 2: Write the Script

A PowerShell script that reads a CSV export and sends contacts to the API:

  • Read the CSV file your ERP exports nightly.
  • For each row, map fields (FirstName, LastName, Email, Phone, Company).
  • Call `Invoke-RestMethod` to POST to `/api/contacts` with the API key header.
  • Log successes and failures.
  • The script is typically 30–50 lines. No special libraries needed.

    Step 3: Schedule It

    Use Windows Task Scheduler (or cron on Linux) to run the script on a schedule:

  • Nightly:For ERP exports that refresh daily.
  • Hourly:For systems that change frequently.
  • On-demand:Triggered by the source system after an export.
  • Step 4: Forget It

    Once scheduled, the pipeline runs unattended. New contacts from the ERP appear in Contact Central — and from there, in every team member's Outlook and phone via Exchange Sync.

    Real-World Scenarios

    ERP → Contact Central

    Export customer contacts from SAP, Abacus, or Bexio nightly. Push to Contact Central. Sales team sees current customer data in Outlook next morning.

    Membership Database → Contact Central

    Association exports member list monthly. Automated import updates Contact Central. Office sees current membership contacts.

    Partner Portal → Contact Central

    Partner system exports new leads weekly. Script sends them to Contact Central with a "Partner Lead" tag. Sales follows up.

    Event Registration → Contact Central

    After a trade show, export the registration list. One-time import with the CSV wizard, or automated via API if the event platform supports it.

    What About Duplicates?

    When automated imports run regularly, duplicates are a concern. Contact Central handles this:

  • Import-time detection:The system flags contacts that match existing records.
  • Background scanning:Continuous duplicate detection catches matches the import missed.
  • Phone normalization:Different phone formats are normalized to E.164, so "+41 44 123 45 67" and "044 123 45 67" are recognized as the same number.
  • Why This Beats Traditional Integration

    Contact Ingress PipelineTraditional Integration
    Setup time2 hours2–8 weeks
    CostCHF 0 (IT time only)CHF 5,000–20,000
    Middleware neededNoUsually
    Vendor dependencyNoneIntegration partner
    MaintenanceScript + scheduleOngoing contract
    FlexibilityChange anytimeChange request + budget

    Getting Started

    1. Sign up for a Contact Central trial (30 days free).

    2. Create an API key in Admin → Settings.

    3. Export contacts from your source system (CSV or API).

    4. Write a simple script to push contacts to the API.

    5. Schedule it. Done.

    The API documentation (Swagger) is built into Contact Central — browse endpoints, test calls, and see response formats directly in the system.

    Ready for Efficient Contact Management?

    Try Contact Central free for 30 days, no strings attached.

    Try for Free