Compare sql table csv file count punët
Pershendetje Glen. Jam e interesuar per ndihmen tuaj ne SQL. Do te me duhet ndihma jote ne nje provim neser. A mundeni te me ndihmoni me nje shume prej 10 euro per 1 or e gjysem?
Programing in Dot Net & SQL Server. Visual Studio 2010, SQL Server 2012 Express ose më të avancuar. Modify existing modules, add modules, design interface, Reports...etc
...Microsoft Access Open Microsoft Access on your computer. Click Blank Database and name it, e.g., PerformanceReviewSystem.accdb. Step 2: Create Tables Employees Table Go to Create > Table Design. Add the following fields: EmployeeID (Short Text, Primary Key) Name (Short Text) Position (Short Text) Department (Short Text) MonthOfHire (Date/Time) CurrentWage (Currency) Save the table as Employees. PerformanceCriteria Table Go to Create > Table Design. Add the following fields: CriteriaID (AutoNumber, Primary Key) CriteriaName (Short Text) Description (Short Text) Save the table as PerformanceCriteria. Reviews Table Go to Create > Table Design. Add the following fields: ReviewID (AutoNumber, Primary Key) EmployeeID (Short Text...
Search value on table. Work with ftp only
Hello, i would like for you t...any information on the graphic line that we are using, but you do not have to include it. Here are the elements that need to be designed: PICTURE 1: Cupboard and plate storage furniture: We would like this area to be redesigned, so that it looks different to what it is now, and that it is harmonious with new design. The only thing we need to keep is the area that has storage, so that little table with 2 doors and drawers, the rest needs to be redesigned. PICTURE 2, 3, 4 and 5. : Dining areas. decorative features need to be added. PICTURE 6 AND 7: Our bar and backwall, decorating elements that are harmonious with the rest of the desings need to be added, we want to have liquour bottles on the back as well as decorative elements as i mentioned. ...
...application, while delivering exceptional user experiences. Key Responsibilities: - Building high-quality, scalable web applications - Creating robust server-side logic - Implementing intuitive user interfaces Your skills should include: - Proficiency in Front-end technologies (HTML, CSS, JavaScript) - Expertise in Back-end frameworks (Node.js, Express, etc. PHP) - Experience in Database management (SQL, NoSQL) - Skill in RESTful API development - Familiarity with Version control (Git) - Understanding of Responsive design principles - Knowledge of AWS/Vercel The APIs you'll be working with will mainly involve: - API integrations Prioritizing aspects of back-end development will focus on: - Scalability - Security - Performance Nice to have: - Experience in the betting i...
...optimization and scalability solutions Industry Solutions Enterprise Resource Planning (ERP) systems Customer Relationship Management (CRM) solutions Business Intelligence and Analytics platforms Workflow automation systems Our Technical Expertise Frontend: React.js, Angular, Vue.js, HTML5/CSS3 Backend: Java, Python, Node.js, .NET Mobile: iOS (Swift), Android (Kotlin), React Native Database: SQL, NoSQL, MongoDB, PostgreSQL Cloud: AWS, Azure, Google Cloud DevOps: Docker, Kubernetes, Jenkins Our Development Approach Agile methodology with iterative development Regular client communication and progress updates Comprehensive testing and quality assurance Post-deployment support and maintenance Documentation and knowledge transfer Why Choose Us Proven track record of successfu...
...token's price trends for various timeframes (1 hour, 4 hours, 12 hours, 1 day). ### **2. Admin Dashboard** The admin dashboard will enable token administrators to manage the platform and monitor key metrics. It will include: - **Main Dashboard:** - Statistics on the number of users. - Real-time updates on the token price. - A price trend chart. - **User Management Page:** - A table displaying all users, including their details. - Functionality to add new users. - The ability to manually assign tokens to users. - **Token Price Configuration:** - A dedicated page to configure and adjust the token's price. ### **3. User Dashboard** The user dashboard will provide individual users with insights into their token holdings and value. ...
...() with a Microsoft Access database using VBA. The goal is to retrieve directors' and secretaries' names and store them in a table, using company numbers from another table. Below are the detailed requirements: Requirements: 1- API Connection Setup: Establish a connection to the Companies House API using VBA in MS Access. Let me know what API type and credentials for authentication are needed. 2- Data Retrieval: Retrieve directors' and secretaries' names using the company numbers from an existing table in the MS Access database. Ensure the data is accurately parsed and stored in a new table (Optional). 3- Automation: Develop a VBA script to automate the data retrieval process. Additional Notes: Include instructions on how to use and m...
Chez CodeNChill, nous sommes une agence innovante spécialisée dans le développement de sites web vitrine, e-commerce et sur-mesure. Pour ren...possibilité de prolongation en fonction des résultats et des projets Collaboration : Travailler en équipe avec des freelances sur des projets variés Outils : Utilisation de notre serveur Discord pour la communication et la gestion des projets Compétences requises : Expertise en technologies Frontend (React, Vue.js, etc.) Maîtrise du Backend (Node.js, Express, etc.) Bonne gestion des bases de données (SQL/NoSQL) Expérience en API Restful et gestion de projets agiles Capacité à travailler sur des projets e-commerce et sur-mesure Si vous êtes int&eacu...
...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 be straightforward
I'm looking for a C# plugin for Power BI Desktop that can help me optimize my reports. The plugin should: - Detect unused columns in tables and create M queries to remove them. - Scan all open Power BI reports and list them in a combo box for selection. - Identify all meas...for Power BI Desktop that can help me optimize my reports. The plugin should: - Detect unused columns in tables and create M queries to remove them. - Scan all open Power BI reports and list them in a combo box for selection. - Identify all measures in the selected report and provide optimized DAX code for each. A list of these measures should also be in a combo box. My primary data sources are SQL DB and Excel, so experience with these is crucial. The plugin needs to work with both imported data and Dir...
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.
...activation using PHP Mailer - User login - 'Forgot Password' functionality - Bootstrap 5.3 for responsive design - Server-based validation - User-friendly notifications via session on every action Security is paramount in this project. The application must be robust against various types of attacks, specifically Cross-Site Scripting (XSS), Cross-Site Request Forgery (CSRF), and SQL Injection. Additionally, a configuration file should be created with BASE_PATH and BASE_URL for easy management. Forms must be secure, implemented with CSRF and XSS protection as well as using prepared queries for database interactions. Ideal candidates for this project should have: - Extensive experience with PHP and the MVC framework - Proficiency in implementing security measu...
...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 Indi...
...cloud data storage or remote monitoring capabilities. Skills and Experience Required: Proficiency in electronics and hardware setup (experience with sensors like moisture sensors, load cells, and color sensors). Expertise in microcontrollers, particularly Raspberry Pi or Arduino. Strong experience with Python programming, including sensor integration and data handling. Familiarity with databases (SQL) and building basic dashboards/GUI (if required). Ability to troubleshoot hardware and software issues effectively. Previous experience with similar projects (portfolio or examples of past work is a plus). Timeline: Basic Setup (Hardware + Software): ~7–10 days Optional Features (Dashboard, IoT, Database): Additional 5–7 days Budget: Please provide an estimate based on yo...
Sensor data from Arduino to SQL database locally.
I'm seeking assistance with modifying a flat file database. The task primarily involves updating existing records. This is a one-time project.
I'm looking for a comprehensive web-based platform that can analyze and rank YouTube videos based on various metrics. I want the platform to focus on: - Analyzing and ranking videos based on metrics - Utilizing key metrics such as view count, engagement rate (likes, comments, shares), and watch time for the ranking process - Allowing me to select specific channels or videos that will be included in the ranking This project requires an experienced web developer with skills in data analytics and familiarity with YouTube's API. The ideal candidate will have a proven track record of creating similar platforms.
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 should be a retentat...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 CSV...
I'm seeking a skilled social media manager focused on Facebook and Instagram to help increase my follower count. The ideal candidate should be proficient in posting diverse content types, including images, videos, and text posts. Key Responsibilities: - Developing and executing strategies to boost follower count on Facebook and Instagram. - Posting a mix of images, videos, and text posts to engage potential followers. Ideal Skills: - Proven experience with Facebook and Instagram management. - Strong content creation skills, particularly with images and videos. - Great with story posts - Excellent understanding of social media growth tactics.
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
...educators, professionals, and anyone who needs to capture their screen with ease and style. Meet Screen Recorder Pro – your go-to app for high-quality screen recordings with innovative face tracking! Let’s dive into what makes this tool a game-changer." "Screen Recorder Pro is packed with powerful features, making it easier than ever to create professional-looking videos. Here’s what it brings to the table:" "Record your screen in crystal-clear quality with audio capture. Perfect for tutorials, presentations, or any other content that needs flawless visuals and sound." Instant Preview and Playback: "You can instantly preview and playback your recordings. No more waiting—just hit record and start working on your content rig...
...collected. Note whether the show is a long-running production or a special/limited run (if evident). Deliverables Excel Spreadsheet Detailed table for each theatre showing: Ticket price ranges by seating category (premium, mid-tier, budget). Seating category proportions (estimated). Dynamic pricing variations (day-of-week, seasonal, and time-based trends). Show name for each dataset. Summary sheet for ownership groups with: Aggregated ticket price ranges. Pricing trends by group and time of purchase. Evidence Folder Include screenshots showing: Ticket prices for each theatre. Dynamic pricing variations (where applicable). Seating plans (if available). Name each file clearly (e.g., ""). Documentation List of sources used for research. Notes on any assumptions
...Required fields: title (string) description (text) status (enum: Open, In Progress, Closed) customerName (string) opportunityType (enum: Help Request, Handover, Cover Request) startDate: (timestamp, applicable to Handover and Cover Request only) endDate: (timestamp, applicable to Cover Request only) createdAt (timestamp, auto-generated) updatedAt (timestamp, auto-generated) List Opportunities A table or list displaying existing opportunities Each item should show the title, status, customerName, type, and createdAt. In addition it should be possible to see the full details of an opportunity. Update an Opportunity A way to change an opportunity’s status (Open → In Progress → Closed) Bonus Features (Optional but Encouraged) Filtering opportunities by status Sorting ...
...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....
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...
...management features to view, edit, and update customer orders, assign orders to delivery agents, and manage products by adding, removing, or editing listings. There should also be tools for delivery 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 u...
...3456]|9[12468])|C15|D(0[1-9]|1[0-8]|2[024]|6W)|(E(2[15]|3[24]|4[15]|53|91))|F(12|2[368]|3[15]|4[25]|5[26]|9[1-4])|H(1[2468]|23|5[34]|6[25]|[79]1)|K(3[246]|45|56|67|78)|N(3[79]|[49]1)|P(1[247]|2[45]|3[126]|4[37]|5[16]|6[17]|7[25]|8[15])|R(14|21|[34][25]|5[16]|9[35])|T(12|23|34|45|56)|V(1[45]|23|3[15]|42|9[2-5])|W(12|23|34|91)|X(35|42|91))s?[0-9AC-FHKNPRTV-Y]{4}/i', $code, $output_array); if(count($output_array)>0) { $input = $output_array[0]; $eircode = str_replace($output_array[1],$output_array[1]." ",$input); $eircode = str_replace(' ', '', $eircode); $eircode = strtoupper($eircode); } if(in_array(substr($eircode,0,3),$ir_identifiser)) { //$eircode = $eircode." ".$ll; $eircode = $eircode; ...
...Documentation: Prepare analysis, proposals, and expected benefits. Business Policy establishment: Revamp and modernize the HR attendance Policy in line with global standards. Currently Zain Iraq operates standard 8-4 or 9-5 policy during weekdays. Benchmarking: Research attendance policies from industry leaders to identify best practices, modern trends, and innovative solutions. Gap Identification: Compare which best practices to pinpoint gaps and to adapt the flexible suggested hours, inefficiencies, or inconsistencies. Identify the different teams associated (e.g. customer care, finance, technical etc) Policy Development: Draft a short policy, incorporating elements like flexible working hours, remote work guidelines, leave management, and technological tools for tracking a...
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
...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. Collect key information for each lounge, such as: - Lounge Name - Airport Name & 3-Letter Airport Code (IATA) - Terminal and other location details - Access Type (e.g., airline-specific, membership programs, or pay-per-use) - Operating Hours - Amenities and services offered - Ensure all data is accurate, up-to-date, and categorized appropriately. Deliverables: - A structured CSV file containing the compiled lounge data, with columns clearly labe...
I'm experiencing issues with the ADX formulas in MySQL. The results I'm getting from the built-in SQL functions are incorrect. Specifically, I'm trying to calculate the directional movement, but the output doesn't align with my expectations. Skills and experience that would be ideal for this job include: - Extensive knowledge of MySQL - Proficiency with SQL's built-in functions - Experience troubleshooting formula-related issues - Understanding of directional movement calculations
...lighting, carpet pattern, etc.). 2. The new “Aur Kab Tak?” poster designs in multiple colors (orange, yellow, pink, blue, lavender). - **Objective:** Create a **photorealistic** or **highly realistic 3D/staged** render of what the updated booth layout will look like at a similar event venue. We want to see the final arrangement of a large center backdrop plus side roll-up banners, along with a table setup in front and 2–3 staff members interacting with visitors. ### **2. Venue & Setup Requirements** - **Venue Look & Feel:** - Similar to a typical upscale hotel conference hall or banquet room. - Warm, ambient lighting from the ceiling. - Neutral or wood-paneled walls. - Patterned carpet (as seen in the reference photo). - **Booth Layout:**...
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'm looking to build a user-friendly website and a corresponding app for both iOS and Android. This platform will allow families to share recipes, offering various subscription tiers based on user count and desired features. Key Features: - Recipe Creation and Sharing: Users should be able to upload their own recipes, link to web recipes, or write their own. - Ingredient Shopping List: A system that compiles a shopping list based on selected recipes. - Meal Planning Calendar: A built-in calendar for meal planning. - User Personalization: Each recipe should be linked to the user that uploaded it, fostering a personal touch. Subscription Model: - User-Based Tiers: Different tiers based on number of users, e.g., up to 5 users, up to 20 users. Ideal skills and experience for thi...
I am looking for a developer to create a Ninjatrader platform indicator with OrderFlow package. The specific indicator functionality I am looking for is Cumulative Delta vs price. The developer shall have access to paid OrderFlow package by him/herself. The indicator will: 1. show imbalances: different number of buyers/sellers compare to similar price (I will share screenshot) 2. show places where there were many buyers/sellers but the the price didn't go in that direction (absorption) The indicator should be integrated with my existing trading tools - Ninjatrader 8. The indicator will be in C#. You will share the source code with me and assist with testing and adjustments in case the fake behavior of the indicator will be spotted. Ideal skills and experience for thi...
...Districts in Sri lanka. I want to get below insights from that data A. Climate Trends • Temperature Trends: o Analyze average monthly and yearly temperatures by district to identify warming or cooling trends. o Compare temperature fluctuations across districts or regions. • Rainfall Trends: o Determine seasonal rainfall patterns (e.g., monsoon periods). o Compare districts with consistent high or low rainfall. • Extreme Weather Events: o Identify outliers in data (e.g., droughts, floods) and their frequency. o Correlate with disaster response data if available. B. Regional Comparisons • Compare coastal and inland districts for variations in weather. • Analyze regions most affected by specific weather patterns, like heavy monsoons or heatwav...
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.
We look for a professional web developer with SQL, PHP, Zend / Laminas / Wordpress and coding knowledge that can reprogram / uplift a existing and working quotes & jokes website (Mobile compatible) from Zend 1.12.2 to Laminas and from php 7.4 to php 8.3 where all current functionalities are covered (front & backend). We are also open to lift the whole project into wordpress, hence it would help to administrate the site, but this is only a option if all existing functions can be covered. The site has a database with keywords, authors, topics and pictured as well as a ranking system of the quotes. Also a improvement on current site loading speed fot most ranked quotes should be improved. SEO is also covered well now but some improvemtns might help too. We need a clear proper c...
...features an organization chart that currently doesn't fit on a single page and click event to view the number of person on the Job Category showing in the chart. Microsoft Visual Studio Project & SQL Database backup attached, attached the Organization Chart Generated by this application. Key Tasks: - Adjust the layout of the chart to a vertical orientation. - Ensure the chart fits within a single page. -Click Event on Each Job Category Ideal Skills: - Proficiency in ASP.NET and Microsoft .NET Framework. - Expertise in graphical layouts and responsive designs, including jQuery. - Experience with SQL database integration for handling chart data. - Ability to deliver a quick and efficient solution. Most Important: - The chart should be responsive primarily for d...
I have an AI-generated fictional novel set in India t...with a significant focus on descriptions and settings. I also need to minimize the word count without losing the essence of the story. Key Tasks: - Humanizing the descriptions and settings - Minimizing word count effectively The novel's style is detailed and vivid, so your ability to create rich, intricate settings and contexts will be crucial. The tone of the story is serious and dramatic, so an understanding of this tone will be necessary in your edits. Ideal skills for this project include: - Proficient editing and writing skills - Experience with novel writing and editing - Understanding of serious and dramatic tones - Ability to create detailed and vivid descriptions - Skill in minimizing word count ...
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.
I'm looking for a social media expert to help me increase my followers on Instagram through the promotion of images and videos. Key Responsibilities: - Create and implement a strategy to boost follower count. - Promote a mix of images and videos to attract potential followers. Skills and Experience Required: - Proven track record of increasing Instagram followers. - Strong understanding and experience in promoting images and videos on Instagram. - Ability to create engaging content and strategies.
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 manual updates...
