Databases Projects

Create FTP server to use filezilla

I need to setup a Server (FTP) to use filezilla. - I need to know the most cost effective way to set this up either via Azure or another provider. I can provide further details if needed

Shopify CSV File Formatting

I am having trouble importing a CSV file for Shopify, I need someone to fix the formatting issues so that I can seamlessly import my products. There are 350 products in the doc to review. I believe this is a quick and easy tasks for someone who knows what they are looking for. Shopify help has provided me with the following response, to which I have followed ... "Upon reviewing your CSV file, I noticed that there might be some formatting issues causing the import to fail. Here are a few things you can try: Make sure all text fields are enclosed in quotes. This includes the Title, Body (HTML), Vendor, and Type fields. Ensure that there are no extra commas within any of the fields. Extra commas can cause the import to fail because the system interprets them as field separators. Check for any special characters in your CSV file. Special characters can sometimes cause issues with the import process. Try saving your CSV file with UTF-8 encoding. This can help prevent issues with special characters." Looking for a quick turnaround.

I need a remote mobile system.

I am currently based in the United Kingdom I have an employee who is based in the Philippines. He will be contacting people as a UK representative. I have found multiple vibe systems that allow me to give him a UK number to call UK customers however, my business only uses mobile numbers and he will need to be able to send SMS and call as if he was based in UK in high definition. I am not looking for e Sims because I want the cheapest option. I don't mind getting him a mobile contract in UK if I can somehow connect it to his laptop in the Philippines so he can make calls and SMS messages in Philippines via UK SIM. I have found one app that is very good which is Windows link however they require you to be connected over the web and Bluetooth so that would not work if it was just where but that would have been perfect

Duplicated database

My company has all crucial files and document in google drive and we need a person who can create a duplicated database to prevent document lost.

Website scrapping

I need someone to scrape a website and export the database that is in in excel format and download any CVs loaded there, attach them to reciprocal excel record and have them separately as well. I have access codes. https://jobcare.eu/

opportunity

Need a full stack developer

The project at hand is an ambitious and critical initiative, requiring a seasoned developer with a comprehensive skill set in cloud integration, specifically with Oracle Cloud Infrastructure (OCI). We are in search of a professional who can seamlessly transition our current system from AWS to OCI, ensuring that the authentication and API services are robustly integrated with our already established front-end architecture. This project is segmented into three primary milestones: OCI Integration: The successful candidate will be responsible for integrating OCI authentication and API services with the existing front-end, maintaining system integrity and ensuring seamless functionality. Minimum Viable Product (MVP) Development: Following the successful integration, the developer will focus on creating a functional MVP, incorporating essential features and capabilities that align with our project objectives. Complete Product Development: The final stage involves the full-scale development of the product, enriching it with features, optimizing performance, and refining user experience to meet the high standards expected in healthcare-related applications. We have allocated a total budget of $10,000 for the completion of this project, which will be released in phases corresponding to the successful completion of the outlined milestones. This is a healthcare-centric project, necessitating impeccable attention to detail and robust communication skills to ensure that the end product not only meets but exceeds the stringent requirements of healthcare applications. We invite proposals to begin with the word "Avocado" to ensure attention to detail and compliance with project prerequisites. The core technologies for this project include: Front-End Framework: React coupled with TypeScript Styling and Component Libraries: SCSS, Tailwind, and Material-UI (MUI) Back-End Services: Firebase, inclusive of Cloud Functions, databases, and authentication services. However, we remain open to alternatives that synergize with OCI. Cloud Infrastructure: Oracle Cloud, with a mandatory requirement for experience in this domain. Potential candidates are encouraged to outline their proficiency with the mentioned tech stack and any additional technologies they are adept in and prefer to employ. It is essential for applicants to demonstrate their capability and experience with Oracle Cloud to be considered for this role.

opportunity

Sage ACT Data base

I need help changing an existing ACT database. I have an existing ACT database listed under Contacts. I need it changed to Companies

Malicious Code Removal

I host with BlueHost and have experienced a Phishing attack. Bluehost have identified the code and I need someone that can remove this. Quick easy job for someone that understands this

Power BI Real Time Data Optimisation

I am monitoring a number of sensors which get polled via Modbus every second. This data goes straight to an SQL Database on AZURE. The data is pulled into Power BI via partitioned table - 1 day is 'archived', 1 day in 'incremental' and real time is enabled. Various Dax queries are used to return the most recent values as well as add some together to total various sensor data together. However the reports are not refreshing as quick as I need - I need them to refresh every second for some data. I am looking for someone who has specific experience with real time data in PowerBI to analyse my reports and DAX queries, and suggest improvements to make it real time.

I want to create a QR code system to scan and verify results

We are an accountancy business. We provide Accountant Reference Letters and verify/ authorise important information for our clients. We usually prepare a letter on our company letterhead, sign and stamp it. Then we share with clients mostly via email. I am interested in to establish a system where recipient of the letter can verify details of letter just by scanning the Code which will be provided on letter. For example, we enter our reference, date, subject, reason of letter, sender, receiver details. So we wish that once someone SCAN the CODE, they shall be able to see and verify the authenticity of document. Another example, someone attested a document for us and put a QR Code. When we SCAN the Code, we are able to see same letter as PDF online. Another example, during Covid, one was able to verify COVID PASS from NHS (UK) online by scanning barcode. We wish to see functionality and how it can be done. Our budget is flexible for the right person.

opportunity

Format PowerPoint Presentations And Ms Word Hand outs

I am looking for a freelancer who can format PowerPoint presentations and MS Word handouts for my project. Formatting Requirements: - Content organization: I need assistance in organizing the content of the presentations and handouts. Quantity: - More than 7 presentations and handouts need to be formatted. Style Guide/Design Preference: - I do not have a specific style guide or design preference. I am open to any suggestions and ideas. Ideal Skills and Experience: - Proficiency in PowerPoint and MS Word formatting - Strong organizational skills - Creativity in design and layout - Attention to detail If you can provide professional formatting services and have the skills and experience mentioned above, please bid on this project.

opportunity

Create reports and maintain Spreadsheet

Overview: I am looking for a professional who can create financial reports and maintain a spreadsheet for my business. The ideal candidate should have experience in generating financial reports and working with spreadsheets. Requirements: - Ability to create accurate and detailed financial reports - Proficiency in using spreadsheet software (e.g., Microsoft Excel, Google Sheets) - Strong understanding of financial concepts and terminology - Experience in data collection and organization - Attention to detail to ensure accurate data entry and calculations Responsibilities: - Generate monthly financial reports based on the provided data - Collect and organize data from various sources, including existing data and newly collected data - Maintain and update the spreadsheet regularly to reflect the latest financial information - Verify the accuracy of the data and reports to ensure reliable information for decision-making Skills and Experience: - Proven experience in creating financial reports, preferably in a business or finance setting - Proficiency in using spreadsheet software and advanced functions for data analysis - Knowledge of financial analysis techniques and metrics - Strong organizational skills to manage and categorize data effectively - Attention to detail and ability to spot errors or discrepancies in the data Note: The frequency of these reports will be monthly. The selected candidate should be able to deliver

Advanced mySQL engineer

Looking for an expert in mysql to help us out with an implementation project. - Working with mysql8.0 - Must be able to setup and implement innodb encryption at rest - must know about keygeneration plugins - must know how to implement encryption in transit (ssl) - We are currently using a WHM/Cpanel environment (AlmaLinux8) on AWS. Please address the following in your application: - Have you worked with innodb encryption before - do you know how to setup and configure mysql from scratch - have you worked with whm/cpanel before? You will not be given direct access to the servers, but instead will need to provide instruction to our engineers to implement, due to security protocols we are required to maintain.

opportunity

Automation and Database Creation of a Wordpress Membership Site

I need to integrate a database for a built WordPress membership website, optimise the load speed of the various pages, and automate membership responses for various levels (welcome messaging etc... integration, bulk member loading via CSV, bulk authorising via PaidMembershipPro plugin - and bespoke coding, links to external CRM or GCP). Knowledge of PHP coding, website optimisation, and back-end integration using specific membership and website speed optimisation plugins, Elementor, and Siteground essential. Please have careful considerations of the requirements: https://docs.google.com/document/d/16KzWeL_13CbWzJg9i-N_3FIUn4tW6W7vVrbegexwleA/edit?usp=sharing

Looking for experienced AWS DevOps to clone one a/c to another

I am looking for AWS DevOps/Sys admin to help in cloning existing AWS account to new AWS account which includes AWS EC2 / RDS / LB and S3 bucket and also require to create Jenkins and CI/CD Pipeline. I am also an experience Infra tech person but have limited knowledge of AWS. I will share VM details with admin credentials to work with us during working hours to complete the work with in 2 days.

UK Postal Data - Clean and Sort

Hello, We are looking for a freelancer to amend/fix UK postal addresses on a regular basis. They are in spreadsheets, however some are incorrectly formatted. Running this again. This can be done with Royal Mail PAF or similar

Windows Support Engineer

Hello I need a server expert for transferring data from one host to another shopify website. Look forward to hearing from you soon. Best regards

I am trying to establish a Relationship Database.

I am trying to establish a Relationship Database. This is an example of the interface I would like to achieve. Is it possible with Google Sheets, or do we need something like FileMaker Pro?

Create MySQL Database and Connection

I am looking to create a mySQL database using Oracle and I require the setup and connection to the database via another web product Skyvia. I have the Oracle account and the Virtual Network and I have created the Instance and Database. I require someone to check the setup and edit where applicable and then provide a connection onto skyvia.com which is a website that connects services. We use Sugar CRM and the purpose of the database is use Skyvia to export data into MySQL. I can run through the Skyvia account and the existing Cloud account in more detail as we start discussions.