[Stewart]

I have a msg that needs to be divided into 2 different msgs since it contains 2 results.

[Stewart]

I think I may understand what’s going on.

• This reply was modified 1 year, 10 months ago by Stewart.

[Stewart]

I have attached screenshots.

Attachments:

You must be logged in to view attached files.

[Stewart]

the template won’t work since it’s gotta based on another vendor spec.  I have the proc, just can’t get it output the file.

[Stewart]

I have the tcl placed in the TPS Outbound Data field of the Outbound tab in netconfig.  I resend the msg and it get’s stuck and never creates the file.  Do you have have any examples of the tcl used to write the msg to a file?

[Stewart]

updates

[Stewart]

the query will match on 2 things, category and mnemonic.

[Stewart]

How do you handle a lookup that has more than one condition?

 

set procid [tbllookup its_proc_id.tbl $categoryID $procedureMnemonic

[Stewart]

I opened a ticket about this a bit back and from what I understand this feature isn’t yet available even though it is included in the documentation.

[Stewart]

I found the solution.  I had to use fconfigure.

set codedString “<base64 string>”
set outfile [open <filename>.pdf w+]
fconfigure $outfile -encoding binary -translation binary
puts $outfile [base64::decode $codedString]
close $outfile

[Stewart]

I was able to create the file and based on the file contents it looks to have decoded the string.  However, the PDF is blank.  Thoughts?

[Stewart]

The tables and their configurations in the database.  I did find the solution/work around.  I couldn’t get the schema to load from the database configurations in site preferences.  I had to create the schema in Cloverleaf under database schemas after creating the connection.  I still couldn’t get it load from site settings / db configs however I am able to use the sqlite db now.

Attachments:

You must be logged in to view attached files.

[Stewart]

I can and execute .schema successfully.

[Stewart]

adding email notifications

 

[Stewart]

I had that checked in the properties.  However it still seems to be recreating the file.  I need a new file everyday and am naming on the date.  I’ve added the OBAPPEND as suggested to see if this will work.

 

set systemTime [clock seconds]
set datetimestring [clock format $systemTime -format %Y%m%d]

set new_name “”
append new_name $name $datetimestring $suffix
msgmetaset $mh DRIVERCTL “{FILESET {{OBFILE $new_name}{OBAPPEND 1}}}”
lappend dispList “CONTINUE $mh”

[Author]

Replies