DBF to CSV - converter 3.1 ( Update )

[ukoenig]

Marc,

the CSV-files You are using for the moment
do they include complete field-infos or only data.
If only data where do You get the field-type infos and sizes from.

regards
Uwe

[Marc Venken]

Marc,

the CSV-files You are using for the moment
do they include complete field-infos or only data.
If only data where do You get the field-type infos and sizes from.

regards
Uwe

Uwe,

My csv files that I receive always include a first line with headers :

Code,Naam,Prijs,Maatplus,Minafn,Verpak,Stock
11103250,splitleder amerikaantje gestr.palmverst.,Prijs op aanvraag,,12,120,V
11105100,rundsplit geel gev. gestr.kap,Prijs op aanvraag,,12,120,V
11105400,splitl. handschoen 7cm ecru kap cat 2,Prijs op aanvraag,,12,120,V
11105800,splitlederen hs rood rode kap CAT.II,Prijs op aanvraag,,12,120,V
11106200,splitl. handsch. met palmversterk CAT.II,Prijs op aanvraag,,12,60,V
11106500,splitl. hs. groene pistoolverst. CAT.II,Prijs op aanvraag,,12,60,V
11107000,splitlederen hs groene kap A-kwal.Cat.2,Prijs op aanvraag,,12,120,V
11107011,splitlederen handschoen CE cat 2. mt XXL,Prijs op aanvraag,,12,120,V
11108000,splitlederen handsch. A-kwal. CE 2. geel,Prijs op aanvraag,,12,60,V
11112000,splitlederen handschoen A-kwal.+ nerfver,Prijs op aanvraag,,12,60,V
11116500,varkenslederen hs ongev Bald Eagle.M-XXL,Prijs op aanvraag,,12,72,V
11118100,varkensnerflederen hs geel gevoerd Cat.2,Prijs op aanvraag,,12,120,V
11118150,varkensnerfl.hs geel gev.gestreept Cat.2,Prijs op aanvraag,,12,120,V
11122010,boxlederen hs 10cm canvas ecru kap Cat 2,Prijs op aanvraag,,12,120,V
11124000,boxlederen hs 10 cm gerubb. kap Cat.2,Prijs op aanvraag,,12,120,V

and the program I posted generates a dbf with this line as fields and sizes.
In my case, I convert them all to Char fields for import into Prestashop, so the program is limited to this type of field.
It can not be used for general purposes.

For other csv files, I read them into exel and save them. Then the FW functions can convert to dbf.

Marc

[ukoenig]

Marc,

I finished the first section ( many new functions are included ) like You can see
It is possible now to add some extra fields to the destination DBF before creating a CSV
I would like to add the possibility to change fieldnames and sizes as well

I think
1. adding the new field
2. importing data from the old field to the new one
3. deleting the old field

the 2. part CSV to DBF is nearly finished






regards
Uwe

[Marc Venken]

Marc,

I finished the first section ( many new functions are included ) like You can see
It is possible now to add some extra fields to the destination DBF before creating a CSV
I would like to add the possibility to change fieldnames and sizes as well

I think
1. adding the new field
2. importing data from the old field to the new one
3. deleting the old field

the 2. part CSV to DBF is nearly finished






regards
Uwe

Hey Uwe,

I'm going to take some time to progress in using CSV or XLS files into DBF for further use.

Can you state the last version or if the program is finished ?

Thank

[ukoenig]

Hello Marc,

the last release I stopped was 6.1
for the moment I don't remember the point I changed to another project.
I still remember that I tested to convert in both directions.



The problem was to find a solution, converting from CSV to DBF using a CSV-file
with unknown types and fieldsizes.

FIRST-C-20-0;LAST-C-20-0;STREET-C-30-0;CITY-C-30-0;STATE-C-2-0;ZIP-C-10-0
Homer;Simpson;32179 Maiden Lane;Springfield;IL;20503-8202

FIRST;LAST;STREET;CITY;STATE;ZIP;HIREDATE;MARRIED
Homer;Simpson;32179 Maiden Lane;Springfield;IL;20503-8202;18.09.92;TRUE

a imported CSV-file with missing types and fieldsizes ( needed to create the DBF ).



best regards
Uwe

[Silvio.Falconi]

Uwe, where is th elast version because I tried with a Big Csv and not run ok