Page 1 of 4
DBF to CSV - converter 3.1 ( Update )
Posted: Thu Oct 18, 2012 9:46 pm
by ukoenig
The first release of the DBF to CSV - converter
Maybe still something missin ? Let me know.
http://www.pflegeplus.com/fw_downloads/DbfCsv3.zip
1. Convert complete ( don't select fields from xBrowse )
2. Convert selected fields from xBrowse
3. Define Date-format
4. Define Memo-structure Multiline or Single-line
5. Define with or without Memo
6. Output with or without Header
7. Output-preview
Don't delete Temp.dbf !!! used at startup for xbrowse
Best Regards
Uwe
Re: DBF to CSV - converter 1.1 ( Download )
Posted: Fri Oct 19, 2012 8:31 am
by Silvio.Falconi
Good Mr Uwe!!
can we set also the Intenational Character UTF-8 ?
When you made a file for csv or csv of Excel you must set :
the data date with dtos
the data Number with str(number)
the data charcter with " " ( but this feature sometimes can be ask ) this if there are specials charcaters as
comma or / < > and others into the text field
the data logic with True e False and not with T or F
yesterday I made a easy function to make it easy . it take all dbf are ina specificy folder and I used Fcreate,fWrite functions to create the csv file.
I saw the informations in this website:
http://www.computerhope.com/issues/ch001356.htm
http://download.cnet.com/DBF-to-CSV/300 ... 05766.html
http://www.facebook.com/note.php?dbf-to ... 6976271759
http://forums.esri.com/Thread.asp?c=93&f=1729&t=210918
Re: DBF to CSV - converter 1.1 ( Download )
Posted: Fri Oct 19, 2012 8:38 am
by avista
Not bad,
Missing option to choose separator (delimiter)
Comma is default separator but most used separator in practice is "|" especially if you use SQL
Probably need to control not to be a binary character.
Best regards,
Re: DBF to CSV - converter 1.1 ( Download )
Posted: Fri Oct 19, 2012 8:58 am
by ukoenig
Silvio, Avista
some more functions can be added.
I think it is no problem.
It is just the basics and the 1. release
Thank You for the response
Best Regards
Uwe
Re: DBF to CSV - converter 1.2 ( Update )
Posted: Fri Oct 19, 2012 4:03 pm
by ukoenig
Update 1.2
Download :
http://www.pflegeplus.com/fw_downloads/dbfcsv2.zip
new :
1. delimiter added
2. save / load Job to / from a INI
Best Regards
Uwe
Re: DBF to CSV - converter 1.2 ( Update )
Posted: Fri Oct 19, 2012 4:57 pm
by avista
Hi,
Error description: (DOS Error 3) DBFNTX/1001 Open error: D:\P_DBF2CSV\DOWNLOAD\clients.dbf
sample mistake at start
Regards,
Re: DBF to CSV - converter 1.2 ( Update )
Posted: Fri Oct 19, 2012 5:37 pm
by ukoenig
I included the INI CSV.INI ( by mystake ) just delete it
I will add a FILE-test because it can be, that the DBF doesn't exist anymore
defined in the UNI.
Best Regards
Uwe
Re: DBF to CSV - converter 1.2 ( Update )
Posted: Fri Oct 19, 2012 5:59 pm
by ukoenig
avista,
Thank You very much for the response.
Fixed a missing DBF, defined inside the INI.
You will get a errormessage and TEMP.dbf is used.
Download :
http://www.pflegeplus.com/fw_downloads/dbfcsv2.zip
Best Regards
Uwe
Re: DBF to CSV - converter 1.2 ( Update )
Posted: Fri Oct 19, 2012 10:16 pm
by avista
Hi,
-MEMOS=.F. (Always is .f.) If it is set to YES in ini file is saved to .f.
-Need to add GET where user can choose OTHER separator (his own) (EXCEL behavior) ... Need to control that separator not to be binary character.
-Show CSV-File ... AngelWriter show nothing
-In XBROWSE what is "LEN" ,,, mean "DEC" ?
-XBROWSE need to be little bigger ... if have fieldname with 10 character "LEN" (probably "DEC") is unvisible
-What is the purpose to choose RDD (dbfntx or dbfcdx) so missed to add option to choose INDEX file ...
not bad to have option to create index file from program too.
-Program CRASH (produce error) int this case: Click "Setup", Click "Exit Converter", Click again "Setup" ...
Code: Select all
Error description: Error DBCMD/1011 Alias already in use: Dump
Stack Calls
===========
Called from: => DBUSEAREA( 0 )
Called from: .\DBFCSV.PRG => CONVERT_DBF( 148 )
Called from: .\DBFCSV.PRG => (b)MAIN( 65 )
Called from: .\source\classes\BTNBMP.PRG => TBTNBMP:CLICK( 465 )
Called from: .\source\classes\BTNBMP.PRG => TBTNBMP:LBUTTONUP( 656 )
Called from: .\source\classes\CONTROL.PRG => TCONTROL:HANDLEEVENT( 1714 )
Called from: .\source\classes\BTNBMP.PRG => TBTNBMP:HANDLEEVENT( 1408 )
Called from: .\source\classes\WINDOW.PRG => _FWH( 3177 )
Called from: => WINRUN( 0 )
Called from: .\source\classes\WINDOW.PRG => TWINDOW:ACTIVATE( 990 )
Called from: .\DBFCSV.PRG => MAIN( 89 )
Some other sugestions next days
Best regards,
Re: DBF to CSV - converter 1.2 ( Update )
Posted: Sat Oct 20, 2012 1:14 pm
by ukoenig
avista
Thank You
the little bugs fixed.
About Index.
I think a sorting on any Field will be a better solution ( optional ) ?
The output file will called SORTED.csv
I noticed, as soon I start with a new project, it grows and grows ....
To get some more ideas, I looked at the Internet, but only basic-functions are offered.
I think, that is the reason, to do something by ourself, until it fulfils our need.
Best regards
Uwe
Re: DBF to CSV - converter 1.2 ( Update )
Posted: Sat Oct 20, 2012 3:51 pm
by Silvio.Falconi
Avista,
-Show CSV-File ... AngelWriter show nothing
you can use also a xbrowse to show the cvs file xbrowse - object ( txtfile class)
Re: DBF to CSV - converter 1.2 ( Update )
Posted: Sat Oct 20, 2012 4:16 pm
by ukoenig
Silvio,
a good idea, optional using xBrowse instead of a external Viewer.
I can select a Field from the 2. xBrowse and create a temporary DUmp.ntx or Dump.cdx
Now the CSV-file is sorted in order of the selected field
The < Sort-button is not needed > because the use is selected from the < Tselect DBF-Sort on Field >
Best Regards
Uwe
Re: DBF to CSV - converter 1.2 ( Update )
Posted: Sat Oct 20, 2012 5:01 pm
by Otto
Hello,
I do have a CSV option inside my program too.
I post this screen only to show how a Metro like design maybe could look.
Best regards,
Otto
Re: DBF to CSV - converter 1.2 ( Update )
Posted: Thu Jan 02, 2014 10:04 am
by glnklein
Guten Morgen , ukoenig
Ich bin ganz neu in diesem forum und kannte bis jetzt FTS garnicht !!!!!
ich möchte eine DBF datei in CSV umwandeln allerdings das ganze nicht immer per maus einstellen müssen , ist es auch möglich dieses coole tool so zu starten das direkt die umwandlung gestartet wird und danach sich das tool
wieder schließt ????
Danke
Re: DBF to CSV - converter 1.2 ( Update )
Posted: Thu Jan 02, 2014 11:22 am
by ukoenig
The question in GERMAN :
Guten Morgen , ukoenig
Ich bin ganz neu in diesem forum und kannte bis jetzt FTS garnicht !!!!!
ich möchte eine DBF datei in CSV umwandeln allerdings das ganze nicht immer
per maus einstellen müssen , ist es auch möglich dieses coole tool so zu starten
das direkt die umwandlung gestartet wird und danach sich das tool
wieder schließt ????
Danke
the question in english :
I want to call the tool and convert a DBF from settings ( INI )
without opening the config-page.
Ja das ist mit einigen kleinen Änderungen möglich.
Vieleicht noch ene COMMAND-line Version hinzufügen ?
Yes, it is possible with some small changes.
maybe still adding a COMMANDLINE-version ?
Viele Grüße
best regards
Uwe