Re: from CSV to XML

2007-07-08 Thread [Sunshine Tech Solutions] Ravi Gehlot
Hey Mike, You are right. But the TRIAL version did the conversion. So thanks to Sean Corfield for pointing that out. However, I am not happy yet. I don't want to use that software, I want to write the XML myself. What is the fun of having a software do the job? I have been doing a lot of r

Re: from CSV to XML

2007-07-08 Thread Mike Kear
Strictly speaking it's not free, but you might already have MS Excel. Later versions can save as XML. If you have such a version, you could read your CSV file in to excel, then save it as XML. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks ht

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
Cool. That's why they say that XML is not a language but a meta-language. Unlike HTML that it has its own tags, XML can have tags created by the developer accordingly by creating DTD or schemas. Ravi. Dave Watts wrote: >> Is there a list of specific XML languages? >> > > No, because anyon

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
Sean, I have to say THANK YOU! I got the file converted in seconds with the software you indicated me. Now I know what wddx means and I also know how the XML file needs to look like. I won't sleep tonight till I read and learn about XML. Will try the ColdFusion tags also. Ravi. -- --

RE: from CSV to XML

2007-07-07 Thread Dave Watts
> Is there a list of specific XML languages? No, because anyone can create their own language by creating a DTD or schema. > They company has a portal that knows how to treat XML data > so it let's the end user upload an XML file that is then > imported into a SQL database through their portal

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
Wow! This makes a lot more sense now Dave. So the WDDX from the CFWDDX means the type of XML struct used. Great. Thanks, Ravi. Dave Watts wrote: >> But Ravi told use he has a CSV file he wants to be formated in XML. >> For me it is clear: a CSV file is a format to represent a table. >> A table

RE: from CSV to XML

2007-07-07 Thread Dave Watts
> But Ravi told use he has a CSV file he wants to be formated in XML. > For me it is clear: a CSV file is a format to represent a table. > A table can be formated in XML, and there are not thousands > of ways to represent a table in XML. Sure there are. I can think of several offhand; WDDX, the Q

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
Aaron, You are right on that. I will ask them the proper format. It is useless to put time into something and then change it later. Maybe I wasn't clear here but all I want is to know how to do it so that when I get there on Monday it be easier. Thanks, Ravi. Aaron Rouse wrote: > Sorry, b

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
Hey Sean, Thanks for the patience and thanks for putting the time in showing me how to be a better programmer. Also, I have looked over your BLOG and I have to see you did an awesome job with it. Your last e-mail was printed out and well kept for future consults. Thanks, Ravi. Sean Corfie

Re: from CSV to XML

2007-07-07 Thread Sean Corfield
On 7/7/07, [Sunshine Tech Solutions] Ravi Gehlot <[EMAIL PROTECTED]> wrote: > My sole goal is to learn and > become a better programmer. In my first response to you in this thread I suggested CFHTTP and CFWDDX as possible solutions. You can learn and become a better programmer by looking them up i

Re: from CSV to XML

2007-07-07 Thread Aaron Rouse
Sorry, but I do not think you know how to find your food because the questions you are asking could VERY EASILY be answered via some google searches. If it does not matter if what you do works with the portal or not then just take any of the available web based examples for building XML via CFM an

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
Hey Sean, Yes, I am a beginner in the ColdFusion world. You shouldn't be worried about providing me "the straight solution" so that I could get by. If you think that my interest here is to get by using your knowledge then please deviate from this thinking. My sole goal is to learn and beco

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
Hey Claude, That helps. Thanks! CFHTTP is already in use. What would WDDX stand for? Just curious...gotta google. it. Ravi. Claude Schneegans wrote: > >>what would be the next step in building this XML file? > > I would rather try to read the table using CFHTTP to build a query, > althoug

Re: from CSV to XML

2007-07-07 Thread Claude Schneegans
>>what would be the next step in building this XML file? I would rather try to read the table using CFHTTP to build a query, although CFHTTP will not read ANY CSV format. Then have a look at the tag http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address:

Re: from CSV to XML

2007-07-07 Thread Sean Corfield
On 7/7/07, [Sunshine Tech Solutions] Ravi Gehlot <[EMAIL PROTECTED]> wrote: > It was a piece of work so far to get where I got. First, the CSV > file was delimited by pound signs so I had to use the replace function > to replace it with commas then to REreplace it to get rid of unwanted You re

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
Aaron, I want to choose a format and get this done by Monday. They want to see something done by Monday. Whether it will work or not with the Portal I will have to see it with them on Monday. I understand that the Portal understands a type of XML construct and it will brake if another fash

Re: from CSV to XML

2007-07-07 Thread Aaron Rouse
There are a few ways to do this and a simple google search should return them. You still need to know what the format of the XML needs to be in, in order for it to work with the portal. The portal is going to be designed to work with XML laid out in a certain fashion. On 7/7/07, [Sunshine Tech S

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
So in this case, the XML type is tables. Correct? After I read the CSV file with CFFILE action set to read, built a query in memory with CFHTTP what would be the next step in building this XML file? Ravi. Claude Schneegans wrote: > >>To elaborate on this a little bit, XML isn't a language. Say

Re: from CSV to XML

2007-07-07 Thread Claude Schneegans
>>To elaborate on this a little bit, XML isn't a language. Saying you want something "in XML" doesn't really make sense. You are right that XML is not a language, it is rather a "format", a format able to represent about anything. But Ravi told use he has a CSV file he wants to be formated in XM

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
Hey Dave, Is there a list of specific XML languages? They company has a portal that knows how to treat XML data so it let's the end user upload an XML file that is then imported into a SQL database through their portal. Ravi. Dave Watts wrote: >> No, *you* need to be more specific. XML can

RE: from CSV to XML

2007-07-07 Thread Dave Watts
> No, *you* need to be more specific. XML can be *any* format. > Depending on the XML format *you* want, you will have to > write code a particular way. To elaborate on this a little bit, XML isn't a language. Saying you want something "in XML" doesn't really make sense. What you really want is

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
Hey Sean, I will do a little research on the type of XML I need and then will get back at you. As far as tag-wise would use CFWDDX? Ravi. Sean Corfield wrote: > On 7/7/07, [Sunshine Tech Solutions] Ravi Gehlot > <[EMAIL PROTECTED]> wrote: > >> How could I better answer your question? Cou

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
Hey Sean, I never asked you to do my homework. I have always worked for my salary. Sorry to have bother. Thank You. Ravi. Sean Corfield wrote: > On 7/7/07, [Sunshine Tech Solutions] Ravi Gehlot > <[EMAIL PROTECTED]> wrote: > >> How could I better answer your question? Could you be more s

Re: from CSV to XML

2007-07-07 Thread Sean Corfield
On 7/7/07, [Sunshine Tech Solutions] Ravi Gehlot <[EMAIL PROTECTED]> wrote: > How could I better answer your question? Could you be more specific? No, *you* need to be more specific. XML can be *any* format. Depending on the XML format *you* want, you will have to write code a particular way. > W

from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
How could I better answer your question? Could you be more specific? The XML needs to be one that it can be used to import those delimited column fields in the previous CSV file. I know you might be thinking...well...why don't they just import the CSV into the SQL database. Well, that's the bos

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
How could I better answer your question? Could you be more specific? The XML needs to be one that it can be used to import those delimited column fields in the previous XML file. I know you might be thinking...well...why don't they just import it to the SQL database. Well, that's the boss that

Re: from CSV to XML

2007-07-07 Thread Sean Corfield
On 7/7/07, [Sunshine Tech Solutions] Ravi Gehlot <[EMAIL PROTECTED]> wrote: > Cool, so I got the query successfully in the memory. It works just as > nice as I thought it would. How do I go about generating the "whatever" > XML I need? Well, that depends on the XML you need to generate... -- Sean

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
Cool, so I got the query successfully in the memory. It works just as nice as I thought it would. How do I go about generating the "whatever" XML I need? YES! Thank you for pointing out XMLBuddy. I downloaded and placed it on my plugins directory and then re-started Eclipse and then XML was im

Re: from CSV to XML

2007-07-07 Thread Sean Corfield
On 7/7/07, [Sunshine Tech Solutions] Ravi Gehlot <[EMAIL PROTECTED]> wrote: > But using CFHTTP to produce the query from the CSV file is quite > possible and then having it imported some how in XML format. Once you have a query in memory, you can easily generate whatever XML you need from it in a

Re: from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
Hey Sean, If I use CFHTTP to produce a query from that CSV file what other tool could I use to generate the file. You are completely correct when you say that the question didn't make any sense since with XML we can produce our own tags depending on the type of content structure given. B

Re: from CSV to XML

2007-07-07 Thread Sean Corfield
On 7/7/07, [Sunshine Tech Solutions] Ravi Gehlot <[EMAIL PROTECTED]> wrote: > I was asked to convert a CSV file to XML. Is there free a converter > out there? Since XML can have any format, that question doesn't really make sense. Conversion of CSV to XML is going to depend on what format XML

from CSV to XML

2007-07-07 Thread [Sunshine Tech Solutions] Ravi Gehlot
Hi, I was asked to convert a CSV file to XML. Is there free a converter out there? Also, is there a free XML plugin for Eclipse? Ravi. -- --- Ravi Gehlot. Sr. Management Sunshine Technology Solutions, LLC http://www.sunshinetechsolutions.com/ [EMAIL