Database query csv fileроботи
Я шукаю розробника з досвідом роботи з AirTable для налаштування та автоматизації ключових бізнес-процесів моєї компанії. Наш ідеальний кандидат - добре розуміє функції AirTable і вміє працювати з базами данних. А також готовий створювати індивідуальні рішення для потреб компанії. Задачі та виклики: - Аудит та аналіз продуктивності налаштованої Airtable бази з метою виявлення можливих поліпшень та оптимізацій. - Побудова та реалізація нового воркфлоу для існуючої бази в AirTable. - Автоматизація повторюваних завдань і робочих процесів. - Інтеграція AirTable з іншими інструментами та платформами, яку ми підберемо разом вже під наші потреби. - Надання підтримки користувачам та вирішення проблем. - Розробка та підтримка документації щодо роботи з базою включаючи інструкції для користувачі...
Потрібно реалізувати автоматичну вигрузку csv файла з фтп в БД сайта. На сайті повинно бути поле вводу номера телефона (для перевірки кількості бонусів на сайті) після вводу, людині повинна прийти смс з кодом підствердження, після вводу відкривається інформація про клієнта, а саме ПІБ, номер телефону, номер бонусної картки та кількість накоплених бонусів
I need to create a database of Ukrainian: - real estate agencies offering foreign property, - investment / financial firms offering foreign investment property. Database must be devided in two parts: 1. Company from Kyjev 2. Company form other parts of Ukaraine. Database scope: Name of company, Town, Email address, Web site ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Мені потрібно створити базу даних української мови: - агентства нерухомості, що пропонують іноземну власність, - інвестиційні / фінансові фірми, що пропонують іноземну інвестиційну нерухомість. База даних повинна бути розділена на дві частини: 1. Компанія з Києва 2. Фірма утворює інші частини Укарайна. Обсяг бази даних: Назва компанії, місто, адреса електронної...
Потрібно розробити імпорт інформацію з csv файлу та створити під неї сторінку телепередачі для сайту Детальне ТЗ в доці Приклад файлу імпорту прикріплений, для імпорту буде такий же, але в форматі csv
I'm looking for an expert who can assist me with a project involving an ESP32 and SIM800L. The objective is to push SMS to the cloud and store them in a MySQL database. Key Requirements: - Proficiency in working with ESP32 and SIM800L - Expertise in cloud computing and database management, specifically with MySQL - Ability to design and implement a system for real-time SMS storage Your role will be to ensure the system is efficient and reliable, with a clear focus on data integrity and security. Experience with similar projects would be a significant advantage.
I'm in need of a skilled designer who can create a bathroom sink in crv3d file suitable for CNC router. Key Requirements: - Create crv3d file from design given - kindly refer sample of crv3d file attached Ideal Skills: - Experience in mould design - Knowledge of Aspire software -
I am looking for a skilled Power BI expert to create a dashboard primarily focusing on sales analytics. Key Requirements: - The dashboard should connect to Excel/CSV files. - It should track revenue by product. Ideal Skills and Experience: - Proficiency in Power BI. - Experience in sales analytics. - Ability to work with Excel/CSV data sources.
I'm looking for a freelancer who can scrape comprehensive data from various platforms including e-commerce websites, business dire...In will need to be scraped to find correct contact person. Data Needed: - Business Name - Type of Business - Contact Email - Contact Phone - Contact Person - Physical Address (divided into Street Number, Street Name, Town or City, State or County, Zip or Postal Code, Country) Regions to Target: - USA - Canada - UK - Australia - New Zealand The data should be neatly organized and delivered in a CSV Spreadsheet. Ideal Skills: - Proficient in data scraping tools and techniques - Experience in data analysis and organization - Familiarity with the targeted regions' business landscape Please bid only if you can provide this data accurately and...
I'm looking for a skilled Data Analyst with expertise in Google Data Studio to create dashboards from Google Sheets data. Key Requirements: - Analysis of performance metrics - Use of Excel/CSV files as data sources - Creation of interactive components in dashboards - Incorporation of custom date range filters - Integration of multiple data sources beyond Excel/CSV - Development of custom report templates - Dashboards/Data visualization Ideal Skills: - Proficiency in Google Data Studio - Strong data analysis capabilities - Experience with Excel/CSV files - Understanding of performance metrics
...can help streamline my workflow by integrating , Airtable, and Bravo. The main goal is to consolidate my database from MailerLite into a more efficient system while ensuring smooth automation across platforms. Scope of Work: - Set up and optimize workflows. - Automate data transfer and synchronization between MailerLite, Airtable, and Bravo. - Manage seamless contact handling, segmentation, and updates within Airtable. - Implement best practices for efficient automation and error handling. - Provide documentation and basic training for my team. Requirements: - Proven experience with , Airtable, and Bravo. - Strong understanding of MailerLite and database consolidation. - Ability to create scalable and reliable automation workflows. - Good communication and problem-solvi...
I need a freelancer based in Seattle to set up the Deepin file manager and the Thunderbird email client on my Linux system. I am willing to travel to them for the work. Ideal Skills and Experience: - Proficient in Linux operating systems - Experience with setting up Deepin file manager - Skilled in configuring Thunderbird email client - Knowledgeable about general file management systems
I'm seeking a skilled designer to create a DXF file suitable for a 1.6mm brass cut, for a classic style house number. The design should be aesthetically pleasing, but not overly ornate. Key requirements: - Experience in creating DXF files for metal cutting - Strong design skills, with a focus on classic styles - Ability to create a simple yet elegant design without the use of decorative elements - Knowledge of appropriate design considerations for a 1.6mm brass material - Good communication skills to clarify any design details as necessary Size approx 300mm high by 200mm Please provide samples of previous similar work.
I'm looking for a data visualization expert with Tableau experience to create a detailed hitting landing zones chart. The data will be sourced from CSV files and will focus on individual player performance. I have an idea on how it should look like based on the attached image. Have all the necessary data for it
Subject: Looking for a Freelancer to Build a Structured Database from Korean Community Websites Dear [Freelancer's Name], I am looking for a skilled freelancer to help build a well-structured Excel database by collecting and categorizing information from Korean community websites in Sydney. These websites receive around 1,000 daily visitors and contain valuable information related to: Service providers (moving, cleaning, plumbing, etc.) Rental housing (available listings, pricing, and locations) Job listings (companies hiring, job seekers, and salary details) Worker recruitment (businesses looking for employees) Shopping information (where to buy items, price comparisons) This data will be used for my new service website, which will provide clients with quick and reli...
I need a Talend expert to develop a reject logic for my JSON files. This will involve both schema and content validation. The freelancer will be responsible for setting up a system where any files that fail validation are rejected and quarantined. Key requirements: - Both schema and content validation of JSON files - Quarantine files that are missing required fields, have i...setting up a system where any files that fail validation are rejected and quarantined. Key requirements: - Both schema and content validation of JSON files - Quarantine files that are missing required fields, have invalid field values, or structural errors Ideal skills: - Proficient in Talend 7 / higher - Strong understanding of JSON files and data validation - Experience with error logging and file quaranti...
I'm representing a small non-profit housing organization in Oklahoma, currently managing 72 units in conversion. We are seeking a professional who can assist us in moving our files from QuickBooks t...Responsibilities: - Transfer of varied data types including: * Financial records * Tenant information * Maintenance data * EHR Clinical data - Primarily focusing on: * Data migration Ideal Skills and Experience: - Proficient in QuickBooks and Yardi Voyager - Experienced in data migration - Familiar with handling diverse data types - Able to work with specific QuickBooks file formats, mainly CSV. Our aim is to ensure a smooth transition of all necessary files to the Yardi platform. Your expertise will be crucial in assisting us with this task. Thank you f...
I need a specialized cybersecurity tool to detect and manage malware threats. The detector should specifically monitor our email and file systems, as these are our primary vectors for potential malware attacks. Key Features: - Proactive detection of malware threats - Monitoring of email and file systems - Immediate action upon detection: - Quarantine the threat - Notify the user - Automatically remove the threat Ideal Skills: - Extensive experience in cybersecurity - Proficiency in developing threat detection tools - Knowledge of malware behavior and patterns I am looking for a professional who can create a reliable and efficient malware detector.
I'm seeking a professional web developer to create a ...vehicle details using the DVLA Vehicle Enquiry Service (VES) API () The first phase of this project is to: - copy so that it has the similar content and the same user journey. - Write out the details to a CSV file on the backend. What is NOT required: - Integration with STRIPE - this will be done later. So this stage can simply be a button which doesn't do anything. Please note how renders differently on a mobile phone from a desktop. Please, provide examples of similar projects you've worked on in your proposal.
Please check the pdf document and the STEP file. Don't change anything else than the slot. The first perfect entry wins.
I need assistance with my file management system. The primary focus involves handling my cloud files. The main issues are extracting the files and ensuring everything on my computer operates correctly. Specific Tasks: - Primarily dealing with audio files, projects, samples, and my instrument library. - Organizing and categorizing these files for easy access and retrieval. - Creating and executing a backup strategy to ensure file safety. Ideal Skills and Experience: - Prior experience in file management, particularly with cloud systems. - Proficient in working with audio files and related projects. - Strong organizational skills and attention to detail. The project will involve managing files on Dropbox.
I'm seeking a freelancer to assist with basic data entry tasks. The primary responsibility will be copying and pasting information from various sources. The ideal candidate should be proficient with: - Copying and pasting data from websites, PDF documents, and spreadsheets - Typing documents accurately - Organizing files in a systematic manner This is a straightforward job, suitable for anyone looking for easy freelance tasks. Good attention to detail and a basic understanding of data management will be beneficial.
I need a Power App form designed for data entry, specifically for capturing user information. This form will be integrated with workflows that generate a PDF and a CSV file, which then get sent to our service desk. Ideal skills for this project include: - Proficiency in Microsoft Power Apps - Experience with form design and development - Understanding of workflows and automated processes - Ability to generate and format PDF and CSV files - Familiarity with service desk communication protocols - Experience in using Power Automate for workflow automation. As the project does not specify which particular fields of user information are needed, the freelancer will need to use their expertise to recommend the most relevant fields to include in the form.
I'm in need of a Python program that can scrape text content from 2 pages of one website. The primary goal of this project is to extract specific data for analysis. I want this program to have an desktop icon with a date range and output information to a csv file. I will need help setting up my computer with all the files necessary to run the program. Key Requirements: - Proficiency in Python and web scraping libraries (such as BeautifulSoup, Scrapy, or Selenium) - Ability to handle and parse text content from various web sources - Experience in data extraction and manipulation - Knowledge of best practices for ethical and efficient web scraping - Comment code so if the site changes, changes can be made easily - Will need help installing files on my computer See atta...
...scraping techniques and tools - Experience with scraping data from websites that block data from showing in the HTML - Knowledge of programming languages such as Python, with libraries like BeautifulSoup and Scrapy - Attention to detail and ability to deliver clean, structured data The data extraction is a one-time process, with no need for future updates. Please deliver the scraped data in a CSV file format. Please ensure that anti-scraping measures on the website are handled properly. Please handle anti-scraping measures using general precautions. The project involves scraping a large volume of data. Confidential access details will be shared privately. The structure or pattern of the 'Video Uploader URL' is: it starts with "/members/". The project ...
I'm seeking a professional with Azure SQL Database expertise for a small-scale project. I want to disable MFA for Active directory for sql
I'm looking for an experienced data migration specialist to assist with transferring customer & training course information from an old training management system to a new provider. The previous provider states that data will be provided in an SQL backup file via SMTP and requires manual intervention for the import process. The new provider requires CSV files to import. Key Responsibilities: - Retrieve and handle the SQL backup file - Collaborate with the new provider for data import - Ensure the integrity and security of the customer & company data throughout the process Ideal Skills and Experience: - Proficiency in handling SQL backup files - Previous experience with data migration - Strong communication skills for liaising with the new provider - Atte...
I'm in need of a proficient JavaScript developer to create a database-dependent website, closely resembling the user dashboard of an existing site. The project should be completed within two weeks and will involve working with both PostgreSQL and MongoDB. Key Features: - User Authentication: Secure logins through email and password, supplemented with Two-factor authentication for added security. - Live Updates: User interactions will generate database activity, which will be displayed on the site in real time. The ideal candidate will have: - Extensive experience with JavaScript and database management. - Proficiency in PostgreSQL and MongoDB. - Knowledge of implementing secure user authentication and real-time updates. I have already purchased the domain and ...
I need a PHP program that can access SFTP files, specifically text files, save them locally, and then delete the files from the SFTP server. The program should not perform any additional checks before deletion. Ideal skills for this job include: - Proficiency in PHP - Experience with SFTP protocols - Familiarity with file handling in programming Please note that there is no specific naming convention for the saved files, as I have not specified any. The program should simply save the text files as they are received from the SFTP server.
...Advanced knowledge of Drupal e-commerce (Commerce 2.x and product management). Advanced experience with MariaDB/MySQL databases, complex structures, and query optimization. Ability to correct migration errors and maintain data integrity. Tasks to be Performed Audit the current migration and detect errors in content structures, IDs, and missing data. Implement a migration module using Drupal 7 and Drupal 9 APIs, instead of direct database migration. Fix issues in product and pricing migration, ensuring that all data is transferred correctly. Ensure that event, registration, and payment data remain intact after migration. Optimize database queries to improve loading speed. Conduct controlled migration tests and document the applied changes. What We Expect from the F...
We need the processing pipeline updated very simply: We currently get output that includes points and contours and we want the output to be two separate plots: one of points and one of contours, separately. We would also like sample names ouputed on the plots and CSV files
...dashboards for data visualization. Automate tasks using Excel VBA (Macros) and Power Query to improve workflow efficiency. Clean, structure, and analyze large datasets using data validation, conditional formatting, and Power Pivot. Troubleshoot errors in formulas and provide solutions to improve spreadsheet functionality. Collaborate with different teams to gather requirements and create customized Excel reports. Maintain and improve existing Excel models, ensuring accuracy and performance. Train and support team members on best practices for using Excel effectively. Required Skills & Qualifications: Proven expertise in advanced Excel formulas and functions. Experience in Excel automation using VBA Macros, Power Query, and Power Pivot. Strong analytical and problem-sol...
Upload file from T-Shirt Design for Ocean Swim Race in Hawaii' (2024 Contest). File needs to be in Adobe Illustrator. Also add 'Swim' to design so it reads 'North Shore 5K / 10K Swim'
I need translate French to German A column - TEXT B column HTML
...processes revenue and expense data for mobile applications. Project Overview: - Dashboard processes CSV revenue files and Excel expense files - Combines data to gen erate comprehensive reports - Uses React.js with Material UI for frontend - Handles multiple file formats and data transformations Technical Requirements: 1. Strong experience with: - React.js - Material UI (MUI) - Excel/CSV file processing (, Papa Parse) - JavaScript/ES6+ - Git version control 2. Must be able to: - Understand existing codebase - Debug data processing issues - Add new features - Optimize performance - Handle file validations - Maintain clean...
I'm in need of an experienced app developer to create a new, innovative application for both iOS and Android. The app will connect two phones together for seamless file sharing. Key Responsibilities: - Design and develop a cross-platform application. - Implement robust and efficient file sharing capabilities between connected devices. Ideal Skills: - Proficiency in iOS and Android app development. - Previous experience with file sharing applications. - Strong understanding of cross-platform development. - Excellent UI/UX design skills to ensure a user-friendly interface. - Skills in optimizing battery usage to ensure the app runs efficiently without draining device power. - Knowledge of various connectivity protocols like Wi-Fi Direct, Bluetooth, and NFC. - Ex...
...build a comprehensive e-commerce website for selling physical goods. The website needs to have an underlying database that supports its functionality. Key Features: - The website must be designed to facilitate the sale of physical products. This will involve creating product pages that can host images, descriptions, pricing, etc. - The product pages should include customer reviews, product variants (size, color, etc.), and product recommendations. - A secure, efficient shopping cart and checkout process is essential. - The website must be optimized for mobile viewing and be SEO friendly. Ideal Skills: - Extensive experience in e-commerce website development. - Proficiency in database management. - Knowledge of SEO and mobile optimization. - Familiarity with incorporatin...
... 1. API Integration: Fetch real-time ad data from Facebook & TikTok Ads Libraries. 2. Dashboard UI: A clean, user-friendly interface to view and filter data. 3. Filtering System: Apply advanced filters to find specific ads. 4. Data Export: Ability to download filtered data in CSV/Excel. 5. Ad Preview: Show ad creatives, captions, and engagement metrics. 6. Login System: Secure access with user authentication. Tech Stack Preference: • Backend: Python (FastAPI) / Node.js • Frontend: React / Vue.js • Database: PostgreSQL / MongoDB • Hosting: AWS / DigitalOcean Deliverables: • Fully functional web-based dashboard • API integrations for Facebook & TikTok Ads • Filtering and search functionality • Source code and dep...
I'm looking for a skilled app developer to create a hybrid app that integrates some of the most popular LLMs (GPT, Grok ,Lama ,Copilot ,DeekSeek ,Gemini , etc) for problem-solving. Main Features: - Users can either snap a photo or type a query to get answers. Writing Assistant - Create outlines, essays, polished content etc. - For paid subscribers, the app will show all the steps for any academic subject. -Tutor Section - Database the Queries and Captures for Item Tutoring -Book Vault - Curated Book Library allows you to view summaries, quote, character analysis, and themes, symbolism, general analysis etc. Platforms: - The app should be compatible with both iOS and Android. Subjects: - Initially, the app should support all major academic subjects: Economics, Physi...
...DirectAdmin environments. Monitoring Requirements Host-Level Metrics Ping and availability CPU usage (load averages, per-core utilization) Memory usage (RAM, swap) Disk activity (IOPS, free space, read/write operations) Network traffic (bandwidth usage, errors, dropped packets) Service uptime Service-Level Metrics Web services (HTTP/HTTPS status, performance, visitor statistics) Database performance (MySQL/MariaDB with query statistics) Mail servers (queues, processed/deferred emails, etc.) DNS server health FTP server status cPanel/DirectAdmin-specific service metrics Backup monitoring (jetbackup) Website monitoring Security and Logs User login activity Firewall rule statistics System and error log monitoring Mail log monitoring Apache log analysis Deliverables...
I'm looking for a freelancer to extract specific information from two websites: AICI and GlamHive. The data needs to be compiled in a CSV format. Key Responsibilities: - Extracting the specialties and Instagram contacts from the profiles on the websites. - Compiling additional information such as Location, Experience level, and Pricing details. Ideal skills and experience: - Proficiency in data extraction and web scraping. - Experience with compiling data in CSV format. - Attention to detail and ability to accurately capture and report information.
I'm seeking an experienced professional to create an Access database for managing my inventory. The database should track: - Product Quantities: Monitoring stock levels, tracking stock movement and alerting for reorders. - Supplier Details: Keeping records of suppliers, their contact information and inventory supplied. - Order History: Documenting past orders for reference and analysis. Your application should highlight your relevant experience with Access databases and inventory management. Please provide examples of similar projects you have completed in the past. The database will support access for multiple users simultaneously.
...financial statements by aggregating data from the bookkeeping module. Data Export: Enable easy export of data to Excel (or CSV format) for further analysis. AI Report Generation: Integrate an AI agent (using an API such as OpenAI’s GPT-4, Hugging Face, or a similar service) to assist in generating natural language reports and insights. The AI should be able to process and combine data from both the inventory and bookkeeping databases to provide clear, actionable summaries of monthly performance. Technical Requirements: Framework: Preferably developed using Flutter (or another cross-platform framework) for both Android and iOS. Cloud Integration: Use a cloud database (e.g., Firebase Cloud Firestore) to store data with real-time synchronization and built-in offline p...
I have a PNG logo that needs a thin white border around it. I also need a separate file for the logo text (Just pulled from the existing logo) so I can get apparel printed. Please use the same font for the text as in the logo. Ideal skills and experience for this job: - Graphic Design - Experience with logo modification - Proficient in using design software - Able to create files for apparel printing I would like very high resolution PNG and JPEG files created from this
...Postgres specialist who can help me speed up my data retrieval queries. We have a complex database design that supports an audited versioned file system, which may contain over 100 million items, so we need to optimise the queries and potentially the database structure Main Issues: - Long Execution Time: My current Postgres queries are taking too long to execute, which is hampering performance of my core functionality Data Operations: - Data Retrieval: The slow queries primarily involve data retrieval from large tables with millions of rows. - Data Retrieval: complex joins required, sometimes with many database queries per user request Ideal Skills: - Extensive experience with Postgres - Proficient in query optimization - Skilled in handling large...
...expert in FileMaker to assist in creating a simple yet effective nutrition database. The project involves transforming the way I track my nutrition, currently done via an Excel spreadsheet, into a more sophisticated system leveraging FileMaker's capabilities. Key Requirements: - Each day should be a separate record in the database - Daily food items will need to be selectable via both a search function and a drop-down menu/list - Nutritional values should be linked from a resident table - The system should generate summary reports over various time periods (week/month/year) and allow data to be assembled in different ways (e.g. grams of protein from seafood in March, average grams of tuna per day, etc.) - The database should utilize advanced structures with re...
I'm encountering a problem with a MySQL query that joins multiple tables. The query is returning incorrect data, and I need a skilled developer to help identify the issue and debug the query.
I'm seeking a data visualization expert to create a dashboard and corresponding reports from my Knack database. The main focus is on visualizing performance metrics using bar charts and graphs. Key Responsibilities: - Design and implement a dashboard that visualizes performance metrics through charts and graphs. - Utilize bar charts specifically to display selected performance data. - Generate comprehensive reports for deeper analysis. Ideal Skills and Experience: - Proficient in data visualization and dashboard creation. - Previous experience with Knack database is highly preferred. - Strong understanding of performance metrics. - Excellent skills in creating and interpreting bar charts.
I'm seeking an experienced UiPath developer to help me automate complex data entry tasks. The automation will primarily involve: We will be having more than 100 Invoice formats. The system should automatically read these formats and write into excel csv file. Ideally, the freelancer should have extensive experience with UiPath, a deep understanding of data manipulation processes, and a proven track record of automating tasks across web-based applications and database systems. Proficiency in these areas will be crucial for the successful completion of this project. The estimated volume of data for automation is medium. The system should support template-based extraction for data extraction. The automation should run hourly. The system should log errors and con...
...upload funds via a multi-vendor PayPal integration. Supports payments between users within the platform. New Feature – POS System Integration: Objective: Extend the platform to support an integrated Point-of-Sale (POS) system for physical retail operations. Functionalities Include: Support for barcode scanners and receipt printers. Real-time inventory management synchronized with the central database. Integration with the existing payment system (e.g., multi-vendor PayPal) as well as connectivity with additional payment providers. An API interface for communication between POS hardware and the backend, ensuring real-time transaction capture and analysis. Integration into the existing role-based access control system, enabling store managers and other authorized personnel t...
Opis po polsku: (poniżej English): Czy da się stworzyć aplikację i w jakiej cenie która będzie automatycznie przeglądać określoną stronę www (lista/baza stron mogę znajdować sie w jakiejś bazie), następnie odnajdzie na tej stronie formularz i wypełni go oraz wyśle wg określonej treści? Schemat działania byłby taki: 1. Pobierz adres www z bazy, list np. csv lub google sheet 2. Wejdź na dany adres 3. Przeszukaj stronę 4. Znajdź formularz kontaktowy 5. Wypełnij formularz, wyślij wiadomość (dobrze będzie poradzi sobie jeżeli są zabezpieczenia na stronie np. recaptcha) 6. Jeżeli nie da się wysłać formularza zwróć informacje do bazy np. oznacz adres mailowy jakimś znakiem. Jeżeli byłaby to baza w google sheets to można oznaczyć statusami (do wysłania, wysłane, brak możliwoś...