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
fashion is used. I just want to format it in XML so they know I know
what I am doing. Later on Monday, I can adapt it to what it needs to be.
There will be a meeting and I will bring this up.
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
spaces. Before this replace could be possible CFDIRECTORY and CFFILE was
used to read only CSV type of files. Then CFHTTP was used to read the
delimited CSV file and build a query in memory. All I need is to use
that query in memory built from CFHTTP to build an XML file. Any
suggestions?
Ravi.
Aaron Rouse wrote:
> 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 Solutions] Ravi Gehlot <
> [EMAIL PROTECTED]> wrote:
>
>> 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. 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 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.
>>>
>>>
>>>
>> --
>> -------------------------------------------
>> Ravi Gehlot.
>> Sr. Management
>> Sunshine Technology Solutions, LLC
>> http://www.sunshinetechsolutions.com/
>> [EMAIL PROTECTED]
>> Cell Phone: (407) 860-3775
>> Business Line: (407) 745-1433
>> -------------------------------------------
>>
>> Confidentiality Notice: This message including any
>> attachments is for the sole use of the intended
>> recipient(s) and may contain confidential and privileged
>> information. Any unauthorized review, use, disclosure or
>> distribution is prohibited. If you are not the
>> intended recipient, please contact the sender and
>> delete any copies of this message.
>>
>>
>>
>>
>>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283168
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
