• Page:
  • 1
  • 2

TOPIC: Can't Edit/Execute rrd

Can't Edit/Execute rrd 21 Oct 2015 19:15 #2047

  • shutslar
  • shutslar's Avatar
  • Offline
I am attempting to execute an rrd file with a few records (<10). The rrd is supposed to email a pdf attachment to particular users. The rrd file does not execute and it does not allow me to edit the rrd file in Solution Builder. Any guidance would be appreciated greatly.

Details:
Logicity Pro v1.8.8.0
Windows 7

The email message has a graphic encoded in base64 as an inline html image tag.

Attached is a file with one task in it and a copy of the command line file.
Last Edit: 21 Oct 2015 19:24 by shutslar. Reason: added file attatchments
The administrator has disabled public write access.

Can't Edit/Execute rrd 22 Oct 2015 11:57 #2048

  • mholbrook
  • mholbrook's Avatar
  • Offline
Hello,

If you change the action to view does the report run? i am trying to rule out a report problem before we dig into an email problem. Thansk!

Matt
The administrator has disabled public write access.

Can't Edit/Execute rrd 22 Oct 2015 17:32 #2049

  • shutslar
  • shutslar's Avatar
  • Offline
Thanks. I did find an unrelated service that was causing my problem with emails. I have this resolved. But when I get the email, it is truncating the &msg parameter. The last bit of my &msg parameter reads:
'@kimball.com. <br /><img src="http://www.kimballhospitality.com/images/tempalte/k_hospitality_blue_small.jpg" alt="www.KimballHospitality.com" style="width:314px;height:44px;display:inline-block;">'

It consistently truncates everything after <img src. If I read the rrd file into Solution Builder, it is truncated at the same location. If I copy my entire text into the body box in Solution Builder, it executes perfectly. It is only when I am attempting to execute the rrd file from the command line that it truncates. Is there a limit to how big the &msg parameter can be when executing an rrd file in batch?

edit: The length of the entire &msg parameter is 499 bytes.
Last Edit: 22 Oct 2015 18:07 by shutslar. Reason: added additional info
The administrator has disabled public write access.

Can't Edit/Execute rrd 27 Oct 2015 16:49 #2053

  • RonMoses
  • RonMoses's Avatar
  • Offline
It's more likely a character problem than a length problem. (That's what she said.) ;)

I know that commas will break an RRD line, I'm guessing an equal sign is also problematic, as it's used in the RRD line to assign values to parameters. Logicity is seeing that character, and because it can't make sense of what follows, it's truncating it right there.

So how important is it to have your logo in the email?
The administrator has disabled public write access.

Can't Edit/Execute rrd 27 Oct 2015 17:11 #2054

  • shutslar
  • shutslar's Avatar
  • Offline
I've been informed I can do the logo as a link source or as a base64 string, but I do have to have the logo in the email. Is there another method for including an image in the email body?

Can the program be updated to look for the actual valid parameter names to trigger the parameter functionality? Can it be coded to recognize html tags as strings instead of part of the Logicity command structure? Just wondering what my options are going to be. This particular issue will force me to find another solution if it cannot be resolved quickly. I've really been impressed with Logicity's capabilities and ease of use for this type of work. I truly want to use it if I can.
Last Edit: 27 Oct 2015 17:18 by shutslar. Reason: added additional info
The administrator has disabled public write access.

Can't Edit/Execute rrd 27 Oct 2015 17:24 #2055

  • RonMoses
  • RonMoses's Avatar
  • Offline
Honestly I doubt that code would be interpreted as HTML anyway, even if it didn't break the line. To my knowledge anything in that Body box is going to come through as plain text. I'm looking for a way to do what you need to do, and I'm not seeing it. Maybe if you were putting the report results in the body of the email, you could use the Inline HTML format. But I'm assuming that's not an option here, and I'm not convinced that would work either. Sounds like something that needs to go in the Feature Request forum.
The administrator has disabled public write access.

Can't Edit/Execute rrd 27 Oct 2015 17:25 #2056

  • aellis
  • aellis's Avatar
  • Offline
Ron - you gave me a good laugh with your last comment - thanks for that.

shutslar - I think the issue you are experiencing is one of our nasty limitations with the RRD format. If you have ever opened one of those files up in Notepad you will see that it is basically a one-line-per-action schema and we use the characters & ? ; : , [ ] as delimiters throughout. The most important ones to avoid are & ? ; which I see in your HTML. Could you try boiling this down to not including the style properties to see if that is the issue?
The administrator has disabled public write access.

Can't Edit/Execute rrd 27 Oct 2015 17:27 #2058

  • shutslar
  • shutslar's Avatar
  • Offline
I will give that a try and post results. Thanks for the suggestion.
The administrator has disabled public write access.

Can't Edit/Execute rrd 27 Oct 2015 18:10 #2061

  • shutslar
  • shutslar's Avatar
  • Offline
Well, I removed the style statements. I even removed the http : // in the img src statement. No change. I've attached a copy of the RRD so that you may see what might be causing it . I tried posting just the snippet but it considered it spam.
The administrator has disabled public write access.

Can't Edit/Execute rrd 28 Oct 2015 17:06 #2064

  • RonMoses
  • RonMoses's Avatar
  • Offline
Trying this out on my end, I can see exactly what you see, which is that the Body box displays no text after "src". Interestingly enough, if you open the RRD in Notepad, the rest of the text is still present. So I have to assume = is one of those off-limits characters that Logicity interprets in a specific way... namely, as a parameter assignment. I confirmed this by editing the line in Notepad to read "Everything from the = sign forward is ignored", and sure enough it appears as "Everything from the " in Logicity.

Since I'm not aware of a way to insert an image via HTML without using an = sign, I don't see how this could work.
The administrator has disabled public write access.
  • Page:
  • 1
  • 2