Add columns sqlite database jobs

Hallo, I have a small, unstructured CSV file containing raw data, but it's in unstructured format within a single row. I need this file formatted using Python so the data can be properly analyzed and interpreted. Key Requirements: - Transforming unstructured file with structured format - Breaking down the data into relevant columns - Ensuring data integrity throughout the process - Generating a new CSV file with the reformatted data Ideal Skills: - Proficient in Python, particularly in working with CSV files - Strong attention to detail to avoid data loss or corruption - Previous experience in data formatting and transformation - Ability to deliver accurate and efficient output within a short timeframe.

I'm looking for an expert to create a web-based CRM database aimed at efficiently storing and managing information. The data I intend to keep include: - Customer contact details - Sales history - Communication logs - Course details - Course Refresher notifications This project also requires the creation of functionalities to: - Add new contacts - Update existing contact information - Track sales performance Ideal freelancers should have substantial experience in CRM database development, with knowledge of implementing web-based solutions. Familiarity with training or course-based entities would be a bonus. Your expertise ought to allow seamless additions, updates, and performance tracking of stored information. Demonstrable success in similar projects will be ...

We are developing a spreadsheet-based database of the most popular English quotations (or English translations), and are looking for a researcher with native English language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the use of existing source mate...

I have two images of vans, I want to add my logo to both vans on the side of each van and put both vans on one image (adjust the brightness so it looks like they are on same location. And then put them both on a background of a British street location.

I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.

I'm seeking a proficient Access Database designer to build an advanced and fully functional task management system. Key Features: - Data Entry Forms: These should be user-friendly and designed for efficiency. - Reporting and Analysis Tools: I need to be able to easily track productivity and analyze task-related metrics. - Data Validation Rules: The system needs to ensure the accuracy of inputted data with stringent validation rules. Structure: The database should consist of 5-10 interlinked tables for comprehensive task tracking and management. Ideal skills and experience for this job would include: - Extensive experience with Access database design, specifically around task management systems. - Strong ability to translate user needs into functional system fe...

I'm seeking an experienced freelancer with strong attention to detail to perform data entry into my database. The data to be entered is text-based and extracted from various sources which may have distinct formats. Below are specifics about the job: - Handling Text Data: The job will entail entering a variety of text data into the designated database. - Format Diversity: The data comes from diverse sources, so it does not adhere to a specific format. The ideal candidate must be adaptable in handling different data formats. - Correcting Discrepancies: The freelancer will need to spot and correct discrepancies or inconsistencies within the data sources. Accuracy and keenness to details will be crucial. Ideal Skills: - Proficient in data entry - Strong attention to d...

I'm looking for a skilled professional to improve the accuracy of my cloud-based database. To achieve this, the tasks at hand include: - Identifying and removing duplicate entries - Standardizing data formats to ensure consistency - Conducting routine data cleaning checks to maintain accuracy Ideal candidates should have: - Proven experience in data cleaning and management - A deep understanding of cloud-based database systems - Strong communication skills as I prefer to get updates and progress reports through an instant messaging app.

I have a 1-page Excel spreadsheet with 9 text columns that need to be merged. I'm looking for someone who can start this job immediately and has experience in Excel data manipulation and formatting. Please only bid if you can do this job immediately and I will award and give you the file.

I'm seeking an experienced developer to create an online script that can automate the conversion of CSV files. Script must be browser based and linux based. No preference on programming language. Source file will need to be uploaded to CSV converter, and script will sort data and rename columns based of pre-existing requirements. Once conversion is finished, download link generated to download updated CSV.

...focus will be on using the Yoast Plugin to enhance Product titles. Increasing the word count of Product descriptions to around 230 words (sometimes creating from scratch using other sites as reference and or using AI to help), then creating search engine title and focus keywords and repairing URL structures if needed. If working through CSV is easier, a data export can be sent with relevant data columns. Key Responsibilities: - Enhancing product descriptions for improved SEO performance - Optimizing meta tags to drive more organic search traffic - Restructuring URLs to align with best SEO practices - Utilizing Yoast Plugin to ensure optimal SEO efficiency for delivery area audience Please submit a detailed project proposal outlining: - Your experience with Shopify SEO and any ...

I'm searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solutions according to the basic complex...

I am experiencing slow query processing and management issues with large ...experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall d...

...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 table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush order, Mode of delivery, Drop sequence, PP number, Delivery date, Weight, Volume, Addressee, Name of addressee, Deliver address addressee, ZIP/postal Code, Delivery in...

...currently in need of a professional who can assist in completing a database for over +14000 companies. The goal of this project is to generate high-quality sales leads. Key Project Details: - You will be required to include accurate and up-to-date contact information including phone numbers and email addresses. - In addition to the contact details, each company's key contact person's name must also be included in the database. The ideal freelancer for this project will have: - Prior experience with database generation and management. - Proficiency in data mining and web scraping techniques. - Exceptional attention to detail to ensure accuracy of information. - Proven track record in generating sales leads through database creation. This project i...

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 - Strong communication skills to understand any addition...

We are a manufacturing company in need of skilled freelancers to quickly create a total of 480 product renderings from provided CAD drawings. Products include columns, decorative brackets, pergolas, railing systems, cornices/mouldings, etc. Scope of Work: 1. Create product renderings from provided CAD drawings. Requirements: • Proven experience in object rendering. • Ability to deliver high-quality work under tight deadlines. • Excellent attention to detail. Timeframe: We are looking to have this project completed as soon as possible. Please mention your estimated completion time in your proposal. Application: Please include examples of previous similar work and your proposed timeline for completion. Bids without examples and a clear timeline will not be conside...

...involves migrating a medium-sized database (between 1GB and 10GB) to Oracle, and optimizing its performance. The database schema will also need to be designed, as this is not yet finalized. Key responsibilities include: - Migrating existing data: I need an expert who can handle this without losing any data or causing downtime. - Performance optimization: Once the data is migrated, the database needs to be optimized for speed and efficiency. - Designing the database schema: Your ability to design a schema that aligns with our business goals is critical for this project’s success. Ideal candidates should have extensive experience in Oracle database development, with a focus on data migration and performance optimization. A proven track record in ...

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 checkli...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 hav...

Hi, Nee one simple PhP,MySQL app which will 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

I am in need...Access specialist to create a straightforward database. The main aim of this project is the production of a simple database with a focus on data reporting. Key Points: - The database is intended for data reporting purposes. - There will be 1-5 different types of data entries (tables) in this database. - The final database should be equipped for generating various types of reports from the data it contains. - I am looking for a freelancer who can also document the database effectively. Ideal Skills and Experience: - Experience in designing and building Microsoft Access databases, specifically with a focus on reporting. - Strong knowledge of structuring databases for efficient reporting. - Ability to provide clear and concise docume...

...design, inner grid should take 1300px, if you decide to go fullwidth is also possible - we need also show of available positions - output can be JPG, PNG or figma/sketch designs Favorite designs - - - Contents of webdesign of HP in order from top to bottom - Main slider with claim, menu and logo and some call to action button - 3 columns of services - like For Employees, For Employers, Consulting - list of open positions for employees, nicely designed - why to work with us, and some numbers (jobs per month / whatever) - about us - services provided - contact with ability to reserve meeting via Google Calendar - contact form - footer with some basic info (contacts, menu, socials) Very nice inspirations: -

...a talented and detail-oriented designer to create an eye-catching front elevation for my single-floor house, based on a traditional style. Key Requirements: - Style: The design should reflect traditional aesthetics. - Materials: Incorporate a mix of glass, wood, stone, or any materials that could enhance the visual appeal. - Features: I would like the design to include a porch, balcony, and columns. Your Proposal: - Submit a portfolio showcasing your design skills, particularly in traditional architecture. - Provide a detailed proposal that outlines your approach to this project. - Budget is open to negotiation based on your experience and the quality of your proposal. Ideal Skills: - Proficiency in architectural design software. - Experience in traditional design. - A stron...

You will need to visit and search for the following categories. Drainage Glazing repair Appliance repair Plumber Electrician Roofer Use the postcode W2 4DP After you have the search results You will need to open a google sheet and have the following categories Name of Business Website (you will need to find this either from checkatrade or google if you use google do not put LTD on the end) Companies house link for each business use this link The task is to complete 500 companies - please bid knowing this and only bid if you read the brief and understand it

I have a STEP file of a PCB that includes submodels of various components. Each submodel is named by the component, e.g., resistor 0402. I need someone experienced to identify and accurately place components (e.g., resistors) in the STEP file. Attention to detail and precision are crucial for this job. Start comment with fustion3

...(adding) the scores (easy), but then counting number of values 'summed', and dividing the total sum by the number of values counted. The objective is to write a formula that adds up the various scores, divides it by the number of answers provided (i.e., doesn't count questions they skip), and generates a total score. In the attached image, I entered this data manually in Columns G and used a basic formula in column H. It is columns G and H that I am looking to automate based on user data entered in column F (which will initially start off blank). I need to replicate this formula 125x, and so would also like you to walk me through the formulas. This task requires a good understanding of data manipulation within Excel. Skills and experience ideal for thi...

I'm currently experiencing database connection errors on my Wordpress website. Key Requirements: - Fix database connection errors causing website load problems - Ensure the website is running smoothly and all features are fully functional - Full access to the website's hosting account and database for troubleshooting - Clear and timely communication using instant messaging for updates and feedback Ideal Skills and Experience: - Proven experience in resolving database connection errors on Wordpress websites - Strong understanding of database management and troubleshooting in Wordpress - Excellent problem-solving skills and ability to work efficiently - Previous experience in instant messaging for client communication is a plus Had issues lik...

I built this web page: I've started building a new web page but I need these links added in and styled: EE Event: Music & The Spoken Word + Temple Square Tour: Open House:

I'm in urgent need of a professional web developer with experience in creating automation tools. We're looking to build a sophisticated website and dashboard, which will be later integrated with API and MySQL. The final product should be a robust, blockchain-based automation platform. Key responsibilities include: - Building a website and dashboard from scratch - Implementing blockchain technology for automation - Ensuring seamless integration with API and MySQL The ideal freelancer should have: - Extensive experience in web development, particularly in creating automation tools - Proven track record in implementing blockchain technology - Strong understanding of API and MySQL integration - Ability to deliver high-quality work within a short timeframe This is an urgent project...

I'm looking for a professional Flask and Python developer to help me implement a user management system for my website. The user management system should have Social Media login integration. Additionally, I would like the selected developer to set up a payment gateway and a MySQL database. Ideal Skills: - Proficient in Flask and Python - Experience in implementing user management systems with social media login integration - Proficient in setting up payment gateways - Proficient in working with MySQL databases

I'm in need of an expert to assist me with hosting my custom Laravel project on my Plesk panel. Key Tasks: - Setting up the Laravel project on my existing Plesk server - Ensuring that the server environment is compatible with a custom application - Make the project work in the panel exactly as it is running in my local machine - Configure SQlite also Ideal Skills: - Proficient in Laravel framework - Experience with Plesk panel setup - Ability to troubleshoot server-related issues - Knowledge of PHP extensions and versions Your expertise in Laravel and server management will be crucial for this project. Please include any previous similar projects you've worked on in your proposal.

...programming abilities Tasks: - Develop the User Interface: Design a user-friendly interface using SwiftUI. Implement UI components such as progress bars, buttons, and status indicators. - Implement Core Functionalities: Use Alamofire for handling firmware downloads. Utilize libimobiledevice for interacting with iOS devices to enter recovery mode, DFU mode, and perform restores. Use Core Data or SQLite for storing downloaded firmware files and application data. - Integrate Reactive Programming: Use Combine to manage asynchronous tasks and data binding. Update UI elements in real-time based on data changes and user interactions. - Leverage Machine Learning: Implement Core ML models to predict device issues and suggest solutions. Use NLP to develop an AI-powered assistant for us...

I am in need of a technophile with expertise in Microsoft Access databases. Your task will involve: - Populating my database with customer data which includes names, addresses, phone numbers, organisation affiliations, and details of last interactions. - Inputting sales transactions data which include dates, product names, and prices. The ideal freelancer should demonstrate an adept understanding of database management, particularly Microsoft Access, and be able to accurately input data with keen attention to details. Efficiency, accuracy and attention to detail will be paramount for this project.

I'm looking for a detail-oriented individual to assist with a data entry project. The task involves entering a variety of data types including numeric, text, and alphanumeric, into an Excel file. Key Details: - You will be working with a spreadsheet that has more than 10 columns. - I require the data to be formatted in a specific way: - Color coding: Certain cells should be filled with specific colors. - Conditional formatting: Cells should be formatted based on specific criteria. - Data validation rules: Certain cells should only accept specific types of data. Skills required: - Proficiency in Excel, including experience with conditional formatting, data validation, and color coding. - Strong attention to detail to ensure accurate data entry. - Efficient and re...

...functionality. The table should be responsive and able to handle multiple columns. Here are the specific requirements for the project: *** DO NOT BID ON THIS PROJECT IF YOU HAVE NO UNDERSATNDING OF BOOTSTRAP OR SOME IDEA OF THIS PROJECT. A TEMPORAY SKETCH LAYOUT WITH A SAMPLE WITH BE APPRICATED TO HELP US IN MAKING A DECISON WHO TO AWARD THE PROJECT TO. *** Functionality: - Advanced filtering: The table should allow users to filter data based on multiple columns. - Custom filtering: Users should be able to specify criteria for filtering. Responsiveness: - The Bootstrap table should be responsive, ensuring optimal user experience across different devices and screen sizes. Columns: - The table will have 4-7 columns, which should be properly displayed and o...

I have a multi-story building project that requires an experienced structural engineer. Your primary task would be to evaluate the necessity of central RC columns in the building by checking the load distribution from the provided load calculation sheets. Key responsibilities: - Evaluate the need for central RC columns in a multi-story building - Thoroughly analyze the provided load calculation sheets for structural integrity - Provide alternative design solutions if necessary Ideal skills for this job would include: - Professional experience in structural engineering, especially for multi-story buildings - Expertise in evaluating load distribution and structural integrity - Ability to provide alternative design solutions based on your analysis Your work will greatly influ...

Hey guys, i need very small help, i use this plugin Loan Comparison its wordpress plugin, what i need its just Add a button, Let me explain to you. in Settings To add banks, there is a just 1 link opition, its to Apply Now when i add link there i see it like here What i need its to add another opition to add any other link, when i add it its show me another button under Apply Now, pls look to this site and go down a littel you will see 2 Claim Read Review i need just to add Read Review button :) i need it now

I'm in need of a skilled WordPress developer who can help me in optimising my WordPress site, https://feufo.com. I require a comprehensive set of services that include: - Speed Optimisation: My website needs to load faster. This includes improving the page load time, optimising server response time, and minimizing browser render time. - SEO Optimisation: I need to enhance my website's SEO with a focus on keyword research and optimisation. In addition, I'd like assistance in creating a privacy page on my website. This page should clearly outline the privacy policy of the site and be in line with current legal requirements. Ideal candidates for this project should have: - Proven experience in WordPress site optimisation - In-depth understanding of SEO strategies - Stro...

...experienced individual to fill the role of Database Architect/Lead Developer specializing in Netezza and Oracle databases. The ideal candidate will be responsible for designing, implementing, and maintaining database solutions that meet the needs of our organization. This role requires strong technical expertise in both Netezza and Oracle platforms, as well as leadership capabilities to guide a team of developers. Responsibilities  Design and implement efficient database solutions for our organization, leveraging Netezza and Oracle technologies.  Lead a team of developers in the implementation and maintenance of database systems.  Collaborate with other stakeholders to gather requirements and define database architecture to meet business needs.  O...

I have to transfer data and tables from oracle to postgres.

As trading markets speed up to a millisecond pace, I need a tool that offers a competitive edge. I'm specifically looking for a PC program that can live monitor order flow in a DOM (Depth of Market), successfully identify three-digit numbers and subsequently provide a sound alert to noti...triggered whenever a three-digit number pops up. Ideal Skills and Experience: - Proficient in programming languages (especially Python, Java, C++) - Experience in developing real-time monitoring software - Understanding of trading platforms and order flow software - Excellent problem-solving abilities to tackle the challenge of rapid data change. - Be aware of the attached image: The 2 vertical columns (Buy and Sell), that is where the numbers are changing continously and to catch the three...

...Results card layout improvements: a) Currently, for layout with multiple laptops per row, it shows specs only on mouse-over, lets remove that and show that in the card itself, between the laptop image and the hyperlink of the laptop title. Lower the font a little bit and add a special css class to control the style of the specs. b) The cards need a bit more padding/margin so they dont look too crowded with information. Show Details popup: c) Show details popup needs to occupy 90% of the screen width showing the specs in two columns and have a nice border and a thin scrollbar if the content does not all show in one screen. Description/Name should only show first 250 characters with 3 dots and a "more" link that when clicked expands to show all and then shows &quo...

I have a significant amount of text data from physical documents which I need entered into a database. The ideal candidate will have experience with both data entry and database management. Key Project Requirements: - Data Entry: You will be responsible for accurately transcribing text data from physical documents into a digital format. - Database Management: The entered data needs to be organized correctly in the database. Prior experience in managing databases is essential. Ideal Skills and Experience: - Proficiency in data entry - Strong attention to detail - Experience in database management - Familiarity with data organization techniques I'm looking for someone who can complete this efficiently and accurately.

I need a professional to customize the invoice and sales quotation layouts on my Odoo 12 instance hosted in Google Cloud. The project involves: - Customizing the 'Header' section by changing the font style and size. Additionally, you'll be required to incorporate a company logo as well as a company stamp in the footer. - The 'Order Summary' section may involve rearranging columns, adding additional columns, customizing subtotals as well as adding a background image to the bottom of the layout. Ideal candidates should have: - Proficiency in Odoo 12 and experience in customizing its modules. - Strong background in Linux VM, specifically Ubuntu 18, and Google Cloud hosting. - A keen eye for design aesthetics and the ability to translate my requirements...

[URGENT] Finish by today My existing iOS application is built in Swift and I'm looking to add a new functionality. The app currently utilizes the LIDAR sensor available in Iphone 12+. It allows user to take picture which also saves depthmap and other variables such as distance from phone to the object in the center of the screen and etc to the files app. I would like you to: - Instead of saving the image,depthmap and other variables (current in a json file) in the files app - Send the images and other data to a server via HTTP post request, and display the received processed image back from the server on the screen along with other data as well. Budget is only $150 as this is a 3 hours work max. Ideal Skills and Experience: - Proficient in Swift and iOS app development - Ex...

Seeking a proficient individual who is knowledgeable in Excel for data entry and calculation formula tasks. The project involves: - Manual data entry - Creating complex formulas - Maintaining a spreadsheet with 10-50 columns and rows Ideal skills and qualifications: - A high degree of precision and accuracy in data entry - Strong knowledge of, and experience with, Excel and its formulas. I would like my 24 month forecast converted to an excel spreadsheet so i can adjust inputs and project further.

I need a professional to create an ER diagram for a moderately complex database I'm designing. - This is specifically for database design purposes, using Chen notation. - The database structure I have in mind falls between 10-20 entities, so the ER diagram will need to reflect this level of complexity. - You should have in-depth experience with database design and ER diagramming, particularly using Chen notation. - The ER diagram should be clear, well-structured and accurately represent the relationships and entities within the database. - Previous experience with similar projects is a plus.

I'm seeking a FileMaker Pro expert to modify the existing project database for our small architecture firm. Your main tasks include: - Rectifying existing bugs - Enhancing reporting capacity - Introducing new mapping features, if possible. Some issues have been detected in the current system with features not working properly, particularly in the reporting capacity. A new mapping feature is optional and can be discussed further. There isn't a strict time frame for project completion, but I'm hoping to get it done as soon as possible. Ideally, the applicant should have a strong background in FileMaker, bug fixing and data mapping.

I am in need of a Laravel Developer to work on my website. The changes involve backend functionality and database modifications. Ideal Skills: - Strong experience with Laravel - Expertise in backend development - Proven track record of database modifications Tasks Include: - Implementing API integration, specifically e-commerce APIs - Database modification to accommodate new functionalities I need someone with a high level of expertise in Laravel and backend development. Your ability to integrate e-commerce APIs and modify the database accordingly is crucial for the success of this project. Your focus will be on enhancing the backend functionality, ensuring it's robust and efficient. Your attention to detail and ability to work independently will be high...

...can help me create a movie database website that is connected to a Telegram bot. Key Features: - Movie Database Website: The core of the project is to build a movie database that's user-friendly and comprehensive. - Telegram Bot Integration: I need a Telegram bot that can seamlessly connect to my movie database. The bot should be able to handle user queries and provide relevant movie recommendations. Telegram Bot Functionalities: - Movie Search & Recommendation: Users should be able to search for movies based on different criteria and receive tailored recommendations. - URL Shortener: The bot should be able to generate a shortened URL for the movie being recommended. Ideal Skills and Experience: - Proficiency in web development, particularly in ...