Query project data trabalhos

Generating text file for all the orders and invoices. when a product has warrant selected, the product listed 2 times. one with warranty and another one without warranty. 1. fix the duplicate lines of product when warranty selected 2. we want to take this file and have a separate controller, it should be called whenever we want for debugging purpose when we pass a increment id, in the query string, it should generate order and invoice file for that increment id alone

...to build a static website for me which will have the data from two existing database tables connected to it. Additionally, the website is intended to be hosted on IIS. This project requires the experience and skills of a web developer to configure the IIS server, design and program the website, and create the proper protection for the data. The website should be visually appealing and easy to use, while being built and maintained using web standards to ensure compatibility between devices. I have a current windows 10 computer running IIS, and have attached it to my sql server and i also have the sql query written out. exactly what i need is a basic blank webpage, with a place to enter an item #, and click submit, then it will fill out data into 2 fiel...

Hello I have managed to query Facebook Graph API and extract correct data, which is available at an ad_id level. Now my problem is that we have hundreds of ad_ids, due to which the API keeps reaching its rate limit. So I want someone who ALREADY HAS PAST EXPERIENCE of working with Facebook Batch Async API to send batch requests and get 100% correct data that I am after. Please do not bid if you DO NOT have past experience with sending batch requests to Facebook API.

Load the dataset into MongoDB. Then query the dataset using MongoQuery. Implement a Mongo/Flask API server for a dash frontend to visualise. dataset: 's%20Datasets/retails_data. P.s: you can suggest any dataset you would like.

After rebuilding my PC and installing a newer version of XAMPP (origin PHP version: 7.2.34 / new PHP version 8.2.4) several of my PHP programs no longer work. The attached files are for one of them. We need someone...received when running this program: Fatal error: Uncaught TypeError: mysqli_query(): Argument #1 ($mysql) must be of type mysqli, null given in C:xampphtdocsskokielabelspi_classes Stack trace: #0 C:xampphtdocsskokielabelspi_classes(20): mysqli_query(NULL, 'set global char...') #1 C:xampphtdocsskokielabelspi_classes(20): AbstractDB1->query('SELECT * FROM `...') #2 C:xampphtdocsskokielabels(194): user->item_list() #3 {main} thrown in C:xampphtdocsskokielabelspi_classes on line 20

Update existing web access to include a query for CAS # related data from seven tables.

I have a partially developed ms access project. I need to develop the function for sending emails of records contained in a form and automatically sending emails for expired records form a query

I am looking for someone to help with developing a custom Azure Devops Extension. Must be familiar with the Azure Devops SDK, Azure Devops Api, React / Typescript, REST API. This project will have several phases. The first phase is: 1) Creating a Hub Group 2) Adding a Hub 3) Adding the Query UI from SDk to that user can run queries.

Hello I have managed to query Facebook Graph API and extract correct data, which is available at an adid level. Now my problem is that we have hundreds of ad_ids, due to which the API keeps reaching its rate limit. So I want someone who ALREADY HAS PAST EXPERIENCE of working with Facebook Batch Async API to send batch requests and get me 100% correct data that I am after. Please do not bid if you DO NOT have past experience with sending batch requests to Facebook API.

...for beach gear, sunscreen, and other related products. Includes a widget for quick access to current beach conditions and the best beach day of the week. App Screens: for all the project use the user correct location for location selection Home screen: Shows the user the current beach conditions and whether it's a good day for going to the beach, along with a user-friendly scale ranging from "Excellent" to "Poor." Also displays the sunrise and sunset times for the current day. Includes a search bar for finding specific beaches. Beach search results: Displays a list of beaches that match the user's search query. Each beach listing includes a photo, name, rating, and distance from the user's current location. Beach details: Shows deta...

...will have experience in researching and compiling lists of suppliers, and will have excellent attention to detail. The project will involve the following tasks: - Conducting research on home furniture drop shippers in the United States on Big Commerce vendors here: - Compiling a comprehensive list of drop shippers with their contact information and product offerings and pricing - Providing recommendations for the best drop shippers based on their reputation, pricing, unique offerings and customer service - Delivering the final list in a clean and organized format, such as a spreadsheet or database The project requires the following skills and qualifications: - Strong research and analytical skills - Familiarity with the home

I have a project which I have to present to a large audience and all I have at the moment is loads of unstructured data. The data given is about a feasibility study to find out if it's worthwhile getting funding for an app that would help people cook at home and save money. All this is fictional but needs to be presented properly. I would need details of the work as I have to present this project

PoC: We need sample code (T-SQL) to query data from ssms from Salesforce sandbox rest api (json). - install ssms - get salesforce account - run t-sql and query salesforce api

...Business Intelligence Analyst to help me with important data analysis work. I need someone who has comprehensive knowledge in business analysis and can compare different sets of data to uncover trends, dependencies, and correlations. This is a critical role, as the insights and knowledge gleaned from the analysis will inform strategic decisions. The analyst should have a strong background handling large datasets. The ability to visualize results, create meaningful and actionable reports, and work with SQL to query and process data would be advantageous. Moreover, the analyst must also have a strong understanding of Business Intelligence techniques and highly developed skills in presenting analytical data. The ability to incorporate data and ...

...me a strong understanding of data integrations, APIs, SFTP, and Webhooks. The position I am interviewing for requires additional skills beyond what I currently possess, including the ability to create connections on the fly within the platform. To demonstrate my capabilities, I have been tasked with creating examples in a demo environment. While I can follow instructions, I am seeking a qualified individual who can provide me with 5 hours of personalized, one-on-one assistance through a screen-sharing application like Zoom. The assistance I require will cover various topics, including making HTTP requests, inputting and adding query parameters, transforming collected data, defining output, global variable definitions, running data flow from a UI, displaying...

...seeking an experienced MySQL Admin/Performance Tuner to assist with an existing web application. The project involves reviewing DB setup and settings, looking at DB tuning and possibly proving assistance with query tuning. We are looking for someone who has extensive experience in tuning SQL databases, specifically MySQL databases in an AWS environment. The successful candidate should also have experience monitoring performance, and making adjustments to ensure optimal performance. The successful candidate should have excellent organizational skills, attention to detail, and be able to execute the project effectively and efficiently. We are looking for someone who can take charge of this project from start to finish, as well as someone who can advise best...

I am in need of a MySql expert who can help me optimize a query to reduce server load. The database structure is fixed and cannot be modified. This optimization needs to be done immediately. Ideal skills and experience for this job include: - Strong understanding of MySql database optimization - Experience with query optimization techniques - Knowledge of server load management - Ability to work quickly and efficiently under tight deadlines

We have a team of C# .NET developers but we are currently seeking a C++ developer to make some minor changes to an open source Windows C++ desktop application project. The program does not have an API interface, we would like to add this. There C++ libraries available that offer this functionality. Then we will want the program to connect our web API and based on certain events we want the C++ application to query our web API and then display the results in the C++ interface. You should be familiar with Windows C++ applications and programming as well as an understanding of web API.

We have website, that consumes high CPU power and the hosting provider suggest me to optimize the queries. The website developer is not able to do these things. So i need a person who have wide knowledge in query optimization.

The procject, to be made on Microsoft Power Automate (Cloud) consist in creating a process with the following steps: > Once an email arrive (officex360) with Subject " TO BE SPECIFIED " > Create a copy of the attached file ( it is a .xls file ) > Apply a filter that exclude the all rows containing "VALUE I DONT WANT" in column "COLUMN TO CHECK" > Save the copy on a dropbox path Connections with email and drobox are already set, it should be a very basic task for who knows Mycrosoft power automate.

...package #1 is $5 and allows for 10 API queries to GPT. Each API query will be based on 5 fields within their portal where the user enters information. When the user clicks a submit button located below these 5 fields, the API query is sent to GPT. Then information from those 5 fields is combined and sent to GPT along with a permanent prefix prompt that I have specified. (I use a similar Function in Zoho already and can provide access to that code.) Each API query will contain two questions for GPT. The GPT answers are then provided in two answer area/fields. Both answer areas will contain a heading, such as “Answer One” and “Answer Two.” Below the answers should be one button “Copy to Clipboard” so the user can copy the ...

...full-time job postings from google job search results and store them in a CSV format. The code should be able to efficiently collect relevant data such as Company name, company website, descriptions, posted dates, job title, and organize it properly into a CSV file. I need someone who has experience with Python coding, web scraping, and creating databases. The ability to work quickly and efficiently is a must. All code should be written in compliance with any legal protocols for using online data. If you are confident you have the necessary skills and experience, please contact me for further discussion. I also want python code. Google job search query link is below & screen shot is attached. :16

Friends, I have to make a single-page download website and I also want to know whether this website is possible in WordPress or will be made in PHP. I have my own hosting and Domain name. I want a fully responsive website for any desktop and any mobile. and I want this website in 5 to 7 days also I,m providing all details and information. any query then contacts me. here is an example of some websites: :// :// ://

I'm looking to clean up an excel /csv file and create multiple columns from a single column. i'm attaching explanation. I need this either in power query, pandas or regex python. for speed purposes. will pay $30 thank you,

Requiero una persona que me de un entrenamiento sencillo y practico de dos horas sobre Power Query, alistando datos para conectar y subir los datos a Power BI. La idea es organizar aprender a organizar los datos bien para que al subirlos a Power BI, todo esté okey

I am looking for a freelancer to help me add pagination to the homepage of my WordPress Colibri WP child theme. Specifically, I need pagination for the homepage only and I require that it includes tags but not custom post types. Additionally, it must work with a specific search query. If you think that you can help me with this project please let me know. Thank you!

Hello, I have a Snowflake database, which has 3 columns, Column 1 is a unique identifier and Column 2 and 3 are start and end date for leave. I want a new column based on following condition: IF ACTUAL_LEAVE_START_DATE is not null Count the number of days between 2023-05-11 - 2023-06-01 for ACTUAL_LEAVE_START_DATE and ACTUAL_LEAVE_START_DATE if n...2023-06-01 for ACTUAL_LEAVE_START_DATE and ACTUAL_LEAVE_START_DATE if not null. For example if ACTUAL_LEAVE_START_DATE = 2023-05-15 ACTUAL_LEAVE_START_DATE = 2023-05-29 The the days between would be 14 days Similarly if, ACTUAL_LEAVE_START_DATE = 2023-04-15 ACTUAL_LEAVE_START_DATE = 2023-06-1 The the days between would be 21 days Needs to be done ASAP, I will share the data for the table with you in excel and I want the que...

Homepage: List all available Pokemon with pagination (20 Pokemon per page). Display each Pokemon's image, number, name, and types. Refer to number, name, and types. Refer to for layout inspiration. Statically render the first three paginated pages at build time. Render the remaining pages in real-time. Pokemon detail page: Display name, image, height, weight, classification, type, weakness, and resistance of the Pokemon. Include a button to open a popup showing the Pokemon's evolutions. Query evolution data only when the button is clicked, not beforehand. Refer to for an example of a Pokemon detail page. Statically render the detail pages for the first 20 Pokemon at build time.

Hello, I have a VPS where plesk stopped working and it's urgent to be fixed. This is the error: DB query failed: SQLSTATE[HY000] [2002] No such file or directory Please help urgently.

...network link analysis solutions using JanusGraph database. • Conduct analysis of large data sets to identify relationships and patterns. • Work closely with stakeholders to define requirements and develop custom solutions. • Develop and maintain data models, schema, and taxonomy for the JanusGraph database. • Implement data visualization tools to represent analysis results. • Develop and maintain documentation for design, development, and implementation of solutions. • Provide technical expertise and guidance to team members and stakeholders. • Strong knowledge of graph database concepts and JanusGraph architecture. • Strong experience with data modeling, schema design, and query optimization. • Experience...

Hi i need one row htaccess query. i changed my website but it cant find files: old url (files will be found): new url, cant found: So i want just edit htaccess file so it shows pictures (.jpg) from old url. my budged $10

...DPC level) Your submission should include: a. A taking off list b. Marked up drawings c. A query and answer sheet d. Measurement in the traditional dimension paper (approximately 800 words equivalent) Specification 600mm wide x 1500mm deep C20 mass concrete foundation footing. Taken down to 2.2m below structural floor level. Walls below ground 100mm semi engineering brick outer leaf. 100mm standard dense concrete block inner leaf bedded in 1:3 cement mortar. A bill of quantities is not required. Assume the construction of the walls below ground is the same all the way around the building The project in Scenario 1 has now moved on to the post contract stage. The Client decided to use BIM on the project for a number of reasons: - The design team is made up of arc...

I need help solving a slow MySQL query issue and creating a new multi-column database index for a large database table. The database structure I'm currently using is MySQL, I do have an existing database index for this table, but it needs to be improved. The size of the database table is between 1GB and 3GB. I'm looking for a reliable Freelancer who has experience in database optimization and can promptly address this issue.

I am looking for a freelancer to create a social media post for me. This project involves creating an image post using a combination of both my own supplied images and also creating images. The post should not exceed 140 characters. This is a one-time project with an expected completion timeline of 1 - 3 business days. I look forward to working with the ideal freelancer. i need somting like this for my restaurant : https://www.freepik.com/free-psd/food-menu-restaurant-social-media-banner-template_31598573.htm#query=post%20media%20social%20food%20chiken&position=24&from_view=search&track=ais

...building and maintaining data streaming jobs using Amazon Kinesis Desired experience in working with database technologies and data development such as Python, PLSQL, etc. Solid understanding of writing test cases to ensure data quality, reliability, and high level of confidence. Track record of advancing new technologies to improve data quality and reliability. Continuously improve quality, efficiency, and scalability of data pipelines Knowledge of working with queries/applications, including performance tuning, utilizing indexes, and materialized views to improve query performance. Identify necessary business rules for extracting data along with functional or technical risks related to data sources (e.g., data latency, fr...

From the given training data, our goal is to learn a function that can predict the wine quality rating of a wine sample, based on the objective features. the predictor function will be constructed as a k-d tree. Since the attributes (objective features) are continuously valued, you shall apply the k-d tree algorithm for continuous data, as outlined in Algorithms 1. Once the tree is constructed, you will search the tree to find the 1-nearest neighbour of a query point and label the query point more details will be provided

I need help creating an Excel Database to store my data and query it as needed. Additionally, I will need the database to be integrated with an existing system. Having expertise in VBA is a must, as it will make setting up the database much easier. I’m looking for someone who’s experienced with creating such databases, and who can integrate the data with my existing system. I need someone who can quickly deliver results, so being able to execute the project diligently and accurately is also essential. If you think you can help me with this, please reach out!

...month. Unused questions can be carried over to the next month An eCommerce payment portal needs to be linked. The user receives an invoice and receipt and a copy of the invoice comes to the company/ can be exported ad hoc. If you believe you can deliver this project to a high standard, please get in touch. The landing page contains backghround image, logo, logon/registration button, dialogue entry container with "ask" button, and text on initial landing that is overwritten with the answer text, and a link to a contact page to submit a query....

I am in need of someone to add basic custom coding functionality to my Wordpress site. I have specific functions in mind that need to be coded. The project does not require complex functionality, but instead requires basic coding skills. If you are an experienced coder and believe you can complete this project in a timely manner, I'd love to see your proposal. Thank you for your interest! The specific requirement is to be able to conditionally display a page based on a databases query that takes the value of a hidden field on a contact 7 form and if a match is returned then display page otherwise display another page. The site is hosted on GoDaddy

...“INSERT INTO…” statements or Oracle bulk load. To get some realistic data, my suggestion is to grab and process some data from the Facebook website. Although you may not be able to populate a table with lots of content, you are required to estimate the number of records for tables that you created. The absolute numbers are not as important as the relative sizes of the tables. This information is important for choosing indexing and query optimization. 4. Fourth phase: you will come up with 10 typical queries that you expect to run frequently on your database. A good place to start is to look at the search and browse sections of the Facebook website. You will need to write down the English question and its SQL statement for each query and run...

I have a Java application that makes it easier for me to query for and apply for new jobs on Indeed but it needs some debugging. It is dependent on my local configuration and the only way to run it is with screen-sharing. I want to do this daily at 3 p.m. My current time is UTC +5 and is accurate at this URL I want to do this with you every day without fail where the goal will be to use the tool or do the work manually to apply to at least 25 jobs where my qualifications match and where the employer has been flagged as "responsive". Indeed does a good job of saving my most currently uploaded resume in the system as well as some prior responses. You can debug as much as you want but we must reach our target of 25 applications as well. Considerable experience in Java a...

...the percentage of students who were retained in grade, by US state, grade in school (K-8), in four different years (2011-12, 2013-14, 2015-16, and 2017-18). So this is a straightforward but laborious data acquisition and merging task. Take a look at the instructions and data sources below before you place a bid that's realistic about the time required. The percentage of students who were retained in grade can be calculated by dividing (1) by (2) below: (1) The total number of students retained in each grade and state is available in the State and National Estimations tab of the Civil Rights Data Collection, at . This is probably the hardest part because it involves downloading a different spreadsheet for each state and year, and the formatting of the spreads...

I need an HTML front end for Chat GPTX that will enable a user to cut and paste text into a box then hit one of six buttons below to have Chat GPTX rewrite the copy in a specific style. The button should both choose the style and initiate the call the Chat GPTX's API So the front end will send a query to Chat GPTX in the form Rewrite this {Copy from Box} in the style of {Style associated with button} Those styles are: Disruptors: Elon Musk Masters of the Universe: Jeremy Clarkson Heart and Souls: A Jerry Seinfeld monologue Campaigners: Simon Sinek Visionaries: A TED talk pitch without mentioning TED or talking Chief Fun Officers: Russell Brand Please see attached PDF for a very rough idea of the layout

Project Overview 1.1. Objective To design and develop a Windows service that automates sending emails and updating SQL backend database. 1.2. Scope This project document outlines the requirements, architecture, design, implementation, and testing strategy for the Windows service. Requirements 2.1. Functional Requirements 2.1.1. Email Sending The service must be able to send emails using SMTP protocol. The service should be able to fetch email recipients, subject, and content from the SQL database. The service should be able to handle email attachments. The service should provide support for multiple email providers (e.g. Gmail, Outlook,yahoo, smartermail etc.). The service should support retry mechanism for failed email sending. 2.1.2. SQL Backend Update The service shou...

My project involves creating a Wordpress Search PlugIn that will search Content as well as post and pages. The PlugIn will be coded in Full-text search, with a level of customization of Basic. The PlugIn should allow users to easily search through blog content as well as pages and posts according to their desired query. Specifically, the PlugIn should offer basic features including easy navigation and search, filtering results according to post categories, and an autosuggestion search box. I am looking for someone who can develop this PlugIn quickly and efficiently. The ideal candidate should have solid experience in developing PlugIns in Wordpress, particularly in regards to creating full-text search and basic customizations. If this unique project interests you, pl...

columns - Jan2034, Apr2034, Jul2034, Oct2034, Jan2035, Apr2035, Jul2035, Oct2035, Jan2036, Apr2036, Jul2036, Oct2036 table path - -- write simple sql query ---- targetallocation(column) is the first non zero value and the corresponding month/yyyy is the 1stmonthyyyy as starteff(column) and the same ending value giving row is endeff(column) and if the value changes then (target allocation(column) is the first non zero value and the corresponding month/yyyy is the 1stmonthyyyy as starteff(column) and the endeff is the day if it ends in Janyyyy then 31marchyyyy , Aprilyyyy then 30 june yyyy , Julyyyy then 30septemberyyy, octyyyy then 31decyyy)

I am looking for an experienced freelancer to help me with a dynamic 365 FinOps - SQL query project. Specifically, I need a data retrieval SQL query link to excel file. The query must be able to access invoice data. I have fairly complex needs and require someone with a great deal of experience in writing efficient and secure queries. I need someone who understands data structures, relational databases and how to best design them. Familiarity/experience with Dynamics 365 is a must. If you think you are capable of completing this project and meeting all my requirements, please do not hesitate to contact me. I look forward to working with you.

I need help with Crystal Reports 8.5 and Visual Basic 6. Specifically, I am looking for troubleshooting errors remotely or online. I need this help as soon as possible. A financial application was don...need this help as soon as possible. A financial application was done using Visual Basic 6 with Crystal Reports. It has 47 reports done in Crystal Reports 8.5 that reference ttx files. I am upgrading the application to C# but the reports are an issue. Because the reports reference txt files all the fields are defined there and I cannot determine what tables they reference and exactly what SQL query is used. The database is an Access database. I need someone to examine the application code and extract the queries and create views for all the reports which I can then use in my C# ap...

Edit Code like this: Website: After Login: "Call to undefined function mysql_query()" The website runs on Joomla.

I have the database below set up in SQL. I would like a query that calculates the liquidation fee when a user decides to liquidate some of their total investment. If the amount the user wants to liquidate requires liquidating more than one of their investments, the oldest ones should be sold first and the fee is 8% of the investment minus 1% for each full year old the investment is with a minimum fee of 0%. For example, an investment made 9 years ago would have a 0% liquidation fee and an investment made just over three years ago would have a liquidation fee of 5%. I want to know the total liquidation fee for the amount that the user wishes to sell. In this case, the user with a userid of 1234567 wants to liquidate $238 of their investment in the property called Links. After liquida...