Inserting data from excel to sql table using query jobs

Hi Roman, If you remember, last year you did a project for me to show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. Would you be available? We can chat about the details, but basically, this is what I want: I have an Excel file with different sheets. For example, Founders, Advisors, Announcements, and Media. I want a code similar to the previous code (of course, more complicated) to read this Excel file and show the content of each sheet in a different format (as the amount of type of information is different). I will share an example of the Excel file with you. Are you available?

I'm seeking a talented developer with a solid understanding of Excel VBA and Python to develop a system that generates and runs Python code via a manual button within Excel. The Python code generated should have the capability to work with financial data specifically. Linguistic proficiency in Excel VBA and Python is required; knowledge in XLwings or a similar tool would be a significant advantage.

...developer with expertise in PHP and shipping API integration to help me implement a shipment tracking feature for my online store. Ideal skills and experience would include: - Strong proficiency in PHP and WooCommerce - Extensive experience in integrating shipment tracking APIs - Familiarity with Royal Mail / ParcelForce shipping services - Good understanding of customer satisfaction strategies in an e-commerce setting Key responsibilities include: - Integrating the shipment tracking feature into my WooCommerce site - Ensuring the feature is seamless, user-friendly, and integrates well with the existing site - Making sure that the tracking feature is reliable and accurately reflects the status of the shipments - Offering suggestions on how to maximize customer satisfact...

The website is designed primarily to serve as an informative platform about our services and broadcasting experience in the Free To Air sector. Information that needs to be conveyed on the website: 1. Detailed overview of the services we offer, outlining how we excel in the market. 2. Showcase our extensive experience in the field, driving confidence in our capabilities. The site will be mainly aimed towards potential clients and Free To Air broadcasters who are looking for reliable broadcast service providers. Ideal freelancers for this job should have proficiency in web design with experience developing informational websites for service-based businesses. Understanding of the broadcasting or related sector would be an advantageous, but not necessa...

Need to copy a powerpoint presentation from a video all the slides theres about 30-40 slides some just images and some some text

...experienced Shopify developer to help me make a quite smilar a product page. like this Specifically, I'd like this new page to be built using 'Pagefly' or similar tools. this is the product page that we desire to similar While the page should be an imitation of the reference site, I'd like some minor modifications to the design and layout. Key requirements: - Replicating Product Descriptions and Details: This is the core aspect of the project. You'll need to ensure the descriptions and details are accurately transferred to the new page. - 'Pagefly' Experience: Proficiency in using 'Pagefly' or similar tools is a must. This will ensure that the modifications to the design...

...need a skilled Wordpress expert to address a migration issue I'm facing with my website. Here's what I need: - **Migration Issue:** The problem I'm experiencing is related to theme and plugin compatibility following the migration from a server running PHP 7.2.4 where the site worked to a server running PHP 8.2. The front end of the site works but now access to the back end gives the error "There has been a critical error on this website. Learn more about troubleshooting WordPress." I need someone to correct the code so that it works correctly. I believe that the issue may be connected to WPBakery To excel in this project, you should be highly experienced in Wordpress, with a deep understanding...

I'm looking for a skilled professional to create a Web Assembly prototype, , using a small Delphi application that primarily showcases an interactive user interface. The aim is to target the prototype for web browsers. Key Requirements: - Creation of a Web Assembly prototype utilizing a Delphi application. - Focus on showcasing a simple interactive user interface The Prototype: - The user interface for the prototype is envisioned to be simple, consisting of basic elements. - The primary focus should be on the seamless integration of the Delphi application's functionality into a web browser environment.

I'm in need of a diligent and reliable virtual assistant to assist me with a range of tasks. Here's an overview of the key responsibilities and requirements: - Data Entry: The ideal candidate will be comfortable handling medium volume data entry tasks. This may include various forms of data manipulation, collection, and input. - Email Management: You'll be responsible for managing my email inbox. This includes reading, responding, and flagging important messages for my attention. - Appointment Scheduling: The role will also involve coordinating my schedule and setting up appointments. To excel in this role, you should have experience with: - Microsoft Office Suite, including Word, Excel, and PowerPoint. - CRM Software: K...

The aim of the project is to create a nodeJS program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL...

I'm searching for a skilled JavaScript developer who also has solid experience using Chrome Developer Tools for debugging. The main responsibility of this project will be to analyse and understand functionality of a web application and website. To succeed in this project, you need to: - Be an expert in JavaScript. - Have advanced proficiency in Chrome Developer Tools. - Have a solid understanding and previous experience with web platforms. - API integration experience.

...assistance with scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel fi...

I'm looking for an expert to take the text from my Word document and incorporate it into my Canva slides. The slides are for a presentation, so it's crucial that the information is presented clearly and with a professional touch. Key Tasks: - Transferring text from a Word document to Canva slides - Ensuring all text is appropriately sized, formatted and positioned within each slide - Adapting the text to fit the existing layout and design of the slides - Keeping the information clear and engaging for a presentation audience Ideal Skills and Experience: - Proficiency with Canva - Excellent attention to detail - Prior experience with creating or modifying presentations - Ability to adapt existing layouts to fit new content ...

Data Specialist: The Data Specialist is responsible for providing information that is in databases, organizing and assembling the information so that teams can make decisions using data. Responsabilities: > Access database. > Create dashboards and analysis according to the demand of the business areas. > Update and automate dashboards that need frequent updating. > Provide suggestions of improvements in business areas. Requirements: > Mandarim is a must > SQL > Office Package > Database usage At Shein, we believe that diversity is the force that drives innovation. We are committed to creating an environment where all voices are heard, valued and respected. All our vacancies are inclusive for people with di...

Multi-scenarios Custom Sales Commissions Excel Spreadsheets Dashboards. Develop a bespoke Microsoft Excel spreadsheet to accurately calculate sales commissions. The specifics: - The variables: the spreadsheet to take into account the Sales Volume, the Profit, and the Commission Percentage while computing sales commissions. - Calculation specifics: Commission should be determined accurately according to custom formulas (using the previous variables) that considers the Commission Percentage. - Data input: The spreadsheet will be easy to use, allowing to manually input the data for calculation. This tool (Multi-scenarios Custom Sales Commissions Excel Spreadsheets Dashboards) will enhance efficient determination...

Seeking a tech-savvy professional to establish an automated system leveraging ChatGPT and Make Automation. The aim is to: - Automatically extract specific information from a variety of documents including Word, PDF files, Excel Spreadsheets, and Scanned documents - Thoroughly analyze extracted content including text, tables, charts, and images for compliance and precision - Automatically generate comprehensive reports based on extracted information for easy reference For this task, proficiencies in AI, Machine Learning, ChatGPT, and automation are necessary. Likewise, experience in OCR technology for processing scanned documents will be valuable. Not only should the candidate be detail-oriented - they should also be adept at debugging and ensuring the system ...

I'm looking for a skillful interior decorator to revamp my living room into a modern and eye-pleasing space. My aim is to achieve: - A stylish and pleasant ambiance in line with current trends. - Intelligent furniture layout. So this living room will now serve as a bedroom/living room. Hence efficient furniture planning and save spacing furniture is a must. - Innovative inclusion of freestanding bookcases, and storage ottomans or benches that are both aesthetic and practical. - I would also need a wardrobe to store my clothes and suitcases, a large table(which would have a monitor + laptop on it along with my keyboard and mouse - Right now my living and dining area are connected, I would like to have a partition between them so that I can treat the...

...lookout for experienced professionals to build a comprehensive ecommerce platform for my services. We'll have to move quickly, as I need this project completed as soon as possible. Here are some specifics: - The platform will be primarily used for selling services. - Since I opted to skip the question about service categories, I am open to any skill sets you might bring to the table with regards to diverse service offerings. - Rapid response and fast development timelines are crucial for this project. Ideal candidates for this job should have: - A strong background in ecommerce development, specifically focused on service platforms. - Proven track record of delivering projects within tight timelines. - Flexible problem-solving s...

I'm in need of a minimalist logo for my tailor shop. The ideal candidate should be able to design a modern, simple logo that captures the essence of my business without any excessive elements. Key requirements: - Experience in creating minimalist logos - A portfolio that demonstrates an understanding of modern design and brand representation - Ability to deliver a versatile logo that can be used for both online platforms (like the website and social media) and traditional print materials (such as business cards and brochures). I'm looking for a professional who can bring their creativity and expertise to the table. A strong sense of aesthetics, combined with an understanding of brand representation, will be highly valued.

I am looking for a skilled developer to create a system that can manage and sell chatbots with AI. The main components include: Control Panel Features: Ability to activate or deactivate chatbots Update chatbots with new responses or features Manage clients and their chatbots effectively Display statistics about chatbots usage Provide access to chatbots' configurations Include a client database with their contact information The system should enable me to sell, update, and manage chatbots with ease. On the flip side, my clients should be able to access their chatbots through a login and utilize them effectively in both English and Spanish. Additionally, it is essential that the chatbot can integrate and be used on social media platforms like Facebook...

...Azure Data Factory (ADF) development, SQL, Power BI, and ADF monitoring. Key Tasks: - Creating data pipelines - Building data transformation workflows - Integrating with SQL databases Power BI Usage: - Visualizing data through interactive dashboards - Creating data reports and analytics - Real-time monitoring and alerts ADF Monitoring: - Tracking data pipeline performance - Monitoring data integration processes - Setting up alerts and notifications for job failures. Ideal Skills and Experience: - Expertise in Azure Data Factory (ADF) development - Proficiency in SQL, Power BI, and data visualization - Strong background in monitoring ADF performance - Experience setting up real-time alerts and notifi...

I'm ...and familiarity with SQL Server and Asp.net core. Your English skills will be crucial as direct communication with me is required. Key Responsibilities: - Develop a robust business management system leveraging ASP.NET - Implement user authentication and authorization features - Integrate appropriate APIs to enhance system functionality Ideal Candidate: - Minimum 5 years experience in ASP.NET development - Proficient in C# programming and SQL Server - Familiarity with Asp.net core - Experience in developing business management systems preferred - Strong communication skills for client call Please note that this project is only open to Indian-based independent developers. If you meet the requirements and are able to take active part in client...

I am in need of an expert who can assist me with the custom...an expert who can assist me with the customization and setup of Microsoft Office applications. Key responsibilities: - Assessing my requirements and suggesting the best ways to customize the Microsoft Office software. - Configuring the settings and options of the software to meet my specific needs. - Providing step-by-step guidance to help me understand and use the customized features efficiently. Ideal Skills and Experience: - Proficient in Microsoft Office Suite (Word, Excel, Outlook). - Experience in customizing and setting up Microsoft Office applications for various purposes. - Excellent communication skills to explain technical information in a clear and understandable manner. Your as...

I require a clean and professional logo for my project management consulting business, Let’s Sort This Out, LLC. There isn't any specific imagery I am tried to, perhaps incorporate a pen, clipboard or excel style doc - I am 100% open to creative suggestions! Ideal designers will be experienced in corporate branding and able to present a portfolio of similar work.

I'm in a rush and need a skilled ...is the detailed design phase. I need you to take concepts and transform them into detailed plans, elevations, and sections. There's a deadline to be mindful of, as the completion is needed as soon as possible. Key responsibilities include: - Translating architectural concepts into detailed designs - Creating detailed plans, elevations, and sections - Ensuring the design meets all necessary standards To excel in this project, you should have: - Proficiency in AutoCAD and 3D Max - A deep understanding of architectural design principles - Experience in detailed architectural design - The ability to work efficiently under pressure and meet tight deadlines If you're confident in your skills and can deliver ...

- Size: 36" high by 48" wide - Plotting and vector cut line - 2 files one with dimensions displayed other with artwork and cut contour lines. - Should be able to change color of each element in file with just click and fill. - Text if there should be editable (words, font and color)

I require to verify a basic Energy Compliance report using Comcheck program for a 750 sq. feet single story modular building.

I need someone who knows about monorepo and angular , the application was in angular 10 and I transferred it to angular 17 (dependencies, code, etc.) now it seems to compile but it throws an error NG0908 .I just need them to make me work (run well in ngserve). Please write ragnar to see you read the post.

have anyone can help me to install the Laravel system which buy from themeforest, thanks i will provide the domain and also the login of the hosting, thanks

...should allow users to create comprehensive and customizable quotations, including options to choose profile, colour, glass, mosquito netting, etc. - Generating Invoices: Users should be able to conveniently generate invoices based on the created quotations. - Generating Tax Receipts: The app should also support the generation of tax receipts. Additional Requirements: - Save as PDF: The ability to save these documents in a PDF format is essential. - Customer Data: The app should maintain a database of customer information. - Edit Old Quotations: Users should be able to access and make changes to previous quotations. - User Management: The system will need to support 1 admin user with the ability to add unlimited users. The a...

I'm in need of a skilled professional who can scrape data from Google. The project requires the extraction of names and email addresses for specific profiles to be used as a potential leads database. Upon successful extraction, the data needs to be presented in an Excel spreadsheet, CSV, etc. Ideal Skills and Experience: - Proven experience in data extraction from websites - Proficiency in Excel - Strong attention to detail and accuracy - Experience in extracting usernames and emails is a plus Deliverables: - The extracted Data - The data must be clean, organized, and formatted in an Excel spreadsheet I look forward to receiving your proposals!

I'm looking for an experienced Azure Analytics specialist who could coach me in the areas of Data Analysis and Data Visualization. The role may also involve programming. Key points: - Coaching: I need 1/1 coaching via Teams on Data Analysis & Data Visualization within Azure Analytics - Programming: If the opportunity arises, the candidate could get involved in programming using SQL - Proficiency: I consider myself at an Intermediate level with Azure Analytics Ideal Skills and Experience: - Proficient in Azure Analytics: You should have a strong understanding of Azure Analytics, specifically in Data Analysis and Data Visualization - SQL Programming: Experience with SQL is a must as you may be involved in progra...

...analyst with expert-level MS Excel skills to provide a comprehensive understanding of the data and help build a comprehensive energy financial model. Key Deliverables: - Explanation of Cash flow projections - Explanation of ROI calculations - Explanation of Sensitivity analysis - Explanation of 5-year financial projection - Explanation of Manufacturing Financial Feasibility Modeling Data Inputs: - Revenue projections - Cost projections - Investment costs - Tax rates Inflation Handling: - Inflation should be included in the projections Ideal Candidate: - Proficient in MS Excel, capable of building complex models - Experience in financial modeling for the energy sector - Understanding of manufacturing financial feasibility modeli...

نحن شركة تجارة إلكترونية نتعامل مع منتجات متنوعة ونبحث عن مدير إعلانات الوسائط الاجتماعية للانضمام إلى فريقنا. تشمل المهام على سبيل المثال لا الحصر: إنشاء الإعلانات على منصات التواصل الاجتماعي المختلفة إنشاء تقارير في Excel وGoogle Sheets بشكل يومي وشهري إيقاف الإعلانات التي لا تقدم عائد الاستثمار المقبول إنشاء إعلان جديد للحملة المتوقفة يجب أن يكون مدير الإعلانات متفرغًا فقط لهذا المشروع وغير ملتزم بأي مهمة أو وظيفة أو دراسة أخرى ساعات العمل: 6 أيام في الأسبوع، 10 ساعات يوميا يجب أن يجيد الوكيل اللغتين العربية والإنجليزية يجب أن يتمتع أيضًا بمهارات تواصل جيدة يمكن أن تعمل على إكسل أن يكون لديك خبرة كافية في إعلانات وسائل التواصل الاجتماعي والتسويق الرقمي

As we are Manpower Supply Agency, We would like to incorporate attendance day to day entry of our workers from this info we would like to automate payroll, billing and Government salutatory. and also a dashboard for overall performance of our agency. Skills and experience: - Human Resources and Employee Management expertise - Ability to create user-friendly interfaces - Experience with Single Sign-On (SSO) integration and other login methods - Capable of adding features like search functionality, photo upload, and editable fields - Excellent communication skills to understand our needs and translate them into a functional system.

I'm looking for a skilled professional who can assist me with my Air Table. Key Responsibilities: - Create Airtables - Customize Air Table views and filters to maintain a clean and minimalist look. - Create automated search workflows to improve team collaboration. Ideal Skills & Qualifications: - Proven experience in working with Air Table and customizing views. - Proficiency in setting up automated workflows that enhance team collaboration. - Ability to understand and implement a minimalist design approach. Your experience in creating automated workflows and customizing Air Table views is crucial. Please share your relevant past work and suggest how you'd approach this project.

...organise events on behalf of European trade bodies including an annual awards ceremony for a leading sports nutrient association which takes place in London. We are looking for an experienced Event Organiser to provide essential administrative and logistical support for the team in the UK and EU either on a freelance or fixed term contract to deliver an awards ceremony in London in December 2024. You will need a positive, can-do attitude, and be able to flex your approach and make decisions at speed when required. You will perform well under pressure and possess great attention to detail. This is a hybrid role with some scheduled time in the London office will be required along with attendance at the event itself. Responsibilities Assist i...

...business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle management (i.e., gathering, cleansing, publishing, archiving, back-up and recovery, and purging) for large enterprise systems. Familiarity with master data, metadata, reference data, data warehousing, database structure, business intelligence principles and processes, and technical architecture. Knowledge of database management systems, metadata management tools, cloud storage, and associated security considerations. . Combinations of experience and education will be considered on a...

...bookmarking, local citation, and related. I want to create around 100 profile links for one of my money site. You will be given all required details to create profile that given below. - Email address and password to create profile - Name - Bio - Address - Profile Image - Money website address Requirements: - Should have knowledge of Off-page SEO - Should be able to create profile links in bulk - Should be able to create different variations to prevent duplication Key Responsibilities: - Create profile links with given details - Create a table with the created profile link URL (I will provide the table) Pricing: - I can offer INR 10 per profile link Note - I will provide the list to start creating profile links. Resp...

I require transcription services for English audio or video recordings. I need a skilled transcriber with a good command of English to accurately transcribe audio or video files into text. The quality of the transcription must be high. This job is critical to me and I need someone with a keen ear for detail and a fast turnaround. Key Requirements: - Proficiency in English - Experience in transcribing audio or video files - Attention to detail - Reliability and timeliness - Previous experience with sensitive content is a plus Please bid if you are confident in your transcription abilities and can deliver top-quality work within a reasonable timeframe.

...help with data entry from PDFs into Excel, with some basic analysis required post-entry. Key Details: - The primary task is to type data from PDFs into an Excel spreadsheet. - I will provide the PDFs, they contain various types of information that need to be accurately transposed. - The data must be organized neatly and consistently in the Excel file. Data Analysis: - After the data entry, I will need basic analysis of the entered data. This includes simple calculations, averages, basic graphs, etc. - A grasp of Excel's basic analytical functions is essential for this part of the project. Desired Skills: - Proficiency in data entry, especially from PDFs to Excel...

In order to realize the scientific research project of "International Chinese Education Demand Monitoring, Prediction and Countermeasures Research based on Big Data", and create a website that can query the real-time popularity of Chinese learning language in all countries, the following is a website layout and function plan: ### Web Site name: Global Chinese Learning monitoring platform ### Website Layout: 1. * * Home page * * -Top navigation bar: contains the site name, search box, and user login / registration options. -Global map: 1. Identify the popularity of Chinese learning in different colors.2, Click each country, can feedback heat data, etc., you can jump to the second plate 2. * * National heat query * * -List of countries: ar...

...production, analytics, user access control, and Windows-based applications. This job involves maintenance of a warranty return tracking software, with specific attention to: - Inventory management: Ensuring that the software effectively tracks the inventory of returned products - Reporting & Analytics: Enhancing the software's capability to generate insightful reports about warranty returns. - User access control: Improving the control measures for different user permissions within the software. - Ticket creation, Data Import and Export: Aptitude in handling these features are considered a plus. The overriding purpose of this software is to track and manage warranty returns effectively. Ideally, you should have previous experience in software creat...

I'm seeking someone to migrate the content of a PDF DMS 5 book into an Excel spreadsheet. The Excel sheet should serve as a functional checklist with the disorder's name and its description only. Your mission is to categorize the disorders by chapters, mirroring the structure of the original DMS 5 book. Ideal Skills and Experience: - Proficient in data entry and Excel. - Organizational skills to categorize content effectively. I'm not looking for additional columns for notes or references, just an accurate transfer of the book's content to a checkist format de check list to facilitate reading a and diagnosis. Please apply if you're confident in your knowledge of this area and have the appropriate tec...

I'm in need of a skilled PHP developer to implement a table filtering and search feature on an HTML table. - The search functionality is to be based on name, facilitating instant search results as the user types. Ideal candidate should have: - Proficiency in PHP and HTML - Experience with implementing search features on HTML tables - Understanding of optimizing search functionalities for large data sets.

...prompt/require for Document-URL: and extract all the short abbreviations inner in (....) from entire document(with PDF,...extensions). The report/result will like this table with 2 columns: sentence | terms-founded | string of terms | check-selection | button "do-it" Then I will select the terms by checking and then I will press the button "do-it" and the selected terms founded between (...) will be savet into MysQl Table. So for Document-URL: this is simple example of line from this report -sentence: "With the deployment of the fifth generation (5G) mobile network systems and the

I'm in need of a talented data scientist with a strong background in natural language processing and deep learning. The goal of this project is to develop an efficient and accurate ML model that will estimate the temperature of the Electric Motor dataset from Kaggle. Key requirements include: - Utilizing natural language processing techniques to analyze the time series data provided - Employing deep learning methodologies to ensure the model is robust and performs well - Ensuring the model is able to accurately estimate temperature from the Electric Motor dataset Your expertise in natural language processing, deep learning, and time series data analysis will be crucial for the project's success. Please only ...

...Instagram, TikTok, and Google. Key Tasks: - Create Facebook, Instagram, and TikTok pages from scratch, ensuring they are optimized for maximum engagement and visibility - Generate high-quality, attention-grabbing videos and photos to post on these platforms - Develop a content strategy that aligns with my objectives of increasing brand awareness, engaging with customers, and driving traffic to my website - Attract and engage with a target audience of young adults, adults, and businesses Skills: - Proven experience in creating and managing social media accounts across various platforms - Proficiency in content creation, particularly in the form of videos and images - A keen understanding of how to drive brand awareness, customer engagement, and website traf...

We are an Ecommerce company dealing with variety products and we are looking for a Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications skills Can work on Excel Have sufficient experience in Social Media Ads and Digital Marketing

...professional to help enhance the quality of my personal vlogs through editing. Key Requirements: - Basic video editing expertise: I need someone with a solid foundation in video editing techniques to help enhance the overall quality of my content. - Understanding of personal vlog content: Experience in editing personal vlogs is a plus. You should be able to maintain the authentic and personal feel of the videos while enhancing their visual appeal. - Creativity: I need an editor who can think outside the box and bring fresh ideas to the table. I want my videos to stand out and engage my audience. Ideal skills: - Proficient in basic video editing software - Experience in editing personal vlogs - Strong creativity and ability to think diff...