{"formatVersion":1,"graph":{"connections":[[["0daa7abd-1ded-4d53-8b13-0871828be3f4",2],["8df4a332-b98b-42a4-a773-dd44f4a6d94a",1]],[["8df4a332-b98b-42a4-a773-dd44f4a6d94a",2],["e4b1492b-34ef-41ec-8b94-3b451bde14a7",1]],[["6a286557-03fd-48c9-9f2a-703f09bf469c",1],["e4b1492b-34ef-41ec-8b94-3b451bde14a7",3]]],"nodes":[{"$type":"importExcel","sheetNumber":1,"range":null,"hasHeaders":false,"skipErroneousRows":false,"id":"0daa7abd-1ded-4d53-8b13-0871828be3f4","name":"Преобразовать из Excel","description":null,"ports":[{"$type":"streamInputPort","id":1,"tag":null,"direction":"in","parameterId":"5df7f317-ecd0-4960-8171-1f013a5974dd"},{"$type":"tableOutputPort","id":2,"tag":"main","direction":"out"}]},{"$type":"formulaNode","formula":"имя_вход_файла := [Входящий Excel].Имя\r\nпуть := '\\\\tarasova_en\\shared\\etl_test\\0403\\'\r\n\r\nЕсли Оканчивается(имя_вход_файла; '.xlsx') То\r\n    путь || Заменить(имя_вход_файла; '.xlsx'; '.csv')\r\nИначеЕсли Оканчивается(имя_вход_файла; '.xls') То\r\n    путь || Заменить(имя_вход_файла; '.xls'; '.csv')\r\nИначе\r\n    путь || имя_вход_файла || '.csv'\r\nКонецЕсли","id":"6a286557-03fd-48c9-9f2a-703f09bf469c","name":"Имя и путь до файла CSV","description":null,"ports":[{"$type":"valueOutputPort","id":1,"tag":null,"direction":"out"}]},{"$type":"exportCsvNode","columns":null,"separator":",","quoteCharacter":"\"","nullString":null,"exportHeader":false,"id":"8df4a332-b98b-42a4-a773-dd44f4a6d94a","name":"Преобразовать в CSV 1","description":null,"ports":[{"$type":"tableInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"streamOutputPort","id":2,"tag":null,"direction":"out"}]},{"$type":"saveFileNode","filePath":null,"id":"e4b1492b-34ef-41ec-8b94-3b451bde14a7","name":"Запись в файл 1","description":null,"ports":[{"$type":"streamInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"streamOutputPort","id":2,"tag":null,"direction":"out"},{"$type":"propertyInputPort","propertyName":"filePath","id":3,"tag":null,"direction":"in","parameterId":null}]}]},"layout":{"paperSize":{},"nodes":{"6a286557-03fd-48c9-9f2a-703f09bf469c":{"position":{"x":430,"y":50},"size":{"width":150,"height":40}},"8df4a332-b98b-42a4-a773-dd44f4a6d94a":{"position":{"x":200,"y":150},"size":{"width":150,"height":40}},"e4b1492b-34ef-41ec-8b94-3b451bde14a7":{"position":{"x":200,"y":250},"size":{"width":150,"height":40}},"0daa7abd-1ded-4d53-8b13-0871828be3f4":{"position":{"x":197,"y":58},"size":{"width":150,"height":40}}},"links":{}},"params":[{"id":"5df7f317-ecd0-4960-8171-1f013a5974dd","caption":"Входящий Excel","value":"Пусто","text":"не указано","visual":true,"multiple":false,"datatype":"file"}]}