[Koha-devel] Importing checkout records into Koha

[Fridolyn SOMERS]

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 at gmail.com


On Tue, Aug 9, 2011 at 9:13 AM, Magnus Enger <magnus at enger.priv.no> wrote:

> 2011/8/9 Chris Cormack <chrisc at catalyst.net.nz>:
> > * Hartman, David W. - GBTS Library (David.W.Hartman at 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 at 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/
>
-------------- section suivante --------------
Une pi�ce jointe HTML a �t� nettoy�e...
URL: </pipermail/koha-devel/attachments/20110822/955f6d15/attachment.htm>