Mapping refers to the ability to use a .CSV file or .XLS  file as a destination.  This file can be referred to in the XML as DocRef which means it is placed somewhere within the XML then referred to once or multiple times elsewhere within the XML.

 

I would like to cover a few of the rules in Field Column names and what they refer to when you place them in the .CSV file.

 

The .CSV file must always contain an element mapping to the USER:TO keyword.  This is usually a column named ADDR in the .CSV and it relates to the Delivery Address.

 

The second important field is USER:ADDR_TYPE which is usually labeled TYPE.  This can be a multitude of different values, some of which are internet, mbox, sms, fax, voice, etc.  If no column is mapped to the keyword TYPE then the value “fax” will be assumed.

 

Some really useful features can be utilized in the .CSV file such as the use of the column PASSWORD.  If this is specified then a user specific password must be supplied by in order for the messageREACH pull attachments to be viewed.  That way an individual password can be supplied to each recipient allowing you to track who has accessed what.

 

Another very useful feature is EFORMAT.  By placing this column heading in your .CSV file you can specify the format of the email that the recipient will receive or, html, htmllite, or text.

 

Of course one of the most useful features is the INS_N keyword.  You are literally creating a variable using this which can then be supplied to the email, sms, or many other types of communications. 

 

Of course there are many keywords that are specific to FAX or just EMAIL alone.  I would advise you to check out the API Manual to learn more about all the headings.

 

Here is an examples of using the various .CSV values within the XML, although with this example the .CSV values are embedded directly, but as explained before they could also be in a .CSV file or .XLS file.

 

    <JobSubmitRequest xmlns="http://premconn.premiereconnect.com/2007/02">
      <DocumentSet>
        <Document ref="message_body">
          <DocType>text</DocType>
          <DocData format="text">This is an Email Test of Embedded Values</DocData>
        </Document>
        <Document ref="destination">
          <DocType>text</DocType>
          <DocData format="text">REF,ADDR,TYPE
            CUST-1,j.martin@abc.com,internet</DocData>
        </Document>
      </DocumentSet>
      <Message>
        <JobOptions>
          <EnhancedEmailOptions/>
        </JobOptions>
            <Destinations>
              <Table ref="jans_Table">
                <DocRef>destination</DocRef>
              </Table>
            </Destinations>
        <Contents>
          <Part>
              <DocRef>message_body</DocRef>
              <Treatment>body</Treatment>
            </Part>
        </Contents>
      </Message>
    </JobSubmitRequest>

 

Also attached is an actual .CSV file which could easily be used or modified to be used with email, sms, fax, etc.

 

The layout looks like this:

REF	ADDR	TYPE	INS_1	INS_2	INS_3	PASSWORD
el email	EMAIL ADDRESS	Internet	Variable1	Variable 2	Variable 3	MyPassword

As you can see here this .CSV file makes use of Inserts and a Password value.  Also as you can see at the beginning you can pass in a reference value which will be returned.

 

I hope this helps explain the use of .CSV files and some of the columns.

Attachment	Size
CSV_list1.csv	118 bytes