Hello, I need a sql query that generate a csv from a prestashop database, value required values in the csv are the following: id_order -> order number id_order_invoice -> invoice number total_products -> total paid of the order vat excluded and without shipping total_shipping_tax_excl -> shipping paid vat excluded state -> order state date
...locate the timezone of the visitor and then we display content based on the timezone. We are using a geolocation mysql table with 3M rows for this. The site is working fine when we receive maybe up to 100 visitors per second, but when that goes up to say 200 the server cannot process the query fast enough and the whole server stops. Old processes are
...select values is this session_id mentioned above. In the view, I only want to show records for the session_id associated with the current date. If I use MAX(session_id) in my query, I will get older session_id if they are the newest. If I don't aggregate this data, I get repeating records. Instead, there should be a single record for each person defined
High-Level We need a sharepoint online application built using the app model. The deliverable will be a solution deployed on a SPO site collection which will interact with external sources using the REST API model. The returned results will be filtered against keywords stored in a sharepoint list and all successful results will be displayed on the
need some help on nintex workflows for SharePoint O365
There is existing free app for o365/sharepoint access. I need this to be customised so that it is dedicated for our site and with our logo. Looking for both iOS and Android. preferably Xamarine or similar so that we can work further.
I need a SP 2013 workflow to lookup an entered field value against a reference list of values and, if this value is from the list, generate 'Approved' and if it is not found in a reference list generate 'Rejected'.
There are 3 tables: 1. Project 2. Tool 3. LinkProjectTool I need a query that lists everything in the Project table plus an extra column called ProjectTools. This column should contain a comma delimited string with all the tool names belonging to each project. The elements in this column should be sorted after Tool ID. The input data is contained
Physical Modeling Design & Structured Query Language (SQL)
Hi, I'm looking for someone who can fix my issue. By mistake, I deleted the node_modules folder and after that, I'm not able to get it retrieved as it's permanently deleted. Anyone knows how to resolve this?
I am building a WPF database application. It’s a basic inventory application. It’s using a telerik Gridview. I need help with some aspects like databinding an image to my database table where I need a byte to image converter. I’d like you to complete this step. Then I’ll take it back. I am likely to run into other aspects I can’t complete so there will
Create Document Management System under Sharepoint
We are looking for someone who can work with our marketing team to put to...who can work with our marketing team to put together a handful (4-6) templates that we will be using across our Sharepoint 2016 Intranet. The templates would need to be coded and set up as a quick template within Sharepoint. Previous Sharepoint experience is greatly preferred.
Need some help in creating custom page layouts in sharepoint online which supports mobile view
...have a MS sharepoint account also set up. (company accounts). I need to 1. Configure the MS Database so that users can log in via MS Access on their local machine and update the data, to be stored on MS Sharepoint lists. 2. The connection needs to either be live or refreshed each time data is added into the MA Access database. 3. The Sharepoint list will
Need someone experienced in Microsoft flows to build a simple flow for moving stuff on sharepoint. Please message me with your related experience and how you can specifically help with my request rather than just bidding on the project. Thanks for your time in advance!
Need some one experienced with MS Flow to build a MS flow integrating things available on sharepoint(moving things from one folder to another). Please message me with your experience and how you can help ask for more details rather than just bidding on the project. Thanks for your time in advance!
I want to demonstrate SQL data in a table. Picture 1 SQL query result. Picture 2 HTML table. I want to create a query which is result will be like HTML table. I mean I want to show Year column as a row and subjects as a group. I just need a query
Need help to create custom page layout for SharePoint
I have a query where I am dong inner joins and then doing a check for isnumeric and then data compare that is failing as I am getting Error converting data type varchar to float. Problem is I am not sure what it is complaining about. I need somebody to help me troubleshoot the query. I am comparing to how it was working a few days ago and do not see
The configuration of SharePoint online for our organisation (intranet) + training for team in Hyderabad, India
...knowledge about user modeling in dialogue systems required * Imagine a user that needs simple words for an explanation. I want you to create a program (in python) that can query Wordnet and find synonyms for words. There must be a function that given a word, it returns synonyms. def syn(word) will return a list of synonyms. Note: Complete commenting
...three levels of nodes. Expanding a treenode shows the child items under that node. If a user clicks on any of the nodes, the entire data set from that level is shown in the gridview. This code is currently working fine. I have also written some methods to copy and paste data from clipboard into the datagridview and to update the SQL table if the user
I have a software made in c++, that generate moving objects(airplane, cars, ships) with some parameters such as velocity, acceleration, position and direction. At...probability distribution. I would like to be able to determine the next velocities, positions and directions of the objects after the initial time by using kalman filter and skyline query.
customized sharepoint intranet site
I want to get detailed PrestaShop sales based on products: so the fields I want in the report are: product name | qty Sold | Average Product price | Total sold Price | Original products price | Total Orignal Price | discounted amount | available stock
I am looking to enhance the design of an existing SharePoiint 365 page. Currently it has a table and many rows. I need to improve the interface and make it more easy for the end user to view it.
Hi I am looking to improve the design of an existing SharePoint 365 page. The interface needs to look smoother and easy on eyes. Currently it has a table and it needs to be improved. Also there few other things to improve in the page.
Sharepoint 2010 business applications 1. User Hierarchy listing component 2. Sharepoint App Email notifications 3. Sharepoint content extraction - data model and files. 4. Build Dev, Continuous Environment
Hi, I got a SharePoint 365 web page and i would like to make the design a bit more cleaner and tidier and also make it a very smooth interface. Currently it has a big table with rows and columns getting filled with data.I would like to make the table more adjacent to the browser window and bit smoother to end users.
...fetched: reasy_posts reasy_postmeta reasy_terms reasy_term_relationships reasy_term_taxonomy Custo Meta Key : min_product_price. So please help me out to create sql query to fetch products from tables when i put the values in the fields and sort the products through meta_value(min_product_price). For Example: Find the products 'pen' where category
Hi I am looking to improve the design of a sharepoint 365 page. The page needs to look better and smoother for the end user. Currently the table borders are occupying the whole browser page. I need to make is smaller so that it correctly fits the browser. The fonts need to be aligned correctly and everything needs to look neat and uniform.
I need the following: - PHP Script(s) containing functions that can: - Authenticate with Sharepoint Online using API Token (Azure App) or credentials - PHP Script to run from command-line (php -q) - Check for the existence of a folder within a Document Library i.e. folderExists($folder) - Create a folder ... i.e. createFolder($folder) - Delete a
Intranet using Sharepoint 1) Functionality - Structure of pages - navigation of pages - easy to find stuff 2) Attractive and easy to use theme - Front page needs to be of our choice with options you have for us 3) Make it social - Integrate with Yammer - Intergrate with ESN 4) Integrate Active Directory - SSO 5) Make sure it is
Need a query build that will execute. Needs to have Select GL number GL Id number As of date Filters of less than or equal to 3 months (0 -91days) 3 months to 6 months 92 - 180 days) 6 months to 12 months (181- 365 days) Also include balance filters MILLIONS <=$100M >$100M =< $250M >$250M need to be able to add GL numbers to With as of date