Does anyone have SCAuto running with a SQL RDMS?

[daurkin]

I'm having a little problem using SCAuto Email as it processes emails with a multi-line ticket description. I'm curious if it's due to our system running on SQL. Here's what I found.

The Event In record details show the description field with text and 'thick horizontal bars' where the carriage return would be.

When it processes the event, the ticket description has stripped the carrage returns and replaced it with a period. Now a ticket decription that has a very long body and multiple carrage returns becomes one long line and it takes a long time for a tech to re-format the description and replace the right periods.

When I test the same Event In record on the OTB system, the description works as it should. The carrage returns are added to the description.

My next test is going to see if I can map my OTB to SQL and see what happens but I'd really like some input if it does work on SQL in your installation. Peregrine support has been looking in to for about a week now.

[casper]

We are running SCAUTO with SQL rdbms. We had the same issue and we had to force carriage returns for each line in the description within the email. Use the pipe character(|) for the carriage return. For example, if you want a double space between line1 and line2:

this is line1
||this is line 2

[margygrey]

You can actually specify the Element Seperator with Carriage return by magnifying the field and click enter, it will give you 2 squares.