Re: [Koha] Help with ExportWithCsvProfile

2014-07-26 Thread Galen Charlton
Hi,

On Thu, Jul 24, 2014 at 9:04 AM, Nicole Engard neng...@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:  g...@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
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Help with ExportWithCsvProfile

2014-07-25 Thread Nicole Engard
Thanks! That works!


On Fri, Jul 25, 2014 at 2:43 AM, Jonathan Druart 
jonathan.dru...@biblibre.com wrote:

 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 neng...@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

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


[Koha] Help with ExportWithCsvProfile

2014-07-24 Thread Nicole Engard
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