XML as Database type

143 views
Skip to first unread message

ponnapati

unread,
Oct 22, 2009, 4:22:08 PM10/22/09
to XMPie Interest Group
HI ,

we are starting to implement XMPie in our company. I am doing
some basic learning on XMPie.
I am creating Plan file in uPlan.

1.File--> New Click on Single table plan Wizard
2.uPlan Wizard (Singke table comes up)
3.Click Next , Select XML as DataBase Type
4. select Database File from Local drive , say xyz.xml
5.Click Next , I get error failed to connect to the database.

My xyz.xml file looks like this.

<?xml version="1.0" encoding="utf-8" ?>
<email>
<EmailAddress>Anjaneya....@ConclusiveMarketing.com</
EmailAddress>
<EmailSubject>This is Ctrack Multi Channel implementation</
EmailSubject>
</email>

Can somebody tell me what I am doing worng here .

I appreciate your help.

Thank You,
Anjaneya.

Timothy Perrett

unread,
Oct 22, 2009, 6:47:25 PM10/22/09
to xmpie...@googlegroups.com
Uplan will only connect to an XML record set that follows the MS
standard. It will not connect to any old XML file with no schema.

You'll need to either do an xslt ahead of time or import it into an
RDBMS.

Cheers, Tim

Sent from my iPhone

Walter Van Waard

unread,
Oct 22, 2009, 4:54:54 PM10/22/09
to xmpie...@googlegroups.com
Hi,
As i recall, someone correct me if i am wrong, xmpie only supports the
microsoft standard xml layout.

Verstuurd vanaf mijn iPhone
Groeten,
Walter van waard

Op 22 okt 2009 om 22:22 heeft ponnapati <ponn...@gmail.com> het
volgende geschreven:\

Bill

unread,
Oct 23, 2009, 12:26:15 AM10/23/09
to XMPie Interest Group
Microsoft explanations and an example regarding the XML format, which
needs to be used as data sources for uPlan and uProduce, can be found
here:

http://msdn.microsoft.com/en-us/library/ms806128.aspx

On Oct 22, 10:22 pm, ponnapati <ponnap...@gmail.com> wrote:
> HI ,
>
>      we are starting to implement XMPie in our company. I am doing
> some basic learning on XMPie.
> I am creating Plan file in uPlan.
>
> 1.File--> New Click on Single table plan Wizard
> 2.uPlan Wizard (Singke table comes up)
> 3.Click Next , Select XML as DataBase Type
> 4. select Database File from Local drive , say xyz.xml
> 5.Click Next  , I get error failed to connect to the database.
>
> My xyz.xml file looks like this.
>
> <?xml version="1.0" encoding="utf-8" ?>
> <email>
>         <EmailAddress>Anjaneya.Ponnap...@ConclusiveMarketing.com</

ponnapati

unread,
Oct 23, 2009, 11:19:53 AM10/23/09
to XMPie Interest Group
Thank You Tim , Walter and Bill for your input. I am able to solve the
issue by converting XML to MS XML layout using Link giving by Bill.

It's really helpful.

Anjaneya.

On Oct 22, 4:22 pm, ponnapati <ponnap...@gmail.com> wrote:
> HI ,
>
>      we are starting to implement XMPie in our company. I am doing
> some basic learning on XMPie.
> I am creating Plan file in uPlan.
>
> 1.File--> New Click on Single table plan Wizard
> 2.uPlan Wizard (Singke table comes up)
> 3.Click Next , Select XML as DataBase Type
> 4. select Database File from Local drive , say xyz.xml
> 5.Click Next  , I get error failed to connect to the database.
>
> My xyz.xml file looks like this.
>
> <?xml version="1.0" encoding="utf-8" ?>
> <email>
>         <EmailAddress>Anjaneya.Ponnap...@ConclusiveMarketing.com</

Walter Van Waard

unread,
Oct 23, 2009, 1:08:14 PM10/23/09
to xmpie...@googlegroups.com, XMPie Interest Group
Your welcome :-)

Verstuurd vanaf mijn iPhone
Groeten,
Walter van waard

Op 23 okt 2009 om 17:19 heeft ponnapati <ponn...@gmail.com> het
volgende geschreven:\

>
Reply all
Reply to author
Forward
0 new messages