Hie,

For such data integrations, our company uses Talend Open Studio.
It is a business-oriented data modeling software (an open-source based on Eclipse RCP).
This means that no programing is needed. It can use and produce many file formats like SQL, XLS, CVS, ...

You may use it to transform your CVS file into a SQL injection script.

See :
http://www.talend.com/products-data-integration/talend-open-studio.php


--
Fridolyn SOMERS
ICT engineer
PROGILONE - Lyon - France
fridolyn.somers@gmail.com


On Tue, Aug 9, 2011 at 9:13 AM, Magnus Enger <magnus@enger.priv.no> wrote:
2011/8/9 Chris Cormack <chrisc@catalyst.net.nz>:
> * Hartman, David W. - GBTS Library (David.W.Hartman@disney.com) wrote:
>> Yes, due date is provided and name - names are unique! :)
>>
> Right, then a script like Robin's is probably the way to go.

Here is my script for doing something similar:
https://github.com/MagnusEnger/LibrioTools/blob/master/tidem/loans.pl
Again, this is tailored to one specific system/situation (where the
data about current checkouts was in HTML format!), but it might give
some hints...

What I did was create a .koc-file with my script, which I could then
import using Home › Circulation › Offline Circulation File Upload. I
figured that would reduce the risk of putting data in the wrong place
or missing some field in some table that should have data in it...

The format of the .koc file is documented here:
http://wiki.koha-community.org/wiki/Koha_offline_circulation_file_format

Best regards,
Magnus Enger
libriotech.no
_______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/