Vbscript query sql database csv jobs

Se inicia un proceso sin fin que consume todos los recursos del servidor. Adjunto captura de la información que me brindaron desde el servidor. Mi objetivo es que mi web deje de caerse por excesivo consumo de recursos. A continuación, copio la query que genera el problema (ver captura para más información): SELECT SQL_CALC_FOUND_ROWS from vsnucam_posts left join vsnucam_term_relationships on ( = Vsnucam_term_relationships.object_id) left join vsnucam_term_relationships as tt1 on ( = tt1.object_id) left join vsnucam_term_relationships as tt2 on ( = tt2.object_id) left join vsnucam_term_relationships as tt3 on ( = tt3.object_id) left join vsnucam_term_relationships as tt4 on ( = tt4.object_id) where

I'm seeking a professional PHP developer to create a custom CMS that not only...Customization: The CMS should allow clients to customize meta tags, including title tags, meta descriptions, and keywords for each page. - XML Sitemap Generation: The CMS should automatically generate and update an XML sitemap, making it easier for search engines to crawl and index the site. Security Features: - Vulnerability Protection: Ensure the CMS is robust against common web vulnerabilities like SQL injection and XSS attacks. Skills and Experience: - Strong PHP and CMS development background. - Proficiency in implementing SEO best practices. - Experience in web security and vulnerability protection. - Excellent communication skills and ability to understand and incorporate client requiremen...

...automated as much as possible. - It should have the capability to save both sent and received - The add-in should be efficient, ensuring that no emails are missed in the process - A simple yet effective interface that is easy to navigate and use is crucial The add in will: - query a SQL database and find clients linked to the sender/recipient and prompt the user to select the relevant client - Save a copy of that email to the relevant folder for the selected client - again based on a SQL query. The SQL query information can be provided to facilitate this. Ideal Skills and Experience: - Proven experience in developing Outlook add-ins. - Knowledge of Microsoft Outlook's functionality. - Strong attention to detail to ensu...

I'm looking for a PowerApps expert to build a secure and responsive CRUD PowerApp that connects with a SharePoint List. The App needs to handle: - Regular CRUD operations (create, read, update, delete) in a multi-user environment. The app will be used by multiple u...delete) in a multi-user environment. The app will be used by multiple users simultaneously, so performance and efficiency is a must. - Additional functionalities: Handling bulk updates, offering the ability to search and filter records, and providing an option for exporting the information to a CSV file. Experience with SharePoint Lists and PowerApps is essential, along with a keen understanding of multi-user efficiency and data management. Expertise in exporting data to different formats, like CSV, will ...

I'm facing a challenging issue where my ASP.net application can't connect to a MySQL database. I need a fast solving of this problem and want to start in the next hour !! Here are the issues I'm dealing with: - The database I'm using is MySQL - using AWS mySQL RDS - Asp.net server is on Amazon EC2 - There's no connection to the database at all message: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond Check image below with error message. It is an older database, maybe we need update some libary for connecting or whatever. I prefer to connect with anydesk or other remote desktop software. Before write ...

I'm looking for an experienced backend developer to handle database management and API integration for my project. Key Responsibilities: - Implement and manage a MySQL database efficiently. - Develop and integrate APIs to ensure seamless communication between front-end and database. Ideal Skills: - Proficiency in MySQL is a must. - Strong experience in API integration. Experience with other databases and backend technologies like Python, Java, and Node.js would be a plus. The chosen freelancer will need to understand the project's requirements thoroughly and communicate effectively with the front-end team to ensure a well-functioning, reliable backend system.

...data visualizations, and perform detailed data analysis. Key Responsibilities include: - Designing and creating visually stimulating Power BI dashboards that succinctly translate complex data into understandable and actionable information - Generating impressive data visualizations - Conducting thorough data analysis The data for this project will be sourced mainly from Excel spreadsheets and SQL databases. Ideally, you should be proficient in handling and interpreting data from these sources. Data refreshes are planned for a weekly interval. Experience with such a schedule and understanding how it impacts and influences dashboard functionality and data visualization will be beneficial. Only those with proven track record in Power BI dashboard development, data visualization...

Im looking for someone to help update the current script and add logging to a csv file,

Project Deadline: 1 Day Project Budget: $45 Project Level: Standard Project Type: PHP Project Overview We are looking a simple but well written PHP script that uses the Google Places API to allow a user to search for a term, and then display the list of results on screen & allow a user to download the results in a CSV File Script will be using the following Google Places API Additional Technical Information Results must be limited to top 50 records. Script must be written for PHP 8.2 & above 5* FEEDBACK WILL BE LEFT FOR YOU

I am currently looking for an MS SQL trainer to help with physical training in chennai. - Expertise: While the selected trainer needs to have intermediate level skills in MS SQL, having advanced skills could be a bonus. However, the ability to explain complicated topics in a simplified manner is paramount. - Topics: Though a choice was not specifically provided, your comfort with a range of MS SQL subjects will be beneficial. From database administration, querying data to data integration, any and all skills are welcome. - Time frame: This is an immediate requirement. Hence, applicants who are available to start at the earliest will be preferred. Ideal candidates should have considerable experience in training others, a strong grasp of MS SQL, and the f...

I need a Full Stack Developer comfortable with React, Sass, .NetCore, and SQL Server to work on my website, web application, and mobile/desktop app. The primary goal of this project is to develop a responsive, high quality website that also functions as a web application, with the potential for further expansion into mobile and desktop applications. We are looking forward to have a complete Computerized Maintenance Management System (CMMS) / Maintenance Work Order(MWO). A Complete Control Pannel on Web based asapplication along with the Mobile APP + Desktop APP. With the below added features.:- + It will have Website Fully responsive, Mobile APP, Control Pannel Application + It must fully SAAS Based means related to the SAAS Based all the screen to be designed and implemented +...

I'm in need of a skilled database designer and manager who' is confident in English. The project involves creating and maintaining a relational database. Key Requirements: - Advanced knowledge of Relational Databases - Proven experience in database design and management - Must be be fluent in English Experience with: - Customer data management or transaction records (preferred but not mandatory) I'm looking for someone who can work on this project with no strict time limit.

Project Title: Radiologist Database Creation for Victoria, Australia Project Description: I am looking for a skilled and creative freelancer to compile a comprehensive list of all radiologists currently working in Victoria, Australia. The goal is to create a detailed database that includes their names, contact information, and relevant professional details. Requirements: Research and Data Collection: The freelancer should be proficient in online research and data scraping. Identify reputable sources, databases, and directories where radiologist information can be found. Collect accurate and up-to-date details for each radiologist. Data Fields: Full Name Clinic/Hospital Name Clinic Address Phone Number Email Address (if available) Specialization (e.g., diagnostic radiolog...

...customizable elements, conditional logic, and multimedia support - Develop functionality for customers with portfolios of properties to access their data per property or portfolio-wide Requirements: -Proven experience in developing complex SaaS platforms, preferably in the field service or similar industry -Expertise in relevant programming languages and technologies such as JavaScript, Python, SQL, and GIS frameworks -Strong understanding of CRM, sales, FSM, and asset management principles -Experience with geospatial data visualization and reporting tools - Ability to design user-friendly interfaces with a focus on usability and scalability - Excellent communication skills and ability to collaborate effectively with cross-functional teams Additional Information: - This ...

I'm looking for a professional to scrape restaurant data from Google Maps in New Zealand. This project will require the following skills: - Expertise in web scraping technologies - An understanding of Google Maps and its API The specifics of the data required are: - Restaurant Name - Address - Ratings - Google unique business ID Data output should be organized into a CSV file and updated monthly. Candidates with prior experience in similar projects are preferred. Also, proof of proficiency in web scraping and data organization is a must.

...including not running properly, showing error messages, and providing incorrect functionality. - **Upload & Process CSV File**: The application should allow users to upload CSV files for processing. Upon CSV upload, the system should: - Parse and validate the data in the CSV file. - Store the validated data in a PostgreSQL database. - Provide a user-friendly error message in case the uploaded file is not in CSV format. Ideal candidates for this project should have: - Extensive experience with Java Spring Boot & React development. - Proven track record of troubleshooting and fixing software applications. - Proficiency in working with PostgreSQL database. - Solid understanding of CSV parsing and data validation. - Good...

I'm building a site in Oxygen with Advanced Custom Fields. I have created a custom post type with several different categories. I have then also created a custom archive template using a repeatable element. However, I can't get the archive template to display just the posts in the relevant categories. When I go to the front end categories, they either display nothing or all of them.

I am looking for someone to help me create a comprehensive database of art galleries in Dallas, Texas. This will be used for market research purposes. Key Requirements: - The database should include the names, phone numbers, and email addresses of the art galleries. - For each entry, I also need the street address, city, state, and zip code to be included. Ideal Skills and Experience: - Prior experience in data collection and database creation would be highly valued. - Strong attention to detail is crucial to ensure accurate and complete information. - Familiarity with art-related databases would be a definite plus. The end goal is to have a well-organized, accurate and comprehensive database that can be used effectively for market research purposes.

I'm seeking a Flutter developer to build an application that integrates with an API to perform CRUD operations on an SQL database. Key Requirements: - CRUD Operations: The app should be able to create, read, update, and delete records from the SQL database. - Database: The SQL database is the preferred choice for this project. - API Integration: The app should be able to read data via an API, handle user profiles, transactional data, and real-time updates. Ideal Skills: - Proficiency in Flutter development - Experience with SQL databases - Familiarity with integrating APIs - Understanding of CRUD operations - Ability to handle various types of data, including user profiles and real-time updates.

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

script for auto replying mail with attached files

I'm looking for an expert in MS SQL databases to help me with a specific task. I’m using an MSSQL database and need to create a Param scalar. This is to store specific customer information in a structured manner. The ideal freelancer should be experienced with: - SQL, specifically MSSQL - Parameter creation within databases - Experience working with customer information In your proposal, please provide an example of a similar task you've completed in the past.

...PHP/SQL script. I want it to help me capture, store and manage user reviews. The script will also redirect positive reviews to Google/Facebook for example. DEMO: The script aims to help business owners manage their business details, review sites, and customer feedback effectively by sending positive reviews to external review sites such as google or facebook and negative reviews are sent to a feedback form. —-> Please see example for exactly how I want website to look! Must be very clean and dynamic and perfect for mobile first. <— The project's requirements include: - User Review Capturing: The script should allow users to leave reviews without needing to register. - Database Integration: The script should store all reviews in a SQL d...

...experienced freelancer to add my physical products to my Woocommerce store. The selected candidate will need to: - Handle a range of physical products: My products come in a variety of sizes and colors, so experience with variable products in Woocommerce is a must. - Manage product information carefully: As I have a significant number of products, I will be providing the product information in an Excel/CSV format. The freelancer will need to ensure that this data is accurately transferred into the Woocommerce platform, including details on variations. Some products have 10 variables some products have 5, It's between 2-15 variables no more no less, If you understand all the above please type the price per product at the beginning of the proposal with the word RED. Propo...

data base design (model, sql) 590 laravel auth customized for phone (ALMOST DONE) 2360 Referral logic 2360 referral page register configuration Event Script (creates new even every 3 min will be a cron job for linux) 3540 Additional Pages 2478 { withdrawal page 708 Account details 472 Recharge page 708 Contact us page 826 } Betting Page 4720 includes the following { time and result feature 2000 betting feature 1000 events feature 500 my history feature 500 } Admin Panel 8378 withdrawl 1600 user manage 2000 manage result 1700 past events 800 earnings 1000 TOTAL 21950

I'm seeking a skilled PHP developer with sound knowledge in Javascript to handle a unique assignment. It involves integrating a database and implementing specific user interaction elements including retrieving and showing images on the website. Skills and Expertise required: - PHP for back-end development - Javascript for front end development, focusing on user interaction - Proficiency in retrieving and showing images online - Experience in database integration Though no specific frameworks are required, familiarities with Laravel, jQuery, or React.js are a plus.

The task involves loading multiple large data files into a database. These files, approximately 15GB each and in various formats like CSV, .db, .sql, etc., add up to an estimated dataset size of 1-2 TB. Preference is given to keeping the data locally on the machine, thus ruling out cloud storage solutions. The task entails consolidating and organizing fragmented files into a suitable database, whether it's a relational database or non-relational database. Initially, attempting the task with MySQL or any SQL databases is preferred. However, exploration of whether a NoSQL solution is suitable for handling such big data is also required.

...I have a basic understanding of php and sql databases but only enough to read and understand code not really create it. i’ve used chat GPT to create a very basic script and it’s not done a bad job however it’s unfinished. I can share my Chat GPT log so you can see the files created and understand the progress. It’s a simple script and most of the code is created. I need someone who can edit the code and fix the functionality. Here is what i was creating: The project is a web-based system for business reviews. It allows businesses to collect customer feedback through a simple landing page with star ratings and additional review links for external review sites. The system includes backend scripts to add businesses and review sites to a database...

...is to develop a simple system that will help me manage following for my store, Inventory Sales Administration Inventory Inventory management and verification are the main reasons for developing this system. Each piece of inventory will be tagged with an asset barcode, so that I can track where each piece is and when it was sold at what price. Also need to be able to generate a barcode in a query and report. See Each week, inventory will be scanned, and a report generated to figure out variations between physical stock and what the system says. Inventory dashboard and reports like aging, velocity etc. Sales Should be able to create a customer from the sales order screen. Sales order will be created using customer

I'm seeking a skilled Data Analyst who specializes in Power BI to handle a range of tasks, including data visualization, data modeling and analytic...to represent data trends effectively. - Develop robust data models that align with my business requirements. - Conduct in-depth data analytics to glean valuable insights. My data sources are primarily Excel spreadsheets and SQL databases. Therefore, expertise with these platforms is vital. Additionally, the candidate must be comfortable working with large datasets, as the project involves more than 10GB of data. Skills and Experience: - Mastery of Power BI for data visualization - Strong background in data modeling and analytics - Proven experience with Excel and SQL data sources - Ability to manipulate and analyze large...

I need someone to help with manual data entry from online databases to our system. Key Responsibilities: - Perform manual data entry from online databases to our system. - Ensure accuracy and efficiency in data input. - Categori...help with manual data entry from online databases to our system. Key Responsibilities: - Perform manual data entry from online databases to our system. - Ensure accuracy and efficiency in data input. - Categorize and label data as per our requirements. - Maintain data confidentiality and security. Ideal skills and experience for this job: - Proficiency in data entry. - Prior experience with database entry preferred. - Meticulous attention to detail. - Ability to work efficiently and maintain accuracy. - Understanding of data security and confidentiality...

I'm currently facing a speed issue while importing products through CSV files into my WooCommerce store. The CSV file when processed in a staged sandbox takes minutes, but on our live site is taking days. We are using WP All Import Pro paid plug in and despite this, the import speed is low. Key Requirements: - Identify the issue/reason why the CSV file is processing so slowly in live site environment - Troubleshoot and then fix product import speed in WooCommerce - Ensure the optimization does not compromise the integrity of product data. The ideal freelancer should have: - Proven experience in WooCommerce product import optimization. - Experience with WP All Import plug in

I am currently looking to engage an experienced Machine Learning professional for my project. I require analysis to be conducted on text data as well ...as well as numerical data. A strong understanding of Machine Learning concepts and analytical skills are vital. While I have not specified a particular focus area of Machine Learning, I am open to recommendations from the chosen freelancer based on the data provided. Key requirements include: - Proven track record in Machine Learning - Proven track record in Google Gemini and Google big Query ML - Proficient in data analysis and interpretation - Experience working with both text and numerical data Critical thinking and problem-solving skills with attention to detail will be necessary for the successful completion of thi...

...purposes and building me reporting and a UI(optional) that I request that contains all the data that I need into Microsoft Excel. I would like to be able to access the tables and columns as needed via SQL or a UI and ultimately easily imported/embedded into Microsoft Excel. Proficient in working with Amazon Seller Central and pulling back the relevant info for comprehensive, robust reporting purposes. Understanding of reporting data from Seller Central data and experience in data reporting and data analytics. Also ultimately this data is to be stored into a database and to where I can use SQL to create queries and tables for dashboard reporting purposes. Your work will be crucial in creating and enhancing reporting for accessing all tables and columns of data t...

I'm in urgent need of a skilled C# developer to integrate a database into my application. The project needs to be completed as soon as possible. Key Requirements: - Database Integration: The most critical aspect of this project is the seamless integration of a database into the application. All data should be accurately stored and retrieved from the database. - Timely Delivery: The urgency of this project requires a developer who can deliver high-quality work quickly. Ideal Skills and Experience: - Proficient in C#: A solid understanding of C# programming language is essential for this task. - Database Management: Experience in integrating databases into C# applications is a must. - Quick Turnaround: Previous experience in delivering urgent projec...

...me learn SQL from scratch, and show me how to implement SQL in Visual Studio using C# language, using SQL Server Management Studio. 1. Show me how to implement SQL in Visual Studio in the C# Language. 2. I already know C-Sharp well but want to learn how to implement SQL in my basic C-Sharp Order Management System so that when I enter basic order data in the system, CRUD operations perform and save to the database. 3. I have to utilise SQL Server Management Studio as i have no experience in how to connect this to Visual Studio. 4. The focus would be on showing me how to implement my solution using SQL Server Management Studio within Visual Studio 2022. Key Tasks: - Teach me the SQL fundamentals for this basic implement...

I'm looking for an excel expert to help build and format an advanced product database for the services industry. I already have an existing excel spreadsheet with many items already programmed so this will just be added on. This will revolve around three main components: -Product database containing items -Drop down menu to insert products from database -Custom Graph A strong working knowledge of Excel features, particularly Pivot tables, VLOOKUP function and conditional formatting is a necessity. It would be ideal if you also have experience in data management for the services industry. Your expertise will enable the creation of an effectively organized and easy-to-manage database.

I'm currently working on a project that involves fetching data from an API and loading it into SQL Server using SSIS. I've made significant progress, and I'm facing challenges that require immediate attention. Key Details: - I'm encountering error messages during the data loading process. - I require assistance writing the SSIS package to ensure efficient and error-free data transfer. - The data source is an API, so experience handling API data is essential. Skills/Experience Required: - Proficiency in SQL Server Integration Services (SSIS). -Must know SQL server - Ability to troubleshoot and resolve data loading errors effectively. - Familiarity with API keys for authentication.

I need help creating a CSV file or Excel data sheet. I need a professional who can assist with: - Creating a CSV file or Excel data sheet - Formatting the data accurately - Ensuring the file is easily accessible and understandable - Potentially, assisting with data input This project may require someone with a good eye for detail, data management skills, and experience with Excel or similar software. Please apply to discuss further.

I'm seeking a freelancer with proficiency in Python3 and OCR processes to assist with my forthcoming project. The objective is to establish an environment that can accurately extract printed text co...proficiency in Python3 and OCR processes to assist with my forthcoming project. The objective is to establish an environment that can accurately extract printed text content from PDF documents. This extracted data should then be converted and provided in CSV format. The possible necessity of machine learning integration is anticipated, hence experience with such is advantageous. Key job requirements: - Python3 expertise for environment setup - Proficient in OCR for printed text extraction - Capability to export extracted data into CSV format - Familiarity with machi...

I'm in need of a freelancer who can create a CSV or Excel file for the ecommerce platform we're using. While we haven't decided on the specific data types yet, it's likely the file will include product, pricing, and inventory information. I highly value the skill and experience over promises. So, in your application, please provide examples of past work in this area rather than comprehensive project proposals exclusively. Although we didn't specify whether we need a test file before the start, we're flexible in this area, and are open to discussing what works best for the freelancer in correlation to their workflow. Experience with ecommerce platforms would be advantageous, as well as strong attention to detail and ability to work within timelines. T...

I'm in need of an...error messages, specifically when attempting to upload files. Currently, these messages include "Invalid file format" and "unable to connect to Postgres ". I need these messages to be resolved as part of the debugging process. In addition to resolving these issues, the selected freelancer will be responsible for enhancing the system's file upload feature to accept CSV files. This would involve configuring the API to seamlessly handle CSV file uploads. Ideal skills and experience for this project include: - Proficiency in Spring Boot, REST, and React - Previous experience with debugging file upload systems - Strong understanding of API configurations for file formats If you're confident in your ability to efficiently de...

MS1: Solana Data INPUT: Solana contract address OUTPUT: (These may change in time. We are looking for only the snapshot at the time of the inquiry). 1. List of wallet addresses that have a non-zero balance of the input contract token AND no buy transaction for that token, at the time of the query. 2. Percentage of the total supply that these wallets under item 1 above hold collectively (%) 3. Percentage of the total supply under AMM (%) (Only Raydium is fine). 4. Mint authority info. - Must have: Mint authority revoked? (Yes / No) - Optional but great to have: Mint authority status (Permanently revoked, time-limited etc). 5. Liquidity info. - Must have: Percentage of the liquidity locked (%) - Must have: Liquidity burned? (Yes/No) - Optional but great to have: Liquidity lock autho...

I'm in need of a sleep analysis professional to help me interpret the data from an overnight sleep study. The primary goal is to analyze the different sleep stages present in the data. Key Responsibilities: - Analyzing the provided CSV sleep data - Identifying and labeling different sleep stages - Providing an insightful report on the sleep stages found Ideal Skills: - Proficiency in EEG analysis - Strong knowledge of sleep stages and their interpretation - Experience with CSV data analysis - Previous work on overnight sleep studies - Ability to provide clear and concise reports The EEG data must be manually analyzed, labeled, and provided. Please note that expertise in sleep stage analysis from overnight studies is paramount. The freelancer should be able to provide ...

I am looking to identify all nutritionists, gut health professionals and dietitians on instragram+tiktok that MUST be Australian based accounts with over 5000 followers. I need thier account name, and email address.

We are seeking a proficient freelancer with demonstrated experience in lead scraping to compile three comprehensive CSV lists of leads. Each list will pertain to one of the following sectors: funeral homes, dental practices, and law firms. For each lead, we require the following information to be accurately sourced and documented: Phone Number Email Address Website URL The project will encompass a total of 450 leads, distributed evenly across the three sectors with 150 leads each. The data must be current, verifiable, and neatly organized in CSV format for seamless integration into our CRM system. We prioritize accuracy and are looking for someone who can guarantee the correctness of the provided data. The chosen freelancer should have a proven track record in lead generat...

I require a skillful professional with proficiency in Power BI, SSRS, Power Automate, and SQL. The project involves both analytics and reporting. Key Responsibilities: - Develop an effective data model in SQL that supports data analysis and visualization in Power BI. - Implement insightful data visualization and dashboards using Power BI. - Create reports in SSRS for automated distribution. - Develop automated report distribution through Power Automate. Ideal Skills and Experience: - Proficiency in Power BI, SSRS, Power Automate, and SQL. - Strong background in data analysis and visualization. - Experience with creating complex data models. - Previous work on automated report distribution is a plus. The selected candidate will be pivotal in turning our data into ac...

...Review and enhance the query performance - Optimize our large volume data handling - Analyze and understand the existing aggregation pipeline. - Identify potential bottlenecks and areas for optimization. - Implement efficient algorithms and techniques to enhance pipeline performance. - Ensure that the script returns data in less than 100 milliseconds. - Test and validate optimizations to ensure accuracy and reliability. - Document changes and provide recommendations for future enhancements. This project requires an expert with a deep understanding of manipulating and querying large datasets in a NoSQL environment. Requirements: Intermediate in Python programming language. Extensive experience with MongoDB aggregation pipelines. Strong understanding of database...

I HAVE c# windows POS project for inventory management with Azure MS SQL database application. there is also WordPress ecommerce website. I want to display the quantity of each Item in the website based on the stock table in database verse wisa Skills & Experience: - Proficiency in C# programming - Experience in developing Windows applications - Good understanding of inventory systems - Proven experience in WordPress integrations, especially in relation to e-commerce platforms - Quick and effective problem-solving capacities. I am looking for a freelancer who could develop this api professionally with attention to timeliness, accuracy, and secrecy. If you meet the described criteria, I encourage you to bid. who have done same work earlier please bid budget $...

I'm looking for an experienced programmer who can develop a WhatsApp bot: Please go through each point and give brief explanation on how you will achieve this. 1) I have data in access db format. 2) I want a whatsapp bot which can access this database and reply to the message automatically after searching the database . While there's no mandatory requirement for a specific programming language or framework, an expert understanding of chatbot technologies and experience in creating instant messaging bots would be a great bonus. The successful candidate will need to interpret my project goals into a working bot, therefore excellent communication and understanding are key. To meet my urgent need for this function, I need the project completed as soon as possible. P...