Automated imports

When a regular import is required (usually for processes such as importing user profiles from a third party platform), then Xtremepush Automations is the place to go.

Using this feature allows users to set up a daily, weekly or monthly schedule and select the source for the data to be imported from.

Imports

Navigate to Data > Automations and select the Imports tab.

From here it is possible to view all Automated Imports for the project, their source, frequency and status. It is also possible to see when they last ran and whether that import was successful.

Clicking on the last run timestamp shows details and any errors for that import.

Actions that can be performed on an existing automation can be found by clicking on > more.
Imports can be activated/de-activated and run now if an immediate import is required.

Create Import

Click the Create Import button to be taken to the wizard driven setup process.

Data Source

After giving the automation a name the first step is to select the source for the data.
Select the SFTP file storage which has been set up via the project's Integrations Marketplace and describe the path to the file in the same format as shown below.

The file name cannot be left blank but a matching pattern using a regular expression can be used to pick up files of a known type or with a filename which follows a specific pattern. A site such as Regex101 can be used to check the pattern entered in the filename field will match the required files in the SFTP.

After all details are entered the Refresh Schema button can be used to check that the set up is correct and that Xtremepush can find and read the file from the specified location.

Data Mapping

Once the file is selected it is possible to move onto the data mapping step.

Here platform users are able to match up columns found in the CSV file on the SFTP with attributes which exist in the project.

🚧

Available Attributes

It is only possible to select existing attributes in the project, so make sure to create any desired attributes before setting up an automation.

Schedule

Finally, a frequency for import can be set on the scheduling step. It is possible to set the automation to run monthly, weekly or daily. After saving the schedule it will run at the next available time closest to the current time. Note the timezone set in your project and account for any adjustment needed in your process to avoid issues such as a file being updated in the SFTP by a system running in a timezone different to the one set in the automation schedule.

At the set scheduled time Xtremepush will check the given directory for any files matching the details given and import them. They will then be timestamped and moved to a folder named archive. If the folder doesn't already exist one will be automatically created.

Trigger API Campaign

This feature provides you with the capability to execute API-triggered campaigns seamlessly through the import of profile data.

📘

Can't see this feature?

This feature is not enabled by default. If you would like to use this feature, please contact us.

Once you fill in the Data Source and Data Mapping sections as described above, on the Schedule tab, pick the API-triggered Campaign that will be sent to the imported profiles following the successful profile import. Then, select the time when you intend to trigger the chosen campaign.

🚧

Import required

If the profile import has not been completed by the scheduled campaign time, the campaign will not be executed.

After importing the profiles, navigate to Data > Task history, find the related task and click on the Options menu on the right > Details. This will allow you to review the import task, export exclusions, and potential errors in greater detail.

🚧

Cancel campaign triggering

If you want to cancel the automated campaign triggering before triggering the campaign navigate to the task details from Data > Task history and click on the Cancel button.