Skip to content

import script dies on ngl_foreign_addresses #2

@kbowerma

Description

@kbowerma

script stops after 8 hours with:

[2017-12-20T06:47:33.725Z][INFO] Processing file: ngl_foreign_addresses.csv 
[2017-12-20T06:47:35.767Z][ERROR] invalid input syntax for integer: "N7T 7H5" 
[2017-12-20T06:47:35.767Z][ERROR]  
	{"name":"SequelizeDatabaseError","parent":{"name":"error","length":101,"severity":"ERROR","code":"22P02","position":"186","file":"numutils.c","line":"62","routine":"pg_atoi","sql":"INSERT INTO \"Cemeteries\" (\"cem_id\",\"cem_name\",\"cem_addr_one\",\"city\",\"state\",\"zip\") VALUES ('aamjiwnaang cemetery-river rd.-ontario','AAMJIWNAANG CEMETERY','RIVER RD.','SARNIA','SARNIA','N7T 7H5') RETURNING *;"},"original":{"$ref":"$[\"meta\"][\"parent\"]"},"sql":"INSERT INTO \"Cemeteries\" (\"cem_id\",\"cem_name\",\"cem_addr_one\",\"city\",\"state\",\"zip\") VALUES ('aamjiwnaang cemetery-river rd.-ontario','AAMJIWNAANG CEMETERY','RIVER RD.','SARNIA','SARNIA','N7T 7H5') RETURNING *;"}


Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions