Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Waiting and... waiting (XML Import into foxpro)
Message
From
26/11/2004 10:35:30
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
26/11/2004 02:37:34
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Miscellaneous
Thread ID:
00964849
Message ID:
00964930
Views:
7
>hi There,
>
>we have an application that reads in some XML files
>using the Microsoft DOM (MSXML2). In our program
>we step through every node and write the data for
>each node to a fox table.
>
>This works fine but takes very long time to complete!
>The XML input files are 20 to 40 Megabytes big, processing
>these files takes about 11 hours!
>
>Can anybody help me with;
>
>1) Is there a faster solution to import XML files into foxpro?
> --> The XML input files contain three or four levels, importing
> them with CURSORTOXML does not work because the output is a
> foxpro cursor with only the first level in fields and the rest
> foxpro puts into a memo field.
>
>2) is there any other solution to import XML in foxpro?
>
>3) is there a way to spead-up XML DOM?
>
>4) Any other suggestions?
>
>Hope anybody can help!
>
>Cheers,
>
>Erwin

Erwin,
If you've VFP8 (or for one time job download VFP9 beta) and XML was created with .NET ( a .NET dataset ) then XmlAdapter class can read and save it into multiple related tables.
PS: Never compared to XMLDOM speed.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform