The Academy

0 of 91 lessons complete (0%)

Service Plan *

Imported Data Tab

If you have existing data collected outside of Office Puzzle, you can import the data for each element in the service plan by simply converting your data to the format “DATE;VALUE;TYPE”.

DATE

You can put the DATE value in any of the following formats:

  • MM/DD/YYYY (Ex: 02/10/2023)
  • YYYY-MM-DD (Ex: 2023-02-10)
  • YYYY/MM/DD (Ex: 2023/02/10)

VALUE

The value that will be associated with this DATE, this value is expected to be a NUMBER and shouldn’t contain any letters or sign. For example, if your value is 10% the input should be “10”.

You can generate the dates by adding start and end dates. Then you select the interval and hit Generate dates.

Also, you can import the data, by copying and pasting the dates and values into the box, and clicking on Update.