Query parameterdela

Obdelava podatkov, izdelkov različnih proizvajalcev iz različnih virov z Query-ji, lepljenje po ID-ju ipd ipd Trenutno imamo 1 projekt za nekaj ur dela. Po podobni logiki so v pripravi novi projekti..

...create a chatbot whatsapp business integrated with Mikrowisp The chatbot will serve as a tool for registered companies to interact with their customers. Key Features: - Options menu: The chatbot must provide the options menu, and a limit of queries to exit the chatbot and transfer the advisor. - Invoiced amount query: The chatbot must provide users with a simple way to find out the amount owed and due date. - Consultation of the user profile: The chatbot must respond to the contracted profile. - Spanish Support: The chatbot needs to be capable of interacting with users in spanish - Company Management: The ability to enable, disable, or delete companies from using the chatbot should also be integrated. Ideal

I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like Excel, CSV, and SQL formats.

...this metadata to construct and manage API endpoints dynamically. 4. ORM Flexibility: Any ORM tool like Entity Framework, Dapper, or SQLkata can be utilized to facilitate database operations. The choice of ORM should align to optimize performance and simplify maintainability. 5. Advanced Data Handling: Column Selection: API users should be able to specify which columns to retrieve in the query. Filtering and Sorting: Support comprehensive filtering and sorting capabilities to navigate through data efficiently. Pagination: Implement pagination to handle large datasets effectively. Aggregation and References: Enable aggregation of data from child tables and retrieval of related data from master tables (e.g., retrieving a customer's name when querying...

I'm seeking a flexible skilled coder with robust experience in Pinescript and TradingView platform who can modify my existing Pinescript indicator. Key Modifications Include: - Parameter calculation changes: This includes both adjusting current indicator inputs and modifying the calculation formula to maximize the efficiency and effectiveness of the indicator. - Adding options to the settings interface to allow for customized user experience. - Based on testing, would need to accomodate any suggested changes realtime Your skills and experience in TradingView and Pinescript will be vital for the successful completion of this innovation-focused project. Your keen attention to detail and understanding of financial markets will also be advantageous.

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

...Development needed to accommodate the expected volume of registrations Development to prevent IP bans Detailed feature description: Member Login Sign-up Permission assignment Individual inquiry Immediate rank crawling Tracking target management Individual input Bulk Excel upload & download Keyword-based crawling On/Off Deletion Background crawling of tracking targets Naver Place keyword (1 daily query) Rank change history Generate a shareable URL (reset every week) Display in a popup from step 3...

I'm experiencing performance issues within my IoT-based platform, mostly coming from slow query response times, excessive storage consumption, and challenges with insert operations after compression. I'm looking for an experienced TimescaleDB expert to optimize this. - Optimize slow query response time - Reduce excessive storage consumption - Fix insert operations after compression The ideal freelancer for this project is someone who has extensive experience in TimescaleDB, particularly in query optimization and compression features. Unfortunately, I'm unable to provide the number of tables in the platform, but I need someone who is capable of handling extensive data and complex structures. If you've dealt with this before, you're the righ...

...integrate a Dymo printer into my system. Here's a breakdown of the project: - **Integration**: I need the Dymo printer to work seamlessly with my Access 2013 database. The goal is to automatically print stock labels based on query results. This means you'll need to set up the system to take the query output and send it to the printer for label creation. - **Printing Specifics**: The labels I need printed are stock labels. The process should be automated, so the labels are generated and printed without manual intervention. The labels will be printed based on the results of a query in Access and some limited entry from the operator with such things as qty of labels and which of 2 labels (it's the DYMO LabelWriter 450 Turbo) with slightly different fie...

Having an integral project already in place, I'm in need of a skilled SQL Developer to contribute towards its further development. Specifically, the tasks I require assistance with include: - Query Optimization: Tailoring and enhancing the performance of our current queries is a significant aspect of this role. - Database Maintenance: Maintaining the overall health and efficiency of our SQL Server is also a necessity. Ideal candidate must have a comprehensive understanding of SQL Server, as well as notable expertise in query optimization and database maintenance. I prefer someone with a proven track record of successfully managing and enhancing existing projects. I look forward to seeing your bids.

I'm in need of a LibreOffice Base specialist for form and report generation. Specifically, I require the creation of: - Input forms - Query forms - Output reports More specifically, I need a data entry form with a focus on a form view format. The successful candidate should demonstrate an excellent understanding of LibreOffice Base and form creation in various formats. Ideal Skills: - In-depth LibreOffice Base knowledge and experience - Expertise in form and report creation - Familiarity with form view format structures.

...including the ability to automatically hide and unhide tabs based on the selections made on the "Master Sheet. As well as pull in all needed information from the "Master Sheet" and any "Data Entry Sheet". Ideal Skills and Experience: Successful candidate should possess: - Deep understanding of advanced Excel formulas and functions. - Previous experience in designing visualization charts and custom query builders. - Strong analytical and data organizing skills. - Experience in converting independent Excel worksheets into a master file. - Knowledge in NDT industry would be beneficial but not paramount. The goal is to provide an automated and streamlined approach to handle inspection reports, making analysis and generation of summary statistics a bree...

Postgres data query system Docker across multiple servers

...taken as input to a program. NOTE: You can assume that the smallest possible rectangular patch has the shortest side of two pixels in length. Think well about the problem and once you are sure of a solution, design on the paper (this "design" needs be then described into the pseudo code part) and then implement a program ex1(input_file, output_file) which: - reads the file indicated by the parameter 'input_file' using the 'images' library - preprocesses the image--if needed--and implements a *recursive* function to solve the requirements below. - counts all the patches of lands that are in the image and returns the number of patches. It should return the number of rectangles with the color of the background that is present in...

We are seeking a talented full stack developer to create a mobile application for a medical start up. The application will serve as a platform for patients to perform home based outdoors exercise, receive general information about their condition and communicate wit...and compatible with various devices and platforms - Conduct thorough testing and debugging to ensure high-quality and bug-free code Requirements: - Proven experience as a full stack developer - Familiarity with mobile application development, particularly in the medical industry - Strong programming skills in JavaScript, HTML, CSS, and relevant frameworks - Proficiency in database management and query optimization - Knowledge of RESTful APIs and best practices for integration - Excellent problem-solving and communicat...

Need a backend developer to implement bel...client's existing code base. 1. Feign clients 2. Request and the response interceptors 3. For opt in, only mobile number to be passed as param to the feign client's method - ("919999784665"); 3. For sending sms, only mobile number and msg to be passed as param to the feign client's method - ("919999784665", "Hey there I am using whatsapp"); 4. All other query params to be inserted via request interceptor 5. userid and password to be picked from yml file, they will be different for different environments. 6. For both the APIs we'll have response interceptors which will check if the 'id' given in 'response' corresponds to one of the error codes. If they do, then we...

Hi Berty J. I hope you are fine. Remember the Skyscanner project you did? I need a cmd tool to get parcel tracking histories from where the last number is the parameter I need to call the tool and I expect a JSON on stdout with either the list of events (shipmentCourse entries) or anything they want to tell me like "expecting your shipment data soon." pls check and let's discuss availability and effort.

I'm in need of a LibreOffice Base specialist for form and report generation. Specifically, I require the creation of: - Input forms - Query forms - Output reports More specifically, I need a data entry form with a focus on a form view format. The successful candidate should demonstrate an excellent understanding of LibreOffice Base and form creation in various formats. Ideal Skills: - In-depth LibreOffice Base knowledge and experience - Expertise in form and report creation - Familiarity with form view format structures.

I'm looking for an expert with exceptional skills in Microsoft Access/Database, Excel, and VBA coding. The main focus of the project is on Access/Database, the specific tasks include: - Data Entry - Query Building - Database Design Ideally, I need someone who can efficiently handle a database containing 10-20 tables. You should be detail-oriented, experienced in managing medium-sized databases, and proficient in maximizing the functionality of Access. Excel expertise and VBA coding skills will also be highly valuable in this project. ONLY ACCEPT TASK IF YOU CAN DELIVER WITHIN 3 HOURS

There will be additional $50 for any who completes this project fully. The aim of this project is to compare three types of databases(Any relational database, mongoBD and Neo4J) in terms design approach, implementation, query composition, and performance. The data is about texas hold em poker game The stages of the project are 1. Look at the details of the data 2. Come up with an ER diagram and a relational schema for the data 3. Create a database in any relational db and tables 4. Create a python script to read the txt files and populate the db 5. Test the queries 6. Populate the other(mongodb and neo4j) databases and test the queries Then test the queries below on the databases QUERIES 1. Separate players by their style of play/Group players with a similar style of play togethe...

Need a Windows program that logs into an account, allows the user to enter a 2FA code in a browser window, enters queries into a search from an input XLS file, and on output saves the search status for that query.

...message, UID( IMAP EMAIL id), folder, date, client_id Attachment table: attachment_id, attachment_name, email_id, processed(DEFAULT 0), content( data type json) Requirements Create view to see for each client their email list and for each email the attachments Generate function to recover the tokens for each email account, it must return the token Create a schedule to retrieve emails (with sender parameter include '@','@') and attachments (save in the email and attachment table) Create a schedule that runs after the email schedule, and runs through the attached table, only the records that have not been processed processed: 0, and places in the content field: {'date1': 'RFC-C-FC-250037-2023-P' 'date2': 'Lima, 20 de febrero de...

Se inicia un proceso sin fin que consume todos los recursos del servidor. Adjunto captura de la información que me brindaron desde el servidor. Mi objetivo es que mi web deje de caerse por excesivo consumo de recursos. A continuación, copio la query que genera el problema (ver captura para más información): SELECT SQL_CALC_FOUND_ROWS from vsnucam_posts left join vsnucam_term_relationships on ( = Vsnucam_term_relationships.object_id) left join vsnucam_term_relationships as tt1 on ( = tt1.object_id) left join vsnucam_term_relationships as tt2 on ( = tt2.object_id) left join vsnucam_term_relationships as tt3 on ( = tt3.object_id) left join vsnucam_term_relationships as tt4 on ( = tt4.object_id) where

...automated as much as possible. - It should have the capability to save both sent and received - The add-in should be efficient, ensuring that no emails are missed in the process - A simple yet effective interface that is easy to navigate and use is crucial The add in will: - query a SQL database and find clients linked to the sender/recipient and prompt the user to select the relevant client - Save a copy of that email to the relevant folder for the selected client - again based on a SQL query. The SQL query information can be provided to facilitate this. Ideal Skills and Experience: - Proven experience in developing Outlook add-ins. - Knowledge of Microsoft Outlook's functionality. - Strong attention to detail to ensure proper email categorizati...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

script for auto replying mail with attached files

I'm looking for an expert in MS SQL databases to help me with a specific task. I’m using an MSSQL database and need to create a Param scalar. This is to store specific customer information in a structured manner. The ideal freelancer should be experienced with: - SQL, specifically MSSQL - Parameter creation within databases - Experience working with customer information In your proposal, please provide an example of a similar task you've completed in the past.

...is to develop a simple system that will help me manage following for my store, Inventory Sales Administration Inventory Inventory management and verification are the main reasons for developing this system. Each piece of inventory will be tagged with an asset barcode, so that I can track where each piece is and when it was sold at what price. Also need to be able to generate a barcode in a query and report. See Each week, inventory will be scanned, and a report generated to figure out variations between physical stock and what the system says. Inventory dashboard and reports like aging, velocity etc. Sales Should be able to create a customer from the sales order screen. Sales order will be created using customer

I am currently looking to engage an experienced Machine Learning professional for my project. I require analysis to be conducted on text data as well ...as well as numerical data. A strong understanding of Machine Learning concepts and analytical skills are vital. While I have not specified a particular focus area of Machine Learning, I am open to recommendations from the chosen freelancer based on the data provided. Key requirements include: - Proven track record in Machine Learning - Proven track record in Google Gemini and Google big Query ML - Proficient in data analysis and interpretation - Experience working with both text and numerical data Critical thinking and problem-solving skills with attention to detail will be necessary for the successful completion of thi...

MS1: Solana Data INPUT: Solana contract address OUTPUT: (These may change in time. We are looking for only the snapshot at the time of the inquiry). 1. List of wallet addresses that have a non-zero balance of the input contract token AND no buy transaction for that token, at the time of the query. 2. Percentage of the total supply that these wallets under item 1 above hold collectively (%) 3. Percentage of the total supply under AMM (%) (Only Raydium is fine). 4. Mint authority info. - Must have: Mint authority revoked? (Yes / No) - Optional but great to have: Mint authority status (Permanently revoked, time-limited etc). 5. Liquidity info. - Must have: Percentage of the liquidity locked (%) - Must have: Liquidity burned? (Yes/No) - Optional but great to have: Liquidity lock autho...

As it is a small task, I need it done by tomorrow, Sunday 11:00 UK time. We need a scraping command line tool for the following purpose: Scraping of to get the statuses of the packet. tool name: trackdhl parameter: the tracking ID Expected result: the detailed tracking history as JSON object containing - event date - event text from a list like this one: Sa, 30.03.2024, 11:45 The shipment has been successfully delivered Sa, 30.03.2024, 07:55 The shipment has been loaded onto the delivery vehicle Sa, 30.03.2024, 03:13 The shipment arrived in the region of recipient and will be transported to the delivery base in the next step. Th, 28.03.2024, 16:40 The shipment has been processed in the parcel center

...performance of our aggregation pipeline. The focus is on improving the response time and enhancing our capability to handle large volumes of data proficiently. The goal is to reduce response time to under 100 milliseconds without compromising data accuracy or integrity. WE WILL PROVIDE A PYTHON SCRIPT THAT CONTAINS MongoDB AGGREGATION PIPELINE Key Responsibilities: - Review and enhance the query performance - Optimize our large volume data handling - Analyze and understand the existing aggregation pipeline. - Identify potential bottlenecks and areas for optimization. - Implement efficient algorithms and techniques to enhance pipeline performance. - Ensure that the script returns data in less than 100 milliseconds. - Test and validate optimizations to ensure accuracy...

Data is not sending to API. Need to add new parameter to API

...functionality of the application. Key Responsibilities: - Identify the root cause of the pagination issue - Resolve the bug to ensure the pagination system functions correctly - Test the application thoroughly to verify that the issue has been fixed Ideal Skills and Experience: - Proficiency in PHP and Laravel framework - Prior experience with Laravel's built-in pagination - Strong knowledge of Query Builder - Ability to troubleshoot and debug complex issues - Excellent problem-solving and communication skills It's crucial that the freelancer I work with has a keen eye for detail and a track record of successfully resolving similar issues. The individual should also be comfortable with working in a fast-paced, deadline-driven environment. Here is a video that expla...

I need an SQL query to extract specific information from the Moodle database. The query should pull the name of the user, a list of activities they have completed, and the time they have spent on SCORM packages if they have interacted with any. Key requirements include: - Extracting user's name and completed activities. - Differentiating SCORM packages and calculating time spent on them. - Handling users with no completed activities by including them in the results with zero activity count. If you are familiar with PostgreSQL and Moodle database structure, and have experience writing efficient SQL queries, this project is for you. Your query should be optimized for general use, without specific version constraints. The ideal candidate for this task should under...

...Android platform. The application will be designed to perform the following basic functions, with a user-friendly interface: get tokens QR code creation Payment inquiry Cancellation and refund procedures These functions will be exposed via AIDL and can be triggered via App2App from another application. The application will manage Metropol Pay's payment processes, show the user the QR code and query the transaction details. When opened, Metropol Pay will receive a token with a 5-minute validity period from a Token API, then generate the QR code and display it on the POS screen. The screen will be designed to be user-friendly and informative, and the necessary feedback will be given to the user during the payment and return processes. In addition, a simple test application ...

Prosimo, vpišite se ali se prijavite za več podrobnosti.

...the page should not lock up permanently or be flagged permanently with frequent use or fast refreshing of the page. INPUT: Solana contract address OUTPUT: (These may change in time. We are looking for only the snapshot at the time of the inquiry). 1. List of wallet addresses that have a non-zero balance of the input contract token AND no buy transaction for that token, at the time of the query. (This check intends to find out wallets with pre-mined tokens). Please have this list collapsed to item 2 below when the page first launches). 2. Percentage of the total supply that these wallets under item 1 above hold collectively (%) 3. Percentage of the total supply under AMM (%) (Only Raydium is fine). 4. Mint authority info. - Must have: Mint authority revoked? (Yes / No...

I am experiencing issues...database after moving the database file. After reconnecting the queries to the database, all but one tab of file updated okay. One tab is returning errors. The database is accessed through a desktop application. Key Requirements: - Resolve query errors in the database - Ensure the database functions properly within the desktop application - Investigate and fix any potential issues caused by moving the root file The ideal freelancer for this project should have: - Strong expertise in Microsoft Access - Proficiency in database management and query optimization - Experience in troubleshooting database errors - Ability to work with desktop applications Please include in your bid any relevant experience and your approach to troubleshooting and reso...

I'm seeking a proficient AI expert with the unique skill set in Generative AI and MongoDB. My goal is to automate the query generation process in my mongodb database radiating from chat inputs. WHAT TO DO: * Develop a Generative AI that will use chat inputs to automatically generate complex queries. * While we may have a gamut of queries, for now, we need all-encompassing technology that'll serve a broader purpose. I'm operating on a tight deadline, I need this project completed ASAP. If you're versed in AI and comfortable working with MongoDB, let's get in touch. I'm open to discussing any questions you might have about the project.

I am in need of a skilled developer who can create a real-time monitoring dashboard using MySQL. The dashboard will primarily be used for real-time monitoring. Key requirements: - Strong experience with MySQL: You should be proficient with MySQL and able to efficiently manage and query a large amount of data. - Dashboard development: You should have prior experience developing real-time monitoring dashboards. - Custom Date Range Report Generation: The dashboard should include the ability to generate custom date range reports. - Data visualization and real-time monitoring: Although the primary purpose of the dashboard is real-time monitoring, a good understanding of data visualization would be beneficial too. If you have prior experience with similar projects and are confident in y...

...visualization techniques Ideal candidates for this role should have: - Experience with MS Fabric, specifically working with Lakehouses, Warehouse, SQL Endpoint, Data Flows, and Notebook - Proficiency with SQL Server, VBA, and SAS - Previous work with AI/ML algorithms - Exceptional knowledge of AWS services, including S3, Athena, and Glue - Familiarity with GCP storage and Big Query - Competence in using Power Query for data manipulation and transformation Your skills and experiences will play a crucial role in ensuring the successful delivery of this project, so please be sure to highlight your previous work history in similar projects and please send me you CVs and also please clearly state your price expectation and duration of work and also mention your availability f...

...08:23:06 request Uncaught PHP Exception ValueError: "Path cannot be empty" at /home/usdtftrans/public_html/modules/tm_imageslider/ line 448 { "exception": {} } INFO 08:23:06 php User Deprecated: Not specifying the optional ShopConstraint parameter is deprecated since version 1.7.8.0 { "exception": {} } INFO 08:23:06 php User Deprecated: Not specifying the optional ShopConstraint parameter is deprecated since version 1.7.8.0 { "exception": {} } INFO 08:23:06 php User Deprecated: Not specifying the optional ShopConstraint parameter is deprecated since version 1.7.8.0 { "exception": {} } DEBUG 08:23:06 doctrine SELECT e.id_employee FROM pslx_employee e WHERE ( = :email) AND ( = :active) LIMIT 1 { "email": &quo...

...system to scrape data from the App Store. The system must collect information about apps based on specified search criteria, such as categories and keywords. References: 2. Main Functional Requirements 2.1 Scraping Features Category or Keyword Selection: Users should be able to choose a category or enter keywords to search for apps. Concurrent Query Execution: The system must support the simultaneous execution of multiple queries. Data Storage: Data on scraped apps must be stored for further access and analysis. 2.2 Data Management Viewing Scraped Data: Users can view a list of apps and detailed information about each app. Data Export: Capability to export data into a CSV file, including: App name App link Release date and last update Support

I need a refined and comprehensive database of the customers who submit a query on Car Dekho. My primary purpose is to conduct market research and analysis. Requirements: - The details I need are their full name and contact number. Please omit any other personal or private details. - This data should be provided in a CSV file format, which will be easy to import for various kinds of analysis. Ideal Candidate: - Expertise in data mining and extraction - Proven track record in collecting accurate, high-quality data - Familiarity with the automotive industry is a plus - Strict adherence to data privacy laws - Extensive experience with CSV files and data formatting.

I am struggling with a range of issues in my SQL database that are affecting my business operations. The primary challe...size of my database is substantial, significantly above 10GB, implying the need for a professional who can manage and improve large-capacity systems. The target areas for amelioration in the SQL database include: - Efficiency of the queries. - Table partitioning strategy. The ideal candidate should evidence expert skills and a successful track record in managing large SQL databases, improving query efficiency, and implementing effective table partitioning strategies. In-depth knowledge of comprehensive database performance tuning and optimization techniques, coupled with the ability to solve complex technical challenges like timeouts and deadlocks, is highly ...

I'm running a MySQL database and looking for an expert to help me optimize the query performance. Key responsibilities: - Analyzing the current database structure and configurations to identify areas that need optimization. - Implementing efficient indexing strategies and query tuning to enhance the query performance. - Providing insights and recommendations on how to maintain and keep the optimized database running smoothly. Ideal skills and experience: - Proven experience in MySQL database management and optimization. - Strong understanding of database performance metrics and monitoring tools. - Familiarity with indexing strategies and query tuning techniques. - Excellent problem-solving and analytical thinking capabilities. This role requires a profe...

Hi, We are looking for a developer to do the following tasks: 1. Index resumes in pinecone using langchain 2. Convert query from user into structured response in langchain. 3. Get responses from langchain and pinecone 4. Tank the resumes based on score 5. Test postman APIs for each of the above tasks. There will be two queries - one to fetch the relevant CVs and the other to rank a group of CVs. Ideally the score will be to use both one after the other and get ranked and relevant CVs. This can be written in Nodejs or python; we are okay with either. I will provide sample datasets and test with you. We are on a low budget for this - max - 1500-5000 inr. we want to work with individuals who are keen to learn and do this for the learning and not much for commercial gain. This woul...

I'm seeking an experienced WordPress developer with a specialty in MySQL databases to help me with optimizing query speeds. This personal project requires proficiency in both SQL database handling and WordPress development. Key responsibilities: - Analyzing my WordPress site's interaction with the MySQL database. - Tweaking and fine-tuning to enhance query speeds. - Testing and confirming the increase in performance. Skills and Experience: - Detailed knowledge of MySQL databases. - Extensive experience with WordPress development and optimization. - Proficiency in writing efficient SQL queries. - Ability to diagnose and optimize databases for better speed performance. This project offers the opportunity to showcase your skills in SQL optimization, while significan...

I need a proficient Apache Airflow and SQL consultant to provide expert-level support, specifically focused on complex query formation. - Specific Project Tasks - Implementing Apache Airflow - Creating complex SQL queries - Handling financial transaction data The ideal collaborator should have: - Proven experience working with Apache Airflow - Proficient in SQL, with an emphasis on generating complex queries - Prior experience managing financial transaction data is highly desirable. The objective is to streamline the handling, management, and processing of large volumes of financial transaction data, ensuring efficient and accurate results.