-
Notifications
You must be signed in to change notification settings - Fork 0
User Settings #Banner #TheBay
Some sections are under construction, not publicly visible:
General walkthrough of the entire thebay settings and what they are meant to do.
This is the directory where output files will be copied to after the automation finished executing.
Default path is current user's Desktop as two separate output files in the respective template's file format. If the folder directory is a network location, the user will be required to be connected for automation to run correctly.
When changing this address manually, please make sure the path address is formatted with double back slash.
Example:
"WipOutputDirectory": "C:\\Users\\Middle\\Desktop",
"FinalOutputDirectory": "C:\\Users\\Middle\\Desktop",
This is the prefix filename that appear on the output files.
The default value is "TheBay_Daily_Workflow", it can be changed into any alphanumeric value.
This is the date appear after "DefaulOutputFilename" in the output file name.
This date format is in UTC format, the date will be reflected directly in the summary chart date cell(Default to be N1).
TheBay is represented by 0, do not change this number.
Default value is empty, these fields expect valid file locations. The following inputs also expect fixed file format:
"InputFilenameWorkflow": ".csv"
"InputFilenameInactiveUpc": ".csv"
"InputFilenameBitReport": ".csv", ".xlsx"
"InputFilenameNosCombined": ".csv"
If the folder directory is a network location, the user will be required to be connected for automation to run correctly.
When changing this address manually, please make sure the path address is formatted with double back slash.
Template support ".xlsx" and ".xlsm" formats.
If the folder directory is a network location, the user will be required to be connected for automation to run correctly.
When changing this address manually, please make sure the path address is formatted with double back slash.
This is the password that protects edit privileges on the "Final" output file, "WIP" output file is not affected by this.
"true" - When set to true, WIP output file will only include values, all formulas will be converted to values. This is the default behavior.
"false" - When set to false, WIP output file will include formulas instead of values. Useful for testing and validation.
"SummarySettings": {
"ReportSettings": {
"WorksheetName": "WF Summary Chart",
"DateAddress": "N5",
"ReadingAddress": "E1:BO118"
},
"FinalSettings": {
"WorksheetName": "Summary Chart",
"WritingAddress": "E1"
}
}
"WorkflowSettings": {
"WipSettings": {
"FormulaRow": 3,
"ReferenceRow": 4,
"WorksheetName": "Details_Products",
"HeaderRow": 7,
"WritingRow": 8,
"ReadingAddress": "A:BT"
},
"FinalSettings": {
"WorksheetName": "Workflow Details",
"WritingAddress": "A4"
},
"DataSourceSettings": {
"HeaderRow": 1,
"WritingRow": 1,
"WorksheetName": "Looker_Data"
}
}
"InactiveUpcSettings": {
"WipSettings": {
"FormulaRow": 3,
"ReferenceRow": 4,
"WorksheetName": "Inactive_UPC",
"HeaderRow": 7,
"WritingRow": 8,
"ReadingAddress": "A:AS"
},
"FinalSettings": {
"WorksheetName": "Additional Color Sizes Report",
"WritingAddress": "A4"
},
"DataSourceSettings": {
"HeaderRow": 1,
"WritingRow": 1,
"WorksheetName": "UPC_Looker"
}
}
"BitreportSettings": {
"WipSettings": {
"WorksheetName": "Ttl_Inv",
"HeaderRow": 1,
"WritingRow": 1,
"ReadingAddress": "A:E"
}
}
"NosCombinedSettings": {
"WipSettings": {
"FormulaRow": 1,
"ReferenceRow": 2,
"WorksheetName": "NOS_Colour_Combined",
"HeaderRow": 2,
"WritingRow": 3,
"ReadingAddress": "A:CE"
},
"FinalSettings": {
"WorksheetName": "NOS_Colour_Combined",
"WritingAddress": "A2"
},
"DataSourceSettings": {
"HeaderRow": 2,
"WritingRow": 3,
"WorksheetName": "NOS_Colour_Combined"
}
}