Alpha DevCon 2018
Results 1 to 12 of 12

Thread: Importing memo fields from DBF to MYSQL ...

  1. #1
    Moderator drgarytraub's Avatar
    Real Name
    Dr. Gary Traub
    Join Date
    May 2000
    Location
    Boca Raton, FL
    Posts
    2,715

    Default Importing memo fields from DBF to MYSQL ...

    I have tried various ways to import tables that have memo fields. All the fields import except the DBF memo fields.

    I have used alpha's export - does not work with memo fields and is EXTREMELY SLOW

    I have used Navicat - inport dbf - not work for memo fields

    I have used Excel to open the DBF, then exported to text, then imported that text file via Navicat - again. does not work for memo fields.



    Is there something extra I need to do to make this happen?
    Gary S. Traub, Ph.D.


  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    24,946

    Default Re: Importing memo fields from DBF to MYSQL ...

    Not much experience with your issue. Have you tried the Workspace Upsize Genie under the Tools menu?

    Strike that thought, I was thinking you could choose which tables to upsize.

    I just tested an Alpha table with a memo field exported to csv and then imported to a MariaSQL table specifying the memo field be imported into a LONGTEXT field. seems to work, no idea about speed.
    Last edited by Stan Mathews; 05-30-2018 at 04:21 PM.
    There can be only one.

  3. #3
    Moderator drgarytraub's Avatar
    Real Name
    Dr. Gary Traub
    Join Date
    May 2000
    Location
    Boca Raton, FL
    Posts
    2,715

    Default Re: Importing memo fields from DBF to MYSQL ...

    Thanks for looking Stan. I will try exporting to csv. I already tried it via text, but at this point I would do a rain dance if it could help.
    Gary S. Traub, Ph.D.


  4. #4
    Moderator Peter.Greulich's Avatar
    Real Name
    Peter Greulich
    Join Date
    Apr 2000
    Location
    Boston, MA
    Posts
    11,533

    Default Re: Importing memo fields from DBF to MYSQL ...

    I have, in the past, used Alpha's export feature to export dbf to MySql. ALL my memo fields, on this project or that, exported the memo fields successfully without incident.

  5. #5
    "Certified" Alphaholic Lance Gurd's Avatar
    Real Name
    Lance Gurd
    Join Date
    Jun 2005
    Location
    Southampton, UK
    Posts
    1,381

    Default Re: Importing memo fields from DBF to MYSQL ...

    I am the same as Peter, had no problems

  6. #6
    Moderator drgarytraub's Avatar
    Real Name
    Dr. Gary Traub
    Join Date
    May 2000
    Location
    Boca Raton, FL
    Posts
    2,715

    Default Re: Importing memo fields from DBF to MYSQL ...

    Yes, alpha's export does work but it is incredibly slow. One of my tables was still running after 5 hours. So I have been spending lots of time trying to look for a better solution. Navicat works fantastic for importing most of my tables, and does so in a very small fraction of the time that the export operation takes.
    Gary S. Traub, Ph.D.


  7. #7
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    3,959

    Default Re: Importing memo fields from DBF to MYSQL ...

    Google FPT converter. Your memo fields are in FPT format so that is why it's taking time.
    Convert as you wish and then import the content.
    Ted Giles
    Example Consulting - UK
    .

    https://exampleltd.example-software.com/
    See our site for Alpha Support, Conversion and Upgrade.

  8. #8
    Member
    Real Name
    pieter cremers
    Join Date
    Nov 2009
    Location
    Netherlands
    Posts
    145

    Default Re: Importing memo fields from DBF to MYSQL ...

    Gary,

    Longtime ago we used a program called spectral core Full convert to automate conversion of our paradox tables to mysql.
    Paradox has the same problems with memo files as dbase. But for spectral core it was no problem at all.

    Hth

    Pieter

  9. #9
    Moderator drgarytraub's Avatar
    Real Name
    Dr. Gary Traub
    Join Date
    May 2000
    Location
    Boca Raton, FL
    Posts
    2,715

    Default Re: Importing memo fields from DBF to MYSQL ...

    Thanks for all the suggestions. I am now working with a SQL consultant, and am making some progress. Turns out that using AlphaDAO for a very large table (many, many memo fields) and approx 165,000 records was taking hours and hours so was essentially useless to me because this is not a one time thing for me - I will need to do many times. However, using alpha's export to text (or csv) takes just 35 to 40 seconds, and then using Navicat to import that text file into the pre-exisiting sql table (with all the correct field types pre-defined) takes just another 4 minutes! The first step was using ALphaDao to export just one record so that alpha created the sql table with all the correct fields, field types, and lengths, etc. Then delete that one record, and do as I described above - if you skip this step, and then import the text file, the sql table ends up with all fields being VARCHAR (255) which is not what we want.

    One problem though - importing the data with navicat in this way leads to many errors, e.g., mostly data too long for field and funky characters perhaps from users having copied and pasted from word in to a memo field for example. Turning strict mode off for the import eliminates all those errors which is great - got this suggestion from a google search - but I worry some what effect this could have. Perusal of the resulting table looks ok, but there is far too much data to be sure. So I am wondering what others think about this, or any experience with turnig strict mode off for this purpose.
    Gary S. Traub, Ph.D.


  10. #10
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    3,959

    Default Re: Importing memo fields from DBF to MYSQL ...

    I've posted this Navicat issue on the RAD group Gary. A lot of guys ues it there.
    Ted Giles
    Example Consulting - UK
    .

    https://exampleltd.example-software.com/
    See our site for Alpha Support, Conversion and Upgrade.

  11. #11
    Moderator drgarytraub's Avatar
    Real Name
    Dr. Gary Traub
    Join Date
    May 2000
    Location
    Boca Raton, FL
    Posts
    2,715

    Default Re: Importing memo fields from DBF to MYSQL ...

    Hi Ted,

    I would love to see that. Where is the RAD group?
    Gary S. Traub, Ph.D.


  12. #12
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    3,959

    Default Re: Importing memo fields from DBF to MYSQL ...

    Try this Gary.

    http://www.dbf2002.com/dbf-converter...bf-to-sql.html

    One of the SQL DBA's suggested it after concluding that Navicat was unsuitable.

    As for the RAD group, we are not a public group and evaluate all sorts of RAD software so it's not dedicated Alpha, although there are several who use Alpha DT and Web.
    Ted Giles
    Example Consulting - UK
    .

    https://exampleltd.example-software.com/
    See our site for Alpha Support, Conversion and Upgrade.

Similar Threads

  1. Importing Memo Fields
    By Bill Pope in forum Alpha Five Version 10 - Desktop Applications
    Replies: 3
    Last Post: 12-13-2010, 05:31 PM
  2. Moving dbf to MySQL including memo fields
    By George Corder in forum Alpha Five Version 10 - Desktop Applications
    Replies: 7
    Last Post: 09-27-2010, 02:14 PM
  3. Importing mysql using ADO
    By Silver in forum Alpha Five Version 8
    Replies: 5
    Last Post: 10-09-2007, 10:03 PM
  4. Importing dBase+ memo fields
    By GregOnline in forum Alpha Five Version 6
    Replies: 2
    Last Post: 05-12-2005, 09:23 AM
  5. Importing Memo Fields
    By Steven Al Brown in forum Alpha Five Versions 2 and 3
    Replies: 2
    Last Post: 04-26-2000, 09:00 AM

Bookmarks

Posting Permissions

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