DBF to CSV - converter 3.1 ( Update )

[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

[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

[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,

[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

[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

[avista]

Hi,

Error description: (DOS Error 3) DBFNTX/1001 Open error: D:\P_DBF2CSV\DOWNLOAD\clients.dbf

sample mistake at start

Regards,

[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

[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

[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  Expand view

  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,

[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

[Silvio.Falconi]

Avista,

-Show CSV-File ... AngelWriter show nothing

you can use also a xbrowse to show the cvs file xbrowse - object ( txtfile class)

[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

[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

[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

[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