QuoteWerks Knowledgebase Topic (Article ID 6363)
Error While Importing XML File Not Generated by QuoteWerks
This information applies to :
December 12, 2006
When importing an XML file not generated by QuoteWerks, the following error is received:
SQL Execute Error
QuoteWerks trapped error String or Binary Data would be truncated (-2147217833)
SQL=SET NOCOUNT ON; INSERT INTO DocumentHeaders(.....)
The XML data contains fields that exceed the lengths of QuoteWerks fields.
If you are experienced in working with SQL or Access Databases, you can open the DOCS.MDB file or the SQL DocumentItems or DocumentHeadersTables to find out field lengths. It is suggested that you make a backup copy of the QuoteWerks database/table before doing this.
©1993-2020 Aspire Technologies, Inc.
407-248-1481 (9am-5pm ET M-F)