Sql query search xml filescông việc
I need the search results page (when searching based on vehicle criteria or any other search) to show a page that matches the "shop" page or "category results" pages.
HEllo, I'm looking for anybody that provide me the SQL query that inserts the answers to the questions about the products from this module: The reply should be some thing like "INSERT ..."
I need a Freelancer to help my research team convert a DMP file with administrative data into a CSV file. Unfortunately, we have limited information on how the DMP was created. We can provide temporary access to our machines using a remote desktop to speed up the process. We tried to use ORADUMP to CSV software (https://w...help my research team convert a DMP file with administrative data into a CSV file. Unfortunately, we have limited information on how the DMP was created. We can provide temporary access to our machines using a remote desktop to speed up the process. We tried to use ORADUMP to CSV software () but failed. So, we suspect that the origin of the file is not ORACLE SQL. I am happy to provide additional information to help you bid properly.
Requirement is very clear I need DB Architect: Start Date – Immediate Work Mode – Remote Work Hours : 11.30 AM to 8.30 PM ( May stretch depending on deliverables) Exp: 12 YRS (Minimum) ü Proven expert at writing SQL code with at least 10 years of experience. ü Must have 5+ years of experience working with large data with transactions in the order of 5 – 10M records. ü Expert at performance tuning, Transactions, Dead Lock management, Triggers etc. ü Proven expert in Modeling enterprise-grade databases and architecture. Very strong at Entity Relationship. ü 5+ years of experience modeling loosely coupled relational databases that can store tera or petabytes of data. ü 3+ years of proven expert in working with large Data Warehouse. ...
Description: I am looking for a freelancer who can help me build my client list through web search and lead generation. The project involves targeting the technology industry and, 1. gathering 200 people into this excel: 2. Email them one by one, using my template *** to verify your ability, in your proposal, please create a new sheet and give me 3 examples for my sheets Ideal Skills and Experience: - Strong web search and lead generation skills. - Familiarity with the universities and technology industry and understanding of the roles and titles within it. - Excellent communication skills to effectively reach out and qualify potential leads.
I'm in need of a recruitment expert who specializes in non-profit organizations. I'm particularly focused on filling paid positions at my NGO with highly qualified individuals. Your role will primarily include: - ...the right candidates. - Network and build relationships with potential job seekers and professionals. Ideal Skills and Experience: - A proven track record in recruiting for non-profit organizations. - Strong understanding of HR functions, particularly recruitment. - Ability to fill a variety of roles in our NGO. - Excellent organizational and communication skills. - Strong relationships with job search platforms or communities for NGOs. This is a fantastic opportunity for those skilled in the art of recruitment and who are motivated by the idea of contribut...
We are seeking a skilled freelancer to develop a simple PHP script focused on data visualization, specifically catering to planetary hours. While the script's core functionality ...starts;Warning Message No3 Additional Features: Dynamic color changes in columns to distinguish between good and bad hours (e.g., light green for good, red for bad). Implementation of warning messages for inauspicious days, triggered if the date coincides with specific Hijri calendar days (3, 5, 13, 16, 21, 24, 25). Technical Specifications: The script can be developed using PHP, Java, JavaScript, or SQL. This is not a project for earn money it is just for a local information project. So Important thing is budget is very low not looking high class developer. I prefer freelancer who needs good r...
...don't know how to bypass it, don't bid. ----------------------------- I need script or app for scraping products from There are sitemaps with all URL products. Every product has ID in the end of URL. Example: The next step is to take that ID and connect it to another URL https://catalog.app.iherb.com/product/+ID where you will get the product data in XML format. Example: The script should scrap the data and create an XLSX document and write the following data in the columns: partNumber displayName weight
...information), physical attributes (e.g., height, weight, eye color), and portfolios (ability to attach photos, videos, and resumes). - **Search and Filter Capability:** Robust search functionality enabling easy filtering based on specific criteria (e.g., age, height, eye color) to quickly find suitable candidates for projects. - **Data Security:** Ensure high standards of data protection and privacy compliance, with secure login mechanisms for staff. **Ideal Skills and Experience:** - Experience in developing custom online databases or CRM systems - Proficiency in web development languages (e.g., HTML, CSS, JavaScript) and database management systems (e.g., SQL) - Knowledge of data protection laws and best practices - Ability to create intuitive user interfaces - ...
I'm seeking a skilled PHP developer to create a script tailored to my specific needs for managing XML data efficiently. This script will play a crucial role in the operation of my e-commerce platform, ensuring up-to-date product listings and accurate inventory management. **Key Requirements:** - Develop a PHP script to parse XML files. - The script must extract specific data elements: Product Names, Prices, Descriptions, and Stock Levels. - Import parsed data into a MySQL database. - This process needs to be automated to run on an hourly basis without fail. **Ideal Skills and Experience:** - Proficient in PHP with a strong understanding of XML file handling. - Experienced in writing SQL queries and database schema design. - Familiarity with cron jo...
I'm in need of a proficient Python and SQL developer for an exciting one-month project aimed at enhancing our data management capabilities and user interaction. This role requires a keen eye for detail and a versatile skill set that encompasses database optimization **Key Tasks Include:** - **Database Development:** Create a robust MySQL database that caters to our specific data management needs. - **Web Interface Creation:** Develop an intuitive web-based interface that allows users to easily interact with the data stored in our database. **Ideal Skills and Experience:** - Proficient in Python programming, specifically with experience in using Python for database manipulation and web scraping. - Expertise in SQL with a strong preference for candidates well-versed in M...
...conditional formatting, etc. 2. Strong knowledge of Excel functions and formulas for data manipulation and analysis. 3. Experience with data visualization techniques and creating dynamic charts and graphs. 4. Ability to work with large datasets and perform complex calculations efficiently. 5. Excellent problem-solving skills and attention to detail. 6. Familiarity with other data analysis tools such as SQL, Tableau, or Power BI. 7. Strong Knowledge of data analysis or reporting role. How to Apply: Please submit your resume and a cover letter outlining your experience with Excel and relevant projects. Additionally, include any portfolio samples or project links that demonstrate your proficiency. Additional Information: This is a part-time position based at our [Delhi] office. We ...
...intuitive report view screen. - **Main Landing Screen:** Must incorporate a navigation menu and search bar, aiming for a smooth, efficient navigation experience. - **Modal Pop-Up:** Create a modal that is engaging yet not intrusive to the user experience. - **Application Setting Screen:** Craft a settings page that is easy to navigate, with visually appealing design elements. **Design Aesthetic:** - **Color Scheme:** The app should have a "Light and Airy" color scheme, promoting a welcoming and comfortable environment for users. **Ideal Skills and Experience:** - Proven experience in UX design, particularly with Android tablet applications. - Strong proficiency in Figma, with the ability to share Figma files upon project completion. - An excellent eye for desig...
I'm currently working on a project that requires the extraction of blueberries from 4 images into PNG format. I am planning to paste these blueberries onto another image. What I need: - Someone with the ability to expertly extract the blueberries from these images & put a transparent background, converted into PNG format. - I do NOT want any of the original background present in the cut out. It needs to be precise. Thanks in advance for your time.
...precision and forward-thinking to lay a robust foundation for our data management ecosystem. **Ideal Skills and Experience:** - Expertise in database systems (Sql & NoSql) - Proven track record in optimizing database architectures for performance and reliability - Strong understanding of data security and integrity measures - Familiarity with the demands of various industries, enabling a flexible and adaptable approach to design **Project Goals:** - **Storage Efficiency:** Implement compact, yet expandable, storage mechanisms to handle growing data volumes without compromising performance. - **Retrieval Speed:** Design indexing and query optimization strategies that minimize access times and facilitate swift data retrieval. - **Data Integrity:** Ensure robust mechani...
As an oracle sql, PL/SQL and MySQL user, I'm looking for a database expert to assist me with several tasks including, database design, data migration, and performance optimization. The main goals are to enhance data retrieval speed, ensure data integrity, and optimize overall database performance. Key Skills: - Expertise in Oracle SQL and PL/SQL - Strong Knowledge of MySQL - Proven experience in database design - Skilled in data migration techniques - Track record in improving database performance The perfect candidate would not only bring their experience to the project but also provide insights and recommendations to help achieve the project's primary goals.
...the following information from each email: - Sender’s email address - Email subject - Body text of the email - Store the extracted information in a specified database. **Ideal Skills and Experience:** - Familiarity with different email service providers and their IMAP configurations. - Strong understanding of secure authentication methods for email retrieval. - Proficient in SQL or similar database query language. - Previous experience in email parsing projects. **Platform Used** AlmaLinux 8 64bit with cPanel ** Do Not ** -Ask us to install a framework -Provide code with outside (off server) calls to 3rd parties for any processing The goal is to provide a reliable and efficient way of processing emails into manageable data for our business operations. Freel...
...The developer should be well-versed in utilizing various programming languages, such as C#, Angular, and Node. The main purpose of this project is to develop a web application that includes: - A robust user registration and authentication system - Seamless interactions with database - Implementation of real-time updates To deliver these functionalities efficiently, a concrete understanding of SQL Server is crucial. I am looking for professionals who possess these technical and practical skills, in order to create a smooth and user-friendly web application. Your understanding and application of these programming languages should be of a high level. The right candidate should have prior experience in building complex web applications and should be able to showcase previous wor...
...and start work immediatly 3) Have 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 03:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Details of our current project STACK can be seen here -> Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales Key Responsibilities: 1) Administer Ubuntu environment where we run our project 2) Front end work migrating our current webapp from angular to , create new pages and functionalities in 3) Developers with experience in .NET API C# are an added plus as is knowledge of WordPress plugins. This is for ongoing long term development and
...Interface**: Easy navigation for a positive user experience. - **Responsive Design**: Accessible on various devices, including smartphones and tablets. **Ideal Skills and Experience:** - Experience in developing customer portals or similar web applications. - Proficiency in web technologies (HTML, CSS, JavaScript) and backend languages (PHP, Python, Ruby on Rails). - Familiarity with databases (SQL, MongoDB) for order tracking purposes. - Knowledge in implementing secure login systems and protecting user data. - Previous work that incorporates real-time updates and a keen eye for UI/UX design. This project aims to enhance the customer experience by providing them with valuable order information at their fingertips. I’m looking forward to collaborating with someone who sha...
I'm in search of an experienced website designer located within the Los Angeles area to create an engaging and informative website. My vision is to utilize this platform to educate the public on a specific topic that is close to my heart. It's essential that this site not only serves as an educational tool but also encourages user interactions and support through specific functionalities. Here are the aspects I'm focusing on: **Core Requirements:** - **Educational and Engaging Design:** The website should be intuitively designed to facilitate easy navigation through educational content. The UX/UI should cater to a wide demographic, ensuring information is accessible and engaging. - **Donation Functionality:** A secure and straightforward way for visitors to support ...
... Meta description Optimization 3. Heading Tags Optimization 4. URL Optimization 5. File Optimization 6. Image Analysis and Optimization of Alt Tags on Required Images 7. Hyperlink Analysis and Optimization 8. External Links optimization 9. Audit of Broken Links 10. Quality of Page Content & Density 11. Checking of Canonicalization error 12. Website URL Redirection 13. Optimized XML Site Map Creation for Google PHASE: 3 – Google Webmaster OPTIMIZATION: 1. Google webmaster installation 2. Google webmaster analysis and overview 3. Crawl Errors 4. International Targeted area Setup 5. Sitemap Submission in Google Webmaster 6. Testing 7. Testing on Manual Action & Security PHASE: 4 - *** OFF Page Optimization: *** 1. Article Submission 2. web 2.0 3. Social Boo...
I'm seeking a proficient Python expert who can assist with script editing and fixing. Your primary task would revolve around addressing logic errors within my script starting from some instruction I will provide. This role perfectly fits an individual with in-depth Python understanding and extensive experience in dealing with logical errors and fixing scripts-resultantly enhancing ...Python understanding and extensive experience in dealing with logical errors and fixing scripts-resultantly enhancing overall script performance. A first problem is that the script seems bound by particular dependencies and being poorly documented it is difficult to understand what causes the startup problem. Fixed that, we will move to the final editing of the script used to save output data to ...
Interactive Looker dashboard 1 Layout Data come sql server 4 tables pivot in excel
... and Location. - The flexibility to add other fields as necessary depending on future requirements. **Display Preferences:** - The form should be integrated as a sleek sidebar widget that doesn't intrude on the user's browsing experience but is easily accessible. **Ideal Skills and Experience:** - Proficient in WordPress plugin development with a solid understanding of PHP, JavaScript, and SQL. - Experience with WordPress API and email handling within WordPress. - Knowledge in implementing CRM integrations within WordPress environments. - Strong understanding of UI/UX principles, particularly in creating effective, non-intrusive sidebar widgets. This plugin is pivotal for capturing leads effectively and managing them efficiently. I look forward to collaborating ...
... Here's what I'm looking for: - **SEO Enhancement:** Elevate our position in search engine rankings to garner more attention. I'm in pursuit of strategies that position us ahead of the competition. - **Content Refinement:** Our website content needs a sharp eye to enhance its quality and relevance. The aim is to captivate our audience more effectively while remaining SEO-friendly. - **Keyword Optimization:** It's crucial we optimize our content with the right keywords without compromising on the natural flow and readability. I'm looking for someone who can find the perfect balance. **Ideal Skills and Experience:** - Proven track record with SEO, specifically in increasing website visibility and elevating search engine rankings. - Expertise in con...
OPEN POSITION: Data Base Developer ROLE RESPONSIBILITIES : -Develop and maintain our database system using PHP and SQL. -Optimize database performance for efficiency and scalability. -Collaborate with the development team to implement new features and functionality. -Troubleshoot and resolve database issues in a timely manner. -Stay updated on industry best practices and technologies. REQUIREMENTS : -Proficiency in PHP and SQL is essential. -Experience with HTML -JavaScriptand/or React is a plus. -Strong problem-solving skills and attention to detail. -Excellent communication and collaboration abilities. -Passion for gaming and travel is a bonus! Part time job 300 USD/Month
I'm looking for a seasoned SEO expert to aid in increasing website traffic and improving search engine rankings specifically for an e-commerceWebsite. With my audience primarily being e-commerce shoppers, the aim is to target these consumers more effectively and efficiently. Here's what I'm seeking: - Strategies that will boost overall website traffic - Tactics to significantly improve my e-commerce site's search engine rankings. While taking into account: - I don’t have any specific keywords or competitors in mind currently. The ideal expert will have the skill and knowledge to research and determine the most effective keywords to target within the e-commerce industry. Skills and Experience Needed: - Extensive knowledge about SEO - Proven expe...
I would need a button that allows me to share the result of a search that is performed through a form generated by a wordpress hotel booking plugin. I am currently unable to share the results of a search with my clients and would like to be able to share the results to lighten my workload. The goal would be to customize the results page to be able to share it with the client, either through the URL or through a "Share" button. At the moment, the URL of the results page is generic and does not allow it to be shared. I remain attentive to your quotations. Thank you, Translated with (free version)
Overview: Seeking experienced Core PHP developer to update existing APIs and...measures and authentication. * Test thoroughly for bugs and optimize performance. * Coordinate with team for front-end integration. * Provide documentation and support. Requirements: * Proven Core PHP API development experience. * Familiarity with maintaining and updating APIs. * Proficiency in RESTful API development. * Experience with JWT/OAuth and OTP platform integration. * Strong MySQL and SQL query skills. * Effective communication and collaboration. * Git version control experience. Duration: 4-5 weeks from Feb 20, 2024. Note: Interested candidates are requested to provide their resumes along with relevant work samples showcasing their experience in updating and developing APIs, specifi...
...fulltext search functionality in our PHP code. The main objective is to update FTP file support and improve how search results are displayed on our website, making the user experience more intuitive and helpful. **Key Features to update:** - fulltext search functionality for PHP files located on an FTP server. - Ensure search results are displayed on our website as a list, including: - A short preview of the content within each PHP file. - Highlighting of searched terms within the preview and the list. - Direct links to the documents as they currently exist on the website. - Implement deduplication in search results to avoid showing the same file multiple times. **Ideal Skills and Experience:** - Strong proficiency in PHP, especially wit...
I'm in need of a specialist capable of performing a migration of IBM EPIC Data Power from version V5 to V10. Key respo...Ensuring continuity of our integration functionality, and the installation and configuration features. - Providing evidence that the functionality of these features remains uncompromised after the migration. Ideally, you'll have: - Prior work experience with both IBM EPIC Data Power V5 and V10. - An excellent track record in executing system migrations. - A proficient understanding of XML processing and security within the Data Power environment. Installation and Configuration API-connect for Prod and DR API Connect V5 to V10 - Prod DC DR Synchronization Support for one month Let's ensure the successful and seamless upgrade ...
I'm seeking a programmer with solid knowledge in Netsuite Rest API, particularly with data integration. The main task is to query my Netsuite system through Rest API via SuiteQL What needs to be done: Generate in Postman the payload in order to obtain: a) The sum of all the invoices, credit notes and debit notes made to a customer between 2 dates. b) The composition ( invoices, credit notes and debit notes) of the overdueBalance of a client.
I am looking for a freelancer to prepare complete document on MSSQL server GAP analysis report looking forward to connect me : (removed by Freelancer.com admin) Thank you...
We're seeking remote contractors proficient in business intelligence with the ability to effectively train others. If you're skilled in data analysis, visualization, SQL, programming (Python, R), and other BI essentials, join us for global projects. What We're Looking For: Business Intelligence Experts with Training Skills: Data analysis, visualization, and SQL Programming (Python, R) Business acumen and problem-solving Effective communication and domain expertise Data warehousing and modeling ETL processes and OLAP Statistical analysis and machine learning Big data technologies (Hadoop, Spark) Agile methodologies and data-driven decision-making Cloud technologies (AWS, Azure) and data security NoSQL databases and web scraping Natural Language Processing (NLP...
I'm seeking a skilled web developer to create two web-based forms that will collect critical data in the form of dates, and efficiently store this data in a SQL database. The primary purpose of these forms is to streamline the process of gathering and analyzing specific timeline data crucial for my project's success. **Key Requirements:** - **Form Design:** Design two user-friendly web forms capable of collecting dates. Prioritize simplicity and ease of use to encourage accurate data submission. - **Database Integration:** Utilize SQL for backend storage. Experience with SQL is a must, as the forms need to seamlessly update the database in real-time. - **Report Generation:** Ability to generate summary reports from the collected data. These reports will be ...
...Understanding the vitality of timely information, my goal is to refine our database for better data manipulation and report generation. **Essential Features Required:** - **Report Generation:** Ability to create comprehensive reports including summary, financial, and statistical data is paramount. The database should compile data efficiently, providing insights at a glance. - **Query Building:** Enhancing the database’s query functions to allow complex data analysis and improve decision-making processes. **Report Specifics:** - The project involves formatting and setting up between 6 to 7 different types of reports, including but not limited to, financial statements and statistical analysis reports. The ability to customize and automate these reports is crucial. *...
I'm seeking a skilled freelancer to assist with a web scraping project two specific websites and leading up to a number of websites. The specific data fields that need to be extracted will be provided. Ideally, you'll have: - Advanced skills in web scraping and python - Knowledge of MS SQL Server databases. - A demonstrable understanding of data extraction - A fast turnaround rate as this project is high-priority and needs completing as soon as possible. The end goal is for me to eventually take over the code with your ongoing support and will most likely be a long term relationship. I can provide a full specification when needed.
I'm seeking an expert in audio editing to fine-tune my MP3 files (15hours audiobook) . The primary task is to adjust the RMS levels of each file, to ensure they all lie within a range of -23db and -18db. Ideal candidates should have: - Proficiency in audio editing software - Understanding of decibel levels and RMS adjustment - Expertise in MP3 file manipulation It's critical to note that this adjustment should be uniformly applied to the whole audio file. I expect every portion, from start to end, to meet the mentioned range. If you possess the outlined skills and have a keen ear for audio qualities, I would love to hear from you. Looking forward to perfecting my audio files with your expertise.
I am in need of an experienced ReactJS developer for the creation of a sophisticated front-end application. The key features of the application must include: - User Authentication: ...Integrating a secure sign-in system to protect user data. - Responsive Design: The application must look and function consistently on various screens sizes and devices. - Integration with APIs: The application needs seamless integration with multiple APIs. The application must be capable of interacting with an SQL database for data storage and retrieval. Having expertise in SQL database management would be greatly beneficial for this project. Ideal Skills: - Proficiency in ReactJS and SQL - Understanding of responsive design principles. - Experience in API integration. - User authen...
PLEASE IGNORE THE SMALL BUDGET MENTIONED IN THIS JOB POST. You can tell me the price of this work when applying for the project. Write a stored procedure / database query. In the attached file: all database structure and its data is present. I have also given examples with expected output. The table data is sample data I have entered manually. Some data can be wrong, so ask me any time if you think any data is wrong. All conditions are also written in it.
...real estate or similar marketplaces. - Proficient in creating user-friendly, responsive designs adaptable to various devices. - Strong knowledge of database management for handling extensive property listings. - Capable of implementing advanced search functionalities (Note: Specific search features like location-based, price range, and property type search are to be confirmed). Ideal Skills: - Expertise in JavaScript, HTML, CSS for front-end development. - Proficiency with back-end development (e.g., PHP, Ruby on Rails, Django). - Experience with SQL or NoSQL databases for storing property data. - Familiarity with SEO best practices to enhance the platform's visibility. - A creative mindset to design an engaging user interface. The project timeline was...
This price is for verifying some documents and filling out a questionnaire from some authorities in Benghazi
Let me tell you this, leave the items with the skp extension in the house that I sent as skp to the same place in the photo. The photo names and the file names are the same and it is clear what you can do with the photo. And I will be there for you with any questions you may have. Let's finish this job together in 2 hours, I will pay you 15 dollars after I deliver the job to the owner. I marked with arrows how to do it in the photo and wrote the file name you will place there.
I need a website built with a simple directory plug in for adult industry profiles for escorts in Australia only. Need the website built and a domain connected to it an...for adult industry profiles for escorts in Australia only. Need the website built and a domain connected to it and add SEO for it also. Need also a training log on how to look after it myself. As well as a monthly maintenance and look after it A directory plug in is ok also. More details: What specific features would you like the classifieds directory website to have? User profiles, Search filters, Payment integration, Boosting credit purchases What is the preferred platform for building the classifieds directory website? WordPress How would you like the website to handle adult content? Age verificatio...
I'm looking to hire a skilled individual or team to accurately input textual data from less than 500 individual PDF files. The ideal candidate will possess: - Excellent attention to detail, ensuring minimal errors. - Proven experience working with PDF and data entry. - Ability to deliver project within the agreed deadlines. - Confidence in handling sensitive or confidential information. Please submit your bid with an estimate of the time you anticipate the project to take. Past work or data entry examples are appreciated.
...MongoDB. **Primary Responsibilities:** - Design and implement API endpoints for complex data interactions. - Ensure seamless integration with MongoDB for data storage and retrieval. - Implement server-side logic to handle requests efficiently. **Ideal Skills and Experience:** - Proven track record of building complex APIs using NodeJS. - Solid experience with MongoDB, including schema design and query optimization. - Strong understanding of server-side logic and asynchronous programming models. - Familiarity with code versioning tools, such as Git. - Ability to work independently and in a team setting. **Looking For Someone Who:** - Is detail-oriented and can manage multiple data sources. - Has excellent problem-solving skills and can troubleshoot effectively. - Is passionate ...
I have two Excel files. There are links to a site with presentations. I need someone who understands Excel and can check links of images quickly to then combine to make a final list. I fired an analyst, then the other got pregnant. I'm guessing what the last files are which of course is pain in the bum. I saw what I was given missed rows from another file so have to figure out wtf is going on and combine. I can do but I have a lot to work on. There are columns of data I would ideally like spot checked (industry codes etc). I will hire quickly. There is no urgent deadline and accuracy matters. I will ignore you if you don't write my name Alex when messaging.
Let me tell you this, leave the items with the skp extension in the house that I sent as skp to the same place in the photo. The photo names and the file names are the same and it is clear what you can do with the photo. And I will be there for you with any questions you may have. Let's finish this job together in 2 hours, I will pay you 15 dollars after I deliver the job to the owner. I marked with arrows how to do it in the photo and wrote the file name you will place there.
