Home Forums Discussions Problems Error on preview of formal med record export

Hello,
I recently attempted to export a formal medical record of a particular patient. The process I use is to obtain a preview, and then export as PDF. Unfortunately, with this patient, the process only goes so far, and then I always receive the error shown below in the attached image. The process is then aborted. Other patient record exports proceed normally.
Is there a utility included with amazing charts that could possibly correct this kind of error in the database? It apparently is something as small as a missing single quote mark, to judge by the error explanation.
Amazing charts 8.3

Thanks for any advice.

Hi,

The problem may be the invisible carriage-return chr(13) responsible for the blank line in the middle of your error message before Rare-use-of-alcohol.

***

Crystal Reports can choke on mismatched single-quotes, double-quotes, exclamation marks, and carriage returns.

It's expecting a block of data enclosed by double-quotes with your text internally separated only by '&chr(10)&' like this:

"blah-blah-blah'&chr(10)&'yadda-yadda-yadda'&chr(10)&'and-so-on-to-the-end"

"-------------------'&chr(10)&'---------------------------'&chr(10)&'----------------------------"

It looks as if a &chr(13) is smack in the middle of your data.

Can you use AC 8.3 to edit out the carriage-return/blank line before Rare-use-of-alcohol?

If not, you could shut down AC and the SQL on the server and use a hex editor to find and change the #13 to some ordinary character like x.

***

"This error means that there is an illegal character such as a " or ! or carriage return (Enter key) in some part of the transaction."

https://community.myob.com/t5/Retai...-MISSING-MYOB-RETAIL-MANAGER/td-p/472454

***

Historically, programs have fought over whether to use a carriage-return and line-feed (#13-#10), just a carriage-return (#13), and just a line-feed (#10) as the way to start a new line, so they choke when fed what they consider the wrong invisible characters.


Cheers,

Carl Fogel

I suspected a #13 carriage return, but that's just from my experience, which is from #13-#10 programs.

It's just as likely that there's an extra #10 line-feed before the blank line.

Thank you, Carl. I have used a hex editor many times before, but I'm not sure that I'm intrepid enough to want to open the amazing charts database and risk doing damage to it. There may be multiple instances of this error throughout the record for this patient, as the same text phrase may have been used on multiple occasions (as part of a basis for a new OV for this patient).
I was not aware that we could actually change any text once the individual charts were signed off on. As I understand it, we can only add an addendum, which would not remove the errors.
Or am I mistaken?
Thanks again, I really appreciate your help.
Kurt

Sorry, but I don't know what the restrictions on editing were on 8.3.

All I can say is that the error message looks as if the program chokes on what it considers an unmatched and invisible delimiting character that produces the blank line before Rare-use-of-alcohol, something like a #13-#10 pair, a #13, or just an extra #10.

Thanks, Carl, we'll see if an edit is possible that will fix the offending text.