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/