URL with parameter XML exports raw data only - Support and Troubleshooting

URL with parameter XML exports raw data only Issue  URL with parameter XML exports raw data only

Problem When exporting from the list view and using the Export > XML menu option, the raw data of selected records is exported with the associated journal fields (Additional Comments and Work Notes) and attachments. However, using XML parameter on the URL exports only the raw data of the records.

Data exported URL with XML parameter Menu "Export > XML" Raw data Yes Yes Attachments No Yes Journal fields No Yes Currency information No No Audit No No Data store on other tables No No

Symptoms This problem occurs when exporting the records using the URL containing the XML parameter. After importing the XML, there are no attachments or journal fields like Work Notes or Additional Comments on those records. However, some XML exports do contain the raw data plus the attachments and journal fields.

Cause The context menu Export > XML contains the logic to export the records, the attachments, and the journal fields. However, although the XML parameter informs the application server to export the raw data of the records in the URL query, it contains no logic to export attachments, journal fields, audit records, currency fields, or any other data store on a different table.

Resolution If you need to export the attachments and journal fields (for example, Work Notes and Additional Comments ), use the Export > XML menu option.

XML" src="sys_attachment.do?sys_id=c5ebe4eadb42b450e515c223059619ed" alt="Export > XML" width="598" height="386" align="bottom" border="" hspace="" vspace="" /> Here is the result of the export: The incidents get exported with the journals and attachments.

XML result" src="sys_attachment.do?sys_id=c9ebe4eadb42b450e515c223059619f2" alt="Export > XML result" width="600" height="216" align="bottom" />

If you do need to use the URL parameter, then you will need to create the logic to export the associated attachment and journal fields directly on their tables.

The following guide provides information to help you understand how to export attachments and journals.

Data exported Table containing the data Relationship Raw data table on the URL raw record Attachments sys_attachment table_sys_id = sys_id of the raw record Attachments_docs sys_attachment_doc sys_attachment = sys_id of the attachment Journal fields sys_journal_field element_id = sys_id of the raw record

Note that journal fields are stored in the [sys_journal_field] table. They are linked to the records by the sys_journal_field.element_id = sys_id of the raw record.

Attachments are stored in the [sys_attachment and ]sys_attachment_doc tables. They are linked to the records by sys_attachment.table_sys_id = sys_id of the raw record, and sys_attachment_doc.sys_attachment = sys_id of the attachment.