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); }