Daily Excel Reservation Import Module

Customer: AI | Published: 29.12.2025
Бюджет: 30 $

I’m running the Kivicare Laravel system ( https://laravel.kivicare.io/ ) and it already lets me export reservations, but I now need the reverse flow built in. Your job is to extend the existing reservation module so I can bring new bookings into the platform from an Excel and XML file every day without manual database work. The import must respect the same field structure and business rules used by the current export, writing to the correct tables and triggering any native events or notifications the system normally fires when a reservation is created through the UI. Because this data feeds a live calendar, I need solid safeguards in place. When the file is processed the code should automatically: • check for duplicate reservations against what’s already stored • verify every required column is filled in before saving • validate that date and time values are legitimate and fall within clinic hours If an error is found, show a concise report so I can fix the spreadsheet and re-upload. Successful imports should end with a confirmation message and the new reservations immediately visible in the existing schedule view. Please keep the solution native to Laravel—ideally a custom Artisan command or controller endpoint—and follow the project’s coding style so future updates stay straightforward.