Rendering in XML ?

Question

Post reply

Rendering in XML ?

jbalbo

SSCertifiable

Points: 7580

January 14, 2020 at 3:45 pm

#3715273

Hi,

I haven't used the Export to XML function and wondering if anyone has used it, and can share how to setup my data in the report so it renders correctly

Here is a sample any info/links etc would be helpful

Thanks

Joe

<?xml version="1.0" encoding="utf-8"?>
<!-- Created with Liquid Technologies Online Tools 1.0 (https://www.liquid-technologies.com) -->
<clients xmlns="http://casetivity.com/datamodel.xsd"
xsi:schemaLocation="http://casetivity.com/datamodel.xsd schema.xsd"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Client>
<firstName>First</firstName>
<middleName>Middle</middleName>
<lastName>Last</lastName>
<birthDate>2019-01-01</birthDate>
<nickname>Nickname</nickname>
<multipleBirth>0</multipleBirth>
<consentToShare>0</consentToShare>
<spokenLanguageOther></spokenLanguageOther>
<writtenLanguageOther></writtenLanguageOther>
<nameWithheld>true</nameWithheld>
<currentAddress>
<line1>123 Main St</line1>
<line2></line2>
<zip>02222</zip>
<communityCode>NEEDHAM</communityCode>
<stateCode>MA</stateCode>
</currentAddress>

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80320 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

I am looking at what you posted and wondering what your actual question is. There really isn't much to work with in your post.

Sue_H SSC Guru Points: 90860 More actions · Answer 3

The export to XML doesn't export anything related to the layout or pagination. It just exports the data in XML form, that's it. You'd use it for an XML message, saving data as XML to a database or for use by some other application.

Sue

jbalbo SSCertifiable Points: 7580 More actions · Answer 4

Sorry for being SO vague, just wasn't sure what to ask....

So the XML, I posted was part of a layout I received for data to send on a monthly basis .

Part of what I need to send some client info.

So if I were to write a query in the sample , lets say I have dbo.Client and dbo.Address tables , how would I layout the data in XML so it's similar to my sample.

Thanks

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

jbalbo wrote:

Sorry for being SO vague, just wasn't sure what to ask....
So the XML, I posted was part of a layout I received for data to send on a monthly basis .
Part of what I need to send some client info.
So if I were to write a query in the sample , lets say I have dbo.Client and dbo.Address tables , how would I layout the data in XML so it's similar to my sample.
Thanks

First of all, the XML you posted is incomplete and not properly formed.

Second, to help you with the SQL you would need to post the DDL for the two tables as well as sample data to populate those tables.

The SQL code would then use the FOR XML clause, which one specifically depends.

jbalbo SSCertifiable Points: 7580 More actions · Answer 6

Thanks Lynn,

let me work on this and I'll send a better sample

jbalbo SSCertifiable Points: 7580 More actions · Answer 7

Hi

So here is some sample code for the first 15 fields

and attached is a sample of the entire XML

Thanks

SELECT People.[First Name],
       People.[Middle Initial],
       People.[Last Name],
       People.Birthdate,
       People.Nickname,
       '0' AS MutipleBirth,
  '0' as consentToShare,
       PersonAddress.Address,
       PersonAddress.[Address 2],
       PersonAddress.[Zip/Postal Code],
       PersonAddress.[City/Town] AS Community,
       PersonAddress.[State/Locality] AS stateCode,
       Languages.Name AS SpokenLang,
  Languages.Name AS WritteLang,
  (select top 1 Enum from Enrollments where OBJECTID = people.objectID ) as enrollmentNumber
FROM People
     INNER JOIN  PersonAddress ON People.ObjectID = PersonAddress.Person
     INNER JOIN Languages ON People.ObjectID = Languages.ID;

Attachments:

You must be logged in to view attached files.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 8

jbalbo wrote:

Hi

So here is some sample code for the first 15 fields

and attached is a sample of the entire XML

Thanks

SELECT People.[First Name],
       People.[Middle Initial],
       People.[Last Name],
       People.Birthdate,
       People.Nickname,
       '0' AS MutipleBirth,
  '0' as consentToShare,
       PersonAddress.Address,
       PersonAddress.[Address 2],
       PersonAddress.[Zip/Postal Code],
       PersonAddress.[City/Town] AS Community,
       PersonAddress.[State/Locality] AS stateCode,
       Languages.Name AS SpokenLang,
  Languages.Name AS WritteLang,
  (select top 1 Enum from Enrollments where OBJECTID = people.objectID ) as enrollmentNumber
FROM People
     INNER JOIN  PersonAddress ON People.ObjectID = PersonAddress.Person
     INNER JOIN Languages ON People.ObjectID = Languages.ID;

And the DDL and sample data for the tables?