Open source sql työt

I am looking for some help in sourcing qualified candidates in the healthcare industry. I have a TON of additional positions to fill so this can be a long term commitment! Scope of Assistance: Headhunting: Locating eligible candidates aligned with the job descrip...candidates for healthcare positions, i.e Registered Nurses, Nurse Practioners, Physicians, and Physical Therapists. - The virtual assistant should have a strong network and knowledge of the healthcare industry - The virtual assistant should be familiar with LinkedIn and Indeed Recruiting The ideal virtual assistant for this project would have: - Strong networking skills and connections - The ability to source and screen candidates based on specific qualifications and experience - Excellent communication and organizatio...

I'm looking for a proficient Codeigniter developer who can urgently dive into my project and rectify unspecified bugs/errors. The details of the issues...properly working The exact pages or functionalities affected are not clearly pinpointed yet. It's a task that requires you to have an in-depth understanding of Codeigniter, and the ability to quickly identify and resolve problems within the project. Key Skills and Experience: - Strong experience with PHP and Codeigniter framework - Advanced troubleshooting and debugging skills - Proficient in SQL and server/database connections - Ability to detect and fix broken code rapidly Kindly note, this work is time-sensitive and needs to be completed ASAP. Please bid if you are immediately available and can dedicate enough t...

I'm looking to update the source code of my existing app to accommodate several new features and enhancements to the existing feature about points rewarding such as the Cash King app adding features such as buying points cards and participating in contests or getting additional points as a reward, buying from the app, and getting rewards too, posting events and ads by payment, and uploading videos for ads. Key Features: - **Push Notifications:** Implement push notifications to keep users engaged and informed about app updates. - **Integration of Google Maps for Offers:** Utilize Google Maps API to display location-based offers, enhancing the user experience. - **Use of Phone Number as Primary Authentication Method:** I'd like to shift from an email-based authentication s...

I am looking for a freelancer to help me setup a working Lab Streaming Layer project in Android Studio. I need the Android Studio project for Android LSL which requires the Android Studio project for the Java LSL to be built first. Requirements: - Build the Java project. - Use its outputs to build the Android project. - The Android project must build the simplest APK. Blank UI. Just to be used as proof the project builds and the native libraries all build. Deliverables: - output from java project - exported zipped android studio Java LSL project so I can import it into my android studio - exported zipped android studio Android LSL project so I can import it into my android studio - any additional libraries you had to download for it to work (or just links to the files). - notes on ...

please dont bid if you dont already have a retail pos project using (WPF, C#)using .Net Core utilizing codefirst approach. I'm urgently searching for a pre-developed, .Net Core Retail POS project source code that's built using C#, WPF and the code first approach. A crucial requirement is that it does not depend on third-party tools and supports RTL languages. Please, only place your bid if you have a ready-to-deliver solution.

Dear developers, I am looking for a skilled python engineer that is able to create a ML engine which is capable to extract specific datapoints from the pdf files and save them as per set of rules to sql table. system has to run offline, so no online solutions will be accepted as they cannot be used for this project. current problems: 1. large part of documents are scanned, but data is digital. essentially form was printed and scanned upon completion. 2. scanned files are tilted. 3. scanned files have noise which require removal of it. 4. few scanned documents require quality enhancement. 5. some scanned documents have different zoom. 6. all files have checkboxes. 7. specific datapoints can change location within the file, so engine must search for it and find it. there is maste...

As a thriving business, we're seeking an experienced Laravel and SQL developer for our upcoming web development project. The developer's main task will be to bring to life our concept of designing and implementing a responsive, user-friendly web application. We're in need of: - Laravel Web Development: Building a robust, intuitive web application using Laravel PHP framework. Utilising Laravel's features to their maximum potential. - SQL Database Management: This includes maintaining and optimizing our SQL database for this upcoming project, ensuring the data structures are well-designed and functional. - Backend API Development: We have several third-party services which need to be integrated into our application through backend API Developmen...

This project’s purpose is to entirely reskin a gaming android app. This involves the interface layout, icons, and package name. In addition: - Adopt a refreshing and appealing light theme across the app, ensuring the gaming experience remains exciting for players. - Fine-tune the Admin Panel for streamlined management. Ideal candidates will have previous experience in Android gaming apps and a keen eye for meticulous graphic detail. Essential skills include Android app development, an understanding of gaming aesthetics, and familiarity with Admin Panel setup and management. Implementing changes without compromising the gaming experience is a core requirement. Therefore, successful bidders must demonstrate a balance of technical know-how and creative design skills.

More details: What specific website(s) do you want to scrape data from? Website 1, Website 2 What specific data do you want to scrape from the selected websites? Text content, Tables What information would you like to extract from the text content and tables? Product names, Prices, Descriptions, reviews, size and color, occasion, return and country of origin, category, fabric, weartype

Skills Required Python Aws services-S3, glue, athena, sagemaker, feature store Sql UI/ API/SWAGGER PAGE Good in ML 5 days in a week Remote support role You will have to help developer for completing the task Timings - 9 to 11 am IST (or evening IST) Payment - You will be paid for those hours while you will be working, You will be informed in advance if there is no work and for those hours you will not be paid. Budget = 400 INR /h

I am in urgent need of a developer to help me delete some crucial files from my server's database. The files in question are related to both orders and affiliate data. Key details: - Urgency: This task needs to be completed within 24 hours. The files d...some crucial files from my server's database. The files in question are related to both orders and affiliate data. Key details: - Urgency: This task needs to be completed within 24 hours. The files do not involve any specific criteria for selection. The process is straightforward, and all relevant files need to be removed. Ideal skills and experience: - Proficiency in database management and SQL - Experience in managing ecommerce and affiliate systems - Ability to work under tight deadlines - Good communication and ...

I'm seeking an expert to build a PowerBI solution, primarily for financial planning and analysis (FP&A). Key project requirements: - Robust Integration with our SQL database to pull the necessary data. - Proficiency in creating illustrative Charts and Tables in PowerBI, enhancing data interpretation. - The dashboard should effectively track and analyze the key metrics such as Revenue, Profit Margin, and Sales growth. Ideal freelancers applying for this project should have: - Demonstrable experience in PowerBI and SQL database integration. - Solid background in creating visually engaging dashboards, specifically using Charts and Tables. - A solid understanding of FP&A metrics. - Proven track record in delivering similar projects. Please submit your bid with...

Firma szuka wsparcia zespołu zajmującego się rozbudową i utrzymaniem własnego serwisu web na DNN. Doświadczenie w C#, ASP.NET, T-SQL. Zapraszam do współpracy.

I'm looking for a Full-Stack Python programmer with solid SQL and .NET experience. The primary focus of the project is web development. Key Requirements: - Proficiency in Python is a must. You will be working on both the front-end and back-end of a web application. - Strong understanding of SQL and .NET. You'll be handling databases and working on the server-side functions. - A solid background in full-stack development. The project will require a comprehensive approach to both front-end (user interface design) and back-end (server-side functions) development. Your responsibilities will include, but not limited to: - Developing user interactions on web pages, implementing server-side logic, and maintaining the system. - Building the overall structure of the web a...

I'm seeking a proficient C++ developer with ample experience to handle an update to our existing source code. You will be tasked with: Upgrading the source code to make use of the RandomX algorithm (no need to implement the algorithm, as we already have it ready and we will provide the source code), currently the source code is fully working with CryptoNight. Knowledge and experience with the CryptoNight or crypto coins are incredibly beneficial. You should be well-versed in updating and refining source codes.

Hi, I have a list of providers that I...limitations. I need a script that run and does it so I can implement that on AWS Lambda or similar Serverless implementation. I think Python would be good but also open to Java. I am not sure if you can or suggest to have multiple script that runs as a different process or you can build a Mono-Repo that can handle all of those providers under one process and can be easily scale to add more applications. Below is the list of Providers: Airflow AWS On-Prem AD Azure AD Control Money Data Lake Data Warehouse GitHub Jenkins Kyriba Loyalty Admin Loyalty API Mode MongoDB NetSuite Octopus Deploy OKTA Pricing Engine Reconart SQL Server SSRS Tableau TeamCity Workday Best of luck, I think it's better to have a Milestone for each ...

...innovación y mejora continua en los procesos y productos de la Start-Up. Requisitos: - Fuerte experiencia en programación con Python, demostrable a través de un portafolio de proyectos sólidos y eficaces. - Conocimientos avanzados en frameworks de Python como Django o Flask, especialmente en desarrollos de aplicaciones web. - Habilidad para trabajar con distintos tipos de bases de datos, tanto SQL como NoSQL. - Experiencia en la integración de APIs y en el desarrollo de servicios web. - Capacidad de análisis y solución de problemas, orientado a resultados concretos. - Fluidez en español, con habilidades de comunicación efectivas para trabajar en equipo. - Preferencia, aunque no exclusiva, por candidatos ubicados en A...

I'm experiencing performance issues with 5 stored procedures in my SQL Server. These procedures are significantly slower than expected due to complex JOIN queries involving multiple tables. The project entails: - Diagnosing the cause of the slow performance. - Improving the efficiency and speed of these 5 stored procedures, aiming to achieve at least a 50% increase in speed. - Decreasing high memory usage of a sql server instance Ideal skills and qualifications: - Proficiency in SQL Server and complex JOIN operations. - Proven experience in SQL query optimization and performance improvement. - Understanding of advanced aspects of SQL Server performance tuning. - Excellent debugging and diagnostic skills. - Familiarity with procedures handling mu...

I am seeking an ASP .NET and Angular developer to create a comprehensive web application for an electricity billing system that will enable seamless customer and administrative experiences. Key Features: - Enable customers to create accounts, sign in and out of their account and recover forgotten passwords. - Create the ability for customers to check their billing...password system. Reports can be filtered and sorted by date range, customer profile, or invoice status. Ideal skills: - Proficiency in ASP .NET - Proficiency in Angular - Experience in backend user authentication procedures - Excellent UI / UX design - Prior experience in creating functional dashboard systems - Experience in handling databases and data filtering. for database connectivity use ssms(sql server manageme...

Looking for a skilled web developer to create a sleek and responsive standalone web app that helps manage equi...equipment tracking, calibration scheduling, and reporting Ideal candidate should possess strong experience in web-based app development, UX design, and database management. Capability to create an intuitive user interface is critical, and understanding of equipment calibration fields is a huge plus. Preferred technologies include but not limited to JavaScript, HTML/CSS, Python, SQL, or Ruby/Rails. However, I am open to your expertise on the tech stack that will best serve this project's requirements. Please include in your proposal an estimate of timelines and previous examples of similar work. Let's work together to create a tool to simplify e...

I'm looking for an experienced web developer to build a functional social networking website. Key Functionalities: - User Profile Creation: Users should be able to create a profile solely...web developer to build a functional social networking website. Key Functionalities: - User Profile Creation: Users should be able to create a profile solely with their email and appropriate user input parameters. - Blog Postings: Users should be able to post blogs and comments on these blogs. Ideal Skills: The ideal freelancer for this project should be proficient in HTML, CSS, JavaScript, and SQL. Experience with creating social networking sites or similar projects would be a plus. They should be able to cleanly write code, create an intuitive user interface, and ensure a secure regist...

...system security and integrity through best practices * Providing information support for the administration team as needed * Participating in team efforts toward efficient and successful project planning including weekly virtual team meetings Job Requirements * 5+ Years Experience in backend or full stack development * Knowledge in ColdFusion (2018 or newer), Python, PHP, CFC, Javascript, SQL, MySSQL, Database Design, Server Management * Experience in front end user interface development,
HTML, and CSS * Knowledgeable in APls, both SOAP and REST * Knowledgeable in Windows server management * Strong problem solving skills * Forward thinking in all development * Strong time management skills * Self-starter * Detail oriented Projects You will Own or Assist in...

...visualizations should be incorporated for users' easy and comfortable navigation The ideal candidate for this project should have strong experience and skills in developing with Wix and Wix Apps, SQL and integrating them cohesively. Understanding the importance of data management and the ability to integrate real-time updates into a simple yet functional interface will be critical for this role. Here's the full Scope of Work for integrating your system with Azure SQL and developing the necessary functionalities on your Wix Application: **Azure SQL Integration and Database Setup:** - Integrate the system with Azure SQL. - Create databases for **Customer Information**, **Customer Sizing**, **Certification Information**, **Purchase Information**, *...

I'm looking for a skilled full-stack developer to build the backend for my web application. The application should have: - User authentication: The ability for users...various types of data within the application. - API integration: The backend should be able to communicate with external APIs, enhancing the functionality and enriching the user experience. Ideal skills and experiences for this project include: - Proficiency in back-end programming languages such as Node.js, Python, or Ruby on Rails. - Strong understanding of database management and experience with SQL or NoSQL databases. - Previous experience with building secure user authentication systems. - Familiarity with integrating various APIs. - Good communication skills and ability to work collaboratively with a front...

I need a competent professional to smoothly facilitate the migration of my MSSQL 2019 database to a new server. Additionally, the ownership of SQL Management Studio must be changed effectively. Key job responsibilities: - Safe and efficient migration of the MSSQL 2019 database to a new server - Successfully transfer ownership of SQL Management Studio Ideal Skills and Experience: - Proven expertise in MSSQL 2019 and prior versions - Proficient in handling SQL Management Studio - Experience in successful database migration projects - Detail-oriented in project proposals Please note that only freelancers providing detailed project proposals will be considered. Your proposal should demonstrate your understanding of the project requirements as well as how you intend to ...

I require an expert in SAP Integration Suite for a project focused on integrating Salesforce, Slack, and SQL. With proficient experience in Cloud Integration, Open Connectors, and API, you'll be able to skillfully execute my requirements. Your main tasks will be: - Implementing SAP Integration Suite with Salesforce, Slack and SQL. - Ensuring real-time data synchronization between the systems. - Establishing automated data transfer protocols. - Enhancing the overall efficiency of business processes through these integrations. Your expertise in SAP Integration Suite, Cloud Integration, Open Connectors, and API, along with the ability to ensure real-time data sync, automate data transfers, and streamline business processes, will be crucial for this project...

I am in need of a freelancer who can create paginated Access reports. The job involves: - Using data from MS-Access to use in the report. - Converting the extracted data into paginated reports. - Very good knowledge of SQL. The perfect candidate will be proficient in manipulating SQL language and creating Access reports, with a keen eye for detail and a some understanding of sales data. Background in SQL language and Microsoft Access report is advantageous. Attached is a sample of the report I need the candidate to perform, but in much better format and with the correct information extracted for each column.

I need to convert a small 25mb .bak file to csv/xml. This is a backup of MSSQLSERVER2016 (MS SQL Server)

...should include essential features such as online appointment scheduling, patient registration, and detailed information on the hospital and doctors available. The primary users will be patients and hospital staff, so the user interface must be intuitive and user-friendly. Ideal skills: * Proficient in WordPress development * Experience in healthcare sector websites beneficial * Knowledgeable in SQL or other database management systems * Familiarity with responsive and mobile-friendly designs Key Customization Features: * Patient profile creation: Users should be able to create and manage their profiles effortlessly. * Personalized appointment reminders: The platform should send customized reminders to patients about their upcoming appointments to reduce no-shows. Your port...

I'm looking for a skilled freelancer who can help in entering text data from PDF files and images. There are 60 rows of text, I need to add columns that contain the details from PDF files. This needs to be done now immediately. I will provide an example.

I'm in need of a highly skilled .NET developer for my project. It involves .NET framework (specifically web forms) and a complex SQL database. Ideal Skills and Experience: - Strong expertise in .NET framework, particularly with web forms. - Comprehensive knowledge of SQL, able to navigate and manipulate complex databases. - Previous experience with large-scale projects requiring intricate database structures. Your application should focus on your experience in these areas and similar projects you've completed. Please, make sure to emphasize your accomplishments and results in your past work.

Hi, Please apply only individual. Agency can apply but budget should not be more than mentioned. Role : GCP Engineer (OTP) Exp : 7 + yrs SHIFT: IST Cloud Storage Buckets, BigQuery (SQL, Data Transformations and movement) Airflow (python, DAGs), DBT IAM Policies PyCharm Databricks (pySpark), Azure DevOps Clear and confident communication

In this project, I'm seeking a Power BI expert's assistance to accomplish the following: - Development of data visualization using Power BI - Creation of intuitive dashboards and comprehensive reports I will provide data from classified sources, particularly Excel spreadsheets and SQL databases. Your task will be to integrate these platforms and generate compelling, easy to understand visualizations. The primary KPIs needed in the dashboard and reports will focus on: - Sales revenue: I'm interested in monthly, quarterly, and annual trends - Customer satisfaction: We'll track this through a set of predefined parameters. Your ability to illustrate complex data in a user-friendly manner will be paramount. Prior experience with interpreting sales data and custo...

I'm keen to find a well-versed ASP.NET MVC core developer to work on building a project from scratch. This task includes: - 4 Web Forms using Razor View and 4 Listing page with Filtering and Search feature. - Code first approach - Wire frames will be shared with shortlisted developer. - Entire code project need to share. - SQL Server DB. Key skills required: - Mastery in ASP.NET MVC core - Proficiency in Entity Framework and Identity Framework - Profound understanding of user authentication protocols - Demonstrable experience with responsive design - Ability in creating professional, corporate designs.

As a beginner in Power BI, I need a proficient tutor to help me master all aspects of the tool including Data modeling, Creating visualizations and DAX formulas. I have various data sources such as Excel files, SQL databases and Web APIs which I'd like to connect with Power BI seamlessly. For this job, a deep understanding of Power BI and experience in teaching or tutoring are desired. Patience and ability to explain technical concepts to a newbie could be a good fit for the role. - Power BI mastery - Tutoring experience - Familiarity with Excel files, SQL databases and Web APIs - Patient and clear communication skills

I'm in need of an MS SQL expert who can write complex stored procedures for my project. Key Responsibilities: - Develop and write complex stored procedures tailored to my specific needs Ideal Skills and Experience: - Proficient in MS SQL - Experience in writing complex stored procedures - Strong understanding of database design - Ability to understand and adapt to project requirements This project is vital to my current development, and I'm looking for someone who can deliver quality results. Please share your experience and approach to this task in your bid.

We have around 705 source keys in two projects containing stings in English for an Android Music app and Video app. We use a platform called Localazy for translation, so the strings cannot be sent in an offline format (.docx or .exel), all translations have to be made on that platform itself. The strings need to be translated into Russian. Please note that the translated content will be proof-read and JUST copy-pasting from Google Translate will not be appreciated and the payment can be withheld.

I am seeking a freelancer with deep experience in .NET MVC project code and Azure databases who can assist me in deploying my project on Azure. The task specifically involves: • Investigating issues with my database connectivity on Azure. • I...MVC project code and Azure databases who can assist me in deploying my project on Azure. The task specifically involves: • Investigating issues with my database connectivity on Azure. • Identifying and resolving authentication-related errors I am currently encountering while using SQL Server authentication. The freelancer ideally could view these issues on my laptop setup and advise solutions accordingly. Knowledge of error diagnosis is critical. Understanding of Azure databases, .NET MVC projects and SQL...

...days a week, with the following requirements. Role- Low code Developer Exp Required - 5+ Yrs Timings : 10:00 am to 07:00 PM IST Location : Remote (India) 3+ years of .NET or JAVA development experience  Exposure to Outsystems and/or Appian for Low-Code preferable  3+ years with relational databases  3+ years of MS SQL or MYSQL  1+ years designing and developing REST APIs  Proficiency in C#, .NET, HTML, and/or Javascript  Exposure to JIRA and BitBucket/Git for source control a plus  Practical understanding of data structures, algorithms, and design patterns in a web environment  Cloud first architectures (AWS, Azure, Cloudera, etc.) a plus  Log aggregators (SumoLogic, Splunk) a plus  Experience with SAP, HANA, and/or Vistex a plus  Bachelor's degr...

I own tons of digital documents composed of text data that need to be carefully and accurately entered into a SQL database. Seeking an experienced Data Entry Specialist who: - Has proficient knowledge in working with digital documents for data entry. - Demonstrates excellent typing skills for handling text data. - Has a strong understanding of SQL databases and is comfortable entering data into this platform. - Has meticulous attention to detail to ensure the integrity and accuracy of my data. - Possesses a track record of data entry efficiency and speed, without compromising quality.

...indicator .so its long terms opportunetly. I am urgently looking for a professional who is capable of extracting the source code from TradingView and customize my trading algorithm. The primary purpose of this exercise is as follows: * Customization of Trading Algorithms Unfortunately, the specific capabilities of the customized algorithm weren't outlined, therefore, I'd appreciate offers addressing various functionalities that the algorithm could possess for further selection. The competencies that might be essential include, but not limited to: * Buy/sell trigger alerts * Advanced data analysis * Real-time market trend predictions Expertise in extracting and interpreting source code is paramount, and an added advantage would be an experience within the algo...

I have a VBScript page that uses Classic ASP to query an SQL database with over 4000 entries. This is now causing loading issue due to the number of entries loaded into the web page. I require this page to be converted to JSON and save as a text file. The saved text file should then be loaded using AJAX and using JavaScript formatted for using Data Tables. I am also open to other ways that this can be achieved BUT DataTables is a MUST as all entries need to be loaded on the page and it MUST be written in VBScript. The current web page formatting and design details MUST remain the same. A copy of the page will be sent to the ideal candidate. No other data will be supplied. I'm looking for someone that has very good understanding of VBScript, Classic ASP, JSON and JavaS...

As a rapidly growing business, we are now experiencing some difficulties with our large MS SQL database system. The system comprises of multiple databases, which includes complex relationships and transactions. The primary task we need to carry out is Query Optimization and Performance Tuning. Our large infrastructure could use the expertise of a professional who can recognize inefficiencies and have them fixed. The ideal candidate will have: - Extensive experience with MS SQL , especially Stored Procedure - Proven expertise in query optimization and performance tuning - Experience with large databases, managing complex relationships and transactions. Your aim will be to help us optimize our system and ensure smoother operation of our database infrastructure. Looking...

As the primary user of a Windows 11 Pro PC acting as a server for a SQL based car dealership software, EasyDeal, I require technical support to resolve my ongoing issue. The main problem I encounter is that various devices are struggling to maintain a connection to the software, indicating a "Connection Timeout" TCP errors, "could not locate server" error message. Key Tasks: * Troubleshoot and repair the connection issues on the server and other devices * Ensure stable, reliable connection between the devices and server Ideal Skills & Experience: * Proven experience with EasyDeal software * Excellent knowledge and skills in SQL and network troubleshooting * Familiarity with Windows 11 Pro and server management.

We would like to automate the extraction, transformation and loading of health standard language 7 (HL7) files into a MySQL database hosted on a Microsoft Windows server. The files are sent to the Microsoft Windows server every 5 minutes and we have to load them and once processed move them to a different folder. I have attached our database structure and an example of the HL7 file (dummy) and MySQL database structure. Our HL7 file is for one patient and have one or more OBR per patient. You will have to install Mirth on our server and configure it to automatically process an HL7 file every 3rd minutes. Thank you!

I'm looking for someone proficient in SQL Server to help with my complex stored procedure. This task incorporates both performance optimization throughout and enhancements in specific areas. Required Skills and Experience: • Expertise in SQL Server. • Experience in performance optimization of stored procedures. • Tackling both overall and specific improvements. I have complete documentation of the current structure and logic of the procedure. This will aid in understanding what needs to be fixed and consequently expedite the completion of the project. Your role will include finalizing it and working according to the requirements. Do not bid for this unless you are free to work on this for the next 5 days, as this is urgent work!

I'm seeking an experienced developer to create an add-on for NinjaTrader 8 without specific feature requirements. Given the open-ended nature of this project: - You should be adept in leveraging the add-on for different functions such as building custom chart indicators, automated trading strategies or market data analysis tools and should be able to propose and execute functionality based on your expertise - The choice of programming language is open, whether it's C#, Java, or Python, but it should fit the task at your discretion - There's potential for third-party integrations or APIs, including but not limited to Interactive Brokers API, IQFeed API, Coinbase API Ideal skills: - Previous experience developing NinjaTrader 8 add-ons - Proficient in at least ...

I'm in need of support with a scientific research proje...range of possibilities. - Uncertain Focus: The specific scope of the research isn't yet decided. Whether it's Biology, Physics or Chemistry, I value flexibility and adaptability. - Exceptional Applications: I encourage applicants to present their past work, experience and detailed project proposals. Showcase the breadth and depth of your knowledge, and demonstrate how you can bring value to an open-ended scientific study. Ideal freelancers will possess broad knowledge across multiple scientific fields, with demonstrated problem-solving skills. Relevant research experience is also necessary for undertaking this project successfully. Due to the nature of the project, excellent communication and flexibility ar...

I am in need of a proficient PHP developer who is experienced in Core PHP. Project Complexity - Easy INDIAN INDIVIDUAL developers will be preferred. Long Term Project

Looking for a SQL Expert who is good with Transact SQL, stored procedure and expert with MS SQL server. Task is related to trigger and XML and should hardly take one day to complete