Vba mysql jobs

I am seeking an experienced developer to build a dynamic and complex web application utilizing PHP, MySQL, and JScript. Key functionalities required: - User authentication - Data input and retrieval - Dynamic content generation - E-Wallet - Money Transfer - Shopping Cart - Admin Panel - API Integration - Mobile Recharge - Crypto Wallet - Payment Gateway Integration - Crypto Integration The project requires a clean and professional design that effectively highlights its diverse functionality and usability. There's no specific framework required for this project, allowing developers the freedom to use the ones they are most comfortable with. Ideal Skills: - Extensive experience in PHP, MySQL, and JScript. - Proven track record in building dynamic web apps. - In-depth u...

hi evryone simple project is needed in Excel i have date which is connected to server to import data so i need to update the Date by click at the icon "Update:" [ the icon connected to hyperlink for example] please see the attachment, and after the implement needed is will take the Cell: Date + "00:01" and return it back and it will automatically update> if is it possible by us...project is needed in Excel i have date which is connected to server to import data so i need to update the Date by click at the icon "Update:" [ the icon connected to hyperlink for example] please see the attachment, and after the implement needed is will take the Cell: Date + "00:01" and return it back and it will automatically update> if is it possible...

I have an Excel workbook. I would like to expand that workbook and add an inventory aspect to the workbook. I am looking for a developer with extensive experience with VBA script and custom functions in Microsoft Excel 365. If the first job goes well we will have more consistent work (other jobs) to be done.

I'm currently using Oracle and MySQL database management systems and I'm in urgent need of a dedicated database administrator who can expertly handle performance tuning, backup and recovery, and security management. The ideal candidate should have an extensive background in both Oracle and MySQL, as well as a solid understanding of the nuances of these database management systems. Here's what the project covers: - Performance Tuning: I'm experiencing sub-par performance with my existing workloads, and I need someone with a knack for diagnosing and resolving complex performance issues. - Backup and Recovery: An integral part of the project is to safeguard the digital assets by implementing robust backup and recovery strategies, thus to ensure database av...

Please Sign Up or Login to see details.

...Responsibilities: - Automating repetitive tasks within the Excel spreadsheets, to increase efficiency and accuracy. - Customizing the spreadsheets to better suit the specific requirements of my business. I have a specific deadline for this project, so it's important that you are able to work efficiently and effectively within the given time frame. Skills and Experience: - Proficient in Excel and VBA - Experience in spreadsheet automation and customization - Strong communication skills to understand and implement my requirements - Ability to deliver within a set deadline - Previous experience in similar projects would be a plus. If you're an intermediate Excel developer with a solid understanding of automation and customization, I'd love to hear from you. Pleas...

I am in need of a skilled Word VBA programmer who can assist with automating document formatting and creating custom macros. The ideal candidate should be familiar with Office365 Word and have experience working with formatting styles. Key Responsibilities: - Automating document formatting - Creating custom macros The goal is to make a fully functional document with macros based on an example with Word field codes. Ideal Skills: - Proficiency in VBA for Word - Experience with automating document formatting - Strong understanding of formatting styles in Word - Ability to create custom macros - Attention to detail This project is suitable for someone who is looking to apply their Word VBA skills to a real-world problem, and who can work independently to deliver eff...

I require a programmer adept in software development, preferably with a solid understanding and experience in Excel data manipulation, to create an application tool that can efficiently compare two data sets. - The tool shou...organization’s payroll system. I need the tool to be capable of comparing and juxtaposing entries according to dates and times specifically. - The tool should also be configured to duly highlight or flag any discrepancies between the two data sets, along with matching the data accurately. A report generation functionality, for reference and record-keeping purposes, is also required. Knowledge in macro/VBA programming and expertise in data analysis would be a great advantage for this project. A background in creating payroll system tools would be a...

I require a programmer adept in software development, preferably with a solid understanding and experience in Excel data manipulation, to create an application tool that can efficiently compare two data sets. - The tool shou...organization’s payroll system. I need the tool to be capable of comparing and juxtaposing entries according to dates and times specifically. - The tool should also be configured to duly highlight or flag any discrepancies between the two data sets, along with matching the data accurately. A report generation functionality, for reference and record-keeping purposes, is also required. Knowledge in macro/VBA programming and expertise in data analysis would be a great advantage for this project. A background in creating payroll system tools would be a...

I'm looking for a seasoned PHP and MySQL programmer to establish the architecture of a ranking system for my multiplayer gaming site. Tasks will include but are not limited to: - Database design - Data modeling - Query optimization The ranking system will make use of user ratings, vote counts, and engagement metrics. The ideal freelancer for this project should have ample experience with ranking systems and must exhibit prowess in PHP and MySQL, with a keen understanding of database design, data modeling, and query optimization. Familiarity with gaming sites is a plus. Let’s build a competitive gaming environment together.

I'm looking for a skilled freelancer with a strong understanding of Excel, particularly in building macros for data import and operations. Here's what you'll need to do: - Implement an Excel macro that can smoothly import numerical decimal data from a text file. Our perfect freelancer for this task will have: - Proficiency in Excel and VBA programming - Strong knowledge and experience in creating Excel macros - Understanding of data import techniques for decimal numerical data - Experience in handling data input tasks using macros. If you have the necessary skills and have previously handled similar projects, I'd love to get your bid. Thank you.

Potential freelancers: -Past experience in financial services industry (Recommended) -Skilled in running excel VBA/macros, automating excel data & display through line chart Project: (1) Display recent weekly data (2) For past 5 years Key Details: (1) Data source:

...please ensure you have full time capacity if you're successful. The technology stack you should be well versed in to apply to this role is as follows:  PHP, Specifically the Larval framework 6+ years - It's important to see a track record on your profile of working on more complex PHP apps  NodeJS 4+ years  NextJs and Typescript experience building high performant client experiences 4+ years  Mysql 6+ years AWS 4+ years - Infra as code, Docker, ECS, Aurora, Event bridge. The Infrastructure side of building applications you should be as deeply competent in as the application side for this role.  Scalable event driven data models - You've built real time or just in time systems across many data types and models with scalability and efficiency within system c...

Looking for an experienced software developer proficient in Java and Python. Specializations required: - Java - Python The software will be developed specifically for Windows operating systems. Familiarity with Windows development i...experienced software developer proficient in Java and Python. Specializations required: - Java - Python The software will be developed specifically for Windows operating systems. Familiarity with Windows development is a must. Database Technology: - The software should be fully compatible with MySQL database technology. Previous work with MySQL is desirable. To summarize, your skills and experience should include, but not be limited to, Java, Python, Windows software development and MySQL database technology. If this sounds ...

...system, and develop a mechanism for securely packaging and delivering code updates. Required Skills & Experience: - Strong Python development experience, with a demonstrable portfolio or past projects - Expertise in secure backend development, authentication, and encryption - Solid understanding of API development principles, with RESTful APIs as a plus - Experience with database systems such as MySQL or PostgreSQL - Ability to write clean, well-organized, and maintainable code Nice-to-Haves: - Familiarity with Git for version control - Previous experience building update systems or licensing mechanisms To Apply: Please provide a brief cover letter outlining your relevant experience and interest in the project. Include your portfolio or links to past projects demonstrating...

...to users. Collaborate with me to integrate the update system seamlessly into my existing Python code. Required Skills & Experience: Strong Python development experience (demonstrable portfolio or past projects). Expertise in secure backend development, authentication, and encryption. Solid understanding of API development principles (RESTful APIs are a plus). Experience with database systems (MySQL, PostgreSQL, etc.). Ability to write clean, well-organized, and maintainable code Nice-to-Haves: Familiarity with Git for version control. Previous experience building update systems or licensing mechanisms. To Apply Please provide the following: A brief cover letter outlining your relevant experience and interest in the project. Your portfolio or links to past projects de...

Hello, I have a xlsx file with 2 sheets (sheet 1: data; sheet 2: pivot table), I need a vba macro that do this: - Delete data from sheet 1; - Import a txt file (the user can select it) in sheet 1; - Update the pivot table without changing formatting. And will share you more details in via chat box. Thanks

I'm in need of a reliable freelancer to help me automate the daily backup of my PHP table data to an Excel sheet. The primary purpose of this task is to ensure that all the data on my PHP table is safely stored in an Excel sheet for backup purposes. The data includes important records that I can't afford to lose. The ideal freelancer for this project would have: - Proficiency in PHP and Excel VBA for automation - Experience in data storage and backup systems - Ability to ensure data integrity during the transfer - Excellent attention to detail to ensure all data is backed up correctly - Availability to set up and maintain a daily process If you have the skills and experience to complete this project efficiently and accurately, please reach out and explain your approach.

I'm using aapanel and I'm looking at the processes here and the load is very high on the database, the server is at 100% and I've never seen this happen before.

...Hostinger and faced an issue while setting up a tool (iRedMail). In trying to configure it, I mistakenly reinstalled mysql. As a result, I've lost the databases that were previously stored in /var/lib/mysql. - I have full access to the VPS and can login via the command line. - The MySQL service is currently running on the VPS, but it's empty as I need to recover old databases. - I have specific information about the databases and tables that were deleted. I'm in urgent need of a skilled professional who can help me recover the lost databases. The ideal candidate should possess: - Profound experience in database recovery, particularly on Ubuntu VPS. - In-depth understanding of MySQL database structures. - Ability to work efficiently through c...

I'm looking for an experienced DevOps specialist to optimize my Hostinger VPS. Here are the key details: - **Cloud Platform**: My VPS is hosted on Hostinger and I'm not planning to migrate to any other platform. - **Setup and Configuration**: I've already set up the VPS and ...Requirements**: The main task I'd like you to help me with is optimizing the server. This includes enhancing its performance, efficiency, and reliability. Ideal skills and experience for this job include: - Strong understanding ofVPS. - Excellent knowledge of independent handling of the project - Excellent knowledge of DevOps - Proven experience in web applications optimization - Proven experience on MySQL - Excellent knowledge of DevOps practices. - Good communication to provide upda...

I need a data entry expert to transpose textual data from word documents into a database system. The data is ready for immediate start and the project will ideally suit someone with solid experience in data entry, particularly with word and MySQL or SQLServer. The ideal candidate for this job should: - Have proven experience with data entry. - Be proficient with Word documents. - Have working knowledge of database systems especially MySQL or SQLServer. - Be detail-oriented and accurate. Note that this is not a one-time job, as more projects of similar nature are lined up. Therefore, demonstrating good performance might lead to more future collaborations.

I'm looking for an experienced developer to update my PHP website's code from version 5.4 to 8.2 and migrate the existing MySQL 5.5 database to MariaDB 10.11. Key requirements: - Code Change: The project involves updating the PHP codebase, ensuring compatibility with PHP 8.2. Your role will include identifying and applying necessary changes for syntax updates, security patches, and performance optimization. - Database Migration: You'll also be responsible for migrating the database from MySQL 5.5 to MariaDB 10.11. This includes ensuring data integrity and minimizing downtime during the transition. - Framework Experience: The PHP codebase uses the Zend framework. Familiarity with this framework is essential for completing the code updates effectively. - A...

I'm in need of an experienced VBA Excel programmer for automation of repetitive tasks, creation of custom Excel functions, and assisting with data analysis and visualization. Key Responsibilities: - Develop and implement VBA automation for my repetitive tasks - Scripting and designing customized Excel functions - Contribute expertise to data analysis and visualization tasks. Ideal Skills and Experience: - Fluent with Excel Macros and VBA - Robust knowledge in data analysis and visual representation - Flexible to work with any version of Excel I'm looking for a completion timeline of within the next month.

I need to migrate my current MySQL/PHP database site to Hostinger. I have migrated the website, but the database needs to be migrated manually. I then need to check it is working on the preview version. I will then need you to upload the most recent version of the database, once the DNS is changed to the new host.

I am looking for skilled programmers who have the expertise in converting Excel VBA macro codes into a cloud-based solution that can be run on MS Azure. Key Requirements: - Conversion of Excel VBA macro focusing on data analysis - Development of a scalable and secure MS Azure-based solution Ideal Skills and Experience: - Proficient in Excel VBA and cloud technologies - Experience in migrating Excel VBA macros to cloud-based platforms, especially MS Azure - Strong understanding of data analysis and cloud security - Proven track record in developing scalable cloud solutions

I'm on the hunt for a proficient Node developer to assist in creating a compelling Stock Trading Application. Given the technical requirements of the project, a solid understanding of Node as a backend framework and MySQL as a preferred database is desired. Key functionalities to be developed: - User authentication and registration: Security of user data is paramount, so crafting a reliable and secure sign-up and login system is vital. - Real-time stock data updates: Proficiency in API integration and data visualization is crucial. The application should provide live updates on stock prices. - Trading algorithms: Ideal candidate should have a deep understanding of trading algorithms, capable of implementing such within the software. Previous experience developing similar app...

...an Independent contributor, who can support us for 8 hours a day, 5 days a week, with the following requirements. Role- Low code Developer Exp Required - 5+ Yrs Timings : 10:00 am to 07:00 PM IST Location : Remote (India) 3+ years of .NET or JAVA development experience  Exposure to Outsystems and/or Appian for Low-Code preferable  3+ years with relational databases  3+ years of MS SQL or MYSQL  1+ years designing and developing REST APIs  Proficiency in C#, .NET, HTML, and/or Javascript  Exposure to JIRA and BitBucket/Git for source control a plus  Practical understanding of data structures, algorithms, and design patterns in a web environment  Cloud first architectures (AWS, Azure, Cloudera, etc.) a plus  Log aggregators (SumoLogic, Splunk) a plus  Experience...

I require a MySQL/PHP developer to create a sales report of tickets sold per party per period. The data is in 2 tables, 1 capturing the sale, 1 capturing the details of which tickets for which party. I currently already have a number of sales reports built in PHP/MySQL. We would need to add a report that states the sales per party in the time blocks before the party start - 15 days before, sales per day - 10 days before that - 10 days before - till no more sales SKILLS & EXPERIENCE: - Experience in MySQL and PHP development - Proven track record in database system development - Knowledge of sales reporting will be a great plus.

I am looking for a skilled professional to help me install and setup an online MMORPG game server and client. This job involves: 1. Operating with a Linux system - expertise is crucial. 2. Installation of MySQL development libraries. 3. Setting up a 32-bit gcc environment to compile the server. 4. Hosting a MySQL server on the same host for running the server. 5. Modification of a client installation package to suit the setup. 6. Testing to ensure the game runs correctly and clients can connect. Please note, for this project, 1. Prior experience working with Linux and MySQL development libraries 2. An understanding of the specific 32-bit gcc environment. 3. C++ coding experience (to amend the client) . If you feel suited to this task, do not hesitate to place your...

I'm in need of an expert who possesses a deep understanding and working experience with Django. The project primarily focuses on the customization and automation of a bot script. Key tasks will include: - Automating user start and stop processes - Database integration with MySQL, specifically for storing process IDs to be used for stopping the bot Beside Django, proficiency in MySQL is a crucial requirement for this job, comfortable in handling bot script intricacies. Familiarity with payment gateway integration is an advantage, although not a must-have. Only experienced Django professionals should apply. Your bid should demonstrate your expertise in carrying out such tasks.

I’m seeking a skilled developer to convert my existing PortVB Desktop App into an iOS/Mac Desktop App. It a small tool that runs on a Windows PC and reads some flat XML files and inserts/updates a mySQL database. We need the same program to be able run on a iOS/Mac desktop. I have all the VB Project files/ Source code. - Skills in app development for iOS/Mac, ideally with previous experience in app conversion - Knowledge of data syncing, user authentication, and offline access, in case these features need to be incorporated - Familiarity with contacts management, communication, scheduling, calendar integration, and file/document management functionalities for potential focus areas - Creative design skills to potentially revamp the user interface and overall design of t...

...sale of second-hand equipment, and networking between professionals in the field. Objectives: Create an intuitive and secure platform for users. Integrate profile management, advertisement publication and internal messaging functionalities. Payment system for premium services. Planned technologies : Front-end : HTML5, CSS3, Back-end: PHP with WordPress as CMS, or custom solution. Database: MySQL Plug-in options : WooCommerce for transaction management, WP Job Manager for job offers, Ultimate Member for profile management, and WPML for multilingualism. These plugins are not obligatory and other options can also be proposed. Skills Required: Proven experience in developing WordPress/WooCommerce sites and/or creating full-stack web applications. Ability to work with plugins...

I'm excited to launch an enhanced project aimed at revolutionizing algotrading and real time payoff graphs. Her...Integrate a sophisticated system for user subscriptions, offering flexible monthly and annual options. - Ensure a user-friendly interface with intuitive click-to-subscribe functionality. - Implement robust security measures to safeguard user data and ensure a smooth, engaging browsing experience. - Both web and mobile app. Ideal Skills and Experience: - Proficiency in Python, react, nodejs, flutter, mysql with expertise in handling financial data and integrating with brokers. - Familiarity with APIs and data formats, supplemented with experience in implementing secure subscription models and managing user data. - Ability to design an intuitive interface and light...

I'm in need of a developer adept at using Visual Basic for Applications (VBA) within Excel to scrape exchange rate data from the web. Key aspects of the project: * The focus is on extracting textual content and tables from exchange rate websites. * The specific data to be extracted includes: * Currency codes * Exchange rates * Date and time Ideal candidate's skill set: * Proficiency in Excel VBA with a focus on data extraction from the web. * Familiarity with financial and exchange rate data is a plus. * Ability to implement robust error-handling processes within the script. * Clear communication and timeliness. I look forward to engaging with a knowledgeable freelancer who can fulfill these requirements promptly.

We would like to automate the extraction, transformation and loading of health standard language 7 (HL7) files into a MySQL database hosted on a Microsoft Windows server. The files are sent to the Microsoft Windows server every 5 minutes and we have to load them and once processed move them to a different folder. I have attached our database structure and an example of the HL7 file (dummy) and MySQL database structure. Our HL7 file is for one patient and have one or more OBR per patient. You will have to install Mirth on our server and configure it to automatically process an HL7 file every 3rd minutes. Thank you!

I urgently require a PHP, MySQL, and JavaScript expert to integrate added administrative functions to my current project. The definitive tasks at hand will involve: - User Management: Development of new functionalities to create, edit, and eradicate users, with proper assessment of user roles and authorizations. - Content Management: Incorporate an intuitive system to add, manage, and delete content with specifications varying according to user roles. Ideal candidates should possess extensive experiences in both PHP, MySQL, and JavaScript applications and show proven track records of previous work involving intricate administrative functions. An in-depth understanding of user and content management systems should be evidenced to ensure successful project completion. Your a...

I want someone who can create a VBA macro to merge specified excel workbooks from different excel files in one click. More details: What specific tasks do you need the VBA Excel program to perform? Automate data entry What types of data will the VBA program need to handle while automating the data entry? Text data, Numeric data How will the VBA program receive the data that needs to be entered? Files

I'm looking for a seasoned developer specifically skilled in MySQL to create an inventory management system. Key Features: - Inventory tracking: Implement a feature for manually entering stock levels. The system should be able to accurately reflect these entries. - Reporting and analytics: Build a function to produce reports showing stock levels and purchase history. Ideal Experience: - Proven expertise in MySQL. - Experience in developing inventory management systems. - Familiarity with implementing manual entry for stock levels. - Extensive background in constructing analytic features for report creation. Your bid should showcase previous similar projects and explain how you will achieve the requirements briefly.

I require a professional well-versed with MYSQL for data migration. I will provide the database, you will have to transfer all data successfully and ensure its integrity post-migration. Your responsibilities: - Migrate data from the current MYSQL database to the new MYSQL setup - Ensure data security and integrity after migration - Document the migration process and provide a clear explanation I am striving to maintain data consistency, so it is crucial that you have: - Proficient experience with MYSQL - Hands-on experience with data migration projects, - Proven ability to troubleshoot and problem-solve effectively - Excellent documentation skills. This project requires a meticulous approach, excellent attention to detail, and reliable communication.

...Search, and MySQL (Jira docs). Comfort with Jenkins and Linux is critical. Ideally, our selected freelancer possesses strong communication skills and exhibits an ability to identify key infrastructure resources rapidly. The scope of tasks includes, but not limited to: - Routine maintenance and updates - Troubleshooting - Problem resolution - Installation and Configuration My project is focused on making frequent updates to resources found in Jira and app-status.ot. It is imperative that the freelancer is able to check emails regularly to stay current with any urgent alerts. Please consider this a long-term project opportunity if found suitable. I look forward to potential collaboration. Ideal candidate manages 35 servers, adept at python, Cassandra, Elastic Search...

I'm an advanced user looking for in-depth, personal tutoring in Excel and VBA. The tutoring should focus on, but not limited to: - Writing VBA scripts - Database management in Excel - Advanced Excel functions - Automation - Data Entry Form - Result Page Additionally, guidance should be provided on automation of tasks including: - Data import/export - Data manipulation - Report generation The ideal candidate will have an extensive background in VBA and Excel, with a specific emphasis in automation and data management. They must be skilled in conveying complex processes and concepts in a clear, understandable manner.

...Tasks: - You will need to retrieve all available information on these web pages, focusing solely on the text content. - Following the successful extraction of the data, your responsibility will be to deliver it in JSON format. - The databases for the transfer of data includes MongoDB and MySQL. Ideal Skills: - Advanced knowledge of web scraping tools and techniques. - Experience with social media platforms and their data structures. - Strong understanding of JSON and databases, specifically MongoDB and MySQL. - Diligence and attention to detail for extracting vast amounts of data accurately. In essence, those looking to bid should have a solid background in similar projects, showcasing their abilities to handle large data volumes efficiently. If you fit the bill and ...

As an individual who has taken the first steps towards digitizing data management, I am seeking a proficient Android developer who can transform my existing Excel-based userforms into an enticing Android appl...- A critical feature of this app would be its capability to sync data effortlessly to an external Excel sheet. Hence, experience in database sync technologies is a must. All in all, a successful candidate should demonstrate ample experience in Android application development, a knack for intuitive UI/UX design, and familiarity with data syncing between Android and Excel. While the knowledge of VBA isn't required, it could be advantageous to understand the context of the userforms better. Let's enhance the usability of our userforms and bring this vision to the fing...

I have a webform developed in HTML5, PHP, SQL, and JavaScript. I'm looking for a developer to make a few key improvements. PRE-BUILT I have currently built a where the user selects a customer from a dropdown and selects the number of products to add to this order. Each customer from an SQL table called 'customers' has its own price class 'customerPriceClass' When the user selects the number of products, the page updates and adds rows for each product with a dropdown menu where the choices are fetched from another table called 'products'. The user selects the product and enters the number of units. NEEDED: STEP1 For each row of products the corresponding price from the table 'prices' should be fetched that is associated with the customers p...

As a beginner in Excel and VBA Programming, I am actively seeking an experienced and knowledgeable tutor who can guide me on the journey to developing structural analysis software. I am reckoning on an efficient and in-depth learning experience tailored around my unique learning pace and style. Key Objectives: - Understand Basic to Advance VBA coding and its application in Excel - How to implement complex algorithms in VBA - Grasp of data analysis functions and graphical interface capabilities in VBA Ideal Tutor's Profile: - Qualified tutor with solid and demonstrable grasp of VBA and Excel - Proven experience teaching VBA with commendable patience and understanding - Proven experience developing structural analysis software will be a plus ...

I'm in urgent need of a proficient web designer armed with practical skills in HTML, CSS, JavaScript, React, and MySQL. The project involves creating an interactive, user-friendly e-commerce website. Primary Responsibilities: - Design the layout of the website, ensuring its responsiveness and compatibility across various devices. - Implement features using HTML, CSS, JavaScript, React, and MySQL. - Develop a robust database system using MySQL for handling transactions, user data, and other website functionalities. - Ensure the website is intuitive and user-friendly. The ideal candidate: - Demonstrated experience in web development using the mentioned technologies. - Extensive knowledge of e-commerce websites. Note: The task does not involve the hosting of th...

The local MySQL server engine suddenly shut down due to a power failure. This caused an error in storage or a memory error that led to corruption when the storage engine is writing data to the table. Attempting to fix it, I manipulated the LOGS files (transaction logs, etc.) and managed to connect to the database, query data, and export some of it, and the data was exported perfectly. That's why I know the data is intact. Unfortunately, I didn't think to export all the data because I thought the error had been fixed. However, the next day, the error returned, and I couldn't fix it. Here is a link that explains that it is a common problem in my situation: We are using, XAMPP, MYSQL and Maria

I'm in need of a professional who has mastered the Excel 2016 with a strong focus on VBA scripting. The individual should have: - Proficiency in financial modelling using VBA. -Option Future calculations P&L of portfolio.

I urgently require someone with database expertise to assist me in sorting out an issue with a MySQL query. Please note that I use an old version.