Program Name: Text2DAO
This version Fixes:
- Adds *.lst to the Database Open/Save File Filter List
- And some other minor things I've forgotten about.
Not Fixed, Yet:
- There is no vertical scroll bar on the some of the windows... Sorry, forgot again. You'll just have to scroll down through text to get to the bottom.
- Delimited Import Text Files that included (even between Double-Quotes) continue to cause problems.
For the Curious: Change History And Know Issues & Wish List OUT OF DATE
Click to Download - Current Version: 1.2005.0.531 .Zipped 69Kb May 31, 2005
Comprehensive Setup Install File .Zipped !BIG! 5,226Kb May 31, 2005
What I suggest you do is try the 'tiny' file and see what you don't already have installed. Let me know, And, I can tailor the package to only include those modules most often required in the field.
So far, it appears the MS FlexGrid Control is the most likely offender in the e-Sword Groups...
Here is a 'SetUp' with FlexGrid and RichText .Zipped smaller 758Kb May 31, 2005
I Apologise that the Documentation is not up to date with the Program. I'm Working on it. Thanks for your Patience.
SMM's_Text2DAO Doc 104Kb Here is the curent Documentation in a .Zip Merely unzip where you want it. Or View On-Line: SMM's_Text2DAO. March 12, 2005 2030
Purpose(s): Import and Convert a delimited text file into a
useable MS Jet Database.
Caveat Emptor: Make Copies of *ALL* files *BEFORE* 'playing' with them using this program. This is FREE… NO Warranties are offered, implied or otherwise connected with this software…
This Program is a utility, which means it is not as user friendly as I would like...
Constructive Criticism is encouraged... No whining, please...
The Main Program Screen
File Menu
a. Import Tab-Delimited Text
b. Import Comma-Delimited Text
c. Open Data Base
d. Exit
Database:
a. Create From Text Import
Columns:
a. Move First
b. Move Left
c. Move Right
d. Move Last
e. Add Column
f. Delete Column
Main Screen After Importing Jonathon’s e-Sword Database
1. The FlexGrid column widths can be adjusted.
2. The Drop-Down Combo Box is used to change the Field
Type. An [Enter] is required to accept the changes.
3. When ‘Text’ is the Field Type, Field Size can be
adjusted. Again, An [Enter] is required to accept the changes.
4.The Columns can be re-ordered, added to or deleted using the Columns menu.
Note: Only the Right-Most column can be deleted. But, any column can be moved to the ‘Last’ position.
5.Fields in the Database are created in the same order a the Columns.
6. Quotation Marks are deleted upon importation unless there are two in a row. In which case only the second Quotation Mark is
retained.
7. Spaces in the Field Name are replaced by Underscores
due to Field Name naming restrictions.
After the Columns are ordered and assigned, a database can be created using the data in the FlexGrid by using the Database menu.
A database once created (or another one) can be opened using the File menu.
DataView Window after opening a multi-table database
- You can only open unlocked or non-password protected databases.
- The Data is ‘Live’. Change it and the change is ‘Committed’.
- You MUST assign each field you want to view or edit to a display resource.
- Click a Field Name in the Field Assignment List
- Click a Display Resource in the Display Resource Assignment FlexGrid.
- Click the ‘select’ Button. The Field Name should disappear from the Field Assignment List and appear as a Label for the assigned Display Resource.
- Only one Database Table can be manipulated at a time.
- Clicking on the arrows on the Data Control will scroll through the Database displaying the data in the appropriate Display Resource. Changes made will be committed to the Database.
- Font Color can be changed only on the ‘Selected’ Text in the Rich Text Box by using the RTF Options Menu.
- Font Type & Size can be assigned for the Rich Text Box by using the RTF Options Menu.
- Background Highlighting is not directly supported at this time.
- No validation is performed on user input or imported text to ensure that the information conforms to the requirements of the users selection of Field Type.
How It Works
- The Text File is opened and the first line is read into a standard listbox.
- It is assumed that the first line is the Field/Column Title line and has the correct number of columns for what you're doing.
- The List Count from the listbox is used to configure a FlexGrid to the correct number of columns/fields wide.
- The remainder of the text file is read into the flexgrid.
-
- At this point the user can change to default 'Text' Field Type to one of several provided. If 'Text' is used the 'Size' (Number of Characters Wide) can be adjusted. [DAO seems to be limited to 255 characters in this configuration.]
- Once the user is happy with their selections they may select [Database]-[Create From Text Import] to create the database. {Note: Database is Closed after being created.}
- The user may open a .MDB (based) database.
- Once a database is selected a list of Tables in the Database will be displayed in the Left-Most Listbox.
- As a Table is Highlighted it's Fields are displayed in the Flexgrid immediately to the Right of the Tables Listbox and in the FieldNames List above the Rich Text Box.
- As the Fields are displayed a corresponding number of Textboxes are created to allow editing of the Field data.
- Before Editing or Viewing may occur the Fields Must be assigned to a Textbox or the RichTextBox...
- To assign to Field to an Editing Location click the field, then click the editing location then click 'Select'.
- The Rich Text Box is primarily for Memo Fields...
Bug Reporting:
- Take Mental Notes so that you can give me enough information to reproduce the problem.
- Try to reproduce the problem yourself. If you can't get it to reproduce I probably won't be able to either. Can't fix it if I can't find it.
- Remember this is a 'utility'... A 'geeks' utility... It's not meant to be user friendly...
Suggestions?
Ah well...
Bugs aren't the only reason for releasing 'beta' of a program. Even a simple 'utility' can always be improved...
There is a very high probability that I think and work differently than you do... What is natural and intuitive to me, may be the hardest to understand point of frustration for you...