FiveTech Software tech support forums

by **Rimantas** » Mon Sep 28, 2009 5:06 pm

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 !

by **Rimantas** » Mon Sep 28, 2009 5:35 pm

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 view: <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">  <style>  </style>  </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>

by **Rimantas** » Tue Sep 29, 2009 4:14 pm

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 !

by **Euclides** » Thu Oct 01, 2009 2:14 pm

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

by **Rimantas** » Thu Oct 01, 2009 5:09 pm

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 !

by **Euclides** » Thu Oct 01, 2009 6:16 pm

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

by **Rimantas** » Thu Oct 01, 2009 6:34 pm

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 !

by **Euclides** » Thu Oct 01, 2009 6:59 pm

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

FiveTech Software tech support forums

DBF -> HTML

DBF -> HTML

Re: DBF -> HTML

Re: DBF -> HTML

Re: DBF -> HTML

Re: DBF -> HTML

Re: DBF -> HTML

Re: DBF -> HTML

Re: DBF -> HTML

Who is online