Загрузка spreadsheets

@serkovsa

Добавляю поток загрузки spreadsheets
Поток сохраняет результат в файл и потом загружает его в базу.

Код потока:

[{"id":"86192602ade34b19","type":"debug","z":"e652a2606a72b12f","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":790,"y":1540,"wires":[]},{"id":"239f5b76f1c9ec3a","type":"luxmsbi-transfer-data","z":"e652a2606a72b12f","name":"","retryCount":1,"retryDelay":5000,"sourceType":"xls","sourceSqlConnIdent":"","sourceSqlQuery":"","sourceXlsFilePath":"file:///tmp/test.xlsx","sourceXlsHeaderRow":"1","sourceXlsFirstDataRow":"2","sourceXlsSheetNumbers":"1","sourceXlsStreamProcessing":false,"sourceXlsDropFileOnComplete":false,"sourceCsvFileEncoding":"utf-8","sourceCsvFilePath":"","sourceCsvWithNames":true,"sourceCsvDelimiter":"comma","sourceCsvZipped":false,"sourceCsvDropFileOnComplete":false,"sourceDbfFileEncoding":"utf-8","sourceDbfFilePath":"","sourceDbfDropFileOnComplete":false,"sourceQvdFilePath":"","sourceQvdDropFileOnComplete":false,"sourceAvroFilePath":"","sourceAvroDropFileOnComplete":false,"sourceParquetFilePath":"","sourceParquetDropFileOnComplete":false,"destinationType":"sql","destinationSqlConnIdent":"luxmsbi","destinationSqlSchemaName":"custom","destinationSqlTableName":"test","destinationSqlMode":"truncate","destinationSqlTryToCast":true,"destinationSqlChunkSize":1000,"destinationCsvWithNames":true,"destinationCsvDelimiter":"comma","destinationCsvZipped":false,"allowed":"sql_sql,sql_csv,xls_sql,csv_sql,dbf_sql,qvd_sql,avro_sql,parquet_sql","x":590,"y":1540,"wires":[["86192602ade34b19"]]},{"id":"66bdeef7e40a6a7b","type":"exec","z":"e652a2606a72b12f","command":"wget \"https://docs.google.com/spreadsheets/d/1ftMvB2zauwfkQis-YLU9oUz2uxbMde9rtDmfJTsK-0U/export?format=xlsx\" -O /tmp/test.xlsx","addpay":"","append":"","useSpawn":"false","timer":"","winHide":false,"oldrc":false,"name":"wget","x":410,"y":1560,"wires":[["239f5b76f1c9ec3a"],[],[]]},{"id":"523e2d0332fba7c7","type":"inject","z":"e652a2606a72b12f","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":240,"y":1560,"wires":[["66bdeef7e40a6a7b"]]}]

Некоторые моменты можно выставить динамично, например имя файла.

Спасибо. Может быть полезно.

Должно на Вашем стенде также отработать.

Угу.

1 лайк