I am looking to rename multiple choice answers client side (php file) that are showing as numbers. Example what I now have in my PHP file: 'sql_query' => "SELECT element_10,element_2,element_3,element_5,element_4,element_6,element_8,element_9 FROM ap_form", Here's what I need element_5 has 2 choices Choice 1 is showing up 1 I would like it to be MA Choice 2 is ...
I have a CSV sheet w/ all the appointments made at different locations which have the client ID number. I would like to take the client ID from the appointment table and match it with the Client Table to find out their name, number and email and which location they booked at.
I am looking for bash script to be running in centos server holding whm and cpanel accounts Functions required 1-Install and activate around 6 plugins if not installed 2-Update the current plugins 3-Update wordpress core 4-Remove inactive plugins 5-Remove inactive themes 6-Search for all htaccess files and add a specific some code code 7-Checks how
Hi All i have a table like attached image needs first negative balance date followed by second last positive balance means 7769 . -3752...like attached image needs first negative balance date followed by second last positive balance means 7769 . -3752.86 2018-08-10 08:06:35 1 min job for expert send query in your reply budget : 500 INR
I have MongoDB collection. I have to group the documents in that collection based on the monthly cycle. For example, the cycle date is 20 of each month. I have to group the documents like 20/06/2018 to 19/07/2018 , 20/07/2018 to 19/08/2018.
I need someone to write a simple sql query to copy fields between tables
we have a form for insert data, we need on submit to create a query before to process to check if data exist and IF exist show a modal with alert and name of data else process
...wouldn't even know which language is appropriate). I tried Zapier, but it falls flat with no eBay support, and insufficient Dropbox capability. I have tinkered slightly with bash scripting and python, but amateur would be an over statement. That said, I am hoping, the end product is written in a manner allowing me to follow the logic, including some
I need someone freelancer to help me to fix the query below: select count(distinct p.products_id) as total from (products p) left join manufacturers m on (m.manufacturers_id=p.manufacturers_id) left join specials s on p.products_id = s.products_id left join tax_rates tr on p.products_tax_class_id = tr.tax_class_id left join zones_to_geo_zones gz on
I'm looking for a bash script able to connect to remote linux hosts and send commands, retrieve files to save on server, this script should list connected hosts, add more hosts , delete connected hosts. You can use ssh, netcat, etc. contact to me for more detail.
Query on Office 365 Excel Online to export the data. No bootstrapping. Need to use Dojo or jQuery, or find a way to get it into that format for me to use.
Project Duration: 1 Hour Project Overview When trying to run this query: SET `description` = REPLACE(`description`, 'â€™', ''') WHERE `description` like 'â€™%' We get the following error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right synt...
I am currently getting a 500 error on my website. I traced it back to an SQL query (SELECT XYZ FROM zip_code INNER JOIN city ON zip_code.city_id = city.city_id INNER JOIN region ON city.region_id = region.region_id INNER JOIN country ON region.country_id = country.country_id). The INNER JOIN country ON region.country_id = country.country_id part of
Scrape from a google spreadsheet into a database on Azure or EC2, and create a UI for non-technical people to query. Make sure certain users can add but cannot delete data from the db. Also the UI should sanitize and validate the data before entering it int the database.
...passwd file and the encrypted password in the shadow file. The passwd file containing account information might look like this: smithj:x:1001:1001:John Smith:/home/smithj:/bin/bash The shadow file containing password and account expiration information for users might look like this: smithj:KJDKKkkLLjjwlnttqoiybnm.:10063:0:99999:7::: The fields in the
Hello, I created 2 scripts bash. The 1st script which save in a file all what i write in an ssh session, and the 2nd session use this file for crawling and save in a txt file all raw html source code. I used elinks bin, but since 2 days, elinks doesn't work anymore with Cloudflare. I need someone to modifiy my second script for avoid the cloudflare message
I am looking for a simple bash script that can parse a csv file, extract specific files use these fields to populate a mysql dB via the bash script. One field will be a date timestamp. One a time timestamp and then 2 other fields.
I have a quick issue I just need some advice on Fixing or a slight change of code. JSON Response is being presented to the app however, it won't append to the Dictionary that I'm trying to use. Paying a maximum of $30AUD for this as it is a quick code fix. Just needs a simple fix.
We are looking for various software dev roles. Some projects foccused on Linux using BASH, C, C++, python, node.js, others app and web layer HTML5, CSS, MEAN.. we have part time and full time positions as well as project based jobs. Pay level is flexible we are looking for dynamic skilled developers and are willing to compensate for it
Select rows to display the columns: name of product/service assign alias as “ProductService”, quantity sold of product (invoice detail), employeeID who is assigned to the invoice; where the employee ID equals 1; sort by name of product/service ascending.
SELECT [login to view URL], SUM([login to view URL] * [login to view URL]) as price FROM Customers INNER JOIN Invoice ON [login to view URL] = [login to view URL] INNER JOIN InvoiceDetail ON [login to view URL] = [login to view URL] group BY [login to view URL] I CAN"T SEEM TO GET THE Customers.Firstname...etc... because of the SUM... I can get one or the other but not both...
I have a request table I need a few queries done on. This is an excel sheet. I need to find out quick analytics on our user behavior. It would be excellent to get the %, numbers and graphs depicting results.
...searching for a developer who can write a bash script that automatically deletes old releases. I have a folder with 2 subdirectories and a symlink named "current". The symlink "current" links to the latest release in the folder "releases", which currently is (as you can see on the screenshots) the folder "497". The script should be ...
1. Write a bash script that change the grub default boot to the highest kernel (not necessary the first entry) version. The OS is CentOS 6.x. 2. For a load balancer (HAProxy, Nginx, etc) that handle high volume of concurrent connections, what are some key system parameters should be tuned. Assume this is on CentOS 6.x and iptables is running.
This work involves a pdf file of shipping labels with multiple pages that needs to be sorted based on a reference number in a text file that matches a label/page within a pdf file.. ie A list of alpha numeric letters/numbers are given vertically in a text file that need to be searched within the pdf file and as the pdf file finds the queries within its pages (which is one per page), it creates a n...
Hi Everyone, I'd like a Bash Shell script which downloads 4 csv files from static URL's and then hosts them on the server. It will only download the file if it's not empty. 2 Files will be merged to create 1 larger csv file. Likewise, the other 2 files will merge to create another csv file. Example, download from URL to server/downloads/: http://www
I'm wanting a bash script that will check whether or not specific permissions are applied to an IAM role/user. Below are the required permissions. [login to view URL] I'd like to have the user be prompted for the region+IAM role and the print what permissions are or are not applied. Example: >Enter region us-west-1 >Enter iam role Arn:IAM:blah
Develop an agent on golan...tasks: setting up the environment, docker, CI, etc. (optionally) Requirements: - understanding disk subsystems and raid - good golang/python skills - optionally node.js and bash scripting skills Working conditions: - A number of questions will be asked - hourly payment - full employment Full task will be sent additionally
need a Linux script to compare and match 2 excel sheets with argument take each line from first file> search for match in second file and find result according value in the 2nd column in the first excel sheet compared to the value in the second excel sheet
Hi, I would required a simple shell script to send me a daily report of sendmail from the log with the following option as below:- 1. Required a shell/bash script to filter and output the selected results 2. I would need a email subject and delivery status including the timestamp for the results as to be delivered in [login to view URL] format.
I need you to build a landing page. budget 600 Rs