Sitecore Web Forms for Marketers and DMS - Do Not Record Campaigns, Goals, or Eviction Information

There is an option in WFFM, so when someone refuses the form, any data that was entered in the form itself is recorded and should be accessible through a dropout report.

I have a WFFM for which I turned on Google Analytics and turned on the cutoff function. Unfortunately, I do not see any data written to the database, and the report of the loss is visible, but empty.

I can see from the javascript code included in the WFFM folder that a series of AJAX calls should save the fields in blur events - with calls to / sitecore modules / web / Web Forms for Marketers / Tracking.aspx

I tried debugging Javascript code, but the method that should post information to / sitecore modules / web / Web Forms for Marketers / Tracking.aspx is never called. Can you come up with any reason for this code not working? Also, does anyone know which table should be written? Is this a table of fields in WFFM DB?

Finally, although I included analytics in this particular WFFM form, and I linked the campaign and the form submission goal, none of them are written. I see that the data entered into the form is saved successfully and displayed in the data report, but the information about the Campaign or goal is not recorded in the database.

I even checked manually directly in DMS DB:

select top 10
p.DateTime, p.UrlText, cp.CampaignName
,i.Url, vi.VisitId
from pages p
inner join ItemUrls i on p.ItemId = i.ItemId
inner join Visits vi on vi.VisitId = p.VisitId
inner join GeoIps g on vi.Ip = g.Ip
left join Campaigns cp on cp.CampaignId = vi.CampaignId
order by p.DateTime desc

This shows that the page on which the form is displayed hits, but no campaign is associated with the visit.

Then I tried the following:

select pe.datetime, ped.Name, pg.UrlText from PageEvents pe
inner join PageEventDefinitions ped on ped.PageEventDefinitionId = pe.PageEventDefinitionId
inner join Pages pg on pg.PageId = pe.PageId
order by pe.DateTime desc

( , , WFFM Sitecore).

!

,

sc.webform.js :

_create: function () {
var self = this,
    options = this.options;
if (options.tracking) {
    this.element.find("input[type!='submit'], select, textarea")
    .bind('focus', function (e) { self.onFocusField(e, this) })
    .bind('blur change', function (e) { self.onBlurField(e, this) });

    this.element.find("select")
        .change(function () { $scw.webform.controls.updateAnalyticsListValue(this) });

    this.element.find("input[type='checkbox'], input[type='radio']")
        .click(function () { $scw.webform.controls.updateAnalyticsListValue(this) });
}

this.element.find(".scfDatePickerTextBox").each(function () { $scw.webform.controls.datePicker(this) });
},

, sc.webform. , . , , .

SECOND EDIT

. , Javascript, , WFFM:

<script type="text/javascript">
$scwhead.ready(function() {
    $scw('#form_A8BF483419174F97A2830E12CBCF7E4F').webform({formId: "{A8BF4834-1917-4F97-A283-0E12CBCF7E4F}",pageId: "{21C24144-B964-4FBA-8388-D9B90EBBC17C}",eventCountId: "pagecolumns_0_columncontent_0_bottomrow_0_form_A8BF483419174F97A2830E12CBCF7E4F_form_A8BF483419174F97A2830E12CBCF7E4F_eventcount",tracking: true})
}); 
</script>

, _create jQuery.UI, sc.webform.js. , _create, jQuery.UI. Kinda , ?

, _create, TrackEvents, :

_trackEvents: function(events) {
$scw.ajax({
     type: 'POST',
     url: "/sitecore modules/web/Web Forms for Marketers/Tracking.aspx" + location.search,
     data: {track: JSON.stringify(events)},
     dataType: 'json'
});

, , , , , , trackEvents , WFFM ( mistery ), , t , WFFM. :

select f.Timestamp, f.StorageName, fi.Value, fi.FieldName 
from Form f
inner join Field fi on f.Id = fi.FormId
order by f.Timestamp desc, FieldName

- , Tracking.aspx ?

+5
3

, WFFM? , , WFFM.. SQL "", WFFM .

SQL:

   <!-- MSSQL-->

    <formsDataProvider type="Sitecore.Forms.Data.DataProviders.WFMDataProvider,Sitecore.Forms.Core">
  <param desc="connection string">Database=Sitecore_WebForms;Data Source=xxx;user id=xxx;password=xxx;Connect Timeout=30</param>
</formsDataProvider>

<!-- SQLite -->

<!--<formsDataProvider type="Sitecore.Forms.Data.DataProviders.SQLite.SQLiteWFMDataProvider,Sitecore.Forms.Core">
  <param desc="connection string">Data Source=/data/sitecore_webforms.db;version=3;BinaryGUID=true</param>
</formsDataProvider>-->

, , - , ? , , , , , , - ? , .

+1

6.5 update 6 WFFM 2.3.3 rev. 111209. , , , json, .

:

track:[{"fieldId":"{E0A0BCDD-85E1-4D8D-9E76-5ABD240423C9}","type":"Field Completed","value":"test","formId":"{0F3B57C1-1B6A-43B9-A5A6-2E958C168B31}","pageId":"{025AFF68-62B9-42CE-B49F-0C36311E1976}","ticks":16}]

, - , ...

+1

, ? , . :

  • → →
  • "".
  • pageeventdefinition .

.

0

All Articles