Database query csv filepráce
Dobrý den, prosím o pomoc při parsování dat z CSV do XLSX. Zdrojové CSV obsahuje HEADERS, pak je několik řádků dat vztahujících se k těmto Headers. Po datech následují další HEADERS, které jsou rozdílné od předchozích HEADERS v názvech i počtu, a opět následuje několik řádků dat. Toto se opakuje, celkem jde o cca 368 řádků v CSV, z toho asi 20 HEADERS řádků. Data z CSV nechť jsou exportována do jediného XLSX. Struktura cílového XLSX: 1) ke každému (skoro každému) HEADERS řádku bude vytvořen v XLSX nový List, jehož název bude zhruba odpovídat prvn&ia...
I need to scrape data from real estate website. Specifically data under these two filters: Together some 9300 real estates in two separate datasets. Only the text data is needed (no pictures, no maps), preferably in xls or csv.
Převod v minulosti zaznamenaných měření z na Chci to mít někde pohromadě. Původní webapp je dost nepřehledná a non-user-friendly, nová lepší, ale nemá možnost ručního přidání starších dat ani nějaký jednoduchý import. Zdrojová data z Healthplanet by snad měla jít sosnout přes...zaznamenaných měření z na Chci to mít někde pohromadě. Původní webapp je dost nepřehledná a non-user-friendly, nová lepší, ale nemá možnost ručního přidání starších dat ani nějaký jednoduchý import. Zdrojová data z Healthplanet by snad měla jít sosnout přes nějakej...
...which is the LMS plugin, and we have online classes, so some users have made progress in their courses it must be the same on the staging site… Here’s a list of the tables from the database of the live site, I think we need them, but please feel free to migrate anything else if we need it to have all the data required from the live site. Another thing, it’s good to prepare a whole plan of the migration process, because when you want to start, we need to put the live site on maintenance mode until migration is done, and we don’t want to keep it long under maintenance for the client u know… Tables from database that required to be migrated. wp_learndash_pro_quiz_category wp_learndash_pro_quiz_form wp_learndash_pro_quiz_lock wp_learndash_pro...
...neumožňuje ukládání do XLS. Sháníme tedy programátora, který se chce na našem projektu podílet a vytvoří jednoduchou aplikaci, který bude sloužit k ukládání vyčítaných dat do PC. Požadavky: Spustitelný *.EXE SW s možností přidání do naplánovaných úloh. SW bude mít jen pár základních parametrů. 1) URL ke xml souboru (možnost zadání user & password) 2) Název souboru kam vyčítat 3) přípona (xls, xlsx, csv) 4) interval ukládání hodnot (xml je aktualizováno při každém obnovení) 5s, 10s, 30s, 60s, 120s, 300s, 600s, (3...
Dobry den, poptavam podporu pri web scrappingu informaci o nemovitostech z konkretniho webu. Jedna se mi o strukturovane ulozeni informaci z webove stranky (bude upresneno) do xlsx/csv a idealni automatickou aktualizaci teto databaze. [Removed for encouraging offsite communication which is against our Terms and Conditions -Section 13:Communication With Other Users] Predem dekuji. S pozdravem, Dan Vasko
Jedna se o dokonceni eshop od webnode na kterym uz pracuji. Par detailu + hlavne import produktu od Partnera pomoci CSV souboru. Predem dekuji.
***WE REQUEST PERSONAL PRESENCE IN CZECH REPUBLIC*** Vaším úkolem bude rozvíjet JavaScript framework pro informační systém agentury práce. Jedná se o databázový systém využívající na backendu PostgeSQL, aplikační server v Javě a frontend je javaScript. Sídlíme v Praze, ale pracovat je možné odkudkoliv. Občasné osobní setkání ale pomůže k lepším výsledkům. Preferujeme dlouhodobou spolupráci.
Hledám programátora, který zajistí automatický import produktů (dat) ze stránek dodavatele do e-shopu. Součástí importu bude i překlad (Google)
Disassemble Freescale MPC5674F hex file to assembler. IDA PRO, winhex is a must!
I AM LOOKING FOR A CAD DESIGNER TO CREATE A LIGHT WEIGHT YET TRENDY PROTECTIVE CASE THAT SLIPS RIGHT OVER THE LATEST IPAD PRO. HERE IS A LINK FOR THE SPECIFICATIONS FOR THE IPAD PRO. PLEASE REFER TO SIZE AND WEIGHT SPECIFICATIONS FOR DESIGNING GUIDELINES. FORMATTING FOR THE CAD FILE MUST BE IN .STEP, .STP, .STL, .OBJ
Potřebuji vytvořit jednoduchý SW a GUI v Jave, který se bude připojovat na cca 5 zdrojů dat přes jejich API, bude ukládat data z těchto zdrojů do .csv plus bude schopen využít některé příkazy jednotlivých API zdroje.
Potřebuji vytvořit jednoduchý SW a GUI v Jave, který se bude připojovat na cca 5 zdrojů dat přes jejich API, bude ukládat data z těchto zdrojů do .csv plus bude schopen využít některé příkazy jednotlivých API zdroje.
Úpravu CSV importu pro import produktů do Magenta.
Chtěli bychom přenést stávající eshop (), který běží na pronájmu na vlastní prestashop řešení. Z eshopu bychom chtěli hromadně přenést produkty (xml nebo csv) a kdyby to bylo možné, tak i dosavadní objednávky a nějaká další data. Od systému prestashop bychom poté požadovali tyto funkce: xml import produktů (automatický z feedů dodavatelů), xml export na srovnávače (heureka, zboží, hyperzbozi,...), možnost SEO optimalizace (úprava meta informací, "dobré" url adresy), možnost integrace platební brány, integrace Ulož (výběr z odběrných míst), generování...
Enhance SQL Server trigger on the UserProfile table to correctly handle scenarios where RoleId changes for a given UserId (via UI or direct query) and log them appropriately in the UserProfileHistory table.
I need a skilled professional to seamlessly integrate my Microsoft Access Database with a daily-updated Excel sheet. The Excel sheet contains mixed data (text and numbers). Key Tasks: - Daily integration of updates from the Excel sheet into the Access database. This includes both appending new records and updating existing ones. Ideal skills and experience: - Proficient in Microsoft Access and Excel. - Experience with data integration and automation. - Ability to set up a system that requires minimal manual intervention.
I need a skilled freelancer to scrape product information from a specific website. The task involves extracting a total of 841 entries accurately and efficiently. The data fields req...freelancer to scrape product information from a specific website. The task involves extracting a total of 841 entries accurately and efficiently. The data fields required include product name and price, product description and images, and product specifications and reviews. The ideal candidate should have experience with web scraping tools and techniques, ensuring clean and organized data output in CSV format. Key Requirements: - Web scraping expertise, preferably with Python - Attention to detail for data accuracy - Ability to deliver results in a timely manner - Providing the code used for the scr...
Project Overview: React/TypeScript application using for video meetings, integrated with Supabase for backend services. The application handles interview scheduling and video meetings but has connection issues that need debugging and fixing. Tech Stack: Frontend: React 18, TypeScript Backend: Supabase Video Integration: State Management: React Query UI Components: Shadcn/UI Real-time Updates: Supabase Realtime Current Issues: Meeting connection failures Token creation errors Room URL validation issues Device permission handling problems Key Files to Work With: src/components/ src/components/ supabase/functions/manage-daily-room/ src/components/ Required Skills: Strong experience with React and TypeScript Experience
...environments. Monitoring Requirements: Host-Level Metrics: Ping and availability CPU usage (load averages, CPU core utilization) Memory (RAM usage, swap usage) Disk (IOPS, available space, read/write operations) Network traffic (bandwidth usage, errors, dropped packets) Service uptime Service-Level Metrics: Web services (HTTP/HTTPS status, performance, and visitor statistics) Database performance (MySQL/MariaDB, including query statistics) Mail servers (Exim/Postfix queues, processed emails, deferred emails, etc.) DNS server health FTP server monitoring Other cPanel/DirectAdmin-specific services and statistics Backup monitoring Security and Logs: User login activity Firewall rules and hit statistics Error logs and system log monitoring Mail log monitoring Apache log ...
I'm looking for a web-based, secure chat platform primarily for text messaging and file attachments, with normal level of security. Key Features: - Text messaging: The platform should facilitate seamless text communication. - Text and File Attachments: Users should be able to send and receive file attachments without any hitches. 2 or 3 users can join and chat or send files. With specific room. Look at this example: Project 1: user 1 and 2 should be able share ideas, and share their works and get comments Project 2: User 3 and 4 can do the same. Would be good that I can delete rooms or create new ones. User Authentication: - The system should use a simple username and password for user authentication. Ideal Skills and Experience: - Proficiency in web dev...
I'm looking for a skilled developer to create an automated script that scrapes products from an eCommerce site. The script should capture comprehensive product details and export them into a CSV file via Excel. Key Requirements: - The script needs to operate automatically, without manual intervention. - It should meticulously gather: - Photos and text - Price and description - Category and SKU Ideal skills include web scraping, Python or similar programming language expertise, and experience with data handling in Excel and CSV formats. Please ensure your proposal includes relevant past projects, as well as your approach to this task.
More details: What specific tasks do you want the macro to perform? Data analysis, Data formatting Do you need the macro to run automatically under certain conditions? No, I'll run it manually What level of user interaction do you foresee with the macro? Simple prompts and inputs
...into post-trade stock movements, such as: Maximum progression Re-entry price hits End-of-day value Customizations: Allow users to upload a list of stocks in .csv format for scanning. Provide filters to shortlist stocks based on Elliott Wave patterns, Fibonacci levels, RSI, and other criteria. Set adjustable parameters for trading conditions, such as time frames, indicators, and thresholds. Technology and Platforms: Programming language: Python (preferred), or any suitable language. Frontend: Simple and user-friendly interface (web-based or desktop-based). Backend: High-performance algorithm with cloud or on-premise hosting. Database: Store historical data, strategy parameters, and trade logs. Risk Management: Automate risk management, including position sizing, maximum ...
I need a skilled AutoCAD professional to create a KMZ file for mapping purposes. The level of detail required is medium, so it's crucial to understand how to balance detail with clarity. The project involves agricultural land parcels spreading across multiple villages. We need to consolidate these various maps and present them in KMZ and pdf formats. Key elements that need to be included in this KMZ file are land/survey numbers.
...Option to generate commissions for pickups. - A seller dashboard for managing pickups. - Configure the above with the Dokan plugin. - Allow sellers to process multiple orders in bulk for shipping. - Enable sellers to print shipping labels directly from their dashboard. - Automate shipment tracking updates for both sellers and buyers. - Add options for sellers to import and export shipment data via CSV files. - Integrate real-time shipping rate calculation based on package dimensions and destination. - Implement notification system to alert sellers of shipment statuses and issues. - Set up a system for managing shipment returns seamlessly. Ideal Skills: - Experience with Dokan plugin and its integration. - Familiarity with Shiprocket courier service. - Web development skills for...
...and state filters, allowing Employers to search Freelancers locally. Modify the Task Search/Listing Page to filter tasks/projects based on selected city and state. Database Changes: Add "City" and "State" fields in the Freelancer and Employer profile meta data. Ensure that the selected city and state are saved in the database when profiles are updated. Ensure Compatibility with Future Updates: Use the child theme to override necessary template files from the workreap-core plugin (templates directory). Avoid modifying the core theme or plugin files directly to ensure updates won’t overwrite customizations. Custom Query Modifications: Modify WP_Query or task queries to ensure that tasks and Freelancers are properly filtered by city a...
...include a scalable website, secure APIs, and an efficient database capable of handling billions of records (around 300-400 billions). The system will provide users with actionable insights through dashboards, monitoring tools, and real-time alerts. These are a few functionalities and features planned as of now. Once these implementations are completed successfully, we aim to scale the platform further by introducing advanced capabilities and enhancements to cater to a broader audience and meet future demands. To achieve this, we are looking for skilled professionals with expertise in database management, web development, and cloud infrastructure. Below are the detailed requirements for the project: Expertise Required 1. Database Administrator (DBA): • Prof...
...detection and CRM integration for lead management. Additionally, the AI can be trained using the user's voice to add a personalized human touch to conversations. Calls will be made using SIM-based calling instead of VoIP for reliability and cost-effectiveness. 1. Lead Management Integration with CRM: Import leads directly from our CRM system. Manual Import: Upload leads using Excel files or CSV format. Manual Entry: Allow users to input numbers manually. 2. Call Modes Manual Calling: Enable users to make calls directly through the app. AI-Powered Automatic Calling: AI should initiate calls on behalf of the user, engaging leads in natural, human-like conversations. - SIM-Based Calling Reliability: Calls are made using SIM-based telephony rather ...
I'm looking to create an e-commerce platform focused on selling digital products, specifically databases. The platform should have features that allow for product samples and multiple downloads. Key Features: - E-commerce functionality ta...that allow for product samples and multiple downloads. Key Features: - E-commerce functionality tailored for digital products - Product sampling capabilities - Allowing multiple downloads for customers In addition, I need the backend to handle customer data for marketing purposes. This means that the database needs to be efficient in storing and retrieving customer information, tracking campaign performance, and managing sales data. Ideal Skills: - E-commerce website development - Database management - Marketing data analysis - ...
I need a Python expert who can help me develop an automation script for monitoring my databases. Key Responsibilities: - Develop a Python script that can systematically monitor our databases. - Ensure the script can handle various database types. - Implement alerts for system anomalies or irregularities. Ideal Skills and Experience: - Proven experience in Python programming, specifically in creating automation scripts. - Prior experience in system monitoring is a plus. - Familiarity with various database types is highly desirable.
I'm looking for a professional with extensive experience in Odoo database migrations. My current system is the latest version of Odoo, and I need to migrate to the very latest version as well. Key Tasks: - Assess the current Odoo database and identify potential challenges for the migration. - Execute the migration to the latest Odoo version smoothly and efficiently. - Ensure data integrity and system functionality post-migration. Ideal Skills and Experience: - Proven track record in Odoo database migrations. - Deep understanding of the latest Odoo versions. - Strong problem-solving skills. - Excellent attention to detail.
Hi I had a designer improve the page of a back-end web app (a list of orders) and now I need to merge back those changes to the php file (and css and js) I'll provide you the new html file and ftp access to the php file. I'm using the adminlte template. Max bid 50 euros. Thank you.
I need an expert to update certain fields of user data in my database. Specifically, the changes involve age, birth year, school attendance dates, and high school graduation year, among others.
I'm looking for an expert to help me modify user activity history on a website's database. Ideal Candidate: - Proficient in database management and web technologies. - Previous experience with user data modification. - Knowledge of data privacy regulations and ethical standards. Task: - Edit existing user activity entries. Please note, the selected freelancer will have to work under strict confidentiality and adhere to data protection laws.
I need a WordPress developer to create a simple function that does the following: **Fetch Data from SQL: Retrieve the correct row from an SQL database based on a value passed in the URL query (e.g., ?workorder=12345). Extract the corresponding URL from the database. Display PDF: Use the retrieved URL to display a PDF file in a viewer, such as , in the same way as in this demo: **Integrate with Forminator: Pass the retrieved URL into a hidden field in a Forminator form, allowing it to be submitted with the form. **Additional Information: * The website is built with Oxygen Builder. * You will have access to all necessary systems to complete the task. * If you have experience with WordPress, SQL, PDF viewers (e.g., ), and Forminator, this task should
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.
...and understanding of cloud deployments and microservices approach to build the application. - Proficient in planning, designing and implementing SPAs using Angular and developing REST APIs using Node JS. - Created Typescript reusable components and services to consume REST APIs using Component-based architecture. TECHNOLOGIES: Node.js | Angular | React.js | | Java script | TypeScript DATABASE SQL | PL/SQL| MySQL | PostgreSQL | MongoDB | Amazon DynamoDB PM TOOLS: GIT | SVN | JIRA Monthly Remuneration: INR 75-80K Duration : 3 Months with very high possibility for extension. You should be open for an interview with a highly technical CTO. Please apply with your complete profile & examples of your best work. This position is ONLY for Full-time freelancers based in India. ...
...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
...application. This involves using Visual Studio Code (VSC) and developing weekly content to complete the assignment. Key Responsibilities: - Collaborate with me in developing a web application using Java. - Implement features such as user authentication and database interaction. - Create engaging weekly content to facilitate the learning and development process. Ideal Skills: - Proficiency in Java and experience in web application development. - Familiarity with Visual Studio Code (VSC). - Experience in implementing user authentication and database interaction features. - Excellent content creation skills. - I have attached the assignment details (its in 3 parts), sot the students should be able to provide 3 submission. - I have attached the weekly contents in excel sheet...
...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 G...
Bonjour, Je suis à la recherche d’un designer produit expérimenté pour créer un fichier CAO détaillé à partir de ma fiche technique pour un produit que je développe. Vous aurez la description du produit par message. Je dispose déjà de toutes les spécifications techniques, des matériaux, de l’épaisseur des couches et des fonctionnalités principales, mais j'ai besoin d'un expert pour transformer cela en un modèle CAO précis. Ce fichier CAO sera utilisé pour la fabrication du prototype. Détails supplémentaires : Le fichier CAO devra respecter des dimensions spécifiques. Le modèle doit prendre en compte les matéri...
...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...
