IPRO Bookmarks

2020-01-04
These are all the ipro bookmarks from Chrome that I got tired of seeing and don't feel like cleaning up this page to get useful links (regex, sql server, etc.) to a better location since I just did that for all my Audi links.

most likely useful someday:
sql server
java script
hl7

 

Ipro

mirth connect

msg variable

msg object in JavaScript Writer? - Mirth Community
Processing XML with E4X - Archive of obsolete content | MDN
E4X - Archive of obsolete content | MDN
for loop in mirth through different segments - Mirth Community
Question about looping in msg - Mirth Community

debugger

Real debugging for mirth javaScript channel code - Page 2 - Mirth Community
Mirth Connect Admin Guide: Testing Javascript Code Outside Mirth Connect
Unofficial Mirth Connect v3.5 Developer's Guide
JavaScript unit testing with Rhino - Stack Overflow
Using JavaScript with Eclipse - Tutorial
Angry Coding: Mozilla Rhino CommonJS module support
Rhino overview - Mozilla | MDN
Setting up Mirth on Eclipse - Mirth Community
Gurun Perspective: Mirth Connect development environment
mirth connect debugger setup - Google Search

entryset

SourceMap
Map (Java Platform SE 8 )

run through channels

MC Channels to HTML Project - Mirth Community
Mass update of Channels - SQL Mirth's internal Channel Database - Mirth Community

multiple versions

getting 2 mirthconnect server instances on the same machine - Mirth Community

mirth connect api spec 3.5.1
Deserializes an E4X XML node into HL7 v2.x
There was an error connecting to the server - Mirth Community
java - Mirth Connect Administrator Won't Launch - Stack Overflow
Mirth Connect Introduction and Tutorial [Patesco]
Reverting to a Previous Version of Java for Windows | UO Information Technology
Java Archive Downloads - Java SE 8
EXE4J_JAVA_HOME, No JVM could be found on your system
bug report [MIRTH-4218] Mirth Connect 3.5.1 can't be used with Java 9 JRE - Mirth Project
mirth connect classes
Mirth Connect web dashboard
Moving Mirth Connect configuration from one database to another - Mirth Connect - Confluence
Installing and configuring MS SQL Server 2008 - Mirth Connect - Confluence
3.1 classes specification
Mirth Connect Administrator 8443
reset admin password to admin
Encryption Configuration
reset password with security settings
[MIRTH-4091] Mirth UI doesn't display correctly on high dpi monitors - Mirth Project
apache commons and base64 encoded binary data embedded in a xml message - Mirth Community
jTDS JDBC Driver docunentation
Mirth Tools: User defined functions - Page 2 - Mirth Community
Mirth Community - View Profile: RPHaa
msg dot notation
Question About msg versus seg - Mirth Community
Microsoft Word - v2xmlv10.doc
Getting sender's ip address in mirth channel - Mirth Community
Certificates for localhost - Let's Encrypt - Free SSL/TLS Certificates

sql server

live edit in excel

Editing an SQL Server table in Excel - SQL Server Wiki - SQL Server - Toad World
Excel Add-in to Connect with SQL Server
How-To Synchronize Data Between Excel and SQL Server | TurboFuture

access live connection

mostly works but don't get updated from sql server Import or link to data in an SQL Server database - Access
Jumping to a specific record using gotorecord - Access World Forums
Examples of query criteria - Access

stored procedure

sql server - Access Call Stored Procedure with Pass Through Parameter - Stack Overflow

training

Download SQL Server 2016 Training Kit from Official Microsoft Download Center
Course 10986B: Updating Your Skills to SQL Server 2016 | Microsoft

Error message when you open SQL Server Configuration Manager in SQL Server: "Cannot connect to WMI provider. You do not have permission or the server is unreachable"
Download SQL Server Management Studio (SSMS) | Microsoft Docs
Configure the Windows Firewall to Allow SQL Server Access | Microsoft Docs
Troubleshoot Connecting to the SQL Server Database Engine | Microsoft Docs
edit values in table in SQL
SQL Joins
SQL Server: FOR LOOP
Language Elements (Transact-SQL) | Microsoft Docs
Reserved Keywords (Transact-SQL) | Microsoft Docs
SQL Server – How to set a datetime field to automatically use current date/time – IT Support Guides
sql server - Need a datetime field in MS SQL that automatically updates when the record is modified - Stack Overflow
Working with Stored Procedures and User-Defined Functions
sql server - How to set a default value for an existing column - Stack Overflow
Advanced Forms Design in Microsoft Access 2010 and 2013 | Holowczak.com
Access Front End SQL2012 record lock multi user
Working with Constraints
Check Constraint Dialog Box
Error validating constraint.
Create a Stored Procedure | Microsoft Docs

timezones

AT TIME ZONE - a new favourite feature in SQL Server 2016
How to handle SQL code for Daylight Savings for MST Time zone
datetimeoffset (Transact-SQL) | Microsoft Docs
sys.time_zone_info (Transact-SQL) | Microsoft Docs
What You Need to Know about DATETIMEOFFSET and SQL Server 2016's AT TIME ZONE Function

BULK INSERT (Transact-SQL) | Microsoft Docs
Invalid Urn filter on server level: filter must be empty, or server attribute must be equal with the true server name

cursors and Common Table Expressions

Using Common Table Expressions
Cursors (Transact-SQL) | Microsoft Docs

Syntax Conventions [] {} etc
Querying and Changing Data (Database Engine)
possible grep SQL Search - Find SQL fast in SQL Server Management Studio and Visual Studio 2017
possible grep How to grep SQL Server stored procedures? - Stack Overflow
SQL Server Regex | Use regular expression to search, replace and split text in SQL · zzzprojects/Eval-SQL.NET Wiki · GitHub
sql server - How do you view ALL text from an ntext or nvarchar(max) in SSMS? - Stack Overflow

primary key skips values

sql server - What could cause an auto increment primary key to skip numbers? - Database Administrators Stack Exchange

sql - Convert Datetime column from UTC to local time in select statement - Stack Overflow

javascript

switch vs if else

Should I use big switch statements in JavaScript without performance problems? - Stack Overflow

JavaScript reference - JavaScript | MDN
Operator precedence - JavaScript | MDN
JSHint, a JavaScript Code Quality Tool
mozilla javascript reference Number.isInteger() - JavaScript | MDN
JavaScript Function Parameters ARGS by val OBJS by ref
RegExp - JavaScript | MDN
javascript - Regex match newline in textarea - Stack Overflow
String literals and escape characters
sirdarckcat: Passing Variables by Reference in JavaScript
no performance hit if declare vars in loop
JavaScript libraries
JavaScript other Methods
index of pages of mozilla javascript
StringUtils (Apache Commons Lang 3.7 API)
How do I use StringUtils in Java? - Stack Overflow
JavaScript data types and data structures - JavaScript | MDN
mosquitoes breeding in salt water

java linkedhashmap

HashMap (Java Platform SE 7 )
LinkedHashMap (Java Platform SE 7 )

HL7

MSH defn
Event Types (table 003)
Separators and Escape Sequences - HL7 to Mirth Results Mapping Guide - Confluence
HL7 Escape Sequences
Value Set Details
HL7 Escape Sequences | Health Standards
.gov ORU HL7 Implementation Guide.
PDF Attachment in HL7 Message | Health Standards
HL7 - REFACTORED
value tables in segment description 2.24.1 MSH - message header segment
Health Level Seven International - Homepage
hl7.org index
Workflow - FHIR v3.0.1

vpn

Bug Search
Solved: AnyConnect disables native IPv6 when co... - Cisco Support Community
Cisco AnyConnect and IPv6 - Packet Pushers -

SNOMED search codes