January 2019 issue
summary. . . [order code JAN19]
WordMerge For Big Databases (and Other Tricks) WordMerging in databases with an exceedingly large number of
fields can have unintended consequences. Problems that might not be
immediately apparent but might very well come back to bite.
Fortunately, an easy tweak or two in the WordMerge program can protect
against merge failures and dramatically improve overall mail-merge
Exporting By Checkbox
A company needed a custom export solution ― a gizmo in the INVOICES
database that lets them browse their recent invoices and selectively
mark them for export for periodic mail-outs. The routine prevents the same Bill-To company from
winding up more than once in the export file. Results automatically
come up in Excel.
WordMerge Docs List Documents can be excluded from the WordMerge Select Folder
or Document picklist without having to remove them from the usual
default C:\Sesame2\ Docs WordMerge docs folder. Or, the
opposite — only the specified docs can be allowed to show on
the picklist. All it takes is a little string array magic and knowing
where in the WordMerge program to work it.
Tracking Groups of Related Dates A company needed to track four critical dates. Not their own
dates. Their vendors’ dates. The approach here can prove useful when
(1) there are multiple date fields in a record related to one another
in some way, (2) the dates require periodic updating, and (3) an easy
way is needed to find records where one or more of the dates is
approaching or has passed.
Hassle-Free Price Hiking A company selling high-volume small-ticket products to the trade
was looking for a way to simplify its price updating process. Prices
on several hundred products needed to be upped a bit at year end. With
8 quantity pricing tiers per product, it promised to be an agonizing
and error-prone exercise. In Q&A they had no choice but to do in
manually. in Sesame, they were looking for some magic.
Exporting Potential Dups to Excel Check out this handy click-'n'-go routine that scans a
50,000-record database for potential duplicate records (based on your
custom criteria) and shows the results in Excel in under 20 seconds.
Translated Programming Not
Working — Disaster struck when a company's Q&A Read-Only fields
were all programmed.
Translated Programming Not
Working 2 — Revisiting the Auto-calc phenomenon.
No Main Form? — What
happens exactly when Sesame translates a multi-form Q&A for Windows
Use Data from One Database as a
Retrieve Spec in Another — Find the equipment, get the account
numbers, retrieve the customer records with those accounts, and
print a report. The only tricky part about this is working with two
Double-Duty Search — an
Any Restrictions search followed by a Search in Current
Results was the only way to tackle this thorny problem.
Replacing a Sesame Client —
A user's computer dies. What's the easiest way Sesame-wise to get
that user back in the game on his or her new box?
XLookup Data and Allow Changes —
Correcting a couple of thorny issues when relying on a large
zipcode lookup database to auto-fill fields.
Combine Multiple Database
Translations — When it's possible to combine two databases into
one for the sake of efficiency.
Q&A Windows Translation Issues
— You might be in for a few surprises should you attempt to
translate a Q&A for Windows database. Here's what to expect and how
to deal with it.
_______________Technical tidbits you can
Express Export to Excel
― Using a custom data export program instead of Sesame’s own export
facilities, you can have the results automatically pop up in
Microsoft Excel with no additional steps or questions asked.
Is .doc Dying in WordMerge? ― You're liable to get this
error message one of these days. What to do about it when you do.
(Insider password required)
How to Copy Programming Code from
Inside Sesame to paste into Sesame's Program
You can copy programming code from Inside Sesame
Acrobat PDFs and paste it into your Sesame Program Editor.
Select the code with your mouse, then Right click
on the selected text and choose Copy to copy it to the
(If the program continues to another page, do that page separately.)
In Sesame's Program Editor, select Edit | Paste
(or press Ctrl-V) to paste
the copied code into the appropriate LE/Event slot.
Inside Sesame programming examples may
inadvertently contain styled
quotes. If these are present, you'll get a lexical error when you Test
the program. You'll need to replace these styled quotes with the plain straight quotes
the Program Editor requires.