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

    Unanswered: Creating file for BUTIL load

    Hi,

    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,
    Markus

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    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
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

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

    Greetings,
    Markus

Posting Permissions

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