{"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],["992ff552-f3e0-4e7b-9b5e-96713c032691",1]],[["77ae2c9b-e222-4935-9238-7d149e170043",2],["9af1d724-baa9-411e-94ed-088128c092ee",1]],[["992ff552-f3e0-4e7b-9b5e-96713c032691",2],["3bd3f78d-ed21-4ce8-9717-0579e7e0fbbe",1]],[["9af1d724-baa9-411e-94ed-088128c092ee",2],["41c0440a-7503-4703-9089-0ac99d07e7e6",2]],[["3bd3f78d-ed21-4ce8-9717-0579e7e0fbbe",2],["bd459008-3685-41d6-8ba7-382b42dbfcf4",3]],[["bd459008-3685-41d6-8ba7-382b42dbfcf4",2],["41c0440a-7503-4703-9089-0ac99d07e7e6",1]],[["82cbdeb1-ed6a-4640-97d9-f8d73f3efc3e",1],["bd459008-3685-41d6-8ba7-382b42dbfcf4",1]]],"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":"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":"ExportExcel","sheet":null,"startCell":null,"columns":["name","price","description","id","editor","modified"],"exportHeader":true,"format":"default","useTemplate":false,"id":"9af1d724-baa9-411e-94ed-088128c092ee","name":"Преобразовать в Excel","description":null,"ports":[{"$type":"tableInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"streamOutputPort","id":2,"tag":null,"direction":"out"}]},{"$type":"entityNode","model":"online_shop","entity":"manager","id":"82cbdeb1-ed6a-4640-97d9-f8d73f3efc3e","name":"Менеджеры","description":null,"ports":[{"$type":"tableOutputPort","id":1,"tag":null,"direction":"out"}]},{"$type":"groupNode","groupBy":[],"aggregates":[{"$type":"groupAggregate","sourceColumnName":"id","targetColumnName":"Количество","aggregator":"ValuesCount"}],"id":"992ff552-f3e0-4e7b-9b5e-96713c032691","name":"Количество вставленных строк","description":"","ports":[{"$type":"tableInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"tableOutputPort","id":2,"tag":null,"direction":"out"}]},{"$type":"singleRowToObjectNode","id":"3bd3f78d-ed21-4ce8-9717-0579e7e0fbbe","name":"Преобразовать в Объект 1","description":null,"ports":[{"$type":"tableInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"valueOutputPort","id":2,"tag":null,"direction":"out"}]},{"$type":"projectionNode","rules":[{"$type":"addCalculatedColumn","formula":"Сцепить('В справочник \"Товары\" было импортировано '; ФП3.Количество; ' строк.')","columnName":"Сообщение"},{"$type":"addCalculatedColumn","formula":"'Импорт справочника Товары'","columnName":"Тема"}],"removeInputColumns":false,"sortRules":[],"id":"bd459008-3685-41d6-8ba7-382b42dbfcf4","name":"Проекция — Формирование темы, сообщения","description":null,"ports":[{"$type":"tableInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"tableOutputPort","id":2,"tag":null,"direction":"out"},{"$type":"parameterInputPort","parameterName":"ФП3","id":3,"tag":null,"direction":"in","parameterId":null}]},{"$type":"sendMailNode","toField":"email","subjField":"Тема","bodyField":"Сообщение","attachments":[{"portId":2,"fileName":"import_result.xlsx"}],"id":"41c0440a-7503-4703-9089-0ac99d07e7e6","name":"Отправка почты","description":null,"ports":[{"$type":"tableInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"streamInputPort","id":2,"tag":null,"direction":"in","parameterId":null}]}]},"layout":{"paperSize":{"width":1200,"height":800},"nodes":{"3d6c346c-143e-4572-949d-90865f837cfd":{"position":{"x":390,"y":100},"size":{"width":150,"height":40}},"73cd75a1-dafa-4a03-adf9-744197861d20":{"position":{"x":390,"y":180},"size":{"width":150,"height":40}},"77ae2c9b-e222-4935-9238-7d149e170043":{"position":{"x":390,"y":260},"size":{"width":150,"height":40}},"9af1d724-baa9-411e-94ed-088128c092ee":{"position":{"x":580,"y":420},"size":{"width":150,"height":40}},"82cbdeb1-ed6a-4640-97d9-f8d73f3efc3e":{"position":{"x":200,"y":410},"size":{"width":140,"height":40}},"992ff552-f3e0-4e7b-9b5e-96713c032691":{"position":{"x":370,"y":340},"size":{"width":190,"height":40}},"3bd3f78d-ed21-4ce8-9717-0579e7e0fbbe":{"position":{"x":390,"y":420},"size":{"width":150,"height":40}},"bd459008-3685-41d6-8ba7-382b42dbfcf4":{"position":{"x":200,"y":510},"size":{"width":270,"height":40}},"41c0440a-7503-4703-9089-0ac99d07e7e6":{"position":{"x":400,"y":610},"size":{"width":150,"height":40}}},"links":{"77ae2c9b-e222-4935-9238-7d149e170043:2#9af1d724-baa9-411e-94ed-088128c092ee:1":{"vertices":[{"x":590,"y":330}]}}}}