...
Alternative to importing an .xml, data can also be loaded from XLSX and CSV spreadsheets. When using a spreadsheet to import data the user must specify how that data is imported into Fuzor. While this may take more time on initial setup, this allows the user more control over how the data is imported. settings are preserved and can be exported and reused so that future updates are easier. For more information about which columns can be mapped see Task Table Columns. Notably both WBS and Task Type cannot be populated with column mapping. | |||||||
The column mapping menu can be opened from the 4D Load Options menu or by right clicking a mappable column header and selecting the button that appears. |  | ||||||
 |  | ||||||
The Load Spreadsheet button opens the file browser for the user to select a spreadsheet to load data from. The Current Column Map list denotes which columns from the spreadsheet should be used to populate specified columns in Fuzor. When a spreadsheet is first loaded the list is empty. | |||||||
When a spreadsheet is loaded the file name is displayed above the settings to add new mappings to the schedule. There are four drop down menus that control how a new mapping is added. | |||||||
The Source Column denotes the column in the spreadsheet where the data is loaded from. Other columns allow the user to select from available Fuzor columns. |  | ||||||
Column Type specifies a particular column within a set of dates. Possible values are Duration, Start Date, End Date and all supported Cost Types. A Custom Column is also an option from this drop down menu Task or Baseline specifies a particular schedule to populate. Date Type specifies a particular set of durations and dates to populate. Options are Planned, Actual, Start and End, and Remaining. The Add Column Mapping button adds the mapping specified by the drop down menus to the Current Column Map List When all desired columns are mapped use the Apply button to load the data from the spreadsheet | |||||||
...