Got it! Import data using .col file - number field

HCL Domino Domino Forum
1

I moved the number column to the last column and this worked.

I have a .col file that I am using to import a file. The problem is the first column is a number, so while my Notrix job runs and everything appears to be ‘ok’ - I get no data. I tested by not pulling that number column and get the 263 documents I’m to get. How can I define a number as text in the .col file? I tried using: FIELD GEO_CODE:=@Trim(@Text(GEO_CODE)); but that didn’t work. Thanks.

2

Subject: Got it! Import data using .col file - number field

I haven’t wrote COL files in awhile, but I remember that you can type the data with the proper argument. The following example come from the Designer Help:

fieldName: TYPE DATETIME

I think you can do the same for

fieldNumber: TYPE NUMBER

I’ll have look back at some of my past work to see if I used the data qualifiers before.

Without seeing your entire COL file, I can’t tell if your syntax is correct… Can you post three to five typical data rows from your import file? This is not a Notrix issue; it can be tested with a basic File, Import operation (using a COL file).

john