Many technical terms are spelled with and without blank spaces, dashes and slashes. For example, "data base" and "database" or "A/D converter" and "AD converter." We generate two deployment feeds.
Formal Feed
The formal feed uses paragraph tags and only one example of a term's spelling; for example, "database." Websites using the formal feed must handle blank spaces, slashes and dashes in their lookup system so that somebody looking up "data base" will find the term "database."
Informal Feed
Our website uses the informal feed, which contains break tags and no paragraph tags. It also allows for two spellings of a term with a "See abc" reference to the other as in the following example.
Punctuation Reference Coding
Alt-P creates a new punctuation reference. If you have two spellings for a term, make one a punctuation reference and link it to the term with the spelling you feel is most correct as in the example above. Otherwise, make sure the one spelling for a term is the most popular.
You Can Test for Proper Punctuation Coding
If you use the informal feed with punctuation references, you can test for proper coding. If duplicate term names are found and one is not identified as a punctuation reference, an error will be flagged.
A Windows SQLite converter program was created to generate mobile databases, which are no longer deployed; however, the app is used to test for valid punctuation as follows.
The XML to SQLite Application
Duplicate terms without one being marked as a punctuation reference appear in the right window. If found, make one a punctuation reference.
Run the program as follows:
1. Run Windows app \dploy\prepSQDB
to generate two SQLite databases,
One for iOS, another for Android.
PrepSQDB generates CDEmobile.xml
in \dploy\mobile.
2. When the application runs,
select Convert XML and CDEmobile.xml
3. VERY IMPORTANT. Do not move this app while
running. It only takes a minute, but
moving the window can cause it to fail.
4. If the right window is blank, click X.
If there are terms in the right window, make
one a punctuation reference and try again.
See CLC Dev Punctuation.
This duplicate testing program was written in
LiveCode and requires two modules in subfolders
below dploy\mobile as follows:
c:\dploy\mobile\Externals:
revdb.dll
\Externals\database_drivers:
dbsqlite.dll