This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
en:dataexchange:import_which_properties_has_batchprocess [2019/06/04 16:44] – [Standard field structure (internal)] fw | en:dataexchange:import_which_properties_has_batchprocess [2025/05/26 10:34] (current) – [action.json] fw | ||
---|---|---|---|
Line 5: | Line 5: | ||
Please upload csv-files with addresses or target group definitions (with customer IDs or eMail addresses) to / | Please upload csv-files with addresses or target group definitions (with customer IDs or eMail addresses) to / | ||
- | Click on //Adresses > Lists//, choose action //Import addresses// and follow the given instructions. | + | Click on //Adresses > Lists//, choose action //Import addresses// and follow the given instructions. You can find a manual in article //" |
Line 39: | Line 39: | ||
|**Test file**|This file must correspond exactly to the files that will be uploaded later, regarding charset, formatting (csv, bz2, Z), data structure (number + order of columns, separator, field delimiter).| | |**Test file**|This file must correspond exactly to the files that will be uploaded later, regarding charset, formatting (csv, bz2, Z), data structure (number + order of columns, separator, field delimiter).| | ||
|**E-mail address/ | |**E-mail address/ | ||
- | |**Address management feature**|custID OR mail; can be chosen differing from client configuration.| | + | |**Address management feature**|//custID// OR //mail// - can be chosen differing from client configuration.| |
|**Time of import**|Process is checking whether a file has been uploaded: daily at x o' | |**Time of import**|Process is checking whether a file has been uploaded: daily at x o' | ||
|**Creating a new target group**|Per import OR adding to a auto target group.| | |**Creating a new target group**|Per import OR adding to a auto target group.| | ||
- | |**If auto target group**|1) Adding OR replacing of the auto target group - possible methods: \\ - replace \\ - replaceNoResubscribes | + | |**If auto target group**|Adding OR replacing of the auto target group - possible methods: \\ - //replace//: the addresses provided replace the whole auto target group; recommended for daily transfer of the complete positive database |
Line 95: | Line 95: | ||
|agr|tinyint(3)|0|Advertisement agreement (1=given)| | |agr|tinyint(3)|0|Advertisement agreement (1=given)| | ||
|tel|varchar(255)| |phone number| | |tel|varchar(255)| |phone number| | ||
- | |birthday|date|0000-00-00| | | + | |birthday|date|0000-00-00|birthday| |
|pm_image|varchar(255)| |Link to an image of person (address research). Can be filled manually.| | |pm_image|varchar(255)| |Link to an image of person (address research). Can be filled manually.| | ||
|pm_reputation_score|tinyint(1)| |Internal reputation score. System field of promio.connect.| | |pm_reputation_score|tinyint(1)| |Internal reputation score. System field of promio.connect.| | ||
Line 132: | Line 132: | ||
|reg_ip|varchar(255)| |Registration IP| | |reg_ip|varchar(255)| |Registration IP| | ||
|agr|tinyint(3)|0|Advertisement agreement (1=given)| | |agr|tinyint(3)|0|Advertisement agreement (1=given)| | ||
- | |tel|varchar(255)| | | | + | |tel|varchar(255)| |phone number |
- | |birthday|date|0000-00-00| | | + | |birthday|date|0000-00-00|birthday| |
|special_1|varchar(255)| |Free variable for future use| | |special_1|varchar(255)| |Free variable for future use| | ||
|special_2|varchar(255)| |Free variable for future use| | |special_2|varchar(255)| |Free variable for future use| | ||
- | ===== Automatic | + | ===== Automatic |
- | After the automatic import of a target group, you can carry out additional tasks by invoking an API call. A common application is the automatic set-up of an email with subsequent | + | After the automatic import of a target group, you can trigger |
- | This requires configuring an automatic import process through promio.net support. | + | This requires configuring an automatic import process through promio.net support. |
- | + | The import creates the target group used for delivery (no use of an auto target group supported). | |
- | To do so, you must provide two files in a ZIP archive: | + | |
+ | To do so, you must provide the two files // | ||
+ | This ZIP file must be named according to the agreed upon naming scheme and provided in the SFTP folder / | ||
==== user.csv ==== | ==== user.csv ==== | ||
Line 156: | Line 157: | ||
- | ==== action.xml ==== | + | ==== action.json ==== |
- | Contains | + | Contains |
+ | These are used after the automatic import | ||
- | The other values must be filled out correctly. Be certain to ensure that all text uses HTML entities throughout. | ||
- | < | + | === Maximum specification with all necessary and optional properties === |
- | < | + | < |
- | > => > | + | { |
- | etc. | + | " |
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | }, | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | }, | ||
+ | " | ||
+ | " | ||
+ | } | ||
+ | }, | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | | ||
+ | ], | ||
+ | " | ||
+ | { | ||
+ | " | ||
+ | " | ||
+ | } | ||
+ | ] | ||
+ | }, | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | } | ||
+ | }, | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | }, | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | }, | ||
+ | " | ||
+ | " | ||
+ | { | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | } | ||
+ | ] | ||
+ | } | ||
+ | } | ||
+ | } | ||
</ | </ | ||
- | <code xml> | + | === Required fields and instructions |
- | <?xml version=" | + | |
- | < | + | |
- | | + | |
- | | + | |
- | | + | |
- | < | + | |
- | < | + | |
- | < | + | |
- | < | + | |
- | < | + | |
- | < | + | |
- | </ | + | |
- | < | + | |
- | <format xsi: | + | |
- | < | + | |
- | < | + | |
- | < | + | |
- | < | + | |
- | < | + | |
- | </ | + | |
- | </ | + | |
- | < | + | |
- | < | + | |
- | </ | + | |
- | < | + | |
- | < | + | |
- | <subject xsi: | + | |
- | < | + | |
- | < | + | |
- | < | + | |
- | & | + | |
- | </ | + | |
- | < | + | |
- | </ | + | |
- | </ | + | |
- | </ | + | |
- | </ | + | |
- | </code> | + | * // |
- | + | * necessary. Enter ID of the client. | |
- | This ZIP file must be named according to the agreed upon naming scheme | + | * // |
+ | * required. Required field within: //name// | ||
+ | * Docs: [[https:// | ||
+ | * // | ||
+ | * required | ||
+ | * if // | ||
+ | * message is built from a template | ||
+ | * required: //name// | ||
+ | * if // | ||
+ | * required: //name// | ||
+ | * Docs: [[https:// | ||
+ | * // | ||
+ | * required for messages that are not created by a template | ||
+ | * required fields: // | ||
+ | * //text//: | ||
+ | * optional. Only necessary for a different text part. If //text// is not specified, | ||
+ | * // | ||
+ | * optional. Only necessary for setting // | ||
+ | * Target group ID is assigned automatically. | ||
+ | * Docs: [[https:// | ||
+ | * // | ||
+ | * optional. | ||
+ | * settings for delivery | ||
+ | * // | ||
+ | * for scheduling the campaign. If the specified delivery time is in the past, it is automatically changed to IMMEDIATELY. | ||
+ | * required: | ||
+ | * Docs: [[https:// | ||
+ | * //start// | ||
+ | * delivery is only started if //start// is set. | ||
+ | * no required fields | ||
+ | * Docs: [[https:// | ||
+ | * // | ||
+ | * optional. Send a test mail. | ||
+ | * Docs: [[https:// | ||
+ | **Important: | ||
+ | The source code in // | ||
+ | The following (external) website provides information on how to escape, as well as an option to have source text escaped automatically: | ||
+ | === Examples === | ||
+ | Example of creating a message via HTML source code (incl. start delivery): | ||
+ | <code JavaScript> | ||
+ | { | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | }, | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | } | ||
+ | }, | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | }, | ||
+ | " | ||
+ | } | ||
+ | } | ||
+ | } | ||
+ | </ | ||
+ | Example of creating a message via template (without start delivery): | ||
+ | <code JavaScript> | ||
+ | { | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | }, | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | } | ||
+ | } | ||
+ | </ | ||
- | {{tag>Import | + | {{tag>imports |