Many duzzits can take input information from a file, either uploaded directly by a user or pulled via FTP. For example, let’s say we have a duzzit that creates contact information:
As there is an “Upload a file to process…” link, we have the option of uploading a file or configuring FTP. Clicking on this link results in this popup:
Let’s say we want to upload a file. Once we choose a file (click “Choose File”, choose a file from your local system, upload it, and click on “Next”), itDuzzit analyzes the file, suggests matches (file columns and duzzit inputs), and displays a mapping screen:
Once mappings are adjusted as desired, clicking on “Finish Upload” results in this screen:
Now the duzzit can be run for each row in the uploaded file.
Alternately, you can configure itDuzzit to FTP a file to process on a periodic basis by providing FTP information.
The “Working Directory” field indicates which directory on the site contains the files that you want to process. If your ftp login places you directly in the directory containing your files, leave this blank. Otherwise, enter the directory path relative to the ftp login directory.
The “Filename or Pattern” field is where you indicate what file or files to pull. If you always will be processing one specific file, enter that filename and leave the “Process all files that match the filename pattern” checkbox unchecked. If you need to process multiple files, check this checkbox, and enter a regular expression pattern for matching the files. If you don’t know what a regular expression is, just try using “.*” as a wildcard. So, say you want to match all files that start with “Customer” and end with “csv”. (“Customer-1.csv”, “Customer-2.csv”, etc). To match this, you could enter “Customer.*csv” (without the quotes).
The “Rename the file when completed” checkbox offers a rudimentary strategy to avoid repeatedly processing the same file. If checked, itDuzzit will attempt to rename every file it pulls from the ftp site by appending “.complete” to the file name. Note that in order for this to work, the ftp account that itDuzzit is using will need authority to modify files on the ftp site.
FTP credentials (user and password for the ftp site) can be provided in two ways. First, you can fill in these fields when scheduling duzzit execution. Second, you can setup a custom connection for the ftp site. To do this, go to the connection page:
To add a custom ftp connection, click “Add a Custom Account Connection”:
When you save the ftp information, you’ll see the custom connection in your list of connectors:
Now, all you need to do is make sure that the site url (in this case ftp.example.com) is what you specify on the FTP configuration screen for your duzzit.
After specifying the FTP settings, itDuzzit will pull the file you’re configuring as a sample for configuring mappings. This screen flow is similar to uploading a file, but at the end of this process, instead of processing right away, typically you would schedule the duzzit to run in the future. When scheduled, every time the duzzit is run, it will FTP the file and run the duzzit for each row in the file(s).
