New file |
0,0 → 1,30 |
#!/bin/bash |
|
orig=/tmp/orig.csv |
ret=${1:-/tmp/result.csv} |
|
# curl -sF "upload=@test.xls" -F utilisateur=22506 "http://cel/jrest/ImportXLS" |
# $ sqlite3 .mozilla/firefox/*.default/cookies.sqlite<<<"SELECT * FROM moz_cookies WHERE baseDomain = 'cel' AND name = 'PHPSESSID';" |
# GET -H "Cookie: PHPSESSID=ID" "http://cel/jrest/CelWidgetExport/export/?colonnes=standard,avance,etendu,baseflor&id_utilisateur=22506&format=csv > $ret |
[[ ! -f $ret || ! -f test.xls ]] && echo "err" && exit 1 |
|
[[ ! -f $orig ]] && xls2csv -s cp1252 test.xls 2>/dev/null > $orig |
[[ ! -f $orig ]] && echo "err" && exit 1 |
|
|
IFS=$'\n' cols=( $(csvtool head 1 $orig|tr , "\n") ) |
|
# test header |
#diff <(csvtool head 1 $orig|tr , "\n") <(csvtool head 1 $ret |tr , "\n"); exit; |
|
w=$(csvtool width $ret); w=32 |
|
# wdiff <(xls2csv -s cp1252 test.xls|csvtool readable -) <(csvtool readable $ret) |
for i in ${cols[@]}; do |
[[ $i =~ ^(Date Transmission|Date Création|Date Modification|Nom Commun|Identifiant|Ordre)$ ]] && continue; |
echo "== $i"; |
wdiff -w "$(tput bold;tput setaf 1)" -x "$(tput sgr0)" -y "$(tput bold;tput setaf 2)" -z "$(tput sgr0)" <(csvtool namedcol "$i" $orig) <(csvtool namedcol "$i" $ret) |
done |
|
|
#ddiff <(csvtool namedcol Notes,Date /tmp/orig.csv ) <(csvtool namedcol Notes,Date /tmp/result.csv) |
Property changes: |
Added: svn:eol-style |
+native |
\ No newline at end of property |
Added: svn:executable |
+* |
\ No newline at end of property |