Vba mysql import xls file jobs
...relationship should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the products that are matched to cars according to the cars (sample image attached). To make things easier, the filtering of the products could be enabled only for specific categories...
I am seeking a proficient Flutter developer to create an application for both iOS and Android platforms, with integral backend development using PHP/MySQL. Key Responsibilities: * Develop a Flutter app for both Android and iOS platforms. * Backend development of the app using PHP/MySQL. * Creation of Data fetching APIs for seamless user-experience. Ideal Skills: * Proficient in Flutter * Extensive experience with PHP/MySQL backend development * Skilled and knowledgeable in creating Data fetching APIs If you have proven experience in similar projects, I am willing to discuss the details further. Your understanding and expertise in Flutter development and API creation is paramount for this project.
I'm in need of an experienced backend developer to create a mail parser with the following specifications: - **Email Protoco...experienced backend developer to create a mail parser with the following specifications: - **Email Protocol:** The mail parser should support SMTP, so proficiency in this area is a must. - **Primary Goal:** The primary function of this mail parser should be storing emails in a MySQL database. If you have experience with database integration, this would be a big plus. This project requires expertise in backend development, specifically with an understanding of how SMTP works. You should also be familiar with MySQL and have experience in integrating databases into applications. Please provide examples of similar projects you've worked on i...
Requirements are noted in chat. Regard Muhammad S.
I'm looking for a skilled web developer to help me enhance my finance website, Prime Asset Finance. The main focus will be on adding customer testimonials from Google, and other improvements. Here's a breakdown of the project requirements: - **Customer Testimonials from Google**: I'd like to import customer reviews from Google to display them on my website. Therefore, your expertise in integrating external data sources into a website is crucial. - **Display**: The testimonials should only show the text portion. - **General Site Enhancements**: Apart from integrating the testimonials, I'm also open to suggestions on how to improve the overall look and performance of the site. - UI/UX updates for a modern look. - Making the site responsive across devices. - Sim...
...AI-driven funding opportunity matching, interactive user profiling through an intelligent quiz, and efficient application assistance. Scope of Work: The project encompasses the following key tasks: Template Customization: Adapting the AI SaaS Dashboard template to fit the unique branding and functional requirements. Database Integration: Configuring and linking an external Airtable database to import and regularly update a directory of funding opportunities. User Authentication and Profile Setup: Developing secure login/logout capabilities and user profile management. AI Chatbot Development: Integrating OpenAI’s ChatGPT API to create an interactive chatbot that conducts a business background quiz and uses responses to tailor funding recommendations. Opportunity Matchi...
( Only In...expertise as a Senior Software Engineer or higher ● Extensive experience in software development, scripting and agile methodologies ● Experience using system monitoring tools and automated testing frameworks ● Highly skilled knowledge of selected programming languages (e.g. Ruby, Python, React) ● In-depth knowledge of relational databases (e.g. PostgreSQL, MySQL) and NoSQL databases (e.g. MongoDB) ● Familiarity with AWS and cloud native offerings ● Analytical mind with problem-solving aptitude ● Ability to work independently ● Ability to work cross-functionally with leaders in Architecture, QA, SRE, Product, Creative, etc… ● Excellent organizational and leadership
I'm looking for an experienced WordPress developer who can help me add a special functionality to my existing websites by creating a custom plugin. This role is ideal for someone who has: - A high level of competency in PHP, JavaScript, and MySQL and is experienced in WordPress. - Strong understanding of the WordPress plugins ecosystem and knowledge on how to extend its functionalities. - In-depth knowledge of SEO and how to enhance it on a WordPress website. Key Tasks: - Develop a WordPress plugin that targets SEO enhancements. - Test the plugin for compatibility issues and fix any bugs, ensuring it works harmoniously with our existing setup. - Understand our needs and respond to them by customizing the plugin where necessary. Please note that the function to be added to th...
I'm seeking a skilled PHP/MySQL developer to create a custom PHP POS application. This job will require you to have good experience in PHP/MySQL. You will be paid on a task-based. We will test you with some sample tasks. To be eligible for further discussion I want you to have a look into the portal by visiting the below link and create a free account and try the portal give me one issue you have faced and can be improved in the portal. If you are unable to do above then your application will be rejected immediately.
I am seeking a competent developer experienced in PHP, MySQL, HTML, and CSS. The project involves designing a web application that encompasses: - User registration and login - An information management system The ideal candidate should have strong experience in these areas. No external integrations are required for now, but a candidate that could add this feature in later stages will be preferred. Please ensure you are proficient and demonstrate a deep understanding of the key skills before you take on this project.
As the project owner, I need a skilled Solidworks expert to convert the attached assembly into a STEP file and meticulously remove the undercuts, while allowing for minor changes in dimensions. This project is particularly important as the modified assembly will ultimately be used for fabrication purposes. Your expertise in handling STEP files and making the specified changes is critical. Ideal skills and experience: - Extensive proficiency with Solidworks - Proficient in converting Solidworks assemblies to STEP files - Skilled in modifying part designs, preferably with experience in removing undercuts - Understanding of and experience with fabrication processes - Ability to respect tolerance specifications by allowing minor change in dimensions post-modification - Strong attenti...
I'm looking for a freelance vector artist to convert my file into an high quality AI format. The job is straightforward and only requires direct conversion. However, there are specific dimensions and resolution requirements I would like to adhere by. Freelancers adept at working with Adobe Illustrator and experienced in maintaining high-quality resolution during the conversion process would be an excellent fit. We'll discuss the specifications once we begin the project. Your task is simple: - Convert the attached file into both AI and PDF format - Please provide the image in high resolution as it will be printed on a t-shirt Please bid with a time and cost estimate, and let me know if you need any more details. Proficiency in English is a bonus as it would a...
Project as discussed via chat containing requirements covered in: CashPlus Merchant Credit Advance Instruction Admin Dashboard (1).pdf
I currently have a PHP script that echo's the value of a MySQL db and results appear 3 to a page using Pagination. I'd like the script modified to filter results. There should be a drop down box on the page with the selections of the drop down corresponding to the table column and when selected only the rows with the value of the column appear while still only displaying 3 to a page with page back and forward controls. In the below example of a db table the drop down box would contain the selections 1, 2 and 3. When the used selects 1 then the page output would only display Bob, Jane and Sarah. This is an already existing page with css in the output. Name Address. number ------------------------------------------------------ bob brisbane. ...
Hi Ashish, this is for the tasks I emailed about.
I have an unfinished Flutter app that requires a skilled individual to handle its database connection. The app is designed and now, I need help connecting it to a MySQL database using an API. Key Responsibilities: - Complete the database connection for my Flutter app - Utilize MySQL to store the following data types: user profiles and authentication, transactional records, content and multimedia files Ideal candidate: - Proficient in Flutter and experienced in developing Flutter apps - Skilled in MySQL and API integration - Familiar with handling user data and transaction records securely - Strong background in data storage and retrieval for content and multimedia files This project is not for a business, but rather a personal venture. Your expertise will help me b...
I am seeking partners to become my local sales channels in North America, Europe, Russia, India, Japan and Korea etc. The primary products to sell are UAVs, bearings, and titanate material (e.g. brake). The ideal candidate will have: - Experience selling to the automotive and industrial manufacturing sectors - Know related product importation process, import duty, custom clearance, local transportation - Homologation if any - A strong network and knowledge of these regions - Familiarity with the specific products, their applications, and market demands Your role will involve selling these items to your local customers, establishing a steady sales channel for my products in these regions. Let's collaborate and create a mutually beneficial partnership. I also have sponge prod...
I'm looking for a professional who can make a .jar file in Java 17 for me. It is intended to be a software product which I want to package and distribute. Here are the specifics: - Purpose: The main goal of this project is to create a .jar file that is user-friendly and easy to use for anyone who downloads it. - Platform: The .jar file should be compatible specifically with Windows operating systems. It should be tested and guaranteed to run smoothly on those systems. You should have: - Proficient in Java 17 and Eclipse. - Prior experience in creating .jar files for software products. - A good understanding of user experience and interface design to ensure the .jar file's usability. I'm open to suggestions on how to improve this project. Your creativ...
Good evening, I need help with a Python assignment and I also need programming tutorials in java, Python, mvc, php, Javascript, mysql, jQuery, html, css, asp.net, c#. The tutorials would be in Spanish. I need them as soon as possible.
******* LOCATION ******* You must live in Eastern Europe or Latin America. ******* OVERVIEW ******* I will conduct searches on Google like "Plumbers Minneapolis, Minnesota" or "Carpenters Charlotte, North Carolina." Then I will run the script(s) you created for me. The script(s) you create will save the Google search results in a .csv file. That is trivial and straightforward. The script(s) will also open the websites associated with the search results. That is also trivial and straightforward. The main challenge lies in locating and filling out contact forms on these websites with my first name, last name, email address, phone number, etc. Most search results will include a link to the company’s website. For example, when I search on Google for&helli...
if you can do the work on this moment you can do it i need the file like in within 20 min. it is a eps file it seems it is unsharp. file format is correct but it looks unsharp who can fix it. these are dthe guideline of the file needed:
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
how to decode : All report content comes from the json data we provide, I explain the logic details in report logic.pdf., please check its content. I also attached a json data and a tire report , they come from one scan, you check its content to verify the report logic. we have to make similar script to generate report from our system
Project Budget: $100 Project Deadline: 1-2 Days Project Type: Custom WordPress Plugin Project Difficulty: Standard PHP Version: 8.2 and above Project Overview: Custom WordPress plugin required to allow a user to: -...Project Type: Custom WordPress Plugin Project Difficulty: Standard PHP Version: 8.2 and above Project Overview: Custom WordPress plugin required to allow a user to: - Upload a CSV with bulk new POST data - Select a post category, schedule start date, choose how many posts to PUBLISH each a day - Import post data and create all new posts as DRAFTS, to go live on the specified post schedule & keep a suitable log that can be checked - Insert the new POST IDs back into the original CSV file & automatically download the update CSV for a user 5* FEED...
Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical kno...
i have a form created with HTML and PHP. user has to fill in information and when press submit, it should insert infos in database. But sometimes it doesn't it just clear or keep loading. maybe connection is not good everytime. So i need someone to adjust it to upload d...doesn't it just clear or keep loading. maybe connection is not good everytime. So i need someone to adjust it to upload data in realtime. as soon as user finished typing in 1 field, it should store data. when uploading, it should show loading icon near input field. if succeed, green vink icon. if not, red cross icon. when user finish, user can click submit button which will echo all data stored in mysql database on same page in lightbox. image attached. Budget is $35. if you want more, please do NO...
I need a skyvia expert for an integration project. Source: HubSpot Target: HubSpot Objects to migrate: Contacts, Companies with it's relations Use the import package from skyvia. Please tell me if you have done HubSpot migrations with skyvia before. If not, don't apply to this project.
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for ...
Hello and Thank you for being here Trying to make this reference work Fails ("~/.ssh/mycreds") Works ("/home/username/mycreds") How can I make the logical reference work ~ Can you help me please ? Will give a 5 Star Review when this is done and will write such inspiring words for you, when done. Please understand; there is hope you can give your “best” price; been unemployed, and have cancer with bills backing up, $10 possible? Please note $10 is the max total that I can handle for this (doing hourly reduces % fee). Will leave a Glowing paragraph of feedback 5 stars : - ) My funds are low but will pay quick and leave 5 stars. Please give your best possible for your bid ? (something reasonable?) Please note there is hope we can mutually compl...
I'm looking for an expert to help me set up an Amazon FBA business focusing on Home and Kitchen products. Key Responsibilities: - Registering as a seller on Amazon: I haven't done this yet, so I need assistance with the initial steps. - Product Sourcing: I need help with finding reliable suppliers for Home and Kitchen products. - Setting up the Amazon FBA store: ...Amazon platform and its requirements for sellers. - Strong sourcing skills and a network of reliable suppliers in the Home and Kitchen product niche. - Experience with store setup and optimization on Amazon. Looking for a professional who can guide me through the entire process and help me kickstart this business successfully. I have ready: My supplier from China. The 20 products I’m going to import....
I'm in need of an expert who can help in developing a relational database using SQL and Python. The project will pri...revolve around database management. Consequently, I would appreciate assistance in the following tasks: - Designing a new relational database, ensuring it's optimized for efficiency and performance. - Implementing data import and export capabilities for seamless data movement. - Developing queries to support the database's functionality and ease of use. The ideal candidate for this project should have a strong background in both SQL and Python, with a specific focus on database development. Experience with optimizing databases for performance and some knowledge of data import/export mechanisms would be advantageous. Moreover, an understanding...
I'm in need of an expert who can fix my corrupted .FIC file in my HFSQL database. Key Project Requirements: - The file is currently not opening and is producing errors, so the main goal is to restore it to its original state and ensure it can be opened without any issues. Please note that I can provide the corrupted .FIC file for analysis. Ideal Skills and Experience: - Proficient in HFSQL database management. - Proven track record in repairing and recovering corrupted database files. - Strong problem-solving skills to identify and rectify the issues within the file. If you're confident in your ability to handle this task efficiently, please provide details of your relevant experience and how you plan to approach this project in your bid.
I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering prin...
Make a nice design for a lighting company's product catalog 2 products on each page with a small description of the product Like this:
I want to create a Calculator File locker app, similar to the ones already available (on codecanyon) and in play store. The app must work in both Android and iOS
More details: Which platform(s) should the app be developed for? Both What essential features should be included in the audio calling app? Contact list import, Call recording, 3-way calls How should the audio calling app handle user registration and authentication? Email and password login, Phone number verification
I'm urgently seeking a proficient PHP/MySQL developer to tackle several key tasks for my project. Although I chose to skip specifying the exact functionalities, the developer should anticipate working on tasks such as: Work on 45 pages, each very simple. There are 3 main page features: 1. View table from DB 2. Create new record in that table 3. Edit record in that table Most the pages are the same, just a different table. A few tables have some other functionality but it's all very easy. All html design has been done already, you just have to add some PHP/MySQL code to make the pages work with the database. You also need to create the DB, table and records. Though most have been created already. You would need to double check them though. I also need the ...
...manipulation. 5. Tecnologias Utilizadas: Frontend: Use of technologies such as HTML5, CSS3, JavaScript, along with frameworks like React.js or Vue.js to develop responsive and dynamic interfaces. Backend: Use of languages such as PHP or Node.js, with frameworks like Laravel or to develop business logic and data management. Database: Use of relational database management systems like MySQL or PostgreSQL to store and manage system data. 6. Testes e Qualidade do Código: Development of automated tests to ensure the correct functionality of the system and identify possible bugs or security flaws. Continuous code review to ensure adherence to best programming practices and design standards. 7. Documentação: Creation of comprehensive system documentation, incl...
...industry trends in inventory management. Provide technical support and guidance to end-users as required. Requirements: Bachelor's degree in Computer Science, Software Engineering, or a related field. Proven experience as a Software Developer, focusing on inventory management software. Proficiency in programming languages such as Java, Python, or C#. Familiarity with database management systems like MySQL, PostgreSQL, or MongoDB. Strong problem-solving skills with acute attention to detail. Excellent communication and collaboration abilities. Capacity to work independently and collaboratively within a team environment. Prior exposure to Agile development methodologies is advantageous. How to Apply: If you're ready to embark on an exciting journey and contribute to the...
I am in dire need of guidance to efficiently set up Meltano for data pipelining primarily from relational databases such as MySQL and PostgreSQL. The goal is not only to have a system in place but also to grasp a deep understanding of the whole process. Key responsibilities: - Set up Meltano for data pipelining from relational databases - Offer expertise and guidance throughout the setup process Ideal Candidate: - Expertise with Meltano and data pipelining - Experience with relational databases particularly PostgreSQL - Excellent communication and teaching skills - Attention to detail, patience and willingness to explain complex concepts in a digestible manner. I look forward to collaborating with a professional who can offer high quality assistance, and expedite the learning an...
I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.
For an existing website I need this: Likely Laravel framework. Please keep in mind you need to make the MySQL db for this as well. 1. Store form and order data in MySQL, calculate pricing and show in .js, and send email confirmations from main website order form. 2. Store form and order data in MySQL, check voucher code in DB and return back, need to update order details in bottom of page (.js) and send email confirmations from Affiliate landing page order section. Need to implement online payment from Stripe on both order pages. First phase: 1. Login page (html done, some core PHP done) 2. Forgot password page (html done) 3. Sign up page (html done, some core PHP done - confirmation email needs work) 4. Orders list page (html done) 5. Single order page (ht...
...the file upload functionality from our public area to be copied to our backoffice. This will allow the backoffice to upload files for users in the public area. Key Requirements: - Transfer file upload feature from backoffice to public section - Support for the following file types: pdf - Visual feedback of the upload process with a success/error message - Backoffice should be able to both delete and replace files after an upload Ideal Skills: - Proficiency in Xano and WeWeb platforms - Experience with file upload feature implementation - Ability to create a visually appealing and informative upload process - Understanding of user and content management systems This project involves integrating and mirroring an existing feature, so familiarity with Xano and...
...introduce new functionalities that will improve both the user experience for patients and the operational efficiency for healthcare providers. Key Tasks: - Develop a module for online video appointments. - Create a secure document sharing feature for doctors and patients. Ideal Candidate: - Proficient in WordPress theme customization. - Experienced in custom plugin development. - Skilled in PHP and MYSQL - Has previously worked on healthcare-related platforms, particularly with appointment scheduling and multimedia communication. - Must value clean code, user-friendliness, and data protection. This project is crucial for facilitating seamless digital interaction between patients and healthcare providers. Your efforts will directly impact the efficiency of medical services an...
I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.
I'm in need of a professional to upload my complete album created in Logic Pro to YouTube Music for distribution. Key Requirements: - You'll need to have experience in uploading music to YouTube Music and understand the platform's requirements - Comprehension of how to upload a complete album instead of individual tracks is essential. Additional Details: - I'll provide you with the Logic Pro file and the album art, so you'll purely focus on the technical upload process. - There's no need for any additional work related to the album art. Ideal Skills: - Experience with music distribution platforms, especially YouTube Music - Proficiency in Logic Pro for potential troubleshooting - Understanding of album upload processes If you have relevant experienc...
Freelancer capable of editing a PDF file in English and make a new file max 2 pages. The pdf should look aesthetically neat
I am seeking expertise for my VLSI Magic project that requires: - High-complexity circuit design, calling for an in-depth understanding of intricate electronic circuit schematics. - Proficiency in logic synthesis, particularly in multi-level logic synthesis which is vital for my project. Part 1: Verify the d...synthesis which is vital for my project. Part 1: Verify the design using a logic design tool. Part 2: Implement your design using Magic VLSI layout tool to generate your project layout Part 3: Test your design using irsim to simulate your project. Project submission should be two items: a- A report PDF file. (PDF) b- A compressed file containing all your codes, simulations, and results. (.zip, .rar)
I'm looking for a proficient professional who can create a report in Microsoft Access from a MySQL database. The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work wit...
