Streamlined Uploads: XLS For Participants & Prizes In App-sorteo

by Admin 65 views
Streamlined Uploads: XLS for Participants & Prizes in app-sorteo

Introduction

Hey guys! We're super excited to announce a major upgrade to the way you manage participants and prizes in NovitSoftware's app-sorteo! Forget juggling multiple .txt files and dealing with repetitive uploads. We're switching to a much more efficient system using .xls files. This update is designed to save you time, reduce errors, and make your workflow smoother than ever. Get ready to say goodbye to the old way and hello to a streamlined, user-friendly experience.

The Problem with the Old System

Previously, uploading participants and prizes was a bit of a hassle. You had to upload separate .txt files for each company (like Consultatio and Nordelta), meaning you were essentially doing the same work twice. This was not only time-consuming but also increased the chances of errors creeping in. Plus, managing different file formats added unnecessary complexity to the entire process. We heard your feedback, and we knew there had to be a better way. This new system directly addresses those pain points, making the entire process much easier and more efficient.

The Solution: .XLS Files for Participants and Prizes

Our new system leverages the power and flexibility of .xls files to simplify the upload process. Instead of multiple .txt files, you'll now upload just two .xls files: one for participants and one for prizes. This change significantly reduces the number of files you need to manage and eliminates the need for duplicate uploads. Let's dive into the details of how this new system works.

Participants .XLS File

The participant .xls file will contain all the necessary information about each participant, including their name, surname, DNI (identification number), company affiliation, and participation status. The key innovation here is the inclusion of a "Company" column. This column will allow you to specify which company each participant belongs to (e.g., Consultatio, Nordelta). This single file will replace the need for separate files for each company.

Flexible Column Mapping

We understand that your data might not always be perfectly structured. That's why we've implemented a flexible column mapping system. The importer will intelligently identify the relevant columns (Name, Surname, DNI, Company, and "Participa en Sorteo?") regardless of their position in the file. This means you don't have to worry about rearranging columns to match a specific format. As long as the required information is present, the system will be able to extract it. The system is designed to be robust and adaptable to different data layouts.

Handling Participation Status

The "Participa en Sorteo?" column can contain various values indicating whether a participant is eligible for the draw. The system will recognize a wide range of affirmative values, including True, 1, si, SI, Si, Yes, yes, and YES. Any of these values will be interpreted as a confirmation that the participant should be included in the draw. This flexibility ensures that you can use your preferred terminology without causing any errors.

Attendance Tracking

We've also added support for an "Asistio" or "¿Asistió?" (Attended?) column. This column will contain boolean values indicating whether a participant attended the event. Only participants with an affirmative or true value in this column will be included in the draw. This feature allows you to restrict the draw to only those who were present at the event, adding an extra layer of eligibility.

Prizes .XLS File

The prize .xls file will contain a list of prizes and their corresponding quantities. This file will be used for both Consultatio and Nordelta, meaning that the same set of prizes will be available for both draws. For example, if you upload “Monopatin | 3,” there will be three Monopatin winners in Consultatio and three Monopatin winners in Nordelta. This simplifies prize management and ensures consistency across both companies. The file will have two columns, one for the name of the prize and the other for the quantity.

Updated User Interface

To reflect these changes, we've updated the graphical interface of the app. You'll notice that the separate buttons for each company have been replaced with a single button for uploading the participant .xls file. This simplifies the interface and makes it more intuitive to use. The winner's interface will remain the same, clearly differentiating winners from each company. This ensures that you can easily track which company each winner belongs to.

Acceptance Criteria

As part of the acceptance criteria for this update, we've included the example .xls files you provided. These files must be successfully uploaded, and the draw must function correctly using the data from these files. This ensures that the new system is compatible with your existing data and that the transition is seamless. We've thoroughly tested the system with these files to ensure that everything works as expected. The provided files are:

  • Participants example: evento_515 (1).xlsx
  • Prizes example: Excel Modelo.xlsx

Benefits of the New System

The new system offers several key benefits:

  • Reduced Upload Time: Uploading a single .xls file for participants is much faster than uploading multiple .txt files.
  • Simplified Workflow: The new system simplifies the entire process of managing participants and prizes.
  • Reduced Errors: By eliminating the need for duplicate uploads, the new system reduces the chances of errors.
  • Flexible Column Mapping: The flexible column mapping system ensures that you can use your preferred data format without causing any errors.
  • Attendance Tracking: The attendance tracking feature allows you to restrict the draw to only those who were present at the event.
  • Consistent Prize Management: The prize .xls file ensures that the same set of prizes is available for both companies.

How to Use the New System

  1. Prepare your Participant .xls file: Create an .xls file containing the participant data, including columns for Name, Surname, DNI, Company, "Participa en Sorteo?", and "Asistio" (optional). Ensure that the "Participa en Sorteo?" and "Asistio" columns contain valid affirmative or negative values.
  2. Prepare your Prize .xls file: Create an .xls file containing the list of prizes and their corresponding quantities.
  3. Upload the files: In the app, use the new upload button to upload the participant and prize .xls files.
  4. Run the draw: The draw will automatically use the data from the uploaded files.
  5. View the results: The winner's interface will display the winners from each company.

Conclusion

We're confident that this new system will significantly improve your experience with NovitSoftware's app-sorteo. By switching to .xls files and implementing flexible column mapping, we've created a more efficient, user-friendly, and error-resistant system. We encourage you to try it out and let us know what you think. Your feedback is always valuable as we continue to improve our products. Thanks for being a part of the NovitSoftware community!