Stonehaven Technology / sTToXML Technical Support

Checking Invalid XML Errors using an XML validator

Customer Service — Wed, 17 Oct 2007 01:26:00 GMT

Invalid XML messages can be deciphered by testing the XML file with an XML validator. There is a free validator online at

http://www.stg.brown.edu/pub/xmlvalid/

The validator tool may help pinpoint a problem in the XML file; thus, helping you determine what is needed to generate a valid XML file. Follow the on-screen instructions to upload your XML for testing

A typical invalid XML message in sTToXML may read as:

759. XML Failure. The uploaded XML file is invalid according to the smbxml .dtd specifications.
Error Reason: 'Element content is invalid according to the DTD/Schema....

Deciphering sTToXML Column Names / smbxml XML Elements

Customer Service — Tue, 31 Jul 2007 00:06:00 GMT

Netsuite's smbxml XML User's Guide does an excellent job of explaining the XML elements (fieldnames) for each of the XML tables. The guide is available for download from the sTToXML website. By extension, the explanations also apply to the sTToXML template column names.

http://www.sttoxml.com/languages/smbxml/docs/index.htm

Download the smbxml .zip or .pdf files.

sTToXML Pre-populated Templates vs. XML-direct templates

Customer Service — Sun, 29 Jul 2007 22:13:00 GMT

Stonehaven Technoloy uses the XML-direct templates for its data to XML conversions. Granted, the field-names are more cryptic; however, the XML logic and groupings are easily discernible. Additionally, it is much easier to remove unwanted / unneeded columns from the templates and diagnose any problems.

The primary advantage of the pre-populated templates is the column names are easier to comprehend. However, attempting to remove unneeded columns is very problematic.

In the end, our recommendation is to use the "Build a [smbxml] template" option on the sTToXML Template screen. Only the use the Select a Pre-populated Template option if you are very new to sTToXML and XML and you do not plan on removing any of the template's columns.

Which Netsuite Tables are Supported by sTToXML

Customer Service — Sat, 07 Jul 2007 13:13:00 GMT

sTToXML automatically supports all of the tables exposed by Netsuite's smbxml language. Most significantly, all of Netsuite's XML-exposed transactions such as sales orders, purchase orders, invoices, etc. are supported. Use the following link to see a report listing all of the supported tables:

http://www.sttoxml.com/03_59_04/reports/listelements.asp?l=smbxml

Step by Step Instructions for using sTToXML

Customer Service — Sat, 07 Jul 2007 13:01:00 GMT

You can find step-by-step instructions for using sTToXML in the sttoxml.com website. Click the link below to surf to the page directly.

http://www.sttoxml.com/sttoxml/howto/HowToUseSttoxml.htm