Coder Social home page Coder Social logo

Comments (2)

ajschumacher avatar ajschumacher commented on August 17, 2024

It looks like the problem is that not all the internal quotes are getting escaped (where here I mean it in the goofy RFC 4180 double-quote-is-the-escape-for-a-quote-sense). Take a look at line ten of the CSV in what you linked to:

FedScope Accessions Cubes,"This raw data set provides the actual number of personnel actions (""Transfer-Ins" and "New Hires") ...

Those quotes were " escaped in the JSON, but only the first one is getting double-quote escaped in here. Is some regex not /g?

from json.

konklone avatar konklone commented on August 17, 2024

Good eye, @ajschumacher, you are right. And making matters worse, this version of jquery-csv is unsupported - it's 0.70, and 0.71 actually removes the fromObjects method entirely.

The real solution is to replace jquery-csv with our own flat-object-to-csv output method (which won't need all the fanciness of jquery-csv).

In the meantime, I've hotfixed the problem in jquery-csv in 4563d9c, and http://konklone.io/json/?id=9415277 should now parse OPM's /data.json file correctly.

Thanks @ajschumacher! And to @philipashlock, who originally reported this.

from json.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.