Is it possible to show HTML data in dashboard?

Epicor ERP 10
1

Hi Epicor community,

we have some data from our old database before Epicor’s implementation that contains the data in HTML format.
Now I know that is not how data should be stored in terms of transactional data, but here we are.
Now I am wondering if Epicor is capable to present the HTML data in the dashboard grid.

My last resort is to wipe the HTML format from the data but before that I’d like to explore Epicor’s capacity in this context.
Could you please let me know if there is any work-around?

Regards,
Shizar

2

Classic or Kinetic?

3

Classic for now

4

Typical example of html data you would like to display?

for later… might require some, um, creativity.

5

You can’t quite do HTML in there, but you can do formatted text, which is an xml based formatting that is very similar.

You might have to do a little transforming of the data.
That is why I’m asking for a sample.

using Infragistics.Win.UltraWinGrid;

private void epiButtonC1_Click(object sender, System.EventArgs args)
{
/*You can ignore this part, it's just me populating the grid
	DataSet returnDS = FunctionRunner(UD01Form, "FunctionRunnerBAQ", "Test", "FormattedText");
	DataSet dsMessages = JsonConvert.DeserializeObject<DataSet>( returnDS.Tables["Results"].Rows[0]["Calculated_ObjectJson"].ToString() );
	epiUltraGridC1.DataSource = dsMessages.Tables[0];
*/
	epiUltraGridC1.DisplayLayout.Bands[0].Columns[0].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.FormattedText;
	epiUltraGridC1.DisplayLayout.Bands[0].Columns[2].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.FormattedText;
}

formattedText
formattedText714×92 2.55 KB

1 Like
6

And you ghosted me. Again! :rofl:

Comedy Cbc GIF by Run The Burbs

7

Apologies @klincecum
No intention of ignoring you and your help!

Had a super busy work-day.
Would it be possible to implement this in a dashboard?
If not possible, let’s say I create a UD menu and I wish to list all of the transactional data that is in HTML format.
How would I go about that? Should I use a textbox for the field or can I use gridview?

This is the sample of the data and the rendered version. As you can see the data (on the left) is in HTML:

image
image1215×404 25.6 KB

8

And this would be per row? Like that block is one row?

If so, give me the text version. (redacted of course ).

I can advise from there.

9

Yes each row has this column, and not every row is like this, but considerable number of rows are like this:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML><HEAD><STYLE type=text/css> P, UL, OL, DL, DIR, MENU, PRE { margin: 0 auto;}</STYLE><META name=GENERATOR content="MSHTML 9.00.8112.16434"></HEAD><BODY leftMargin=1 rightMargin=1 topMargin=1><DIV><FONT size=2 face="Segoe UI"><DIV>The XXXX status for this project has been updated for the following reason:<BR/><BR/>Quote # <a href="XXXX:QUOTE_15493">15493</a> has been converted to Order # <a href="XXXX:ORDER_12420">12420</a><BR/><BR/>Project ID: <a href="XXXX:PROJECT_103834">103834</a><BR/>Project Name: <a href="XXXX:PROJECT_103834">Spare Parts For Stock</a><BR/>Customer Name: <a href="XXXX:CUSTOMER_B3090552620%C0T(DCas">ABC Company - Salt Lake City</a><BR/><BR/>Triggered By: Shizar<BR/>Changed On: 14 April 2015 - 16:25:03<BR/>Changed To: Accounting Phase -> Credit Pending</DIV></FONT></DIV></BODY></HTML>

I have found a way to clean this up using SQL but I’d rather use what we have since users are used to this representation of data.

Thanks in advance :slight_smile:

10

Hi @klincecum ,

I ended up importing the data in a UD table and then creating a dashboard with a Tracker in which a textbox is embedded through customization.
That TextBox gets the info from that specific column when the selected row is changed, and in the meantime the string in the TextBox gets preprocessed to be stripped from the HTML tags except for Line Breaks.

So I found a work-around.
Now what I need to do is to add a menu for UD table to add new record so that users can use it for further data entry. Is there a good tutorial on this?