web stats
Mirth Community - Search Results

Go Back   Mirth Community > Search Forums

Showing results 1 to 24 of 24
Search took 0.00 seconds.
Search: Posts Made By: itizi
Forum: Development 09-04-2018, 01:05 PM
Replies: 0
Views: 1,060
Posted By itizi
filename file regular expressions

what regex engine is used? where can I find a guide on what tools are available in the regex used in the filename filter pattern regex?

My current issues is that I'm trying to pulling files with...
Forum: Support 04-01-2016, 12:46 PM
Replies: 5
Views: 1,145
Posted By itizi
is there anywhere in mirth that shows the insert...

is there anywhere in mirth that shows the insert statement with values filled in?
Forum: Support 04-01-2016, 09:59 AM
Replies: 5
Views: 1,145
Posted By itizi
unfortunately my sql server doesn't have that...

unfortunately my sql server doesn't have that option...I know so outdated.. we will be upgrading sometime soon, but at present that isn't possible
Forum: Support 04-01-2016, 08:36 AM
Replies: 5
Views: 1,145
Posted By itizi
troubleshooting destination sql errors

I'm looking for suggestions on troubleshooting errors from SQL server, most especially the obnoxiously generic "String or binary data would be truncated" error, although there are others too. Since I...
Forum: Support 01-16-2015, 09:11 AM
Replies: 21
Views: 6,689
Posted By itizi
I got this error: Transformer error ERROR...

I got this error:

Transformer error
ERROR MESSAGE: Error evaluating transformer
com.mirth.connect.server.MirthJavascriptTransformerException:
CHANNEL: OKC_okhh
CONNECTOR: Destination 1...
Forum: Support 01-16-2015, 08:55 AM
Replies: 21
Views: 6,689
Posted By itizi
but how do you reference the msg created in the...

but how do you reference the msg created in the above code in that syntax?
Forum: Support 01-16-2015, 08:38 AM
Replies: 21
Views: 6,689
Posted By itizi
How do you make lastname into a channel variable?

How do you make lastname into a channel variable?
Forum: Support 01-16-2015, 08:31 AM
Replies: 21
Views: 6,689
Posted By itizi
okay. does it make channel variables I can create...

okay. does it make channel variables I can create an insert into statement with or how do I now get those row children into my database?
Forum: Support 01-16-2015, 08:24 AM
Replies: 21
Views: 6,689
Posted By itizi
Is that code for a javascript-type transformer?...

Is that code for a javascript-type transformer? or does it go in the source?
Forum: Support 01-16-2015, 07:55 AM
Replies: 21
Views: 6,689
Posted By itizi
Ok it appears I can make a batch into a record by...

Ok it appears I can make a batch into a record by using a 'nonsense' character as the record delimiter and unticking the split batch by record checkbox... now I can use the transformers with substr...
Forum: Support 01-16-2015, 07:44 AM
Replies: 21
Views: 6,689
Posted By itizi
Is it possible to split records on the batch? You...

Is it possible to split records on the batch? You gave me a javascript that splits batches on P1, but each batch should be a record since I can't use both of those characters as a record delimiter...
Forum: Support 01-16-2015, 07:04 AM
Replies: 21
Views: 6,689
Posted By itizi
I apologize for not reading before posting.. in...

I apologize for not reading before posting.. in any case would the idea be to start making transformers with, for instance, msg['row'][0]['column1'].toString().substr(31,20) as the mapping? or is...
Forum: Support 01-16-2015, 06:21 AM
Replies: 21
Views: 6,689
Posted By itizi
Since you ask so nicely, my version is...

Since you ask so nicely, my version is 3.0.3.7171, but if it helps I've certainly willing to upgrade... Is it better to separate them into batches? each row is not a record, instead each record...
Forum: Support 01-15-2015, 01:48 PM
Replies: 21
Views: 6,689
Posted By itizi
So would this code go in the source tab, and it...

So would this code go in the source tab, and it would output the records one by one for the destinations?
Forum: Support 01-15-2015, 01:32 PM
Replies: 21
Views: 6,689
Posted By itizi
Actually it is fixed width it's just that this...

Actually it is fixed width it's just that this html message board will only show one space no matter how many consecutive spaces there are
Forum: Support 01-15-2015, 01:07 PM
Replies: 21
Views: 6,689
Posted By itizi
The first record is Martin shore and the second...

The first record is Martin shore and the second is alive wonderland...each starts with a P1 segment...there are multiple rows per record, each row has a different fixed width specification, is P1...
Forum: Support 01-15-2015, 12:51 PM
Replies: 21
Views: 6,689
Posted By itizi
multi line fixed field file parsing

I searched the forum for possibilities, but I haven't really gotten anywhere with this...does anyone have suggestions on how I might parse a file that has multiple records with multiple segments-...
Forum: Support 08-21-2014, 11:57 AM
Replies: 6
Views: 2,755
Posted By itizi
Ok thanks, sounds like I need to make a push to...

Ok thanks, sounds like I need to make a push to upgrade to 3.0
Forum: Support 08-21-2014, 08:38 AM
Replies: 6
Views: 2,755
Posted By itizi
sorry for the lack of clarity: in my specific...

sorry for the lack of clarity: in my specific case, I have a database writer as destination, and sometimes the db goes offline for whatever reason, so if something comes in from a filewriter and it...
Forum: Support 08-21-2014, 07:30 AM
Replies: 6
Views: 2,755
Posted By itizi
I know this is a really old thread, but this is...

I know this is a really old thread, but this is the exact issue I'm dealing with right now...does anyone have an example postprocessor script like what asulis mentions?
Forum: Support 06-28-2012, 06:34 AM
Replies: 20
Views: 6,118
Posted By itizi
sql server 2000. I would like it to look like ...

sql server 2000. I would like it to look like

insert into adt (pid,ins1_setno)
values ('156284','1',)

of course I will be putting A LOT more fields in there if I can get this first little...
Forum: Support 06-27-2012, 03:13 PM
Replies: 20
Views: 6,118
Posted By itizi
Here is the code I came up with which doesn't...

Here is the code I came up with which doesn't work:

var queryBuilder = new java.lang.StringBuilder();
queryBuilder.append("INSERT INTO ADT (PID");

var i=0
for each(seg in msg..IN1) {

...
Forum: Support 06-27-2012, 12:30 PM
Replies: 20
Views: 6,118
Posted By itizi
I know this is a really old thread, but I'm...

I know this is a really old thread, but I'm having a similar trouble.. I like StefanScholte's idea, but I'm not sure how to go about appending the insurance parts to the end of the rest of the query,...
Forum: Support 04-19-2012, 02:00 PM
Replies: 1
Views: 2,252
Posted By itizi
msSQL to Hl7

what I've done so far is to insert a select statement in the source and used transformers on the source to map the fields to HL7 fields, and my destination is a file, and I used just...
Showing results 1 to 24 of 24

 
Forum Jump

All times are GMT -8. The time now is 04:38 AM.


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