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:236278
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
