Columnstrabajos

Solucionar el error: "ERROR 1055 (42000): Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘‘ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by" Causa: Hasta la versión 5.6 de MySQL 5.6 el modo de SQL era NO_ENGINE_SUBSTITUTION. En la versión 8 de MySQL los modos de SQL por defecto son ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, and NO_ENGINE_SUBSTITUTION Por motivos de seguridad, compatibilidad y mantenimiento en hosting compartidos no se modifica el modo de SQL por defecto en el servidor, y hay que modificarlo en el inicio de sesión dentro de la programación. O b...

Make a jquery modification so that while you scroll the page, in a section of 2 columns, the left column remains fixed while you scroll and after moving to the second column the left column changes fixed.

Translation English to German I have an excel data base. I need you to review and correct the translation Date in english columns G TO K In German coulmins L o R

...se pueda buscar escribiendo o en la casilla de fila 1 haya un desplegable con todas las opciones. In the list of products, in ROW 1 I want that I can type the product or the window be also a drop down selector with all the variables of the field. 5-Modificación de campos en los ficheros ODT. I want to modifiy the ODT files and PDF files for being able to enlarge the boxes, move the tables, add columns to the existing table... 6- Añadir un boton para que directamente, se pueda crear presupuesto, validarlo, crear un pedido a proveedor. When you create 1 propal to customer, then the propal creates 1 order to provider and email it to supplier (dorpshipping system) Espero sus ofertas y miles de gracias anticipadas...

...los datos y hacer validaciones - Leer archivos con la configuración de los combobox - validación de los campos (fecha fin >= fecha inicio) - Agregar filas de la tabla en forma dinámica. ------------- I require a Web development (a single page), which allows the entry of data related to how to read a text interface. Suppose we have an interface called "", and it has 4 columns (id, nom, f_ren, amount). The web form must allow you to enter all this information and then export it to a Json file. This Json file must then be able to read and re-fill the form data. The development must be done on a single page html5 + css + javascript (NOTHING MORE). The expected format is in the attached PDF file, along with the specifications. ...

Por favor, regístrate o inicia sesión para ver los detalles.

Presupuesto de $80, propuestas arr... Balance antes 7. Balance después 8. Billetera 9. Fecha Expiración En la parte superior de la tabla debe de haber 2 campos de tipo DATE, para el filtro del Ngx-datable por fecha de expiración, Integrar el botón de buscar y limpiar el filtro, todos los filtros se deben realizar en el Front-End de Angular. A table is requested using the Ngx-datatable component that contains the following columns: 1. Date Watering 2. Cellular 3. TransId 4. Recharge Amount 5. Currency 6. Balance before 7. Balance after 8. Wallet 9. Expiration Date In the upper part of the table there must be 2 fields of type DATE, for the Ngx-datable filter by expiration date, Integrate the search button and clean the filter, all filters must be...

Necesito que el filtro de categorías del portfolio del theme Bridge (Wordpress) sean desplegables. En el theme, por defecto, todas las categorías se muestra en línea, una al lado de la otra, pero yo necesito que el usuario las pueda escoger de un menú desplegable. Ejemplo de filtro de categorías por defecto: Tengo la última versión del theme, y puedo brindar una maqueta web para trabajar. Necesito presupuesto y estimado de tiempo de entrega. Gracias.

...balance called: Interest, these interests will not be a frozen balance but they can be withdrawn, or move back to capital to continue saving. The frozen balance for savings must have the option of having fulfilled its period of time saved, it can return to the BALANCE if the user wishes it. You must establish an X minimum balance option to be able to SAVE OR CAPITALize. The following 3 balance columns must be reflected on the site: BALANCE ---> SAVINGS / CAPITAL ---> INTERESTS GAINED. It must be able to adapt to the functions of: Deposit and Withdrawal of money Theme of WodPress where I intend to use the tool: = ICO Blockchain --------------------------------------- PRECIO A CONVENIR. ESPAÑOL: Detalles del sitio web: Estoy creando una etapa beta de una web banc...

...you found the birthdate fill in the column "Birthdate" with the birth date you found. If you did not find the birthdate, you must provide an estimation. We have given you some ranges columns (under 14,14-18,19-25,26-30,31-35,36-45,46-60,61 and above). Mark an x on the age range you think the creator has. If there are specific notes or comments, please let us know through the comments column. The ideal freelancer will: 1 - Understand Spanish 2 - Has attention to detail. 3 - Is able to estimate age by seeing a face. Once we award you the job, we will provide you a CSV file with the following columns: Channel ID - The id of the YouTube Channel YouTube URL - The url of the YouTube Channel YouTube About Page - The url for the about page where they ...

...filtros con los campos anteriores: Regards, The Project consists of the following: • Add the following fields to the Device table. • Customer Name • Loan Number • Start Date • Expiry Date • These fields should appear when creating or editing a device • A panel on the left side of the map view that has the following features: O A Search TextBox O A list of devices, including the DeviceId columns, Last Update Date of the position. O The option to edit device information O From the panel when selecting a device you must mark the position on the map and Open a second panel with the following information • DeviceId • Customer name • Loan Number • Vehicle model • Vehicle Maker • License plate &bull...

...profesional mínima 3 años en Desarrollo SharePoint (2010,2013,OnLine) Conocimiento de buenas prácticas en diseño y programación de sistemas, patrones como MVC, MVVM, etc. Conocimientos de HTML5, JavaScript, JQuery, C#, XML, CSS Conocimiento de desarrollo sobre base de datos Microsoft SQL Server Sólidos conocimientos de la API de cliente y de servidor de SharePoint: Site Definitions, Features, Site Columns, Content Types, List Definitions, Excel Services, External Lists, Business Connectivity Services, Custom Actions, etc. Disponibilidad para iniciar/completar ciclo de exámenes de certificación Microsoft relacionadas con SharePoint Aptitud para trabajar en equipo, con capacidad de autoaprendizaje y adaptación al cambio...

Necesitamos los datos de los directores de las 100 empresas más grandes de Granada. Aqui puedes ...(presidente, CEO) hasta 3 máximo. Por ejemplo el CEO/presidente, el CTO (technologia), o el CFO, CMO o COO. Por cada set de datos completos y correctos, ofrecemos € 0,50. O sea: nombre completo, email, y telefono directo. Buscamos los primeros 50 records. O sea entre 50 o 150 nombres y datos, por lo cual sería entre € 25 y € 75, si todo está correcto. Los datos hay que rellenar en un excel en columns sueltas: - ranking de la empresa (1 hasta x) - nombre de la empresa - página web (para poder clickear preferible) - Director 1 nombre y apellido - Director 1 cargo - Director 1 email (o sea, info@ no vale) - Director 1 t...

¡Hola Miki! Creo este proyecto para las siguientes plantillas: - Lasoo - Pacific Columns

Making pictures with columns, formulas, filters categories, summations, GRAPHICS

...tengo esta collection: ( { columns:[ 'Divisa', '05/10/2015', '02/10/2015', '01/10/2015', '30/09/2015', ], data:[ { 'Divisa':'USD', '05/10/2015':'11.236', '02/10/2015':'1.116', '01/10/2015':'11.153', '30/09/2015':'11.203', }, { 'Divisa':'JPY', '05/10/2015':'135.07', '02/10/2015':'134.24', '01/10/2015':'133.56', '30/09/2015':'134.69' }, { 'Divisa':'BGN', '05/10/2015':19.558, '02/10/2015':19.558, '01...

...para una autoescuela de manejo de capital federal bsas. Páginas: Home, Autoescuela, Nuestros Vehículos, Material de Estudio, Sucursales, Blog, Contacto. Indispensable un diseño creativo que no esté sobrecargado, sino mas bien claro. Una tipografia que le de cierto estilo, imagenes relacionadas que acompañen a los textos. Contara con un slider principal, un encabezado con logo menu y sucursales. Columns con textos, y pie de pagina. Opcional formulario de contacto tipo "popup" para la home. Es indispensable contar con experiencia en maquetacion wordpress, y manejo de visual composer, y ajustes necesarios para que adecuada visualizacion responisive. Se proveerá el theme wordpress, premium responsive con Visual Composer. El theme ...

...ser montado en la url que indiquemos. La página esta hecha en wordpress. Favor de indicar tiempo de realización e instalación y costo. gracias English 80x3 matrix with 240 possible outcomes. I require on a form, the user selects vertically one or more of the 80 possibilities for the first 2 columns (visually these positions will be given for product images), with option to indicate how many times each position. The program should identify the 80 positions of the first two columns and performing a multiplication of the position selected by the number of times the user has indicated. Adding up all the pocisiones the user has chosen once multiplied. Must generate a result 1 and result 2 column 3 is the equivalent of each selected position...

...in a wheelchair , etc. .. downstairs you think a height of 1.50 meters deep , which was made an area of ​​woodworking machines with distruicion and necessary for the parent to develop their profession comfortable , organized and well made, coated side panels of glass, to give him the space and breadth lighting .. on the outside of the facade with a juice slabs of wood , ranging fastened to the columns of the house, with a distance between the smoked glass (to give privacy to upstairs ) and support the subject , taking into account the paisajimos was placed between the slabs one ivy giving a more joyful, lively and interesting visual , which changes depending on the 4 seasons (summer, spring, winter and fall) Today disabled people are excluded from society and I think that just...

...widgetized Software Required: Adobe Photoshop CS+; Apache Server; For uncompressing a template ZIP package: WinZip 9+ (Windows); Stuffit Expander 10+ (Mac); WordPress 3.5.x; Hosting Requirements: PHP 5.3 or higher MySQL 5.0 or higher The mod_rewrite Apache module Features: Admin Panel, Bootstrap, Cherry Framework, Responsive Bootstrap Version: 2.3.1 Animation: HTML Plus JS Functionality: Blog Layout: 2 Columns Width: 1607px...

...description/image que se descubra al hacer mouse over Se valorará que sea responsive y que pase a un formulario en la misma pagina los valores seleccionados No queremos un desarrollo desde cero, solo aceptaremos pequeños cambios sobre interfaces que tengáis ya realizadas (para asignar el proyecto necesitamos una demo funcionando) We want a jquery/css year calendar, with months distributed in 3 columns/4 rows navigation between years Multilanguage Range selection, start/end date, changing color for it Beeing able to configure different kind of days with different classes applied Those days could have a mouse over description showning text and/or images Responsiveness and modifying a form in the same tab with the start and date will be added value W...

I am seeking a Power BI expert to create a dashboard for me. The main goal of the project is dashboard creation, with a focus on advanced layout and visuals. I already h...already have the data ready for use. I am looking for an experienced professional who can handle the following: - Advanced layout and visuals customization - Ability to create custom visuals and interactivity - Strong understanding of data analysis and visualization - Excellent communication skills to ensure the dashboard meets my exact needs The main thing, i want you to do is, showing/hiding columns of the report dynamically(in a published report), and letting user save the state and reload state at a later time. If you have the required skills and experience, please apply to this project. Start with the wor...

Currently use Google sheets for my company but need to organize it better. First column A is status, column B is Representative Name, column C is name of customer, column D is the date the customer was added, column e is blank, Column F is marketing source, column G is amount of column from J -AO that we color green Column H is amount of columns J-AO that we calculate Red. This is a shared Google sheets which can only be edited by admin although all representatives of our company can view it. What I need is filters so each representative can from a drop down select there name and only there deals will show up, and filters that if column A is colored red we can filter all the reds or all the greens and so on. Once the right person is selected I can show a sample of how the spreads...

I need a macro for Excel 365 that will allow me to export specific columns of data to a new CSV file. The exported file must be in CSV tab delimited format. The criteria for selecting the data to export will be based on specific columns. I also need the macro to match data in the other 4 sheets and delete certain rows based on criteria before exporting. Ideal skills for this job include experience with Excel macros and proficiency in VBA. Match, Delete and Export Excel 365 Macro This project is based on the enclosed sample active workbook, which has the following worksheets (one in each tab, labeled: Cases, Casework, Comments, Contacts, plan_request The macro should run in Excel 365. The macro should basically delete all the entries from a specific “Issuer State&...

Would like to parse rows of data into readable format then create an excel or UI filter to filter the data columns and display final data

Excel Macro to run on Mac Hello, I have a macro that works well on PC but not Mac. The macro is simple; it launches a user form that has list when the user clicks on a cell with data validation. Row source doesn’t work in Excel Mac. Many columns could have different validation lists:ranges. Again, doable in Excel Pc. Ideal skills and experience for this job include: - Proficiency in Excel and VBA programming on Mac I am open to discussing additional requirements and details with potential freelancers. Thank you for your interest in my project.

I have excel files with many data (over 130 columns). These excel files consists of soccer matches with results and their related numbers (Odds). All are seperated into countries. Otherwise all in one would be too big for excel. The other excel file (80 columns) consists also of soccer matches with results BUT with Goal Timings which are missing in the file where all numbers (Odds) are. So this means, when the columns of the file with numbers (Odds) is like this in excel: Date, Country, League, Home Team, Away Team, Results, Odds I need to put from the other file the columns of goal timings into the file with numbers (Odds) between the columns Results and Odds. It must be like this: Date, Country, League, Home Team, Away Team, Results, GOAL TIMINGS,...

I have approx 400 company names from Mexico with addresses and we need more details on these companies. I need details on the columns in orange. Website, Phone No, Email ID, Top Manager Name, Top Manager Designation, Top Manager Contact.

Por favor, regístrate o inicia sesión para ver los detalles.

Por favor, regístrate o inicia sesión para ver los detalles.

Hello, I need to take an xls file and separate the data into more columns so the data can be properly uploaded into out software.

write 2 shell Script to pull the following columns from winds servers and oracle databses ( host name, IP address, user id, AD group)

I am looking for a freelancer to create a simple macro for Excel to automate data entry. The ideal candidate should have experience in creating macros and be proficien...automate data entry. The ideal candidate should have experience in creating macros and be proficient in Excel 2010, Excel 2013, or Excel 2016 or newer. The specific data that needs to be entered will be sourced from another Excel sheet. The macro should be designed to streamline the data entry process and reduce the potential for errors. Two files are attached. The macro needs to match the codes in columns A in both files and then take the associated number in column G in the Plan A Stock on Hand summary file (the available to promise number) and drop that next to the matching code in the Cin7 export file in column...

...templates welcome) which will pull various stories from the sites we pre-select. To start we will provide the programmer 10 sites to pull stories from of different formats, but we will need a portal or way to add more sources, We do not have an exact site that is identical to what we want but a close one would be perhaps with a better looking design and triple columns. The site owner will specify a list of places that the items will pull from and an AI program should write a short description and publish the link. The sources could be rss, substack postings, yt new videos, etc. The site should post these items quickly, like every 15 minutes check for new things and post the links and descriptions. The site should do this automatically 24 hours a day and the

...three data files: , and Region.xml. The file records the information of wine list across the world which detailed information about their ratings is recorded in and records the country of each wine region. You are asked to: 1 Import all the data from the other files into the Excel file. Write Excel formulas to fill the last three empty columns in the file with appropriate information provided from the other files. 2 Assess the data and correct it if necessary. You are also required to use Excel functions to automate the correction. 3 Investigate the data distribution of wine price by drawing its histogram and boxplot and providing your insight. 4 The company wants to collaborate with the favourite wineries to expand its market

React.js SPA with datatables and Auth 1. Topbar with Logo on the left and login Link/logged in user on right 2. Collasible Sidebar with 4-5 menu items and submenu 3. Two Data table below topbar with 6-7 columns (no auth) - rows added/updated dynamically (data from axios api) - rows paginated (10rows) and not sortable - First column has links to show another table (requires Auth) - The link opens new table and replaces original table ((requires Auth)) - has 5-7 columns - rows added/updated dynamically (data from axios api) - rows paginated(100) and not sortable 4. have to integrate with AWS amplify and cognito as Auth provider 5. dark themed UI

Python code for the Jupyter notebook. It will be written entirely in English. The code should get odds information from the page The code should generate a database of games that will take place today next 40 to 60 minutes. The Database must contain the following columns: 1) Game day 2) Game schedule 3) Country 4) Alloy 5) Team Home Name 6) Name of Time Away 7) Current Home, Draw, Away, Over/Under, Asian Handicap, Both Teams to Score odds (With checkbox and with filters <, >, =, <=, >=, for all odds) 8) Send bot to Telegram from filtered games

...click at left side bar "Obras" and arrive at this form. This form should get data from api, and fill default table template. Expected columns: - Nome - Local - Date ini - Date end - Status At this form, we could add new, witch allow to create new item in Modal form. After user fill all required data, a button to save will send to Api. And if any errors occurs, this item will appear in table. This behaviour its expected to all forms (if any else specified) D - FUNCIONARIOS User must click at left side bar "Funcionarios" and arrive at this form. This form should get data from api (with token), and fill default table template. Expected columns: - Nome - NIF - Date Nasc - Idade - Status At this form, we could add new, witch a...

Hello freelancers, We are currently seeking an experienced Golang developer to join our team on a fixed contract basis. The project involves the development of microservices using Golang and integration with a PostgreSQL database. This is a remote position, a...building and consuming RESTful APIs. Strong problem-solving skills and the ability to debug complex issues. Excellent communication skills and the ability to work effectively in a remote team environment. Attention to detail and a commitment to delivering quality work. The microservice: I have 10 tables in the db. i need to perform CRUD on the tables. The api should include filters of up to 10 columns. in 6 of the tables have a 1 to 1 relationship between the domain class, controller and the database table. There is no busin...

...The ideal freelancer for this job should have experience in Magento 1.9 and be proficient in theme customization. Details: 1. Change mobile category view to show 1 single full width product column (currently showing 2 columns of products) 2. Change title location, product ratiing location, price location to image 2 attached. 3. Show variation colours as pictured, overlapping product image. 4. Show stock availability 5. Show custom attribute ("Delivery from Wed 31st May). 6. Remove padding and centre image. 7. Move Add To Cart button to bottom right. 8. Keep category columns same in all other resolution viewpoints, but they can all share the new product item view page. Attachments: attached is how the website looks now. I have attached of how I want the category vi...

... Requirements: Login Page (part of template) Viewing Page (64 iframes on single page which can show selected image/video) Dashboard Home Page (part of templatle) - Blank Camera Functionality (edit template) - host sdk in javascript (just host the index file on this page) AI Settings (part of template) - Keep it blank for now Add/Del Page (edit template) - Build a MySQL database with 5-6 columns and primary key, where a table will be shown on web page, and when we click on add, it will ask for various fields from MYSQL and once done, it will show updated table on web page. Similiarly when we click on delete, it will delete record from existing table Contact Details (edit template) - Same as above, enter Cam IP (primary/unique key) and edit details corresponding to it Want ...

...topics. 3) There are 3 Change Data Capture(CDC) kafka topics. 4) There are 1 Kafka sink topic Requirement: when there is a change in data, CDC kafka topic(point3) will trigger message to flink, and flink needs to send consolidate information of all data for particular row to kafka sink topic(point4) Employee table : Name, ID, Address, DeptId,statusID columns employeeDept : DeptId,DeptName columns employeestatus: StatusID,StatusName columns John(Employee Table) had an address change, employee CDC kafka topic triggers(point3), flink listen to CDC kafka topic, and flink program should be able to get the data from all three tables employee, employeeDept, employeestatus that belongs to John and send consolidated data of john(Name, ID, Address, DeptId,statusID, DeptId...

As discussed, ~2000 records scraped with just the two columns (business name and email address) for $150 (including Freelancer.com commission). spreadsheet with URLs attached.

I am ...append("Age") ("Win") ("Places") if j > 0: arr_row = [] columns = rows[j].find_elements_by_class_name("flexible-cell") for m in range(len(columns)): # print(columns[m].text) if m == 12: (runners[k].text) else: (columns[m].text) for idx_temp in range(len(arr_temp[k])): (arr_temp[k][idx_temp]) (arr_row) print("INDEX:" + str(k)) df2 = ((arr_save), columns=header_array) file_name = str(round(() * 1000)) df2.to_csv(file_name + ".csv") () ()

...others spreadsheets accordingly to what is found in the column I and J (ex. if column J = France and I = Orange, modify 'France Orange spreadsheet'. If column J = France and I = Blue, modify 'France Blue spreadsheet') with data from source spreadsheet. The app would then export the destination spreadsheet to a .csv file. The app would then open an Adobe Illustrator file accordingly to data found in columns I and J from source spreadsheet. Then it would open the .csv file as a variable library and export the result as a .pdf file. Then it would convert the .pdf to .jpeg. Then it would rename the .jpeg file with data found in column B from source spreadsheet. The second part is setting up a proxy connection on a website I have credentials to log in. Then reads t...

...have (internet) traffic based data like rank, impressions, clicks. displaying the data is limited to the users roles, if the user is allowed to view the data Having these frontends (as microfrontends) - a user administration frontend - a frontend to see the current cron jobs running with ability to run or stop it - a frontend to display the traffic data per user. Ensure the table has sortable columns, along with filtering on each column, along with searching in the table (e.g. datatable features) This is a test task, not a real project! Means we want to see your expertise in discussing, architecturing and building microservice and microfrontend apps. There are multiple issues to solve and if you have the experiences with it, you will easily name them and get down to the discuss...

I am looking for someone to combine two Excel ...show you what I am after in the final product. (See Rows 2 To 30 of the combined spreadsheet). The spreadsheets have a common identifier to match the data. (Column A of Data 1 and Column A of Data 2 are a common identifier and also Column O of Data 1 contains the horse's name which matches in Data 2. I need to be able to access the combined data spreadsheet cells by using formula. Also, in some columns, I need to be able to identify the highest value compared to other entries and identify the gap between the highest value and second highest value for each race. I will need assistance with Excel formula for this. Ideal skills for this job include proficiency in Excel and attention to detail and your willingness to assist me with ...

I am looking for an Excel expert who has experience with data entry and formatting. The project requires the entry of numerical and text data into an Excel sheet with more than 20 columns and 100 rows. I will provide the template or format for the Excel sheet, so all the expert needs to do is enter in the necessary data. This data must adhere to the provided template and all data must be accurate and up to date. As this involves a lot of detail work, the expert must be highly accurate and take great care when entering the data into the Excel sheet to ensure that no mistakes are made. Ultimately, I am looking for an experienced Excel expert to take care of this data entry project with utmost precision and accuracy.

...a Python developer to create a Simple GUI program that can take a ‘. Par’ file, perform calculations on its columns and generate results in CSV format. The program should also be able to generate two charts for specific columns, which will be discussed during the initial discussion. The key requirements for this project are as follows: 1. The program should be able to read a '.par' file and display its contents in a user-friendly interface. 2. The program should perform specific calculations on the columns of the file based on user inputs. 3. The program should generate CSV files containing the results of the calculations. 4. The program should generate two charts for specific columns based on user inputs. 5. The program should have a si...

Hello, I am trying to calculate the 3 yrs moving average across rows in R. The top part of the attached sheet is the original sheet I have. I would like to add a row (under each city) that shows the 3 years average temperature (see lower part of the sheet highlighted in yellow). I believe should be a simple line of code in R, but I am unable to figure it out. Can someone please help? Thanks. Jurgen