Need help to create a query for Postgres to know the number of products on hand, need the internal code, name of the product and the qty on the stock. Using Odoo version 10 and Navicat as query builder. I need a Teamviewer or AnyDesk, so we build the query on my computer. I believe is an easy task for someone who knows the Odoo tables, therefore,
I have a Microsoft Access database that I would like update and a new user interface created when entering stats. I do not want it web based I would love the ability to use this program on an Android tablet so I can enter the stats and import them into the main MS-Access program.
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
Need a person who can do online Accounts finance stats cources
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.
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...
Need a python script to crawl some github project and get stats. Requirement see attachment. Suggest use Scrapy or Selenium but other frameworks are accepted as long as the job can be done.
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
We are currently working on a pilot/demo project for a large multinational, and are needing a web dashboard to display survey results. We are pretty certain that Shiny/R could be the best platform (from previous projects), but are open to suggestions!
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.
We wrote a neurosurgery manuscript for our client. The journal they submitted to sent the paper back from revisions including further analyses. The client is requesting we do Cochran–Mantel–Haenszel (CMH) analysis. Please don't contact us if you have never done this type of analysis before.
Hello i just want to make a crypto website, i already have a domainname, wordpress, but i need live stats of coins / price and more, i will give you a example . I only hire good experience scripters that made earlyer crypto related website before, and only talks good english. Kind regards, T Tran
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....
...radio server using icecast2. I also have a separate website where I want to display the stats from the icecast streaming radio (such as the number of listeners, the now-playing track, and the most recently played 10 tracks). I want to do this by parsing the server stats from a '[login to view URL]' file which is available specifically for this purpose. I require
...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
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.
We need a backoffice page where we can track Instagram users details: - keywords we liked for them - users followed / unfollowed - growth per month and week in a nice chart These details should be pulled from their instagram account ---- and a user are where they can enter their preferences: - which keywords they want to track - which users accounts they want to follow or not - ...
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.
The features to be added are: • Write (read) the game statistics into (from) a file, i.e., one which is stored on the hard disk between executions of Nimsys • A new type of player - a computer player, whose moves are automatically determined by the computer rather than a game user • A victory guaranteed strategy for the computer player Use project b solution as a startin...
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...
Get the stats of the league of legends using the api and show in a webpage
...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