Hello Nicole, Try to use a CSV using a MARC "type". The SQL type has been introduced by bug 10854 to export serial claims and it's not implemented everywhere. Regards, Jonathan 2014-07-24 18:04 GMT+02:00 Nicole Engard <nengard@gmail.com>:

I created a CSV Profile (that obviously isn't right) http://screencast.com/t/49bnF9SY1 , named it 'checkouts, and then set the ExportWithCsvProfile preference to 'checkouts'. When I exported I got a blank CSV file. Can someone tell me how to use this preference to get a list of the patron's checkouts as a CSV file? I will share your example in the manual.

Thanks Nicole _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

Hi, On Thu, Jul 24, 2014 at 9:04 AM, Nicole Engard <nengard@gmail.com> wrote:

I created a CSV Profile (that obviously isn't right) http://screencast.com/t/49bnF9SY1 , named it 'checkouts, and then set the ExportWithCsvProfile preference to 'checkouts'. When I exported I got a blank CSV file. Can someone tell me how to use this preference to get a list of the patron's checkouts as a CSV file? I will share your example in the manual.

The problem is that the loans export is expecting a *MARC* CSV profile, not an SQL one. This is because the loans export was developed before SQL CSV profiles were an option; it works by fetching the MARC bib records corresponding to the selected loans. Here is an example of a profile that would work: Title=245$a|Author=100$a At present, the loans export has no way to include information about the loans themselves or the patron. Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: gmc@esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org