Databases Projects
Looking for freelance Databases jobs and project work? PeoplePerHour has you covered.
Kanban Stock Card Generator
A Kanban stock card generator is a tool used in the Kanban methodology to manage inventory and production. It consists of cards that represent tasks or items in a workflow, and it helps to visualize the progress of tasks and identify bottlenecks. The freelancer will be responsible for building a Kanban stock card generator in Excel, which will enable users to create and print cards. The freelancer will need to have experience with Excel and mail merge, as well as a good understanding of the Kanban methodology. The project will involve the following steps: 1. Review the source file and layout for the Kanban stock cards. 2. Build a functional Kanban stock card generator in Excel. 3. Ensure that the generator is user-friendly and easy to use. 4. Implement features such as card printing and customization. 5. Test the generator thoroughly to ensure that it works correctly. 6. Provide documentation and support to users. The freelancer will be paid based on the project's scope and complexity. We are open to discussing a fixed price or a hourly rate. If you are interested in this project, please submit your proposal, including your experience, skills, and estimated timeline for completion. We look forward to working with you on this project.
a day ago18 proposalsRemoteopportunity
Microsoft Access Database to Microsoft PowerApps
As the title explains, i would like to have my clients MS Access database moved over to an up-to-date solution. I've read a lot about Powerapp / PowerBi. Initially, I'd like to have a detailed conversation with you to go through what's required and hear your suggestions. Currently, the backend of the database is hosted on Microsoft Azure. Any questions, please just ask. Thanks.
3 days ago15 proposalsRemoteEnhanced Accountancy Website Features
Project goal: Integrate advanced features into an existing accountancy website for improved functionality and user engagement. Scope of work: - Integrate a database for various fee packages and pricing options. - Develop an online signing-up process for easy user registration. - Set up an online Direct Debit (DD) process for both fixed and variable payments. - Integrate scheduling tools such as Calendly. - Develop a secure client login/area by integrating Accountancy Manager. - Implement other basic tweaks and changes as needed for website enhancement. Budget: Kindly quote a fixed fee. Additional information: - Open to creative IT skills and ideas for website development. - New ideas for website enhancement are welcome.
4 days ago29 proposalsRemoteopportunity
Development of an Online Database Using Open Source Data APIs
We are seeking proposals for the development of an online database capable of holding and managing a substantial amount of data, with advanced search functionality. The database will be populated and continuously updated using several open-source data APIs. Our existing database contains approximately one million business records, which we seek to enhance and expand through this project. Project Requirements: 1. Database Development: • Design and develop a scalable online database to hold a large volume of data. • Ensure the database supports advanced search capabilities to quickly and efficiently query against the stored data. 2. Data Integration: • Access and extract data from multiple open-source data APIs. • Integrate and normalize data from these sources into a unified format within the database. • Ensure data is regularly updated and synchronized with the latest information available from the APIs. 3. Data Management: • Populate the existing base of approximately one million business records with additional relevant data from the APIs. • Ensure data quality and consistency, removing duplicates and correcting inaccuracies. 4. Technical Specifications: • The database should be accessible online with a user-friendly interface. • Support for exporting data into standard formats such as CSV for offline analysis. • High availability and performance to handle large-scale data queries and updates.
5 days ago35 proposalsRemoteopportunity
Create an extension to extra images from a app using API
We are looking for a skilled freelancer to develop an extension that seamlessly integrates with a delivery app's API. The extension should enable users to extract data about their orders, including images, effortlessly. The primary objective is to automate the process of downloading and organising these images into an Excel sheet. The freelancer should have a solid understanding of the work required. They should be able to work independently and meet deadlines. Experience with similar projects and a portfolio of successful work is highly desired. If you have the expertise I encourage you to bid on it.
6 days ago11 proposalsRemoteYoutube URL scrapping
I need someone to scrap youtube URLs from song titles in a .csv file. It will be an extensive list of around 7,500 - 10,000 titles. I want the URLs added to the URL column in the csv and the file returned.
7 days ago39 proposalsRemoteWebsite Deployment Though Fillzilla
front end Is Next.js, Backend in Node.js and Database in MongoDB i have build for of next.js which is already upload but i can not seen output on IP address
10 days ago19 proposalsRemoteopportunity
Database Administrator / Back-end Developer Required
Hi, I am looking for a Database Administrator / Back-end Developer to complete the given below requirements: Scenario: 1. The store is based on Magento 2.4.6-p3 with all necessary server requirements such as Nginx 1.22, MariaDb 10.6, Varnish cache 7.3, php 8.1, Composer 2.2, Elasticsearch 8.5, MySQL 10.6, RabbitMQ 3.11, Redis 7, etc. 2. The website is hosted on CCX53 on Hetzner Cloud: 32 CPU, 128 GB RAM (dedicated resources) Here are the details of the products present in the database: 1. The store has 320 million products in 411 GB database. There are no product attributes, or variables. Just simple products. 2. There are no product images 3. Each product is a company information page i.e. the products are digital and it provides information on companies globally. I will share the sample product page link once you submit your proposal. Magento Modules Installed and configured: 1. Amasty Elasticsearch: https://amasty.com/elasticsearch-for-magento-2.html 2. Amasty Google Speed Optimiser Pro: https://amasty.com/google-page-speed-optimizer-for-magento-2.html 3. Amasty Varnish Full Page Cache Warmer: https://amasty.com/full-page-cache-warmer-for-magento-2.html Requirements: 1. Import the product database of 411 GB database. I will provide the database in SQL format. 2. Optimise the Elasticsearch and page load 3. We expect 100 concurrent users anytime throughout the day 4. Elasticsearch should index all the products 5. Optimize website performance. Current score on Google page speed insight is 47 on mobile and 83 on Desktop. 6. Product search result should be less than 3 seconds 7. Suggest if the job requires server change
11 days ago24 proposalsRemoteDeploy an Access app
I need help to deploy a secure Access app as a .accde file with runtime environment, installation package, digital ID and DSN-less connections. I want the applicant to show me how to do this myself. Please indicate in your response whether you have done this before.
12 days ago13 proposalsRemotePower automate cloud flow creation
create a powerautomate cloud flow using my AI model to extract info from pdf and rename file in sharepoint folder
13 days ago13 proposalsRemoteopportunity
Develop a simple carbon caculator
Good morning , We are looking for a developer to develop a carbon caculator. The work is a fast turnaround and should be completed by 20th May. We have spreadsheets with back end data and formulas. It should be easily updated with new data available on the free data on Government website. This is just for scope one and two of caculator which is quite simple. The below link shows an example of what we need developing. We want to provide free access like Greenly. The final page can reveal the result. https://greenly.earth/en-gb?utm_term=carbon%20calculator&utm_campaign=1:+SN+%7C+2:+Acquisition+%7C+3:+Search+Generic+Carbon+UK+google+%7C+4:+UK&utm_source=adwords&utm_medium=ppc&hsa_acc=8929442750&hsa_cam=15453379597&hsa_grp=135745822249&hsa_ad=580573821047&hsa_src=g&hsa_tgt=aud-1962306165324:kwd-298447716438&hsa_kw=carbon%20calculator&hsa_mt=b&hsa_net=adwords&hsa_ver=3&gad_source=1&gclid=CjwKCAjwrvyxBhAbEiwAEg_KgnSACrRF3uny2vlBuN356Qmh-dECqos_KMuiSpCceY3wXEu1QQsJ-hoCoSoQAvD_BwE Here is a second example although we want it to look like Greenly. https://www.carbonfootprint.com/calculator.aspx The carbon caculator should be easily updated with new data published each year. This is the new data on the excel https://www.gov.uk/government/publications/greenhouse-gas-reporting-conversion-factors-2023 We can provide formulas. We need passwords and access when project is complete. Thanks, Luke
15 days ago45 proposalsRemoteopportunity
Order Report Program
I need to get a program made wherein we will need to feed in the order received from various libraries for various languages and for various Branches. i.e Library A has 6 Branches, Branch A, B, C, D, E, F and G. And they order per the attached list. We will need a Program, wherein we feed the order for each of the Library Branch-wise and then we supply the books, we can add the data Like Invoice no. Date and then the amount supplied for the language. The Maters we rwequire for this will be: 1. Library name alongwith the details of Various Branches, Their Budget for Various languages, with different classification Fiction, Non Fiction, Children and Dual Language books- The budget amount for each category and then as and when we supply anything, we will add the Invoice number, Date and Amount spent for the language with its category ( Fiction, Non-Fiction-Children, Dual language), as also the Quantity ( Number of books Supplied). I must mention that each Invoice will have only one language and one category of the category. The Budgets we get are pertaining a one financial year. As such we will also require the provision to close one budget and start a new one. The purpose of this program will be to prepare a report at any particular time, wherein it will provide as to how much amount of books for each category has been supplied to a particular branch, and what amount is left in the budget that needs to be supplied. We would require to take out such reports on regular basis.
17 days ago21 proposalsRemoteopportunity
I need a list of 500 donors and sponsors for disaster relief
I'm in need of a professional who can provide me with a comprehensive list of international donors, specifically targeting individual donors,Not for profit organisations,and corporate sponsors. This list will be instrumental in supporting my fundraising efforts for disaster relief. Key Tasks: - Compiled list of international donors who are known for their philanthropic activities in disaster relief. - Include contact information (email, phone numbers, etc.) for each entry. - Ensure the list is up-to-date and relevant. Ideal Skills and Experience: - Proven track record in fundraising and donor research, preferably in the disaster relief sector. Strong understanding of the nuances of individual donor engagement. - Excellent research and database management skills. - Great attention to detail and accuracy in compiling information. I'm open to discussing the compensation for this work, so please don't hesitate to reach out to me to discuss a potential deal.
17 days ago12 proposalsRemoteopportunity
Excel Data Consolidate&CSV Formatting for Shopify Product Upload
We are looking for a skilled freelancer to assist us in consolidating data from various product ranges stored in separate Excel sheets. The task involves merging Excel sheets when necessary and pulling relevant data, such as prices, to match product codes from different sheets. The ultimate goal is to generate a comprehensive CSV file that adheres to the required template for Shopify product uploads. Some products contain variants, which requires expertise in bulk Shopify uploads to ensure accurate listing of main products alongside their variants. Key Responsibilities: - Consolidate data from multiple Excel sheets into a unified file, accommodating products and their variants. - Match product codes with corresponding prices and other essential information, maintaining consistency throughout. - Ensure accuracy and completeness of data across all product entries, including variants. - Format the final CSV file to meet the specifications of the Shopify platform for hassle-free uploading. - Validate the CSV file to verify compatibility and smooth integration with Shopify's product management system. Requirements: - Proficiency in Excel and CSV file manipulation, with a focus on managing product variants. - Experience with bulk Shopify uploads, particularly in accurately listing main products alongside their variants. - Attention to detail and precision in data entry and manipulation tasks. - Ability to meet project deadlines and deliverables effectively. - Strong communication skills to provide regular updates and address any inquiries promptly. If you possess the requisite skills and are interested in collaborating on this project, please submit your proposal detailing your relevant experience and your approach to completing the task. We welcome any portfolio samples or past projects demonstrating your expertise in data management and bulk Shopify uploads, particularly concerning product variants.
18 days ago43 proposalsRemoteopportunity
Creating a SQL database on Google
We are a marketing agency that has built our own custom software. in the course of the upgrade, we are looking to update the location of the database from zapier tables to Google SQL database. We have 12 tables of information that we would like to be newly formatted on Google SQL. You don't need to help with the transfer of data, this would just be about making sure that the SQL database is properly set up. We need a setup of the Google SQL to be able to properly store the 12 tables worth of information, with each field having formatting rules that they would follow. What's more, we will be having AI read from this, so if the data is not properly formatted we would need a rule to revert the data to something that won't confuse the AI.
18 days ago24 proposalsRemoteopportunity
Scorecards and Dashboards
Im looking for somone who can create an automated scorecard and dashboard for a client. You'll need to pull data from several systems and create a good looking dashboard which updates a minimum of daily.
23 days ago47 proposalsRemoteConnect my ChatGPT4.0 to my outlook and Teams
Could you please provide guidance on how to integrate ChatGPT with Microsoft Teams and Microsoft Office Outlook without incurring any additional costs of new tools such as mailMaestro, etc? Thank you for your assistance.
23 days ago10 proposalsRemoteopportunity
I need email addresses for my linkedin contacts database
We have a database of approximately 6,500 LinkedIn contacts, and unfortunately, the email addresses of many contacts are missing. Our goal is to find a freelancer who can help us update the database with valid email addresses. The freelancer should have experience in data mining, web scraping, or any other method that can help them extract email addresses from LinkedIn profiles. The project requires the freelancer to work remotely and should be completed within a reasonable timeframe. We are willing to provide additional information and support to the freelancer throughout the project. If you are interested in this project, please submit your proposal, including your estimated cost and timeline. We look forward to hearing from you and discussing the details further.
24 days ago73 proposalsRemoteCollecting Information From Online Profiles
Hi there We are looking for a freelancer who can collect information on a list of 1000 profile links and paste into a spreadsheet. The information we need to collect from the profiles are Business Name Website Address Mobile Number Landline Number Email Address Thanks for reading.
25 days ago77 proposalsRemote
Past Projects
5171 error on a SQL database MDF
can any one help with above error we have a 1.6gb database which will not attach