Sync database mysqlJobs
More details: Is this project for business or personal use? Personal What information should successful freelancers include in their application? Past work How soon do you need your project completed? Within a month
Vær venlig at Tilmelde dig eller Log ind for at se detaljer.
I'm in need of an experienced professional who can assist me in transferring a large-scale database. Key requirements include: - Proficiency in handling and transferring databases, specifically SQL Server. - Experience in migrating large databases, in this case, exceeding 10GB. - Demonstrated knowledge in handling data and ensuring its integrity. - Ability to ensure smooth transfer with minimal downtime. Your role will involve transferring selected data safely, efficiently and without data loss. Prior experience with similar projects is highly advantageous.
I'm seeking a specialist to help me integrate Vonage with our QQ Catalyst CRM. This is a two-fold project involving: 1. Call Logging and Recording: I want all our call details to be logged and recorded seamlessly within the CRM. 2. Contact Information Sync: I require both the name, phone number, and email address from QQ Catalyst to be integrated with Vonage for easy contact accessibility. The ideal candidate will have prior experience with both QQ Catalyst and Vonage, and a proven track record of successful CRM integrations. Your expertise in customizing and integrating APIs will ensure the smooth interaction between these two platforms. You must possess the technical skill to troubleshoot issues that might arise during the integration process. FOCUS: - CRM Integrations ...
I am looking for an expert Salesforce data analyst who can identify and analyze data discrepancies between Zuora and Salesforce. Specific fields to consider include: Scenario: Scheduled Sync has not run successfully in quite some time and there might be many records that are out of sync between the 2 systems Given: scheduled sync in Zuora is not completing a successful run from noV 2020 When: we analyze the data between the 2 systems by exporting data out of Zuora and comparing it with Salesforce Then: we should be able to document how many records are out of sync for “status”, “outstanding balances”,”late fee”, “auto renew” etc
... Key Features Required: - Customer Database Management: A well-structured and easy-to-use database to store customer details efficiently. - Sales Tracking: Built-in capabilities to track and analyze sales data, which will enable us to better understand our business growth and trends. - Inventory Management: An integrated inventory management system to efficiently monitor stock levels and streamline our operations. - App Integration: A feature that can seamlessly connect our clients to our business through an app. Core Skills and Experience: Ideal freelancers should possess: - Proficient skillset and experience in software development (specifically Windows and macOS compatible software). - Knowledge in developing systems for Customer database, Sales track...
I'm in need of a seasoned Flutter developer to create a mobile application compatible with both iOS and Android for an established business. Key Tasks include: - Designing and progr...(Know the user's location and be able to configure a radius to find products, businesses, events in the indicated radius) c. Calendars to see events, or create appointments. d. Content management such as video documents. and. Payment system that generates unique QR codes for events or any purpose, with Stripe. F. Sending emails or notifications to app users. 2. Firebase. 3. Aws, preferably using mysql databases, to integrate with the website. 4. Integration with 5. strip as a payment gateway 5. Focused on a unique and 100% aesthetic and functional design. Only apply programmers with demo...
...microservices, MySQL, Node.js, and React to create an extensive hospital management application. The app will service a wide audience comprising patients, doctors, hospital staff, and board directors. Key Features Needed: • Appointment scheduling based on doctor availability with easy patient extension. • Patient registration facilitated by mobile OTP verification. • An efficient system for medical records management. • Seamless integration for various payment options including credit/debit card, UPI, and netbanking. • A user-friendly dashboard displaying pertinent data based on the user's role. • Report upload and download capability. • Wallet balance check and refill functionality. Login Requirements: • Registration to store user d...
I require an adept video editor to synchronize my video and audio files. There is one audio file and two video files. This is for a podcast, so I recorded the audio and video separately. However, I don't require additional features like background music, subtitles, or special effects. The timeline for this project is tight, as I require it completed immediately. Skills & Experience: - Proven expertise in video editing - Familiarity with MOV files - Previous work in audio-video synchronization - Able to meet short deadlines
...tools, specifically ClickUp and Clockify. Our goal is to streamline our workflow by ensuring that activities in ClickUp are automatically mirrored in Clockify. This includes the creation of new tasks/projects and the synchronization of time entries. Key Objectives: Task/Project Creation Sync: When a new task is added in ClickUp, a corresponding project/task should be automatically created in Clockify. The new task in Clockify should be accessible to the same users who are assigned to it in ClickUp. Time Entry Sync: Time entries made in ClickUp should automatically post in Clockify against the corresponding task/project. This includes accurately reflecting the duration and any specific notes associated with the time entry. Requirements: Experience: Proven track record wi...
...REPOSITORY WHICH HAS ALL THE CODE AND SEND IT TO ME. I want to run the website on LOCALHOST. I wont be HOSTING it. The name of the website is RenderzHub. Have a look at as it has the features that I need in my website. But don't go to put efforts in making it exact as artstation. Languages to be used: Front-end: HTML, CSS, JavaScript using React.js framework. Back-end/Database: PHP with MySQL. The website should have following: • Starting page: Page that is shown when website is visited; Has Get Started, Sign Up and Sign in; Refer demo video. • User Sign Up and Sign in: account creation process- entering name, email, password, contact; can have Google sign in; • User profile: Users should be able to customize their profile, add soc...
I have an article directory site that I had recently upgraded by a freelancer with a newer version of MySQLi so it would run again. The si...recently upgraded by a freelancer with a newer version of MySQLi so it would run again. The site is working but I have just noticed there's a minor error in the database that won't let you enter the proper "Category" of a new article with a drop-down window when you try to add a new one (see attached image). This is done in the site's web-based control panel. Just looking to get this fixed, it shouldn't take too long if you know what you're doing. Sorry I am not willing to pay more than $10 to get this done, I've already spent so much money on it and fooled around with people who couldn't fix the...
I need a professional who can incorporate a tailored tracking page on my Shopify website. This page should sync directly with the OrderID/APIEndpoint of SelloShip, my logistics partner, to keep tabs on the order status. Key Tasks: * Establish connection with SelloShip's OrderID/APIEndpoint for streamlined tracking * Design a complete, well-integrated page with emphasis on aligning with my website's aesthetics * Incorporate a well-structured UpSell/CrossSell segment on the page showcasing related products tied to the purchased items I'm unsure about the availability of API documentation or integration rules laid out by SelloShip, so a bit of research might be in order. Required Expertise: * Proficient in Shopify web development * Prior experience with custom trac...
...project with a MySQL database where I am currently having issues with pagination. The records in the table are not being sorted correctly, and I need assistance to fix this. Here's what I am looking for: - Experience with PHP and MySQL. - Familiarity with table pagination in PHP. - Understanding of ORDER BY clause in MySQL. I require someone who can take a look at my current PHP code and figure out why it is not sorting the records in the table correctly. The number of records, specific columns used for sorting and the current ORDER BY clause in my PHP code can be shared once we proceed with the project. The end goal is to have a paginated table that is correctly sorted and displayed. This should be a relatively straightforward job for someone with e...
...need of a seasoned professional who is adequately versed in JSON, PHP and MySQL to create a TD Ameritrade API script. The purpose of this script includes data retrieval of stock and option chain and placement of limit orders grounded on terms from a MySQL settings table. Key Requirements: - Develop an API script with specific conditions for limit order implementation in terms of price and time. - The retrieved data should focus on stock prices and option prices. - The displaying of retrieved data should be structured in a table format with the ability to submit the order via button click (unless "autotrade == '1' in the setting table). -Any orders submitted should be logged in a separate Ledger table within the database and used to avoid duplicate s...
I’m seeking an experienced database developer to build two MariaDB/MySQL nodes using Galera, aiming to ensure high availability of our transactional data. Your responsibility will be centered on constructing these clusters to maintain constant uptime and assuring that they serve as a dependable solution for our growing needs. Primary Tasks: - Creation and configuration of two MariaDB/MySQL nodes using Galera. - Migration of transactional data from an existing MariaDB/MySQL database to these new nodes. Ideal Skills: - Significant experience with MariaDB/MySQL and Galera cluster. - Proficient in database migration processes. - Strong knowledge in high availability solutions. Your expertise will play a vital role in guaranteeing ou...
I'm sought after a seriously proficient developer with strong skills in Php, MySQL, and JavaScript. The project requires both software language proficiency and problem-solving skills. As a developer, you need to have comprehensive knowledge of development frameworks to deliver an exceptional outcome. Details: Category: Game Game Name: Gta V Platform: Ragemp Type: Roleplay Highlight: Must have knowledge of programming so that one can code well. I want to make a role play server for the game which will have more JavaScript work. Your application will stand out if you can demonstrate your ability to apply your skills to previous projects and show tangible examples of your work. Let's create something exceptional together!
I need a tech-savvy individual to set up my Control Web Panel (CWP) on my Virtual Private Server (VPS). Since my VPS is running on Linux, having a strong background in this operating system is essential. Ple...(VPS). Since my VPS is running on Linux, having a strong background in this operating system is essential. Please be prepared to provide: - Basic Security setup on CWP. Prior experience with Linux security protocols is a bonus. - Installation and configuration of specific services including: - Web Server (Apache, Nginx, LiteSpeed) - Mail Server (Postfix, Dovecot, RoundCube) - Database Server (MySQL, MariaDB) Deep knowledge and proven experience with these servers and databases are required for this project. Appreciate your interest and look forward fo...
For my upcoming Laravel-based project, I am looking for an expert Laravel developer. This project will be developed from scratch and its main functionality will be a robust data management system. - Required skills and experience: - In-depth knowledge of Laravel PHP Framework - Previous experience in creating data management systems - Expertise in MySQL or similar databases I do have specific requirements and will provide the detailed documentation to the selected candidate. The developer would need to follow these requirements closely to ensure the project's success. Strong problem-solving skills with an analytical mind would be a major plus.
I'm looking for a skilled professional to design and implement a MySQL database system. The database cluster, mysql router, should feature: - data warehousing, Data analysis tools to interpret and present data in a meaningful way. - User management systems to organize and regulate users effectively. - Cluster management, sql router management. - Open source tool to monitor the slow query, query...effectively monitor the data base. Ideally, the system should be equipped to store an estimated 10,000 to 500,000 records. Strong experience with MySQL is imperative, alongside a working knowledge in data analysis, user management, and real-time data updating functionalities. Your portfolio demonstrating similar projects will be highly appreciated.
Students Database of 11th STD and 12th STD Science , currently interested in NEET/JEE Free courses and free test series .
I am looking for someone proficient in Excel and familiar with MySQL databases to assist me with data collection, manipulation, and analysis. The ideal freelancer would - Have proven experience in Excel, specifically in data manipulation and analysis. - Be familiar with MySQL databases or apache spark - Understand how to generate comprehensible reports. - Possess an analytical mind to identify trends and patterns from the data collected. The purpose of collecting, manipulating, and analyzing the data is to have a single type of database for all the data-driven decisions I need to make. As such, knowledge in building and working with databases is an added advantage. To make a convincing proposal, show me how you've done something similar in the pa...
For our project, we require a reputable Grafana developer. Our cloud servers are housed on DigitalOcean and Hostinger, operating on an Ubuntu or similar ope...environment on these servers. Key tasks will include: - Establishing Grafana on our existing cloud server - Customizing the environment to suit our specific requirements - Preparing the environment for further development - Implementing necessary changes throughout this process In addition, expertise will be needed to integrate a MySQL database data source with Grafana. In summary, we are seeking someone with solid Grafana experience, Ubuntu competency, and knowledge of MySQL databases. Ability to optimally perform this project is highly important to us, and we look forward to connecting with prospective freel...
Sprache : Delphi Anforderungen: Über die Ebay-API sollen alle verkauften Artikel mit Kunden und Portodaten ausgelesen werden (einfach alle Informationen, die Ebay bereitstellt - also auch, ob die Artikel bereits bezahlt sind) und diese Daten in eine MySQL-Datenbank geschrieben werden. Dabei würde sich eine Kopftabelle mit den Kundendaten etc. und eine Detailtabelle mit den ersteigerten Artikeln anbieten. Gewünscht ist auch eine separate Tabelle mit den extrahierten Kundendaten, um Redundanzen zu verhindern. In der Kopftabelle kann dann auf die Kundendaten referenziert werden. Wichtig ist, dass die Lieferadresse über die API angefordert wird. Diese kann sich von der Kundenadresse unterscheiden. Die gewonnenen Daten sollen im Programm angezeigt werden - eine sin...
Fix issues related to MySQL on the Linux Server / Drupal
I require a competent freelancer to locate and collect 3000 product images on the internet and transfer them into a database for inventory management. The images should correspond to the given skus and upc codes. The project specifics include: - Images should be in JPEG format - Minimum acceptable image resolution is 72 dpi This project would ideally suit someone with the following skills and experiences: - Image sourcing and editing - Strong research abilities - Experience with data entry and database management - Familiarity with skus and upc codes - Attention to detail. Please ensure all images are obtained legally and are suitable to use for commercial purpose.
I'm looking for an expert to guide me in running an existing windows command script. My ultimate aim is to extract specific data from my databases. Here are a few details about what I need: Key Tasks: - Guide me through the process of executing an existing Windows command script with steps by steps written documentation - script is password protected - password is known - Assist in extracting valuable data from various databases Essential experience and skills: - Proven expertise in Windows command scripts - Proficiency in data extraction from databases - Excellent communication and teaching skills, as I need step-by-step guidance. Please bid only if you match the skill set and experience.
I'm searching for an experienced full-stack web developer with a proficient command in PHP (php mysql). The candidate will be tasked with the implementation of a frontend for an already designed api. view the reference code: Key Responsibilities: - Development of the web platform using PHP for add or delete load balancers - Development of the web platform using PHP for add or delete servers in the load balancers - Ensuring high performance of applications and providing support to do it - Integrating UI elements with server-side logic Ideal Experience and Skills: - Profound knowledge of PHP - Strong experience in web development - Understanding and implementation of security and data protection - Good problem solving skills - Validating user
...React websites and MySQL databases. The purpose of the project is to add features and update the design of our already operational travel-based website where users get information and can book travel. The website covers: - Destinations: Detailing various interesting locations, their information, and booking options. - Retreats: Indepth information on various spiritual and wellness retreats; offering booking service. As such, the freelancer would be responsible for: - Creating/troubleshooting some bugs - Implementing and verifying secure booking features. - Upgrading website design for user-friendliness and aesthetic appeal. - Updating database as necessary for new features. - Updating obsolete libraries Ideal skills for this project include: - Proficiency in React an...
I'm seeking a skilled developer to build both front and back ends for an existing online database design. This project will involve constructing the admin and user portals with specific functionalities. Admin Portal Needs to enable: - User management; to ensure I can control access and permissions within the platform - Data entry and editing; to ensure the database content is dynamic and updated as required User Portal Needs to facilitate: - User registration and login; to ensure only authorized users have access - Search and filter options; to allow users to quickly find specific information they need - View and edit user profile; letting users manage their own information on the platform The type of data to be stored primarily includes: - User information - Order ...
I'm seeking an expert to help create a Dockerfile that runs Perl and DBD::mysql so that I can run a legacy website. This should be a simple task if you have the knowledge. Specific requirements include: - A Dockerfile is the only output required, roughly corresponding to mine - It should build and run in wsl, i.e. docker run -p 8080:80 image_name - It must use Apache, Perl and the CPAN module DBD::MySQL - It should have been tested on a MySql database, the file is provided to run on localhost:8080/ - A screenshot of the above is required to prove that it is working (you just need a MySql Table with fields Id and Name) Candidates should ideally have: - Extensive experience in Docker and a basic knowledge of Perl - Understanding of Perl CPAN modul...
I am looking for a seasoned Python developer with experience in Telegram bots. The bot should automate responses and facilitate user registration/authentication. It will need to link with external APIs. The mai...functionalities: - Auto-reply messages - User registration and authentication - Integration with external APIs - Capability to handle multi broadcast systems The bot should be able to handle all databases in one system for efficient broadcasting. Specifically, it should work within a MySQL database. It needs to be able to send messages to specific groups and individual users. Ideal freelancer skills and experience: - Extensive Python development experience - Familiarity with Telegram bots & APIs - Understanding of MySQL databases and how to implement t...
...with inherent data processing and error handling mechanisms of Go script. Project Scope: • Script is available at this GitHub Library: • We would like a middleware in form of MySQL/PostGres DB to which we can push data (messages to be sent) from our existing web application. We would like the data to be consumed by the go-script (from table 1) and send messages to appropriate SMSC (Telco) using the script. • We would like the Delivery Reports (DLRs) from Telco's that are sent to the go-script mentioned above via SMPP to be logged into the database(table 2). • We would like to add one functionality (available in another script) for throttling/ rate-limiter per second to the telco. Telcos specifies the rate limit per second (transactions per s...
I am seeking a skilled Flutter Flow developer to develop a web app. Key Functionalities: - Appointment scheduling: Facilitate easy booking and management of patient appointments directly within the app. - Electronic medical records management: Patients' medical records should be safely stored and easily accessible within the app. - Telemedicine/video consultations: Incorporate a function for virtual consultations, allowing doctors and patients to connect remotely. Who Am I Looking For? A highly skilled professional with substantial experience in Flutter Flow is a must. Familiarity with the healthcare domain would be advantageous. Additionally, I'm seeking someone who is willing to communicate and develop ideas together.
I am in need of an expert who can proficiently filter and extract financial time series data from compressed files in AWS S3. Upon extraction, thi...can proficiently filter and extract financial time series data from compressed files in AWS S3. Upon extraction, this data should be neatly compiled into a streamlined, accessible database with clear, intuitive organization. Ideal skills and experience for the job: - Familiar with Amazon AWS, specifically S3 - Understanding of financial time series data - Proficiency in database design and management - Experience handling large data sets Job Responsibilities: - Filter and extract time series data from AWS S3 - Design a coherent, user-friendly database structure - Transfer extracted data into the new database fo...
I am shifting my operations and client management to and require help importing my client data into its database. You'll be gathering this from various sources including, but not limited to social media platforms, my current CRM tool, and email contacts. Key Data to Extract: - Client names - Contact details - Transaction history - Family names - Pet names - Birthdays - Anniversaries - Addresses Ideal Candidate: The ideal candidate will have excellent data management skills, experience with CRM platforms, preferably monday.com. They will require strong attention to detail to ensure the accuracy of the imported data. An understanding of personal data protection principles is crucial. Knowledge in real estate sector will be a definite plus. For items that are not known, the ...
I'm searching for an expert web developer who specializes in creating e-commerce websites integrated with MySQL databases. The website is already developed needs to change some content on pages. Key tasks include: - Designing and developing a seamless user registration and login system - Ensuring efficient performance and security features The ideal candidate should possess a strong background in web development, particularly in building e-commerce platforms. Furthermore, significant experience and proficiency in MySQL are paramount.
Hello, I have a simple php page and a complex database. My database size is very high and when I query a data I don't get a response for a very long time. I created a basic API and I have complex data in my database. I need a system that will delete repeated data in the database, destroy all unnecessary data and work with a proper, reliable api.
I need a website built in PHP, allows users to setup a list of pre-defined medication orders , based on a procedure) and then send to a SQL Server database / aim is to insert rows of data into the my SQL SERVER Please note that the site does not need user registration or login functionality. We also do not need to track customer info or delivery location. Ideal freelancers for this job should be proficient in PHP development/ mySQL and SQL Server. They should also have experience in designing simple yet functional websites, with a focus on order-processing functions. A keen attention to detail is necessary to ensure accurate data capture of product-related details.
I require skilled services from a freelancer who can integrate and visually display data from a CSV file on a Wordpress site. Here's what you need to know: - The data visualization will be in the form of bar charts, line graphs, and pie charts, providing a comprehensive view of the data. - The CSV file will be updated daily. The freelancer should ensure that these daily updates seamlessly sync with the graphical displays on the site. - Automated updates are required. All graphs should update themselves without manual intervention, providing real-time data representation on the Wordpress site. The ideal candidate for this project will have: - Profound experience in data visualization - Strong knowledge and experience with Wordpress, full stack development, web development,p...
I'm in urgent need of a developer well-versed in PHP, MYSQL, and FFMPEG for the creation of a GPU Transcoding Panel operating on Linux. Key project details and specifications include: - The system will be Linux-based due to its flexibility, stability, and open-source nature. - The project completion timeline is urgent. Ideal skills and experience include: - Proficiency in PHP, MYSQL, and FFMPEG - Experience in developing GPU Transcoding Panels - Extensive knowledge of Linux systems - Knowledge of video encoding and decoding tools is not obligatory, but would be advantageous. Please note that the output format requirements are currently undefined and will be determined with the successful freelancer as the project progresses.
I am in need of an accomplished Full Stack Developer to join my digital team. With your expertise, I am loo...team. With your expertise, I am looking to create a dynamic and user-friendly product. Skills and Experience: - A proven track record with front and back-end programming – HTML/CSS, JavaScript, and particularly React. - Depth of knowledge using React as a library will be crucial for this role. I require a developer who can hit the ground running. - Experience with MySQL is a must. You should be competent in using this database technology to manage and protect our data effectively. With your skills and expertise, I believe we can take the user experience to a higher level, improving client satisfaction and driving business performance. I look forward to re...
Hi Kolte Technologies, I noticed that you have experience with QuickBooks API integration. I am interested in a two-way QuickBooks Sync tool to MySQL DB, which can support multiple QuickBooks company files and has an auto-sync scheduling function. Additionally, I have a MySQL DB schema that needs to be followed; the sync output should match my schema so that I don't need to modify it. If you can develop this, please provide a quote. Thank you.
I'm seeking a skilled designer experienced in creating compelling brand identities, designing product packaging and curating materials for marketing. Your job will focus on creating designs for caps in sync with my provided themes and the latest trends. KEY TASKS: - Develop a distinctive brand identity - Design product packaging, keeping in mind the product - CAPS - Create design-centric marketing materials TARGET AUDIENCE: Please note: The target audience for these designs is adults between the age of 14-50 years. Therefore, your designs must resonate with this demographic. DESIRABLE EXPERIENCE: If you have previously worked with similar industries creating trending and theme-based designs, consider this a plus. In your proposal, kindly provide a portfolio that specifi...
My song parody of the Beatles' "YOU CAN'T DO THAT" to be revised with AI Lip Sync generation. The current video is here All the video passages are here: !Ap6SuR6y_kgdg9k6NwwuXzyJK05Elg?e=YTmXwZ The 2.5-minute audible is here: !Ap6SuR6y_kgdg5keigo0DCETfFOd1Q?e=9JftmH Supplant the "Paul McCartney" character with Klaus Schwab instead of the FBI man shown now.
I am looking for a seasoned Python developer with experience in Telegram bots. The bot should automate responses and facilitate user registration/authentication. It will need to link with external APIs. The mai...functionalities: - Auto-reply messages - User registration and authentication - Integration with external APIs - Capability to handle multi broadcast systems The bot should be able to handle all databases in one system for efficient broadcasting. Specifically, it should work within a MySQL database. It needs to be able to send messages to specific groups and individual users. Ideal freelancer skills and experience: - Extensive Python development experience - Familiarity with Telegram bots & APIs - Understanding of MySQL databases and how to implement t...
I'm urgently in need of a competent PHP developer to build a login form for an existing backend. This form requires a unique combination of name and mobile number for user identification. After filling in these detai...to complete the project promptly. I want login form with name and mobile no. and OTP verification through MSG91 API just for authenticating and save the user record at backend, after login button the page will redirected to defined link, and want the simple admin backend to see the record for all registered user Login form should be responsive and mobile friendly Preferred backend in php and MySQL This is 10-30mints of work for experience one And the budget is for is $2-10 Next task will give in next project this task is immediately MSG91 api is very simple ...
I am looking for a programmer to create a simple script to sync inventory between my Amazon shop and Prestashop website. This script is to update product stock via EAN codes.
As a project owner, I am seeking a skilled DevOps professional to upload and setup my Django Python project files on an EC2 server through AWS. Key Responsibilities: - Upload Django Python project files on EC2 se...owner, I am seeking a skilled DevOps professional to upload and setup my Django Python project files on an EC2 server through AWS. Key Responsibilities: - Upload Django Python project files on EC2 server - Set up and configure the server properly via full administrator access in AWS - Work with MySQL as the type of database used in the Django project Ideal Skills: - Extensive experience with Django Python project deployment - Expertise in AWS and particularly EC2 services - Proficiency with MySQL databases - Strong communication skills for progress upda...
...of a proficient video editor to bring my vision to life. General skills required include: - Video Editing: You should possess basic video editing abilities, since the complexity of editing required is minimal. Clean, seamless transitions and a cohesive timeline are key. - Audio Integration: The ability to flawlessly incorporate music and a voiceover is crucial. Ensuring that the audio components sync with the visual aspects of the video is vital. - Subtitling: You'll also need to create and add subtitles. An eye for font, size, and placement is preferred. The final cut of the video should last around 20 minutes. Experience in similar projects will be an asset. We have voiceover, music and required content such as photos, video clips ready and video is half edited, so edit...