ERP Bridge
  • Welcome to ERP Bridge
  • Software & Hardware requirements
  • Environment Configuration
  • Data Preparation
  • Overview
  • Registration and first login
  • The Installation
    • 0 - Go to Installation wizard
    • 1 - Name
    • 2 - Hubspot Login
    • 3 - Sync Frequency
    • 4 - Download Wizard
    • ERP Bridge Wizard - On-Premise
      • 0 - Install the wizard on-premise (.msi)
      • 1 - Welcome screen
      • 2 - Login
      • 3 - Select Installation
      • 4 - Database
      • 5 - Database Tables
      • 6 - Download the agent
      • 7 - Start Agent
    • Back to the cloud
  • The Operation
    • 0 - Choose direction
    • 1 - Default settings
    • 2 - [HS -> DB] Filters
    • 2 - Database Mapping
    • 3 - Decision Rules
      • Example with 1 decision rule
      • Example with 2 decision rules
    • 4 - [DB -> HS] Associations
  • Start to Synchronize
  • Uninstall
  • Advanced topics
    • Change ERP Bridge Agent path
  • Troubleshoot
    • On-Premise wizard errors
  • HubSpot to Database sync
    • Handling empty fields
  • Security Documentation for ERP Bridge
    • 1. Product Access Control
    • 2. Rate Limit
    • 3. Authentication Resources
    • 4. Encryption
    • 5. Change Management
    • 6. Cloud Security
    • 7. Security certification
    • 8. Availability
    • 9. Logging
    • 10. Installer Desktop
    • 11. Server Agent
Powered by GitBook
On this page
  • Database Tables
  • Date & DateTime
  • Single Checkbox
  • Multiple Checkboxes & Selects

Data Preparation

Properties of the following types: checkbox, multiple checkboxes, dropdown select, radio select and HubSpot user, the data should match one of the internal values of the property.

Last updated 13 days ago

When you are in the phase of preparation of data to be inserted in HubSpot, please consider the data-format that is accepted by HubSpot itself ().

Database Tables

Database tables must not contain spaces or special characters other than the underscore character ("_").

Here some example of good and bad table names:

✅ CONTACTS ✅ ERP_CONTACTS ❌ ERP CONTACTS ❌ ERP&CONTACTS

Date & DateTime

In HubSpot there are 2 types to handle the time:

  • Date: it contains just the date (day, month and year) and the time is fixed at midnight. (Ex: 2020-02-10)

  • DateTime: it contains both the date and the time part. (Ex: 2020-02-10 06:10:00)

In order to successfully transfer date and datetime data from the database, ERP Bridge try to convert the value you have in the database to UNIX Timestamp at UTC timezone. Even if the software will infer most of date formats, we suggest always to use the most common and international date format (ISO 8601): dd-mm-yyyy.

If you have a date already in UNIX Timestamp format, the software will bypass the conversion and it will just push the value to HubSpot.

Be careful about the last point: HubSpot requires the UNIX Timestamp in milliseconds format, if you will send it in seconds, it will not accept the value.

Single Checkbox

This type of property has only 2 possible values. The only possible internal values of the property are "true" and "false" interdependently from the labels.

Multiple Checkboxes & Selects

These types of properties are very customizable and the user can decide multiple entries with custom labels and internal values.

The important thing here is that your database value must match the internal value of every single option, NOT the label! If you will try to push an option non-present in the HubSpot property options, the request will be rejected by HubSpot and it will be logged in logs file.

official documentation