Export class to Excel/CSV?

[Ruben]

Hi!

How is the best way to export a class with the data containing to a Excel format or CSV?

That would be a very crucial feature for us.

Thanks!

Ruben

[Davi Macêdo]

Hi Ruben. This feature is not yet available. The best way to do it is to write a script to reach the api and write the file. Another option is export directly from mongodb database. Best!

[price...@gmail.com]

Hi Davi! Can you make example or quide about export directly from mongodb database?

[Davi Macêdo]

Hi. To export directly from mongodb you can use mongodump command as specified in the link below:

https://docs.mongodb.com/manual/reference/program/mongodump/

[rmkons...@gmail.com]

Ok! Thank you!=)

[in...@rubentavares.de]

Hi Davi, do you have an example for the script API method? Would this work over the cloud code import file way? Thanks!

[Davi Macêdo]

Hi.

I built a public API to exemplify.

This is the public API:

https://www.back4app.com/api/Export%20Example-YKjNQyNBBsaJpRlcSRxBfR3yKCGdU395XzZfqjdB

And here is the example:

https://gist.github.com/davimacedo/a4d1e189c485dab52678df6bc4b2d93d

Basically you have to upload a cloud code file like this one here:

https://gist.github.com/davimacedo/a4d1e189c485dab52678df6bc4b2d93d#file-main-js

And run a curl command like this one here:

https://gist.github.com/davimacedo/a4d1e189c485dab52678df6bc4b2d93d#file-curl-sh

It is limited to 100 rows. You can increase this limit to 1000 rows using limit() function. If you need more than it you have to change the code little bit to retrieve 1000 then 1000...

Best.

[Ruben]

Hi Davi,

thanks!

Could you exemplify the code to be used for >1000 rows?

I am a newbie in curl. And I need this function urgently today.

But your code for 100 rows works for me :)

Thanks!

Ruben Tavares

[in...@rubentavares.de]

Hi Davi,

I would maybe also want this to be executed via a button on a webpage.

I want it to be saved on the server as results.json. How do I accomplish that?

I found this: http://stackoverflow.com/questions/6235785/run-a-shell-script-with-an-html-button

But it's not saving out.json anywhere. Would I need to specify the path?

Thanks!

Ruben Tavares

[Davi Macêdo]

Hi, Ruben.

Sorry about the delay.

You can try something like it to export all data:

Parse.Cloud.define("export", function (request, response) {

  var consolidatedResults = [];

  export1000();

  function export1000 (partialResults) {

    if (partialResults) {

      consolidatedResults = consolidatedResults.concat(partialResults);

      if (partialResults.length < 1000) {

        response.success(consolidatedResults);

        return;

      }

    }

    var ExportObject = Parse.Object.extend(request.params.exportClass);

    var query = new Parse.Query(ExportObject);

    query.limit(1000);

    query.skip(consolidatedResults.length);

    query.find({ success: export1000, error: response.error });

  }

});

I have not tested ok? :)

Please, let me know.

[Davi Macêdo]

Hi, Ruben.

About exporting button, the stackoverflow response seems to work fine. But you have to make sure that you have php installed.

It will probably create the file in the same folder the application is running.

Best!