| |
Miembro registrado
19 mensajes |
|
| Publicado el 29,septiembre 2020 - 16:30 |
Greeting,
is there any way for Windev 25 to read a data file with a presumably CLARION .dat extension.
the format to be converted can be text, csv or something else from which the data can be imported into the Windev HFSQL database.
And note! I do not have the Clarion program, but I have used Windeviä since 1997, now with version 25.
Thanks if anyone bother to reply and also email reply possible if you want: lsdigiraha [at] gmail.com
Regards,
Lasse S from Finland |
| |
| |
| | | |
|
| | |
| |
| Publicado el 29,septiembre 2020 - 19:53 |
I don' t know clarion but I know that many ex clarion developers came to windev and were able to access the clarion DB via an odbc driver.
However, clarion DB is not text or csv, so either the .dat is clarion DB and 'see above' or it's a text or csv and in that case a simple floadtext followed by a loop on extracstring will do the trick. it's easy to see in notepad++ if it is text content. |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
19 mensajes |
|
| Publicado el 30,septiembre 2020 - 11:36 |
Hi and thanks.
yes I have tried also this and made same scripts, but in Notepad it looks like this:
---------------
Q P c ( ¤‘YW Ô#Á ~ CustNo PartNo CuListPrice 6 2000 Y@ 6 20006007 !„B! @ 6 999 ¤p=
×£À? 6 RAR7438N9P "lxz¥tM@ 200 (@ 238 (@ 3034 ÍÌÌÌÌÌ)@ 30939 333333ó? 39383 333333@
4949 Ãõ(\Â@ 823823 0@ 8821 @
------------
this is firts part part of it.
As Windev 25 |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
19 mensajes |
|
| Publicado el 30,septiembre 2020 - 11:40 |
| But not all characters come in this forum text, this forum removes same ... |
| |
| |
| | | |
|
| | |
| |
| Publicado el 30,septiembre 2020 - 17:58 |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
94 mensajes |
|
| Publicado el 02,octubre 2020 - 13:52 |
You need TOPSCAN.EXE utility which allows you to export data in txt format.
This utility distributed with Clarion (version 10) allows you to open old Clarion .DAT files. |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
94 mensajes |
|
| Publicado el 02,octubre 2020 - 14:31 |
My answer above assumes that this is a one time conversion.
Otherwise you need a Clarion program which would export the data in the desired format.. |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
19 mensajes |
|
| Publicado el 02,octubre 2020 - 14:57 |
Hi,
it was DB ISAM datafile
Thank you |
| |
| |
| | | |
|
| | |