Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Exporting text field t...
Microsoft Dynamics GP (Archived)

Exporting text field that have more than 255 characters in Smartlist

(0) ShareShare
ReportReport
Posted on by Community Member

Hi everyone,

I don't seem to find this information anywhere in the Community or in the GP documentation. I'd like your advise please.

Lately, I encounter a reaction in Smartlist that let me thinking! Seems like Smartlist can only extract the first 255 characters for a DB text field. My interrogation pointing to the field "Additional Information" that can be reach in the Customer> Internet Information (blue round icon right of the Adresse Code) > Additional Information (column "INetInfo" in the DB SY01200). In the DB, this field can contain 32000 characters and my client is using more than 255 characters.

The sad part about it is that we have a Smartlist that extract (the first 255 char) from this field but also an IM integration built to integrate this information back in GP that let us modify many customers in one convenient action. You imagine my client surprise when a field of, lets say 1000 characters, get stripped of its last 745 characters.

I can strip the field from the Smartlist but before that I'd like to confirm that this Smartlist reaction is normal! Can we only get the 255 first characters from GP DB by Smartlists ? Is there any way to extract more from characters ?

Any thoughts would be welcome.

Sorry for my sluggish english and thank you for your attention.

Have a nice day,

Olivier

*This post is locked for comments

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Exporting text field that have more than 255 characters in Smartlist

    I see..

    It shouldn't technically be too complicated to mimic the same column names from the SL to an Excel report (Query), and once it's built, the column name doesn't change anymore and can be refreshed at will....

    it's up to you if you want to spend the effort to replicate that content.. but if your customer doesn't really need that 'memo' field, it's probably not worth it.

  • Community Member Profile Picture
    Community Member on at
    RE: Exporting text field that have more than 255 characters in Smartlist

    Hi,

    I tried the Excel Report Builder from SL but it can't do the exact same thing that the SL does (columns with same name, using french accent).

    Since your experimenting the same "max 255 char" issue, I guess i'll just suppress the field from the SL and from the IM integration. This field will now only be manually modified. The field is only used for users notes! I'll validate with my users but I don't think it's gonna matter too much!

    Once again, thx for your help.

    Have a nice day!

  • Community Member Profile Picture
    Community Member on at
    RE: Exporting text field that have more than 255 characters in Smartlist

    Once again, thanks a lot for your swift answer Béat! :¬)

    I'll give a try to the EXCEL export! I'm gonna have to try it against my IM integration!!

    I'll keep you posted!

    Meanwhile, if a MS support engineer passes by ... can we confirm this limitation ?

    thx for your time,

    Olivier

  • Verified answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Exporting text field that have more than 255 characters in Smartlist

    Olivier,

    I tested out the scenarios in GP 2018 by adding the Internet Address table to the existing Customers default smartlist and exported it to Excel.. it only exported 253 characters from the field, though I had copied a large chunk of text from the GP user guide..

    I then create an Excel report with ERB based on the same source (CustomerAddress SQL view & InternetAddres table SY01200).. and run the report to pull the data from the GP company.. and the data from the INetInfo field was showing in its integrity..

    The 253 chars limitation must be an heritage from the old DOS days where Great Plains was developed initially.. this would have to be confirmed by some Microsoft support engineer..

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Exporting text field that have more than 255 characters in Smartlist

    Bonjour Olivier,

    I haven't confirmed yet the limitation of the 255 characters in the SmartList export (which wouldn't surprise me ), but have you tried to use Excel Report Builder instead of SmartLists ? Excel wouldn't have that limitation (pretty sure about it)..

    I'm going to test your scenarios out in GP 2013R2 & 2018 to see if it behaves the same way..

    PS: I've seen worse English than yours on this forum :-)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans