Build executable based access database jobs

I'm seeking an experienced developer or team to create a cloud-based, multi-tenant (SAAS model), user-friendly CRM system. The front-end will be built using Angular, while the backend API will be developed using .NET Core. Key Requirements: - The CRM should manage various customer interactions, including email communications, phone call tracking, and live chat support. - It should incorporate sales pipeline management and automatic lead scoring as crucial sales tracking features. - The system needs to handle different types of leads: cold, warm, and hot. - The design must prioritize a user-friendly interface for end-users, coupled with a scalable backend. Ideal Skills and Experience: - Proficiency in Angular for front-end development. - Extensive experience with .NET Core for...

Convert Excel data to Access for monthly data storage and invoice calculation and creation for small water utility company.

As we seek long-term work, I am seeking value for money, so p...Clean and secure websites, ensuring that they function optimally. o Utilize available backups for complete restoration. 3. Client Backend Restoration: o Rebuild and restore the backend admin panels to allow clients to access their accounts and manage information easily. Requirements: • Strong experience in WordPress development and PHP. • Deep knowledge of server management (Linux experience required). • Expertise in WordPress malware cleanup, securing websites, and restoring themes. • Proven ability to handle backend client user information restoration and ensuring proper access to admin panels. • Ability to resolve issues efficiently and provide long-term maintenance support. Am looking...

I'm seeking a freelancer to run a Python script that scrapes the entire DataAxle database of 18 million companies. The end goal is a comprehensive spreadsheet that includes all available fields. Example fields include: - Company name and address - Industry and revenue - Number of employees and contact details - SIC Code - SIC Code Description The primary purpose of this data collection is for sales leads generation. Ideal Skills: - Proficiency in Python - Experience with web scraping - Familiarity with DataAxle or similar databases - Ability to generate clean and comprehensive spreadsheets - Understanding of sales lead criteria

I'm seeking a skilled developer to create a web-based application that simplifies the creation of Word documents, specifically for tax documentation reports. Requirements: - Build a user-friendly e-commerce platform that allows for easy document creation and purchasing of additional features. - The web based application should let users add their data and generates word documents in a particular manner. - The web based application should enable user to add tables and the data to be linked. - Integrate a secure payment system for transactions. - Implement a content management system for users to save, edit and track their reports. Ideal Skills and Experience: - Extensive experience in web application development, preferably with e-commerce and CMS systems...

I am looking for a developer to help build a straightforward platform with two user personas: Buyer and Seller. This platform's unique selling point is facilitating the sale of sellers' phone numbers. I already have a UI/UX design in place, but it requires minor adjustments to suit this business model. The seller are listing their business (i.e., they would like to sell their own business and they will list their business with all information and buyer will search for business and when they like a business they will pay a fee in order to access the contact information) Key Requirements: - Buyer Functionality: The Buyer persona needs the ability to browse and search for sellers. - Seller Functionality: The Seller persona should be able to create and manage their o...

I'm seeking an experienced Android application developer to help me fix some issues in my app, "The Shelter". This application, designed to identify homeless individuals, is currently experiencing some functional errors and performance issues. Key Responsibilit... Key Responsibilities: - Debugging: Identify and resolve functional errors and performance issues to ensure smooth operation of the app. - Interface Enhancement: Improve the visual design and user experience flow of the app to make it more intuitive and pleasant for the users. The app is not yet publicly accessible on Google Play. If you're interested, please send me your email to get limited access before the official launch. Your expertise in Android development, debugging and UI/UX design is crucia...

...+ Academic & professional certificates requests/approvals] is a unified app that is integrated with existing business applications (i.e., SAP Fiori, Correspondence, Tender Board…...etc.), providing employees with abilities to initiate Services requests, approve and track workflows, find documents and emails, access analytical reports, interact with a digital assistant (Meera) and more. * oneTalent ( uses data, potential , development plan and opportunities to generate AI programs based on your talent for our future leaders. leveraging AI in our learning system will motivate our productivity and uncover hidden talents...

...the Song of the Week, and it will open a TikTok/Reel-style video with a generic background, bilingual lyrics, and translations displayed in real-time, so I can learn while watching. As a user, I can click on individual words in the lyrics to see their translations and save them to a vocabulary list for review. As a user, I will be quizzed at the end of the song with fill-in-the-blank questions based on the song’s lyrics, so I can reinforce what I’ve learned. Example Quiz: "How do you say 'dance' in French?" Discover Tab As a user, I can click on the "Discover" tab to see content creators who have posted covers or lip-syncing videos in my selected language, so I can learn from their content. As a user, I can watch content creator videos w...

I'm looking for an experienced C# .NET Core developer to create a Profinet driver that operates as a Windows service. The application should have a web interface for configuration and management of the driver, and function as a RESTful API for data access. Key requirements: - The driver will collect sensor readings and send it to a specified endpoint. - It should manage its own cache, which size can be configured based on the number of days of data retention. - The web interface should allow for driver operations management (start/stop/restart), endpoint configuration for data transmission, and cache size and retention settings. - The driver should use Basic Authentication for its RESTful API. Ideal skills for this job include: - Proficiency in C# and .NET Core - Expe...

We are looking for a skilled development team to build a multi-platform business services platform that enables clients to purchase and manage various business services, including branding, printed materials, social media management, and ERP software solutions. Project Overview Platforms: Web Application Mobile Applications (iOS and Android using React Native Expo) Dashboards: Client Portal Admin Portal Employee Portal Guest Portal Preferred Tech Stack: Frontend: React (Web) and React Native Expo (Mobile) or Flutter Backend: NestJS or Database: Prisma ORM Core Features Guest Portal (Web & Mobile): Welcome screen showcasing platform highlights. Options to sign in, sign up, or continue as a guest. Menu with sections: Products, About Us, Portfolio, Branches, and Client...

...Strong understanding of modern web design principles - Expertise in creating user dashboards This project is an exciting opportunity for a talented web developer looking to make a mark in the fintech industry. High level Idea: I want to create a website where users can learn how to minimize their tax amounts. They will enter their details, see the calculated tax and potential savings, and get access to a dashboard with tax-saving strategies after making a payment. Home page reference: Similar service offering by other company: I would suggest to go through the flow. Login Login through mobile number & OTP Payment: Razorpay Dashboard: Could share a rough idea. 1. Income 2. Investment 3. Deduction 4. Tax calculation

...following components: 1. U-Shaped Supermarket: • Customers enter on one side and checkout at the other. • Include: • Storage area for supermarket use • 2 toilets for staff • Efficient use of dead space 2. Entrance for Upper Floor (Clinics): • Use the fixed staircase location to design a dedicated entrance for the upper floor. • Ensure clear signage and separation from the supermarket for easy access. 3. Rentable Store Units: • Divide the remaining space into the maximum number of rentable units for small businesses. • Ensure all units have frontage to hallways or main walkways for visibility. Requirements for Ground Floor: • Functional layout with clear customer flow • Maximization of rentable space • Com...

Will create a proper google form and sheet according to your requirements.

I'm looking for a skilled videographer who can capture the essence of my upcoming birthday party in a cinematic style. Key Responsibilities: - Capture the arrival of guests with a keen eye for detail and creativity. - Use of hig...Responsibilities: - Capture the arrival of guests with a keen eye for detail and creativity. - Use of high-quality equipment to ensure a polished final product. - Edit footage into a cohesive, engaging video that reflects the cinematic style. Ideal Skills: - Prior experience in event videography, particularly birthday parties. - Strong portfolio of cinematic style videos. - Excellent editing skills and access to professional-grade editing software. I want this video to be a wonderful keepsake of the day, so a love for capturing life's specia...

I'm seeking a skilled developer to create an AI Bot for Telegram linked to our ne...manage Telegram interactions. Key Requirements: 1. The bot should offer users a 24-hour free trial. 2. Post-trial, users should pay in our ETHERIAL AI Tokens to maintain access. 3. The bot must handle payment and subscription management using our token. 4. It should deliver an intuitive user interface with seamless functionality. 5. Regular updates and maintenance should be based on user feedback. Ideal Candidate: - Strong experience with AI integration - Proficient in Telegram bot development - Skilled in creating user-friendly interfaces - Capable of managing payment systems within a bot - Open to delivering regular updates based on feedback Makesure you know about Ai Integrat...

...assist in pinpointing customer locations on a map. The app needs to function offline with both automatic and manual data synchronization when internet access is available. The dashboard, meant for advanced analytics, should track: - Top Customers - Best-Selling Products - Delivery Staff Performance This dashboard will have role-based access to limit sensitive information. Additionally, the app should support importing a client database from Excel. Ideal skills and experience for this job include: - Proficiency in Android app development - Experience with offline functionality and data synchronization - Knowledge of creating role-based access systems - Capability to develop advanced analytics dashboards I am looking for a functional, s...

I'm in need of a PHP script that will restrict all search engine crawlers from accessing any page on my entire website. The script needs to be robust and capable of preventing page access for these bots. Ideal Skills and Experience: - Proficient in PHP - Experience in web security - Knowledge of bot detection and blocking techniques

Attached is a image of an icon. I would like a 256px x 256px version. It should have the same appearance but look good at that resolution.

...support for troubleshooting or adjustments. Requirements: Proven experience with Shopify and payment gateway integration. Familiarity with Shopify apps and API integrations. Strong attention to detail and problem-solving skills. Good communication and ability to meet tight deadlines. Additional Information: The API keys are time-sensitive, and this project must be completed within a strict timeframe. Access to the keys and additional documentation will be provided at the start of the project. Timeline: We require this integration to be completed within 3 days. How to Apply: Please include the following in your application: Relevant experience with Shopify payment integrations. Examples of previous Shopify projects. Your estimated time to complete the project. Your rate or pri...

I'm seeking a dynamic salesperson to market and sell our comprehensive suite of digital marketing services, which includes SEO, social media marketing, and Pay-per-click advertising. This role is commission-based, offering you the potential for significant earnings commensurate with your sales success. Key Responsibilities: - Drive sales across various platforms including Google Ads, Facebook Ads, and LinkedIn Ads. - Cultivate relationships with potential clients and negotiate sales. Ideal Candidate: - Previous experience in digital marketing sales is essential. - Possesses strong communication and negotiation skills. - Has a proven track record of meeting sales targets. Skills and Experience: - In-depth understanding of digital marketing services. - Experience with Google ...

...cannot be downloaded or copied in any way. Security is a top priority, and the plugin must implement robust measures to protect the documents from unauthorized access or sharing. The plugin must be compatible with the latest version of Moodle and integrate smoothly with Moodle’s existing file management system. It should have a user-friendly interface for both administrators and users, ensuring a hassle-free experience. The ideal developer should have proven expertise in Moodle plugin development, with strong proficiency in PHP, JavaScript, and Moodle APIs. Familiarity with document viewer libraries and techniques to restrict document access will be a significant advantage. Deliverables include a fully functional and secure Moodle plugin, detailed installation and ...

I'm looking for a proficient Terraform developer to create a script for Google Cloud. We need the script to create these items 1. networking 2. GKE cluster with one node 3. permanent volume and claim for GKE 4. Postgres SQL service - needs to be accessible from GKE 5. API Gateway - if API URL is /example1 > run a lambda function - otherwise forward API request to /endpoint/{incoming URL)...create a script for Google Cloud. We need the script to create these items 1. networking 2. GKE cluster with one node 3. permanent volume and claim for GKE 4. Postgres SQL service - needs to be accessible from GKE 5. API Gateway - if API URL is /example1 > run a lambda function - otherwise forward API request to /endpoint/{incoming URL) (a service running in GKE) 6. IAM Role Binding for ...

I need an existing PCB design re-created from provided Gerber files. The project involves a PCB with 220x LEDs. You will be supplied with: - Gerber, component position, and BOM files of the design - A r...position, and BOM files of the design - A reference design to emulate The expected output is: - Comprehensive KiCAD files (including schematics and PCB design files) - The original design with added appropriate heatsink pads Ideal skills and experience for this job include: - Proficiency in using KiCAD - Experience in PCB design - Ability to incorporate heatsink pads based on thermal requirements Please note, while you will have access to a reference design, I expect you to use your best judgment and expertise to create a functional and effective PCB design. Duration to...

...it should be based on comparing its importance to the current level of detail. 7. The library must work correctly in multithreaded applications. 8. Proper initialization and shutdown of the library should be ensured. source code of the library should be compliant with POSIX and C language standards. Project 2: The goal of this project is to write a task scheduling program that serves as a functional equivalent of the cron program () known from Unix systems. The program should meet the following requirements: 1. It should be based on the mechanism of interval timers. 2. The program should be controlled by command-line arguments. 3. Only one instance of the program should be able to run at a time (the first launch of the executable starts the service

I have several Excel/CSV files containing sales records that need to be transferred into our current digital system, which is a txt format. Key Responsibilities: - Accurately input sales data from Excel/CSV files to the txt system. - Ensure data integrity and correctness during the transfer. Ideal Skills: - Proficiency in handling Excel/CSV files. - Attention to detail for data ...containing sales records that need to be transferred into our current digital system, which is a txt format. Key Responsibilities: - Accurately input sales data from Excel/CSV files to the txt system. - Ensure data integrity and correctness during the transfer. Ideal Skills: - Proficiency in handling Excel/CSV files. - Attention to detail for data accuracy. - Experience with data entry and database m...

I am looking for a proficient web developer to create a platform where I can sell my digital products. The platform should allow customers to access the products online through an account. Key Features Include: - Subscription Management: The platform should be capable of managing subscriptions for different tiers of access to my products. Ideal Skills and Experience: - E-commerce platform development - Subscription management system integration - Experience with digital product delivery systems A strong portfolio with similar projects will be a plus. Looking forward to your bids.

I'm seeking assistance to update our membership records for our non-profit organization. The data is currently housed in a Microsoft Access database. Ideal candidates for this project should: - Have experience with data entry, particularly within a Microsoft Access environment. - Have a keen eye for detail to ensure accuracy in updating our records. - Prior experience working with non-profit organizations would be an advantage. I am looking for a freelancer who can take this task off my hands so I can focus on our mission.

...should be robust, efficient, and secure, supporting APIs tailored for the roles. Frontend elements will ensure user-friendly interactions for Players, Admins, and Super Admins. Key Project Requirements: Roles and Access: 1. Players: ◦ OAuth-based login system (Google). ◦ Separate database table for Players for added security. 2. Admins: ◦ Email-password authentication. ◦ Manage player disputes and KYC processes. 3. Super Admins: ◦ Same login flow as Admins. ◦ Elevated permissions for dispute resolution and platform oversight. Features for Players: 1. Authentication: ◦ OAuth-based login (Google) (Already Implemented). ◦ Logout functionality (Already Implemented). 2. Tournament Management: ◦ Search for tournaments using filters. ◦ Create tournaments (if KYC v...

I am experiencing critical problems with my official website due to MySQL database connection issues. The site is built using PHP, and I need a seasoned professional with extensive experience in PHP and MySQL to get it back on track. ***It should be fix remote access only. *** Key Responsibilities: - Diagnose and fix all database connection issues - Ensure the website is fully operational post-repair Ideal Skills: - Proficient in PHP and MySQL - Strong troubleshooting skills for database issues - Experience working with official or business websites

...intended - Usability Testing: Checking the app's user-friendliness - Performance Testing: Evaluating the app's responsiveness and stability Website Testing: - Specific focus on Search Functionality: Testing the efficiency and accuracy of the search tool. Supplier and Admin Panel Testing: - Prioritize Data Management: Testing the handling, processing, and storage of data. - Access Control: Ensuring only authorized users can access certain features. - Reporting Tools: Checking the functionality and accuracy of reporting features. Ideal skills and experience for this job include: - Proven experience in software testing, specifically for Android apps and websites. - Strong understanding of functional, usability, and performance testing. - Excellent attention to de...

Please Sign Up or Login to see details.

UK Access Solutions Ltd are a large regional Scaffolding Contractor, Looking for a remote, skilled and qualified scaffolding designer who can cater to all types of structures, be it residential, commercial, or industrial. The role involves: - Regularly designing scaffolding systems to complement our UK operations. - Understanding and creating designs suitable for varying heights and stages of construction. Ideal candidates should possess extensive experience in scaffolding design, with a keen understanding of different structural requirements, with full Knowledge of UK Regulations. The ability to work collaboratively with our UK Teams and meet strict deadlines will be essential.

I'm looking for a Typescript expert to write Typescript serverless functions to: OLD SYSTEM -> Webhook -> Serverless Function -> New Database and OLD SYSTEM <-> Crap API <-> Serverless Function <-> New Database Bidirectional sync Webhook includes the data that needs to be updated in a timely manner Crap API can sync other data (non-timely) and verify the webhook data was correct to update periodically Challenges include: - Inconsistent webhook formats - Unreliable API behavior of old system - Token management of old system API Technical Stack: - Serverless Functions - Database - Modern TypeScript Deliverables: 1. New Database configured with schema and operational 2. Working and fully tested serverless functions - Webhook Han...

I'd like to have a slide template design in ppt format matching logo design guidelines.

I'm seeking a talented Figma designer who can improve upon a provided sample. The focus will be on two card types that display key metrics. Key Requirements: - Improve design elements for enhanced visual appeal - Ensure a clean, modern, and user-friendly layout - Strict adherence to the provided mockups as inspiration Please avoid introducing random designs or themes that deviate from the sample's structure and intent. I'm open to your expertise, but if there are any doubts or clarifications required, please ask before proceeding to avoid misalignment with expectations. If the design meets expectations, we can collaborate further on additional requirements.

...cards via third-party providers. inventory, transaction, and API management. 4.Top-notch security and failover mechanisms. 5.Real-time reporting and analytics. Our Tech Stack: Backend: Node.js, Frontend: (UI designs already available; needs integration). Database: MongoDB Cloud: AWS for hosting and server management. Other Tools: Redis, RabbitMQ/Kafka, Prometheus, Grafana, ELK Stack Key Responsibilities: and optimize APIs for seamless client integration. 2.Build scalable, secure admin and client dashboards. dynamic API switching and failover mechanisms. compliance with data protection regulations (GDPR/CCPA). designed UI into the platform using What We’re Looking For: expertise in Node.js, Express

...Document Management: OCR-based document reading for faster verification. Credit Assessment: Automated scoring with parameters like income, property value, and credit history. Workflow Management: Customizable approval hierarchies. Loan Management System (LMS): Repayment Tracking: Auto-reconciliation of payments. Customer Support: Service requests like account statements, loan closure. Analytics: Generate performance reports (e.g., NPA tracking, overdue reports). 5. Technical Requirements Platform: Web-based application with mobile responsiveness. Integration: APIs for credit bureau checks. Payment gateway and accounting software. CRM and external legal tools. Data Security: Compliance with data protection laws (e.g., GDPR, IT Act). Secure access with role-bas...

...platform, ActiveMoodle, according to specific design templates and brand guidelines. Tasks include: - Updating our site theme, including the home page and course pages, to align with the premium Maker theme with certain brand and color customizations. The premium template will be provided. - Modifying the Udemy-style course landing pages with specific visual design changes. - Ensuring course access is limited to registered or enrolled users only. The ideal freelancer for this job should: - Have a strong understanding and experience with Moodle. - Be able to implement specific brand and color customizations accurately. - Have a keen eye for visual design changes. - Understand functionality requirements for e-learning platforms. Please note that we will create our own course co...

 Statement Of Work User App: -  Login o Login with Mobile Number:  Users can enter their registered mobile number to access the app.  Login with OTP: o Users receive a One-Time Password (OTP) on their registered mobile number.  Signup o Signup with Personal Details  Users can create a new account by providing o Name o Email address o Mobile number o Password  Home Page o Users can view Banners o Users can view Sliders  View Subscription Plan o A list of available Subscription plan is displayed, categorized by:  Duration (e.g.; 1-month,3-month,6-month, 1-Year)  Select Packages o Shortlist Favorite Packages  Users can add plans to a “Favorites” list for quick future purchase. o Choose a Package  Once finalized, users can select a plan to proceed with purchase. ...

I'm looking for a software engineer or a team of developers who can build a complete, robust, and user-friendly SaaS solution for managing a gated community, with a primary focus on resident management. The software should be comparable to existing solutions like MyGate, but with unique features and enhancements. Key Features: - Comprehensive resident management: This includes tracking of resident information, managing visitor access, handling security alerts, and monitoring community engagement. - Payment and dues tracking: The software should have a seamless interface for tracking payments and dues from residents, with automated reminders and updates. - Communication tools: The platform should feature interactive communication tools similar to message boards, allowing...

I need a JavaScript-based URL redirect that includes the source URL and dynamic query parameter. The query and the source url information should be forwarded to the redirected page. Ideal candidates for this project should have a strong understanding of JavaScript, URL structures, and web redirection processes. Please also have the ability to test and troubleshoot the redirects to ensure all parameters are being correctly included and displayed.

I'm selling my professional Shopify-integrated print-on-demand website, Vera Forma Official. This site is fulfilled by Qikink and...e-commerce entrepreneur. Website link :- Key Aspects: - The buyer will need to purchase a Shopify subscription and buy the website to gain access to the exclusive Qikink products. - The ideal freelancer for this project should have a strong background in e-commerce, experience with Shopify and print-on-demand services, as well as skills in website marketing and advertising. The primary goal of this project is to effectively sell the website to the right buyer. The target audience for this website mainly consists of print-on-demand enthusiasts. The unique selling point of Vera Forma Official lies in its access to exclusive Qikink products...

...documents, etc - Providing reports post-diagnostic imaging procedures from our current RIS/PACS (Radiology Information System/ Picture Archiving System) by seamless integration - must be HIPPAA and HL7 compliant - A private section for inter-company interactions per client, including document and ID card uploads - Enabling clients to upload during onboarding via file upload or camera - Full database access for marketing, reminders, and push notifications - Integration with our current RIS/PACS system for seamless information transfer - Customer query handling and support Please note that we don't require payment processing at this stage. Ideal candidates should have: - Extensive experience in web and mobile app development, particularly for CRM systems - Proficienc...

Project Title: Looking for a ...in the market. Monetization Features: Integrated monetization options such as subscriptions, ads, affiliate marketing, or e-commerce capabilities. Analytics and tracking for performance and revenue. Customization & Scalability: Easily customizable to match branding and marketing goals. Scalable for future growth and expansions. Niches of Interest: Deliverables: Complete source code or admin access to the platform. Documentation (user manual, installation instructions, etc.). Assistance with initial setup and deployment. Please share your proposals with: A demo link or screenshots of the website/software. Details about the features and functionality. Monetization methods and any proof of performance, if available. Looking forward to your ideas ...

... so we’re looking for someone with a flair for creating inspiring and emotionally engaging videos. Your Responsibilities: Creative Work: Independently compiling video sequences using stock materials. Utilizing stock material platforms (e.g., Pexels, Pixabay) – ideally, you have access to additional platforms with high-quality content. Transforming ideas and concepts into visually appealing video contributions. What You Bring: Experience as a video editor or cutter. A creative eye for visual and sound editing. Access to stock material accounts is a plus. German language skills at a native or very high level. What We Offer: Flexible Work: You will work independently and can manage your own schedule. Regular projects with engaging topics. Collaboration with a crea...

I'm in need of a detail-oriented freelancer for a data entry project. The task involves manually entering data from PDF files into a database. Ideal Skills and Experience: - Proficiency in manual data entry - Experience working with PDF files - Familiarity with database systems - High attention to detail - Ability to maintain confidentiality and handle sensitive data with care.

...metadata via a user-friendly web interface, and using OpenAI's embedding with a vector database and GPT APIs to retrieve and generate new content. This will be a new independent prorotype project to get the integrations and workflow set up and working correctly. Full-Stack Developer (Preferred One-Dev Solution) Responsibilities: Develop and maintain a backend pipeline to: - Scrape and preprocess data from client websites. - Chunk content into JSON packets and prepare it for tagging. - Integrate with Supabase for data storage. Build a simple web app for manual metadata tagging: - Design a clean UI for reviewing and tagging content. - Integrate pre-defined tag options for consistency. Set up a vector database for semantic search. Integrate OpenAI’s t...

I'm seeking an experienced developer to create a comprehensive Library Management System. Key Features: - Book Registration: Input details like title, author, publication date, and copies. - Book Search: Search by title, author, publication date, and genre...title, author, publication date, and copies. - Book Search: Search by title, author, publication date, and genre. - Book Borrowing Management: Track loans with due dates for return. - Reporting: Generate reports on borrowed and returned books, and total inventory. - Database: Use SQLite or MySQL for storing book and user information. User Access: - Access is limited to Administrator and Librarian Ideal Skills: - Proficiency in database management - Experience in developing management systems - Abili...

I'm looking for a professional video editor based in the USA to edit 25 promotional videos monthly for my client. Each video is under 1 minute in length, and the editing style should be clean and professional. Details: - Monthly Requirement: 25 videos - Payment: $25 per video - Freelancing: Allowed - Editing Style: Clean and professional, suitable for promotional content. Reference and raw clip