Import Excel Data into Firebase Database

I had a table of data that I wanted to feed into Firebase Realtime Database which has to be in JSON format.
The table looks like this:


Make sure that the key names for the JSON file should be the top row of the table.

Now save the file as .csv in Excel:



Go the https://codebeautify.org/csv-to-xml-json and browse the csv file and click on "CSV to JSON" button and then on "Download".

In Firebase realtime database, click on the 3 dots icon on the right as shown in the image below:




Then click on "Import JSON" as shown below:


Then browse the downloaded JSON file and click on "Import". You will get the result as shown below:



Comments

Post a Comment

Popular posts from this blog

ADB Cheat Sheet

Lists all settings adb shell settings list global enables "show taps" on the UI adb shell settings put system show_touches 1 set the battery state as unplugged adb shell dumpsys battery unplug To set the battery percentage adb shell dumpsys battery set level 65 http://mikepalarz.me/2019/04/dumpsys-battery set the battery state as what is original(not so sure about this, you can try it out) adb shell dumpsys battery reset Return 1 if device is in battery saver mode, else returns 0 adb shell settings get global battery_saver_mode To show list of activities in backstack. I have discovered this command with lot of research. adb shell settings put global zen_mode 1 adb shell "pidof com.google.android.wearable.sysui | xargs kill" adb shell dumpsys activity activities| grep "* Hist" Command for accessibility https://gist.github.com/mrk-han/67a98616e43f86f8482c5ee6dd3faabe Enable wifi adb shell svc wifi enable This is not working.Haven't found a right solutio...
Read more

Enabling Internet in Android Emulator

Image
 This experiment is run on a Mac Laptop. For Windows, the file path may be different but the commands should be essentially the same. 1. cd to the location: `~/Library/Android/sdk/emulator` Now view the list of available emulators with: ` ./emulator -list-avds` Say you want to enable internet in the first device Nexus_5_API_30,  make sure the emulator isn't running(it's closed), then run the following command: ` ./emulator -avd Nexus_5_API_30 -dns-server 8.8.8.8 -read-only` Now the emulator starts and you can browse internet in it.  Most importantly you can now sign in to Google Play store and perform various operations, like in my case I needed to pair a phone emulator to a watch emulator which needed Wear OS app to be installed on the phone and that needed Google Play Store login. Let me know if this works for you or not.
Read more

Important GIT Techniques

To find the names of all files that were changed (deleted, modified or added) in a given commit git diff-tree --no-commit-id --name-only -r bd61ad98 To save those files' names to output.txt git diff-tree --no-commit-id --name-only -r bd61ad98 > output.tx ========================== Using diff2html-cli for generating preety diff between two commits: Install diff2html-cli: Install node first, In command line brew install node Then install diff2html-cli, in command line type: npm install -g diff2html-cli Run the command to find the diff.html file: git diff 8f8428f0d da63cef6c | diff2html -i stdin ============================= Scenario: You have cloned a project from github, you were working locally on it, changed the projects and commited to new local branch(Eg PostMethod). Now you want to also create a remote branch by same name(PostMethod) and push the local changes to that branch. git branch --set-upstream-to PostMethod origin/PostMethod Branch 'origin/PostMethod' set up...
Read more