en:dataexchange:import_which_properties_has_batchprocess
Differences
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 15:29] – fw | en:dataexchange:import_which_properties_has_batchprocess [2025/04/02 16:39] (current) – 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 42: | Line 42: | ||
| |**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 \\ - add \\ - addNoResubscribes \\ \\ 2) if auto target group is replaced: \\ Unsubscribing of all users that are not included in the current file?* \\ \\ <wrap lo>*critical feature; | + | |**If auto target group**|1) Adding OR replacing of the auto target group - possible methods: \\ - replace \\ - replaceNoResubscribes \\ - add \\ - addNoResubscribes \\ \\ 2) if auto target group is replaced: \\ Unsubscribing of all users that are not included in the current file?* \\ * Please note: this is not recommended and only possible if user data are synchronized completely and every night because users will be added to the blacklist.| |
| Line 76: | Line 76: | ||
| |b2b_user_id|int(8)|0|internal client ID: [xxxx]| | |b2b_user_id|int(8)|0|internal client ID: [xxxx]| | ||
| |id|int(9)| |internal customer ID. System field of promio.connect.| | |id|int(9)| |internal customer ID. System field of promio.connect.| | ||
| - | |mail|varchar(255)| | | | + | |mail|varchar(255)| |e-mail address| |
| - | |nick|varchar(255)| | | | + | |nick|varchar(255)| |nickname| |
| |vorname|varchar(255)| |first name| | |vorname|varchar(255)| |first name| | ||
| - | |name|varchar(255)| |last name| | + | |name|varchar(255)| |surname| |
| |gender|tinyint(1)|0|1=male, | |gender|tinyint(1)|0|1=male, | ||
| |mailerror|tinyint(1)|0|Internal last bounce status. System field of promio.connect.| | |mailerror|tinyint(1)|0|Internal last bounce status. System field of promio.connect.| | ||
| - | |unsubscribe|tinyint(1)|0|Internal unsubscribe | + | |unsubscribe|tinyint(1)|0|Internal unsubscribe |
| - | |source|tinyint(1)|0|Internal import | + | |source|tinyint(1)|0|Internal import |
| |strasse|varchar(255)| |street| | |strasse|varchar(255)| |street| | ||
| |plz |varchar(255)| |postal code| | |plz |varchar(255)| |postal code| | ||
| Line 94: | Line 94: | ||
| |tsLastUpdate|timestamp|on update CURRENT_TIMESTAMP|Timestamp of last update of data set. System field of promio.connect.| | |tsLastUpdate|timestamp|on update CURRENT_TIMESTAMP|Timestamp of last update of data set. System field of promio.connect.| | ||
| |agr|tinyint(3)|0|Advertisement agreement (1=given)| | |agr|tinyint(3)|0|Advertisement agreement (1=given)| | ||
| - | |tel|varchar(255)| |telephone | + | |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 116: | Line 116: | ||
| - | |Feld|Typ|Standard|Kommentare| | + | |**Fieldname**|**Fieldtype**|**Standard**|**Comment**| |
| |b2b_user_id|int(8)|0|internal client ID: [xxxx]| | |b2b_user_id|int(8)|0|internal client ID: [xxxx]| | ||
| |id|int(9)| |internal customer ID| | |id|int(9)| |internal customer ID| | ||
| - | |mail|varchar(255)| | | | + | |mail|varchar(255)| |e-mail address |
| - | |nick|varchar(255)| | | | + | |nick|varchar(255)| |nickname| |
| |vorname|varchar(255)| |first name| | |vorname|varchar(255)| |first name| | ||
| - | |name|varchar(255)| |last name| | + | |name|varchar(255)| |surname| |
| |gender|tinyint(1)|0|1=male, | |gender|tinyint(1)|0|1=male, | ||
| |strasse|varchar(255)| |street| | |strasse|varchar(255)| |street| | ||
| |plz|varchar(255)| |postal code| | |plz|varchar(255)| |postal code| | ||
| - | |ort|varchar(255)| |place| | + | |ort|varchar(255)| |city| |
| |custID|varbinary(255)| |external customer ID| | |custID|varbinary(255)| |external customer ID| | ||
| |country|varchar(255)| |de, at, ch, ...| | |country|varchar(255)| |de, at, ch, ...| | ||
| - | |reg_datetime|datetime|0000-00-00 00:00:00|Time of registration| | + | |reg_datetime|datetime|0000-00-00 00:00:00|Registration date| |
| |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. | ||
| - | To do so, you must provide two files in a ZIP archive: | + | To do so, you must provide |
| + | 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 156: | ||
| - | ==== 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 and saved in the SFTP folder | + | * // |
| + | * 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, | ||
| + | * //targetGroup// | ||
| + | * optional. Only necessary | ||
| + | * Target group ID is assigned automatically. | ||
| + | * Docs: [[https:// | ||
| + | * // | ||
| + | * optional. | ||
| + | * settings for delivery | ||
| + | * // | ||
| + | * for scheduling the campaign | ||
| + | * 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 |
en/dataexchange/import_which_properties_has_batchprocess.1559654958.txt.gz · Last modified: 2019/06/04 15:29 by fw
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
