UpToDate

I was able to go into UTD's new user portal. I went into the analytics dashboard, adjusted the time frame to Year-to-Date, then "view more" under the Annual Usage graph. I clicked on "all topics" and then "view as a table" or just "view in focus mode". I then manually put this data into an excel format. Your excel format must match what the example looks like. Cell 1 should say " Month to Month Usage Report for (Insert institution), then a blank cell. The rest of the data I formatted as a chart with headers. Column A should be formatted as text and not a number. Make sure the rest of the cells in column A after your table are formatted as general. 

This way only gets you strictly account usage as a whole, not IP or specific sites/institutions data. 

This is the only way I could use the manual upload.

I'm attaching an example excel sheet.

Hello Denise,

 we (CzechELib) have received report with raw data (monthly usage assigned to individual IP addresses) and our IT colleague has

managed to assign most of the records to institutions and has produced reasonable CSV file for upload.

However, there are always IP addresses which we were not able to assign, because they were coming from the temporary login outside IP ranges.

Best

Jiri