Databases Projects

Want to get job done of email scraping.

We have approximately 12 thousand plus company name. We want extraction of authentic emails and company URLs. those who are ready to extract all complete set of emails should contact only. Emails must be authentic.

Shopping list programme using Excel and VBA

I want to create a shopping list programme for personal use built on Excel with VBA to improve the UI Each week i want to create a shopping list from my database of products that will give me a list of products to buy from two shops, Aldi and Tesco. It should be prefilled with weekly or regular items and then pull from the database as i type the product and ask me quantities. when i print the front page should be Aldi items and the second page Tesco items i need to be able to add items to the "database" tab myself

URGENT: Create a Detailed Materials Tracking Log

We urgently require a well-structured Materials Log to help us track materials across various home renovation projects (bathrooms, kitchens, wardrobes, windows, doors, etc.). The log must be in Google Sheets and easy for our team to update in real time. It should help us track: • Job Reference Number (e.g., CR01500) • Customer Name • Installation Date • Project Type (Bathroom / Kitchen / Wardrobe / Windows / Other) • Material Type (e.g., Glass, Frames, Handles, Hinges, Panels, Worktops, Cabinets) • Supplier Name • Quantity Required • Quantity Ordered • Quantity Received • Delivery Date • Status (Pending / Delivered / Backorder) • Notes / Issues • Cost Price • Total Value of Materials for Job We want the layout to be clean, intuitive, and colour-coded if possible (e.g., red for delays, green for completed, yellow for pending). This sheet will be used daily, so speed, structure, and clarity are key. Skills Needed: • Google Sheets / Excel expert • Workflow/Operations understanding • Eye for detail and formatting • Quick turnaround (within 1-2 hours) What to include in your proposal: • Examples of similar tracking sheets/logs you’ve created • Estimated delivery time • Any suggestions you have to make this even more efficient

opportunity

Develop a Pricing table for Sales Team with Margin calculators

Freelance Excel Specialist Needed – Multi-Currency Pricing Table with SKU Images & Search Functionality We are looking for an Excel expert to develop a comprehensive pricing tool for our sales team, covering approximately 200 SKUs across three currencies (GBP, USD, EUR). This tool must streamline price calculations, display product images, and allow for quick searches by product name. Project Scope: ✅ Three Currency Sheets – Separate pricing sheets for GBP, USD, and EUR, with automatic currency conversion. ✅ Dynamic SKU Pricing – Automated calculations based on materials, customizations, and quantity. ✅ Image Integration – Ability to display product images next to SKUs. ✅ Search Functionality – Quick search/filtering by product name for easy navigation. ✅ Cost & Margin Calculation – Include built-in profitability metrics (cost, margin, and contribution calculations). ✅ User-Friendly Interface – Dropdown selections, conditional formatting, and structured layout for ease of use. Ideal Candidate: ✔ Proficient in Excel (advanced formulas, data validation, pivot tables). ✔ Experience with large datasets (handling 200+ SKUs efficiently). ✔ Knowledge of image embedding in Excel (linking or displaying product visuals). ✔ VBA/macros experience is a plus for automation and enhanced functionality.

Product Professionals - Database

Looking to gather up 10,000 lines of data. + UK Based (Mandarin Speaking a bonus) - Manchester (Mandarin Speaking a bonus) - North West UK - North UK - England - UK Wide + Job Titles - Product Manager - Lead Product Manager - Chief Product Officer - VP of Product - DevOps Engineer (Must Speak Mandarin) - Senior DevOps Engineer (Must Speak Mandarin) - QA Tester (Must Speak Mandarin) - LinkedIn URL - Email Address if Available (not important) Will only pay $0.01 per line as it is just LinkedIn scraping.

Data Entry & Spreadsheet Organisation for Product Management

We are looking for a detail-oriented data entry specialist to assist with cleaning, organising, and structuring product data in spreadsheets. The role involves reviewing existing data, correcting inconsistencies, formatting entries to meet specific guidelines, and ensuring all information is accurate and well-structured. The organised data will be used for internal records and inventory management. Strong attention to detail and proficiency with Excel or Google Sheets are essential.

Help with Excel…

I would like somebody to tell me how when I open an excel spreadsheet sheet I can make it immediately tell me to save the excel sheet as a new document. I have an employee who has been told that they should immediately save the document before editing but never does. So now I want them to be made to save it. Is there a way to do this and can someone tell me how to do it ?

I need Mariadb Mysql expert to restore my Databases

Hello, I have a server running Ubuntu with Webmin, Apache, and MariaDB. Unfortunately, three days ago, MariaDB stopped working. I attempted several fixes but couldn’t resolve the issue, so I decided to reinstall MariaDB. Before reinstalling, I made a full backup of the /var/lib/mysql/ directory, which I still have. After reinstalling MariaDB, I restored the old database files. However, when I try to access the databases through the Webmin Database Management Panel, I receive the following error for every database: Fatal Error! SQL show index from atwp_actionscheduler_claims failed: Table 'abiyetakim.atwp_actionscheduler_claims' doesn't exist in engine. I host several small WordPress sites, and all my websites are affected. I’m looking for an expert who can help me restore the databases. I’ve checked the backup files on my local machine, and I can see the text inside them, indicating the files are not corrupted. I am offering a $20 reward for someone who can help me resolve this issue. If you’re an expert and can help, I will provide my server’s root password once your proposal is accepted. I look forward to receiving proposals from reliable professionals. Thank you!

Customer Service Database Development

Project Overview: We are seeking an experienced developer to build an interactive CRUZE Customer Service Database that will allow us to efficiently track and manage our B2C operations. The platform should provide comprehensive reporting, interactive graphs, and the ability to extract and analyze data. Key Features & Requirements: 1. Customer Order Tracking: * Maintain a record of customer data, including name, contact details, and category classification. * Track customers’ order history, including: * Product type and viscosity ordered. * Offers availed at the time of purchase. * Order date and associated details. * Monitor order status and categorize orders based on type and offer purchased. 2. Promotions & Transactions Management: * Track promotional campaigns and their usage. * Record transactions related to promotions and provide insights on their effectiveness. * Generate reports on promotion performance at the end of a designated period. 3. Product Sales & Inventory Management: * Monitor products sold or used within a specific timeframe. * Maintain an inventory for both promotions and products. * Provide automated alerts for low stock levels. 4. Interactive Dashboard & Reports: * A user-friendly dashboard displaying real-time insights with interactive graphs. * Data extraction capabilities in various formats (Excel, CSV, PDF, etc.). * Custom reports on sales, promotions, order trends, and inventory status. 5. Technology Preferences: * Cloud-based or local database implementation (please recommend the best approach). * Integration with existing CRM (if applicable). * Secure access with role-based permissions. Expected Deliverables: * A fully functional and tested database system with an intuitive UI. * Dashboard with interactive graphs and analytics. * Reporting and data export features. * Documentation and user training (if needed). Budget & Timeline: * Please provide an estimated cost and development timeline. * Include details on post-launch support and potential future enhancements. If you have experience in building similar platforms, please share your portfolio or relevant past work. We look forward to collaborating with a skilled freelancer who can bring our vision to life. Best regards,


Solarwinds Expert for Remote Services

Solarwinds Expert for Remote Services - Onboard new Customer Premises Equipment (CPE) using Solarwinds - Add and update bootstrap templates for consistent configurations - Perform remote firewall upgrades to enhance system security - Set up and refine alert notifications for system monitoring

Excel wizz required to fix some formulas on Excel sheet

We need a Excel Guru to revise some formulas on our excel spreadsheet. Basis outline: Pull through data from one sheet to another excuding some data based on data in cell Formula changes to change how some cells are caculated (changing %'s) Add drop down cell to a sheet to insert data from a rates table on a seperate sheet. I would estimate an hour or twos work for an excel Pro.

opportunity

API Development from BambooHR to a SQL Database

We are looking for someone who has previously worked with the API from BambooHR who can mobilize the integration between Bamboo and our own internal SQL database or can spit out changes to a new SQL database or email address.

Set me up on Xero

I need someone to do some really basic set ups for my new business on Xero and stripe, linking my accounts and setting up my invoice page...super basic !

University Data Scraping for Students

I need a data scraper that can gather the important information from online public directories.

opportunity

Power BI / Quicksight Dashboard Configuration

Project Goal: Configure a dashboard using an existing service (e.g., Power BI, QuickSight, Tableau) to display business data collected via APIs. The dashboard should be integrated into our private admin panel, with the possibility of exposing certain data via a password-protected public URL if required. General Requirements - Accessibility: The dashboard must be accessible through our internal admin panel. It should also support the option to expose selected data through a password-protected public URL. - Flexibility and Customization: The configuration must support a multi-tenant setup: each client using our system should see only their relevant data. The data should update dynamically via integration with existing APIs. Tool Selection: Use a proven dashboarding solution like Power BI, QuickSight, or Tableau to ensure speed, scalability, and ease of use. Dashboard Structure Panel 1: Revenue Performance - Data to Display: - Company Revenue (Month to Date): Revenue generated from the start of the current month to date. - Company Revenue (Year to Date): Revenue generated from the start of the current year to date. - Suggested Visualization: - Cards or bar charts. - Highlighted numeric values for quick performance insights. Panel 2: Revenue Percentage by Business Line - Data to Display: - Revenue percentage for each business line. - Absolute revenue amount generated by each category. Suggested Visualization: Pie charts for percentages. Side tables for detailed breakdowns. Panel 3: Revenue vs. Budget by Business Line - Data to Display: Current revenue (Month to Date and Year to Date) for each business line. - Pre-set revenue budget for each line. - Positive/negative variance compared to the budget. Suggested Visualization: Bar charts for direct comparisons. Color indicators to highlight variances. Panel 4: Workflow Overview - Data to Display - Total number of tasks categorized by status: - To Be Managed - To Be Scheduled - To Started - In Progress - Completed - Lost - Other Status Interactive links to drill down into detailed information for each task (e.g., date, client, current status, notes). Suggested Visualization: Dynamic tables with drill-down capabilities. Bar charts or flow diagrams for overall progress representation. Technical Specifications API Integration: Configure the chosen tool to fetch data from REST APIs or other supported data sources (e.g., CSV files, SQL databases). Set up real-time or scheduled data refreshes. Multi-Tenant Access: Apply report-level filters to ensure each client views only their own data. Configure roles and permissions to manage data access. Admin Panel Integration: Embed the dashboard into the admin panel using iframe or embedded reporting options. Ensure a seamless and responsive user experience. Public Data Exposure: Configure a specific view of the dashboard to be shared via a password-protected public URL. Limit displayed data for privacy and security reasons. Scalability and Maintenance: Ensure the configuration is scalable to accommodate new companies, data types, or panels in the future. Simplify modifications to APIs or filters as business needs evolve. Expected Deliverables 1) Initial Dashboard Configuration with the specified four panels. 2) API Integration to dynamically update data in real-time or at scheduled intervals. 3) Dashboard Embedding within the admin panel. 4) Public URL Configuration (if feasible) to display selected data. 5) Operational Guide for adding new clients or modifying filters.

Complex Data base integrtaion with wordpres site

I will try and make this very brief. I am the owner of glaciustravel.com. We are a travel company. Currently I use typeform for asking clients all the information i need, but it ends up messy and i then have multiple data sources. its complex. Looking for a portal on the website for customers to enter all data i need them to - i think airtable is best for that, then i need it to link up with worldpay (i think we can do that via zapier?!) - it needs to be worldpay - and then i need sub reports to be pushed out to various suppliers. Basically, I need one super table for each trip, with all data, fed in by staff at this end, and also my clients. it needs to be a live document and able to be acessed by suppliers (parts of it). needs to allow a payment gateway for the selections that the clients are choosing.

opportunity

Site Work Record Sheet which will link to our inspection report

We produce various reports for inspection activities carried out at our clients premises. The reports are completed by information recorded in notebooks. i would like a site result sheet which would link to our Inspection Report. some your information such as Customer name / address, location and equipment used would be obtained from dropdown boxes. small laptop / Tablets to be used and once the result is completed the information would be stored on the device and to the Cloud.

I need assistance data gathering for University Databases

My team needs additional members to help us scrape for student information as part of our growing university email data base.

Data Transfer & Database Management

I'm seeking a professional adept at data management to assist in transferring information from various sources into a new database. The project entails: - Transferring data from old Access databases into a new system, with a focus on financial data - Regularly updating databases or records with new information - Correcting and modifying inaccurate files and records - Ensuring compliance with security backups and regular checks to maintain proper data saving and storage Your role will also involve organizing paper formats, paper backups, and material source files as necessary. Ideal skills for this job include: - Proficiency in handling and transferring data from Access databases - Strong attention to detail, particularly with financial data - Experience with data correction and modification - Knowledge of data security protocols and backup procedures - Ability to organize and manage paper records effectively.

opportunity

Convert MS Access project (.adp) to MS Access 365

We have an MS Access project 2010 (.adp) file that connects to an MS SQL Server (2012 or higher). The application is used for contact and address management. The goal is to upgrade the application to the latest version of MS Access. The application connects to a database backend that has 10 tables. Please provide your quotes for the database upgrade. Any other solutions you can give are welcome too.