-
Notifications
You must be signed in to change notification settings - Fork 0
Banner Settings
The base banner settings provide fundamental functionalities which guides the basic set of operation. For example, save locations and input file locations. The individual banner will share most of its settings with some specialized settings for each banner.
The banner settings are saved under "User\Documents\LifeCycle Workflow Automation" in JSON format. The settings will be replaced if the default filenames are altered.
Keep in mind the standard single backslash '' is replace by '\' since the automation will parse double back slash into a single slash. The program will crash if the double back slash rule is broken.
Below is a list of settings names explained in detail.
Individual settings offered for customization:
This field is where output file will be copied to after calculation. The default location is set to current user's desktop. This setting should be set to a valid folder location.
Network location must be connected for files to appear correctly. There are no error checking code for network issues currently.
The default name that appears on both WIP and final output file. This name will be the prefix to the date input in the settings file. The name of output file will follow the format:
"Default_Filename" + "Date_MM_DD_YYYY" + "Hour_Minute_Generated"(Optional) + "File_type".
Output date follows UTC standard format.
Example: "2020-11-02T00:00:00", 2020-Nov-02Thh:mm:ss.
Banners represented in numbers.
- 0 - TheBay
- 1 - Saks
- 2 - O5
These fields are expecting valid file location. The default filenames are left as empty.
The double back slash rule is very important and keep to be followed when editing filenames manually. There are no file content validation at this stage. Please make sure the input files are correctly inputted into the automation.
The template file location can be set to network or local drives, as long as it is properly mapped under Windows. The template name support .xlsx and .xlsm file formats.
This is the password that is set on the Final output file. The password is required to edit the excel file being generated.
Convert all operation data into values only, this operation will be performed as the last step to ensure all calculation precedence are followed properly according to workflow original design.
Each banner has its own version of worksheet settings. For more information, please refer to individual banners here.