PROFESSIONAL NEWSGROUPS
WINDEV
,
WEBDEV
and
WINDEV Mobile
Home
|
Recent messages
|
Connect
|
Sign out
|
English
Home
→
WINDEV 2024
→
.dat file conversion HELP
.dat file conversion HELP
Started by Lasse Sandström, Sep., 29 2020 4:30 PM - 7 replies
Connect yourself…
Lasse Sandström
#1
Registered member
19 messages
Posted on September, 29 2020 - 4:30 PM
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
Report
0
0
Argus
#2
Posted on September, 29 2020 - 7:53 PM
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.
Report
0
0
Lasse Sandström
#3
Registered member
19 messages
Posted on September, 30 2020 - 11:36 AM
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
Report
0
0
Lasse Sandström
#4
Registered member
19 messages
Posted on September, 30 2020 - 11:40 AM
But not all characters come in this forum text, this forum removes same ...
Report
0
0
Argus
#5
Posted on September, 30 2020 - 5:58 PM
clearly not a text file...
A google search found this:
https://stackoverflow.com/questions/49221485/clarion-database-dat
so the .dat is NOT topspeed, it's old calrion format, and you need a clarion utility to export it to csv, then you will be able to import in windev...
I suggest that you ask for help here
https://www.wxforum.info/list.php…
where I know that there are a number of ex clarion dev. who are now using windev and will have the needed utility to export as csv
Report
0
0
vvido
#6
Registered member
94 messages
Posted on October, 02 2020 - 1:52 PM
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.
Report
0
0
vvido
#7
Registered member
94 messages
Posted on October, 02 2020 - 2:31 PM
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..
Report
0
0
Lasse Sandström
#8
Registered member
19 messages
Posted on October, 02 2020 - 2:57 PM
Hi,
it was DB ISAM datafile
Thank you
Report
0
0
→ Go back to WINDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (earlier versions)
Français
English
Español
Portuguesa
Close this window
Search type
Only topics
All the messages
Search period
Any time
Past hour
Past 24 hours
Past week
Past month
Past year
Cancel
Preview of your message
Adding an image
Import an image from a URL
Send an image from a file of your disk
Drop a file or click "Browse..."
or
Cancel
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Text