IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
  • 1.  Display txt files content with SQL

    Posted Fri August 21, 2020 10:49 AM

    Hello,

    I need to display txt files content in Mashzone.
    For that I parse my txt files in SQL-SQLSERVER using varbinary and I’m using a SQL Query to have the txt files content.

    In my dashboard I have a rich text area to display the result of my query. But only a part of my query result is show in this widget. It’s look like txt files content are truncate when I view my dashboard.

    How can I do for having all content of my txt files ?

    Regards


    #webMethods
    #MashZone-NextGen


  • 2.  RE: Display txt files content with SQL

    Posted Fri August 21, 2020 12:35 PM

    Hello,

    MashZone supports 2000 characters max per table cell. If more characters are to be processed the result will be truncated. One solution could be to split the text into paragraphs of 2000 characters and to load these into different feed columns. These could be assigned to the rich text widget and will thereby show longer texts.

    If the text files do not change the content could perhaps be added to the rich text widget directly.

    Kind regards,
    Christian


    #webMethods
    #MashZone-NextGen


  • 3.  RE: Display txt files content with SQL

    Posted Mon August 24, 2020 11:31 AM

    Thank you for your answer, I will try that.

    The text fils can be change, so it can’t be added to the rich text widget directly


    #webMethods
    #MashZone-NextGen


  • 4.  RE: Display txt files content with SQL

    Posted Wed October 28, 2020 09:34 AM

    Hi Adrien,

    I had as well a problem with the character length in the cells.
    You could adjust the mashzone.properties file (located …\MashZoneNG\apache-tomcat\webapps\mashzone\WEB-INF)
    and add this line “mashzone.cell.characterlength = 5000” .
    Maybe you have to check your version because this adaption just works since a certain Version or Fix I can´t remember the exact Version or Fix but maybe someone of the SAG-Team can help here.
    Kind regards,
    Manuel


    #MashZone-NextGen
    #webMethods


  • 5.  RE: Display txt files content with SQL

    Posted Wed October 28, 2020 10:26 AM

    Hi Manuel,

    It’s working on Mashzone 10.5 !

    Thank you for solving this case.

    Regards


    #webMethods
    #MashZone-NextGen