Database query csv file jobs
...backend of the search engine for users to search results from the indexed data. • Features: • Simple, user-friendly interface for searching indexed data. • Fast and relevant search results. • Results should be displayed with the most relevant information at the top (based on keyword match, ranking, etc.). 5. Database Integration: • Purpose: Set up a database to store and manage crawled data and indexes. • Features: • Use a scalable database like MySQL, PostgreSQL, or MongoDB. • Efficient query handling to fetch search results quickly. 6. Scalability & Performance: • Goal: Ensure the entire system is optimized for performance, scalability, and reliability. • Details: The search engine should handle a larg...
...backend of the search engine for users to search results from the indexed data. • Features: • Simple, user-friendly interface for searching indexed data. • Fast and relevant search results. • Results should be displayed with the most relevant information at the top (based on keyword match, ranking, etc.). 5. Database Integration: • Purpose: Set up a database to store and manage crawled data and indexes. • Features: • Use a scalable database like MySQL, PostgreSQL, or MongoDB. • Efficient query handling to fetch search results quickly. 6. Scalability & Performance: • Goal: Ensure the entire system is optimized for performance, scalability, and reliability. • Details: The search engine should handle a larg...
I am in need of a Microsoft Visual Studio expert with extensive experience in Visual Basic and database applications. I am currently developing a database application and require assistance with Microsoft Visual Studio. - **Skills Needed**: - Proficient in Visual Basic - Expertise in Microsoft Visual Studio - Experience with developing database applications - Excellent problem-solving and debugging skills - Familiarity with project setup and extension development in Visual Studio Your role will primarily focus on helping me set up the project correctly and ensuring that all components of the application interact seamlessly. If you are adept at troubleshooting and code debugging, it would be a huge plus. I am looking for someone who can help me make this p...
I have a project in CodeIgniter that was running perfectly, but now it's giving some errors. - Authentication emails aren't sending. - Emails aren't working. - Bulk upload of CSV files aren't working (Some Socket Issue In Network Tab). The application is installed on a VPS and I am using CWP Panel. Therefore, I need an expert in CodeIgniter who is also familiar with CWP Panel. Please type "CI" at the top of your bid so I can see you aren't a bot. Thank you.
...in 20 minutes). I need someone to accomplish two main goals in this project: 1) Modify the code so that only the bare minimum information is listened to in Alchemy to satisfy the requirements: For a given list of market/outcome IDs, once every 60 seconds fetch the object showing the top 10 holders and their number of shares. (And also NOT fetch any other information that will drive up Alchemy query usage.) 2) Configure the code so that it can be dynamic. I can write TypeScript code that will fetch and update a list of market/outcomes every 60 minutes. I just need you to configure the repo's code so that the connection to Alchemy reads in from a dynamic variable (the current list of markets). When you apply, send me an example of related Web3 work that you've done, o...
I'm seeking assistance with modifying a flat file database. The task primarily involves updating existing records. This is a one-time project.
Looking for a Python programmer to do the following: User will press a button. program will activate an output that will turn off at a preset time by the system (Regardless if the user continues to press in the input) The system will then wait a preset time before it will allow the input to activate the out put. Example: Preset on time := 10 Sec. (This s...on (for as long as the user presses the input or 'on time' (10 seconds has been reached) The user can try and press the input in after this but the output will not turn on. until the wait time has reach. Every time they press the input the system will log date and time. Every time the output is on the system will log duration, date and time This will need to be exported to a database where it can be retrieved in a ...
I'm looking for an experienced tutor for an intermediate level session focused on Power Query and Power BI. The session will involve using a practice dataset to clean data, transform it, and merge queries in Power Query. Key Areas of Focus: - Data Cleaning - Data Transformation - Merging Queries In Power BI, we will be concentrating on: - Creating Dashboards - Data Visualization - Automating Reports Ideal candidates should have a strong expertise in Power Query and Power BI, with proven experience in teaching and using practice datasets. Your ability to simplify complex concepts and create a fun, engaging learning environment will be key to a successful session. Please provide examples of previous tutoring sessions you've conducted related to these topics...
I'm looking for someone to develop a practical file for a BTech Computer Science and Engineering workshop. The file will be primarily for educational purposes. Key Components of the Practical File: - A well-structured written section that includes theory explanations - Diagrams relevant to the workshop content - White blank pages for additional notes or observations - Diagrams that will help visualize complex concepts Ideal Freelancer: - a strong background in computer science and engineering - Excellent writing skills - Experience creating educational materials
...protection for data privacy. • Ability to switch profiles within the app. 6. Third-Party Integration: • Integration with Google Fit, Apple Health, and potentially Strava. 7. Social Sharing: • Generate shareable summaries of activity and achievements. • Optional integration with social platforms (e.g., Instagram, Facebook). 8. Data Export: • Export health and activity data in formats like CSV and PDF. 9. Future AI Integration: • Enable personalized insights using AI for health improvement and activity optimization. Technical Requirements • Use the SDK provided by the smart ring manufacturer, which supports Flutter and both iOS and Android platforms. • Ensure secure storage and handling of health data, adhering to GDPR standards....
I'm currently developing an iOS app that leverages the Screentime API and Family Controls. This app involves tracking usage, implementing parental controls, and setting up app restrictions. I'm seeking a seasoned Swift developer who can help troubleshoot coding issues and assist with the setup of specific code segments on a pay-per-query basis. Key Areas of Focus: - Usage tracking: I need guidance on how to implement this feature and help troubleshooting any issues that arise. - Parental controls: I require assistance with feature implementation and bug fixing. - App restrictions: I'm looking for an expert to help optimize performance and address any potential coding issues. Ideal Candidate: - You must be an expert in Swift, with extensive experience in Xcode and iO...
...management, such as notifying agents of assigned orders and allowing them to update the status of deliveries. Reports and analytics should be available for sales data, with an option to download reports in CSV format. Additionally, a mobile-friendly delivery agent portal should be created to let agents view their assigned orders and mark them as delivered. For the technical specifications, I prefer using PHP for the backend, with Laravel or CodeIgniter as the framework. The frontend can be developed using HTML, CSS, and JavaScript, with Bootstrap for responsiveness. MySQL should be used for the database. I already have hosting with Hostinger, so the system should be compatible with their services. Integration with Razorpay or Paytm is required for secure online payments.....
Looking to get a php api that takes a postcode. goes too my database and brings back customer details for that post code. A similar api is written like this so most of code can be copied. Simple project and i need this done today public function geteircode(){ if(isset($_POST['eircode']) && !empty($_POST['eircode'])){ $code = strtr($_POST['eircode'],[' '=>'']); $ir_identifiser = array("A41","A42","A45","A63","A67","A75","A81","A82","A83","A84","A85","A86","A91","A92","A94","A96","A98","C15","D01","D02",...
I'm a recent high school graduate seeking assistance with data entry into my SQL-based database. Ideal Skills: - Proficient in manual data entry - Experienced with SQL databases (e.g., MySQL, PostgreSQL) - Strong attention to detail and accuracy - Good communication skills - Problem-solving abilities
Project Overview: Comprehensive Airport Lounge Database Creation I am seeking a detail-oriented freelancer with strong research and data collection skills to compile a comprehensive and accurate list of airport lounges worldwide. This project focuses on categorizing lounges into the following types: Airline Lounges (operated by an airline) Common-use Lounges (operated by an independent lounge operator) Priority Pass Lounges (similar to common-use lounges but within the Priority Pass network of lounges) The compiled data will be delivered in a well-organized CSV file, suitable for analysis and integration into other platforms. Scope of Work: - Conduct thorough online research using search engines and reliable travel resources to identify airport lounges globally. ...
...Technologies - Flutter (Latest stable version) - Flutter Web - Firebase - Dart (Latest stable version) ### Required Firebase Services Knowledge 1. Firebase Authentication - Email/Password authentication - Phone number verification - Custom claims for role-based access - Security rules implementation 2. Cloud Firestore - Database design and structuring - Query optimization - Indexing - Security rules - Batch operations 3. Firebase Storage - File upload/download - Security rules - Image optimization - Content delivery 4. Firebase Cloud Functions - Background tasks - API endpoints - Scheduled operations - Event triggers ### Required Flutter Expertise 1. State Management - Provider pattern - State lifecycle ...
I'm looking for a freelancer who can help me convert a PDF file into an editable document. This involves typing out the content of the PDF, with the following specific requirements: - The document should be formatted as a simple text format. - Maintaining the original layout is not necessary, but accuracy in transcription is crucial. - Attention to detail and a commitment to producing high-quality work are essential. Ideal skills for this job include strong typing abilities, proficiency with word processing software, and experience with document formatting. Please note, there are no specific sections of the PDF that require prioritization or special attention.
I need assistance with finding product codes (SKU and size in either US or EUR and link for a proof) for 4100 EANs. The data should be sourced from Google or VERY easy because 2 /3 brands only Key Requirements: - Data processing and research skills - Experience with Excel/CSV - Ability to follow a specific format for data input I will provide the EANs in a spreadsheet (Excel/CSV) and I already have a format for the SKU and size. This is a straightforward project that requires basic data input and online research. Please be prepared to work meticulously and efficiently.
I need help adjusting the size and bleed areas on some card files I have. - Current Format: The files are in PDF format. - Task: There are 30 cards (60 pages front and back) that need overall size adjusting according to specific dimensions provided by my card printing manufacturer. All content is already in place, so this is minimal work. - Software: I have tried using Adobe Acrobat for adjustments, but it hasn't been successful. If you have experience with this type of project and are able to help, I would greatly appreciate it. Thank you in advance.
I have multiple Excel files that need to be consolidated into a single Excel workbook. Each file should be placed in a separate sheet named according to its original file name. No data transformations or cleaning are required. Ideal skills for this project include: - Proficiency in Microsoft Excel - Experience in data consolidation tasks - Attention to detail to ensure correct file placement and naming.
I'm looking for a freelancer who can help me convert a PDF file into an editable document. This involves typing out the content of the PDF, with the following specific requirements: - The document should be formatted as a simple text format. - Maintaining the original layout is not necessary, but accuracy in transcription is crucial. - Attention to detail and a commitment to producing high-quality work are essential. Ideal skills for this job include strong typing abilities, proficiency with word processing software, and experience with document formatting. Please note, there are no specific sections of the PDF that require prioritization or special attention.
This project aims to streamline and automate data preparation, analysis, and visualization processes within the tourism sector. By transitioning from manual Excel-based workflows to an automated system using Power BI and Power Query, the project seeks to improve efficiency, accuracy, and decision-making capabilities. Objectives of Dashboards in Power BI Build interactive dashboards to visualize key trends, traveler preferences, and satisfaction levels. Utilize advanced Power BI features such as DAX formulas and custom indicators to provide meaningful insights. Statistical Indicators Generate descriptive statistical measures (e.g., average, median, and standard deviation) directly within Power BI. Use these measures to establish benchmarks and identify trends.
I'm looking for a comprehensive database of 10,000 active job seekers with a focus on entry-level & mid-level Software Development skills. Requirements: - Job seekers should be looking for job in IT field. - Database should include first name, last name, email, and phone number. Please note, the job seekers must be currently seeking IT roles.
I need assistance with my Android app which reads a .bds file from Busy Accounting software's MS Access database. Currently, the app can read the file but cannot update it without causing corruption. I want to be able to add new records and modify existing ones. Key Requirements: - Diagnose and resolve the corruption issue when trying to update the .bds file. - Implement functionality to add new records and modify existing ones from the Android app to the .bds file. Essential Skills: - Experience with Busy Accounting software and .bds file structure. - Proficiency in Android app development, particularly with direct file access. - Knowledge of MS Access database management. Please note, I need a solution that does not require ...
I'm seeking a freelancer who can provide me with a daily supply of up to 30K email addresses of individuals aged between 50 and 60 in the USA. The primary purpose of this email database will be for marketing campaigns, so the emails should be valid and ideally have a history of engagement with similar campaigns. Skills and Experience Required: - Data mining and web scraping - Experience with email list building - Understanding of demographic targeting - Knowledge of email marketing standards Please note, the lists need to be delivered daily, and must be of high quality to ensure maximum deliverability and engagement.
I need a skilled developer to create a .Net core, Web API connected to a MySQL database. The main function of the API will be data retrieval, specifically user data. Key Requirements: - Proficient in .Net core and Web API - Strong experience with MySQL - Previous work with creating APIs for data retrieval - Able to understand and implement secure data retrieval practices Please note that the specifics about the users accessing the system (admin users, end-users/customers, or both) have yet to be determined. However, the API will primarily need to handle requests for user data.
I’m working on an Angular/.NET application with a functional small attachment tab UI and several working APIs. However, I’m facing issues with two APIs: 1. Insert API: Data is not being inserted into the database. 2. Fetch API: Unable to retrieve data properly. Technologies used: - Frontend: Angular - Backend: .NET Core, .net framework - Database: [SQL Server/MySQL, MongoDB.] Deliverables: - Fix the insert and fetch API issues. - Ensure proper testing for functionality.
I need a comprehensive database to streamline my housing assistance work. The system should identify potential housing matches based on both member budgets and location requirements. Key Requirements: - The database should track various rental properties, including their address, type, cost, and availability, as well as landlord contact information. - On the member side, it should store budget limits, preferred locations, and contact details. Ideal Skills: - Database development - Data management - Software development - Ideally, some understanding of housing assistance systems, though not strictly necessary. This database will greatly enhance my efficiency in helping people find homes. Please provide examples of similar projects you have completed.
I'm in need of a Python backend developer, preferably a fresher, with a focus on API development and database management. The project will primarily involve working with SQL databases and leveraging the Django framework. Key Responsibilities: - API Development: Building, testing, and maintaining APIs to support various applications and services. - Database Management: Overseeing the interaction with our SQL databases, ensuring data integrity and optimizing performance. Ideal Skills: - Proficiency in Python, particularly in a backend context. - Familiarity with SQL databases, including basic query writing and database design. - Prior experience or knowledge of the Django framework. - Understanding of API structures and principles. This is a great opportun...
I'm in need of a data entry professional adept at handling mixed data types - both text and numeric. The task involves gathering this data from various websites and compiling it into a CSV file. Key Requirements: - Proficient in data entry with a keen eye for detail - Experience with collecting data from websites - Able to handle mixed data types - Skilled in formatting data into a CSV file Ideal freelancers for this project should have a demonstrated track record of data collection and entry, with the ability to accurately transcribe and format data from diverse web sources.
I'm seeking a freelancer to create an animal database for free use by K-12 students aimed at enhancing environmental education. The comprehensive specifications are attached. Please read the attached project details. Only apply if you're confident in meeting all project objectives and constraints. Key Project Requirements: - Development of an animal database encompassing various information categories as detailed in the attached instructions. - The database must be accessible via a link from an existing environmental education website. Ideal Skills and Experience: - Proficiency in database creation and web development. - Prior experience in educational software development is a plus. - Strong understanding of environmental education content and requi...
I'm looking for a skilled SQL developer to create a query for data retrieval from my MySQL database. Ideal candidates for this project should: - Have extensive experience working with MySQL databases - Possess a strong understanding of SQL syntax and functions - Be capable of writing efficient and effective data retrieval queries.
I'm looking for an experienced ...should calculate: - Weekly and monthly running totals for items sold per store - Total sales across all 5 locations The data points I have include: 1. Date of sale 2. Item 3. Transaction number 4. Price sold at 5. Store # If a customer buys 3 of the same item, it will give me 3 separate lines of data (i.e., all sales listed are quantity of 1). I will be uploading my data weekly through a CSV file into Microsoft Excel. The spreadsheet needs to be able to generate the following reports: - Weekly total sales - Monthly total sales - Item-wise sales per store Ideal candidates for this project should have a strong proficiency in Excel and experience in creating similar data tracking spreadsheets. Please include examples of your previous ...
I need assistance with finding product codes (SKU and size in either US or EUR and link for a proof) for 4100 EANs. The data should be sourced from Google or 1 another website , VERY easy because 2 /3 brand only Key Requirements: - Data processing and research skills - Experience with Excel/CSV - Ability to follow a specific format for data input I will provide the EANs in a spreadsheet (Excel/CSV) and I already have a format for the SKU and size. This is a straightforward project that requires basic data input and online research. Please be prepared to work meticulously and efficiently.
Please Sign Up or Login to see details.
I'm looking for a research assistant who can help me collect and analyze both quantitative and qualitative data for an academic project. Key Responsibilities: - Data Collection: Gather both quantitative and qualitative data relevant to the research. - Data Formatting: Organize and prepare the collected data in Excel/CSV files and Word documents. - Data Analysis: Analyze the data to extract meaningful insights. Ideal Skills: - Proficient in data collection and analysis - Experienced in academic research - Skilled in using Excel and Word - Capable of working with both quantitative and qualitative data. Please, only apply if you're experienced in academic research data collection and analysis.
I'm looking for a professional to compile an extensive list of exhibitors from the Fitur trade show. This list will need to be more than 200 exhibitors and should include: - Company name and contact details - Product or service offerings - Booth number and location The final data should be delivered in a Spreadsheet (Excel/CSV) format. Ideal skills for this job include: - Attention to detail: It's crucial that the information recorded is accurate. - Proficiency in Excel: The final product should be well organized and easy to understand. - Research skills: You may need to look beyond the official exhibitor list to get a comprehensive view. Experience in data compilation and familiarity with trade shows will be an added advantage.
I'm looking for a talented blockchain developer with expertise in Hyperledger Fabric and IPFS to help me transfer my risk register into a hybrid blockchain and IPFS-based database. The main purpose of this project is to enable automated processes through the use of smart contracts. Key Responsibilities: - Develop a hybrid blockchain and IPFS-based database - Transfer the existing risk register into this new database - Implement smart contracts to automate various elements - Ensure the automation of approval workflows, risk assessments, and notifications and alerts Ideal Skills: - Extensive experience in developing with Hyperledger Fabric - Proficiency in working with IPFS - Strong understanding of hybrid blockchain systems - Prior experience with risk managemen...
as discussed in the chat section
I'm seeking a professional to clean up my CSV file, which contains keywords. The data requires moderate corrections for misspellings and the removal of non-alphabet characters while keeping the rows intact. Ideal Skills and Experience: - Proficiency in data cleansing - Experience with CSV files - Attention to detail - Good understanding of English spelling and grammar - Ability to identify and correct moderate misspellings Both attached spreadsheets are lists of keywords for google ads campaigns. I need to removed any NON-alphabet characters in the keywords between the [ ] symbols. It should just be a keyword phrase between the brackets. (nothing else) example characters to be removed !#$&^*(?" or anything else including a "square root" s...
...Stack: Frontend: React: Core frontend framework. TypeScript: For type-safe JavaScript development. Vite: Build tool and development server. Tailwind CSS: Styling and responsive design. Shadcn UI: Pre-built UI components for consistent design. React Router: Client-side routing. React Query: Data fetching, caching, and state management. React Hook Form: Form handling and validation. Backend (Supabase): PostgreSQL: Main database. Supabase Auth: Authentication and user management. Supabase Storage: File storage (e.g., contracts). Supabase Edge Functions: Serverless functions (built with Deno). Supabase Realtime: Real-time features and subscriptions. Third-party Integrations: OpenAI: AI chat functionality for airline and workgroup-specific assistants. ...
I'm in need of an experienced full-stack developer to create a comprehensive database for airport lounges and an accompanying user interface. This project will involve both front-end and back-end development, as well as expert knowledge of database management systems, WordPress integration, and PHP. Key Responsibilities: - Design a database that provides users with information about airport lounges including location, amenities, and access requirements. - Include data on numerous amenities (up to 40) for each airport lounge, such as Wi-Fi, food and beverages, and seating options. - Incorporate various access requirements into the database such as membership type, day pass options, credit card partnerships, and elite status. - Allow users to see if they hav...
I'm looking for an expert in Tableau, specifically for creating interactive dashboards. The data will primarily come from Excel/CSV files, so proficiency with these sources is essential. Ideal Skills: - Extensive experience with Tableau - Proficient in working with Excel/CSV files - Ability to design interactive charts and graphs The dashboard should feature interactive charts and graphs. I'm not looking for a static, one-dimensional dashboard; I need something that can engage users and allow them to explore the data on their own. If you have a proven track record of creating such dashboards and can deliver a high-quality, user-friendly product, I would love to hear from you. My cost is 10USD
...$command = $connection->createCommand("SELECT id FROM product $where"); $result = $command->queryAll(); Potential Causes: Missing Variable Definition: The $where variable might not be properly defined or assigned a value before it's used in the SQL query. Configuration Issue: The migration from cPanel to DirectAdmin might have caused configuration changes that affect how variables are handled within the application. Technical Skills Required: Proficiency in PHP 7 development Experience with the framework Understanding of database queries and variable scoping in PHP Project Deliverables: A fully functional website with the variable not found error resolved. Identification of the root cause of the issue (missing variable definition or configur...
I'm looking for a professional to create a vector gradient file of my logo. - Final file format should be EPS. - I only have a PNG file, so we might need to recreate the "X" for smooth results. - Ideally, you should have experience with graphic design, particularly with creating vector files from raster images. THE FONT USED FOR THE TEXT IS "MONTSERRAT EXTRABOLD" AND THE SPACING IN THE TEXT UNDERNEATH IS "280"
I'm seeki...skilled data entry professional with experience in data cleaning. The job will primarily involve cleaning mixed data (text and numbers) sourced from our database. Key Responsibilities: - Identify and rectify inconsistencies within the data - Ensure data integrity and accuracy - Prepare cleaned data for further analysis Ideal Skills: - Proficiency in data cleaning techniques - Experience working with mixed data types - Familiarity with database navigation and Excel/CSV files - Attention to detail and strong problem-solving skills Experience Requirement: Prior experience in data cleaning and verification, particularly with mixed data from a database, is highly desirable. Understanding of common data issues and how to resolve them quickly will ...
We we forced to udpate our server form centos7 to alvaviva that has a more recent version of mysql, now one main pure php file we have are throwing some errors. We need someone to update it. No logic changes needed just syntax and maybe some database access query.
...after token migration to Raydium. The type of app can be discussed, but the initial idea would be a simple executable GUI that takes two inputs: 1. a time frame (e.g., from 18:00 UTC January 25 to 19:00 UTC January 25) and, 2. a duration in hour. The script should outputs a CSV file. The CSV file must contain minute-by-minute data for the input duration (e.g., 4 hours worth of data collected minute-by-minute) for ALL tokens that migrated from pump fun to Raydium for the input time frame. The CSV file should contain the following columns: ca - contract address of the token (character) time_since_migration - time (in minutes) since Raydium pool creation after migration (numeric, positive integer) open_mc_sol - market cap in SOL at the start...
