converting xml to csv - xmlLinguist - Products - SysOnyx Inc. - Message Board - Yuku

RSS
Email

0 Kudo

<< Previous Topic Next Topic >>

converting xml to csv

Author	Comment
Dennis25	converting xml to csv	Lead	[-]
Posts: 2 (08/20/04 07:32:45) Reply Quote More My Recent Posts Message Me Connection Blocking Invite Ignore User's Posts	Tags : None Hi, I'm trying to convert an xml file to csv. But I'm having trouble just opening the xml file in the first place. The xml file is very large and I don't want to have to specify every line manually. I would be very grateful for any help!!! Thanks in advance Dennis
Bryce K Nielsen	Re: converting xml to csv	#1	[-]
Posts: 230 (08/20/04 08:33:24) Administrator Reply Quote More My Recent Posts Message Me Connection Blocking Invite Ignore User's Posts	What tool are you opening the document in? xmlLinguist isn't designed to open an XML document, and there currently aren't any "import" features. Is the slow down in the translation step? And when you say very large, how big, in KB/MB? The basic steps for making a CSV with XML Linguist is as follows: - Create a document that has only ONE line - Set the Document.SeparationValue to a comma - Set the SkipLines to 1 (if your CSV contains column headers). Only useful when going from CSV to XML - The Line.Identifier can be left blank - Create the necessary fields. Look in the Help file under Tutorials/Single Map Files section for a simple tutorial on how to make this map. Note that your xml document in effect should look something like this: <DocumentName> <LineName> <Field1Name>Some value</Field1Name> <Field2Name>Some value</Field2Name> <Field3Name>Some value</Field3Name> <!-- etc... --- </LineName></DocumentName> where the different "Name" values match the Names in the xmlLinguist map. HTH, -BKN
Dennis25	Re: converting xml to csv	#2	[-]
Posts: 2 (08/29/04 23:59:30) Reply Quote More My Recent Posts Message Me Connection Blocking Invite Ignore User's Posts	Hi, thanks for your answer!! You already helped me with your comment that the xml linguistist cannot load xml filed. Therefore this tool is not correct for my needs. What I want to do is the following: I wand to load an xml file, maybe make some changes and create a csv file out of that. Is any of your tools capable of doing this? If not, do you have an idea what tool could help me? My files are about 370 MB large. So standard excel will not do, since the no of lines and columns is not enough. It would be great if you could help me out here. Thanks a lot Dennis
Bryce K Nielsen	Re: converting xml to csv	#3	[-]
Posts: 230 (08/31/04 08:49:57) Administrator Reply Quote More My Recent Posts Message Me Connection Blocking Invite Ignore User's Posts	370 MB XML Document? You probably won't find any tool that will be able to handle that. XML's biggest weakness is size. As a document approaches the tens of MBs in size, most tools crumble. Our xmlHack tool, a general, simple XML Editor, is one of the few that can handle larger documents. But even then, if the document is bigger than around 100 MB, it struggles. I don't think it could open a 370MB document... If it weren't for the size, xmlLinguist could be the tool you want. But the size contraint is going to be your killer. I can't think of any tool that would help here, sorry -BKN
RMittelman	Re: converting xml to csv	#4	[-]
Posts: 50 (10/26/04 10:58:12) Reply Quote More My Recent Posts Message Me Connection Blocking Invite Ignore User's Posts	This can be done using SAX. I wrote a VB program a couple of years ago to process 400MB+ files, and output to fixed-width text files. It's by no means a universal tool, as I had to customize it for particular node types.
Bryce K Nielsen	Re: converting xml to csv	#5	[-]
Posts: 230 (10/26/04 12:20:59) Administrator Reply Quote More My Recent Posts Message Me Connection Blocking Invite Ignore User's Posts	Yes, very true, and SAX is a lot easier on the memory of your machine, since it uses streaming technology (basically means only one element at a time is in memory, the rest is left on the harddrive, so your memory usage is only a couple KB at the most as it zips through the file). Currently, xmlLinguist uses DOM to do it's parsing. This does effectively give a limit to the size of documents we can process, though the limit is within practical means (I've translated upwards of 10mb EDI documents). However, version 1.5 will move the engine logic to streaming technologies, using SAX instead of DOM, etc., and this will give a huge performance boost in both speed and memory size (there will effectively be ZERO size limititation, well, actually the limitation will be the size of the harddrive). -BKN
mkandren	Re: converting xml to csv	#6	[-]
Posts: 1 (11/29/05 21:47:02) Reply Quote More My Recent Posts Message Me Connection Blocking Invite Ignore User's Posts	Hi Bryce, I stumbled onto your product xmlLinguist doing a Yahoo search on "XML to CSV". I have a need for a client to convert XML to PDB (Palm Database). I need to create the PDB on the PC so it will HotSync into the Palm OS device. My client's database is web based and they asked if they could supply it in XML. I told them I would look into it. I have written an XML parser before and they are a pain so your product may be a godsend. For if I can get their database into CSV files then it would be a snap for me to write a small Windows application to convert from CSV to PDB. I read this thread on the board here and I am wondering if your product will meet my need. For now I have two questions. 1. I am by no means an XML expert but what do you mean by ONE line in your post? Is ONE line equivalent to one record or row in a database? My client's database will not be large but it will have several records with one to many relationships to other records. 2. Does xmlLinguist have the option of NOT using a comma as a delimiter? Portions of the client database will have commas embedded into the actual data. So I would want to use a different character, perhaps a TAB. Is this possible? Thanks, Mike
Bryce K Nielsen	Re: converting xml to csv	#7	[-]
Posts: 230 (12/01/05 16:18:34) Administrator Reply Quote More My Recent Posts Message Me Connection Blocking Invite Ignore User's Posts	Mike, Quick answers: 1) One Line refers to the text file in question. When working with databases, this typically refers to one record in a table. 2) Yes, any character can be used. Within the document properties, for the Value Separator, if it's not a "character" then you can use the ASC(#) function, where # is the numeric value of the character in question. For example, TAB is ASC(9). Download the 30 day trial and tinker a little bit with it. If you have some lines from the XML exported database, I could write up a simple map to show you how this would be done. Also, check out www.sysonyx.com/xml-to-edi-850 for a tutorial on how to translate from XML to text (i.e. CSV in your case). -BKN

<< Previous Topic Next Topic >>

Quick Reply