[Download-List] XML File Tags

[Norman, David (SAAS)]

Thanks, Dave. I guess that would do it !!

========================
David Norman
Senior Software Engineer
SA Ambulance Service
Box 3, GPO
Adelaide, South Australia 5001
*+61 8 8274 0384
fax +61 8 8271 0758
* norman.david at saambulance.com.au


-----Original Message-----
From: download-list-bounces at cedarville.edu
[mailto:download-list-bounces at cedarville.edu] On Behalf Of David L.
Rotman
Sent: Thursday, 22 February 2007 11:32 PM
To: Cedarville DOWNLOAD Users
Subject: RE: [Download-List] XML File Tags

It appears that what you want is more like a flat file than XML.

Here is one approach:
DOWNLOAD CUSTOMER \
   LITERAL '<idnumber>' @ID LITERAL '</idnumber>' \
   FORMAT FIXED \
   HEADING LITERAL '<?xml version="1.0"?>'  LINE 1 \
   LITERAL '<download>' LINE 2 \
   FOOTING LITERAL '</download>'

This would work for one or two fields, but would be fairly tedious
if you had lots of fields to produce.



Dave Rotman
Associate Vice President for Technology
Chief Information Officer
Cedarville University
251 N. Main Street
Cedarville, OH 45314
rotmand at cedarville.edu
voice 937-766-7905
fax 937-766-8819


>>> "Norman, David (SAAS)" <norman.david at saambulance.com.au> 2/21/2007
5:35 PM >>>
Yes, Dave, your second example is the sort of thing I'm looking for.
In
this instance there is only one field, so following your sample I
would
like to see:
<?xml version="1.0"?>
<download>
  <idnumber>123</idnumber>
  <idnumber>408</idnumber>
  <idnumber>567</idnumber>
</download>

If it can't be done (and it doesn't seem quite right to me) it's no
big
deal - the receiver is prepared to change their routines to accept the
filetags around each field.

Thanks for our prompt response,

Regards,
========================
David Norman
Senior Software Engineer
SA Ambulance Service
Box 3, GPO
Adelaide, South Australia 5001
*+61 8 8274 0384
fax +61 8 8271 0758
* norman.david at saambulance.com.au 


-----Original Message-----
From: download-list-bounces at cedarville.edu 
[mailto:download-list-bounces at cedarville.edu] On Behalf Of David L.
Rotman
Sent: Wednesday, 21 February 2007 11:27 PM
To: download-list at cedarville.edu 
Subject: Re: [Download-List] XML File Tags

David--

Can you give us an abbreviated example of what you want to produce?

Here is some typical output:
<?xml version="1.0"?>
<download>
<customer>
  <idnumber>123</idnumber>
  <lastname>Brady</lastname>
  <firstname>Mike</firstname>
</customer>
<customer>
  <idnumber>408</idnumber>
  <lastname>Jones</lastname>
  <firstname>Susan</firstname>
</customer>
</download>

Are you wanting this?  (I'm not sure how the recipient would process
this...)
<?xml version="1.0"?>
<download>
  <idnumber>123</idnumber>
  <lastname>Brady</lastname>
  <firstname>Mike</firstname>
  <idnumber>408</idnumber>
  <lastname>Jones</lastname>
  <firstname>Susan</firstname>
</download>




Dave Rotman
Associate Vice President for Technology
Chief Information Officer
Cedarville University
251 N. Main Street
Cedarville, OH 45314
rotmand at cedarville.edu 
voice 937-766-7905
fax 937-766-8819


>>> "Norman, David (SAAS)" <norman.david at saambulance.com.au> 2/20/2007
12:22 AM >>>
Is there any way to suppress the XML file tags ? The receiver is
expecting just the field tag and otherwise I will have to strip the
file
tags afterwards.

Thanks,
========================
David Norman
Senior Software Engineer
SA Ambulance Service
Box 3, GPO
Adelaide, South Australia 5001
*+61 8 8274 0384
* fax +61 8 8271 4844
* norman.david at saambulance.com.au 


_______________________________________________
download-list mailing list
download-list at cedarville.edu 
http://mail.cedarville.edu/mailman/listinfo/download-list 

_______________________________________________
download-list mailing list
download-list at cedarville.edu 
http://mail.cedarville.edu/mailman/listinfo/download-list
_______________________________________________
download-list mailing list
download-list at cedarville.edu
http://mail.cedarville.edu/mailman/listinfo/download-list