Icon

DATASUS - Download DBC Files

<p>Automated import: .DBC Files (original by: https://forum.knime.com/u/hmfa/summary)</p><p>(https://forum.knime.com/t/automated-download-of-a-series-of-files-from-the-same-server/88326/7?u=mlauber71)</p>

URL: Automated import: .DBC Files https://forum.knime.com/t/automated-download-of-a-series-of-files-from-the-same-server/88326/7?u=mlauber71

Automated import: .DBC Files (original by: https://forum.knime.com/u/hmfa/summary)

(https://forum.knime.com/t/automated-download-of-a-series-of-files-from-the-same-server/88326/7?u=mlauber71)



FTP

host: ftp.datasus.gov.br

WORKING DIR

/dissemin/publicos/SIASUS/200801_/Dados

FOLDERS

D:\\temp\\PA-SIASUS-201701_202503_original\\

Download some small sample. Getting the file information for all 50k files will take too long

Cell Splitter By Position
PathToFilesOriginal
String Manipulation
File_names
String Manipulation
PathToFilesconverted
String Manipulation
next file
Variable Loop End
connect to ftp.datasus.gov.brdefault folder/dissemin/publicos/SIASUS/200801_/DadosYou might get timeout messages if you are outside Brazil
FTP Connector
string to match
Path to String
Start&End Months
Create Date&Time Range
all files todonwload
Table Row to Variable Loop Start
transfer that file
Transfer Files
convertto variable
Table Row to Variable
List files in forlder
List Files/Folders
filter thatfile
Row Filter
TOP 2 files=> remove for production
Top k Row Filter
Files/Folders Meta Info
TOP 2 files=> remove for production
Top k Row Filter
convertto variable
Table Row to Variable
transfer that file
Transfer Files

Nodes

Extensions

Links