Translating values - Receive as x post out as y

Follow

How to translate values in Export Schedules

When you are taking in large amounts of data from multiple sources and distributing to many buyers, it is important that you can cater to every format.

Translating values on the output in LeadByte is simple, and can be found in the deliveries tab and the export schedules tab. 

Below is a step by step guide on how you can go about translating values in LeadByte.

 

Step 1 - In LeadByte, click on Delivery > Manage File Schedules > Create New Schedule or edit an existing Schedule

  

 

Step 2 - Once you've set the fields you wish to translate, select options on the right side 

Image_2020-02-05_at_1.17.34_PM.png

 

These fields can then be translated to whatever values your spreadsheet needs them to be. 

For example, let's say our system has Gender "Male" or "Female" as a value, and your client wants the value as only "M" or "F". You can then translate every "Male" or "Female" field to be exported as "M" or "F" by using the below rules. You can also use the conversion field to Auto capitalise.

 Image_2020-02-05_at_1.27.56_PM.png

 

Likewise, if the field you wish to translate is "DOB", you can select a variety of formats to best suit your needs. For example:

Image_2020-02-05_at_1.29.30_PM.png

 This way you can translate the DOB format to match your records. This also applies to any other values you want to translate.

 

How to translate values in Delivery

 Step 1 - In LeadByte, click on Delivery > Manage Deliveries > Add New Delivery or edit an existing Delivery 

 

 Step 3 - Scroll down to Custom Data Mappings, and select options. In case this is a new campaign, select Add New Mapping. For this example we'll use DOB as a value 

_b1cc7941e045abd19cf2b1a20e3f4a38__Screenshot-2018-10-11T13_45_52.138Z.png

 

Step 4 - In the options you can define how you want to export your data format

_d26bf844df39bee916f9064a57733f2b__Screenshot-2018-10-11T13_46_48.135Z.png

(Optional) If you tick ISO 8601, this will format the date values to the standard format which you can see in the following screenshot

_64838c735bd60f7264a4a50c96c32438__Screenshot-2018-10-11T13_47_17.883Z.png 

Alternatively, if you set the data type of the field as date/time, you can then leave the custom time pattern as blank to export only a date.

_0bdeb20d17b945d56ac713fcf99c7387__Screenshot-2018-10-11T14_46_31.503Z.png

_f2a3f65d4473a36536cbd7e41c430a6b__Screenshot-2018-10-11T14_46_49.714Z.png

And that's it! For any further questions please don't hesitate to raise a support ticket.

Was this article helpful?
0 out of 0 found this helpful

Comments