This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
''' | |
Compute some stats on cah collection | |
First get the files with: | |
lynx -dump -hiddenlinks=listonly -nonumbers http://the-eye.eu/eleuther_staging/cah/ | grep cah | grep .csv > cah.csv | |
aria2c --dir=shards --auto-file-renaming=false --continue=true -i cah.csv -x 16 -s 16 -j 100 | |
Takes a few minutes to run | |
Then pip install pyspark | |
Then run this file. It also takes a few minutes | |
''' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select C.*, PS.caller_number as Caller, PD.caller_number as Destination from cl_calls C | |
JOIN cl_segments S ON C.id = S.call_id | |
JOIN cl_party_info PS ON PS.id = S.src_part_id | |
JOIN cl_party_info PD ON PD.id = S.dst_part_id | |
where S.seq_order = 1 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<# | |
Script to update new items for an exported/imported form | |
Must replace all exported form fields IDs with imported form fields IDs - copy the ForEach-Object line as necessary | |
Must replace old form id with new form id | |
insert latest exported xml | |
specify the date from which new items are to be imported | |
run the script | |
import the updated.xml file into the target site | |
#> | |
$filetoimport = 'clinicaivory-lakeview.formidable.2018-07-28.xml' |