From: Dobrica Pavlinusic <dpavlin@rot13.org>
Date: Fri, 5 Oct 2018 14:23:31 +0000 (+0200)
Subject: generate sql inserts from dla data
X-Git-Url: http://git.rot13.org/?p=koha-dla;a=commitdiff_plain;h=e7f9fc4e2a844a9e4ca51951634f2e8dabe1d2cc

generate sql inserts from dla data
---

diff --git a/dla-import-to-sql.sh b/dla-import-to-sql.sh
new file mode 100755
index 0000000..20601e3
--- /dev/null
+++ b/dla-import-to-sql.sh
@@ -0,0 +1,10 @@
+#!/bin/sh -e
+
+
+#ls /mnt/share/DLA/inventura/*/*/upload/inv/*.pdX | while read path ; do
+find /mnt/share/DLA/inventura/ . -name '*.pdX' | grep upload/inv | while read path ; do
+	echo "# $path"
+	source_id=$(echo $path | cut -d/ -f6)
+	date_scanned=$(echo $path | cut -d/ -f7)
+	strings $path | grep '130[0-9][0-9][0-9][0-9][0-9][0-9][0-9]' | sed -e 's/^.*\(130[0-9][0-9][0-9][0-9][0-9][0-9][0-9]\).*$/\1/' -e "s/^/insert ignore into ffzg_inventura (date_scanned,source_id,barcode) values ('$date_scanned','$source_id','/" -e "s/$/');/"
+done