Sql return hierarchical tree jobs
I'm looking for help with a professional writing for a business loan application forms to fill in and send back to me. Key requirements: -fill in the question and write a user-friendly loan application form for high success rate. - there are 2 forms to fill in 1- Business plan template 2- cash flow template, they are in Microsoft excell file, once filled in just save and return to me so it is ready for the application upload. Ideal freelancer will have: - Proven experience in English literature - Strong understanding of business planning and growth. The application form is an essential part of the loan application process, with few questions which asks how the business growth and planning , once is written I can review for the final outcome. ,If you have the right s...
1 Need to build a website monitoring program to monitor changes in sub-pages of the landing page Detailed requirements: The website needs to have SQL function because batch site monitoring needs to be uploaded. 2 Identify the link to the final sub-page login keyword such as Proxy function and mobile phone UA because mobile phone batch UA is required Multi-thread monitoring 3 Filter duplicates and monitor changes in subpages of the website Set a custom time to refresh the web page 4 Send the new URL of the subpage change to the created group through the telegram machine
I am seeking a skilled mobile app developer to create an Android app focused on stock management. Key Features: - The primary function of this app is inventory tracking. It should allow users to monitor stock levels, product movement, and manage inventory with ease. Work - Create Retailer Account Create Stock Payment received Return to Origin Add User Manage Permissions Manage Retailer Requirements: - Proficiency in Android app development - Prior experience with stock management applications - Familiarity with inventory tracking systems A successful project will require a developer who can create an intuitive user experience and implement a robust inventory tracking system.
I urgently require a proficient SQL Server expert, particularly conversant with SQL Server 2012. My primary challenge is recovering deleted records. Ideal Skills: - Comprehensive understanding of SQL Server 2012 - Expertise in data recovery processes Experience Required: - Proven track record in database recovery - Past work with SQL Server 2012 Your immediate availability for this project is essential. Please, only serious and experienced candidates should bid.
I am looking for a skilled designer to create a poster and matching return card for a dinner. Wording is attached. The poster size should be 8 1/2 x 5 1/2 and the attached card should be 5 1/2 x 4 1/4. Also attached are some of our previous designs which you can use for inspiration. Please create a new look for this year. Ideal skills and experience for this job include: - Proficiency in graphic design software - Experience in creating posters for formal events - Ability to work with custom sizes and formats - Strong attention to detail and an eye for design aesthetics If you think you have the skills and experience needed to create a stunning poster for my event, please submit your proposal. I look forward to seeing what you can come up with!
I am in need of a skilled developer to assist with an existing API integration between SilverStripe website and REX Software, with a focus on correcting a data issue that is causing the server to fail with backing up the website due to disk usage. The server technician said: "The disk usage is at 80% so a dump would fail as it would need more space to create a sql file to be transferred. It looks to be an issue with REX and the website framework SilverStripe. It may be that REX is not configured to remove (dump) old data." Your role will involve correct the error so the server does not continue to reach its disk usage and implementing a seamless API integration that successfully synchronizes and updates property listings between these two platforms. Ideal Skills: &bull...
-The Excel workbook should comprise multiple worksheets showing the models, the regression analysis summary, the comparison of model performance, the decision tree, and the calculations you used to answer the task questions that require you to complete in Excel USING SOLVER. -report should be mainly for the economic order quantity (EOQ) analysis and the answers to the qualitative questions. No introduction -1900 word report -There should be at least FOUR worksheets in the Excel workbook. Two of them should show the following two demand forecasting methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne. 1. Moving average 2. Static method. for the other two: summary of the regression analysis for the static method. The o...
I'm running a Node.js website where the last user's data is mi...promptly. Key Responsibilities: - Investigate the current data display functionality and how it's handling user data. - Correct the code responsible for showing the last user's data to the first user. - Ensure that the correct user data is displayed to each respective user post-login. Ideal Freelancer: - Proficient in Node.js with a deep understanding of data management and display. - Experienced in SQL databases, specifically in managing user data. - Previous experience in debugging and resolving similar issues is a plus. - Deadline-oriented and able to work efficiently to resolve this issue. Please refer to the attached video for better understanding of the issue. Your prompt attention to this ...
... Essential Skills and Qualifications: - Expertise in using Visual Studio for software development, including .NET and PHP programming. - Proficiency in Azure DevOps for project lifecycle management, including CI/CD pipelines and agile project management. - Experience with Microsoft Azure, especially Azure Service Bus and Azure Functions. - Strong knowledge of database management with MySQL and SQL. - Ability in RESTful API development and OAuth security practices. - Excellent problem-solving skills and ability to work effectively in a team environment. Education and Experience: - Bachelor’s or Master’s degree in Computer Science, Software Engineering, or related field. - At least 7 years of full-stack development experience, with a focus on complex cloud-based solut...
I'm looking for an expert who can put together a precise and comprehensive multifamily proforma that focuses on cash flow details. Specifics Required: - Include data on net operating income, debt service, and cash on cash return. - An in-depth monthly breakdown of these values. Skills & Experience: - Proven track record in financial analysis, specifically real estate and multifamily property market. - Professional approach with strong attention to detail. - High-level proficiency in using proforma software or Excel. - Understanding of the specifics of rental property cash flows.
The WhatsAp... the bot greets them and requests input of a code or menu name (there are 200 codes or menu names available). 2. If the input is incorrect, the bot asks the sender to resend the correct code, send an image containing all the codes, or return to the main menu. 3. If the code is entered correctly, the bot displays general information in text form taken from a Google Sheet. Along with this information, a menu is displayed: • PDF file extracted from Google Drive or a folder • Image • Information in text form taken from a Google Sheet • Input another code • Return to the main menu For subscribers: 1. Information from PDF files or images is sourced from a different folder. Alternatively, information in text form is more common. open source e...
I need a small application prototype with the following features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ...features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ie. admin app and applicant app. job application requirements will be provided. Nodejs, angular, My SQL, ORM, Data Seeding, Migrations shoul...
We are seeking a skilled freelance writer to create comprehensive documentation and set up demo data for our company's Customer Relationship Management (CRM) processes. The primary responsibility will be to research and document our existing CRM workflows, procedures, and best practices, as well as create sample data for d...proposal with the following: Your rate or fixed-price quote for the project (Budget: Max Rs. 1000 INR only) A writing sample demonstrating your ability to create clear and concise documentation Your availability to start and estimated timeline for completion We will provide demo login credentials for the GrowCRM system. Although the budget is strict at Max Rs. 1000 INR, we can offer good reviews in return for quality work. We look forward to reviewing yo...
I have a SQL Server that needs to be accessible over the internet. However, I'm facing connectivity issues, possibly due to closed or blocked ports on my ComCast router model CBR2-T. I need a freelancer to open the necessary ports on the router. The task involves: - Checking the current port status on the router - Identifying the SQL Server port - Opening the port on the router Please bid if you're experienced with network configuration and have dealt with ComCast routers before. Necessary Skills: - Network Configuration - Router Administration - ComCast Router Experience - SQL Server Configuration
I require someone experienced in Linux server management to help optimize the performance of my server. Linux Server Performance Optimization Plesk Obsidian, SQL, PHP Key Responsibilities: - Review the current server setup and performance - Identify areas for improvement - Implement solutions to optimize server performance - Fix the 2 errors. This is not a one-time setup; I may require ongoing management based on the initial optimization results. Your expertise in Linux server management is crucial to this project.
I'm in need of a professional web developer to create a platform that serves as an agent management website. The website should have an elegant interface, account logins, and a simple credit system that can be administered by an admin account. Key Features: - Agent Registration and Login: The website should allow agents to create accounts and log in securely. - Profile Manag...agent registration and login feature is not fully defined yet. The ideal candidate for this project should have experience in building similar systems, understand user account management, and have the ability to design an aesthetically pleasing interface. Requirements can be asked if you are interested, you can build with any framework, preferably javascript based frameworks. Minimal SQL is required, a...
I need a C function capable of interfacing with the Windows location services and Linux's geoclue2 to acquire the current location (l...The function should aim to provide location data with the highest possible accuracy, utilizing GPS, Wi-Fi positioning services, and GEO IP location services. - In cases where the location data retrieval fails, the function should be designed to return an error code. The ideal candidate for this job should possess: - Proficiency in C language. - Familiarity with Windows location services and Linux's geoclue2. - Experience in working with GPS, Wi-Fi positioning, and GEO IP location services. - Capability to handle error cases efficiently with return error codes. - Previous experience in the development of cross-platform functionality...
In my project, I'm looking to set up ActiveMQ JMS messaging for our system, focusing on synchronous and asynchronous messaging. We anticipate a low scale of message traffic, not exceeding 1,000 messages per day. Key responsibilities will include: - Set...framework to publish and subscribe messages to ActiveMQ queues Create queries to make sure data is published into the respective tables and assertions to validate Ideal skills and experiences for this role would include: - Proficient in ActiveMQ and JMS messaging - Previous experience in setting up asynchronous messaging systems - Familiar with SOAPUI and its capabilities for message testing - SQL developer for database queries and validations Please bid on this project if you're confident in your ability to deliver on...
Looking for help in modifying an existing python script and related sql database table The current script - (1) scrapes company financial data from website and populates database (2) scrapes news related to keywords from google news (3)sentiment classification of news items (4)pushes data to sql database The company names and keywords are currently hardcoded in the script Requirement- (1) Company names/urls/keywords (will be provided) to be put in master table in the database (2) The script to loop through and scrape the relevant data and put in database
I'm looking for a freelancer who's great at web scraping to help with a project involving a specific website initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide source code, documentation and deployment info...
Required a dot net developer. Speacialized in Microservices acrhitecture based solution. Dotnet Core, C#, SQL, Data transformation, API gateway, Auth based security.
i have Pojo class where it is picking property value from api response as integer in the Pojo Class: @JsonProperty("intensity") private Integer intensity; public Integer getColor() { return color; } public void setColor(Integer color) { = color; } and in parser class (INTENSITY, ((), 0)); The problem is sometimes the Api giving the color value as string not as interger but only on on checkbox config we add and this already defined in java if(checkVariant is true) then consider it string and parse it what i have to do to fix my code based on that condition so i can parse the string value this way: updateProperties("color", ((), ));
I am seeking a full stack PHP developer to assist me with my project. I'm l...you are a skilled PHP developer with experience in full stack development and are passionate about producing high-quality applications, this project is for you. Your ability to work both independently and collaboratively will be key to our success. Ideal skills and experiences include: - Proficient in PHP and related frameworks - Strong knowledge of HTML, CSS, and JavaScript - Familiarity with SQL and database management - Experience in user authentication and payment processing - Understanding of project management and problem-solving - Excellent communication and time management skills I am looking to commence this project at the earliest convenience, so please get in touch if you're avail...
I'm in need of an experienced Shopify designer to create a robust e-commerce portal for my business. The website's primary purpose will be to facilitate online sales for various types of gadgets. Key responsibilities include: - Design an intuitive, user-friendly Shopify store. - Input and organise 50-100 product listings. - Optimisation for conversions. The ideal candidate will have: ...intuitive, user-friendly Shopify store. - Input and organise 50-100 product listings. - Optimisation for conversions. The ideal candidate will have: - Solid experience in Shopify store design and setup. - A good understanding of e-commerce best practices. - Familiarity with gadgets and similar niche products. The end result should be a seamless shopping experience that encourages sales and...
...Boost Product Customer Satisfaction: You'll be tasked with finding ways to ensure our customer's satisfaction with our products, as this is key to our growth strategy. Business to customer Skills and Experience: - Proven track record in market expansion strategies, ideally in the radio industry. - Proficient in measures of customer satisfaction including interpreting online reviews, ratings, return or refund rates. - Ability to work with teams and adapt to changing market dynamics. - Strong communication and reporting skills to provide regular updates on progress. HONEPE India ( P ) Ltd ?️ Urgent openings!!?️ Job Nature ▪️ New QR Onboarding ▪️Soundbox machine Sales ▪️...
...with "Login" button in the middle of the screen (copy/paste login functions from example code) 07. add new screen with "SCAN" button in the middle of the screen (copy/paste login functions from example code) 08. When logon is successfull 09. Show "SCAN" screen 10. when click "SCAN" button, start BLE scan for 4 sec (copy/paste login functions from example code) 11. parse SCAN BLE List and return success/true with the first BLE device that has RSSI >= -50 12 if no BLE devices are meet, go back to "SCAN" screen and wait for click 13. else 14. present/enable faceid auth 15. if not success go back to "SCAN" screen and wait for click 16. else 17. enable haptic ...
...project is to handle data extraction from websites, dealing particularly with nested or hierarchical data. Key Responsibilities: - Collaborating with the team to define the scope of the project and identify the data requirements. - Design and implement data extraction scripts using the Scrapy framework. - Handle complex, nested or hierarchical data structures. - Ensure the accuracy and efficiency of the data extraction process. Ideal Skills and Experience: - Proven experience in Python development. - Expertise in working with the Scrapy framework. - Strong understanding of web technologies and data structures. - Excellent problem-solving and analytical skills. - Experience with handling nested or hierarchical data structures. - Previous experience in data extracti...
I have a Uniswap Swap Widget integrated on my web platform built using React. The widget is currently facing connectivity problems that need to be addressed. Uniswap Swap Widget It use Metamask and Wallet Connect , I want change it Rainbowkit connector It need to complete in few hrs Ideal Skills and Experience: - Proficiency with React and Uniswap - Experience in fixing connectivity issues in web platforms - Understanding of how to integrate and troubleshoot widgets The task mainly involves identifying the root cause of the connectivity issue, and implementing a reliable fix that ensures the widget functions correctly. Experience with similar projects or Uniswap integration will be a
...hence our AI works on it through big data and automation. The project is about algorithmic auto-investing trading on world wide's financial market. Fixed Rate Job Paid based on success delivery per country. $10/country. Make about 5-10 API/country for installing python, setting SQL for our applications and Google Sheet. For each country may need API for such as : 1. Historical Data 2. Financial Scrapped Source 3. Financial Summary Scrapped Source 4. Interest rate 5. Some More Required Skill & Experience : 1. Php & SQL 2. Familiar with python installing & setting up environments 3. Experienced in Linux Debian & LNMP server by SSH 4. You need to know on how to run python scripts on debian by ssh, and setup cron task on debian, and debugging etc Perso...
I am looking for a programmer with previous experience in building a Group Buy SEO Panel with the following tools, with the possibility of adding tools later. semrush freepik envato elements Motion Array pacdora with the following download limits: freepik 25 files /day envato elements 30/day Motion Array 30 /day pacdora 30/day I do not want a page specifically for payments, but in return I want a section at admin dashboard to generate activation keys for each service. I will sell these keys, and once the customer obtains an activation key for a service, he will paste it in a specific place on user dashboard and click on the word Activate, and the service associated with this key will be activated. Please send a previous project you work on
Quiero pasar estas dos funciones de C++ a C template<class T> int EEPROM_put(int ee, const T& value) { const byte* p = (const byte*)(const void*)&value; unsigned int i; for (i = 0; i < sizeof(value); i++) foo(ee++, *p++); return i; } template<class T> int EEPROM_get(int ee, T& value) { byte* p = (byte*)(void*)&value; unsigned int i; for (i = 0; i < sizeof(value); i++) *p++ = foo(ee++); return i; }
Hi Ishaq A., My Printer says that The logo file in one of the rewind bag artwork files for Mulberry Tree brand is too small. Can you please fix the logo and change to the two coloured versions used in the artwork
...API Integration: Get access to the OpenAI GPT-3 API. Write a script that takes inputs from Dialogflow via the webhook, processes it with GPT-3, and returns the output to Dialogflow. Integration and Fulfillment: Configure Dialogflow to use the webhook for fulfillment. Ensure the webhook communicates with the GPT-3 API and formats the response correctly. Return the formatted response to Dialogflow for Google Assistant to process. Example Workflow: User Command: "Write a poem about a sunset." Google Assistant: Recognizes the command and passes it to Dialogflow. Dialogflow Intent: Matches the intent for writing a poem. Webhook: Sends the request to your webhook. GPT-3 API Call: The webhook calls the GPT-3 AP...
...---------------------------------------------------------------------------------------------------- I need to remove the Service Number Taxonomy that was added and create a new one called Booking Category. This will need look up the `11_bkntc_services` table in the database. (I use the Booknetic Plugin for Game Bookings) The table looks like this image, so you will have to use case insensitive SQL to find the `11_bkntc_services` WHERE name is PARTIALLY equal to the "Projects name" (2nd Image) as I have multiple actual games per "Project" The WP page in question is Https:// The "Book Now" button uses the code in the image below found in this file: wp-content/themes/gamico/template-parts/project/ to show the Booknetic category based on the game.
...Implementation: - Set up a CI/CD pipeline using GitHub Actions for automated testing, building, and deployment of both frontend and backend applications. - Integrate the pipeline with our GCP infrastructure, including Compute Engine, Cloud SQL, and Cloud Storage. 2. Logging Setup: - Configure logging for all services: -- Frontend (Nginx, ): Log HTTP requests, errors, and application logs. -- Backend (Gunicorn, Django): Log application errors, access logs, and system logs. -- Celery and Beat: Log task execution and periodic tasks. -- Database (Cloud SQL): Log database queries and errors. -- Redis (Cloud Memorystore): Log Redis operations. - Collect and store logs centrally using GCP's Stackdriver Logging. - Set up log rotation and retention policies. 3. HTTPS Domain...
I'm in need of a talented illustrator who can create a hand-drawn family tree in a minimal style. The end product should be a beautiful, simple illustration that stands out for its elegant, uncluttered design. Key Details: - Style: Minimal - Size: Medium (up to 18x24 inches) - Content: The tree should be detailed enough to cover 7 generations, but without the names of the family members. I'll be filling in the names myself post-completion. - I need in PDF/illustrator format. Ideal Skills and Experience: - Proficient in hand illustration, with a portfolio that showcases a minimalistic style. - Experience in creating intricate, multi-generational family trees or similar illustrations. - Ability to communicate and work collaboratively to ensure the final product meet...
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you provide code to simulate input data (both code versions: python and sql)-> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. When 34 for 20%; 65 for 30%; 12 for 40%; 78 for 10%; 5 for 15%; 23 for 70%; 41 for 30% randoml...
We are looking for 5-10 years of .Net experienced developer who can also have experienced in React and .Net based web development. Long terms multiple projects development. Using Mainly Azure SQL server database with Visual Studio .Net Core API. Graph QL and EF. Worked on Azure Key Vault, Azure Logic app, Azure function is bonus.
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days *****you provide code to simulate input data -> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states randomly 30 to 170 transactions per day for given product for usual price randomly 200 to 600 transactions per day for given product for promotion random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78,...
...ready, and the SQL tables have been set up. The main features of this project include: - **Dashboard:** This should display data from the other 3 pages in a list format as well as in a bar chart. - **Page 1 - Callback List:** A simple list of data from the 'callback' table. - **Page 2 - Token List:** A simple list of data from the 'token' table. - **Page 3 - Name List:** A simple list of data from the 'name' table. For the dashboard, I'm looking for a clean, professional design and prefer the use of bar charts for the graphical representation of the data. User authentication should be straightforward, requiring only an email and password for access. Ideal Skills and Experience: - Proficient in Laravel - Experience in creating admin dash...
We have a project developed with VS2022, c#, datatables, SQL database, javascript and similar.... The user experience is not good. We need a professional and nice interface and user experience, but, mantain our actual code and funcionality.
Hi, I am looking for a developer to maintain, make upgrades and fix bugs on my current website and booking system. The system has been done in SQL written in C# by my old developer. He has had a change of career and can no longer work on things but is happy to do a handover to make things easier. This will be an ongoing business relationship and not a one off thing so will need someone with good communication and accurate times of completion. Thanks, Luke.
...CodeIgniter 4, ensuring all features and functionalities remain intact. Optimize SQL Queries: Review and optimize all SQL queries to handle heavy loads efficiently. The current system experiences performance issues during peak times, and the new version should resolve these. Fix Bugs and Security Issues: Identify and fix any existing bugs and security vulnerabilities in the current project. Ensure the new version adheres to the latest security standards. API Integration: Connect the backend with the frontend using APIs. The APIs should be well-documented, secure, and efficient, allowing seamless communication between the backend and frontend. Requirements: Proven experience with CodeIgniter 3 and 4. Strong knowledge of SQL query optimization. Expertise in ident...
I'm in need of an intricate financial model designed for a residential property that focuses on calculating equity investments. Specifically, I want: - Informative analytics on 'Return on Equity', to evaluate potential profits over time. - An illustration of 'Cash Flow Distribution', to comprehend the income dispersions. - Analysis on 'Equity Multiple', to understand the total cash received against the total equity invested. Ideal freelancers will have a strong background in financial modelling, specifically pertaining to property investments. Understanding of debt financing, equity investments and capability in generating these specific outputs is critical.
...comprehensive analysis of potential investments and to help me make informed decisions. Key Areas: - Evaluating Investment Opportunities: I need someone who can create robust and reliable financial models to assess the viability of various real estate ventures. Your models should help me identify and prioritize the most promising investments. - Financial Metrics: Your models should primarily focus on Return on Investment (ROI), Net Present Value (NPV), and Capitalization Rate (Cap Rate). These are the key metrics I need to see to make sound investment decisions. Ideal Candidate: - Proven Experience: Previous experience in real estate financial modelling and investment analysis is a must. A background in real estate or finance would be highly beneficial. - Analytical Skills: ...
Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
