web stats
Mirth Community - Search Results

Go Back   Mirth Community > Search Forums

Showing results 1 to 17 of 17
Search took 0.00 seconds.
Search: Posts Made By: DimitriA
Forum: Support 07-28-2011, 03:55 PM
Replies: 2
Views: 3,377
Posted By DimitriA
Syntax Question: INSERT variable to db

I'm having trouble getting the syntax right for how to insert a variable into SQL Express 2005.

I have tried:

var test1 = 3;

query = dbConn.executeUpdate("INSERT INTO someTable (someColumn)...
Forum: Support 07-28-2011, 01:22 PM
Replies: 6
Views: 8,213
Posted By DimitriA
Sure. This would have probably been easier in the...

Sure. This would have probably been easier in the first place. Thank you for your time and patience. I really appreciate it.

First, here is the step in my Destination Transformer (that you helped...
Forum: Support 07-28-2011, 10:29 AM
Replies: 6
Views: 8,213
Posted By DimitriA
I am currently doing this. However, I can only...

I am currently doing this. However, I can only map the variable to a single cell as the destination node. If I do this, all of the lab values appear in that one cell.

I was wondering if there was...
Forum: Support 07-27-2011, 10:04 AM
Replies: 6
Views: 8,213
Posted By DimitriA
Cycle through rows in .csv in Message Builder?

Hi,

I am trying to generate a .csv file with patients' lab results in columns. I can store the different results in an array variable using JavaScript; however, I'm having trouble mapping that...
Forum: Development 07-21-2011, 05:29 PM
Replies: 15
Views: 25,932
Posted By DimitriA
Has anyone gotten this to work? I am trying...

Has anyone gotten this to work?

I am trying to write an excel file using this (from the tutorial on the API)


importPackage(Packages.jxl.Workbook);

WritableWorkbook workbook =...
Forum: Support 07-21-2011, 04:59 PM
Replies: 9
Views: 6,272
Posted By DimitriA
Never mind I got it. For anyone else: ...

Never mind I got it.

For anyone else:


var resultVal = new Array();
var counter = 0;

for each (mOBX in msg..OBX)
{
Forum: Support 07-21-2011, 03:41 PM
Replies: 2
Views: 3,288
Posted By DimitriA
I got it. Thank you!

I got it. Thank you!
Forum: Support 07-21-2011, 03:27 PM
Replies: 3
Views: 5,200
Posted By DimitriA
Very similar, however with a Message Builder...

Very similar, however with a Message Builder there is no way to use JavaScript.

Your idea inspired me to try using one of the arrays I'd made using the advice in the other thread you mentioned....
Forum: Support 07-21-2011, 01:06 PM
Replies: 2
Views: 3,288
Posted By DimitriA
Insert an Array into db using JavaScript

Hi,

I'm trying to use JavaScript to insert an array of integers into a db. Unfortunately, I'm not getting the syntax right and they're appearing as strings

I can get the string patientID to...
Forum: Support 07-21-2011, 10:35 AM
Replies: 3
Views: 5,200
Posted By DimitriA
Using Message Builder to map multiple results

Hi, I am very new to Mirth and could dearly use some help.

I am trying to use a transformer to map lab results received in HL7v2 into a .csv file. I set my output type to be Delimited Text and...
Forum: Support 07-20-2011, 09:16 AM
Replies: 9
Views: 6,272
Posted By DimitriA
Bostad, Thank you so much for the clear and...

Bostad,

Thank you so much for the clear and thorough explanation!

However I'm stumped on the last part: how do I get at the values in the 'for each' loop?

I tried setting the name of a...
Forum: Support 07-18-2011, 04:07 PM
Replies: 9
Views: 6,272
Posted By DimitriA
Great! Sorry for the newbie question but uh...

Great!

Sorry for the newbie question but uh . . . where do I put that?

It looks like JavaScript, so do I put it in Destinations?
Forum: Support 07-18-2011, 12:41 PM
Replies: 9
Views: 6,272
Posted By DimitriA
Actually, I'm pretty confident about the design...

Actually, I'm pretty confident about the design of the db - it looks a lot like what you laid out. My question was: how do I get at the values of the results in order to store them?

For example:...
Forum: Support 07-18-2011, 10:46 AM
Replies: 9
Views: 6,272
Posted By DimitriA
Basic Transformer Question

Hi, I am very new to Mirth and have a lot to learn. I really appreciate how helpful the people on this forum have been thus far. Thank you all!

I am trying to create a channel that will receive...
Forum: Support 07-18-2011, 10:24 AM
Replies: 6
Views: 10,581
Posted By DimitriA
Thank you marmanold and duggram! I'll check out...

Thank you marmanold and duggram! I'll check out that thread
Forum: Support 07-18-2011, 10:23 AM
Replies: 6
Views: 10,581
Posted By DimitriA
Thank you for the reply Bostad, but there's a lot...

Thank you for the reply Bostad, but there's a lot I don't understand here. Like I said, I'm just getting started with Mirth. Could you explain or point me to an explanation about inbound/outbound...
Forum: Support 07-14-2011, 03:42 PM
Replies: 6
Views: 10,581
Posted By DimitriA
Write HL7 v2 to Excel?

Hi, I'm very new to Mirth and I would really appreciate some help.

Is there anyway I can generate Excel files from the HL7 v2.* messages I receive?

I am currently converting them into XML and...
Showing results 1 to 17 of 17

 
Forum Jump

All times are GMT -8. The time now is 08:48 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation