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.
- Read a text file with comma-, space-, tab- or caret-separated (^) values. (caret added with version 1.0.5)
- Remove all single, double quotation marks or tilde (~) from values. (tilde added with version 1.0.5)
- Assign a field to any of the following data types: Integer, Real (float), Text.
- You decide how to name a table and fields.
- 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.
- Text2SQL will show progress with a progress bar while inserting records to a database.
- The application supports Fullscreen.
- Language: English only.
- The application supports the Retina display.
- Application file size: 1.4 MB
- The application comes with a complete user’s guide written in English. (Choose Help > User’s Guide.)
- Mac OS X 10.7, 10.8, 10.9
- 64-bit system
- A database can contain only one table.
- A data file must contain at least two fields (columns) of data.
- 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).
- Possible data types are only Integer, Real, Text.
- Text2SQL will automatically add a count field titled ID with auto increment.
1.1.0 (Released on January 11, 2015)
- 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)
- Fix: When the user selected and opened a data file, the application could leak memory while analyzing data.
- Fix: The data list could remain disabled until the user clicked on the Reload button to read the same dataset twice.
- Fix: When the user chose Open Data under File, the application did not let the user select a data file for any format.
- A few other changes and fixes are done.
1.0.7 (Released on June 17, 2014)
- Fix: The show SQL button might not come back after the user created a database file or canceled the export process.
- 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)
- Fix: The printout function was incomplete with broken lines.
- A new separator (^) is added to the field separation drop-down menu.
- A new removal character (~) is added to the removal drop-down menu.
- Some other fixes are done.
1.0.1 (Released on January 7, 2014)
- The application failed to restore the last window dimensions.
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.
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.