Share via

Simplest form to get JSON from a .dbf in Visual Fox pro 9.0 to import to an ASI?

Larry Nuñez 46 Reputation points
2026-05-02T12:41:59.09+00:00

What is the simplest form to get JSON format from a .dbf in Visual Fox pro 9.0 to import to an ASI?

Developer technologies | Visual Studio | Other
Developer technologies | Visual Studio | Other

A family of Microsoft suites of integrated development tools for building applications for Windows, the web, mobile devices and many other platforms. Miscellaneous topics that do not fit into specific categories.

0 comments

Answer accepted by question author

kagiyama yutaka 3,430 Reputation points
2026-05-10T10:31:16.4833333+00:00

I think that first do set null off… it steadies the old dbf header so it stops breaking json. Then run copy to out.json type json… that’s the simplest true path in vfp9sp2.

Was this answer helpful?

3 people found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest

  1. AI answer

    2026-05-02T12:42:10.0166667+00:00

    Visual FoxPro 9.0 does not have native JSON support in the provided context, so the simplest approach within this scope is to:

    1. Export or convert the .dbf data into a format that can be consumed by a tool or environment that supports JSON.
    2. Use a JSON-capable environment (for example, C# in Visual Studio) to generate JSON from that data.

    Given the context, one practical path is:

    1. From Visual FoxPro, export the .dbf data to an intermediate format (for example, CSV or XML) that another tool can read.
    2. In Visual Studio, use C# to read that intermediate file and then serialize it to JSON.
    3. Use the resulting JSON as the import source for the ASI.

    The context also shows how Visual Studio can take JSON and generate classes (Edit → Paste Special → Paste JSON as Classes), which is useful on the consuming side: once JSON is produced from the .dbf data, Visual Studio can generate strongly typed classes for working with that JSON in .NET.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

    1 person found this answer helpful.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.