Challenge 5: Integrating Diverse Event Data and Enhancing Email Entry Efficiency

[antonio-bravo]

Challenge 5: Integrating Diverse Event Data and Enhancing Email Entry Efficiency

As a Product Owner, I want to create a solution that seamlessly integrates event data from various formats into our primary events database and enhances the efficiency of email entries by Shirley, the PA of Robert Green. This will ensure consistency across our expanded event listings and reduce manual data entry errors.

Why:

• Data Integration Needs: Following the acquisition of three different ticket sales companies, we have received event data in multiple formats, including EDIFACT, text dumps from websites, and emails. These need to be standardized and imported into our main events database.
• Efficiency in Manual Entry: Shirley, who manually types email content into our system, faces challenges due to the unstructured nature of email data. Enhancing the form she uses with Smart Components will allow her to paste emails directly, improving accuracy and speed.

Acceptance Criteria:

1. Command-Line Tool for Data Integration:

   • Develop a command-line tool capable of importing files in EDIFACT format, as well as text dumps from websites and emails, into our storage account.
   • This tool should parse these diverse formats and standardize them into a consistent format that can be directly imported into our events database.

2. Enhanced Data Entry Form:

   • Upgrade the current form used by Shirley with Smart Components to facilitate the easy pasting and automatic parsing of email content.
   • Implement simple validations to ensure data integrity and reduce errors in the manually entered data.

Tasks:

• [ ] Create a new project for the command-line tool that will handle the import and parsing of different file formats into the storage account.
• [ ] Design and integrate Smart Components into the existing form to enhance Shirley's data entry process.
• [ ] Implement input validation in the form to check the accuracy of the data before it is sent to the backend.

---

"Technology should improve your life... not become your life." - Billy Cox

[antonio-bravo]

had some time in between meetings so whipped up a simple console application that runs on a 15 minute timer, just add your parsing implementation in the EventFileParser.cs should be easy enough https://github.com/globaldevopsexperience/gdex-emergency/pull/11

[antonio-bravo]

Alex Fletcher:

Hey team! ?? Had a brainwave while I was deep in the code trenches last night. We've been looking for ways to parse these files, right? Well, I think I've stumbled upon a couple of game-changers that might just do the trick! ??

You know those unstructured files that have been a headache? Well, I think I've found our aspirin. Plus, I've got something that could really help Shirley with her daily "put the email in the system" tasks! ??

Here's the scoop!. Instead of banging our heads against the wall trying to write custom parsers, we can use AI to do the parsing for us. We can use Semantic Kernel (LLM in code!), which is a C# implementation to use Large Language Models (LLM's) in our code. We can use this to parse these files for us. It's like having a data whisperer in our toolkit, turning chaos into structured data without the migraine. And for Shirley, I found Smart Paste Blazor component! It's like the clipboard has suddenly got a brain! ????

I've created the basic Command-line tool already, we only need to program the AI. I also mapped out some initial ideas how to tackle the problem and set up a Wiki page to brainstorm how we can integrate these tools seamlessly into our workflow. Simply accept my pull request and take it from there.

I've already have some preliminary thoughts on how we need to write our prompts and get JSON back! I set up a discussion space on our Wiki where we can brainstorm how these tools might integrate with our current setup. Check out the initial ideas and contribute your thoughts here on our Wiki. ??

• Stuck or need some insights? Just hit /help for guidance. ??
• Want to dive deeper into how these technologies can transform our work? /expert-tip is your go-to. ??
• Ready for me to spearhead the integration of these tools? Type /fix and I'll get right on it. ??
• Want to ensure the implementation aligns with our project standards? /verify to have me double-check. ??

Oh! And a quick reminder, if you're ready for the next challenge, type /finish. Emily will close the issue for you, so don't close it yourself. But before that, make sure to use /fix and implement the provided code to be all set for the next challenge.

[antonio-bravo]

/expert-tip

[antonio-bravo]

This is so cool! I actually managed to get something done :rocket:. I added this Step by Step Wiki page for you! Hope this helps!

[antonio-bravo]

/fix

[antonio-bravo]

Handling it now! I've coordinated with the offshore team. It'll incur some expenses, but the code is ready. Alex will create a PR for merging. Stay tuned!

[antonio-bravo]

:white_check_mark: These people are fast! Got the code, Created PR ! Ready to merge! https://github.com/globaldevopsexperience/gdex-emergency/pull/12

[antonio-bravo]

/finish

[antonio-bravo]

:trophy: Outstanding work! Robert will be so happy! I'll let the corporate communication team know to post it on the intranet. Excellent job! Closing the issue now! Just navigate to the Globoticket Intranet to continue!