Copyright © 2003-2018 Inmagic, a division of SydneyPLUS International Library Systems, Inc., a Lucidea company. All rights reserved.
Inmagic DB/Text for SQL (formerly known as Content Server) is an enterprise-wide scalable content management system. It combines the advantages of a robust and flexible database management environment with high-speed search and categorization, making finding relevant information fast, easy, and precise. Web publishing capabilities are built into DB/Text, offering a better way to publish, access, and maintain information on corporate intranets and the Internet.
This product has the following components:
DB/TextWorks for SQL. This is the Windows desktop component.
DB/Text WebPublisher PRO for SQL. This component gives your organization the ability to publish textbases on the Web. Anyone with a Web browser can point to an HTML page and submit a query. The results are returned dynamically, in forms that you design. You can also design an interface so that you and/or your end users can add, edit, and delete records in a textbase through the Web.
DB/Text for SQL Importer. This component is a service that enables you to load records into one or more textbases, while automatically and continually processing imports in the background. You can import records in Inmagic tagged, delimited ASCII, and XML formats. You can also import documents (for example, Microsoft Word documents).
Important! This section applies to clients upgrading from version 14.5 or earlier. Please read the entire section carefully.
Textbases created or upgraded using version 17.0 are not compatible with any Inmagic product prior to version 15.0. You will need to upgrade DB/Text WebPublisher to version 17.0 before you will be able to use it with a version 15.0 or later textbase. When you open an existing version 14.5 (or earlier) textbase with DB/TextWorks version 17.0, you will be prompted to upgrade the textbase. If you upgrade the textbase, you will not be able to access the textbase with any Inmagic product prior to version 15.0.
For example: If you use Inmagic Genie, you will need to open each Genie textbase (GenieKey, Catalog, etc.) in DB/TextWorks to upgrade it to 17.0. If your textbase includes any Link fields, you will need to open the secondary/associated textbases directly (File>Open) to upgrade them to 17.0. If your textbase uses the Thesaurus feature, you will need to open the thesaurus textbase directly (File>Open) to upgrade it to 17.0. And so on.
Form Scripts that use the "formatting signal" discussed in the "Box Object" topic in the Help must be updated. The length has changed from 13 characters to 23 characters. Any Form Scripts that use the script snippet in that topic will need to be modified to use the new length.
Notes for WebPublisher
A change must be made to the WEB.CONFIG file for InmagicBrowse. Please see the installation notes for more information.
WebPublisher Edit Screens now use WPP_Edit.aspx instead of a .ASP page (iwpp-edit.asp or icsw-edit.asp). You will need to re-export any HTML edit screens. And if you have made any customizations to the old .ASP pages (rare), you'll need to transfer those customizations to the new .ASPX page.
If your WebPublisher reports look different than they did in previous versions, they probably include Raw HTML or Inline Images. Open the form in the Form Designer, choose Tools>Form Properties, select the HTML tab, uncheck "Use Cascading Style Sheets to preserve formatting", save the form, and try the report in WebPublisher again.
Notes for Inmagic Genie
You will need to open each Genie textbase with DB/TextWorks to upgrade it to 15.0 or later.
You will need to open the WebPrint form in the DB/TextWorks Form Designer to choose Tools>Form Properties, select the HTML tab, and uncheck "Use Cascading Style Sheets to preserve formatting".
You may (or may not) need to add an option to the ICSWEB.INI file for DB/Text WebPublisher. Please see the "DBTWPub.INI (ICSWeb.INI) File" topic under "WebPublisher PRO Configuration" in the Help Contents, and click the bottom link in the topic ("Whether specific characters (trademarks, smart quotes, etc.) are HTML-encoded, primarily for use with Inmagic Genie").
Each enhancement is discussed briefly here. The Inmagic issue number follows each item listed.
Undo Record Deletion – Deleted records can be recovered using the new ‘Undo Deleted Record(s) action on the Records menu. The action is available for the Delete and Batch Delete actions. [6531]
Each user can enable this operation in the Tools > Options dialog General tab, General tab. Select the check box 'Retain deleted records in user file directory for Undo operation'.
Textbase must have Xml Match fields specified - these are used to avoid errors when restoring records.
Records are backed up as .csv files in User Files directory. Backups are retained for 5 days.
The deleted record .csv files are stacked, with the most recent Delete or Batch Delete at the top. Undoing delete pops the next .csv file to the top.
There is no limit on the number of records backed up.
The Undo operation requests confirmation, and displays the number of backed up records.
Auto and code fields may not be restored to the original values.
Search for Duplicate Records – easy way to search for records with duplicate values in a specific field. The action is implemented by the ‘Browse Duplicated Terms’ action on the Edit menu. [6032]
Available in the Query and Command Query windows.
The Query Choices Browser appears showing terms which occur more than once, with a count of occurrences as usual.
This option appears as a radio button in the browser.
Send Report as Mail supports specifying alternative port. [7660]
Implemented in inmagic.ini, similar to implementation for UserName and Password.
In inmagic.ini [Inmagic DB/TextWorks] section, add or modify existing SMTPPort entry. For instance, add the line SMTPPort=2525.
You may need to add this setting if your organization uses a non-standard SMTP port number.
The Inmagic.INI file includes personal customizations and preference settings and can be found in each user's personal user file path folder.
The following features are no longer available in DB/TextWorks as of version 15.0.
WebPublisher Multiple Textbase Query. Presto for DB/TextWorks provides a much more robust ability to search across multiple textbases and display these results. Note: This feature is unrelated to Link fields. Textbases can still be linked together (e.g., Loans linked to Borrower).
Scan Image. Note: The ability to use existing images has not been affected. The Scan Image feature permitted you to use DB/TextWorks to scan an image with your scanner.
Textbase-Specific Help. Microsoft has dropped support for the .HLP format in modern versions of Windows. You can use a script button or the Applications menu to launch a textbase-specific help document.
Email – MAPI Support. Microsoft has begun deprecating MAPI features in Windows. See the new features for SMTP e-mail, which allow the inclusion of Additional Message Text and a Signature.
The following issues are addressed by this version. The applicable Inmagic Software Problem Report (SPR) number is enclosed in [square brackets].
Specified sort in Genie report is ignored. [8083]
Dead URL Link Checker: cannot handle TOC info (pound sign) in URL. [5752]. The checker is more robust, but some URLs still may not be handled correctly (Due to obsolete WinHTTP stack in 32-bit Windows)
‘Copy Special’ operation may not include all data in a record [8096].
In Print Preview, Rich Text fields appear to use tiny fonts. Print does use the correct font sizes.
64-bit OS: Using 'Check spelling as you type' causes display issues in Edit Form [8084].
64-bit OS: Import Document fails for Microsoft documents - can't find IFilters. [8063].
The following documentation and help resources are available. Please check the Documentation subfolder of the main installation folder, or click the Product Documentation link on the Customer Extranet page.
Support Matrix for Inmagic DB/Text for SQL v17.0 [DBTextWorksSQLSupportMatrix.pdf]. Lists requirements for DB/TextWorks and WebPublisher PRO v17.0 on the SQL platform.
Inmagic DB/Text for SQL v17.0 Installation and Upgrade Instructions [DBTforSQLInstallationNotes.pdf]. Explains how to install or upgrade DB/TextWorks for SQL and WebPublisher PRO for SQL.
Inmagic DB/Text for SQL Administrator's Guide [DBTforSQLAdminGuide.pdf]. Describes ongoing administrative and maintenance tasks that should be performed by the DB/Text for SQL administrator, including how to back up and restore a textbase.
Inmagic DB/Text for SQL Textbase Importer Service v14 User's Guide [dbimpsrvSQL.pdf]. Explains how to use the Importer service provided with DB/Text for SQL.
Converting to the Inmagic DB/Text for SQL Platform [ConvertingToDBTforSQLPlatform.pdf]. This document is intended for customers who are moving from the non-SQL platform to the SQL platform of DB/TextWorks and WebPublisher PRO.
Online Help. Covers both DB/TextWorks and WebPublisher PRO. To open the help file, start DB/TextWorks and press F1, or choose Help>Help Topics from the DB/TextWorks menu bar.
Knowledgebase. Use the Inmagic Technical Support knowledgebase on the Web to search for solutions to common problems and explanations for error messages. To access the knowledgebase, click Support Knowledgebase on the Inmagic Customer Extranet page.