Sql views variable number columns jobs
...or activity, such as show everything that happened on the 14/5/2024 or show all instances of Opened Chrome. They should also be able to change their email address and password. We do not need the ability to block or limit anything, just to report. In the admin panel it should show the following: List of users accounts with ability ti view accounts - Reset user's password, etc Number of devices installed Total Number of devices each user has it installed on The app needs to have the following configured: AdMobs Google Analytics/Firebase Analytics Firebase Crashalytics OneSignal. We may look to charge a subscription fee in the future but at the moment it will be free with ads. Ads show on app open and after a period of time being used when logged into the app. Ide...
3D modeling and rendering of a vintage caravan to present it as a mobile bar. Deliverables: Rendering with various views in JPG and MP4.
I am looking for a freelancer who can help me with Web Scraping. We have a list of websites that we would like to scrape specific data from, and have them put into a set of MySQL Databases (or maybe something else). The website that we would like to scrape data from each contain thousands of articles, and we would also want other metadata, such as Author name, article date, number of views, or any other metadata that we can take from the pages. Please bid, and we can discuss the first website, you can tell us how long you think it'll take to write the scraper. There are maybe 50 websites to begin with that we would like to do this for, in this one project, and we also have another couple of similar projects. Ideally, the scraper will run form a program, so that we can...
We are the largest and fastest growing UK charity community delivering support through multiple services via our website. Our website and AI machine learning and GPT are handled by others. We need dev support for the core SQL system and 2 small SQL directories, plus running reports and system admin. We need full stack Microsoft .NET development experience, strong SQL knowledge and exposure to Azure Microsoft services. We require a range of services. We’ll begin with the ad hoc work to begin to build a working relationship and then build that up to the following on an ongoing basis. • Ad hoc tasks for minor tweaks and changes on an ongoing basis. • Larger pieces of work, such as creating a moving from a free to a free and premium versions, with up...
We are seeking a Business Data Analyst for our team who is willing to work with new ...Responsibilities: - Collect and analyze data from various sources - Identify patterns, trends, and correlations in datasets - Create reports and dashboards to present findings - Collaborate with cross-functional teams to understand business requirements Required skills: - Strong analytical and problem-solving skills - Proficiency in data analysis tools such as Excel, SQL, or Python - Experience with data visualization tools such as Tableau or Power BI - Excellent communication and presentation skills This is a great opportunity for individuals who are new to the field of business data analysis and are looking to gain practical experience in a supportive en...
Velocity alert analysis and provide actionable insights. Key requirements include: - Proficient in analyzing velocity alerts using SQL or SPL or Python - Capable of translating data from a word file into actionable insights - Experienced in the field of identity analytics, risk engine, authentication channel for the digital banking platforms - Understanding of Account Takeover (ATO) or digital identity compromise - Leverage known data as it relates to the digital customer identity and risk decisioning. - Analyze data logs from customer authentication channels and digital banking applications for malicious use and bad actors. - Create long-term solutions and automation to processes that can be improved when digital member identity is being utilized. Refer to attached document for b...
I need assistance with a data entry project. I have a number of records that need to be accurately typed into an Excel sheet. - The data to be entered is fairly straightforward and doesn't include complex formulas or calculations. - You won't be required to do any data analysis or validation. - Unfortunately, I don't have the exact number of columns or rows, but it's a moderate amount. The ideal freelancer for this project will have: - Proficiency in Excel and data entry - Attention to detail and accuracy - A commitment to meeting deadlines Your main task will be to ensure that all the details are accurately recorded in the Excel sheet.
...sources including databases, APIs, and files - Proficiency in data transformation, aggregation, and cleaning -Bachelor's degree in Computer Science, Engineering, or related field. -2+ years of experience as a Data Engineer or similar role. -Hands-on experience with PySpark, Scala, and Azure Databricks is required. -Experience with data modeling, ETL development, and data warehousing concepts. -Strong SQL skills and proficiency in data manipulation and analysis. -Experience with cloud platforms (Azure preferred) and big data technologies. -Optionally, experience with SSIS and SSAS is a plus. -Proven experience with POWER BI, Tableau, HADOOP, MongoDB etc. -Excellent problem-solving and communication skills Be ready to understand the specifics of the project once selected and ...
I need a professional to gather 750 contacts from three different Houzz pages. Requirements: - The information required for each contact is Name, Email, Phone number, and business name. - The contacts should be organized by location. - There is a need for the contacts to be from the following specific Houzz pages: Kitchen Designers and Renovators, Bathroom Designers and Renovators, Design and Construction. Preferably, the contacts should be from a specific location which I will provide. The ideal freelancer for this task should have experience in web scraping and data collection. Accuracy and attention to details are also key for this project.
I'm looking virtual assistant for collect email address and phone number. I will give company name just you search and collect email and phone number. New freelancer welcome. Thanks
I am looking for a skilled data entry specialist with advanced proficiency in excel. The project at hand is a one-time copy typing task. The task involves: - Entering a variety of data types into an excel spreadsheet (Text, Numbers, and Dates). - Creating a custom excel template with less than 10 columns. Ideal skills and experience for the job include: - Proficiency in using Excel, especially in data entry tasks. - Strong attention to detail to ensure all data is accurately entered. - Experience in creating custom excel templates is an added advantage. Please note, I will provide the document that needs to be copied and expect the resulting spreadsheet to match the information exactly.
In my quest for an impeccable residential building design, I am seeking the expertise of a well-versed structural engineer to conduct a comprehensive review. To provide a bit of context: - The design is in its detailed stage and ready for a granular assessment. - I want a thorough examination of the entirety - from foundation to roof. This includes but is not limited to footing, columns, walls, beams and slabs. A successful bidder will ideally possess the following skills and experience: - Significant experience in residential project and structural design. - Attention to detail for detecting potential weak spots or errors. - Knowledge in the latest safety standards and building codes. - Ability to provide creative, practical, and cost-effective solutions for detected issues. I...
...in-progress database or commence anew based on existing requirements. This database is intended for exclusive use within our family bakery, facilitating efficient management of formula costing involving ingredients, labor, and overheads. The final product should encompass: - Seamless migration of current data - Storage for formulas and preparation instructions - Pricing calculator adaptable to variable inputs (ingredient costs, labor) - User-friendly interface tailored for non-technical users Additionally, please note: - The database developed will serve solely my bakery's operational needs. - Ownership of the completed software will remain with me. - While there's potential interest from other bakeries, extending or distributing the software beyond our use...
I'm going to build auth login page using the react , tailwind css, express Mysql DB. Also we have to join with google acc , facebook acc, apple acc.
...is in the file MTQ - Upwork - Interactive Front Panel - and the other attachments are supporting documents). SUMMARY: Tabbed ReactJS forms with a Python backend that can interact with each other. The front-end can have a few input fields and a few interactive subcomponents in the form of either tables or images (with possibly overlaid hand-picked polygons), organized in a few columns. The layout can be customized (in the spirit of React-Json-Schema Form). The change in any Frontend component will be handled by a Python backend and the Python backend, in turns, can generate new data to update the interactive subcomponents of the front end. Key responsibilities and requirements include: - Proficiency in ReactJS and CSS for the front-end development part of the project. - Experi...
...planes in Revit. The purpose of the 3D model and planes is to support architectural design. I need the 3D model to be at a basic level of detail, focusing on shapes and structures. You will also need to create various views and sections for the planes, including elevation views, floor plans, and cross-sections, as well as plumbing and electrical layouts. Ideal skills and experience for this job include: - Strong proficiency in Revit and 3D modeling - Experience in architectural design - Ability to create basic shapes and structures - Proficiency in creating various views and sections for architectural plans - Understanding of plumbing and electrical layouts in architectural design Please only apply if you have demonstrable experience and can deliver high-quali...
I'm seeking a freelancer to assist with a simple data entry task. The project involves populating a spreadsheet with dates, expenses, and descriptions. I'll require this to be done just once. Key Requirements: - Entering data such as dates, expenses, and descriptions into a spreadsheet - The spreadsheet should consist of 3 columns - There will be about 200 rows I have made the spreadsheet already in Google Docs, all you need to do is fill it out with text from 200 File names which I will include This task is straightforward and should not take too long to complete. I'm looking for someone who can get this done accurately and in a timely manner. Please reach out if you fit the bill. Budget is ideally $10 AUD
I need to automate the sending of messages via WhatsApp Web. Key Project Details: - Each message will be sent to a single mobile number. - The automation will be based on WhatsApp Web, so please ensure you have experience with this platform. Ideal Candidate: - Proficient in creating automation scripts using WhatsApp Web. - Experience in creating automated messaging applications would be a plus. - Good communication skills to understand and implement my requirements.
...and easy-to-navigate user interface. Although I've not specified any particular areas for redesign, potential areas to focus on could be: - Revamping the homepage layout - Improving product pages for a more engaging product presentation - Optimizing the checkout process for a seamless user experience I won't be able to provide an exact number of products on the site as that detail was skipped, but the designer should be prepared to handle a flexible number of products. Additional features or functionalities were not specified, however, innovation is encouraged. Proposals suggesting interesting functionalities such as product search/filter options, wishlist functionality, or customer reviews/ratings will have an edge. Communication is a key component for th...
I'm looking for a detail-oriented individual to assist with a data entry project. The task involves entering a variety of data types including numeric, text, and alphanumeric, into an Excel file. Key Details: - You will be working with a spreadsheet that has more than 10 columns. - I require the data to be formatted in a specific way: - Color coding: Certain cells should be filled with specific colors. - Conditional formatting: Cells should be formatted based on specific criteria. - Data validation rules: Certain cells should only accept specific types of data. Skills required: - Proficiency in Excel, including experience with conditional formatting, data validation, and color coding. - Strong attention to detail to ensure accurate data entry. - Efficient and re...
As part of my business operations, I need a robust and all-inclusive Excel-...system should track all sales, revealing important stats that can aid decision-making. - **Inventory Management**: Stock should sync automatically with sales from POS, maintaining an accurate record of available goods. - **Customer Database**: Important fields such as Contact Information and Purchase History should be part of this system. Important tax-related fields like the tax fee and tax ID number should also be included. IDEAL SKILLS: Freelancers with a strong background in Excel and inventory management systems are preferred. Experience in integrating POS systems and data entry automation is also desirable. Knowledge in effective customer database setup, particularly in handling tax related fields, ...
I'm in need of a skilled professional who can help me integrate Google Analytics with my Bigcommerce store. I'm looking to track user behavior, not just the standard website traffic. Key Aspects: - The main focus will be on Advanced tracking with custom metrics to understand user behavior better. - I would like the freelancer to set up tracking for Page views and time on page, Events such as clicks on buttons or links, and User journeys through the website. Ideal Skills: - Proficiency in Google Analytics, with experience in setting up custom metrics. - Familiarity with Bigcommerce for seamless integration and accurate tracking. - Strong analytical and problem-solving skills to ensure the data collected is insightful and actionable. Your role in this project will be c...
I have a WordPress website that needs a specific feature. I'm looking for a professi...directly and email us the person's contact details. The key requirements for this project are: - Understanding of WordPress and form integration - Ability to add an email notification feature for form submissions - Ability for user to download a document (Case Study PDF) The Contact Us form should be able to collect: - Full Names of visitors - Their Email addresses - Company Name - Phone number - Specific inquiries or messages they have Freelancers with previous experience in integrating forms into WordPress sites will be preferred. Familiarity with email notification setup is also required. I'd like this job to be completed efficiently and quickly. I look forward ...
As the client, I'm seeking a freelancer to build a robust list of leads ...to build a robust list of leads for various small businesses in Australia. These businesses include: - Hair salons and beauty clinics - Dental practices - Cafes and takeaway food shops - Gyms - Accounting practices - Law firms The information required for each lead consists of: - Business name - Email address - Contact number - Business address - State - Postcode - Category of business I want the address state and postcode to be presented distinctly in different columns. The data must be accurate, as it is essential for our marketing campaigns. Ideal freelancers for this project would be those with experience in data mining and lead generation, proven research skills, and knowledge of Austra...
...to replace this with a duration box. This should be a certain whole number of hours which should be 1 hour, 2 hours, 3 hours, 4 hours, 5 hours, or 6 hours, instead of an end time. Fifthly is the rent a rifle area. Currently, it is a dropdown where you choose to bring your own rifle for free, rent for 1 hour for £5, rent for 2 hours for £10, rent for 3 hours for £15, rent for 4 hours for £20, rent for 5 hours for £25, or rent for 6 hours for £30. Instead, could this be a dropdown. Instead, I would like to replace this with a tick box that users tick to bring their own rifle or leave unticked if they would like to rent a rifle. The system should calculate the price automatically. I will give you a wp-content folder and sql file you can i...
...media expert who is well-versed in the world of TikTok, Facebook, YouTube, and Instagram. The ideal candidate will help me grow my followers, engage my audience, and promote my drop shipping products. Key Responsibilities: - Developing and executing content strategies for TikTok, Facebook, YouTube, and Instagram - Creating engaging and shareable content tailored to each platform - Growing the number of followers across these platforms - Implementing strategies to increase brand awareness, drive website traffic, generate leads, and facilitate sales and knowledge transfer The successful candidate will have: - Proven experience in social media content creation, particularly on TikTok, Facebook, YouTube, and Instagram - A deep understanding of different audience demographics - A tr...
I'm in need of a talented Keycloak software developer with a solid grasp of .NET. The primary goal of this project will be to develop a custom user management and authorization sys...role-based access control - Develop user registration and profile management features - Integrate the solution with our existing user database The ideal candidate for this project would have: - Proficiency in Keycloak - Extensive experience with .NET - A strong understanding of user management systems and implementing role-based access control - Previous experience integrating user databases List of views: - Login - Users - App roles - User groups Development for User Management (React) If you have the necessary skills and experience to deliver a top-quality solution, I'm keen to discuss t...
I need a creative graphic designer to create a bright and vibrant 8.5x11 inches flyer for an upcoming event. WHO DARE??? Five candidates can participate in the Paqui One Chip Challenge. Can you eat one extremely spicy Paqui Carolina Reaper chip and avoid eating or drinking anything afterwards for five minutes? ONLY ADULTS!!! Location: Le Virage Date: May 23, 2024 Time: 8:00 pm Contact Number: 77032389 Key Requirements: - The flyer should be in a bright and vibrant color scheme.
...speech recognition and natural language processing - Experience in developing software compatible with Windows and Mac - Strong understanding of calendar integration and email automation On-Prem Client: Quivr Agent * Installation * Install Quivr Agent on Windows or macOS * Configure Quivr Agent to connect to local database and file system * Local Database * Use Azure Storage or Microsoft SQL Server as local database * Store indexed data and search results in local database * File System * Use Windows File System or macOS File System * Index local files and folders * Search * Search local database and file system for relevant results * Display search results in user interface * User Interface * Develop user interface for Quivr Agent * Inclu...
I'm in need of an animator highly skilled in 3D product visualization for an electronic...animation where products is turning, while moving across the screen, and bouncing off the top and bottom of the web page, at random angles, like a game of PONG. Use the word "pong" " as the first word of your reply so I know you have really read this. Your responsibilities will include: - Accurately translating the given product details into a 3D model, animated model. - Incorporating rotating views that emphasize distinct highlights of the electronic product The ideal candidate would have prior experience with 3D product visualization, especially with electronic items. A keen eye for detail, accuracy and strong software skills are a must. Please submit a portfoli...
...com/documentation/api/practice-manager-3-1/staff - Jobs & Tasks - - Time - - 1 x Document Set for Clients, and 1 x Document Set for Jobs that are sync'd with the Clients and Jobs lists (e.g. New Client = Setup New Document Set) The lists above are linked so I want to columns to link to the appropriate list (e.g. Clients to their respective jobs). I won't be able to share the API key with you because of sensitive data however you can use the sample responses provided on the XPM site to design the power automate flows and SharePoint site. Once done, I can import into my environment as I have already setup the custom connectors. Ideal candidates for this project would
I am seeking researchers in Athens, Greece to conduct market research for a retail audit. The ideal candidate should have good communication skills. You will have to own an android mobile device to be eligible for this project. For this project, you will have to go to 15 stores and assess products for defects. The number of stores will decrease to 10, if the products' availability is more than 90% after the first 10 stores. The set fee for this project is €200. In each store you will have to assess the product, take photos of the defects, and assess the production code. Training material will be provided. Specific requirements for the project include: - Conducting a retail audit in Athens - Collecting data on an app - Must have an android device Skills and experience ...
...DragDropContext, Droppable, Draggable } from 'react-beautiful-dnd'; function App() { const [panelOpen, setPanelOpen] = useState(false); const [columns, setColumns] = useState({ column1: { id: 'column1', items: ['Sample_Step1', 'Sample_Step2'] }, column2: { id: 'column2', items: [] }, column3: { id: 'column3', items: ['Sample_Step6', 'Sample_Step7'] }, }); const tableData = [ { step: 'Sample_Step1', stepNum: '1', data: 'Enter Text' }, { step: 'Sample_Step2', stepNum: '2', data: 'Click Button' }, // ... add more data rows here ]; // const handleDragEnd = (result) => { // // ... logic to move items ...
Project Duration: 1 Hour Project Type: PHP & MySQL Server Type: Linux Ubuntu PHP Type: 8.2 & Above Number of Improvements: 4 Project Overview: We would like some modification made to two existing PHP files that: 1) Fixes a bug stopping one of the files from inserting new records into our database 2) Inserts additional data into a new db field 5* FEEDBACK WILL BE LEFT FOR YOU
...working on a film production and need someone to ensure the animations in my project’s sequencer are operating correctly. The drone, already functional, is attached to a cine camera actor and I require assistance in validating its smooth operation. Specific tasks include: - Assuring the drone's spinning and working properties - Assessment and possible tweaking of aerial tracking shots and panoramic views - Ensuring reliable subject tracking sequences The ideal candidate will have extensive experience with animation, specifically in the film production industry, and a keen eye for detail to catch and correct any potential issues. It's vital that the drone smoothly performs all actions to enhance the film's visual aesthetics. An understanding of cinematic vis...
I'm in need of a web-based job card system that will allow the creation and editing of digital job cards. Both employees and managers will need access to the system, with an admin login section for authorization of completed job cards. We would like the system to link with Quickbooks Online seamlessly, either through Zapier or an SQL database connection. This will allow completed job cards to be sent to Quickbooks for automatic invoice creation. Managers can then authorize on Quickbooks before sending. Key Functionalities: - Creation and Editing of Job Cards: The system should enable the easy creation and editing of job cards through a user-friendly web form by both employees and managers. Employees can then select their name from a drop-down combo box if they have worked on...
...generation: The system should allow recruiters to provide feedback to candidates after the tests or interviews. The system should also allow recruiters to generate offer letters for selected candidates with details such as job role, salary, joining date, etc. 7. Profile and preference management: The system should allow users to manage their profile information such as name, email, phone number, etc. The system should also allow users to set their preferences such as notification settings, password change, etc. Source code file along with comments on the code is required. If you think the requirements are high for such amount of time then do let me know which requirements can be fulfilled. kindly send your previous work samples of minimalist design apps along wit...
I'm in need of an expert who can fix a google script for me. This script connects with an external web service API that provides data and populates specific columns of a Google Sheet with the parsed JSON data. Lately, it has been throwing up an error: Address unavailable:(Code: 63:32). I haven't made any changes to the API or Google Sheet recently, so I am unsure as to why this is occurring. I would appreciate it if a proficient Google Scripts and API specialist could look into this matter and fix the issues that are leading to this error. Ideally, I am looking for someone who: - Is well-versed with Google scripts - Has a good understanding of APIs, especially ones related to external web services - Can troubleshoot errors effectively and efficiently Looking forward to...
I'm in need of a detail-oriented freelancer to assist with data entry of numerical data. The details of the data, source, and number of fields or columns per entry are currently uncertain as the project is in preliminary stages. Key Responsibilities: - Enter numerical data accurately. - Be prepared to handle digital files or physical documents. Ideal Skills/Experience: - Proven track record in data entry. - Excellent attention to detail. - Capable of handling possible multiple data sources and fields. - Great organizational skills.
...Demonstrated ability to create visually appealing and informative charts and dashboards using tools like Tableau, Power BI, or similar. • Cloud Platforms: In depth experience with major cloud platforms (AWS, Google Cloud, Azure) and database automation. • Bachelor's degree in Computer Science, Data Science, Geography, or related field. • Familiarity with programming languages such as Python, R, or SQL. • Experience with API integrations and data manipulation techniques. • Strong understanding of machine learning and AI concepts, and the ability to integrate predictive models into software applications • Stay up-to-date with the latest industry trends, technologies, and best practices in data engineering, analytics, and AI Additional Desirable S...
I have a vibrant Shopify store which serves as a platform for selling unique products and services. Despite good traffic, understanding my conversion metrics remains a challenge. To gain more views and better sales analytics, I need someone skilled in: - Ecommerce analytics - Shopify platform - Goal setup and tracking. The goal here is to set up various conversion goals effectively on my store. These include: - Add to Cart events - Begin Checkout - Final purchase/sale conversions - Individual page views
You will be required to Copy technical part number from PDFs to excel file. Most of the files have copy paste enabled. I have around 400 PDFs. The brief provided will be very precise and easy to follow. Its a long term project. Will have projects on monthly basis If you understand what we are looking for. A fairly simple project with easy guide to follow through
I'm in need of a freelancer who can edit the page number on my ebook. The current page number is 45, and I need it to be changed to 69. Key Requirements: - The ebook is in JPEG format so knowledge of working with this format is essential. - The page numbers are embedded as text rather than graphics. Ideal Freelancer: - Proficient in ebook editing. - Experienced with working on JPEG files. - Thorough attention to detail to ensure the page number change is seamless.
...converters, and Chat GPT. • Design encrypted communication systems for secure email interactions between customers and third parties. • Automate database updates and manage structured databases for different user types. • Collaborate with frontend developers to ensure system consistency and reflect design changes. Requirements: • Profound knowledge of PHP and Laravel framework. • Strong experience with SQL database management, design, and optimization. • Ability to implement APIs and manage external data integrations. • Understanding of encryption and secure communication protocols. • Ability to work in a team and adapt to evolving project requirements. Desired Skills: • Prior experience in the travel industry or similar sectors. &bu...
I'm seeking a Magento 2 expert to configure emails for my e-commerce platform. This involves setting up three types of emails: 1. Order confirmation email: This should include an itemized list of the order details, as well as shipping information. 2. Shipping confirmation email: This should display the tracking number for customers to easily follow their shipment. Skills & Experience Required: - Profound knowledge of Magento 2 - Quick and accurate configuration skills - Proven experience with email setups in e-commerce platforms
...will share data to an SQL server. This needs to function within a SAAS environment with subscription per device. Main features include: - Admin and User Modules - Managed subscriptions per device - Real-time data alerts In the Admin Module, the following functionalities should be available: - User Management: Admin can manage and monitor users - Device Permissions: Admin can determine how much data a user can view - Monitor Device Data: Admin can view data from all devices - Payment Module: Ability to process transactions For the User Module, users should be able to: - View specific device data as permitted by the administrator - Receive alerts via data changes - Make payments for their subscriptions The ideal freelancer would have experience with IoT systems, SQL data...
...script that can convert .AAF files to .CSV format using either the pyaaf2 module or another suitable alternative. Key Requirements: - This task can not be solved with ChatGPT, because it gives wrong results that are not working, so be careful. - The script should focus on extracting and organizing the clip names and timecodes from the .AAF file. - The CSV output should be structured with separate columns for each attribute, specifically Clip Name, Start Timecode, and End Timecode. This format is crucial for the successful integration of the data. - The Timecode can be in SMPTE format (HH:MM:SS:FF) or in Seconds with Milliseconds. Ideal Skills: - Proficiency in Python programming, with a strong understanding of data manipulation and file handling. - Experience in working with m...
I need a professional who can deliver on the setup and configuration of my Google, Meta, and Bing ad accounts. It's crucial for my business to have this done effectively and efficiently. - Tasks: Specifically, the tasks at hand include account setup and configuration, with a focus on my own strategic i...strategic inputs being paired up with your expertise. - Strategies: I do have certain strategies I'd like implemented, but I also appreciate the insightful input of an industry expert. We can collaborate to strike a balance between my desired approach and your strategic recommendations. - KPIs: The primary KPI I'm interested in is the number of account opens. This core metric will be key in monitoring the success of our ad campaigns. Candidates will be paid on the ...
I'm looking for a professional who can proficiently split Column D in my Excel spreadsheet into columns E, F, G, H . This data must remain on the same sheet post-split progression. I have provided an example in row 2 Key requirements: - Excel proficiency with experience in splitting columns - Ability to deliver quality work in a timely manner - Must respect data privacy Any freelancer applying for this project should include their relevant Excel experience to demonstrate their skill. This task needs to be completed quickly and correctly, so I need someone who knows their way around Excel. Let me know if you're up for it, I'm eager to get started on this as soon as possible.
