Importing multiple records in CSV file

Question

Question

Mack Altman · Feb 16, 2018

#CSV #DTL #Object Data Model #SQL #Caché

I came across How to import a tab separated text file into a SQL table programmatically?, which appears to indicate that I can pass the filename and all records will be imported. However, when I put use the Import method only a single record gets imported. However, all records are imported if I use the management console to import the file by selecting it and choosing the options.

Has anyone ran into this in the past?

Discussion (3)0

Log in or sign up to continue

Eduard Lebedyuk · Mar 14, 2018

When you're using Import, one record that imports - is it correct (corresponds to one string in csv)?

0 0

score 0 · Answer 1 · 2018-02-17T03:13:19-05:00

Have you modified Import method in your class to show errors?

 if $$$ISOK(tStatus) { set tCounter = tCounter + 1 } else { w $System.Status.GetErrorText(tStatus) return}

Most likely you're getting an error and import stops.

score 0 · Answer 2 · 2018-03-13T17:31:00-04:00

Mack Altman · Mar 13, 2018

I did this as instructed on the referenced post, but no errors are being encountered.

0 0