Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004

    Unanswered: Creating file for BUTIL load


    I want to create a text file to import data via BUTIL load. Looking at some files created via BUTIL recover exemplify that some types like integer or date are encoded in a "strange" format. Can someone tell me, how I can encode them by my own?

    Thanks for your help,

  2. #2
    Join Date
    Dec 2001
    Provided Answers: 6
    The records in a BUTIL Unformatted File are stored in the following format:
    <record lenght>,<binary byte image of the record>
    What does that mean? That means that integers are stored in their byte swapped format. Dates are stored as their 4 byte format and so on.
    You would do much better to write a custom import routine that take a simpler format and imports the data or create DDFs for the Btrieve files and use the Import Wizard with Pervasive.SQL 2000 or later. The Import Wizard can pull in data from CSV formats.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    Nov 2004
    Thanks for your help - I will try all these things


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts