Save as HTML

anders.lidgren · 1999-12-03

Have anyone any solution to problems with pagebreaks in reports saved as HTML.

I've a customer that looses a few row's att every pagebreak. When he saves a orderconfirmation as HTML, and then send it by e-mail to a vendor the row's disapear. If i look at the html-text in the document, all the row's are there. I've open the document in IE4.

The client-version is 2.00 and the database is 1.20

Luc_VanDyck · 1999-12-03

I think there is no much you can do about it. It is a 'black box' routine: if it works, then fine. But if it doesn't, you are sorry.

Navision uses <TABLE>-, <TR>- and <TD>-tags a lot to format the pages. Probably there is an error during the conversion-process.

[This message has been edited by Luc Van Dyck (edited 03-12-1999).]

John_Tegelaar · 1999-12-11

For e-mailing documents to suppliers and others, we are using a PDF Printer Driver from Amyuni (see www.amyuni.com). This mimics a normal printer for your application, but generates a PDF-file as output. PDF files are small and with the free Adobe Acrobat Reader it's easy to put on screen or print out on paper at the recipient's side. Additional benefit is that's difficult to change the contents.

In case you would like to stick to HTML format, Amyuni has a HTML printer driver as well.

John Tegelaar
Duolink BV
The Netherlands

Andreas_Lundin · 1999-12-20

Hi!

I've made a solution on exporting/displaying Navision data into HTML-format. I'm still working on the final version, but's it's getting there.

HTML-generator

I've created a prototype HTML-generator for Navision. The generator is using a codeunit, that writes HTML/JavaScript-tags and wraps the Navision data into HTML-file. It's very fast, and the output generates a structure of HTML-files. I've tested it on the the following subjects:

1. General Ledger and postings
2. Vendor and vendor postings
3. Customer and customer postings

It generates a total output within 2 - 5 minutes on a regular database, so it's possible to make multiple updates per day. It's could be useful when generating data for a company intranet or the Internet.

The current HTML-structure - as viewed by the browser - created is the following(the general Ledger is uses as example):

<SECTION 1>
Company name: Economy Unlimited
Company address: The Solar System 1
etc....

Description:

Section 1 is a general company description of the current company.

Section 2 is a clickable menu of all accounts in the current General Ledger. This section/menu is used to navigate between all General Ledger accounts.

Section 3 is displaying the postings on the the account selected in Section 2.

All HTML-formatting is done within the codeunit - even the color settings for the HTML-pages. I've not added picture support yet, but it's very simple to add graphic tags into the output. So, the only limitation is your imagination <img border="0" title="" alt="" src="images/smiles/icon_smile.gif" />.

I'm also using the project as a practice. I'm an intermediate experienced C++, HTML- and Java programmer, so I'm using the project as a personal workshop.
The solution is not time consuming, and the HTML-files doesn't use that many MB on the harddisk. HTML-files is simple textfiles, so a General Ledger output from a medium database/customer will use approx. 3 - 10 MB on the harddisk.

If you would like to see a HTML-sample of the output, please be free to contact me on.

Regards
Andreas Lundin
System programmer

Luc_VanDyck · 1999-12-21

Andreas,

Is there any change you make the sources available?

Andreas_Lundin · 1999-12-22

Hi again!

I'm not planning on releasing my source code, for the time beeing. At least not for the next month or so(maybe sometime during January next year). I would like to have a final solution ready before I release my notes/code. Maybe I'll release some codecuts at the end og December in order to give some hints on how you could develop your own solution. I have been developing the solution only for my own educational purpose.

I'm not able to predict whether there's a market out there for this kind of tool or not. But my intentions by describing my solution in this forum, what to give other developers an idea on how they can develop HTML-solutions.

I also have made a raw version of a codeunit(combined with a C-program) that can convert a range of Navision data into a structure of PDF-files. I'll try to describe this solution later on.

Regards
Andreas

Dennis_Decoene · 1999-12-29

It would really be great to see how such a thing is done. does it work with active-x components or pure C/AL?

Andreas_Lundin · 1999-12-30

Hi!

The current solution is done 100 % by the use of a Navision codeunit. But I'm also considering an ocx(ActiveX) solution.

So, wrapping the solution in an ocx-control will take at least two weeks, because I have to learn something about programming a ocx control. I have never done that <img border="0" title="" alt="" src="images/smiles/icon_smile.gif" />. But it's never too late to learn new stuff.

I'll drop a note on this forum when I have a prototype, and I send it to you, if you're still interested. OK?

Regards
Andreas

Luc_VanDyck · 1999-12-30

Andreas,

I can provide a download-section on mynavision.net, so your programs can be evaluated by some experienced NF-developers.

Andreas_Lundin · 1999-12-30

Hi Luc!

I think it is a great idea to create this download area. I'll post a reply when I have something ready. OK?

Regards
Andreas

Andreas_Lundin · 2000-01-03

Hi!

I've managed to make a beta version of an ocx control handling data --> HMTL. So, it's problably ready by the end of the week.

I'll drop a note, when I'm ready.

Regards
Andreas

Dennis_Decoene · 2000-01-04

Andreas, could you at least give us a hint on how you tackled the problem in pure C/AL?

Andreas_Lundin · 2000-01-05

Hi!

Here's some code giving you a skeleton to tailor your own code. The code makes a html-file with Navision data in a table grid. If you have any questions, please be free to post the on this forum.

fHtmlTable.TEXTMODE(TRUE);
fHtmlTable.CREATE('D:\TABLE.HTM');
fHtmlTable.OPEN('D:\TABLE.HTM');
fHtmlTable.WRITE('<HTML>');
fHtmlTable.WRITE('<HEAD> Headline </HEAD>');
fHtmlTable.WRITE('<BODY>');
fHtmlTable.WRITE('<TABLE WIDTH=100% BORDER=2>');
fHtmlTable.WRITE('<TH>Number</TH>');
fHtmlTable.WRITE('<TH>Name</TH>');
fHtmlTable.WRITE('<TH>Amount</TH>');
fHtmlTable.WRITE('<TH>Total Amount</TH>');

rHtml.FIND('-');
REPEAT
fHtmlTable.WRITE('<TR>');
fHtmlTable.WRITE('<TD>');
fHtmlTable.WRITE(rHtml.Number);
fHtmlTable.WRITE('</TD>');
fHtmlTable.WRITE('<TD>');
fHtmlTable.WRITE(rHtml.Name);
fHtmlTable.WRITE('</TD>');
fHtmlTable.WRITE('<TD>');
fHtmlTable.WRITE(rHtml.Amount);
fHtmlTable.WRITE('</TD>');
fHtmlTable.WRITE('<TD>');
fHtmlTable.WRITE(rHtml."Total amount");
fHtmlTable.WRITE('</TD>');
fHtmlTable.WRITE('</TR>');
UNTIL rHtml.NEXT = 0;

fHtmlTable.WRITE('</TABLE>');
fHtmlTable.WRITE('</BODY>');
fHtmlTable.WRITE('</HTML>');
fHtmlTable.CLOSE();

Regards
Andreas

Andreas_Lundin · 2000-01-05

Oops!

I can se, that my prior mail is a little bit messed up. The system seems to interprete my code sample into a HTML table. That was not my intention, so if you want to have a readable version, please drop a note stating your E-mail, and I send a copy to you.

Regards
Andreas

Andreas_Lundin · 2000-01-05

Hi Luc!

Is it possible for you to supply a download area for sample code. Then I will send you a text file containing the code samples.

Regards
Andreas

Andreas_Lundin · 2000-01-07

Hi!

I have made a small sample ocx(ActiveX) control transforming Navision data into a HTML-grid. I have made a zipfile containing the ocx, register program(ocx), Navision sample code(integrating with the ocx) and a small document describing the ocx.

It was my intention that it should by able to download the sample from this sight, but I haven't heard from Luc. So I working on a download area elsewhere.

I will also place the prior Navision sample in this download area(if it's possible to create a download area).

I'll inform you in this forum, when I have created a download place.

Regards
Andreas

Luc_VanDyck · 2000-01-08

Andreas,

Did you receive my e-mail concerning the download section? If you send your files to webmaster@mynavision.net, with a short description, I will include them in the appropriate area.

Please keep in mind that there are lawyers of Navision on my back! So I have also other things that need to be settled.

Luc_VanDyck · 2000-01-12

Andreas,

Your code is included in the download-section.

Thank you for your contribution!

Save as HTML

Comments

Categories