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 On Mon, Jun 21, 2010 at 10:34 PM, Jim Idle <[email protected]> wrote: > 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 > > > -----Original Message----- > > From: [email protected] [mailto:[email protected]] On Behalf > > Of wagdy mounir > > Sent: Monday, June 21, 2010 2:50 AM > > To: jBASE > > Subject: T24: Importing XML file to database tabe > > > > 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 > > > > -- > > 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 [email protected] > > To unsubscribe, send email to [email protected] > > For more options, visit this group at > > http://groups.google.com/group/jBASE?hl=en > > > > -- > 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 [email protected] > To unsubscribe, send email to [email protected] > For more options, visit this group at > http://groups.google.com/group/jBASE?hl=en > -- Regards Mujtaba Yousuf Khan T24 Consultant -- 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 [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
