Skip to main content

Example JSON Config For Append Module

DesignKeyProcessing

  "DesignKeyProcessing": {
"CLUSTER_FIELD_NAME": Comma Seperated List of fields that are clustered to identify offers,
"JOIN_FIELD_NAME": Name of field that is joined together accross the rows identified by the CLUSTER_FIELDS ,
"JOIN_FIELD_TYPE": Either NUMBER or STRING ,
"DESIGN_KEY_FIELD_NAME": Name of Column that value of hashed join field name will be placed in
}
{
"NewOfferIDProcessing": {
"OFFER_ID_HIERARCHY": {
"PRODUCT_FAMILY_FIELD": "Código de Producto CUC",
"ITEM_CODE_FIELD": "Código de Producto SAP",
"CLUSTER_FIELD": "WORKING_PAGE",
"SETID_FIELD": "SET",
"OFFER_TYPE_FIELD": "OFFER_TYPE",
"PAGE_SECTION_FIELD": "PAGE_SPLIT_TYPE",
"COMPANION_ITEM_OFFER_TYPE": "TO300,TO301,TO324",
"OFFER_ID_FIELD": "NUMERO OFERTA",
"COUNTRY_NAME_FIELD": "COUNTRY_CODE",
"GROUPING_FIELD": "COUNTRY_CODE",
"PRODUCT_DESCRIPTION_FIELD": "PRODUCTO SAP"
},
"PLANIT_EVOLUTION_INPUT_OUTPUT_HEADERS": {
"offerID": "NUMERO_OFERTA",
"groupNumber": "NUMERO_GRUPO",
"groupType": "TIPO_GRUPO",
"units": "UNIDADES",
"isCompanionItem": "COMPANION_ITEM"
}
},
"GENERAL_CONFIGS": {
"DOCS": "https://docs.decasim.com/docs/configurations/introduction",
"OFFER_DETAIL_FIELD_NAME": "OFFER_DETAIL",
"OFFER_DATA_APPEND_FIELDS": "Producto SAP,Código de Producto CUC,Código de Producto SAP,Código BPCS,Precio Normal,Precio SE,PARTICIPATION,FORECAST_PMNP,FORECAST_PUP",
"ASSOCIATED_ITEM_LOOKUP_FIELD": "Código de Producto SAP",
"PRODUCT_DATABASE_ITEM_CODE_KEY": "Código de Producto SAP",
"PRODUCT_DATABASE_ITEM_DESCRIPTION_KEY": "Producto SAP",
"PRODUCT_DATABASE_ITEM_PRODUCT_FAMILY_KEY": "Producto CUC",
"PRODUCT_DATABASE_ITEM_PRODUCT_FAMILY_CODE": "Código de Producto CUC",
"PRODUCT_CODE_APPEND_FIELDS": "Código de Producto CUC,Código de Producto SAP,Código BPCS",
"PRODUCT_DATABASE_GROUP_BY_FIELD": "PAIS",
"PRODUCT_DATABASE_SEARCH_TYPES": "ITEM_DESC,PRODUCT_FAMILY_DESC",
"OFFER_ID_REQUIRED_RULE_COUNT": "8",
"USE_REFACTORED_OFFER_ID": "True",
"UNPARSED_ROWS": "true",
"CUSTOMER_PROMO_FILE_FOLDER": "/Users/dougedmonds/IdeaProjects/decasim-excel/src/main/resources/output/",
"USE_DEFAULT_PRICE_SOURCE": "True",
"ROLL_BACK_CANDIDATE_VALUE": "GENESIS",
"ROLL_BACK_DEFAULT_VALUE": "BD",
"MISSING_DATA_DEFAULT_VALUE": "-",
"CUSTOMER_DEFINED_PAGE_START": "WORKING_PAGE_FROM",
"CUSTOMER_DEFINED_PAGE_END": "WORKING_PAGE_TO",
"BULK_APPEND_FLAG": "false",
"OUTPUT_OPTIONAL_LOGS": "false",
"USE_LOGGER": "true",
"DESIGN_FILE_TYPE_FOR_EQUIVALENCE_FILE_TYPE": "EQUIVALENCES_DATA",
"DESIGN_FILE_TYPE_FOR_PERFORMANCE_DATA_SEARCH": "HISTORIC_PERFORMANCE_DATA",
"DESIGN_FILE_TYPE_FOR_HISTORICAL_SEARCH": "Historic_Pages_File",
"DESIGN_FILE_TYPE_FOR_ITEM_PROPERTIES_SEARCH": "Maestro_File",
"DESIGN_FILE_TYPE_FOR_ITEM_TONO_SEARCH": "TONES_AND_SHADES_File",
"PRODUCT_HIERARCHY_FILE": "{DESIGN_FILE_NAME_IN_APP}"
},
"LOGGING_CONFIGS": {
"OFFER_DATA_APPEND_LOGGING": "False",
"PRODUCT_DATA_APPEND_LOGGING": "True",
"PROMO_FILE_SEARCH_LOGGING": "True"
},
"MatchKeyOverrideField": {
"CONDITION_FIELD": "CATEGORY",
"CONDITION_VALUE": "MAQUILLAJE",
"SEARCH_FIELD": "PRODUCTO CUC"
},
"SourceFileName": {
"1": {
"FILE_SOURCE_PREFIX": "0"
},
"2": {
"COUNTRY_CODE": "0"
},
"3": {
"FILE_SOURCE_PREFIX": "1"
},
"4": {
"FILE_SOURCE_PREFIX": "2"
},
"5": {
"SOURCE_TYPE": "0"
}
},
"ProductCodeFileName": {
"1": {
"FILE_SOURCE_PREFIX": "0"
},
"2": {
"COUNTRY_CODE": "0"
},
"3": {
"FILE_SOURCE_PREFIX": "1"
},
"4": {
"FILE_SOURCE_PREFIX": "2"
},
"5": {
"SOURCE_TYPE": "0"
}
},
"OfferIDProcessing": {
"JOIN_FIELD_NAME": "SET,OFFER_TYPE,COUNTRY_CODE,COUNTRY_PAGE",
"BACK_UP_JOIN_FIELD_NAME": "Producto SAP,OFFER_TYPE,COUNTRY_CODE,COUNTRY_PAGE",
"OFFER_KEY_FIELD_NAME": "CORRELATIVO",
"ITEMS_IN_OFFER_FIELD": "SKU_COUNT"
},
"HISTORIC_PERFORMANCE_DATA": {
"LABEL": {
"PREFIX": "ACTUAL"
},
"MatchKeyFields": {
"CÓDIGO DE PRODUCTO CUC": "Código CUC-SAP"
},
"FilterFields": {
"COUNTRY_CODE": "Código de País",
"OFFER_TYPE": "TipoOferta"
},
"PrimaryFilterField": {
"CAMPAIGN": "Campaña (YYYYCC)"
},
"APPEND_FIELDS": {
"PMNP": {
"TYPE": "MEDIAN"
},
"PUP": {
"TYPE": "MEDIAN"
}
}
},
"EquivalenceFile": {
"PARENT_ITEM_KEY_FIELD": "Código de Producto SAP",
"PARENT_ITEM_FAMILY_FIELD": "Código de Producto CUC",
"CHILD_ITEM_KEY_FIELD": "CONNECTED Código de Producto SAP",
"CHILD_ITEM_FAMILY_FIELD": "CONNECTED Código de Producto CUC"
},
"EntityMapping": {
"COUNTRY_CODE": {
"CO": "COLOMBIA",
"CR": "COSTA RICA",
"EC": "ECUADOR",
"RD": "REPUBLICA DOMINICANA",
"DO": "REPUBLICA DOMINICANA",
"BO": "BOLIVIA",
"CL": "CHILE",
"MX": "MEXICO",
"PA": "PANAMA",
"PR": "PUERTO RICO",
"US": "UNITED STATES",
"GT": "GUATEMALA",
"PE": "PERU",
"SV": "EL SALVADOR"
}
},
"JoinFields": {
"APPEND_FIELD": "ELEMENT_PROPERTIES",
"JOIN_FIELDS": "Precio Set Normal,Precio Set Oferta,PUM",
"JOIN_CHARACTER": "\\"
},
"HistoricAppend": {
"SEARCH_FIELD": {
"ESPECIFICATIONS": "ESPECIFICATIONS"
},
"APPEND_FIELDS": "CÓDIGO DE PRODUCTO SAP,NOMBRE_ARTICULO,CORRELATIVO,CÓDIGO DE PRODUCTO CUC,DamSource,PUM,PRODUCTO SAP,NOMBRE_ELEMENTO,NOMBRE_LINEA,NOMBRE_FANTASIA,PRECIO NORMAL,PRECIO SE,ELEMENT_PROPERTIES,RASTERFIELD"
},
"DesignAppend": {
"SEARCH_FIELD": {
"CÓDIGO DE PRODUCTO SAP": "CÓDIGO DE PRODUCTO SAP"
},
"APPEND_FIELDS": "NOMBRE_LINEA,NOMBRE_FANTASIA,NOMBRE_ELEMENTO,CAPACIDAD",
"FILTER_FIELD": {
"COUNTRY_CODE": "PAIS"
}
},
"TonesAndShades": {
"SEARCH_FIELD": {
"CÓDIGO DE PRODUCTO SAP": "CÓDIGO DE PRODUCTO SAP"
},
"APPEND_FIELDS": "Priority,Image_Size",
"FILTER_FIELD": {
"COUNTRY_CODE": "COUNTRY_CODE"
}
},
"SecondaryKeyFields": {
"SECONDARY_KEY": "ELEMENT_KEY"
},
"SecondaryKeyCount": {
"PRECIO SET OFERTA": "Precio SE",
"PRECIO SET NORMAL": "Precio Normal"
},
"SecondaryKeyAverage": {
"PRECIO SET SE AVG": "Precio SE",
"PRECIO SET N AVG": "Precio Normal"
},
"Prefixes": {
"WP_RasterField_Max": "ANY=",
"WP_Section_RasterField_Max": "ANY=",
"Section_Max": "ANY=",
"PAGE_LAYOUT_TEMPLATE": "DOUBLE="
},
"CalculateMax": {
"WP_RasterField_Max": {
"SOURCE_FIELD": "RasterField",
"CLUSTER_FIELDS": "WORKING_PAGE"
},
"WP_Section_RasterField_Max": {
"SOURCE_FIELD": "RasterField",
"CLUSTER_FIELDS": "WORKING_PAGE,PAGE_SPLIT_TYPE"
},
"Section_Max": {
"SOURCE_FIELD": "PAGE_SPLIT_TYPE",
"CLUSTER_FIELDS": "WORKING_PAGE"
},
"PAGE_LAYOUT_TEMPLATE": {
"SOURCE_FIELD": "RasterField",
"CLUSTER_FIELDS": "WORKING_PAGE"
}
},
"AssignBlockIndex": {
"CLUSTER_FIELD_NAME": "COUNTRY_CODE,COUNTRY_PAGE",
"FIELD_TO_INDEX": "CORRELATIVO",
"BLOCK_FIELD_NAME": "RasterField"
},
"PromoKeyProcessing": {
"CLUSTER_FIELD_NAME": "WORKING_PAGE",
"JOIN_FIELD_NAME": "CÓDIGO DE PRODUCTO SAP",
"JOIN_FIELD_TYPE": "NUMBER",
"PROMO_KEY_FIELD_NAME": "ELEMENT_KEY"
},
"DesignKeyProcessing": {
"CLUSTER_FIELD_NAME": "WORKING_PAGE,COUNTRY_CODE,PAGE_SPLIT_TYPE,NUMERO_OFERTA",
"JOIN_FIELD_NAME": "Código de Producto SAP",
"JOIN_FIELD_TYPE": "NUMBER",
"DESIGN_KEY_FIELD_NAME": "OFFER_HASH"
},
"PageReferenceProcessing": {
"CLUSTER_FIELD_NAME": "COUNTRY_CODE",
"COUNT_BY_FIELD": "WORKING_PAGE",
"PAGE_REFERENCE_FIELD_NAME": "COUNTRY_PAGE",
"PRIMARY_PAGE_FIELD_NAME": "PRIMARY_PAGE"
},
"PostProcessing": {
"HumanReadableReference": {
"TYPE": "SOURCE_FILE_NAME_EXTRACTOR",
"PARAMETERS": {
"1": {
"FILE_SOURCE_PREFIX": "0"
},
"2": {
"COUNTRY_CODE": "0"
},
"3": {
"FILE_SOURCE_PREFIX": "1"
},
"4": {
"FILE_SOURCE_PREFIX": "2"
},
"5": {
"USE_VALUE": "PAG"
},
"6": {
"COUNTRY_PAGE": "0"
}
}
}
},
"ValidationPolicy": {
"DISCOUNT": {
"TYPE": "RATIO_MINIMUM",
"PARAMETERS": "Precio SE,Precio Normal,0.6"
},
"OFFER TYPE VALUE": {
"TYPE": "IN_SET",
"PARAMETERS": "OFFER_TYPE=TO300,TO303,TO301,TO309,TO310,TO311,TO319,TO320,TO321,TO322,TO323,TO324,TO329,TO330,TO331,TO332,TO333,TO334,TO034,TO024"
}
}
}