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 [email protected] On Tue, Aug 9, 2011 at 9:13 AM, Magnus Enger <[email protected]> wrote: > 2011/8/9 Chris Cormack <[email protected]>: > > * Hartman, David W. - GBTS Library ([email protected]) 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 > [email protected] > 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/ >
_______________________________________________ Koha-devel mailing list [email protected] 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/
