Exporting Unlimited UDFs

NEW feature requires Student Manager version 8.0.253.24 or newer

Unlimited UDFs are not added to a report cursor by default. You have 2 options to add them to the report cursor for exporting purposes.

Add a Single UUDF

You can use a Justdoit() function in the report to add Unlimited UDFs to a cursor.

This example will add a Name Unlimited UDF called emergency_contact to the cursor:

justdoit('select *,addnmunl(nmid,"emergency_contact") as emergency_contact,0 as marker from (cursor5) into cursor(cursor5)')

Add Multiple UUDFs

If you need to add more Unlimited UDFs, you can use the Adduudfs() function in a Justdoit() to add the Unlimited UDFs to the cursor.

Notes

• The Unlimited UDF field must be available in the cursor (nudfu, cudfu, rudfu). See the Adduudfs() function for more information.
• Currently only Name and Course UUDFs are supported. Register UUDFs will be supported in a future build.

To use this option:

1. Create a .txt type file with the names of the Unlimited UDFs you want to export, e.g. nameuudfs.txt. The Unlimited UDFs must be separated by commas.

Make sure your .txt file has no trailing spaces or line breaks at the end of your list. Example:

2. Place your .txt file in the Extend folder in your Student Manager directory (e.g. manager8\etend).

3. Modify a report that has the available Unlimited UDF field in it. For example, if you want to export Name Unlimited UDFs, your report area must include the nudfu field from the Nameudfs table.

4. Add a Justdoit() function that uses the adduudfs() function. Example:

justdoit([adduudfs("nudfu",filetostr("nameuudfs.txt"))])