Write code transfer data sql server excel jobs
I need a skilled developer to integrate a POS terminal with an existing admin backend. Key requirements include: - Real-time synchronization: The system should allow for real-time data transfer between the POS terminal and the admin backend. This includes sales, inventory updates, and user transactions. Ideal skills for this project include experience with POS systems, backend development, Engineering and real-time data synchronization. Please provide examples of similar projects you've completed in your proposal.
I'm seeking an e...need to build a robust and scalable cloud infrastructure tailored to our needs. - Writing custom scripts: This will involve scripting in Python to meet our specific data handling requirements. - Data processing workflows: You will design and implement efficient data processing workflows using Airflow. Main project is to create views from google bigquery dataset and read it in aws emr using Workload identity federation ,create airflow jobs and then dump it to sql server. Shall be expert in terraform scripting as well Your expertise in these areas will be critical to the success of this project. Prior experience with large-scale data processing and cloud infrastructure is highly desirable. Please ensure your bid reflects your...
I need a professional resume tailored for a mid-level Data Engineer. The focus should be on SQL skills, particularly query optimization. Experience with ETL processes, data pipeline design, and database management should also be highlighted. Key requirements: - Design and writing experience with tech-oriented resumes - Strong understanding of data engineering roles and skills - Proficient in showcasing mid-level experience convincingly - Excellent command over English and resume-writing conventions
I am seeking help with writing new R code. The project involves creating and implementing R code for data analysis and visualization. Please note that I do not need assistance with data manipulation or statistical analysis at this time. Ideal Skills: - Proficient in R programming - Experience in writing new R code - Familiarity with data analysis and visualization in R - Ability to explain code and concepts clearly
As a college professor, I need assistance in verifying the completion of 22 Python coding assignments by my students. The assignments are at a very beginner level and...not. Requirements: - Provide each student's name and their corresponding grade on a separate sheet. - The format of the student names and grades can be in any form (Excel spreadsheet, CSV file, or even handwritten/scanned). - No specific comments are required on the assignments, just a confirmation of completion. - Results can be organized in any order (alphabetically by student name, in the order assignments were reviewed, or grouped by assignment). Ideal Skills: - Familiarity with Python and Jupyter Notebooks - Attention to detail - Ability to work with different data formats - Proficient in organiz...
...streamline our HR processes using Microsoft Forms and Excel. The main aim is to utilize Microsoft Forms for case raising, where employees can report various issues. Key Responsibilities: - Set up Microsoft Forms for case raising - Utilize Excel to track each client, employees, auto send email notification with a unique ID - Implement direct data import from Microsoft Forms to Excel and a dashboard -Excel dashboard for clients and employees Ideal Skills: - send email via outlook to each client absence data weekly -Excel invoice system - Save files auto from email to drive or excel - Proficiency in Microsoft Forms and Excel - Experience with HR processes - Ability to create and manage a unique ID system in Excel -...
I'm looking for an expert in Excel who can help me analyze some racing data. The main tasks will be comparing performances and identifying trends. Ideal skills and experience for the job include: - Proficiency in Excel - Experience with data analysis - Knowledge of racing data is a plus.
...to find relevant companies. • Ensure the list includes only companies with a national presence or significant operations in multiple states. • Deliver the data in a well-organized spreadsheet format (Excel or Google Sheets). Ideal Freelancer: • Experience with web scraping tools (e.g., Python, BeautifulSoup, Scrapy, etc.). • Familiarity with data verification to ensure the information is accurate and up to date. • Knowledge of facility management or related industries is a plus. Budget & Timeline: • Please include your proposed budget and estimated timeline for completion when submitting your bid. Additional Notes: • The data collected must be publicly available. • No use of illegal or unethical scraping ...
I'm seeking an expert to assist with an examination task that encompasses both SQL queries and ORM diagram creation. Key Requirements: - Proficiency in SQL, particularly with MySQL - Experience in designing and creating ORM diagrams - Capability to work with simple data structures, specifically simple tables Ideal Skills: - Strong understanding of relational database concepts - Excellent problem-solving skills - Ability to work under pressure and meet deadlines
I'm seeking a professional to assist with my eBay listings and dropship product sourcing. Your tasks will include: - Locating Amazon U.S. suppliers for specific product categories - Extracting dropship products into an Excel spreadsheet - Creating custom eBay template descriptions - Optimizing draft listing " custom Authentic cartier Glasses" and making auction posts live The ideal candidate should have prior experience with eBay product sourcing and listings, and be proficient in Excel. Understanding of product categories and ability to create appealing product descriptions will be a plus. Your primary focus will be on specific product categories, so familiarity with these categories will be beneficial. You will need to extract the following information fo...
I need assistance with transferring...transferring over 50+ meals from My Fitness Pal into the Recipes section of the same platform. All meals are already entered in My Fitness Pal. Key Tasks: - Transfer each meal into the Recipes section ensuring all data (food products, calories) matches the meal exactly. - Categorize meals into specific types of recipes: Breakfast, Lunch, and Dinner. - Include the exact nutritional information from the meals (macronutrients, vitamins, etc.) in the transfer. Ideal Freelancer: - Must have experience with My Fitness Pal. - Attention to detail is paramount to ensure data accuracy. - Knowledge in nutrition would be beneficial. - Experience in data entry and categorization tasks. - Completed ASAP - I will provide the MyF...
...multiple Excel files that contain customer details such as name, address, suburb, postcode, and telephone number as part of delivery manifests for a freight provider. I'm looking for an Excel expert who can help me consolidate these files into a single, clean customer database. There are approximately 75 separate excel files and about 600 customers. Key Tasks: - Extract contact details from all files - Merge all files into one without duplications - Count and record how many times each customer appears across the separate freight manifests The final merged file should be in Excel format and include the contact details along with an appearance count for each customer. Ideal Skills & Experience: - Advanced Excel skills (data extractio...
I'm looking for an Excel wizard to craft a reconciliation tool for two payment datasets - our Genie Ledger and Payment Gateway Data. Key Tasks: - Identify critical data fields for reconciliation, focusing on Transaction ID, Amount, Date, Payer Information, Payment Method, and Bank Details. - Develop a user-friendly tool that compares both datasets and displays all calculations on a dedicated front cover sheet. - Spot any discrepancies and highlight them in red on the front cover sheet. Ideal Candidate Should Have: - Extensive experience with Microsoft Excel, particularly with macros and VLOOKUP. - Strong analytical skills and attention to detail. - Ability to present data clearly and in a list format. I need a straightforward solution with clear...
...player's progress, compares them to peers or bio groups, and helps parents and coaches quickly get actionable insights. Key Features: - Tracking of various soccer and kinesiology metrics - User-friendly interface for coaches and parents Ideal Skills: - Figma Design - Web Development - Data Integration - User Interface Design Your deliverable: - Interactive, high-fidelity Figma, Sketch, or Adobe XD design prototype The data used by the web interface will come from our servers, but for now, I will provide an Excel file with all the parameters. Please include relevant examples of your work in your proposal. For this project, I will give the dataset to the selected designer. Please read the attached scope of work before sending your proposal. I will know if you...
...Prompt the admin to input the message and attach any media (optional). 2. Ask if the message should be sent immediately or scheduled for later. • For scheduled messages, the admin specifies the date and time. • Once the broadcast is sent: • The bot generates an Excel report showing: • Total number of recipients. • Names and usernames of users the message was delivered to. 2. User Management • The bot will keep a record of all users who activate it. • Admin Command: /users • Generates an Excel report listing: • Serial Number () • Name • Telegram Username of each user. 3. Prize Distribution • The bot will handle contests where users can win prizes. • Command: /prize ...
We have an existing Google Sheet that we want to turn into an Excel Sheet, but when we download it and open in excel the formulas to not come with it properly. Wanted to see if y'all could help us with it?
I am looking for assistance in collecting and org...327 products Kama: 294 products Max Fritid: 1169 products Movera: 545 products Deliverables: Structured Data: Use the provided Excel sheet and fill in the designated columns with extracted information, including: 1) Product Name 2) Description 3) Product page URL 4) Image URLs (usually only one, but up to four images per product, if available) 5) Additional description, if available If any errors or issues occur (e.g., missing data, broken links, unavailable products), leave a clear comment in the designated "Comments" column explaining the problem. This can be done manually with copy paste, og with web scraping tools, as long as you got attention to detail to ensure high-quality data entry. Pay p...
...and C# to help me automate my weekly email process. Currently, I manually prepare emails in MS-Word, pulling customer data from MS-Excel, and sending through MS-Outlook using mail merge. I utilize 25 different email accounts, sending 2000 emails from each account to my customers, with the content being a price list with images. I want a system that automates this process. The emails should be sent from the 25 accounts to the customers from the Excel file automatically, with each account sending out 2000 emails. Skills and experience required: - Proficiency in Microsoft Power Automate - Experience with C# for custom scripting - Familiarity with mail merge in MS-Word, MS-Excel, and MS-Outlook - Knowledge in creating both HTML and plain text versions of emai...
...engineer to set up a cross-platform VPN server. The primary objective is to create a virtual private network that allows all connected devices (Windows, macOS, Linux, iPhone) to communicate with each other using dedicated VPN IPs. Requirements: VPN Setup (Hosting Server): The VPN server will be hosted on a dedicated hosting server (not PC-based). Ensure compatibility with hosting provider specifications and environment. Cross-Platform Compatibility: Support for clients on Windows and Mac (Intel & Apple Silicon chips). Enable connectivity for iPhone devices to join the VPN network. Private Network Communication: All connected devices must have dedicated VPN IPs and be able to communicate directly with each other over the VPN. Allow secure and seamless ...
I'm seeking a meticulous freelancer for manual data entry tasks. You'll be working with provided PDF files and inputting data into an Excel spreadsheet. Key Responsibilities: - Carefully extracting and entering data from PDF files into an Excel spreadsheet - Ensuring accuracy and attention to detail throughout the process Ideal Skills: - Proficient in Excel - Excellent attention to detail - Previous experience in manual data entry - Comfortable working with PDF files.
We're on th...programmer with a solid background in Delphi, Devex, and SQL Server to join our team. If you’re someone who loves coding and has experience building apps and managing databases with these tools, we want to chat! Your role will involve writing code, fine-tuning SQL queries, and ensuring our software works smoothly together. If you’re passionate about what you do and have a track record to back it up, we’d love to hear from you! Key Responsibilities: - Fix bugs as they arise in the existing applications. - Implement feature updates as required. - Improve application performance, with a primary focus on code efficiency. Ideal Skills & Experience: - Proficient in Delphi, Devex and SQL Server. - Experien...
...athlete-specific data fields. Data Fields to Collect for Athletes: The form must capture specific details such as: Full Name Date of Birth Blood Type Allergies Passport or ID copy upload (mandatory) Export Functionality: The system must allow the export of all registered athletes into an Excel file. The exported Excel file should include all the collected personal data in separate columns (e.g., Full Name, Date of Birth, Blood Type, Allergies, etc.). Uploaded documents (e.g., Passport or ID copies) should also be exportable or downloadable. Additional Notes: The solution must integrate seamlessly with WooCommerce's existing checkout process. The form and its functionality should be user-friendly and error-free. Security is essential for handling...
I'm an advanced user of Microsoft Excel, seeking assistance with some issues I'm encountering. You will need: - Extensive knowledge of Microsoft Excel - Experience with troubleshooting complex spreadsheet problems - Ability to communicate solutions clearly and effectively
...the attached Excel sheet. Fill out just the price, year, mileage, and link columns: 1. 2. 3. Facebook marketplace 4. https://www.ironplanet.com/Tanker+Trucks 5. 6. 7. 8. 9. https://www.truckplanet.com/Tanker+Trucks 10. 11. Then for any vehicles that meet all of the Criteria listed below, fill out all of the columns of the Excel sheet. You will
I need assistance with importing our sales leads from an Excel file into our CRM system, Recman. Key Requirements: - The Excel file is stored on Drive and needs to be accessed, processed and imported. - The specific data fields to be imported include: Contact information, Lead source, and Sales history. - No specific data transformation or mapping is required, the data can be imported as is. Ideal Skills: - Proficient in handling Excel files, particularly in a Drive environment. - Familiarity with Recman CRM is a plus. - Good attention to detail to ensure all relevant data fields are correctly imported.
I need a professional to set up a SQL Server failover cluster for 10 applications, all running on Windows Server. This will be for a UAT environment and will involve a quick proof of concept on 2 nodes. Key Requirements: - Setup of SQL Server failover cluster - Testing of the setup as a proof of concept - Evaluation of the SQL Server version used by each of the 10 applications The ultimate goal is to achieve an 'always on availability group' level of high availability. Ideal Skills: - Extensive experience with SQL Server - Familiarity with Windows Server - Knowledge of high availability configurations - Ability to conduct a proof of concept Successful completion of this initial setup and testing will lead...
I need a comprehensive movies list exported into a CSV from IMDB. list should include key details like title and release year, director and cast, as well as genre and rating. Ideal skills and experience for the job include: - Proficiency in data management and export - Extensive knowledge of movies and film industry - Skilled in using Excel or CSV formatting.
... bug fixes, and potential feature enhancements. Technology Stack: Frontend: The website uses React with for server-side rendering, which helps in optimizing load times and SEO. Experience with JavaScript, TypeScript, and modern CSS frameworks like Tailwind CSS or styled-components is essential. Backend: While primarily frontend-focused, some backend knowledge would be beneficial. Although specifics aren't provided, familiarity with RESTful APIs or GraphQL could be useful for data fetching or integration with external services. Database: Knowledge of SQL or NoSQL databases would be advantageous for handling any database operations if required for new features or data management. Deployment: The site is likely hosted on platforms like Vercel, Netlify, or...
Project Overview I am developing a feature-rich Property Management Platform that helps landlords, property managers, and staff streamline every aspect of property oversight. This project extends beyond basic property/tenant management, incorporating advanced financial accounting, invoicing, document management, automated notifications, staff/vendor management, analytics, data import/export, and robust security measures. Initially, we’ll focus on a web-based solution using React (front-end) and Node.js + PostgreSQL (back-end). We also plan to future-proof the system for possible expansions to desktop and mobile platforms. If you have experience building complex, secure, and scalable SaaS/web apps, we’d love to see your proposal! Key Features & Modules 1. Property...
...in an urgent situation as my server has been compromised. It's an old Debian 7.11 system running apache2, with several Virtual Web Domains, Postfix, PHP & MySQL. A malicious hacker seems to have infiltrated through a security loophole and is now using my server to send out spam, severely damaging my mail server's reputation. Your primary tasks will be to: - Analyze net and apache logs to identify the backdoor and trace the malicious code. - Fix the security hole in the system. - Remove any remaining malicious code from the server. I am able to provide you with root access for thorough analysis. The log files that should be prioritized for the analysis include: - Apache access and error logs I have a specific list of virtual web domain...
I'm looking for someone skilled in Excel to help me with a data transfer task. I need to pull information from one spreadsheet and add it to a column in another. Key Requirements: - Transfer of text data between two simple spreadsheets (comprising simple rows and columns) - Matching of data based on an exact match in a single column Ideal Skills and Experience: - Proficient in Excel - Attention to detail to ensure accurate data transfer - Experience in data handling tasks
EXCEL Manufacturing Product scheduler/run time tracker We are developing a means to schedule components in an integrated excel spreadsheet that includes various production steps: (Functions) Laser, shear, punch, bend, paint, assembly, weld, assembly 2, shipping. To be save on a network-share point so all can access same document. The idea is to have a laptop at each station (listed above) 1a,1st step: Manual enter/copy paste-from engineering Initial step-Enter data (component part number(description)) into the first sequence, list all items from the project that needs to be produced. once entered, you can filter material gauges, material types in order to consolidate production run on the LASER. When running the selected items (check box) we track time to produce ...
I need help organizing confidential client data in an Excel spreadsheet. The data is currently in one column and needs to be split into appropriate columns for First Name, Last Name, Phone number, Email, Birthdate, Mortgage start date, mortgage term, and Client Birthday. - Required Skills: Intermediate level Excel proficiency, with experience in using formulas to manipulate data in Excel. - Platform: The session will take place on Microsoft Teams, where I will share my screen. - Data Format: The data is currently organized in an Excel Spreadsheet. Due to the confidential nature of this data, I am unable to share it via email. The ideal freelancer for this job would be able to work swiftly and accurately, ensuring that...
I'm in need of a doors and windows-based software that can generate production drawings and quotations based on my cost estimations. I've laid out the algorithm in Excel files, which will be provided for this project. As a developer, your responsibilities will include: - Creating a user-friendly interface (UI) that allows easy access to the software's functions. - Implementing the cost estimation and production drawing generation features. The ideal candidate for this project should have robust experience in: - Java with JavaFX: This is my preferred programming language and framework for this project. - Software development for Windows: The software needs to be compatible with this platform. - UI design: The software should have a simple, intuitive interface. Plea...
I have a small excel file. I need to convert in excel VBA. The project will be completed by Spanish language. The file and more details will be shared via chat box. Thanks!
ERP Data Migration Consultant Responsibilities: Analyze and resolve data duplication issues in inventory and client-stored wine records. Generate and review reports to identify discrepancies in purchase orders (POs) and sales orders (SOs). Collaborate with internal teams to reconcile discrepancies between Xero and Wine Owners. Propose and implement solutions, including script-based corrections, to rectify the migration dataset. Provide guidance and recommendations to prevent future data migration errors. Work closely with our ERP partner, Wine Owners, to ensure all adjustments align with system requirements. Requirements: Proven experience in ERP data migration and troubleshooting, preferably with platforms like Wine Owners or similar inventory management s...
I'm seeking a skilled Excel expert to create a reconciliation tool for comparing two payment datasets. The first dataset comes from our internal ledger (Genie Ledger), and the second from our payment provider (Payment Gateway Data). Key Tasks: - Identify important data fields for reconciliation, considering factors like Transaction ID, Amount, Date, Payer Information, Payment Method, and Bank Details. - Develop a tool that compares the two datasets, showing all workings on a dedicated front cover sheet. - Identify any reconciliation discrepancies and highlight them on the front cover sheet. The ideal candidate should have: - Extensive experience in using Microsoft Excel, particularly with macros - Strong analytical skills - Attention to detail and abilit...
I'm looking for an experienced professional to upgrade my ASPVS250 from Server 2012 to Server 2025. Key Requirements: - Upgrade the server, which primarily functions as a Remote Desktop. - Migrate totally critical applications from the existing server to the new one. - Ensure a smooth transition with minimal downtime. Ideal Skills: - Extensive experience with Server 2012 and Server 2025. - Strong knowledge of Remote Desktop Services, particularly the Enterprise version. - Proven track record in critical application migration. Please get in touch with your relevant experience and proposals.
I'm looking for a professional who can help me set up a QR code that will be printed for my reception area. Customers will be able to scan the QR code and submit their feedback, which consists of star ratings, comments, and their phone number. The collected data will be channeled directly to my existing Google Form for easy data collection. Key Requirements: - Generate a functional QR code that links to my Google Form. - Ensure the QR code is suitable for printing and displays correctly on printed material. - Provide guidance on how to use the QR code if necessary. Ideal Skills and Experience: - Experience with QR code generation. - Familiarity with Google Forms. - Understanding of customer feedback systems. - Graphic design sk...
I require assistance with developing a macro in Excel. The macro needs to interact with local Excel files and perform specific functionality. The details of the functionality will be provided after the initial discussion. Ideal skills and experience for the job include: - Proficiency in Excel, particularly in macro development - Experience with automating tasks in Excel - Ability to understand and implement specific instructions - Good communication skills for discussing project details
I'm looking to develop a multiuser website for collecting school ID card data and capturing photos. Key Features: - User Access: The website will be accessed by teachers and administrators. - Photo Capture: Users should be able to upload photos from their devices and also utilize real-time camera capture. The website should NOT include editing tools such as cropping. - Data Collection: ID card data will be uploaded via CSV/Excel files. Ideal Skills: - Full-stack web development - Experience with real-time photo capture integration - Proficiency in handling CSV/Excel uploads - Knowledge in developing multiuser platforms Please provide examples of similar projects you have completed.
We are looking for...unrelated sites). We will provide: A list of websites you can use to offer links in return (, , etc.). A tracking system for reporting progress. Requirements: - Proven experience with link building and outreach strategies. - Excellent communication and negotiation skills. - Ability to use email tools and outreach platforms effectively. - Familiarity with Google Sheets or Excel for reporting progress. Payment Structure: - $100 for every 50 live and verified links. - Bonuses available for exceptional performance and securing links from high-authority sites (DA 50+). Websites You Can Offer in Exchange:
I am dealing with slow queries, particularly when querying a very large number of records from multi...that are consistently slow, I need an expert who can deeply analyze the situation, identify the root cause of the problem, and implement effective solutions to improve overall database performance. Ideal candidates should have: - Extensive experience as an MS SQL Database Administrator - Proven track record of diagnosing and resolving database performance issues - Ability to optimize query performance and improve system efficiency - Strong skills in performance tuning and database optimization techniques - Familiarity with MS SQL Server Management Studio and other relevant tools. - You need to have knowledge in .NET EF Core A proper candidate needs to have at least...
I have a completed press release that needs to be properly formatted and transferred to WordPress. This is a simple but urgent task, with an absolute deadline of 9 AM EST. I am looking for someone experienced in WordPress and formatting tasks. Successful completion may lead to future work opportunities for creative senior writers who specialize in topics related to the 80s.
I'm seeking a beginner-level assistant for my regular work. Your primary tasks will involve conducting research and creating simple PowerPoint presentations on given topics. Key Responsibilities: - Researching topics and creating simple PPTs - Hiring and interviewing team members - Managing existing team and content in excel Skills and Experience: - Strong communication skills English/Hindi - Proficiency in Excel and PPT Ideal Candidate: - A college student with a working computer - Looking for long-term work - Flexible with working hours Please note: - We will connect over a call on Saturdays or Sundays for planning and learning sessions.
