Exporting / Printing long notes

If you have timesheet notes that are longer than 255 characters, you may have found it difficult to print those notes in a regular TimeControl report.  This is thanks to the Formula1 module that has been used in TimeControl for a very long time to product and view reports.  In an upcoming version of TimeControl we’ll have some additional reporting functionality but for the moment, there is another easy way to get a report that includes notes up to 4,000 characters.
Just export them to Excel.  Here are the basic steps
1. Make a new Table Export based on PSDetails
exportnotes1
2. Select fields that may interest you such as Charge Codes and Descriptions from the Posted Charge Revision table and Hours and Date work performed from the PS Detail table
exportnotes2
3. Now select the Posted Detail/Line table and select Posted Notes. These are the notes that are attached to each line in the timesheet. (For the notes that are attached to the entire timesheet header, select the Posted Line Header table and select Posted Header Note)
exportnotes3
The resulting CSV file will export the notes which should be readable into Excel.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.