<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>
When you upload more than 100 students at a time, this is the error that will pop up.
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>
To make sure your upload is smooth accordingly, download CSV Splitter to help you out. It can only be used on Windows computer.
Once downloaded, unzip it.
When you run the CSVSplitter.exe
file, edit the following settings accordingly.
“Number of rows per package = 100” is only a guideline. If you still see the error, please reduce it down to 50, 80, etc.
Issue with the above CSV Splitter is all the output files are not renamed to the CSV format.
At the location bar at the top of the window, right click and “Edit address”.
Type “cmd” before the location and tap enter.
In the Terminal,
dir /b “FILENAME.*”
to retrieve the files you need
ren "FILENAME.*" "FILENAME.*.csv”
to rename the files into .csv file format