private ServiceConfiguration GetStagingConfig()
{
var config = new PipelineServiceConfiguration
{
ServiceClass = typeof(MetricsStagingService).AssemblyQualifiedName,
Limits = { MaxExecutionTime = new TimeSpan(0, 1, 0, 0) },
DeliveryID = GetDeliveryId("Settings"),
MappingConfigPath = "",
};
// TODO shirat - check if should be a part of configuration class and not parameters
config.Parameters["ChecksumTheshold"] = "0.1";
config.Parameters["Sql.TransformCommand"] = "SP_Delivery_Transform_BO_Generic(@DeliveryID:NvarChar,@DeliveryTablePrefix:NvarChar,@MeasuresNamesSQL:NvarChar,@MeasuresFieldNamesSQL:NvarChar,?CommitTableName:NvarChar)";
config.Parameters["Sql.StageCommand"] = "SP_Delivery_Rollback_By_DeliveryOutputID_v291(@DeliveryOutputID:NvarChar,@TableName:NvarChar)";
config.Parameters["Sql.RollbackCommand"] = "SP_Delivery_Stage_BO_Generic(@DeliveryFileName:NvarChar,@CommitTableName:NvarChar,@MeasuresNamesSQL:NvarChar,@MeasuresFieldNamesSQL:NvarChar,@OutputIDsPerSignature:varChar,@DeliveryID:NvarChar)";
config.Parameters["IgnoreDeliveryJsonErrors"] = true;
config.Parameters["IdentityInDebug"] = true;
config.Parameters["IdentityConfig"] = @"
<IdentityConfig>
<EdgeType Name='Campaign' CreateNewObjects='false'>
<FieldToUpdate Name='Location' />
<FieldToUpdate Name='IsLocationNegative' />
<FieldToUpdate Name='Language' />
<FieldToUpdate Name='IsLanguageNegative' />
</EdgeType>
</IdentityConfig>";
return(config);
}
private ServiceConfiguration GetInitializerConfig()
{
var config = new PipelineServiceConfiguration
{
ServiceClass = typeof(Edge.Services.BackOffice.EasyForex.InitializerService).AssemblyQualifiedName,
DeliveryID = GetGuidFromString("Delivery7"),
TimePeriod = GetTimePeriod(),
Limits = { MaxExecutionTime = new TimeSpan(0, 1, 0, 0) }
};
config.Parameters["IgnoreDeliveryJsonErrors"] = true;
config.Parameters["Sql.RollbackCommand"] = "SP_Delivery_Stage_BO_Generic(@DeliveryFileName:NvarChar,@CommitTableName:NvarChar,@MeasuresNamesSQL:NvarChar,@MeasuresFieldNamesSQL:NvarChar,@OutputIDsPerSignature:varChar,@DeliveryID:NvarChar)";
config.Parameters["SourceUrl"] = "https://classic.easy-forex.com/BackOffice/API/Marketing.asmx";
config.Parameters["SOAPAction"] = "http://www.easy-forex.com/GetGatewayStatistics";
config.Parameters["SoapMethod"] = "GetGatewayStatistics";
config.Parameters["StartGid"] = "1";
config.Parameters["EndGid"] = "1000000";
config.Parameters["User"] = "******";
config.Parameters["Pass"] = "******";
config.Parameters["FileDirectory"] = "EasyForexBackoffice";
config.Parameters["Bo.Xpath"] = "Envelope/Body/GetGatewayStatisticsResponse/GetGatewayStatisticsResult/diffgram/DSMarketing/CampaignStatisticsForEasyNet";
config.Parameters["Bo.IsAttribute"] = "false";
config.Parameters["Bo.TrackerIDField"] = "GID";
return(config);
}
private ServiceConfiguration GetInitializerConfig()
{
var config = new PipelineServiceConfiguration
{
ServiceClass = typeof(InitializerService).AssemblyQualifiedName,
DeliveryID = GetDeliveryId("Settings"),
TimePeriod = GetTimePeriod(),
Limits = { MaxExecutionTime = new TimeSpan(0, 1, 0, 0) }
};
config.Parameters["IgnoreDeliveryJsonErrors"] = true;
config.Parameters["Adwords.MccEmail"] = ADWORDS_MCC_EMAIL;
config.Parameters["Adwords.ClientID"] = ADWORDS_CLIENT_ID;
config.Parameters["DeveloperToken"] = "5eCsvAOU06Fs4j5qHWKTCA";
config.Parameters["Sql.RollbackCommand"] = "SP_Delivery_Stage_BO_Generic(@DeliveryFileName:NvarChar,@CommitTableName:NvarChar,@MeasuresNamesSQL:NvarChar,@MeasuresFieldNamesSQL:NvarChar,@OutputIDsPerSignature:varChar,@DeliveryID:NvarChar)";
config.Parameters["Adwords.ReportConfig"] = @"
<GoogleAdwordsReportConfig>
<Report Name='CampaignCriterion' Type='CampaignCriterion' Filter='LOCATION|LANGUAGE' Enable='true'>
<Field Name='Id' />
<Field Name='CriteriaType' />
<Field Name='IsNegative' />
<Field Name='CampaignId' />
<Field Name='LanguageCode' />
<Field Name='LanguageName' />
<Field Name='LocationName' />
<Field Name='DisplayType' />
</Report>
</GoogleAdwordsReportConfig>
";
return(config);
}
private ServiceConfiguration GetInitializerConfig()
{
var config = new PipelineServiceConfiguration
{
ServiceClass = typeof(InitializerService).AssemblyQualifiedName,
DeliveryID = GetDeliveryId("ObjectsUpdate"),
TimePeriod = GetTimePeriod(),
Limits = { MaxExecutionTime = new TimeSpan(0, 1, 0, 0) }
};
config.Parameters["IgnoreDeliveryJsonErrors"] = true;
config.Parameters["FilterDeleted"] = false;
config.Parameters["KeywordContentId"] = "111";
config.Parameters["Adwords.MccEmail"] = ADWORDS_MCC_EMAIL;
config.Parameters["Adwords.ClientID"] = ADWORDS_CLIENT_ID;
config.Parameters["DeveloperToken"] = "5eCsvAOU06Fs4j5qHWKTCA";
config.Parameters["SubChannelName"] = "sub";
config.Parameters["Sql.RollbackCommand"] = "SP_Delivery_Stage_BO_Generic(@DeliveryFileName:NvarChar,@CommitTableName:NvarChar,@MeasuresNamesSQL:NvarChar,@MeasuresFieldNamesSQL:NvarChar,@OutputIDsPerSignature:varChar,@DeliveryID:NvarChar)";
config.Parameters["includeZeroImpression"] = true;
config.Parameters["Adwords.ReportConfig"] = @"
<GoogleAdwordsReportConfig>
<Report Name='CAMPAIGN_STATUS' Type='CAMPAIGN_PERFORMANCE_REPORT' Enable='true'>
<Field Name='CampaignId' />
<Field Name='CampaignName' />
<Field Name='CampaignStatus' />
<Field Name='TotalBudget' />
<Field Name='Period' />
</Report>
</GoogleAdwordsReportConfig>
";
return(config);
}
private ServiceConfiguration GetRetrieverConfig()
{
var config = new PipelineServiceConfiguration
{
ServiceClass = typeof(UrlRetrieverService).AssemblyQualifiedName,
DeliveryID = GetGuidFromString("Delivery1")
};
config.Parameters["IgnoreDeliveryJsonErrors"] = true;
return(config);
}
private ServiceConfiguration GetRetrieverConfig()
{
var config = new PipelineServiceConfiguration
{
ServiceClass = typeof(Edge.Services.BackOffice.EasyForex.RetrieverService).AssemblyQualifiedName,
//ServiceClass = typeof(MyEasyForexBackofficeRetrieverService).AssemblyQualifiedName,
DeliveryID = GetGuidFromString("Delivery7"),
TimePeriod = GetTimePeriod(),
Limits = { MaxExecutionTime = new TimeSpan(0, 2, 0, 0) }
};
config.Parameters["IgnoreDeliveryJsonErrors"] = true;
return(config);
}
private ServiceConfiguration GetRetrieverConfig()
{
var config = new PipelineServiceConfiguration
{
ServiceClass = typeof(MyBackofficeRetrieverService).AssemblyQualifiedName,
//ServiceClass = typeof(RetrieverService).AssemblyQualifiedName,
DeliveryID = GetDeliveryId("SaleForce"),
TimePeriod = GetTimePeriod(),
Limits = { MaxExecutionTime = new TimeSpan(0, 2, 0, 0) }
};
config.Parameters["IgnoreDeliveryJsonErrors"] = true;
return(config);
}
private ServiceConfiguration GetRetrieverConfig()
{
var config = new PipelineServiceConfiguration
{
ServiceClass = typeof(RetrieverService).AssemblyQualifiedName,
//ServiceClass = typeof(MyEasyForexBackofficeRetrieverService).AssemblyQualifiedName,
DeliveryID = GetGuidFromString("Facebook"),
TimePeriod = GetTimePeriod(),
Limits = { MaxExecutionTime = new TimeSpan(0, 2, 0, 0) }
};
config.Parameters["IgnoreDeliveryJsonErrors"] = true;
config.Parameters["Facebook.AccessToken"] = FACEBOOK_ACCESS_TOKEN;
return(config);
}
private ServiceConfiguration GetRetrieverConfig()
{
var config = new PipelineServiceConfiguration
{
//ServiceClass = typeof(MyGoogleAdWordsRetrieverService).AssemblyQualifiedName,
ServiceClass = typeof(RetrieverService).AssemblyQualifiedName,
DeliveryID = GetDeliveryId("Adwords"),
TimePeriod = GetTimePeriod(),
Limits = { MaxExecutionTime = new TimeSpan(0, 2, 0, 0) }
};
config.Parameters["IgnoreDeliveryJsonErrors"] = true;
config.Parameters["DeveloperToken"] = "5eCsvAOU06Fs4j5qHWKTCA";
config.Parameters["Adwords.MccEmail"] = ADWORDS_MCC_EMAIL;
config.Parameters["Adwords.ClientID"] = ADWORDS_CLIENT_ID;
return(config);
}
private ServiceConfiguration GetTransformConfig()
{
var config = new PipelineServiceConfiguration
{
ServiceClass = typeof(MetricsTransformService).AssemblyQualifiedName,
DeliveryID = GetGuidFromString("Delivery1"),
MappingConfigPath = @"C:\Development\Edge.bi\Files\temp\Mappings\1006\FtpAdvertising.xml",
};
// TODO shirat - check if should be a part of configuration class and not parameters
config.Parameters["ChecksumTheshold"] = "0.1";
config.Parameters["Sql.TransformCommand"] = "SP_Delivery_Transform_BO_Generic(@DeliveryID:NvarChar,@DeliveryTablePrefix:NvarChar,@MeasuresNamesSQL:NvarChar,@MeasuresFieldNamesSQL:NvarChar,?CommitTableName:NvarChar)";
config.Parameters["Sql.StageCommand"] = "SP_Delivery_Rollback_By_DeliveryOutputID_v291(@DeliveryOutputID:NvarChar,@TableName:NvarChar)";
config.Parameters["Sql.RollbackCommand"] = "SP_Delivery_Stage_BO_Generic(@DeliveryFileName:NvarChar,@CommitTableName:NvarChar,@MeasuresNamesSQL:NvarChar,@MeasuresFieldNamesSQL:NvarChar,@OutputIDsPerSignature:varChar,@DeliveryID:NvarChar)";
config.Parameters["IgnoreDeliveryJsonErrors"] = true;
config.Parameters["IdentityInDebug"] = false;
return(config);
}
private ServiceConfiguration GetTransformConfig()
{
var config = new PipelineServiceConfiguration
{
ServiceClass = typeof(MetricsTransformService).AssemblyQualifiedName,
Limits = { MaxExecutionTime = new TimeSpan(0, 2, 0, 0) },
DeliveryID = GetDeliveryId("Adwords"),
MappingConfigPath = "",
};
// TODO shirat - check if should be a part of configuration class and not parameters
config.Parameters["ChecksumTheshold"] = "0.1";
config.Parameters["Sql.TransformCommand"] = "SP_Delivery_Transform_BO_Generic(@DeliveryID:NvarChar,@DeliveryTablePrefix:NvarChar,@MeasuresNamesSQL:NvarChar,@MeasuresFieldNamesSQL:NvarChar,?CommitTableName:NvarChar)";
config.Parameters["Sql.StageCommand"] = "SP_Delivery_Rollback_By_DeliveryOutputID_v291(@DeliveryOutputID:NvarChar,@TableName:NvarChar)";
config.Parameters["Sql.RollbackCommand"] = "SP_Delivery_Stage_BO_Generic(@DeliveryFileName:NvarChar,@CommitTableName:NvarChar,@MeasuresNamesSQL:NvarChar,@MeasuresFieldNamesSQL:NvarChar,@OutputIDsPerSignature:varChar,@DeliveryID:NvarChar)";
config.Parameters["IgnoreDeliveryJsonErrors"] = true;
config.Parameters["IdentityInDebug"] = true;
return(config);
}
private ServiceConfiguration GetInitializerConfig()
{
var config = new PipelineServiceConfiguration
{
ServiceClass = typeof(InitializerService).AssemblyQualifiedName,
DeliveryID = GetDeliveryId("PayoneerBackoffice"),
TimePeriod = GetTimePeriod(),
Limits = { MaxExecutionTime = new TimeSpan(0, 1, 0, 0) }
};
config.Parameters["IgnoreDeliveryJsonErrors"] = true;
config.Parameters["Sql.RollbackCommand"] = "SP_Delivery_Stage_BO_Generic(@DeliveryFileName:NvarChar,@CommitTableName:NvarChar,@MeasuresNamesSQL:NvarChar,@MeasuresFieldNamesSQL:NvarChar,@OutputIDsPerSignature:varChar,@DeliveryID:NvarChar)";
config.Parameters["Bo.ServiceAdress"] = "https://api.payoneer.com/WebApps/NotificationListener/API.aspx?mname=d2p_sem_statistics&from={0:yyyy-MM-ddTHH:mmZ}&to={1:yyyy-MM-ddTHH:mmZ}&";
config.Parameters["Bo.UTCOffest"] = 0;
config.Parameters["Bo.Xpath"] = "EdgeBI.Metrics/Tracker";
config.Parameters["Bo.IsAttribute"] = true;
config.Parameters["Bo.TrackerIDField"] = "SEM";
return(config);
}
private ServiceConfiguration GetInitializerConfig()
{
var config = new PipelineServiceConfiguration
{
ServiceClass = typeof(InitializerService).AssemblyQualifiedName,
DeliveryID = GetGuidFromString("Facebook"),
TimePeriod = GetTimePeriod(),
Limits = { MaxExecutionTime = new TimeSpan(0, 1, 0, 0) }
};
config.Parameters["IgnoreDeliveryJsonErrors"] = true;
config.Parameters["Sql.RollbackCommand"] = "SP_Delivery_Stage_BO_Generic(@DeliveryFileName:NvarChar,@CommitTableName:NvarChar,@MeasuresNamesSQL:NvarChar,@MeasuresFieldNamesSQL:NvarChar,@OutputIDsPerSignature:varChar,@DeliveryID:NvarChar)";
config.Parameters["Facebook.Account.ID"] = FACEBOOK_ACCOUNT_ID;
config.Parameters["TimeZone"] = "2";
config.Parameters["Offset"] = "0";
config.Parameters["Facebook.BaseServiceAdress"] = "https://graph.facebook.com";
config.Parameters["Facebook.Fields.AdGroupCreative"] = "creative_id,type,title,body,image_hash,link_url,name,run_status,preview_url,count_current_adgroups,id,image_url";
config.Parameters["Facebook.Fields.AdGroup"] = "id,account_id,adgroup_status,bid_info,campaign_id,conversion_specs,creative_ids,impression_control_map,last_updated_by_app_id,locations,name,targeting,tracking_pixel_ids,tracking_specs,updated_time,created_time,ad_status";
config.Parameters["Facebook.Fields.Campaign"] = "id,account_id,name,campaign_status,daily_imps,frequency_cap,frequency_cap_reset_period,start_time,end_time,updated_time,created_time";
config.Parameters["FileDirectory"] = GetTestName();
return(config);
}
private ServiceConfiguration GetInitializerConfig()
{
var config = new PipelineServiceConfiguration
{
ServiceClass = typeof(InitializerService).AssemblyQualifiedName,
DeliveryID = GetDeliveryId("Adwords"),
TimePeriod = GetTimePeriod(),
Limits = { MaxExecutionTime = new TimeSpan(0, 1, 0, 0) }
};
config.Parameters["IgnoreDeliveryJsonErrors"] = true;
config.Parameters["FilterDeleted"] = false;
config.Parameters["KeywordContentId"] = "111";
config.Parameters["Adwords.MccEmail"] = ADWORDS_MCC_EMAIL;
config.Parameters["Adwords.ClientID"] = ADWORDS_CLIENT_ID;
config.Parameters["DeveloperToken"] = "5eCsvAOU06Fs4j5qHWKTCA";
config.Parameters["SubChannelName"] = "sub";
config.Parameters["Sql.RollbackCommand"] = "SP_Delivery_Stage_BO_Generic(@DeliveryFileName:NvarChar,@CommitTableName:NvarChar,@MeasuresNamesSQL:NvarChar,@MeasuresFieldNamesSQL:NvarChar,@OutputIDsPerSignature:varChar,@DeliveryID:NvarChar)";
config.Parameters["Adwords.ReportType"] = "KEYWORDS_PERFORMANCE_REPORT|AD_PERFORMANCE_REPORT|PLACEMENT_PERFORMANCE_REPORT";
config.Parameters["IncludeStatus"] = true;
config.Parameters["includeConversionTypes"] = true;
config.Parameters["includeZeroImpression"] = true;
config.Parameters["includeDisplaytData"] = true;
config.Parameters["Adwords.ReportConfig"] = @"
<GoogleAdwordsReportConfig>
<Report Name='GEO_PERF' Type='GEO_PERFORMANCE_REPORT' Enable='true'>
<Field Name='Date' />
<Field Name='AdGroupId' />
<Field Name='AdGroupName' />
<Field Name='CampaignId' />
<Field Name='CampaignName' />
<Field Name='CountryCriteriaId' />
<Field Name='RegionCriteriaId' />
<Field Name='CityCriteriaId' />
<Field Name='AccountCurrencyCode' />
<Field Name='Ctr' />
<Field Name='Impressions' />
<Field Name='Clicks' />
<Field Name='Cost' />
<Field Name='AveragePosition' />
</Report>
<Report Name='KEYWORDS_PERF' Type='KEYWORDS_PERFORMANCE_REPORT' Enable='true'>
<Field Name='Id' />
<Field Name='AdGroupId' />
<Field Name='CampaignId' />
<Field Name='KeywordText' />
<Field Name='KeywordMatchType' />
<Field Name='Impressions' />
<Field Name='Clicks' />
<Field Name='Cost' />
<Field Name='Status' />
<Field Name='DestinationUrl' />
<Field Name='QualityScore' />
</Report>
<Report Name='KEYWORDS_PERF_Status' Type='KEYWORDS_PERFORMANCE_REPORT' Enable='false'>
<Field Name='Id' />
<Field Name='AdGroupId' />
<Field Name='CampaignId' />
<Field Name='Status' />
</Report>
<Report Name='AD_PERF' Type='AD_PERFORMANCE_REPORT' Enable='true'>
<Field Name='Id' />
<Field Name='Date' />
<Field Name='AdType' />
<Field Name='AdGroupId' />
<Field Name='AdGroupName' />
<Field Name='AdGroupStatus' />
<Field Name='CampaignId' />
<Field Name='CampaignName' />
<Field Name='CampaignStatus' />
<Field Name='Headline' />
<Field Name='Description1' />
<Field Name='Description2' />
<Field Name='KeywordId' />
<Field Name='DisplayUrl' />
<Field Name='CreativeDestinationUrl' />
<Field Name='AccountTimeZoneId' />
<Field Name='AccountCurrencyCode' />
<Field Name='Ctr' />
<Field Name='Status' />
<Field Name='DevicePreference' />
<Field Name='Impressions' />
<Field Name='Clicks' />
<Field Name='Cost' />
<Field Name='AveragePosition' />
<Field Name='Conversions' />
<Field Name='ConversionRate' />
<Field Name='ConversionRateManyPerClick' />
<Field Name='ConversionsManyPerClick' />
<Field Name='ConversionValue' />
<Field Name='TotalConvValue' />
</Report>
<Report Name='AD_PERF_Conv' Type='AD_PERFORMANCE_REPORT' Enable='true'>
<Field Name='Id' />
<Field Name='Date' />
<Field Name='KeywordId' />
<Field Name='ConversionsManyPerClick' />
<Field Name='ConversionCategoryName' />
</Report>
<Report Name='AD_PERF_Status' Type='AD_PERFORMANCE_REPORT' Enable='false'>
<Field Name='Id' />
<Field Name='Status' />
<Field Name='AdGroupId' />
<Field Name='AdGroupName' />
<Field Name='AdGroupStatus' />
<Field Name='CampaignId' />
<Field Name='CampaignName' />
<Field Name='CampaignStatus' />
</Report>
<Report Name='MANAGED_PLAC_PERF' Type='PLACEMENT_PERFORMANCE_REPORT' Enable='true'>
<Field Name='Id' />
<Field Name='AdGroupId' />
<Field Name='CampaignId' />
<Field Name='Status' />
<Field Name='DestinationUrl' />
<Field Name='PlacementUrl' />
<Field Name='Clicks' />
</Report>
<Report Name='MANAGED_PLAC_PERF_Status' Type='PLACEMENT_PERFORMANCE_REPORT' Enable='false'>
<Field Name='Id' />
<Field Name='AdGroupId' />
<Field Name='CampaignId' />
<Field Name='Status' />
</Report>
</GoogleAdwordsReportConfig>
";
return(config);
}
