Update stored procedure sql queryJobb
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...
I am looking for an experienced freelancer to help me automate the saving of PDF email attachments from Outlook. I currently use the Outlook Desktop Application and need to save these attachments without having to ope...each email individually. I have 4,000+ emails to check Key Requirements: - Expertise in Outlook Desktop Application - Proficiency in creating automated systems - Knowledge of PDF handling and saving - Timely and efficient work delivery - A good communicator to understand requirements and provide regular updates The saved PDFs do not need to be organized in any specific manner; they can all be stored in a designated folder. I'm hoping to streamline this process and save time. If you have experience in developing similar solutions or think you can create one, pl...
...visitors can view and purchase our products. Signup . The order processed should print on the certain computer linked to the website. It should be supported by Strong Backend database . Key Features: - I need a custom-built website, not a WordPress or Shopify site. - The CMS should have robust product management tools, allowing me to add, remove, or update items under different categories. - Content editing is essential. I need to be able to update the content of the site regularly. - The CMS should also include user account management. This will allow registered customers to have accounts on the site with their own profiles, order history, etc. - Additionally, I need the ability to send promotion messages to registered customers. This will be a key part of our marketin...
...timeline with the respective Excel data. * Key deliverables and their progress status, again directly pulled from Excel. * Risks and dependencies associated with each milestone or deliverable. * Utilization of data visualization elements like pie charts, bar graphs, and line graphs to represent the status and progress of each aspect dynamically. Preferably, updating Excel should automatically update the PowerPoint plan, allowing for a real-time, accurate portrayal of project progression. Required skills and experience: * Extensive knowledge about PowerPoint and Excel * Experience in data visualization, particularly in pie charts, bar graphs and line graphs * Experience in creating timeline diagrams * Understanding of project planning fundamentals, including milestones, key del...
I'm seeking a Django/ Java Script with Bootstrap expert who can assist with the layout and design of my website atplands.com. The primary goal of this project is to update the site's visual appearance. My website: Reference downloadable Theme code: Key tasks include: - Reviewing the current website and providing recommendations for improvements - Collaborating with the team to create a new, fresh look for the site - Ensuring the new design is functional and user-friendly Ideal skills for this project include: - Strong experience with Django/ Java Script with Bootstrap - Proven track record of working on front-end development using JavaScript/Bootstrap - A good eye for design and layout - Ability to understand and implement JavaScript
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,...
I need an Android app that includes an integrated Tapjoy offerwall. The main functionalities of the app should include: - User Registration: Users s...Registration: Users should be able to log in using their email and password. - Offerwall Integration: The app should have a single Tapjoy offerwall integrated into it. This is the core feature of the app. - User Balance: The user's balance should automatically update after they complete an offer. Ideal skills and experience for this job include: - Proficiency in Android development, including experience with integrating third-party offerwalls. - Understanding of user registration and secure login systems. - Experience in developing apps that update user balances automatically. - Knowledge of Tapjoy or similar offerwall ...
Hi Bhawan, creating this milestone to record the hours to date. Tracking of 14.5 hours as of 19 May.
...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...
I need someone with experience in Shopify and the Order Printer app to assist me in updating the 'Order Forms' and 'Tax Invoice' templates. The previous version of the app has been updated, and as a result, the code for these templates needs to be adapted. The 'Order forms template' must have: Order Number and Order Date Notes from Customer Quantity, Item Details fields including variants and customisation details. Estimated Delivery Date Customer & Shipping Details The 'Tax Invoice' must have: TAX INVOICE Logo Order Number and Order Date Business Name & Address ABN: Customer Name & Address Quantity, Item Details and variant Pricing, Discounts etc Tax displayed as GST Your main focus will be to ensure that the 'Order...
I'm in need of a mobile application that will help me track the items stored in various boxes. The application must be versatile, enabling me to create and scan QR codes, maintain a detailed list of items per box, and even take photos and add images for better organization and identification. Key Features & Functionality: - Tracking Items in Different Boxes: The primary and most crucial function of the app is to enable the user to keep a comprehensive record of the items stored in various boxes. - QR Code Creation & Scanning: The app should offer the functionality to generate QR codes for items and boxes, and the ability to scan these codes for easy data input. - Item Lists per Box: It is essential that the app can maintain a list of items uniquely attributed to...
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.
I need a professional who can convert a 1-10 page PDF document into a fully editable Word file. The main purpose of this conversion is to be able to easily edit and update the contents of the document as needed. Key requirements: - Conversion of a 1-10 page PDF file into an editable Word document. - Retaining the formatting of the original PDF to ensure the Word file looks professional. - Including images from the PDF into the Word document, maintaining their quality and positioning. Ideal skills and experience for this project: - Strong experience with PDF to Word conversions. - Proficiency in Microsoft Word and a good eye for detail to ensure the final Word file is accurate and retains the formatting of the PDF. - Experience with handling images in Word documents. If you think ...
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.
...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 identifyin...
...of track file like mp3, wav, flac so that it can be encoded into different formats and can be distributed to different dsp sites depending upon required formats. The administrator can upload the royalty files in different formats like xls, csv, txt. provided by dsp sites and calculate the revenues for the artists and label user’s earned by their distributed albums. The encoded tracks need to be stored on cloud storages like amazon S3. The assets can be download from amazon s3 when ever required for distribution. The platform needs a: Distribution software with Release Creation System Catalog management Content tracking Analysis Daily Trends Analysis Audience targeting Monitoring of music lists Video editor Royalty accounting software Neighbouring Rights Collection DMCA aut...
Update, Fix, and Add Features to the website - Add strong security and Chat option in WhatsApp. The same changes will be applied to 3 conferences websites
I need a highly functional booking and appointment website specifically designed to fit the needs of my clinic. As an essential feature, it must effectively manage detailed patient records. Key integration encompasses live chat support, a contact form, and both audio/video online consultation features. Ideal skills and experiences: - Proficiency in creating medical/clinic-...skills and experiences: - Proficiency in creating medical/clinic-based websites - Experience in implementing effective booking and appointment features - Experience with patient record management systems - Expertise in integrating communication features such as live chat, contact form, and online consultation tools on a platform - Strong history of data security to ensure patient details are safely stored and ...
looks like you're encountering a MySQL error related to an incorrect DATETIME value in your query. This error typically occurs when the format of the date and time being used in the query does not match the expected format in MySQL, or when an empty string is being used where a datetime value is resolve this issue, you should first check the format of the 'date_scheduled' values in your 'banners' table to ensure they are in the correct DATETIME format. You might also need to modify your query to handle cases where 'date_scheduled' might be empty or incorrectly you're not sure how to proceed or need further assistance with checking or adjusting your database, you can manage and review your MySQL databases and their tables from S...
Project Details Docker and K8s * Containerize any Microservices based app (Frontend and Backend and DB) and run it as a nonroot user. * Write Kubernetes artefacts to deploy above container on K8s. * Setup Database in Kubernetes cluster. * Deploy microservice to Kubernetes cluster. * Ensure that applicati...microservice to Kubernetes cluster. * Ensure that applications are able to communicate with each other. * Only Ul should be Publicly accessible and not the backend. CI-CD * Automated Application Deployment via CICD. * Setup Jenkins in the Ec2 instance created via Terraform. * Create CICD pipeline to automate the actions done in Phase 1 with stages like Build and Push, push the images to Dockerhub, Update the Kubernetes Artifacts with latest image tag and deploy to th...
...diverse target audience which includes the general public, builders, engineers, architects clients, and a specific building industry/niche market. Use the details of the amarco website and show the format you suggest. Key elements of the project include: - A fresh, modern and responsive design: I'm looking to update the layout and overall design of my website to make it more visually appealing and engaging for visitors. - We want to update the website to display, mention and outline with text and images the expansion of the company as a builder and developer services provider. - Enhanced navigation: The new design should include improved navigation to ensure that users can easily find the information they need and seamlessly navigate through the website. - Ad...
I'm in need of a marketing specialist to help with a B2B product marketing project. The main objectives for this campaign are: - Increasing brand awareness - Generating leads - Boosting sales Your focus should be on creating an strategy with clear execution steps and compelling content to update the website and also for email and content marketing channels. Experience and skills needed: - Refine the messaging for our company website - Proven track record in B2B product marketing - Expertise in email and content marketing strategies - Strong understanding of optimization for these marketing channels - Ability to create relevant, impactful content that resonates with business clients Your task will be to help me reach businesses effectively and persuasively ...
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.
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.
...license plates. This system will need to take images of overspeeding vehicles, store the data in a public cloud, and send it to clients via email and WhatsApp. Key requirements include: - Compatibility: The system must be compatible with Windows, Mac, and Android. - Speed Detection: The system should use image recognition to determine vehicle speed. - Data Storage: The captured data should be stored in a public cloud. - Alerting: Notifications for speeding vehicles should be sent to clients through email and WhatsApp. Prior experience with CCTV camera integration and image recognition is crucial for this project. Experience working with public cloud services is also a plus. The successful candidate will be able to demonstrate a high level of proficiency in developing similar...
I'm looking for a mobile app developer to create an Android app that will serve as a platform for users to engage. Key Features: - **User Login and Registration:** The app should allow users to create accounts and log into them. User data should be stored securely. - **Push Notifications:** I want the ability to send push notifications to users through the app. This feature should be robust, allowing for targeted and engaging notifications. I'm eager to see your past work in mobile app development, particularly for the Android platform. Experience with push notification systems and secure user authentication is a plus. If you're confident in your ability to deliver a solid app that fulfills the outlined requirements, please get in touch.
I'm in need of an exceptional landing page that focuses on promoting my product. While I have some branding elements like color schemes and logos, I'm open to creative interpretations within this framework. Key Requirements: - The main objective is to showcase the features of the product in a...much time until FIRE. The app is available on iOs, MacOs and Android and I have the links for all of the platforms and I would like the landing page to have the standard AppStore/PlayStore download links/buttons. I am opened to suggestions for the hosting part, maybe Wix can be a good candidate, not sure. The only requirement will be to be able to connect a domain because I have my own domain. UPDATE: Redesign this page please ->
I need an experienced graphic designer to assist with my small city council campaign. The project entails: - Modifying an existing political yard sign to update the campaign message and include contact information. - Creating designs for campaign mailers and email materials. The ideal candidate should have previous experience with political or non-profit campaigns, and possess excellent attention to detail. Familiarity working with print and digital media is also required. A refined sense of aesthetics, familiarity with current design software, and an understanding of the political landscape will be appreciated. This is a campaign for reelection, so basic design is complete; some simple updates to yard signs is required, as well as working with the candidate on campaign mailers. ...
Freelancer hiring for Seo Expert, Social media Expert My friend is looking for a freelancer who can do 1. seo activities on a daily basis, update the sheet. 2. Do work on social media with posting stories, highlight creation, daily activities on social media. #seo #remote #freelanceseo #seofreelancer #socialmedia #socialmediaexpert #freelancer #freelance #daily2/3
...#4, ACER, $.. We will post for the winner 4 separate jobs, each will be separate awarded before start! If same computer we can’t fix, is no pay, of course To start communication you need to answer with: “4 computers” so I know you read my listing 1, I have on older HP laptop, have not used since 2021, run on Microsoft Office Enterprise 2007 Can’t go online: “YOUR CLOCK IS BEHING” - I go to “Update Date and Time” - Go to “Change date and Time” - “X Unable to continue” you don’t have a permission to perform this task. - I tried on Youtube, that was not helpful: “How to Fix Windows 10 Errors 2021 | Start Menu Not Working ~ Settings Not Opening - 100% Fix” 2, LENOVO laptop: IdeaPad 3 15IIL05,...
...of the week - Travel tips and inspiration - Call to action to book - Contact information **Deliverables:** - Fully designed and tested email templates for each of the emails listed above. - Integration with Constant Contact to ensure automated sending based on the specified triggers. - Initial setup and testing of the weekly deals newsletter template, with instructions on how to update it with new deals each week. **Requirements:** - Experience with Constant Contact email campaign setup. - Strong copywriting skills to craft engaging and persuasive email content. - Proficiency in email design to create visually appealing templates. - Knowledge of email marketing best practices and automation workflows. **Deadline:** Please provide an estimated timeline for proj...
...simple and efficient development process. • Scope: The project will include updating page colors, fonts, and images to reflect our brand. The template will remain largely unchanged to maintain development simplicity. • Deliverables: A visually appealing website that aligns with our brand identity, using both vector and image overlays where appropriate. Key Requirements: 1. Brand Integration: • Update the template with our brand colors and fonts. • Ensure consistency in design elements across all pages. 2. Image Customization: • Replace existing template images with branded images or vector graphics. • Apply color overlays or shading to images to match our brand's aesthetic. 3. Minimal Template Changes: • Keep the original template structur...
...app from the apple store – must facilitate the option to enable users to subscribe to a quarterly payment model. This is a must. 2. Error trapping - must be able to fail a call or function without crashing the app 3. All dates are in dd/mm/yyyy 4. The Search function must work across all prizes not just those currently calling 5. The code must be deposited in our github 6. Apple must accept the update 7. All drafts must use a version number on the front screen which are incremented for each version 8. Must use our new logo (to be supplied) Additional functions - A new section in the app to cover prize stats This section enables users to get finalists to each art prize using the api’s supplied. This includes: 1. Get finalists for a given prize for a given year (using ...
I'm looking to revamp the Projects Page of my website with the main goal of realigning it. Key requirements: - Update the design of the Projects Page - Realign the Featured Projects section - Ensure consistency with the rest of the site This is a simple WorPress Fix
We are seeking a skilled developer or development team to create a comprehensive web crawler system. This system should scrape, structure, and update information from web pages, handle large projects, and be accessible via a powerful API. The system should offer user-friendly features for both individuals and businesses and include flexible user management for both customers and employees. Project Requirements 1. Web Crawling and Data Extraction -Develop a system capable of scraping entire websites and extracting data from each page. -The system should divide the scraped information into sections to facilitate easy reading and understanding. -For e-commerce sites, the system should identify and structure the following information: --Product category (including breadcrumbs for hiera...
I'm in need of a proficient expert who can assist me with running queries on DuckDB using data originating from Amazon S3. This task primarily involves: - Interacting with semi-structured data such as XML and JSON - Processing a substantial data volume ranging from 1GB to 1TB The ideal freelancer should have the following capabilities: - Deep understanding and experience with DuckDB and Amazon S3 - Strong skills in handling and querying semi-structured data - Experience in managing and processing large volumes of data Please note: it's critical that the freelancer have experience with managing these sorts of tasks previously and has a solid understanding of large volume data manipulation.
...accounts and log in. - Push Notifications: Utilizing notifications to engage with users and keep them updated with the latest offers, deals, and more. - Connected to WordPress Shop: The app should effectively fetch and display product data from the existing WordPress shop, ensuring real-time updates of the product catalog. - Custom Stock Management: Admin should have the capability to manage and update stock information with ease. - Bidding Auction System: A unique feature allowing customers to place offers on products, creating a dynamic shopping environment. - Custom Photo Upload: Customers should be able to upload custom photos from their devices to the WordPress shop. This feature will enhance personalization and engagement. Ideal candidates for this project should have: - P...
...This includes setting up the website from scratch, making sure all the necessary pages are created, and ensuring it's user-friendly. - **Arabic Language Support**: The website should be developed in a way that fully supports the Arabic language, including all aspects such as product descriptions, user interface, etc. - **Manual Product Management**: I prefer a system where I can manually add and update products. The chosen freelancer should be able to create a simple and efficient system for me to do this. - **Payment Methods**: I'm looking to offer 'Cash on Delivery' as the primary payment method. This should be seamlessly integrated into the website. Ideal Skills and Experience: - **E-commerce Website Development**: A proven track record of creating suc...
I'm looking for a talented freelancer to help me automate a complex process. As of now, I manually gather numerical data from a variety of unstructured sources like images, text, and PDFs. This data includes formulas and is stored both on my local computer and the web. At present, I get ChatGPT to convert this data into a table which I then paste into excel. I do calculations in excel to find out what percent each ingredient is of a total formula. Then I create a new entry into a table in Airtable and paste this data into a different table in Airtable which references the first table. I need someone to automate this data extraction process, calculations and entry into two separate Airtable tables so I can do it repeatedly myself. I work in a standardised operating environment f...
I'm searching for a professional who can address the issue of an incorrect .p12 key in my Android application. Key Tasks: - Troubleshoot the current .p12 key to identify the cause of the issue - Generate a new key for the application - Update the app with the new key to ensure proper functionality Experience and Skills: - Demonstrable experience with Android app development - Proficiency in handling .p12 key issues - Strong knowledge of Android security protocols and practices I'd appreciate someone who can take care of this process. The applicant should also be able to confirm compatibility of the new key with the versions of Android the app is currently supporting. Please include any relevant experience you have in maintaining and updating Android apps in your propos...
I'm looking for someone who can do an easy update to my website Check out this area of the website, where I have my books listed: I need to add 7 or 8 of my latest books to what you see there. I'll supply the images and the text. The website is a Wordpress site hosted on Namecheap. Requirement: Please only bid exactly what you're willing to do the work for.
I require an expert in WordPress, Elementor, and The7 theme to assist with updating my website. - I am currently running Elementor version 3.1.1 and The7 ...theme to assist with updating my website. - I am currently running Elementor version 3.1.1 and The7 theme version 10.10.0. - I don't believe there were any customizations done to thse. - I am looking for someone who can update these elements while ensuring that the current design and functionality remain unchanged. Ideal Skills and Experience: - Proficiency in WordPress, Elementor, and The7 theme. - Experience in updating WordPress websites while maintaining current design. - Strong understanding of Elementor and its integration with themes. I have tried to update them myself - but I get messages saying the ...
I need a WordPress portal that allows me to input text and images for specific user groups to access. Key Elements: - The admin should be able to input and update text or image content on the platform. - I want this content to be visible only to registered users and admin users. Guests should not have access to it. - Users will need to log in to view the content, so some form of user authentication is also necessary.
I am looking for an expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.
I am in need of a skilled AppSheet developer to create a custom app for my small warehouse inventory business. Key Features: - Inventory Tracking: I require a system that will consistently track and update inventory in real-time to ensure accuracy. Other Details: - Products: As a small warehouse, I have less than 50 different types of products. - User Access: The app will not need to support multiple users accessing and updating the inventory simultaneously. Ideal Skills: - Proficient in AppSheet development - Experience in building inventory tracking systems Please respond with your relevant experience and sample work for further consideration.
I am seeking an experienced LT Spice expert to assist with the design and simulation of a half-bridge circuit to drive an ultrasonic cleaner load, 60W, 39kHz, and 10R impedance. I have an LT spice model that needs to be updated to meet the requirement. The floating side needs to show a square wave and the output to the load needs to be a sinewave. The main requirement is to update the values of the discrete component and use a much better MOSFET to meet the required output of 600V AC, 0.5A, 39kHz Responsibilities: - Improve the LT Spice model for the half-bridge circuit (no rectifier needed), Output is AC and not DC - Conduct detailed simulations to analyze performance - Optimize circuit design based on simulation results The MOSFET part number is SIHP24N80AE-GE3, The PWM con...
I have a Ubuntu 22.04 server, currently with spark running perfectly. I want, however, integrate spark with Hive warehouse. In this project, you're required to perform the installing of Hadoop and hive and, after that, update settings in spark so it can connect with hive warehouse properly. You'll be provided with remote access via TeamViewer or anydesk.
Seeking a skilled web developer to improve and update our existing Django-based website. The project involves: Menu Bar: Update and ensure consistency with multilingual support (Swedish, Danish, English). Contact Form: Implement validation, translations, CAPTCHA, and backend management. Multilanguage Support: Set up inputs for Swedish, Danish, and English without auto-translation. Articles and Blogs: Improve layout, image handling, and formatting consistency. Search Function: Enhance search to include titles and body text. Main Picture: Add functionality to change the main picture with size guidelines. Home and About Pages: Ensure consistent formatting and editable content. DNS and Email Setup: Correct domain pointers and enable email functionality on server. Proven experien...
