11/25/2024 5:38:40 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.
|
|
|
|
Contents of Notes field on reports gets cut off when it is more than one or two lines long
Posted: 22 Jan 09 12:32 PM
|
Hi Everyone,
I'm in the process of exporting data out of saleslogix into a CSV file. The problem I'm running into is that the contents of the Notes (Contact.History.Notes) field has some limitation on how many character it puts out. Almost all of my notes are very long, couple of paragraphs long and these are coming out half-missing. How do I increase the value of this field to accommodate the longe notes. Or is there a better way to extract the data other than using the query builder which is what I'm using. I'm running SLX 6.1.2.
Thanks in advance. |
|
|
| |
|
Re: Contents of Notes field on reports gets cut off when it is more than one or two lines long
Posted: 23 Jan 09 4:59 AM
|
As far as how to get the data out - If it's a one time thing, I would go to SQL and use the export tools. If this is going to be a regular event with end users involved - script something.
And as already pointed out - the full text is the LongNotes field.
The other issue that you're going to run into is that notes data is "messy" - lots of things that csv hates like commas, carriage returns, embedded quotes, etc. It's hard to get something usable that way.
You might want to try using something along the lines of pipes for separators (the | character) since people rarely use those in notes, and possibly removing the carriage returns. The other thing you might want to do is to use something like ACCESS or XML as your interim storage format.
If you go with ACCESS, you might need some smarts on your receiving side to handle the messy data to retain all of the formatting since Jet/ODBC tends to chop strings off at the carriage return as well.
For XML, make sure to use a CDATA designation on the field.
Good Luck
ws |
|
|
|
Re: Contents of Notes field on reports gets cut off when it is more than one or two lines long
Posted: 23 Jan 09 9:50 AM
|
Thanks everyone,
When running the Query Builder, I'm unable to drag the longnotes down to layout area. This will be a one time extraction as I'm moving things over to Salesoforce. Unfortunately, Salesforce only has csv import feature with their Profession edition. Also, I'm not a database guy, but they tasked me with this. I will have my database guy look at Walter's answer above for xml or access. Anyone else has moved some data to salesforce from saleslogix, please share some ways you have done this. Thanks everyone. Great forum.
|
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|