Solved

Export PFS:FILE format to dbase format

Posted on 1998-04-15
2
768 Views
Last Modified: 2013-11-24
I'm trying to export a file in Pfs:file format to dbase format but only takes first 180 fields using dbase IV IMPORT command. How I Can get all fields (about 500)?
0
Comment
Question by:juanca
2 Comments
 
LVL 9

Accepted Solution

by:
cymbolic earned 100 total points
ID: 1026270
There is an excellent tool for working with .dbf files available on AOL and on the net (look for File Pile), known as DBFLOOK.  With registration comes a set of tools containing an import and export programs for creating .dbf files.  DBFLOOK itself can be used to make a fixed record length extract file become a .dbf by prefixing a dbf header to the file.  It will also create a header to be used as well, allowing you to specify field names, sizes and types. If you can extract the pfs file to a fixed length record format, I can help you use this tool to convert it into a .dbf.

I've worked extensively with the .dbf format in enterprise level applications with hundreds of .dbf files involved.
email me at cymbolic@aol.com if you need more help, or to send a sample file for conversion.
0
 

Expert Comment

by:rbfine
ID: 1026271
If you haven't found an answer, here's what I do:

1. Export the file in fixed length format, if possible.  All the fields at once.  This is also known as an 'SDF' file.

2. Create a dbase structure with fields in it like 'Field1, character 200', 'Field2 Character 200', etc.  You can create up to 254 of them if you need to.  Oops, dBase IV allows more.

3. Append from the SDF file you exported before by using the APPEND FROM ... SDF command.

4. You can then split the fields as necessary, either programmatically or with console commands.  If you pick the field lengths in the 2nd step smartly, you'll have a much easier task of it.

rbfine@finesoft.com

0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question