PHP Form, Query Search, Email on Complete, database creation, export into existing excel template
Change 1 - [login to view URL] returns results only from WooCommerce store. Client would like search to return results from both WooCommerce and from WordPress pages. Query page should separate results. Example: Search: "Fire pit" Query page: Heading: "Store results" fire pit result 1 Heading: "Page results" fire pit result 2
I need a basic tsql query for a the attached spreadsheet to produce the desired output. I believe I need a subquery to output file where; Distinct records where the status <> 'Active' Where there are duplicate records with multiple Status I need to output only one record where there are no Status = 'Active' The purpose of the report is to determine
...to create the same query outcome. I have attached 3 files 1) the create table script, 2) a data extract in excel 3) the sql we need to convert. We can connect you with our team in India who are aware of the SQL to assist in any way you need, but we dont have MySQL skills and there for need your help. The outcome needs to be query based results as
Very specifically, I am looking for someone to build a job template in Talend Open Studio for Big Data [login to view URL] that queries this SOAP Web Service [login to view URL] writing the response to a MySQL database. Once setup, I can then use (and customise) the job template at my end.
We need a single mysql query that gets records from 2 related tables. Please read carefully the [login to view URL] file before making the offer. We will provide also the 2 tables .sql files and a result table to show the result fields.
...mouse from both parties) and if possible capture using finger signature on mobile device. All data should come from mySQL so at any time, we can recreate the contract based on query select. Your job among others, is to fix the current workflow of signing (we will provide a docx for your review). The basic flow will be: a. Create Contract (admin presses
Looking for assistance on google sheets project. Need someone who is good with using google sheets for data mining.
We are looking for someone familiar or with good skills with MongoDB, Mongoose, Node, and Express. The task will be about building a query with about 40 parameters. All of them are non required so the query should work either if you get 1 or 40.
I am looking to learn advanced MS access
I am looking for a help with my database with Query / Report /etc
We are building a web that extract data from mysql, we do select with OR and AND contructs The data must be displayed in the browser as a list
From a Google App engine account, 1. Set up a new postgresql database as described in [login to view URL] That is, create a table with a few rows. 2. Deploy a Google web toolkit project mywebapp on the google cloud platform using ant in command line (not Eclipse) as described in [login to view URL] 3. Write java code to: first connect to the db from the server side in the file MyWebAp...
I have a Google sheet where I keep the record of my invoices. I need to do a statement by calendar month of those invoices that were not paid by the end of ...where I keep the record of my invoices. I need to do a statement by calendar month of those invoices that were not paid by the end of the month for each month. Need to do it as query preferable.
I have a database of insurance companies. Each record (row) has multiple insurance companies separated by a comma. I need a standardized database where each unique insurance company name occupies a single row. I had a colleague who created a quick macro that scans through records like this and builds a unique table. I lost the macro. Someone who is familiar with Excel can do this in 5 minutes. ...
To create a search query to find keywords / articles from 20 - 50 websites Require in about 2 - 3 days. Sort by keywords Sort by website Sort dates Process 1: Search 20 - 50 websites through Google Process 2: Search 20 - 50 websites direct Please suggest Process 1 or 2, or if both are possible. Optional Able to de-select sites
I am looking to learn advanced MS access
a WordPress website already responsive but has many issues on mobile devices and needs improving. no access will be giving you can work on the main website CSS file then send it to me to replace it. Job should be done within 1 day. Please when sending proposal make sure it is relevant to what I need.
select phone_number,from device_status where bal <>'0.00' and phone_number>'1' and updated_at > date_sub(now(),interval 5 minute) and bal < '5000' and tries < warn and accumulated < x; Some entries will be found Log into a web form *225*[number]*[rand]# where rand will be a random number in a range rounded to a certain amount. Click send....
...htaccess file already has a few hundred redirects in it. I'm currently doing a lot of standard 301 redirects in the file, but also have some URL's (maybe 50 - 80) which have query strings. I need someone who can sort out the file and use a combination of redirects to get all redirects working.. It should NOT take more than an hour if you know what
...as specified in the paper and get the results as shown but I am not able to understand the equations given on page 4 of this paper. I am even giving a link which shows the creation of Morlet wavelet but again I am not able to understand it. You can even use that program to create the filter but with certain parameters fine tuned so that I get the desired
We save data with ACF( Advanced custom field) plugin I need a DB column match (like a filter would work) then sort...employer vs. Jobs skills available by user *Excel calls this a multi-column sort I was told that a separate table created in DB was best and faster???? I need the MySQL Query, the WP save, and the WP return results sorted
Necesito crear una newsletter en HTML, para enviar por correo a mis clientes. Esta debe ser responsive, creada en HTML5 y Media query, EDITABLE. Todos los textos e imagenes deben poder ser cambiados. Se utiliza Blade (laravel) como motor de plantillas.
...Prepayments. Bank reconciliation, External Bill matching, PDC reminders, PDC discounting, Bank status query, Non-Stock item purchase/sale, Cash flow statement, Financial budget. c. Ledgers, Trial balance, Ratio Analysis, Receivables and Payables, Ledger Query, Transaction type wise ledger values, Issued Cheque Listing, Daybook and bank book, MTD, YTD Balance
Query Generation: This is a one-sentence English command writing assignment project with a questionnaire survey at the end. The Worker will work on this task in the form of an excel sheet to generate verbal (spoken) English. This task will require you to think creatively and write conversational English as if you are actually speaking (Whether it's
Need a Use Case, Sequence, ER diagram and sql query. Please message for more information.
I need to build XML3 Files from ERP System using ODBC Connection. The structure is for Bank Payment files. Expecting 1 hour quick job as everything is in place already.
I have Mongo collection that I need Grouped and mapped. I'll provide the details of the initial schema and the result in the file. This is one query that should be easy for an experienced Mongo data scientist or Engineer.
Description: We have a local database that contains texts from thousands of user feedbacks on certain product. The aim of this project is to use keyword and Google universal-sentence-encoder to filter out only the relevant feedbacks to display on a local page for further analysis. Deliverable: a. python scripts to parse the text from MySQL and store the results back into MySQL b. php script...
...following 1. First page will contain two prompts ( DRIVER / VENDOR ) 2. Second page will ask the DRIVER OR VENDOR for telephone number in XXX-XXX-XXXX 3. The third page will query a MYSQL database for the drivers or vendors TELEPHONE number and if they have done this before the PAGE will display WELCOME BACK (NAME) or if they are not in database it will
Hello, I need some help with an informix pass through query. Im currently connected to the database using access. The query below needs modifiying SELECT idc_userid as User , event_ts as hours, after_event_qty as Qty, event_loc1_text as Location, event_ts as Time, item_nbr as Item, substr(event_loc1_text,1,2) as Area FROM wms_appl_event WHERE
Im working on query, basically i want: if slideIndex is on int & post has tag == 'tagslug' & category = 'slug' then output posts. i have the code owrking, its just the query itself im not sure how to do. can anyone help?
Hive SQL queries to query a range of thousands of rowkeys. The 1st rowkey in this case can be of the format 20170806GOLDSTANDING01a345 and the second rowkey can be 20180102GOLDSTANDING01a345 The task is to isolate the date as a range of 20170806 to 20180102 and output all the in between rowkeys
I got a script that query MS SQL and PostgerSQL and create a CSV file with data. Also it query data from powerCLI of VMware. The DB is realted to VMware SRM. It work too slow and i want someone that is expert in this to look at it and fix it even by recreate the script.
...city , Metropolitan area, U.S as below : Facebook Activities Number of Key Phrases Optimized Page Setup Cover Photo Creation Activate Call to Action Button Designing Query Tabs Content creation & Optimization Creation of Hashtags, Story Boards, Campaigns Promoting brand in Target audience specific groups Page Traffic Analysis Tracking
Sto lavorando con Access su un database tramite il quale vorrei geo-referenziare degli eventi. Il mio obiettivo è quindi quello di ottenere una tabella contenente IDevento, coordinata x, coordinata y dell'evento. Le informazioni con cui georeferenziare sono contenute diverse tabelle che dovranno essere collegate per ottenere il risultato.
Chinook Database Introduction In this project, you will query the Chinook Database. The Chinook Database holds information about a music store. For this project, you will be assisting the Chinook team with understanding the media in their store, their customers and employees, and their invoice information. To assist you in the queries ahead, the
I'm looking for a SQL query on a postgres database that will find the closest road geometry and return the closest matching database record. Sample Latitude, Longitude for Lookup: 51.38356, 0.15047 51.42524,0.23797 51.40002,0.20599 This query needs to be able to handle a 1 lat/long value or multiple lat/long values It needs to search:
I need to do a query in cassandra
Hello! I have a very simple problem. I have a button that sets a recordset based on a query. For example: rs = [login to view URL]("qryName") This query has a WHERE clause where I need to specify that the records are from a certain year. This year value is pulled from a control on the form the button is located on. For example: WHERE
Its about query retrieval and performance analysis. you will need to implement the query processing and retrieval portion of the search engine. Your code should support the Vector Space Model and use Cosine Similarity as relevance measure. Your IR Engine should be capable of calculating TF*IDF weights for all the terms in the collection and in the query
I have a php script that runs a mysql query and dumps out the results. I need to adjust the query to join two additional tables and dump out the correct results.