ebot

-- For each user run this query:
Select d.DocId, DocTypeName, OwnerTypeName, CreateDateTime,
       EncounterNo, MedRecNo, EnrolleeName
From Documents as d
Inner Join DocTypes as dt on
d.DocType = dt.DocType
Inner Join DocsOwners as do on
d.DocId = do.DocId
Inner Join Owners as o on
do.OwnerId = o.OwnerId

ebot

#!/usr/bin/env ruby -wKU

total_files = 0
# Looop through each yml file
d = Dir.new(".")
 Dir.glob( '*.yml' ) do |file|
  file_count = 0
  log_file = File.new file, 'r'
  log_text = log_file.read

ebot

#!/usr/bin/env ruby -wKU
#http://gist.github.com/124347

require 'rubygems'
require 'fastercsv'
require 'yaml'

begin
  # Load the config file
  ops = YAML::load(File.new('config.yml'))

ebot

#!/usr/bin/env ruby -wKU
#http://gist.github.com/gists/146431
require 'fileutils'

tif_dir = "\\\\EDMC0D0a\\C0D0\\OlcReports"
tag_dir = "\\\\EDMC0D0a\\C0D0\\Upload\\Alpha"

begin
  Dir.glob("data/*.tif").each do |file|
    file_name = File.basename(file)

ebot

<?xml version="1.0" encoding="UTF-8"?>
<lesson title="" lang="EN" version="">
  <pages>
    <page title="" number="">
      <text><![CDATA[]]></text>
      <overlays>
        <overlay type="txt|img|swf|qt">
          <source></source>
          <xloc></xloc>
          <yloc></yloc>

ebot

#!/usr/bin/env ruby -wKU

require 'rexml/document'
require 'rubygems'
require 'RedCloth'
 
include REXML

doc = Document.new( File.new( 'bpack.xml', 'r' ) )
XPath.match( doc, "//pages/page" ).each do |page|

ebot

#!/usr/bin/env ruby -wKU

require 'rubygems'
require 'fastercsv'
require 'yaml'

begin
  # Gather the encounter information
  map = YAML::load( File.new( 'encounter-map.yml', 'r' ) )
  encounters = {}

ebot

set nocompatible
source $VIMRUNTIME/vimrc_example.vim
source $VIMRUNTIME/mswin.vim
behave mswin

set diffexpr=MyDiff()
function MyDiff()
  let opt = '-a --binary '
  if &diffopt =~ 'icase' | let opt = opt . '-i ' | endif
  if &diffopt =~ 'iwhite' | let opt = opt . '-b ' | endif

ebot

SELECT YEAR(ModifyDateTime) as document_year,
       COUNT(TotalKB) as document_count, 
       (SUM(TotalKB)/1024)/1024 as document_size_gb
FROM Documents as d
  INNER JOIN DocTypes as dt ON d.DocType = dt.DocType 
  INNER JOIN DocArchStg as das ON d.DocID = das.Docid
  INNER JOIN DocsOwners as do ON d.DocId = do.DocId
  INNER JOIN Encounters as e ON do.OwnerId = e.EncntrOwnerId
GROUP BY YEAR(ModifyDateTime) WITH ROLLUP

ebot

#!/usr/bin/env ruby -wKU
#
# A practical example of using modules is the process of making tacos. 
# There are 4 main modules: main, Ingredients, Prep, and Serve
#

module TacoBell
  class Tacos
    def initialize(style = "Mild")
      @style = style