Expected duration: 1 day or less **Please remember, I would like you to bid for time spent on establishing a solution. I will provide FTP and backend access so we can discuss via PPH video call and then establish the best solution. Nothing in depth - just an overview. I will then create the job on PPH that asks for that solution to be developed**
SKILLS: Sub Category: Web Development, Programming/Coding, Database.
Specific skills required: PHP/MySQL and Joomla.
SITUATION: We have a bespoke Joomla component that is used to display training courses and take bookings. The website is https://www.wedotraining.com/
The component uses a template (Course Master) for each type of course so that only dates have to be added each time any new courses needs to be advertised.
The Course Masters already contain information such as: Course Title; Venue/Location; Start/Finish times; etc. See attachment 1 'CM.png' for an example.
Currently we receive a schedule from each Training Provider that contains lots of information (as a spreadsheet). To add courses quickly, in the Course Master view, we can simply add each instance of Start, Finish (and Intermediate where relevant) dates of upcoming courses, line-by-line. See attachment 2 'CM-manual-add.png' for an example.
For even quicker entries, a CSV upload can also be used to add the dates of upcoming courses. This is simply 'Start Date, End Date, Intermediate Dates'. See attachment 3 'CM-file-upload-method.png' for an example.
REQUIRED: We would like to speed up this process further by uploading courses in a more generic way. At the moment because the dates are added in the Course Master view, which contains predefined data, the schedules have to be filtered down to specific Category, Course and Location before we add the dates.
We would like to add the data from an entire schedule from a training provider if possible. See https://tinyurl.com/yg6eta3s for an example.
A POTENTIAL SOLUTION?: This was one of my thoughts on a solution. I do have some other ideas but I am no expert. I am after your suggestions on acheiving the end goal.
1) I wonder if we could upload a file of Course Master ID's with dates. Maybe using one column of data for a check (if the data in the checker-column does not correspond with the Course master then show an error). See https://tinyurl.com/yjzw355o for an example.
? How would we add the correct Course Master ID to the schedule? ~ We could collate an index of ID's and mannually add them before the upload. ~ We could have Excel/Gsheets run a simple code or script to add the relevant ID's
**Please remember, I would like you to bid for time spent on establishing a solution. I will provide FTP and backend access so we can discuss via PPH video call and then establish the best solution. Nothing in depth - just an overview. I will then create the job on PPH that asks for that solution to be developed**
I hope that all makes sense and look forward to receiving your bid.