Python Windows Service Development

Title: Windows Service Development Description: We are seeking a skilled and experienced Developer to create a Windows Service solution for periodically updating data from MSSQL database to Quickzu website. Sample Data Structure: A- Products information: • Name – Category – Description – Image – Price - Selling Price • Unit - Unit Value - Available Stock - SKU (Stock Keeping Unit) • Availability (Yes-No) - Visibility (Visible-Invisible) - Exclude tax B- Orders Types: • Pending orders. • Paid Orders. • Accepted Orders. • Finished Orders. • Cancelled Orders. C- Order Data: • Client Name. • Client phone. • Address. • A list of selected products. • The ordered quantity for each product. • Client notes. • Order Total amount. • Payment Method. Solution Features: 1- Windows Service Implementation: • Create a Windows Service project using Python 3.12.1. • Implement a periodic scheduler to run the data synchronization at specified intervals or by triggered event. 2- Database Connectivity: • Establish a connection to the MSSQL database. • Perform CRUD operations (Create, Read, Update, Delete) on the MSSQL database to manage products. 3- Quickzu API Integration: • API Documentation: [login to view URL] • Implement API calls to Quickzu for CRUD operations on product information. • Handle authentication and authorization for Quickzu API calls. • Use cURL to implement API calls to Quickzu for CRUD operations on product information. 4- SharePoint Integration: • Implement connectivity to SharePoint to retrieve images associated with products. • Manage authentication to access SharePoint resources securely. 5- Image Handling: • Develop functions to download and upload images between SharePoint and the local system. • Consider caching images locally to optimize performance and minimize the number of requests to SharePoint. 6- Data Mapping: • Map the fields between MSSQL and Quickzu to ensure proper data synchronization. • Handle data transformation as needed (e.g., format conversion, data type adjustments). 7- Logging: • Implement logging to record the details of each synchronization process, including any errors or warnings. • Log information about CRUD operations performed on both MSSQL and Quickzu. • Extend logging to include details about image retrieval from SharePoint, such as success or failure, and any error messages. 8- Error Handling: • Implement robust error handling to manage exceptions during database operations, API calls, or any other potential issues. 9- Configuration Management: • Use configuration files or settings to manage parameters such as database connection details, Quickzu API credentials, and synchronization intervals. • Include configuration settings for SharePoint connection details, including the URL, authentication credentials, and any other necessary parameters. 10- Concurrency and Performance: • Consider implementing concurrency mechanisms to optimize data synchronization performance, especially if dealing with a large dataset. • Implement batch processing to minimize the number of API calls. 11- Security: • Ensure that sensitive information, such as database credentials and API keys, is securely stored and accessed. • Use HTTPS for communication with the Quickzu API. 12- Documentation: • Provide comprehensive documentation for setting up, configuring, and maintaining the Windows Service solution. • Include information about the data schema for MSSQL and Quickzu, as well as any dependencies. 13- Monitoring and Alerts: • Implement monitoring to track the performance of the Windows Service and receive alerts for any critical issues. Timeline: • Expected Start Date: [05-JAN-2024] • Project Duration: [One Month] Deadline for Applications: • Applications must be submitted by [05-Feb-2024].