Csv tab delimited files mysql jobs

I'm in need of a PHP developer who can help me update my current system. The goal is to unencode emails with 'Content-Type...charset=utf-8' and 'Content-Transfer-Encoding: base64' and then save the body, along with the subject, sender, recipient, and date into my existing MySQL database. Key Requirements: - Use PHP to unencode the email and save the content into MySQL - Omit attachments from this process - Ensure the subject, sender, recipient, date, and body are accurately stored in the database Ideal Skills: - Proficiency in PHP and MySQL - Experience with email parsing and decoding - Knowledge of email headers and MySQL schemas - Attention to detail to ensure all data is correctly stored NOTE: Files will be passed back and f...

Good day I have a problem, I don't have a certificate for 2 pieces of data and I guess that's why they are recognized as a virus and I don't want to have to buy an expensive certificate and then still have the problem That's why I'm looking for someone who can quickly create a certificate for 2 files (that are virus-free) in order to test whether it really is the problem

Looking for expert DBA having an experience with Amazon RDS MySQL 8 Community edition. Lot of queries are stuck in "executing" state without any kind of database table locking. Most of the queries stuck are all "SELECT" queries. The queries itself is fully optimized using joins and indexing for better performance and those are regular queries which are executing just fine without any issue since many months. If you have a VAST amount of AWS experience, reply with the text "I have a vast amount of AWS experience and I am available right now to help." Thanks! --- Comments below are from AI -- I am in urgent need of AWS server administrator to resolve critical issues with my EC2 and RDS services. The server is currently experiencing performance degrada...

I need to enhance 50 audio files, which are mostly 5 to 10 seconds long, with an audio filter replicating the atmosphere of an Air Traffic Control communication. Key Requirements: - 4 distinct effects are required depending on which file of the 50. - The first effect should mimic the ground communication with the tower. It should have a Radio AIR traffic control effect, but not as strong as the airborn communication with the tower. . - The second effect should replicate a more amplified Air Traffic Control communication (airborn). - Third effect on a couple of files is to sound very garbled (inaudible sort of). - Fourth effect is totally garbled and cannot hear properly. Expectations: - The final audio files should have a clear distinction between various ef...

Simple job for easy 10 rating. Combine like files into 1 csv. all files have same column heeders NEED JOB DONE ASAP. TODAY USA time.

I'm seeking a skilled backend developer to assist with API development and integration with a MySQL database. To help build a website that has this purpose- The purpose of the 'Thai Wills' web application is to provide a user-friendly platform where registered users can create legal wills online. The application aims to simplify the process of will creation through an automated system for basic wills, while facilitating access to legal services for more complex will situations. Scope • The development of the'Thai Wills' web application which includes user registration, questionnaire-based will generation, and an interface for admin and legal professionals to manage and facilitate the will creation process. The scope includes: ▪ Basic will creation th...

I need a proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would invo...Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experience in modifying existing Excel templates or creating new ones. - Data Integration: Knowledge of integrating and working with local files (CSV, JSON, XML) within Ex...

I need a proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would invo...Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experience in modifying existing Excel templates or creating new ones. - Data Integration: Knowledge of integrating and working with local files (CSV, JSON, XML) within Ex...

...analysis. The primary purpose of the program is to assist in data analysis. Thus, it should help in organizing and interpreting large sets of data. The program will need to handle data from two main sources: - Text files (CSV, TXT) - Manual input The ideal freelancer for this job should have a strong background in Excel programming and data analysis, with specific experience in handling various data types and creating efficient, user-friendly Excel programs. Key Skills: - Proficient in Excel programming - Skilled in data analysis - Experience working with text files and manual input - Ability to create user-friendly applications - Understanding of data organization and interpretation. Your role will be pivotal in helping me streamline my data analysis p...

I'm currently experiencing slow performance from my WordPress database that appears to be most apparent when using Mysql/MariamDB which is affecting my admin and dashboard areas. Ideally, I'm seeking assistance from a professional with substantial experience in WordPress and database optimization. The main skills and experience required include: - Knowledge and skills in MySQL/MariaDB - Expertise in WordPress database management - Experience working with websites having more than 20 plugins. Your task will include performing necessary optimizations to significantly enhance the performance of the website, specifically the admin and dashboard areas. Please, include examples of similar projects you've worked on when bidding.

...page 11 there are items already - (1st project) page 18 and (2nd project) page 16 are the same. Open version of (1st project) page 16 and (2nd project) page 11 when you click on "Choisir une nouvelle qualification" - (1st project) page 3 and (2nd project) page 2 are the same - (1st project) page 9 and (2nd project) page 8 are the same, when you click on "Déclarer un déménagement", there must be a tab - (1st project) page 4 is when there are no items select and (2nd project) page 3 there are already items - (1st project) page 10 and (2nd project) page 9 are the same. Open version of (1st project) page 4 and (2nd project) page 3 when you click on "Saisir un nouvel exercice comptable" - (1st project) page 5 is when there are no item...

I need to import 70,000 products into my new Amazon store. The project requires someone with a strong understanding of Amazon’s product template, and the ability to work with large datasets in CSV format. There are three main components to this project: - Importing a large number of products: You will need to be able to handle a large volume of data and ensure that it is correctly entered into my Amazon store. - Managing product variations: Each product will need to be listed as a separate entity rather than a variation, so you will need to have a good understanding of Amazon's product listing system. - Updating existing products: You will also need to be able to manage and update existing products in my store. I am looking for a professional who has experience with ...

...for me. My project primarily involves generating variable frequency range FSK sine wave output. Key Requirements: - Develop code specifically for Arduino R4 board + SD card module - Generate sine waves of different frequencies - Different frequencies - 10,000 different frequencies (integers) - eg: txt file (100,200,300,400,500.................n integers) Frequencies list are stored in a SD card CSV or txt format Arduino new R4 boards has built-in DAC for sine wave generation with ready made library as follows: Code for wave generation --->>> analogWave wave(DAC); int freq = 10; // in hertz, change accordingly void setup() { } void loop()...

Good day, We please need a Freelancer to create a WebM video from an existing and purchased Premiere Pro template. This is the template: The requirements to the output video are: - Put below mentioned sequences 01-03 into a row - Video will be displayed in this frame (check ) - Video must be in WebM format - Video background must be transparent (!!) - Video must be web-optimized - Video must run in a loop - Video must contain transparent gradient on left/right side - Video sequence 03 must contain transition animation Please check the individual sequences for more details: Sequence 01 - Smartphone - Take animation from 00:09 - 00:15 - Take screenshot - Add animation transparency at left and right corner - Do not change screens while animation - Add 0.5 seconds delay be...

I need a proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would invo...Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experience in modifying existing Excel templates or creating new ones. - Data Integration: Knowledge of integrating and working with local files (CSV, JSON, XML) within Ex...

I'm looking for a skilled PHP developer who can create a secure login and register system using fingerprint data stored in a MySQL database. The system must ensure seamless user experience, while maintaining strong security measures to protect sensitive data. Key Features: - Implementation of a biometric device for fingerprint data collection - Two-factor authentication to enhance the system's security - Support for multiple user roles with distinct permissions Ideal Skills and Experience: - Proficient in PHP programming language - Experience in MySQL database management - Strong understanding of data security principles and practices - Prior experience in implementing biometric systems would be advantageous - Excellent problem-solving and communication skills If...

... and deliver it to me in a .csv file. **Project description** - go to - select - see a list of all baseball card collections (starting with "1888 N28 Allen & Ginter" ending with "2021 Topps") - get all "collections" - for each "collection" - get all "players" - e.g. (starting from "#1 NL Batting Leads" to "#576 Johnny Temple") - for each "player" - get all "auctions" incl. all data - e.g. (starting with "LOT# 186381386125" to "LOT# 142") - for each auction - save data in .csv in following format - collection_name

I'm leading the development of a cutting-edge video streaming app using Flutter. Our aim is to provide users with a seamless entertainment experience, offering a wide range of conten...protect user data. Requirements: To excel in this role, you should: 1. Have proven backend development experience. 2. Be proficient in backend programming languages like Python, Node.js, or Java. 3. Have familiarity with web frameworks such as Django, Flask, or Spring Boot. 4. Understand RESTful API design principles. 5. Have experience with database management systems like PostgreSQL or MySQL. 6. Be comfortable working with cloud platforms like AWS or Google Cloud. 7. Be familiar with DevOps practices like CI/CD and containerization. 8. Possess strong collaboration and commun...

I'm looking to develop a simple AI prediction model with a regression algorithm, and a React frontend with Dashboard. This project aims to showcase historical prediction accuracy using real-time data from APIs, dataset i will provide in CSV file formate about crops. Key Requirements: - Creation of a regression model: The AI prediction model needs to be built using regression techniques. - Data source: The model should fetch real-time data from APIs, pre defined data. - React Frontend: The primary goal of the React Dashboard is to showcase historical prediction accuracy. - SaaS Model: Create subscription for 3 tires. Ideal Skills: - Strong experience in developing AI prediction models, particularly regression models. - Proficiency in working with React for frontend develo...

... Almost all are delivered through spreadsheets created by our clients. The fields vary. Regardless, I hope those sheets can be synced to create jobs and reflect changes within our system. Other jobs would be entered manually, while others would be integrated through our online order form. Objective 3 I currently use Google MyMaps for mapping jobs. I import the vast majority using .csv files and erase them manually as they are completed. I'm looking for a way to sync a map according to the information on a spreadsheet/database. These are the main objectives. There are other ideas I'd like to entertain as well. I'm looking for an expert to help me determine: - if these objectives are feasible. - Provide options, including what platform(s),...

...and mobile-friendly, hence maximizing our site accessibility across all platforms. Key Features: - WordPress Build: Leveraging WordPress and PHP Laravel for seamless creation and management of our website. - MYSQL Database: Efficient use and integration of MYSQL for optimal website operation and data management. - Responsiveness & Mobile-friendly: Given the nature of our audience, the site must adapt effectively across various devices- from desktops to mobile phones. Required Skills & Experience: - Extensive proficiency in WordPress and PHP Laravel - Deep understanding of MYSQL - Prior experience in creating responsive and mobile-friendly sites - Experience building sites for professional adults, with a portfolio to showcase your experience. Together...

I'm seeking a talented full stack developer for initial software development for a pathology lab. The software must be responsive, user-friendly, and robust, catering to patients, staff, and referring doctors. Here's what we need: 1. **Choice of Platform**: As the client, I am open to using Angular, React or PHP for the development along with SQL Server/MySQL for the database. Feel free to recommend a platform when you apply. 2. **Essential Modules**: - Building Patient Database (From existing Lab Software - Which will remain as is). This database will be used for Whatsapp , email , SMS Marketing (This also is part of scope) and also For Patient Web App interface. Whatsapp API interfacing will be required for sending and interacting with Patients. - Patient Web App inter...

I'm looking for a skilled programmer who can quickly correct the issues in my web scraping project in python. The task involves scraping data from Website A. Specifically, I need to retrieve player, tournament, records and runs and bowlers information. Ideal Skills and Experience: - Proficient in web scraping techniques - Experience working with CSV format - Familiarity with data extraction from dynamic sources - Ability to troubleshoot and fix existing code - Strong attention to detail and accuracy Please note that I need this task completed urgently within few hours as base code is already written, need to fix details, so quick turnaround time is essential. Thank you!

I am in need of an experienced PHP developer to improve my existing project. I already have a project that involves a PHP application with 3 database-linked forms but require further enhancements for it. The ideal candidate should have a strong background in PHP, particularly in creating data-driven applications that interact with MySQL databases as this is what the project entails. Unknown functionalities are yet to be determined for the 3 forms as I have not specified whether their purpose is for data retrieval, modification or submission. As such, I would appreciate a candidate who has vast knowledge in these areas to guide the development and application of these functionalities within the project. Your expertise in recommending and implementing the most efficient and effective ...

I'm seeking a skilled backend developer to assist with API development and integration with a MySQL database. To help build a website that has this purpose- The purpose of the 'Thai Wills' web application is to provide a user-friendly platform where registered users can create legal wills online. The application aims to simplify the process of will creation through an automated system for basic wills, while facilitating access to legal services for more complex will situations. Scope • The development of the'Thai Wills' web application which includes user registration, questionnaire-based will generation, and an interface for admin and legal professionals to manage and facilitate the will creation process. The scope includes: ▪ Basic will creation th...

...motorcyclist, in the past I was using a dedicated GPS from Garmin called the Zumo XT. I could connect my phone to that GPS via Bluetooth and if I had an app called Garmin Drive installed on my phone it was able to share some information between my phone and the GPS like for example notifications or Music information: Notification example: Music information: I’ve now switched to using a Samsung galaxy tab active 3 as a navigation device instead of the dedicated GPS and I’m now missing the notification / music information shared between my phone and the device in front of me while driving. I’m looking to recreate that behavior. With a dedicated android app About the app now: The app will have two side: - A receiver side (the tablet that I will use as a GPS) th...

...question, please improvise, DON'T ask. General: - There will be no database nor payment functionalities. - There will be just one language (German). - The site must be adaptative to any browsing device (desktop, tablet, mobile). - All texts and pictures will be read by the website from a folder (see zip file attached). This is mandatory. I will be able to change these at conveniance by updating new files (show me how). The icon and favicon will also be updateable in the same way. - Delivery period of the website after having been awarded will be 3 days. Tabs (in this order): - About us: background pictures of your selection and a text read from a file (no copy-paste). - Team: a matrix of 2 cols and 10 rows: * col1 = pictures read from a file (no copy-paste). * col2 = a tex...

I’m seeking an adept Python Developer to construct an AWS-based program capable of distributing large-scale emails from a diverse .csv list. Key features: - Email customization placeholders and dynamic subject/body integration for high-level personalization, - Capabilities to send via diverse SMTP email accounts, - Incorporation of an open rate and read status tracking feature. Ideal candidate possess extensive experience with Python, AWS and email tracking protocols. Familiarity with advanced email customization techniques is preferred.

Project Duration: 1 Hour Project Type: Data Processing Project Level: Standard Project Overview: We have a CSV file with 2000 rows. We want all content after the last </p> in each cell removed 5* FEEDBACK WILL BE LEFT FOR YOU

As the owner of a WordPress and MySQL website with less than 10 pages, I am seeking an expert freelancer with web optimization skills and profound knowledge in WordPress and MySQL to greatly boost my website's performance. The main areas that need to be improved include: - Loading time - Server response time - Database optimization I require someone who is familiar and experienced with both E-commerce and SEO plugins as they are significant for the functionality of my site. With the right skills and expertise, I'm confident the successful applicant will be able to make my site faster and more reliable.

I require a Power Bi expert to assist with transferring and analyzing our sales data, currently stored in a spreadsheet format (CSV, Excel). The main element I need to focus on within the analysis is the sales trends over time. The ideal candidate would have: - Strong skills in data transfer and analysis in Power BI - Experience dealing with sales data - A keen eye to identify and present trends over time effectively. To confirm, your task will involve: - Transferring sales data from a CSV/Excel file to Power BI - Conducting detailed analysis focusing on sales trends over time - Presenting these findings in a useful and understandable format.

6 products connected to API to pull info from data feed Wordpress / Elementor Will use PHP / cron File is a URL linked to a CSV containing 1,000s of items Script must search product ID, then update price, descriptions etc id required Refresh every 12hr Delivery time must be less 2 hours Project budget must not exceed £24

6 products connected to API to pull info from data feed Wordpress / Elementor Will use PHP / cron File is a URL linked to a CSV containing 1,000s of items Script must search product ID, then update price, descriptions etc id required Refresh every 12hr Delivery time must be less 2 hours Project budget must be £24

...proficient in AWS, Laravel, NodeJs, PHP, and MYSQL for an upcoming project involving the upgrade and migration of my current applications. The selected candidate will work primarily with Angular, Laravel, NodeJs, PHP, and MYSQL apps. Primary project goals include: - Upgrading the AWS server to the latest version - Ensuring seamless migration of current applications with no interruption to service The applications involved in this project are responsible for managing a wealth of data, including both user profile information and authentication, as well as a range of digital content (videos, pictures, music, etc.). Ideal Skills & Experience: - Proven experience with AWS service upgrades and migrations - Proficiency in Laravel, NodeJs, PHP, and MYSQL - Exper...

I’m looking for someone who is EXPERT in generating docx files by using python. I’ve 56 .docx (28 in English and 28 in Arabic) files that my system will fill-out from our database. I can use word replacing, but I need to have full control over the file where I can add tables, images, paragraphs, HMTL strings (rich text field), …etc. The job is to generate EXACT docx file in python, so I can use it to insert the data directly. Key Requirements: - Expertise in Python: You should have a solid foundation in Python, with a focus on working with docx files. - Quality and Efficiency: It's crucial that the modifications are done accurately and efficiently. This project is ideal for someone who has prior experience working with docx files ...

I am looking for an experienced Python developer to update an existing script. This script is using a api and generates on a daily basis a csv

...app is to establish a seamless connection with a Bluetooth source (specifically, an esp32 sending sensor and pin status data) and store the received data in a local CSV file on the phone. Key Feature Requirements: - The app should function smoothly on both Android and iPhone platforms. (priority is android for now) - Ability to connect over Bluetooth with an esp32 wroom module. The Bluetooth protocol may be either BLE or classic, as I am not entirely certain which one this module uses. - Once connected, the app should be capable of receiving sensor and pin status data. - The app should store this received data in a local CSV file on the mobile device for later access. - A simple and functional user interface would fit best for this application. I do not need aesthetic e...

I have a PDF file with text & tabular data (unstructured) inside it. We need to extract it and save it in csv

I'm seeking a proficient Magento expert to assist with product exports from my eCommerce store. Main Tasks: - Export our extensive range of products into a CSV (Comma Separated Values) file. Skillset: - Solid understanding of Magento - Expertise in module development - Knowledge of performance optimization - Mastery of both theme customization and product exporting Please note the selected freelancer will not be required to deal with specific structures or field inclusions. Only applications demonstrating relevant experience will be considered.

I'm looking for a PowerApps expert to build a secure and responsive CRUD PowerApp that connects with a SharePoint List. The App needs to handle: - Regular CRUD operations (create, read, update, delete) in a multi-user environment. The app will be used by multiple u...delete) in a multi-user environment. The app will be used by multiple users simultaneously, so performance and efficiency is a must. - Additional functionalities: Handling bulk updates, offering the ability to search and filter records, and providing an option for exporting the information to a CSV file. Experience with SharePoint Lists and PowerApps is essential, along with a keen understanding of multi-user efficiency and data management. Expertise in exporting data to different formats, like CSV, will ...

I'm in search of a Senior Full Stack developer, passionate about their craft, to join our ranks. Your wealth of knowledge and experience will be the key to our growth and the solution to surpassing our current limitations. Key Skills: - Proficiency in JavaScript, C#, React, Vue, and .NET Core - Familiarity with Visual Studio - Experience in MySQL database management Nice to have ● Familiarity with DevOps and CI/CD pipeline. ● Familiarity with containerization tools like Docker and Kubernetes. ● Frontend development experience working with React.js. What you have ● 8+ years of experience as a full stack engineer on a team using standard best practices. ● 5+ years of experience as a Full-stack engineer with .NET, ASP.Net Core, Azure, Angular, and React.js. ● Proficiency in a s...

I'm facing a challenging issue where my ASP.net application can't connect to a MySQL database. I need a fast solving of this problem and want to start in the next hour !! Here are the issues I'm dealing with: - The database I'm using is MySQL - using AWS mySQL RDS - Asp.net server is on Amazon EC2 - There's no connection to the database at all message: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond Check image below with error message. It is an older database, maybe we need update some libary for connecting or whatever. I prefer to connect with anydesk or other remote desktop software. Before write me you ...

I'm looking for an experienced backend developer to handle database management and API integration for my project. Key Responsibilities: - Implement and manage a MySQL database efficiently. - Develop and integrate APIs to ensure seamless communication between front-end and database. Ideal Skills: - Proficiency in MySQL is a must. - Strong experience in API integration. Experience with other databases and backend technologies like Python, Java, and Node.js would be a plus. The chosen freelancer will need to understand the project's requirements thoroughly and communicate effectively with the front-end team to ensure a well-functioning, reliable backend system.

I need a skilled PHP developer to implement a Credit/Cancelled Order feature on our website. Key Details: - The purpose of this feature is to enable manual order cancellations ...Details: - The purpose of this feature is to enable manual order cancellations and refunds by admins - The feature should update the customer's order status, manage their store credit if applicable, and send notifications - This should be integrated with our existing hygglig Checkout system, so knowledge or experience with this platform is a big plus Ideal Experience: - Proven experience in PHP/Mysql development - Familiarity with e-commerce systems, and specifically hygglig Checkout - Previous work on order management, refund systems, and store credits Please include your relevant experience in yo...

Im looking for someone to help update the current script and add logging to a csv file,

I'm looking to integrate my WhatsApp order system with my existing Custom HTML/PHP website and MySQL database. Below are the specifics: - I need a system that will automatically save the orders received on WhatsApp into my MySQL database. This should be done using the Interakt webhook. Only exp. bidder who have work before website Becuase i have account in interakt and they provide it webhook service witch have post a data to webshook script. Ideal Skills and Experience: - Proficiency in integrating web services such as WhatsApp with databases - Strong knowledge of Custom HTML and PHP, as well as MySQL - Experience with webhooks, especially Interakt, is a huge plus - Prior experience with eCommerce and order management systems would be beneficial Please pro...

...this platform will be strictly registered members and administrators/staff. Experience in working with Angular 8+, JAVA, BootStrap, SpringSuite, Spring Security, SSO, and MySql will be essential for this project's successful execution. Skills and Experience Required: - Experience in building web applications from scratch - Expertise in Angular 8+, JAVA, Bootstrap scripting - Proven record in successfully integrating user account management - Demonstrable experience in data visualization - Extensive knowledge in creating e-commerce platforms - Familiarity with SpringSuite, Spring Security, and SSO - Proficiency in MySql - Past experience in creating platforms for registered members and administrative use It's essential that you understand the integration and s...

Project Deadline: 1 Day Project Budget: $45 Project Level: Standard Project Type: PHP Project Overview We are looking a simple but well written PHP script that uses the Google Places API to allow a user to search for a term, and then display the list of results on screen & allow a user to download the results in a CSV File Script will be using the following Google Places API Additional Technical Information Results must be limited to top 50 records. Script must be written for PHP 8.2 & above 5* FEEDBACK WILL BE LEFT FOR YOU

I'm in need of a full stack developer with expertise in HTML, CSS, JavaScript, MySQL, MongoDB, PostgreSQL, and WordPress to build an e-commerce site. The main functionality of the site will be e-commerce integration. Purchase Ideal Skills and Experience for the Role: - Proficiency in HTML, CSS, JavaScript - Backend development using languages such as Python, Node.js, PHP - Experience in Database creation using MySQL, MongoDB, PostgreSQL - Capabilities to work on WordPress Included in your Application: - Please provide examples of past work, particularly those involving e-commerce integration. Looking forward to receiving your proposals.

...find hidden or less obvious sources of information. Explore medical association websites, healthcare directories, and professional networks. Utilize search engines, social media, and other platforms to extract relevant data. Quality Assurance: Ensure the accuracy and completeness of the collected data. Verify the information to avoid duplicates or outdated entries. Deliverables: A well-organized CSV file containing the radiologist details. Clear documentation on the sources used for each entry. Additional Notes: The freelancer should have excellent communication skills and attention to detail. Confidentiality and privacy of personal information must be maintained. The project deadline and budget can be discussed based on the scope and complexity. Why Choose Me? I am committ...