KnowledgeBase - What is the Webtrends Enterprise Data Connector log file format?
Article

What is the Webtrends Enterprise Data Connector log file format?

« Go Back
Products
Webtrends On Demand
Introduction

What is the Webtrends Enterprise Data Connector log file format?
Procedure
The Webtrends Enterprise Data Connector (EDC) log file format, sometimes referred to as the Teradata log file format, is available as an alternative to the Webtrends W3C format used for Log File Delivery. A utility exists that can perform conversions on existing W3C format files, available via Professional Services.

The EDC format makes it is easier to import log file data into a data warehousing system using their loader function, and while the basic format is similar to Webtrends' log files, some differences exist:

    Some fields are not mapped from the W3C format.
    Field delimiter is a tab.
    By default there is no field header on the file.
    The File extension is .lta instead of .log

W3C format example:#
#Fields: date time c-ip cs-username cs-host cs-method cs-uri-stem cs-uri-query sc-status sc-bytes cs-version cs(User-Agent) cs(Cookie) cs(Referer) dcs-geo dcs-dns origin-id dcs-id
2013-06-24 16:00:00 127.0.0.1 - - GET /folder1/folder2/folder3/fileName.htm WT.vtid=127.0.0.1-929819760.30302315&WT.vtvs=1372089573949&WT.ti=SomePageName&WT.vt_f_tlh=1372089595&WT.vt_tlh=1372089596&WT.co=Yes&WT.vt_sid=127.0.0.1-929819760.30302315.1372089575&WT.co_f=127.0.0.1-929819760.30302315 200 - - Mozilla/4.0+compatible;+MSIE+8.0;+Windows+NT+6.1;+WOW64;+Trident/4.0;+SLCC2;+.NET+CLR+2.0.50727;+.NET+CLR+3.5.30729;+.NET+CLR+3.0.30729;+Media+Center+PC+6.0;+.NET4.0C;+MALC) WEBTRENDS_ID=127.0.0.1-929819760.30302315;+WT_ACCT=127.0.0.1-929819760.30302315 - cc=BR&ci=Porto+Alegre&cn=South+America&co=Comite+Gestor+Da+Internet+No+Brasil&cs=Brazil&nt=Broadband&rc=RS&rs=Rio+Grande+Do+Sul&tz=GMT%2D2 haco-vl1010-acc01.jve.commcorp.net.br dcs-2013-06-24-16-00000-iaddcs02v dcsxxxxxxxxxxxxxxxxxxxxxx_xxxx


EDC format example:
2013-06-24 16:00:00 127.0.0.1 - - GET /folder1/folder2/folder3/fileName.htm WT.vtid=127.0.0.1-929819760.30302315&WT.vtvs=1372089573949&WT.ti=Hero%20Carousel%20Home&WT.vt_f_tlh=1372089595&WT.vt_tlh=1372089596&WT.co=Yes&WT.vt_sid=127.0.0.1-929819760.30302315.1372089575&WT.co_f=127.0.0.1-929819760.30302315 200 - - Mozilla/4.0+(compatible;+MSIE+8.0;+Windows+NT+6.1;+WOW64;+Trident/4.0;+SLCC2;+.NET+CLR+2.0.50727;+.NET+CLR+3.5.30729;+.NET+CLR+3.0.30729;+Media+Center+PC+6.0;+.NET4.0C;+MALC) WEBTRENDS_ID=127.0.0.1-929819760.30302315;+WT_ACCT=127.0.0.1-929819760.30302315 - cc=BR&ci=Porto+Alegre&cn=South+America&co=Comite+Gestor+Da+Internet+No+Brasil&cs=Brazil&nt=Broadband&rc=RS&rs=Rio+Grande+Do+Sul&tz=GMT%2D2 dcsxxxxxxxxxxxxxxxxxxxxxx_xxxx        Yes   127.0.0.1-929819760.30302315                                       Hero Carousel Home                          1372089595   127.0.0.1-929819760.30302315.1372089575     BR Porto+Alegre South+America Comite+Gestor+Da+Internet+No+Brasil Brazil        Broadband     RS Rio+Grande+Do+Sul  GMT%2D2   


The EDC log by default does not have a header. However, this can be set to contain a header by editing the wtlta.ini file and setting the following variable:

outputdebugheader=true


Note: The delimiter is tab by default however a space, or any other non-double-byte character, may be substituted in its place.
More Information
The following is a list of default parameters. Any Webtrends Parameter may be included however.
 
[params]Value=
WT.acAd click
WT.adAd name
WT.bhBrowsing hour
WT.bsBrowser window size
WT.cdColor palette depth
WT.cg_nContent group name
WT.cg_sContent sub-group
WT.coWebtrends cookie
WT.co_aCustomer defineed cookie
WT.co_dWebtrends cookie (third party)
WT.co_fWebtrends cookie (first party)
WT.ctConnection type
WT.dcsvidWebtrends external visitor ID
WT.dlEvent type indicator (page view, downloads, etc)
WT.emEncoding method
WT.esClick based tracking
WT.fiFlash installed
WT.fvFlash version
WT.hdrHttp header
WT.hpHome page event
WT.joJava enabled
WT.jsJavascript enabled
WT.jvJava version
WT.leLanguage encoding
WT.mc_evMarketing campaign event type
WT.mc_idMarketing campaign ID
WT.mleMetalanguage encoding
WT.ossOnsite search terms
WT.oss_rOnsite search number of results
WT.piProduct attribute parameter
WT.pn_faProduct attribute parameter (family)
WT.pn_grProduct attribute parameter (group)
WT.pn_idProduct ID
WT.pn_maProduct attribute parameter (manufacturer)
WT.pn_scProduct attribute parameter (sub-catagory)
WT.pn_skuProduct sku
WT.pn_suProduct attribute parameter (supplier)
WT.rvRegistration event (registered visitor true)
WT.seg_xSegmentation
WT.si_csConversion step event
WT.si_nScenario name
WT.si_pScenario step name
WT.si_xScenario step number
WT.slvSilverlight version
WT.spWT profile split parameter
WT.srScreen resolution
WT.srchPaid search indicator
WT.svSmartView
WT.svlSmartView link
WT.tiPage title
WT.tspSmartView transition source
WT.ttpSmartView transition target page
WT.tuURL truncated
WT.tvWebtrends tag version
WT.tx_cartidTransaction cart ID
WT.tx_eTransaction event (purchase, add to cart, etc.)
WT.tx_iTransaction invoice
WT.tx_idTransaction invoice date
WT.tx_itTransaction invoice time
WT.tx_sTransaction subtotal
WT.tx_tTransaction total
WT.tx_uTransaction # of units
WT.tzBrowser time zone setting
WT.ulUser language
WT.vhseg_1Custom WT visitor history segment #1
WT.vhseg_2Custom WT visitor history segment #2
WT.vhseg_3Custom WT visitor history segment #3
WT.vhseg_4Custom WT visitor history segment #4
WT.vt_a_dVisitor history visit attributes
WT.vt_a_sVisitor history visit attributes
WT.vt_dVisitor history visit attributes
WT.vt_fVisitor history visit attributes
WT.vt_f_aVisitor history visit attributes
WT.vt_f_dVisitor history visit attributes
WT.vt_f_sVisitor history visit attributes
WT.vt_f_tlhWH 1st party cookie time last hit
WT.vt_f_tlvWH 1st party cookie time last visit
WT.vt_sWarehouse visit start time
WT.vt_sidWarehouse sessionID parameter
WT.vt_tlvWarehouse time of last visit

[geoparams]

arArea code
ccCountry code
ciCity
cnContinental region
coProvider
csCountry string
dmDesignated marketing area
dmcDesignated marketing area city
dmsDesignated marketing area state
msMetropolitan statistical area
mcsMetropolitan statistical area city
mssMetropolitan statistical area state
noOperator
ntNetwork type
nwNetwork
pmpm
pmcpmc
pmspms
rcLanuage
Was this article helpful?

Please tell us how we can make this article more useful.

Characters Remaining: 255