Exporting

  1.  
    1. mikelove
      May 2, 2008
      mikelove says:

      I tried to export all /film/film as a csv and got only 857 rows of data.  Advice?

      2. jeff
        May 5, 2008
        jeff says:

        That's a bug, all right. It's being tracked internally. I'm not award of any workarounds, short of using the API.

      3. mikelove
        May 8, 2008
        mikelove says:

        I forgot about data dumps.  http://download.freebase.com/datadumps/2008-03-28/browse/film/

      4. mikelove
        May 8, 2008
        mikelove says:

        I take it back, these have guids instead of compound values.

      5. Jun 2, 2008
        nathany says:

        so it's been about a month now - still no solution to the export problem?

      6. gmackenz
        Jun 2, 2008
        gmackenz says:

        We currently don't support exporting a large set of data (approximately around a 1000) via the export to csv feature. You either must use our data dump as mikelove discovered above, or write your own MQL query.

         You can see what our filter view page uses by hitting F8 key to get the debug bar and clicking on the 'View transaction log' (its the client MQL query event you want).

         You can use that as a starting point (hint, modify the limit or eliminate it entirely).

      7. gmackenz
        Jun 2, 2008
        gmackenz says:

        Here's a starter query to get all the film titles currently in the system:

         [
          {
            "limit" : 40000,
            "name" : null,
            "type" : "/film/film"
          }
        ]


    Discussion is posted in:

    Think this discussion also relates to something else? Cross-post it by adding a new discussion area:

Related Discussions