<aside> 📢 There is a limit to bulk uploading students at SMS-Registration & SMS-Showcase. This is to prevent the server from being overloaded with a vast amount of students. Follow the steps below to split your CSV in the simplest way.

</aside>

Problem Statement

  1. When you upload more than 100 students at a time, this is the error that will pop up.

    Untitled

    Sometimes it may say “Network Error” too!

    Sometimes it may say “Network Error” too!

    <aside> 🗒️ Depending on the data in the CSV file, the file size may increase accordingly. Firebase may not be able to process the requested file uploaded via API due to file size, it therefore will throw out “network error”.

    Sometimes even 20 rows in a CSV file can cause problems, due to the many columns and long text in columns.

    </aside>

Solution

Step 1: Split CSV in multiple files

  1. To make sure your upload is smooth accordingly, download CSV Splitter to help you out. It can only be used on Windows computer.

  2. Once downloaded, unzip it.

  3. When you run the CSVSplitter.exe file, edit the following settings accordingly.

    Untitled

  4. “Number of rows per package = 100” is only a guideline. If you still see the error, please reduce it down to 50, 80, etc.

Step 2: Rename output files from CSV splitter

  1. Issue with the above CSV Splitter is all the output files are not renamed to the CSV format.

  2. At the location bar at the top of the window, right click and “Edit address”.

    Untitled

  3. Type “cmd” before the location and tap enter.

    Untitled

  4. In the Terminal,

Step 3: Upload the files one by one

  1. You may upload the files into the SMS system, one by one!