it's needful to transfer data from DBF to HTML file . I found samples DBF->XML in this form . But that isn't fully what it's needful for me . Maybe you did something similar ? Can you share ?
With best regards and many thanks in advance !
DBF -> HTML
DBF -> HTML
Hi friends !
it's needful to transfer data from DBF to HTML file . I found samples DBF->XML in this form . But that isn't fully what it's needful for me . Maybe you did something similar ? Can you share ?
With best regards and many thanks in advance !
it's needful to transfer data from DBF to HTML file . I found samples DBF->XML in this form . But that isn't fully what it's needful for me . Maybe you did something similar ? Can you share ?
With best regards and many thanks in advance !
Rimantas U.
Re: DBF -> HTML
Rimantas wrote:Hi friends !
it's needful to transfer data from DBF to HTML file . I found samples DBF->XML in this form . But that isn't fully what it's needful for me . Maybe you did something similar ? Can you share ?
With best regards and many thanks in advance !
I tried DBF -> XML . It generated 3 files from DBF - .xml , .xsl and .htm . But the problem is that I don't know how to view data from this files ...
My main aim is to open such information with Excel - I know I can to do this with DBF's and etc. But that it's needful to do something like that ... Here is a sample , of .htm file :Code: Select all | Expand
<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1257">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">
<link rel=File-List href="ls_etal_200908_bylos/filelist.xml">
<link rel=Edit-Time-Data href="ls_etal_200908_bylos/editdata.mso">
<link rel=OLE-Object-Data href="ls_etal_200908_bylos/oledata.mso">
<!--[if gte mso 9]><xml>
<o:DocumentProperties>
<o:LastAuthor>Rimantas Usevicius</o:LastAuthor>
<o:LastSaved>2009-09-28T17:28:10Z</o:LastSaved>
<o:Version>11.9999</o:Version>
</o:DocumentProperties>
</xml><![endif]-->
<style>
<!--table
{mso-displayed-decimal-separator:"\,";
mso-displayed-thousand-separator:"\.";}
@page
{margin:1.0in 0in 1.0in 0in;
mso-header-margin:0in;
mso-footer-margin:0in;}
tr
{mso-height-source:auto;}
col
{mso-width-source:auto;}
br
{mso-data-placement:same-cell;}
.style0
{mso-number-format:General;
text-align:general;
vertical-align:bottom;
white-space:nowrap;
mso-rotate:0;
mso-background-source:auto;
mso-pattern:auto;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:186;
border:none;
mso-protection:locked visible;
mso-style-name:Paprastas;
mso-style-id:0;}
td
{mso-style-parent:style0;
padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:186;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
border:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:locked visible;
white-space:nowrap;
mso-rotate:0;}
.xl24
{mso-style-parent:style0;
color:black;
font-size:9.0pt;
font-family:Arial, sans-serif;
mso-font-charset:186;
text-align:left;
border-top:none;
border-right:none;
border-bottom:1.0pt solid black;
border-left:none;
white-space:normal;}
.xl25
{mso-style-parent:style0;
color:black;
font-size:9.0pt;
font-family:Arial, sans-serif;
mso-font-charset:186;
text-align:right;
border-top:none;
border-right:none;
border-bottom:1.0pt solid black;
border-left:none;
white-space:normal;}
.xl26
{mso-style-parent:style0;
color:black;
font-size:9.0pt;
font-family:Arial, sans-serif;
mso-font-charset:186;
text-align:left;}
.xl27
{mso-style-parent:style0;
color:black;
font-size:9.0pt;
font-family:Arial, sans-serif;
mso-font-charset:186;
text-align:right;}
.xl28
{mso-style-parent:style0;
color:black;
font-size:9.0pt;
font-family:Arial, sans-serif;
mso-font-charset:186;
mso-number-format:Standard;
text-align:right;}
.xl29
{mso-style-parent:style0;
color:black;
font-size:9.0pt;
font-family:Arial, sans-serif;
mso-font-charset:186;
mso-number-format:"\#\,\#\#0";
text-align:right;}
.xl30
{mso-style-parent:style0;
color:black;
font-size:9.0pt;
font-weight:700;
font-family:Arial, sans-serif;
mso-font-charset:186;
text-align:left;
white-space:normal;}
.xl31
{mso-style-parent:style0;
color:black;
font-size:9.0pt;
font-weight:700;
font-family:Arial, sans-serif;
mso-font-charset:186;
text-align:left;}
.xl32
{mso-style-parent:style0;
color:black;
font-size:9.0pt;
font-weight:700;
font-family:Arial, sans-serif;
mso-font-charset:186;
text-align:right;}
.xl33
{mso-style-parent:style0;
color:black;
font-size:9.0pt;
font-weight:700;
font-family:Arial, sans-serif;
mso-font-charset:186;
mso-number-format:Standard;
text-align:right;}
.xl34
{mso-style-parent:style0;
color:black;
font-size:9.0pt;
font-weight:700;
font-family:Arial, sans-serif;
mso-font-charset:186;
mso-number-format:"\#\,\#\#0";
text-align:right;}
-->
</style>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>ls_etal_200908</x:Name>
<x:WorksheetOptions>
<x:Print>
<x:ValidPrinterInfo/>
<x:PaperSizeIndex>9</x:PaperSizeIndex>
<x:HorizontalResolution>-3</x:HorizontalResolution>
<x:VerticalResolution>0</x:VerticalResolution>
</x:Print>
<x:Selected/>
<x:DoNotDisplayGridlines/>
<x:Panes>
<x:Pane>
<x:Number>3</x:Number>
<x:ActiveRow>5</x:ActiveRow>
<x:ActiveCol>1</x:ActiveCol>
</x:Pane>
</x:Panes>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:WindowHeight>8955</x:WindowHeight>
<x:WindowWidth>15195</x:WindowWidth>
<x:WindowTopX>0</x:WindowTopX>
<x:WindowTopY>15</x:WindowTopY>
<x:ProtectStructure>False</x:ProtectStructure>
<x:ProtectWindows>False</x:ProtectWindows>
</x:ExcelWorkbook>
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026"/>
</xml><![endif]--><!--
Subject:
Author: Microsoft Business Solutions-Axapta 3.0 Build #1951.4060 (Jan 5 2005) HTML Generator version 1.0
JobId: 77624800
Operator rusev
Generated 17-9-2009 9:34:20
Printed (-)
-->
</head>
<body link=blue vlink=purple>
<table x:str border=0 cellpadding=0 cellspacing=0 width=1838 style='border-collapse:
collapse;table-layout:fixed;width:1383pt'>
<col width=115 style='mso-width-source:userset;mso-width-alt:4205;width:86pt'>
<col width=256 style='mso-width-source:userset;mso-width-alt:9362;width:192pt'>
<col width=82 style='mso-width-source:userset;mso-width-alt:2998;width:62pt'>
<col width=69 style='mso-width-source:userset;mso-width-alt:2523;width:52pt'>
<col width=73 style='mso-width-source:userset;mso-width-alt:2669;width:55pt'>
<col width=69 style='mso-width-source:userset;mso-width-alt:2523;width:52pt'>
<col width=58 style='mso-width-source:userset;mso-width-alt:2121;width:44pt'>
<col width=62 style='mso-width-source:userset;mso-width-alt:2267;width:47pt'>
<col width=60 style='mso-width-source:userset;mso-width-alt:2194;width:45pt'>
<col width=81 span=2 style='mso-width-source:userset;mso-width-alt:2962;
width:61pt'>
<col width=62 style='mso-width-source:userset;mso-width-alt:2267;width:47pt'>
<col width=57 style='mso-width-source:userset;mso-width-alt:2084;width:43pt'>
<col width=68 style='mso-width-source:userset;mso-width-alt:2486;width:51pt'>
<col width=74 span=2 style='mso-width-source:userset;mso-width-alt:2706;
width:56pt'>
<col width=199 style='mso-width-source:userset;mso-width-alt:7277;width:149pt'>
<col width=80 span=2 style='mso-width-source:userset;mso-width-alt:2925;
width:60pt'>
<col width=138 style='mso-width-source:userset;mso-width-alt:5046;width:104pt'>
<col width=92 style='mso-width-source:userset;mso-width-alt:3364;width:69pt'>
<tr height=18 style='height:13.5pt'>
<td height=18 class=xl24 width=115 style='height:13.5pt;width:86pt'
bordercolor="#000000">Modelis</td>
<td class=xl25 width=256 style='width:192pt' bordercolor="#000000">Kaina</td>
<td class=xl24 width=82 style='width:62pt' bordercolor="#000000">Sandėlis</td>
<td class=xl25 width=69 style='width:52pt' bordercolor="#000000">Uzsakyta</td>
<td class=xl25 width=73 style='width:55pt' bordercolor="#000000">Lik.pradziai</td>
<td class=xl25 width=69 style='width:52pt' bordercolor="#000000">Lik.suma</td>
<td class=xl25 width=58 style='width:44pt' bordercolor="#000000">Pajamos</td>
<td class=xl25 width=62 style='width:47pt' bordercolor="#000000">Paj.suma</td>
<td class=xl25 width=60 style='width:45pt' bordercolor="#000000">Paj.gam.</td>
<td class=xl25 width=81 style='width:61pt' bordercolor="#000000">Gamyb.suma</td>
<td class=xl25 width=81 style='width:61pt' bordercolor="#000000">Islaidos</td>
<td class=xl25 width=62 style='width:47pt' bordercolor="#000000">Isl.suma</td>
<td class=xl25 width=57 style='width:43pt' bordercolor="#000000">Parduota</td>
<td class=xl25 width=68 style='width:51pt' bordercolor="#000000">Pard.suma</td>
<td class=xl25 width=74 style='width:56pt' bordercolor="#000000">Lik.pabaigai</td>
<td class=xl25 width=74 style='width:56pt' bordercolor="#000000">Lik.suma</td>
<td class=xl24 width=199 style='width:149pt' bordercolor="#000000">Pavadinimas</td>
<td class=xl24 width=80 style='width:60pt' bordercolor="#000000">Klientų
grupė</td>
<td class=xl24 width=80 style='width:60pt' bordercolor="#000000">Tarpt.kodas</td>
<td class=xl24 width=138 style='width:104pt' bordercolor="#000000">Model.kolekcija</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl26 style='height:12.75pt' x:num>4304</td>
<td class=xl27 x:num="62.15">62,15</td>
<td class=xl26>LS etalonai</td>
<td class=xl27></td>
<td class=xl27 x:num>1</td>
<td class=xl27 x:num="62.15">62,15</td>
<td colspan=8 class=xl27 style='mso-ignore:colspan'></td>
<td class=xl27 x:num>1</td>
<td class=xl27 x:num="62.15">62,15</td>
<td class=xl26>TRIUMPH INTERNATIONAL AG</td>
<td class=xl26>ES</td>
<td class=xl26 x:num="6108310000">6108310000</td>
<td class=xl26></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl26 style='height:12.75pt' x:num>4341</td>
<td class=xl27 x:num="23.82">23,82</td>
<td class=xl26>LS etalonai</td>
<td class=xl27></td>
<td class=xl27 x:num>1</td>
<td class=xl27 x:num="23.82">23,82</td>
<td colspan=8 class=xl27 style='mso-ignore:colspan'></td>
<td class=xl27 x:num>1</td>
<td class=xl27 x:num="23.82">23,82</td>
<td class=xl26>TRIUMPH INTERNATIONAL AG</td>
<td class=xl26>ES</td>
<td class=xl26 x:num="6109100000">6109100000</td>
<td class=xl26></td>
</tr>
Rimantas U.
Re: DBF -> HTML
Hi !
It seems that nobody can't to help ...
. OK , lets quest from other side . How to open htm ( + xml + xsl - don't know really which ? ) file , which I can generate with that : viewtopic.php?f=3&t=14362&hilit=xml&start=15 ( Stefan answer to Anser ) ? With Excel ?
With best regards !
It seems that nobody can't to help ...
. OK , lets quest from other side . How to open htm ( + xml + xsl - don't know really which ? ) file , which I can generate with that : viewtopic.php?f=3&t=14362&hilit=xml&start=15 ( Stefan answer to Anser ) ? With Excel ?With best regards !
Rimantas U.
Re: DBF -> HTML
Rimantas,
Maybe i did not understand exactly your needs, but you can try the "dbf to html converter" from "White Town". The demo converts up to 50 records.
There is a trick: if you rename an html file containing a table to .xls, the Excel opens it correctly with "no questions asked".
Best regards
Euclides
Maybe i did not understand exactly your needs, but you can try the "dbf to html converter" from "White Town". The demo converts up to 50 records.
There is a trick: if you rename an html file containing a table to .xls, the Excel opens it correctly with "no questions asked".
Best regards
Euclides
Re: DBF -> HTML
Euclides wrote:Rimantas,
Maybe i did not understand exactly your needs, but you can try the "dbf to html converter" from "White Town". The demo converts up to 50 records.
There is a trick: if you rename an html file containing a table to .xls, the Excel opens it correctly with "no questions asked".
Best regards
Euclides
Thanks for your sugestion !
Sorry , but it's needful this convert with FWH application . It seems that I will to learn about HTML's . Simply I hoped that something similar alreday exist and doing some modifiation can achieve succes results ...
With best regards !
Rimantas U.
Re: DBF -> HTML
Rimantas,
This code will create a HTML file with the DBF in the table
*------------------------------
cTxt ="<HTML>"+CRLF+"<BODY>"+CRLF+"<TABLE border=1>"
do while !eof()
cTxt+="<tr>"+CRLF
for y=1 to fcount()
cTxt+="<td width=60 align=left>"+cValToChar(fieldget( y ))+"</td>"+CRLF
next
cTxt+="</tr>"+CRLF
dbskip()
enddo
cTxt+="</table>"+CRLF
cTxt+="</BODY>"+CRLF+"</HTML>"+CRLF
Memowrit("table.htm", cTxt)
*-----------------------------
Depending of the type of fields, you can play with the "width" and the "align" parameters in the "<TD" tag to adjust the table to your needs.
There is no much things to learn
HTH
regards, Euclides
This code will create a HTML file with the DBF in the table
*------------------------------
cTxt ="<HTML>"+CRLF+"<BODY>"+CRLF+"<TABLE border=1>"
do while !eof()
cTxt+="<tr>"+CRLF
for y=1 to fcount()
cTxt+="<td width=60 align=left>"+cValToChar(fieldget( y ))+"</td>"+CRLF
next
cTxt+="</tr>"+CRLF
dbskip()
enddo
cTxt+="</table>"+CRLF
cTxt+="</BODY>"+CRLF+"</HTML>"+CRLF
Memowrit("table.htm", cTxt)
*-----------------------------
Depending of the type of fields, you can play with the "width" and the "align" parameters in the "<TD" tag to adjust the table to your needs.
There is no much things to learn
HTH
regards, Euclides
Re: DBF -> HTML
Euclides wrote:Rimantas,
This code will create a HTML file with the DBF in the table
*------------------------------
cTxt ="<HTML>"+CRLF+"<BODY>"+CRLF+"<TABLE border=1>"
do while !eof()
cTxt+="<tr>"+CRLF
for y=1 to fcount()
cTxt+="<td width=60 align=left>"+cValToChar(fieldget( y ))+"</td>"+CRLF
next
cTxt+="</tr>"+CRLF
dbskip()
enddo
cTxt+="</table>"+CRLF
cTxt+="</BODY>"+CRLF+"</HTML>"+CRLF
Memowrit("table.htm", cTxt)
*-----------------------------
Depending of the type of fields, you can play with the "width" and the "align" parameters in the "<TD" tag to adjust the table to your needs.
There is no much things to learn
HTH
regards, Euclides
Thanks Euclides ,
Your example will help to me . Something similar I begin . And as you mentioned - stoped with such stuf as "width" . How to understand this "width" ? Pixels ? . Also it's needful to create pages - they will be not the same length , something like subtotals in excel ... Thanks you again ...
Regards !
Rimantas U.
Re: DBF -> HTML
Hi Rimantas,
About your question:
1 - "width" is in REAL pixels (a widt=100, will alow 10 columns in a 1024 rsolution screen).
2 - html "page break" in excel - have no idea about, sorry
Good luck
Euclides
About your question:
1 - "width" is in REAL pixels (a widt=100, will alow 10 columns in a 1024 rsolution screen).
2 - html "page break" in excel - have no idea about, sorry
Good luck
Euclides