Automatic Import Step 4 WHERE
During this step we will be able to set from where we would like to import the file, what format and format specifics:
Import file from FTP:
Import File From URL:
Import Excel File Format:
Import CSV File Format:
Please note all fields are listed below but there are dependent fields which are displayed only in certain cases explained in comment column.
Field Name | Field Type | Field Values | Required | Comment | |
---|---|---|---|---|---|
1 | Automatic Import Name | Text Field | Free input | Yes | |
4 | Storage Type: | ||||
Radio button | 1.FTP | ||||
2.URL | Yes | ||||
5 | FTP Type | Radio button | 1.FTP |
2.SFTP 3.SSLFTP | No | Visible if Storage Type = FTP | | 6 | FTP Host | Text Field | Free input | No | Visible if Storage Type = FTP | | 7 | FTP Username | Text Field | Free input | No | Visible if Storage Type = FTP | | 8 | FTP Password | Password (new type) | Free input | No | Visible if Storage Type = FTP | | 9 | FTP Port | Text Field | Free input | No | Visible if Storage Type = FTP | | 10 | URL | Text Field | Free input | No | Visible if Storage Type = URL | | 11 | Import Format | Radio button | 1.Excel (.xlsx) 2.CSV (.csv) 3.Text (txt) | Yes | | | 12 | File Delimiter | Text Field | Free input | No | Visible if Import Format = CSV | | 13 | Enclosing Character | Text Field | Free input | No | Visible if Import Format = CSV | | 14 | Escaping Character | Text Field | Free input | No | Visible if Import Format = CSV | | 15 | Line End Character | Text Field | Free input | No | Visible if Import Format = CSV | | 16 | Path / File Name | Text Field | Free input | No | | | 17 | File Process Operation | Radio button | 1.Rename/Move 2.Delete | No | | | 18 | New Path / File Name | Text Field | Free input | No | Visible if File Process Operation = Rename/Move |