What’s Coming Up Next? – MacHouse Introducing Text2SQL for Mac OS X

Mac software Text2SQL






TOKYO (MacHouse) – Just a few days ago, we managed to submit our first desktop application of the year to Apple‘s Mac App Store. There will be more to come for sure. Actually, we submitted the second software title of the year to Mac App Store about 10 hours ago. This new software submission is called Text2SQL.

Text2SQL is a desktop application that lets you create an SQLite database right out of a text file. Text2SQL can read comma-, space-, tab-, or caret-separated (^) data files. After Text2SQL inspects a data file, name a table. Then assign a name and its data type to each data field. Finally, just click on the Create button. Right, that’s just a one-minute job.  





Mac software Text2SQL   Mac software Text2SQL





Available at Mac App Store
Mac App Store






Features

  1. Read a text file with comma-, space-, tab- or caret-separated (^) values. (caret added with version 1.0.5)
  2. Remove all single, double quotation marks or tilde (~) from values. (tilde added with version 1.0.5)
  3. Assign a field to any of the following data types: Integer, Real (float), Text.
  4. You decide how to name a table and fields.
  5. Save progress as a document file. Just double-click on a document file to resume progress provided that the data file still exists at the original file path.
  6. Text2SQL will show progress with a progress bar while inserting records to a database.
  7. The application supports Fullscreen.
  8. Language: English only.
  9. The application supports the Retina display.
  10. Application file size: 1.4 MB
  11. The application comes with a complete user’s guide written in English. (Choose Help > User’s Guide.)






System requirements

  1. Mac OS X 10.7, 10.8, 10.9
  2. 64-bit system






Limitations

  1. A database can contain only one table.
  2. A data file must contain at least two fields (columns) of data.
  3. The application can only read text files with the right line break format. If you have a data file with the Classic-Mac line break style (CR), you must first convert that file into the Unix style (LF).
  4. Possible data types are only Integer, Real, Text.
  5. Text2SQL will automatically add a count field titled ID with auto increment.






Version history

1.1.0 (Released on January 11, 2015)

  1. The application checks and sees if the selected text file contains one or more Mac Classic or Windows line breaks.


1.0.10 (Released on December 11, 2014)

  1. Fix: When the user selected and opened a data file, the application could leak memory while analyzing data.
  2. Fix: The data list could remain disabled until the user clicked on the Reload button to read the same dataset twice.
  3. Fix: When the user chose Open Data under File, the application did not let the user select a data file for any format.
  4. A few other changes and fixes are done.


1.0.7 (Released on June 17, 2014)

  1. Fix: The show SQL button might not come back after the user created a database file or canceled the export process.
  2. Fix: A project file could be messed up if the user saves progress over an existing file with Save (as opposed to Save As).


1.0.5 (Released on January 24, 2014)

  1. Fix: The printout function was incomplete with broken lines.
  2. A new separator (^) is added to the field separation drop-down menu.
  3. A new removal character (~) is added to the removal drop-down menu.
  4. Some other fixes are done.


1.0.1 (Released on January 7, 2014)

  1. The application failed to restore the last window dimensions.






Trial/Demo version

Click here to download a trial version. Meanwhile, if you regularly review Mac software, you may be eligible for receiving free coupon codes, which can be redeemed at Mac App Store. Click here for more information.






Video tutorial

A video tutorial with text commentary is available in the form of a QuickTime movie. Click here. The data size is 137.3 MB, and the movie duration is 14 minutes and 52 seconds. The video dimensions are 1,440 x 900 pts.






Text2SQL is a product of MacHouse.

This entry was posted in Apple & Mac. Bookmark the permalink.

9 Responses to What’s Coming Up Next? – MacHouse Introducing Text2SQL for Mac OS X

  1. Sergey says:

    Hello,

    I have purchased this app but I cannot process my files. My files has ^ as separator and ~ as escape.

    Here is 4 rows of the file.

    ~A~^~Analytical data~
    ~AI~^~Analytical data; from the literature or government; incomplete documentation~
    ~AR~^~Analytical data; derived by linear regression~
    ~AS~^~Analytical data; derived by summation of components with source code 1 or 7~

    Could you add this options to parameters?

    This is from USDA website. Part of national DB.

  2. Hello,

    Thank you for your contacting us. Sure, we can add ^ as a separator. Could you tell us what you mean by ‘~ as escape’?

  3. If possible, could you please give us an example dataset by packaging it in an ZIP archive? If you go to and choose No. 5, you can open a ticket with an attachment. Thank you.

  4. Sergey says:

    Where is that no. 5?

    ~ is used instead of ” You can see it in example

    ~A~^~Analytical data~
    ~AI~^~Analytical data; from the literature or government; incomplete documentation~
    ~AR~^~Analytical data; derived by linear regression~
    ~AS~^~Analytical data; derived by summation of components with source code 1 or 7~

    It could be

    “A”,”Analytical data”
    “AI”,”A nalytical data; from the literature or government; incomplete documentation”
    “AR”,”Analytical data; derived by linear regression”
    “AS”,”Analytical data; derived by summation of components with source code 1 or 7″

  5. Please tell us where to download a sample data set or open a ticket at our support to upload a zipped file.

  6. You can find No. 5 at our support site. I’m sorry I didn’t post a link yesterday.

  7. I have tested a new software update with a dataset from this website. Version 1.0.5 has been submitted to Mac App Store. This desktop movie shows how this software update works. I hope these changes will meet your needs.

  8. Version 1.0.5 should now be available as Mac App Store approved it a while ago.

  9. Dave says:

    Seriously, you maintain a trial version that expired over THREE years ago (Jan 15,2014)… and expect people to RESET their system clock to test it? Sorry, but I guess I will have to continue my search elsewhere….

Leave a Reply

Your email address will not be published.

Notify me of followup comments via e-mail. You can also subscribe without commenting.