Share

SQR/PeopleCode to XML Spreadsheet

Tracker: Patches

5 Output to multiple files - ID: 2451231
Last Update: Attachment added ( schaubt )

This change is to allow outputting to multiple files concurrently (without
closing the previous file). This enhancement is good for batch output,
including output for multiple language files.

We have a requirement to support this for sqrs so I have a modified version
of xml_writer.1.07.sqc. Unfortunately we don't use the PC portion, so I
haven't added the functionality there.

It is done by changing all of the persistent flags and variables required
for each file to arrays. The file number (decremented by 1) is used to
indicate the array position of the value for that file.

The file is messy since I left the old code and tagged each change. I was
hoping this would make it easier for it to be merged into a future
release.

The changes are completely backwards compatible. If the XML_Num_Files
constant (used to indicate how many files will be used) is not set by the
sqr then the default is one file.

The new procedures are:
xml_switch_file(#File)
xml_get_file(:#tmp_file_num)

The attached file includes the modified sqc and short documentation.

Note that this version also includes a change to use alternate encoding,
and the fix for defect 2422552. I would imagine that you will remove the
alternate encoding, but I suggest documenting the change for use with
french characters.

I have tested this with a few reports so far and no issues. If you find any
please let me know.

I hope this is as usefull to others as it is to us.

Please let me know if you are looking for any help with the project. I'm
sure I'll be trying other enhancements later.


Trevor ( schaubt ) - 2008-12-19 20:51

5

Open

None

Nobody/Anonymous

None

None

Public


Comments




Log in to comment.

No follow-up comments have been posted.

Attached File ( 1 )

Filename Description Download
sqr2xml.zip Modified sqc and documentation Download

Change ( 1 )

Field Old Value Date By
File Added 306028: sqr2xml.zip 2008-12-19 20:51 schaubt