Import
Which file format is acceptable for import?
File formats acceptable for import are “.CSV” or “.Zip” files that contain “.csv”.
When I drop a file to FTP, will it be deleted or remain there forever?
Once the file is consumed by Dengage, then it will be removed from the FTP.
How can I load contacts manually?
You can load contacts manually by using import functionality. For data import follow the following flow:
➡️ Dataspace -> Import -> New ->Tables -> Upload the csv file containing the data -> Next -> Select table in which you want to import data -> Map the columns -> start import.
Can I import my contact list and send an email to them?
Yes ✅, you can do so by first creating a "sendlist" table in the Data Space-Tables. Import your contact list into this table. Then, designate this "sendlist" table as the target audience.
How can we check the data import reports?
You can check data import reports under :
➡️ DataSpace – Import menu. You can see all import operations under the Log menu on the page that opens.From the “Filter” on the top right; You can filter by Source, Uploader and Status.
Can we import our Product catalogue to D-engage with XML file?
The product catalogue can be shared through various methods:
Dengage API: If you're using the standard e-commerce table structure, utilise the Upsert Product method. Otherwise, for larger data sets (1000 or more upserts), use the Update Data Asynchronous method. For smaller data sets (less than 1000 upserts), employ the Post Data Space-Sync-Upsert method.
FTP: Share your product catalogue as a .csv file via FTP. Refer to the Automation FTP User documentation for details.
Remote Source Method: Establish a direct database connection to share the product catalogue.
For standard e-commerce tables, access product and product_variant table details Ecommerce Tables
How can I create an Automated Job to have a regular export?
You can make a regular export when you follow the steps mentioned below.
Data Space - Automated Flows – New Automated Flow
Recurring Trigger is selected and the recurrence time is defined for this trigger.
➡️ Data Export - Select data source(table, segment, sql, permission change logs, Incremental Logs) is selected. Depending on the selected data source, in the next step, it is selected which table data will be exported if it is a table, and which segment data will be exported if it is a segment, and Select Remote Target (FTP export, Google Customer Match, Facebook Custom Audience, TikTok Custom Audience, Web API, Amazon S3 etc.) is selected. .
The remote target option can only be used for "incremental log" export.
Where can I see if my import got an error?
To see if your import got an error, navigate to Menu > Data Space > Import pageant click on the Filter option at the top right. In the popup that appears, select "Error" in the status field, then click the Apply button.This action will display all uploads that encountered errors.To view details about the specific errors and the steps at which they occurred, go to Data Space > Automated Flow screen, click on the flow with a "Error" status in the status column, and navigate to the "Job History" tab.
How can I create an Automated Job to import data from FTP?
To create an Automation job for importing data from FTP follow these steps:
- Go to the automated job section.
- Click Add then specify a name and start/end date for the job and click Next.
- Select the File drop trigger from the triggers in the left panel.
- Click to configure on the file drop trigger and specify the FTP user and directory where you will be uploading the files through FTP.
- Specify the file headers and click OK.
- From the actions panel select data space update to update the table with your data.
Note: File headers are basically columns in your file and their sequence doesn't matter.
Updated 6 months ago