{"formatVersion":1,"graph":{"connections":[[["3d6c346c-143e-4572-949d-90865f837cfd",1],["73cd75a1-dafa-4a03-adf9-744197861d20",1]],[["73cd75a1-dafa-4a03-adf9-744197861d20",2],["77ae2c9b-e222-4935-9238-7d149e170043",1]],[["77ae2c9b-e222-4935-9238-7d149e170043",2],["b71f0216-58a9-4679-8abf-3c2ef6da9092",1]],[["b71f0216-58a9-4679-8abf-3c2ef6da9092",2],["c2d7f72e-d4c2-41cb-acd0-35d39a2160b0",1]],[["945f557c-9d1c-49b6-b3d2-4d6f4dad6b64",1],["c2d7f72e-d4c2-41cb-acd0-35d39a2160b0",2]]],"nodes":[{"$type":"loadFileNode","filePath":"C:\\users\\ivanov_ii\\etl_files\\Товары.xlsx","id":"3d6c346c-143e-4572-949d-90865f837cfd","name":"Файл Товары.xlsx","description":null,"ports":[{"$type":"streamOutputPort","id":1,"tag":null,"direction":"out"}]},{"$type":"importExcel","sheetNumber":1,"range":null,"hasHeaders":true,"skipErroneousRows":false,"id":"73cd75a1-dafa-4a03-adf9-744197861d20","name":"Преобразовать из Excel","description":null,"ports":[{"$type":"streamInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"tableOutputPort","id":2,"tag":"main","direction":"out"}]},{"$type":"exportCsvNode","columns":["name","description","price","id","editor","modified"],"separator":",","quoteCharacter":"\"","nullString":null,"exportHeader":true,"id":"b71f0216-58a9-4679-8abf-3c2ef6da9092","name":"Преобразовать в CSV","description":null,"ports":[{"$type":"tableInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"streamOutputPort","id":2,"tag":null,"direction":"out"}]},{"$type":"entityInsertNode","columns":[{"sourceColumn":"Товар","targetColumn":"name"},{"sourceColumn":"Цена, ₽/кг","targetColumn":"price"}],"model":"online_shop","entity":"product","id":"77ae2c9b-e222-4935-9238-7d149e170043","name":"Вставка строк Колибри","description":null,"ports":[{"$type":"tableInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"tableOutputPort","id":2,"tag":"inserted","direction":"out"}]},{"$type":"processNode","processId":"ba48ed3e-1627-4ee6-9c26-4d5e1097d68e","portMap":{"1":"56c8144c-fac8-447c-99da-e97f4e0bc468","2":"4f74a08d-d38d-4857-a6ba-b33578e383f3"},"id":"c2d7f72e-d4c2-41cb-acd0-35d39a2160b0","name":"Подпроцесс \"Отправка почты\"","description":null,"ports":[{"$type":"streamInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"valueInputPort","id":2,"tag":null,"direction":"in","parameterId":null}]},{"$type":"formulaNode","formula":"'Товары'","id":"945f557c-9d1c-49b6-b3d2-4d6f4dad6b64","name":"Формула: название импортируемого справочника","description":null,"ports":[{"$type":"valueOutputPort","id":1,"tag":null,"direction":"out"}]}]},"layout":{"paperSize":{},"nodes":{"3d6c346c-143e-4572-949d-90865f837cfd":{"position":{"x":240,"y":30},"size":{"width":150,"height":40}},"73cd75a1-dafa-4a03-adf9-744197861d20":{"position":{"x":240,"y":110},"size":{"width":150,"height":40}},"77ae2c9b-e222-4935-9238-7d149e170043":{"position":{"x":240,"y":190},"size":{"width":150,"height":40}},"b71f0216-58a9-4679-8abf-3c2ef6da9092":{"position":{"x":240,"y":270},"size":{"width":150,"height":40}},"c2d7f72e-d4c2-41cb-acd0-35d39a2160b0":{"position":{"x":220,"y":370},"size":{"width":200,"height":40}},"945f557c-9d1c-49b6-b3d2-4d6f4dad6b64":{"position":{"x":440,"y":270},"size":{"width":280,"height":40}}},"links":{}}}