如何将Cloud Firestore数据库集合下载到JSON或CSV文件中?

如何将Cloud Firestore数据库集合下载到JSON或CSV文件中?

问题描述:

好了,这就是问题,我已经在Flutter/Firebase项目上工作了一段时间,现在我的客户想知道是否有可能从Cloud Firestore数据库的某个集合中获取CSV o JSON文件用于稍后由Power Bi或其他数据分析工具处理.

Okay so here is the thing, I have been working on a Flutter/Firebase project for a while and now my client is wondering if there's any chance of getting a CSV o JSON file from a certain collection of the Cloud Firestore database for later on being processed by Power Bi or some other data analysis tool.

为更清楚起见,我一直在考虑构建一个带有Firebase的简单ElectronJS桌面应用程序,该应用程序具有一个简单的界面,该界面很适合我的客户单击一些内容,从而从文件中获取带有选定集合/文档的文件.Cloud Firestore数据库.

For being more clear, I have been thinking about building a simple ElectronJS desktop app with Firebase on it, with a simple interface that can be suitable for my client to click few things a get a file with selected collections/documents from the Cloud Firestore database.

我已经进行了调查,但是唯一可行的结果是使用Google Cloud Console的导出/导入工具,但是对于不熟悉Google Cloud环境的人来说,这确实是一个令人头疼的事情,除了它不是一个合适的选择之外对于客户而言,考虑到他需要一个简单而有效的UI/UX设计来进行交互.

I have investigated but the only result that kind of works is using the Export/Import tool of Google Cloud Console, but it is a real headache for someone who's not familiarized with the Google Cloud environment, besides it is not a suitable choice for the client, considering he needs a simple and efficient UI/UX design for interacting with.

如果您需要更多信息,请评论或直接写信给我benjamin.caceres.ra@gmail.com非常感谢!:)

If you need more info just comment or write to me directly benjamin.caceres.ra@gmail.com Thanks a lot! :)

没有提供工具来格式化导出Firestore数据.您将需要编写代码来查询数据库,迭代文档并以所需的格式编写输出.

There is no provided tooling to get a formatted export of Firestore data. You're going to have to write code to query the database, iterate the documents, and write the output in the format you want.