Limit on number of rows on csv file

Salaam

I have just uploaded times for 2019 in CSV format without issue, but the file only contained data (for the whole of) 2019. I already had data for 2018 including the last days for December, uploaded from last year. (One thing I used to forget was to remove the line for Feb 29 for non-leap years as the plugin checks and complains if that is included).

In the first column in the CSV file is the date, what I have done is done a “Find and Replace” on the CSV file using Notepad to change 2018- to 2019- (the extra dash is just to ensure ONLY the year is changed just in case that “2018” occurred in the times). Saved the file ensuring the CSV extension remains and uploaded that.

You could upload a 2018 csv file then 2019 csv file rather than put more then a years data in one file. In theory I think you could upload several years worth of data as long as the correct year was included in the first column. I don’t think the the plugin would stop you doing that. Though of course you may want to adjust times for each year to cater for the different dates for clocks going forward/backward and any changed Jamaat times for Ramadan.

One feature that could be useful is a “Preview” feature in the Admin area, for future months that have been uploaded. Though the plugin indicates succesful upload there doesn’t seem to be an easy way to check the data after upload for mistakes in future months, apar from waiting until that date !

I use a plugin like https://www.ads-software.com/plugins/ari-adminer/ to allow me to review the uploaded timetable for the whole year and delete old old enteries.

Easy to use and the timetables are in a table is called “timetable”.

Salam brothers,

I am working on allowing future months to be viewed and edited from the admin screen. Make dua, I still don’t have internet in my new house.

You will have to successfully upload the year data first though.

That would be useful In Sha Allah. Thanks.

In theory you could allow a full years worth of data. Then perhaps allow a button in the Admin area that says “Copy from Jan 2019 to Jan 2020” to duplicate the data from the existing uploaded data. Then you could allow the current editing features in the Admin area to change individual days where needed. (I am thinking for most masjids the times will mostly be the same each year with maybe some changes for “Day Light Saving” (GMT/BST in UK) time and some Jamaat times with Ramadan moving forwards.)

This could potentially reduce the need to upload a new CSV file each year / month, as it is the upload process that seems to cause problems some times. Though I hope you would retain the option to upload a full year CSV file as thats easier !

Thanks attaqwa for your suggestion will have a look at that plugin.

Jazaakumullah khair.
I must admit I didn’t try uploading a full year 2019 because I thought that will remove my final 2018 days!