File Builder FTP 3.X Video Tutorial

[jason_petty]

The 3.x version of this tool that I just posted to ShareNow has a number of new features that have been asked for by the community.   I have also created a video tutorial on this version found at the following locations:

File Builder FTP 3.X Version Video Tutorial

File Builder FTP 3.x Video Tutorial - YouTube

Version 3.X has a number of new features:

1. There is an option to choose Tab as a delimiter on the File Definition now.

2. There was code put in to terminate SFTP connection after it is used.

3. Added some more descriptive tool tips on the MID Server path and FTP file path to be more clear.

4. Fixed a couple of issues with XML creation:

      a. Field names that start with a number get an "x" put in front of it when the XML node is created.

      b. File names that start with a number get an "x" put in front of it when the XML node is created.

      c. File names with spaces in it will have spaces replaced with a "_" when the XML node is created.

5. Created two new UI Actions on the File Definitions form:

      a. "Auto-Populate All Fields (Labels)" — This will read the source table's fields from ServiceNow and create fields in your File Definition using the ServiceNow Field Labels as the Field Name.

              i. If any of the field names have a "/" in it, it will be replaced by a "-".

              ii. If any of the field names have a space in it, it will be replaced by a "_".

      b. "Auto-Populate All Fields (DB Field Name)" — This will read the source table's fields from ServiceNow and create fields in your File Definition using the ServiceNow Field Names as the Field Name.

6. All the fields that you create have another option named "Value Type". There are three possible values: "Value", "DisplayValue", and "Hardcoded".

      a. Value — Raw value. So if it is a reference field, it will get the sys_id.

      b. DisplayValue — Will get the display value of the field.

      c. Hardcoded — If you want just a raw text string in that field on each record, you set this, then put your text in the Source Field value.

7. Updated the Example Scheduled Job to have better comments with instructions how to call it from a script.