The following are some limitations you should be aware of when generating extracts from custom reports with suggestions for workarounds.
Attendance Meta-Data is tied to ADA Refresh
As of now, Attendance Meta-Data is tied to an ADA Refresh. This limits the data you can send in the morning. Most districts and charter school organizations are set to automatically refresh their ADA data, typically around 3:00 AM. This means attendance meta-data will not have data as of today's data.
We provide absence, tardy and other attendance mark files to work around this limitation. You can call our help desk at (949)-242-0343 or send in an email to firstname.lastname@example.org for more information.
I need to provide a column more than once in a report.
As of now, the "Add Columns" feature of Custom Reporting will not allow a column to be added more than once. For example, this is an issue for extracts where the local student ID is in the student ID field but also the username and/or temporary password field.
You can use Advanced > Add a Calculation and using the string-calculations to add a calculation where you make no modifications and just include the string un-altered. This effectively is a duplicate column.
We currently only support comma (,) or tab-delimited files. The uncommon options, such as carrot-delimited (^), pipe-delimited (|) and fixed-width are currently not available.
Currently there are no work-arounds other than writing a script after the file is generated. You may want to call your vendor and speak with them to support tab-delimited and comma-separated value.