I'm getting errors when attempting to import this file. I've tried it with both the Import function and the PM inbound interface.
I'm using Client 198. Server 0.0.70
"ALLEN","LAKARRA","L","1133767","13962 LEATHERGLASS","CORSICANA","TX","75110","000008123","9032292440","","08112006","F","TMHP TEXAS HEALTH STEPS","undefined","","","","SMITH","JOHN","","WHITE","ERIC"
This is the error message from Synapse:
make object! [
code: 329
type: 'script
id: 'bad-bad
arg1: "ODBC"
arg2: {conversion error from string " "}
arg3: none
near: [insert db-port [{insert into users (userid, fnames, surname, gender, dob, salut, reminder, answer, pass, occupation, ethnic, ssn, street1, street2, town, city, state, zip, security, workph, homeph, cellph, email, altcontact, altph, relation, location, activ, abook, cpmsid ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? , ?, ?, ? ) }
userid fnames surname gender dob salut "" "" pass occupation ethnic ssn street1 street2 town
city state zip 0 workph homeph cellph email altcontact altph relation location activ mold/all abook form pmsid
]]
where: 'add-zybex-patient
]