Understanding CSV files

CSV stands for Comma Separated Values, and it's a file format (.csv) for spreadsheets. Ad-Din Web Portal accepts the import and export of C SV files for below modules.

Import

Export

Class

Class

Class Section

Class Section

Subjects

Subjects

Attendance

Attendance

Manage Marks

Manage Marks

Library

Library

Madrasah User Management

Class Routine

 

Exam

 

Holidays

 

Grade

 

Delegation

 

Migration

 

Assignments

 

Payment

 

Recognitions

 

Madrasah User Management

CSV files might seem intimidating at first, but when you understand what the text and characters represent in a spreadsheet, you might use it for some bigger tasks (such as bulk importing/editing above modules.
CSV files with UTF-8 encoding are the only file format that can be used to import to or export from AD-Din Web Portal.
In a CSV file, each entry represents a cell in a spreadsheet, each line represents a new row, and each comma indicates where one entry ends and another one begins.
For example, the entries in this Students CSV file:

look like this in a spreadsheet program:

When you export a CSV file from your Ad-Din Web Portal, it opens as a .csv file in your computer's native text editor such as Notepad. You can also use an alternative text editor, but it's recommended that you use a spreadsheet program to view and edit your CSV files instead.

Caution

If you are updating a CSV file export, then remember to confirm the UTF-8 encoding to avoid generating unwanted special characters in your file. If you save your file after forgetting to confirm its UTF-8 encoding, then your data will be corrupted when you upload it as a new spreadsheet. Ad-Din team can't recover corrupted files for you.
If you are using Microsoft Excel, you can export the file again which will take care of the UTF-8 issues for you.

Note

Ad-Din Team recommends that you use Microsoft Excel to work with your CSV files. First add some entries manually in the desired module than export to CSV > Unzip the file and place it on your C Drive in Folder Called "Ad-Din" > open your Microsoft Excel > click File > Open > Browse to folder location where the Exported CSV file is located > change the File types to All Files (.) > you will now see the CSV file, Select to open it. After you've made your changes, Click on File > Save. When prompted Say Yes.

Avoid Special characters as they don't work correctly in CSV files.
If you don't have a spreadsheet program, then you can edit CSV files using a text editor.

Caution

You should only use a text editor as a last resort. For example, use a text editor if there are formatting errors in your CSV file and you cannot open it in a spreadsheet program.
Most computers have text editors that can open CSV files

Note

A CSV file with UTF-8 encoding is the only file format that can be used to import to or export from Ad-Din Web Portal.