I have this code here;I am trying to read a csv file but when I run this code I get <LIST>%open+3^%stream.Object.1 would anyone have a look and tell me where I am going wrong .Record mapper is fine but I need a custom csv Importer
> ClassMethod ImportCSV()
> {
> set adapter =##class(%File).%New()
>
> set status=adapter.%Open("C:\In\in.csv")
>
> if $$$ISERR(status)
> {
> do $System.Status.DisplayError(status)
> }
>
> set counter =1
>
> while 'adapter.AtEnd
> {
> set line=adapter.ReadLine()
>
> set rec= ##class(CSVRecord).%New()
>
> set rec.ID=$piece(line,",",1)
> set rec.FName=$piece(line,",",2)
> set rec.SecName=$piece(line,",",3)
> set rec.Gender=$piece(line,",",4)
> set rec.Age=$piece(line,",",5)
>
> write rec.ID,
>
> rec.FName,
>
> ` rec.Secname ,`
>
> ` rec.Gender,`
>
> ` rec.Age,!<br> <br> Set savestatus=rec.%Save()<br> <br> if $$$ISERR(savestatus)<br> {<br> do $System.Status.DisplayError(status)<br> }<br> <br> }<br> <br> //if error found during processing,show it<br> if $$$ISERR(status)<br> {<br> do $System.Status.DisplayError(status)<br> }<br>}`