CLI import CSV into suiteCRM

autor:

convert from windows-1250 to UTF8 iconv -f WINDOWS-1250 -t UTF-8 customer.csv > customer.u.csv inspired by this web http://www.jsmackin.co.uk/suitecrm/large-imports-in-suitecrm/ LOAD DATA INFILE '/tmp/customer.u.csv' INTO TABLE contacts FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' (id,description,department,first_name,last_name,primary_address_street,primary_address_city,primary_address_postalcode,phone_home,phone_work,phone_other,phone_fax,phone_mobile,description,alt_address_street,alt_address_street,salutation,alt_address_street,title,primary_address_country,primary_address_state); REBUILD INDEX DB ALTER TABLE contacts DROP KEY idx_cont_last_first; ALTER TABLE contacts DROP KEY idx_contacts_del_last; ALTER TABLE contacts … Číst dál

upgrade openwrt and build own image zabbix

autor:

download OpenWrt-ImageBuilder untar and jump into directory make image PROFILE=TLWA901 PACKAGES="-wpad-mini wpad luci zabbix-extra-mac80211 zabbix-extra-network zabbix-extra-wifi" copy image into old running AP scp ./bin/ar71xx/openwrt-15.05.1-ar71xx-generic-tl-wa901nd-v2-squashfs-fact ory.bin root@192.168.1.23:/tmp/ ssh into AP ssh root@[ip] cd /tmp sysupgrade -b backup.tar.gz # backup old config sysupgrade -f ./backup.tar.gz ./openwrt-15.05.1-ar71xx -generic-tl-wa901nd-v2-squashfs-factory.bin # install new image and restore old config configure zabbix echo … Číst dál

domoticz espeasy mqtt

autor:

Pro nastaveni promenne Dummy musime nejdrive vytvorit Rules on dumb1 do TaskValueSet 6,2,%eventvalue% if [tempsensor#Temperature]<[dumb#temp] do mcpgpio,5,0 else mcpgpio,5,1 endon vysvetleni TaskValueSet TaskValueSet [TaskID],[VariableIDX],[Hodnota]   nepodarilo se me poslat event pres mqtt a domoticz z duvodu json formatu, ale ukazka jak toto volat pres http http://[ipaddressesp]/control?cmd=event,dumb1=10