Loymax SmartCom
English
English
  • What is Loymax SmartCom?
  • Main
    • Main feature
    • Main terms
    • How to start work
    • Communication types and channels
    • FAQ
  • Features
    • Segmentation
      • Segment builder
      • List of segments
      • RFM segments
      • Tags
    • Mass mailings
      • Mailing list
      • E-mail mailings
      • SMS mailings
      • Push mailings
      • Mailing settings
      • A/B testing in a mailing
      • Mailing report
      • Mailing calendar
    • Campaigns
      • Creating a campaign
      • Campaigns list
      • Triggers
        • Added a product to the container
        • Anniversary
        • Bonuses expected expiration
        • Customer registration
        • Date has come
        • Date come for client
        • Date come for order
        • Days since last visit to the site
        • Days since last order
        • Days since registration
        • Event occurred
        • Item from specific category purchased
        • Lost cart on the site
        • Lost view of product on the site
        • Customer visited section of website
        • Customer visited website
        • Customer viewed product on website
        • Customer viewed product category
        • Item purchased
        • Order is paid
        • Order is cancelled
        • Repeated date
        • Getting into RFM segment
        • Getting into segment
        • System event
        • Order was made/receipt was issued
      • Actions
        • Actualize filter
        • Select customers from segment
        • Run A/B test
        • Assign call
        • Accrue points
        • Accrue bonuses in the loyalty program
        • Limit number of participants
        • Limit poll
        • Send push
        • Send SMS
        • Send e-mail
        • Filter customers
        • Wait X minutes/hours/days
        • Wait until date
        • Check e-mail status
        • Report manager
        • Set tag
      • Campaign report
      • Abandoned cart
    • Control group
    • Campaign recipes
    • Polls
    • Customer profile
    • Personalization
      • Template engine
    • Analytics
      • Dashboard
    • Templates
    • Subscriptions management
    • Receipt attribution
    • Promo codes
    • Settings
      • General settings
      • Fields
      • Directories
      • Observers
      • Users
        • Access rights
      • Regions
      • Constants for templates
      • Mailing categories
      • Managing views
  • Usage
    • Quality of contact information
    • Metrics
    • Regions
    • Cascades
    • Events
    • Recommendations for quality mailings
      • Postmasters
      • DNS configuring
      • Warming up IP address
      • Avatar for mail
  • integration
    • Complete integrations
    • Data exchange
      • Introduction
      • Data structure
      • File exchange
      • SQL server data
      • REST API
      • Data exchange bus
    • JS tracker
Powered by GitBook
On this page
  • General information
  • File Naming
  1. integration
  2. Data exchange

File exchange

General information

The data is transferred to the Platform in CSV format.

The data is located on a remote server. The following protocols are supported:

  • FTP;

  • SFTP;

  • WebDAV;

  • AWS;

  • Dropbox.

Objects should be transmitted to the Platform when they are created and when they are changed.

Text encoding is UTF-8. Data can be unloaded several times per 24 hours. The frequency of unloading depends on how quickly you need to respond to customers. The Platform imports data once every 15 minutes.

You do not have to specify the type of operation for the object (update/create): when it is impossible to insert a record, our import mechanism itself realizes that it is an update.

When the Platform imports a file, it automatically deletes this file from the server to exclude repeated loading of the same data.

File Naming

Recommended format for naming files:

  • Customers: clients*.csv;

  • Orders: orders*.csv;

  • Order lines: items*.csv;

  • Events: events*.csv;

  • Products: product_items*.csv;

  • Product categories: product_cat*.csv;

  • Bonus balances: bonuses*.csv;

  • Promo codes: promocodes*.csv;

  • Directories: dictionaries*.csv.

File names contain the timestamp of the moment of unloading, including the current date and the current time: hours, minutes, and seconds.

PreviousData structureNextSQL server data

Last updated 1 year ago