dbf conversion

[apponline]

Hello.

It was my plan to write software on my pc that could do the following:

1. download the products.dbf file via ftp
2. convert the file to tab delimited
3. update all the products prices
4. convert the file back to dbf
5. upload the newly updated products.dbf file with new prices

Now I am up to step 4 of converting the tab delimited file back to dbf, but have noticed that when I convert the file, all the data is there, but the file is half the size.

I have not tested uploading the file because I am worried about it being half the size of the original file. Is there something wrong with what I am doing or is there another way?

If anyone could help me out or if anyone has done anything similar that could help it would be much appreciated.

Thanks.

[PCINET - Andreas]

Bruce with Phosphormedia has already accomplished what you are doing. Look into Storeman ... it's inexpensive and a great help for offline updates.

[Vic - WolfPaw Computers]

Or just export the products database with the built in utility, open in Excel, edit, save as a csv, and re-import with the built in utility.

[DesignExtend-MSI]

Hello.

It was my plan to write software on my pc that could do the following:

1. download the products.dbf file via ftp
2. convert the file to tab delimited
3. update all the products prices
4. convert the file back to dbf
5. upload the newly updated products.dbf file with new prices

Now I am up to step 4 of converting the tab delimited file back to dbf, but have noticed that when I convert the file, all the data is there, but the file is half the size.

I have not tested uploading the file because I am worried about it being half the size of the original file. Is there something wrong with what I am doing or is there another way?

If anyone could help me out or if anyone has done anything similar that could help it would be much appreciated.

Thanks.


If all you want to do is change the price, you can use Vic's method. Converting isn't necessary at all and would just make a simple job of using an export utility more complicated.

StoreMan (http://www.designextend.com/page/miva/PROD/storeman) is a great program for anyone wanting to maintain all their products (attributes, etc.) offline.

As for actually converting, if you have MS Access you could import the dbf into a table, then make your changes and export it to a flat file.