T24: Importing XML file to database tabe

[wagdy mounir]

Dear All,
I am trying to find a way to import an XML file holds some data to a
table on T24 using JBASE
i found the functions below

XMLTODYN

AND

DYNTOXML

But i want an example shows how to import the data from XML file to a
table.
Note: i don’t have the XSL file. i only got the XML and XSD

[Jim Idle]

It's just text - write a jBC program if you have no XSL.

Or use Netbeans or something similar to generate the Schema from the data then use that schema in a program; write a Java program to extract the XML data and send to jBASE; write a Java function to call using CALLJ that returns the records one at a time and write them out as they are returned; Import to an SQL database, then read back using jBASE; translate by hand to raw binary then use the 1 and 0 keys until they wear out;

You will have to model the file yourself - I do not think there are any magic bullets to do that for you.

Jim

> --
> Please read the posting guidelines at:
> http://groups.google.com/group/jBASE/web/Posting%20Guidelines
>
> IMPORTANT: Type T24: at the start of the subject line for questions
> specific to Globus/T24
>
> To post, send email to jB...@googlegroups.com
> To unsubscribe, send email to jBASE-un...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/jBASE?hl=en

[Mujtaba Khan]

Hi,

  Another logic is to convert XMLDATA into (general DB form) is by write a PL/SQL trigger as <C1 ><C2> is used to identify as column and <m1><m2> is used for multi value fields so understand the logic and build your own trigger .. than attached this trigger to parse the XML data into any DB like oracle or sqlserver ... with in ETL Utility of the database.

Regards

Mujtaba Khan

--
Regards

Mujtaba Yousuf Khan
T24 Consultant