On Tue, Nov 17, 2015 at 2:40 PM, Rob Stradling <rob.stradl...@comodo.com> wrote: > On 17/11/15 17:54, Kurt Roeckx wrote: >> >> On Tue, Nov 17, 2015 at 05:40:28PM +0000, Rob Stradling wrote: >>> >>> >>> Great. I tried importing the list into postgres but I couldn't persuade >>> it >>> to accept the invalid character encodings, so I gave up. >> >> >> When importing data in my postgres database I leave the fields >> NULL in case I really can't do anything sensable with it >> currently. > > > I had the same trouble with Peter's updated report, but I've just figured > out how to resolve it. There are ~1000 instances of "\x" in the .tsv file I > exported. After replacing each one with "\\x", postgres happily imported > the data.
I've uploaded the original CSV file to https://s3-us-west-2.amazonaws.com/pzb-public-files/invalid-dnsname.csv I suspect it might work better than the CSV -> Google Sheets -> TSV path. Thanks, Peter _______________________________________________ dev-security-policy mailing list dev-security-policy@lists.mozilla.org https://lists.mozilla.org/listinfo/dev-security-policy