#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2004
    Location
    Boston, MA USA
    Posts
    393
    Rep Power
    47

    Goldmine to MySQL?


    Does anyone have any experience reading Goldmine data in PHP / MySQL?

    For years, I have been using the PHP dbase_open() function to access discrete records in Goldmine DBF files. A typical routine looks like this:
    PHP Code:
    $gdb1 dbase_open('Contact1.DBF'0);

    if (
    $gdb1) {
       
    $record_numbers dbase_numrecords($gdb1);
    $last_record $record_numbers;
       echo 
    " Number of records = $record_numbers... ";

       for (
    $i 1$i <= $record_numbers$i++) {
          
    $row dbase_get_record_with_names($gdb1$i);
          
    $account_no $row['ACCOUNTNO'];
    //      echo "Acct: $account_no <br>";
          
    $account_no addslashes($row['ACCOUNTNO']);
          
    $company_name addslashes($row['COMPANY']);
       } 
    This works well but all I am trying to do is read company names, addresses, etc. and I am able to read Contact1.DBF and Contact2.DBF separately and make the connections in MySQL, using the "ACCOUNTNO" field.

    Now, we want to move away from Goldmine entirely into and open-source MySQL database and we want to read ALL of the data. We are particularly concerned with the "History" data.

    I notice that there are other files besides DBF, such as MDX, and DBT but I am not sure what the format or interrelationships are.

    What's the best way to parse and import a Goldmine database?

    Thanks
    Last edited by SeanF; January 10th, 2014 at 11:54 AM.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2004
    Location
    Boston, MA USA
    Posts
    393
    Rep Power
    47
    Following up my own post, If I edit the "ContHist.DBT" file with a text editor, I see that some of the content I need is in there, wrapped in HTML Meta tags and including some unreadable characters.

    The PHP dbase_open function will read not this format and it's not clear to me how this "history" record gets associated with a "Contact" record.

    Any insight would be greatly appreciated.

IMN logo majestic logo threadwatch logo seochat tools logo