Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Importing XML File (whith PowerBuilder 9)

424 views
Skip to first unread message

Sébastien

unread,
May 28, 2004, 10:39:10 AM5/28/04
to
Hello,

I want to insert data from an XML file into a datawindow.
I don't manage tu use the ImportFile function.
How can I do ?


--
Cordialement,
S.Alvarez
Tel. : 02-99-27-04-28


Paul Horan[TeamSybase]

unread,
May 28, 2004, 12:21:47 PM5/28/04
to
"Sébastien" <za...@pipo.com> wrote in message news:40b74f0e@forums-1-dub...


ImportFile() is the recommended method of importing XML into a datawindow. Have you tried using it? Are you seeing an
error message?

--
Paul Horan[TeamSybase]

Roy Kiesler [TeamSybase]

unread,
May 28, 2004, 1:29:32 PM5/28/04
to
Sébastien wrote:

> Hello,
>
> I want to insert data from an XML file into a datawindow.
> I don't manage tu use the ImportFile function.
> How can I do ?
>
>

We need a little bit more information -- please post again in the _XML_
forum, and include your datawindow definition, your export template and
the XML file you are trying to import, along with any error messages you
are getting.

--
Roy

Roy Kiesler [TeamSybase]

unread,
Jun 3, 2004, 11:53:56 AM6/3/04
to
Your first step is to create a datawindow for the underlying tables,
then create an XML export template that can generate this XML.

Once you can generate this XML, you'll be able to import it as well.

--
Roy

Sébastien wrote:
> Hello,
>
> See attached an example of file witch I recieve.
> It's the only information I have.
> I can have many 'MAITRE' witch contains many 'SOUS_TABLE' and 'LIGNE'
> Tables accessed may change.
>
> These datas will be inserted in many database defined in 'CONNEXIONS'
>
> If you can help me ...
> Sebastien
>
>
> <FICHIER>
> <TYPE>A</TYPE>
> <TABLE_MAITRE>TAB_REGL</TABLE_MAITRE>
> <CONNEXIONS>
> <CONNEXION>DBMS=O84;
> Database=NEXANS_REPLI;
> UserId=NEXANS_REPLI;
> DatabasePassword=NEXANS;
> LogPassword=NEXANS;
> ServerName=MARCEL;
> LogId=NEXANS_REPLI;
> DBParm=disablebind=1,DelimitIdentifier='No',DecimalSeparator=',',Date=' ''''dd/mm/yyyy'''' ';</CONNEXION>
> </CONNEXIONS>
> <MAITRE>
> <K_COD_SOC>NEX</K_COD_SOC>
> <K_COD_MOD_REG>X</K_COD_MOD_REG>
> <SOUS_TABLES>
> <SOUS_TABLE>
> <NOM_TABLE>TAB_REGL</NOM_TABLE>
> <LIEN>COD_SOC,COD_MOD_REG</LIEN>
> <LIGNE>
> <K_COD_SOC>NEX</K_COD_SOC>
> <K_COD_MOD_REG>X</K_COD_MOD_REG>
> <DEL_MOD_REG>0</DEL_MOD_REG>
> <DAT_BAS>F</DAT_BAS>
> <JOU_MOI></JOU_MOI>
> <FIN_MOI>0</FIN_MOI>
> <LIB_MOD_REG>X</LIB_MOD_REG>
> <COD_TCO>XX</COD_TCO>
> <DAT_CRE>21/11/2002 11:09:26</DAT_CRE>
> <USR_CRE>NEXANS</USR_CRE>
> <DAT_UPD>16/04/2004 14:30:52</DAT_UPD>
> <USR_UPD>NEXANS</USR_UPD>
> <COD_TYP_REG></COD_TYP_REG>
> <FLG_HSE>N</FLG_HSE>
> </LIGNE>
> </SOUS_TABLE>
> </SOUS_TABLES>
> </MAITRE>
> <MAITRE>
> <K_COD_SOC>NEX</K_COD_SOC>
> <K_COD_MOD_REG>SAL</K_COD_MOD_REG>
> <SOUS_TABLES>
> <SOUS_TABLE>
> <NOM_TABLE>TAB_REGL</NOM_TABLE>
> <LIEN>COD_SOC,COD_MOD_REG</LIEN>
> <LIGNE>
> <K_COD_SOC>NEX</K_COD_SOC>
> <K_COD_MOD_REG>SAL</K_COD_MOD_REG>
> <DEL_MOD_REG>5</DEL_MOD_REG>
> <DAT_BAS>F</DAT_BAS>
> <JOU_MOI>10</JOU_MOI>
> <FIN_MOI>0</FIN_MOI>
> <LIB_MOD_REG>TEST SAL</LIB_MOD_REG>
> <COD_TCO>ZAZA</COD_TCO>
> <DAT_CRE>19/05/2004 17:15:56</DAT_CRE>
> <USR_CRE>NEXANS</USR_CRE>
> <DAT_UPD></DAT_UPD>
> <USR_UPD></USR_UPD>
> <COD_TYP_REG></COD_TYP_REG>
> <FLG_HSE>O</FLG_HSE>
> </LIGNE>
> </SOUS_TABLE>
> </SOUS_TABLES>
> </MAITRE>
> <MAITRE>
> <K_COD_SOC>NEX</K_COD_SOC>
> <K_COD_MOD_REG>Z1</K_COD_MOD_REG>
> <SOUS_TABLES>
> <SOUS_TABLE>
> <NOM_TABLE>TAB_REGL</NOM_TABLE>
> <LIEN>COD_SOC,COD_MOD_REG</LIEN>
> <LIGNE>
> <K_COD_SOC>NEX</K_COD_SOC>
> <K_COD_MOD_REG>Z1</K_COD_MOD_REG>
> <DEL_MOD_REG>10</DEL_MOD_REG>
> <DAT_BAS>F</DAT_BAS>
> <JOU_MOI>5</JOU_MOI>
> <FIN_MOI>1</FIN_MOI>
> <LIB_MOD_REG>SAL SETTLEMENT METH 1</LIB_MOD_REG>
> <COD_TCO>POUET</COD_TCO>
> <DAT_CRE>27/05/2004 15:03:11</DAT_CRE>
> <USR_CRE>NEXANS</USR_CRE>
> <DAT_UPD></DAT_UPD>
> <USR_UPD></USR_UPD>
> <COD_TYP_REG>Z1</COD_TYP_REG>
> <FLG_HSE>N</FLG_HSE>
> </LIGNE>
> </SOUS_TABLE>
> </SOUS_TABLES>
> </MAITRE>
> <MAITRE>
> <K_COD_SOC>NEX</K_COD_SOC>
> <K_COD_MOD_REG>Z2</K_COD_MOD_REG>
> <SOUS_TABLES>
> <SOUS_TABLE>
> <NOM_TABLE>TAB_REGL</NOM_TABLE>
> <LIEN>COD_SOC,COD_MOD_REG</LIEN>
> <LIGNE>
> <K_COD_SOC>NEX</K_COD_SOC>
> <K_COD_MOD_REG>Z2</K_COD_MOD_REG>
> <DEL_MOD_REG>3</DEL_MOD_REG>
> <DAT_BAS>F</DAT_BAS>
> <JOU_MOI>1</JOU_MOI>
> <FIN_MOI>0</FIN_MOI>
> <LIB_MOD_REG>SAL SETTLEMENT METH 2</LIB_MOD_REG>
> <COD_TCO>ZOUP</COD_TCO>
> <DAT_CRE>27/05/2004 15:03:11</DAT_CRE>
> <USR_CRE>NEXANS</USR_CRE>
> <DAT_UPD></DAT_UPD>
> <USR_UPD></USR_UPD>
> <COD_TYP_REG>Z2</COD_TYP_REG>
> <FLG_HSE>N</FLG_HSE>
> </LIGNE>
> </SOUS_TABLE>
> </SOUS_TABLES>
> </MAITRE>
> </FICHIER>

0 new messages