{"type":"doc","content":[{"type":"heading","attrs":{"level":1},"content":[{"text":"Special Features","type":"text"}]},{"type":"paragraph","content":[{"text":"Please see these ","type":"text"},{"text":"notes","type":"text","marks":[{"type":"link","attrs":{"href":"https://pricefx.atlassian.net/wiki/spaces/LEARN/pages/2220032444"}}]},{"text":" (Pricefx staff only).","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Properties","type":"text"}]},{"type":"table","attrs":{"layout":"full-width","width":1296.0,"localId":"c32d2c5e-219c-4e47-9eee-06fb2dd12d03"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[245.0]},"content":[{"type":"paragraph","content":[{"text":"Option","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Type","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[120.0]},"content":[{"type":"paragraph","content":[{"text":"Default","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[822.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[245.0]},"content":[{"type":"paragraph","content":[{"text":"outputTarget","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[120.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[822.0]},"content":[{"type":"paragraph","content":[{"text":"For asynchronous evaluation sets how often the job status will be checked (in milliseconds).","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[245.0]},"content":[{"type":"paragraph","content":[{"text":"outputTargetName","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[120.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[822.0]},"content":[{"type":"paragraph","content":[{"text":"Sets a timeout for asynchronous evaluation (in milliseconds).","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[245.0]},"content":[{"type":"paragraph","content":[{"text":"connection","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[120.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[822.0]},"content":[{"type":"paragraph","content":[{"text":"Defines a connection to Pricefx.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[245.0]},"content":[{"type":"paragraph","content":[{"text":"dsUniqueName","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[120.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[822.0]},"content":[{"type":"paragraph","content":[{"text":"Defines the Data Source name. ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[245.0]},"content":[{"type":"paragraph","content":[{"text":"objectType","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[120.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[822.0]},"content":[{"type":"paragraph","content":[{"text":"Defines the type of the object.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[245.0]},"content":[{"type":"paragraph","content":[{"text":"targetName","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[120.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[822.0]},"content":[{"type":"paragraph","content":[{"text":"Defines the name in the Pricefx system. If left empty, the name is calculated from the input data.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[245.0]},"content":[{"type":"paragraph","content":[{"text":"fileName","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[120.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[822.0]},"content":[{"type":"paragraph","content":[{"text":"Sets the desired name of the local staging file. Can be left empty. If so, the name is concatenated from the input data.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[245.0]},"content":[{"type":"paragraph","content":[{"text":"truncate","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Boolean","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[120.0]},"content":[{"type":"paragraph","content":[{"text":"false","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[822.0]},"content":[{"type":"paragraph","content":[{"text":"Determines whether to ‘truncate’.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[245.0]},"content":[{"type":"paragraph","content":[{"text":"deDuplicate","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Boolean","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[120.0]},"content":[{"type":"paragraph","content":[{"text":"true","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[822.0]},"content":[{"type":"paragraph","content":[{"text":"Determines whether to ‘deDuplicate’.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[245.0]},"content":[{"type":"paragraph","content":[{"text":"mapper","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[120.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[822.0]},"content":[{"type":"paragraph","content":[{"text":"Defines a mapper which is used to map incoming data.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[245.0]},"content":[{"type":"paragraph","content":[{"text":"delimiter","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"char","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[120.0]},"content":[{"type":"paragraph","content":[{"text":",","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[822.0]},"content":[{"type":"paragraph","content":[{"text":"Defines input delimiter.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[245.0]},"content":[{"type":"paragraph","content":[{"text":"quoteChar","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"char","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[120.0]},"content":[{"type":"paragraph","content":[{"text":"'","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[822.0]},"content":[{"type":"paragraph","content":[{"text":"Defines input quote character.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[245.0]},"content":[{"type":"paragraph","content":[{"text":"escapeChar","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"char","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[120.0]},"content":[{"type":"paragraph","content":[{"text":"''","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[822.0]},"content":[{"type":"paragraph","content":[{"text":"Defines input escape character.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[245.0]},"content":[{"type":"paragraph","content":[{"text":"nullValue","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"char","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[120.0]},"content":[{"type":"paragraph","content":[{"text":"(empty string)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[822.0]},"content":[{"type":"paragraph","content":[{"text":"Defines input null string.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[245.0]},"content":[{"type":"paragraph","content":[{"text":"eol","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"char","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[120.0]},"content":[{"type":"paragraph","content":[{"text":"/r/n","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[822.0]},"content":[{"type":"paragraph","content":[{"text":"Defines input record separator.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[245.0]},"content":[{"type":"paragraph","content":[{"text":"headers","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[120.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[822.0]},"content":[{"type":"paragraph","content":[{"text":"List separated by a comma.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[245.0]},"content":[{"type":"paragraph","content":[{"text":"stagingFile","type":"text","marks":[{"type":"code"}]},{"text":" (since 4.7.0) ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[120.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[822.0]},"content":[{"type":"paragraph","content":[{"text":"Defines a staging file used for the import command. The staging file must be a valid CSV file which can be processed by the Pricefx core and must be in the GZIP format.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[245.0]},"content":[{"type":"paragraph","content":[{"text":"deleteStagingFileAfterImport","type":"text","marks":[{"type":"code"}]},{"text":" (since 4.7.0)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Boolean","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[120.0]},"content":[{"type":"paragraph","content":[{"text":"true","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[822.0]},"content":[{"type":"paragraph","content":[{"text":"Defines if a staging file provided as a parameter should be deleted after import.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[245.0]},"content":[{"type":"paragraph","content":[{"text":"skipIndexing","type":"text","marks":[{"type":"code"}]},{"text":" (since 4.10.0)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[109.0]},"content":[{"type":"paragraph","content":[{"text":"Boolean","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[120.0]},"content":[{"type":"paragraph","content":[{"text":"false","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[822.0]},"content":[{"type":"paragraph","content":[{"text":"Defines if indexing should be skipped after import.","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Examples","type":"text"}]},{"type":"paragraph","content":[{"text":"This route shows how to use raw CSV data which requires mapping and compression into the GZIP format.","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n \n \n \n","type":"text"}]},{"type":"paragraph","content":[{"text":"The next two examples show how to use import without the need to modify input data into the required format. It means that the input is already a CSV file in GZIP format which can be sent to Pricefx. In such case, you do not define the mapper parameter but instead you provide input data as a file in the body or you set the ","type":"text"},{"text":"stagingFile","type":"text","marks":[{"type":"code"}]},{"text":" parameter and define path to the file.","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"// this route will read file from data.directory. File must be valid csv.gzip\n\n \n \n","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"// this route will read file from staging-file path. File must be valid csv.gzip\n\n \n \n","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Full Process Example","type":"text"}]},{"type":"paragraph","content":[{"text":"We have a data file ","type":"text"},{"text":"price_fx_calc_art_with_header_and_date_and_null_values_and_quoted.csv","type":"text","marks":[{"type":"em"}]},{"text":" in a custom format:","type":"text"}]},{"type":"codeBlock","content":[{"text":"date|country|subsidiary|sku|elasticity\n2021-03-15|DE|MM|'49100|0,015'|-1.0000\nNULL|NULL|NULL|NULL|NULL\n|DE|MM|491001545|-1.0000\n2021-03-15|DE|MM|491002042|-1.0000\n'2021-03-15'|DE|MM|491002237|-1.0000\n2021-03-15|DE|MM|491002293|-1.0000\n2021-03-15|DE|MM|491003012|-1.0000\n2021-03-15|DE|MM|491003245|-1.0000\n2021-03-15|DE|MM|491003391|-1.0000\n2021-03-15|DE|MM|491003818|-3.2709\n2021-03-15|DE|MM|491003821|-1.0000\n2021-03-15|DE|MM|491003823|-1.0000","type":"text"}]},{"type":"paragraph","content":[{"text":"Route:","type":"text"}]},{"type":"codeBlock","content":[{"text":"\n \n \n Transaction\n \n \n \n","type":"text"}]},{"type":"paragraph","content":[{"text":"Mapper:","type":"text"}]},{"type":"codeBlock","content":[{"text":"\n \n \n","type":"text"}]},{"type":"paragraph","content":[{"text":"The staged file is created (format according to internal Pricefx requirements ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://pricefx.atlassian.net/wiki/spaces/EN/pages/2808709224"}},{"text":"):","type":"text"}]},{"type":"codeBlock","content":[{"text":"sku,label\n491000015,2021-03-15\n491000019,2021-03-15\n491001545,2021-03-15\n491002042,2021-03-15\n491002237,2021-03-15\n491002293,2021-03-15\n491003012,2021-03-15\n491003245,2021-03-15\n491003391,2021-03-15\n491003818,2021-03-15\n491003821,2021-03-15\n491003823,2021-03-15","type":"text"}]},{"type":"paragraph","content":[{"text":"The data will be loaded into Pricefx.","type":"text"}]}],"version":1}

Browser not supported