Looking at Work in a Spreadsheet
Question: We are involved in some disease research and to analyse data we would like to be able to "dump" a 6 monthly set of clinical notes from a client into an Excel Spreadsheet.
So for example, we would like all Mr Jones of Hill Farm clinical notes from 1.1.07 to 30.6.07 including values into an excel spreadsheet. We have 9 clients that we would like to do this for every 6 months.
What is the easiest way of doing this please?
Answer: Export the specific animal records to a csv file and load it up into excel.
Transaction dates - Enter the start/finish dates you want e.g. 01.01.07 and less than 30.06.07
Ana Codes start 0 and 254 (if you want payments as well make it end at 255).
User Group - Just press Return
Restrict by: Type in c.pvid=1234 (where 1234 is animal number)
Group By - Press Return on default of nothing
Let the report run - if it 'looks ok' at the 'Do you want to Save' question answer 'File'.
All the results will be in an Excel compatible file 'save.csv' in your text folder. Load it into excel and save it somewere else.
Repeat procedure for other animal numbers.