SMM’s text2 DAO Known Issues & Wish List:
NOTES:
1. Exports to a delimited text file occasionally fail
when imported into MS Excel because MS Excel does not handle the delimiter
character properly even when encapsulated in double-quotes. As I am
encapsulated each and every exported field inside double-quotes, all I can
recommend is to try the various available delimiters until one works. The key
will be to find a delimiter that is not embedded in your data.
2. There is, at this time any testing of File extensions. So, if you Create a Database File
and forget to change it to a known Database File Extension you will not see it
when you try to open it as a Database.
ISSUES:
1.
To overcome the need for an ‘Assumed’ RTF Pre-amble. A substitute
Pre-amble is prefixed to RTF Fields the do not have a {/rtf coding before being
placed in an RTF Window. Unfortunately, at this time I do not have a method for
removing the added code before saving. This results in Module Bloat as editing
proceeds.
2.
Still having some problems importing a delimited text file where the
Delimiter Character is also included as information to be imported.
3.
No International Support, yet.
4.
Need to write code to format the text entry from the flexgrid into the
correct field format. Partially done. But, a lot more work needs oto be done.
5.
Some user friendly form of FileName extension handling
6.
Final Database Updates are not written to the underlying Database went
Database is closed. May need a Record Changed Flag and a Warning on exit if not
in ‘Auto Update’ mode.
7.
All Menu Items are enabled even when their functions have no meaning or
may cause an error. Need to develop methodologies to disable Menu Items that
may either cause an error or have no purpose. Ex:
a.
In Main, Create Database should be disabled until a file is Imported.
b.
In Dataview, Export Table and RTF Options should be disabled until a
Table is Selected and Locked.
8.
We Have Font Formatting but no Text formatting like centering and bullets
in the RTF boxes
9. Can not open Utmost Devotional File. Causes a catastrophic
fatal error. “Method ‘def textrtf’ of object ‘IRichText’ failed. Runtime error
–2147417848 (80010108)
10. No ‘graceful’ Error Handler has been incorporated to
handle things not prevented in code. To prevent an abrupt and non-graceful
program termination.
11. There is no ability to edit the Table Name in
Dataview. This is not a currently
planned enhancement. To overcome: Export the Open Table and re-create with
the correct Field name in the import/main window. NOTE: This will not work for
multiple Table Databases because there is currently no provision for combining
Tables.
12. There is no ability to Edit the Field Name in
Dataview. This is not a currently
planned enhancement. To overcome: Export the Open Table and re-create with
the correct Field name in the import/main window. NOTE: This will not work for
multiple Table Databases because there is currently no provision for combining
Tables.
13. There is no provision to limiting the number of
imported columns if zero length fields are imported with valid delimiter pairs.
This is only an issue if the ‘Empty’ space occurs in the Header Line.
14. There is no warning before exit after changes have
been made to the Import Window data. Add a Changes have occurred flag for when
changes have been to the Import FlexGrid to allow saving before Exiting Program
or Importing a different file.
Wish List: