2.7 Debugging XML Export and XML Import

The special considerations presented in section 2.2 of this chapter may provide you with the most help when working with XML. You also can avoid some of the extra work by forcing the user to enter clean data into your databases. For example, numbers that must contain two and only two decimal places will always be correctly formatted if shown with XML exports.

The return in a field will be exported as a return with XML export. If you intend for a field to have one value with no returns, you may use field validations to prevent this. You may also export a calculated field. Depending upon the processor used, you may be able to check for the return character and remove it before presenting the data. In most cases, starting with clean data will ensure proper XML exported results.