I’m currently in the process of setting up Atlas, WebAPI, and Achilles in order to start testing our CDM. I have been struggling with getting the concept table populated today and got stuck on this error for way too long.
ERROR: value too long for type character varying(255)
CONTEXT: COPY concept, line 16548, column concept_name: “Rollabout chair, any and all types with casters 5 or greater Device HCPCS HCPCS S E1031 19900101 209…”
There was a double quote here on this line, but even after removing it it still kept trying to read the entire line into concept_name.
Anyways, this psql command seems to have finally worked.
\copy omop.concept (concept_id, concept_name, domain_id, vocabulary_id, concept_class_id, standard_concept, concept_code, valid_start_date, valid_end_date, invalid_reason) FROM <your-path-to-concept.csv> WITH (FORMAT csv, DELIMITER E’\t’, HEADER, QUOTE E’\b’);