web stats
New to Mirth connect. Need help configuring - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 12-15-2010, 11:43 AM
ramji1501 ramji1501 is offline
Mirth Newb
 
Join Date: Dec 2010
Posts: 19
ramji1501 is on a distinguished road
Default New to Mirth connect. Need help configuring

I am new to Mirth connect. Am excited about the features and utility of the product.

Just got started with configuring mirth connect for my vendor.

I will tell you what I want achieved, would be great if you could tell me the way to do it.

I would like to map the incoming csv file column values (name, address, dob etc), to variables in javascript, do transformations like date changes with javascript, and then write to oracle database.

I am not clear about what I will setup as source connector inbound, outbound, destination outbound.

Appreciate your help
Reply With Quote
  #2  
Old 12-15-2010, 12:19 PM
MikeCaldwell MikeCaldwell is offline
Where are the forums?
 
Join Date: Mar 2008
Location: Sacramento, CA
Posts: 154
MikeCaldwell
Default Teb dem to sql

Here is a basic channel to get you there, it reads in basic TAB delemited Text file (change to accept commas instead) and then write to MS SQL Database (Which you could change to Oracle with a few tweaks). I would have created an Oracle version as I use them all the time, just didnt have the time.

Load it, look through it and take some time to understand whats going on, then change it to fit your needs.
Attached Files
File Type: xml TABDEM_to_SQL_NEW.xml (10.8 KB, 40 views)
__________________
Mike Caldwell
Alliance HealthCare - GE VAR
Rocklin, CA
Centricity PM/EMR Support - Developer - Network Engineer
http://MirthPRO.Com
Reply With Quote
  #3  
Old 12-15-2010, 12:57 PM
ramji1501 ramji1501 is offline
Mirth Newb
 
Join Date: Dec 2010
Posts: 19
ramji1501 is on a distinguished road
Default

Thanks. Will work with it and let you know the result.
Reply With Quote
  #4  
Old 12-15-2010, 03:30 PM
ramji1501 ramji1501 is offline
Mirth Newb
 
Join Date: Dec 2010
Posts: 19
ramji1501 is on a distinguished road
Default Thanks and couple of questions

I modified the channel with my column names, oracle connectivity etc...but still the column PVID that you defined keeps showing up.

I am not sure if this is a problem with changes not saving. Also, when I look into the errors after deploying the channel, the time shown is wrong. In the channel file, it is mentioned Eastern. My time zone is Mountain. This is not a big concern for me, but the log shows time as 17:08 now, which is not any time zone.
Reply With Quote
  #5  
Old 12-16-2010, 03:45 PM
ramji1501 ramji1501 is offline
Mirth Newb
 
Join Date: Dec 2010
Posts: 19
ramji1501 is on a distinguished road
Default

Worked. I did a mistake while mapping. Thanks.
Reply With Quote
Reply

Tags
configuration, connector, inbound, mirth connect, outbound

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 05:53 PM.


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