<cfhttp> will do this for you - it returns a cvs file as a query
checkout the docs!
On 4/2/06, Nomad <[EMAIL PROTECTED]> wrote:
>
> Hello all!
> This is probably easy stuff for most.
> How do I handle null values in the source csv file when importing into db.
> The following lines of code work only when there is no null value in the
> source file.
> Also how do I handle commas that are in the data itself.
> Is there a custom tag or cf based utility that does all that which I can
> execute from a cf template?
> Codes that work only when the source file has no null fields or commas:
>
> <!--- get and read the CSV file --->
> <cffile action="read" file="Somefile.csv" variable="csvfile">
>
> <!--- loop through the CSV file on line breaks and insert into
> database --->
> <cfloop index="index" list="#csvfile#" delimiters="#chr(10)##chr(13)#">
> <cfquery name="importcsv" datasource="somedatasource">
> INSERT INTO Table1
> (modelno,details,dealerpartno,rrp,costprice,brand,subcategory)
> VALUES
> ('#listgetAt('#index#',1, ',')#',
> '#listgetAt('#index#',2, ',')#',
> '#listgetAt('#index#',3, ',')#',
> '#listgetAt('#index#',4, ',')#',
> '#listgetAt('#index#',5, ',')#',
> '#listgetAt('#index#',6, ',')#',
>
> '#listgetAt('#index#',7)#'
> )
> </cfquery>
> </cfloop>
> Mush appreciate any help.
> Thanks heaps.
> Ben.
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236280
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
