Php import xls postgresql jobs

I am looking for an experienced course creator to develop a comprehensive video tutorial focused on Microsoft Power Query. Key Features: - User-friendly interface - Capabilities to import data from various sources - Customizable course structure The ideal candidate should have the ability to break down complex concepts and make them easily understandable. The course content should cater to beginners and intermediate level learners. Course Duration: Each video course module should be crafted with the target of a total duration amounting to 3-4 hours. This could be composed of several shorter lessons or modules, for easy consumption and better learning experience. Required Skills: - Strong knowledge of Microsoft Power Query - Proven experience in creating video courses - Excelle...

I need someone to display my YouTube comments based on newest first. I use PHBB forum so I would like it shown on top. It can accept html and php I believe. It should only show 5 latest. So if you can create this on your site I can upload it to mine and so we can see this on a blank page. Then I need code to insert into my Phbb forum

...functionalities include: - Form submission - to post HTML data to the database. - Data visualization - to display posted data on the webpage. Ideally, the freelancer should have: - Proficiency in WordPress plugin development, - Expertise in HTML, and - Familiarity with handling data through form submission and visualization techniques. The data integration will not involve manual input, spreadsheet import, or API connection as the data is already displayed on the page. We just need it saved. This is to complete a mostly complete wordpress plugin which already captures the user ID, Data source ID and captures the html data which needs to be stored. We have a problem getting the plugin to trigger an Ajax response which we need help debugging. Please submit your bid if your ...

I'm seeking a developer who can create a script or plugin that pulls content from Facebook, Twitter, and Instagram on a daily basis and automatically imports them into my WordPress site as separate posts. Key Requirements: - Scheduled Import: The content should be imported into WordPress daily as individual posts. - Post Categorization: Each imported post should be assigned a category based on its source (e.g. Facebook, Twitter, Instagram). - Immediate Publishing: The imported posts should be published immediately upon import. - Instructions on how to setup App/ID/secret for each social channel Ideal Skills: - Strong knowledge of WordPress and its internal mechanisms. - Proficiency in working with the APIs of Facebook, Twitter, and Instagram. - Experience in developin...

I’m currently seeking an experienced developer for the creation of a CRM Application based on WordPress and PHP. This comprehensive CRM system will focus mainly on the following aspects: - Contact Management: Easy setup for adding new contacts, updating existing contacts, and generally ensuring robust record-keeping for clients. - Sales Pipeline Tracking: This feature will aid in tracking the progress of deals, identifying slow points, and pushing for efficient sales funnel management. - Customer Support Ticketing: A well-organized dashboard for support tickets, helping in prompt and effective resolution of customer issues. While the main features are outlined, I’m open to discussing additional functionalities that might enhance the system’s effectiveness. Integ...

I'm in need of a skilled PHP Yii 2 developer to create a robust platform with user authentication, API integration, and a payment gateway. Key project requirements: - Use1. We've implemented razor pay in frontend but in backend it's phone pe so order I'd is not coming we've to fix that 2. Currently login sign up is email id and password we've to change that flow to phone number OTP login and it's already there for forgot password flow we've to modify that and use it for login 3. Once payment is successful then there's an appointment booking api that needs to make an appointment there's small fixes in it 4. There's a doctor's profile api where it should give doctors fee sometime it's not coming These are the fix...

I'm in search of a PHP Developer with a proven track record of developing comprehensive ERP Solutions for the construction industry. We will looking for a ready application something more or less similar to our requirement. A existing pre developed application. Wherein customization can be done. Key Modules Required: - Quotation - Purchase - Project Management - Materials Management - Stock/Inventory - Billing - Accounts - Reports - Project Management - Cost Estimation - Procurement Specific Features for Project Management: - Task Management: The system should allow for easy task assignment and monitoring. - Resource Allocation: It should have a robust system for allocating and tracking resources. Specific Requirements for Cost Estimation: - Integrated Cost Database: The sy...

I need an experienced PHP developer to fix some issues in our existing code. The main problems are with the Search functionality and the Database Connection. Key responsibilities: - Fixing the broken search functionality - Resolving the database connection issues Your application should demonstrate: - Proven experience in PHP - Understanding of database connections and search functionalities - Good problem-solving skills Please include relevant experience in PHP in your proposal.

I'm in need of a skilled PHP developer to create a website much like www.websiteoutlook.com. The key features of the site will include: - The ability to provide website statistics - Domain information lookup - Primarily an information-driven purpose I'm looking for a professional who can deliver a high-quality site that is user-friendly and functional. The main skills required for this project are: - Proficiency in PHP - Experience in website development - Good understanding of website statistics and domain lookup services Experience with creating similar sites would be a plus.

...what data is available. Key requirements: - Developing an API Salesboard tool with a user-friendly interface and robust functionalities. - Ensuring real-time updates on sales data during business hours in 20 minute intervals - Implementing a feature that allows for customizable reports. - Required integration with our CRM system. - Ability to manually enter some non-sales data or if possible, import from PowerBI for automation - Ability to have the product to be rolled out to other businesses using the same platform if required (not required right away) The ideal candidate should have: - Proven experience in developing API-based tools, specifically for sales and CRM purposes. - Proficiency in real-time data handling and processing. - Strong UI/UX design skills to ensure ease o...

I am in need of a qualified Laravel PHP programmer to develop an investment system along with a lottery on my web platform. - Key features: The system will include ticket purchasing and selection, as well as random number generation. - Ticket purchasing process: I imagine a system that offers a combination of manual and automatic ticket selection. - Additional Implementations: I also require the integration of real-time notifications, layout adjustments and club implementation for subscribers. Ideal candidates must have: - Knowledge of PHP and Laravel programming - Previous experience developing lottery systems or similar platforms - Proficiency in integrating real-time notifications and customizing user profile - Experience creating engaging layouts and implementing subscr...

I have a real estate development company, and I'm looking for a dedicated Excel expert to help me streamline my expense tracking process. Key Requirements: - I already have a template set up and in one of the tabs I have a CSV statement import. Your primary task will be to create a formula that can automatically pull data from a statement import into the relevant property tab. - The data should be ordered by date to ensure clarity and easy reference. - I have created a macro to change the debit figures to negative amounts in the spreadsheet. - I am open to changes/ideas on if it requires a different setup. Ideal Skills and Experience: - Advanced Excel skills are a must. You need to be comfortable working with complex formulas to manipulate data. - Experience with r...

I'm seeking a reliable freelancer to import vendor pricing data into Sage. The data is currently stored in a CSV formatted Excel spreadsheet, with data cleaning required prior to import. The project will entail: - Cleaning the vendor pricing data as required - Successfully importing clean data into Sage Ideal Skills: - Proficient in Excel and its functionalities, especially CSV format - Experience in data cleaning - Demonstrated proficiency in Sage, particularly in data import functions - Attention to detail is crucial for this task This task requires a freelancer with the right blend of skills in Microsoft Excel and Sage software to ensure smooth, error-free integration of vendor pricing data.

...need of a traditional style logo design for my import/export company. The design should predominantly feature red and black as the primary colors. I'm hoping the design can incorporate elements of a globe, a ship, and an arrow. Company name: Sibaf Pty Ltd (Usually just referred to as Sibaf) Key requirements: - Vintage style - Red and black color scheme Possible Suggestions: - Coat of Arms style - Inclusion of a icons of transport like ships, globe, aeroplanes, mail etc. - Maybe include a Christian element as the directors are Christians Ideal Skills: - Graphic design with a strong portfolio of logo design - Proficiency in vintage design aesthetics - Creativity in incorporating multiple elements into a cohesive design Experience with import/export companies is ...

I've got a small Python scr...it to be translated into C# for better integration with the rest of my software. I need a skilled programmer with experience in both Python and C#. Unfortunately, I have not been able to make the script run successfully on Windows, but it works on Linux (WSL). For: Python script (I will provide full script): import grpc from chirpstack_api import api server = "" api_token = "eyJ0eXAiOiJKV1QiLCJ......................87k2i66CulW7Y" channel = grpc.insecure_channel(server) client = (channel) auth_token = [("authorization", "Bearer %s" % api_token)] req = (dev_eui="00000000aabbccdd") resp = (req, metadata=auth_token) print(resp)

I'm seeking a skilled professional to develop a Solidworks macro for specific tasks. Mainly, it's intended to import data from Excel to Solidworks, and automate several repetitive processes. Data to be incorporated from Excel will be primarily: - Dimensions and measurements - Material properties - Configuration properties part number convention The successful candidate should have prior experience working with Solidworks and Excel VBA, understanding how to adeptly make these two platforms talk to each other in an efficient and error-free manner. This project is required within a month. If you're able to work within this timeframe, and have the necessary skills, I would love to hear from you. I have an Excel sheet to automate PN and description creation already mad...

I'm in need of an experienced PHP+Android developer to assist in integrating a Recharge API. Key Responsibilities: - Implementing necessary API endpoints - Ensuring proper error handling and input validation - Creating a seamless integration between the app and the API Experience: - Proficiency in PHP, Android, and API integration - Strong understanding of error handling and validation best practices - Prior experience in implementing payment gateways or similar API integrations would be an added advantage Please bid if you have the necessary skills and experience to deliver a robust and user-friendly recharge system.

I am seeking a developer to create an online database/sales tracking/CRM system from an existing Access database Key Features: - online access. - mirror the look and ease of use of existing access database. - import existing data in new database

I'm looking for a freelancer to set up Atomic Email Sender software on my laptop for ongoing product/service promotion email marketing campaign. Key Requirements: - Set up Atomic Email Sender on my laptop ensuring it's fully operational - Help me import my existing, curated email list for the campaign - Ensure the email set up includes basic customizations like name personalization Ideal Skills and Experience: - Proven experience with email marketing software setup, particularly Atomic Email Sender - Proficiency in managing email lists and contacts - Understanding of basic email personalization techniques and segmentation Please include in your bid any relevant experience you have with similar projects.

...search of a PHP Developer with a proven track record of developing comprehensive ERP Solutions for the construction industry. Key Modules Required: - Project Management - Cost Estimation - Procurement Specific Features for Project Management: - Task Management: The system should allow for easy task assignment and monitoring. - Resource Allocation: It should have a robust system for allocating and tracking resources. Specific Requirements for Cost Estimation: - Integrated Cost Database: The system should have a vast and well-organized cost database. - Calculation Formulas: It should accommodate complex estimation formulas. - Reporting and Analytics: The ability to generate detailed reports and analytics is crucial. Ideal Candidate: - Should have a strong background in PHP...

My PHP email sending platform is not functioning as expected. I've reviewed the code but I can't determine the root cause. If you're confident in your PHP skills and have experience with email sending, your help would be appreciated. Key areas for investigation and resolution include: - Reviewing the existing PHP email sending code for potential issues - Identifying any SMTP server configuration issues - Resolving any errors to ensure the email sending functionality works as intended Ideal Skills & Experience: - Proficient in PHP, with a strong understanding of email sending methods - Experience in debugging PHP applications and resolving SMTP server configuration issues

...a UX-Design. One for the desktop version and one for the mobile version. Your job is to setup these template sites and adjust the menus and everything regarding to the design. We will fill it up later with the right content. + Start page + main categorie side + under categorie side + article page - our design team will assits you by questions. - you have to import the articles from our actually side to the new development side - modify the checkout based on the customer requirements - If this work is running smoothly and good, we can work on a hourly base as well for several add ons by this new page. Could be a long term relation ship. Key requirements and responsibilities include: - Implementing the design

Overview: We're seeking a developer to create two distinct applications on Google Cloud's Vertex AI platform: * E-commerce Product Optimization: * Utilize Feedgen with Vertex AI to generate high-performing product titles and descriptions optimized for Google Merchant Center feeds. * Integrate with Google Sheets for seamless data import and export. * Website Meta Tag Optimization: * Develop a custom script on Vertex AI to: * Scrape content from web pages (titles, headings, body text). If scraping is not feasible, allow for manual input of content. * Utilize Gemini to generate SEO-optimized meta titles and descriptions based on the scraped/input content. * Ensure the script can handle both automated scraping and manual content input scenarios. Re...

I am in need of a one-time service to clean out my email database of invalid email addresses that generates too much soft bounce and hard bounce (and spam trap emails). Key Points: - **Objective**: The main goal of this project is to remove outdated or incorrect email addresses from the email database. - **Frequency**: This is a one-time project, not requiring ongoing maintenance. - ...ongoing maintenance. - **Current Platform**: I use Brevo as my email platform Ideal Freelancer Skills: - Experience with email marketing and database management - Familiarity with Brevo or similar email platforms - Proficient in identifying and removing invalid email addresses - Proven track record of improving email deliverability and marketing campaign results. I supply email addresses in CSV or XLS...

Hello! I need to build a module or functionality to the ServiceGo - Multi Vendor On-Demand Service & Handyman Booking Marketplace system for vendors. The module (functionality) should be the following, subscription model for vendors. In this subscription model, there should be a limit on how many listings (job services) a given vendor can publish and how many customers it can respond to. P.S. The above mentioned functionality is important to us, but even if you can't offer us such a solution we are also looking for the functionality of only registering as a vendor to pay a fee again, which should be per subscription. Link to the system:

...experienced PHP developer to help build a website for my NGO. The key features of this website are a Donation portal and a Volunteer registration system. Key Features: - **Donation Portal**: The portal should support one-time and recurring donations. A crowdfunding option is not part of the initial plan, but it should be implemented in a way that it can be easily added in the future. - **Volunteer Registration**: We need a user-friendly volunteer registration system. The system should collect basic personal information from volunteers, including their name and email address. Additionally, we would like to know their skills and interests as well. This data will help us in organizing our volunteering programs more efficiently. Ideal skills and experience: - Proven experience in d...

...experienced PHP Developer to create a user account management system for my ad publishing website. Key Functionalities: - User Account Management: This system should allow for User Registration and Login, Profile Management, and Account Settings. - Ad Posting Features: Implement the ability for users to Post Ads, Boost their Ads, and Manage Ad Details. - Optional Payment Integration: The system should support payment functionalities via API, enhancing the user experience. This feature is optional but would be beneficial for our service. Your Responsibilities: - Develop a user-friendly and secure system that ensures a seamless user experience. - Integrate the required features and ensure they function efficiently. - Provide clean and well-documented code. Ideal Skills: - Profi...

...professional PHP developer to upgrade my website from PHP 7.4 to PHP 8.2. The main goal of this upgrade is to ensure compatibility with the latest version of PHP. The ideal freelancer for this project should have: - Extensive experience with PHP development - Proven track record of successful PHP upgrades - Knowledge of the differences and potential issues between PHP 7.4 and PHP 8.2 - Ability to troubleshoot and resolve any compatibility issues that may arise - Strong communication skills to keep me informed throughout the process If you have experience with third-party services or APIs that may need to be tested for compatibility with PHP 8.2, please indicate this in your proposal. Additionally, if you have experience wi...

I'm in need of a PHP tool that will allow me to process WooCommerce orders efficiently. This tool should accomplish several key tasks to streamline my order fulfillment process. Key Features: - **Order Recording:** The tool should save all order details locally in a database. This serves as a valuable record of all transactions for future reference and analysis. - **Packing Page:** I need a simple packing page that allows me to mark individual items as packed. This will help keep track of the packing process and ensure all items are included. - **FedEx API Integration:** The tool must be capable of integrating with FedEx's API to perform crucial shipping tasks such as: - **Fetching Shipping Rates:** It should automatically retrieve shipping rates from FedEx to provide a...

Laravel who can start immediately. Work with ftp only. Import excel work

I'm in need of a talented UI designer who can create a highly interactive interface for a PHP Laravel project. The primary objective of this job is to design a user interface that will target business professionals and provide them with a seamless and engaging experience. Key Requirements: - Proficiency in UI design for PHP Laravel: You should be well-versed in creating user interfaces specifically for PHP Laravel projects. - Experience with Interactivity: The interface you design should be highly interactive, offering real-time features and engaging functionalities. - Understanding of Business Needs: The target audience for this interface is business professionals, so your design should cater to their preferences. - AWS Knowledge: Familiarity with AWS would be a...

I'm in need of an expert in social media integration to assist with linking my Instagram business account to Facebook. This project specifically requires the following: - Setup for automatic sharing of new Instagram posts directly to Facebook. These should appear as regular Facebook posts, maintaining a consistent and seamless user experience. - Import existing photos and videos from my Instagram account into Facebook. This will ensure my Facebook audience has full visibility of my past Instagram content. The primary goal of this project is to expand my brand presence. The ideal partner for this project will be experienced in both Instagram and Facebook integrations, with a strong understanding of how to optimize brand visibility across platforms.

I'm looking for a PHP developer to assist in updating a core part of my project quickly. This is a backend development task that requires immediate attention. Key Responsibilities: - Update a critical part of the project written in core PHP. - Ensure the changes are implemented quickly to avoid delays in the project. Ideal Candidate: - Proficient in PHP, with a solid understanding of core PHP. - Experience with backend development is a must. - Able to work under pressure and deliver tasks promptly.

I need an experienced PHP developer to fix some issues in our existing code. The main problems are with the Search functionality and the Database Connection. Key responsibilities: - Fixing the broken search functionality - Resolving the database connection issues Your application should demonstrate: - Proven experience in PHP - Understanding of database connections and search functionalities - Good problem-solving skills Please include relevant experience in PHP in your proposal.

I'm looking for a skilled PHP developer who can make alterations on my current website. The job involves updating and deleting specific buttons. Ideal skills for this position include: - PHP expertise - Frontend development experience - Proven track record of similar projects The work requirements consist of: Button Modification: - Update and Delete functionalities need to be adjusted to drive a smoother UX - Exact buttons cannot be disclosed publicly, those details will be shared privately with the selected candidate. Note: There's no addition of new functionalities or features required. In return for your work, I promise clear communication, prompt payment, and positive feedback for a job well done. I look forward to working with you!

Our development team just wrapped up front end development for a large-scale website. At this critical juncture, we're seeking advice to ensure that our back-end databases - PostgreSQL and Cassandra - will be optimally performing and highly available. Key areas of consultation include: - Performance optimization strategies - Replication and high availability options - Ideal design of databases to accommodate the scale of our website Ideal professionals would bear extensive experience with both PostgreSQL and Cassandra databases, as well as a keen understanding of integrating front-ends to back-end databases. Your prior work with large-scale website infrastructures will greatly benefit our project. Database optimization and design aptitude is a crucial requirement for ...

The aim of the system will be to develop a system where you can capture staffs performance on a daily basis and make notes as needed. Under the reporting section you will then be able to select an employee and date range and view any offenses that was made by the employee. Portal will consist of: 1. Work Category: This is where you can create the various categories in your business....Category and click on FILTER to search We then show all employees who has infringements under this category for the date range and categories. Sample Layout 5.2 Infringements by Employee: Fields to start will be Select Date Range Select Employee and click on FILTER to search We then show the specific employee with their infringements Sample Layout All reports in 5.1 and 5.2 can be exported to XLS...

I'm encountering an issue in Proxmox with the error message "no pool available" when trying to import a ZFS pool. - The project requires immediate attention, so a quick response is essential. - The successful freelancer will be able to diagnose and resolve this specific error in Proxmox. - While not specified, working knowledge of ZFS and Proxmox is crucial for this project. I'm eager to have this issue resolved as soon as possible. Looking forward to your bids.

I am currently seeking a full-time PHP Laravel developer to join my IT company. The ideal candidate should have 2-5 years of experience and be proficient in working on a variety of projects including e-commerce websites, custom web applications, and API development. Key Responsibilities: - Full-time commitment to the IT company - Develop and maintain e-commerce websites - Build custom web applications - Create and maintain APIs Skills and Experience: - 1 to 2 years of PHP Laravel development experience - Proven track record of successful e-commerce website development - Strong experience in custom web application development - Proficiency in API development - Frontend development skills are a must If you possess the required experience and skills, and are ready to commit ...

Please Sign Up or Login to see details.

I'm in need of a skilled PHP Laravel and Bootstrap developer to handle feature customization for my project. - **Specific Functionalities**: I need customization of back-end functionality to ensure the system operates seamlessly and efficiently. - **Ideal Candidate**: - Proficient in PHP Laravel and Bootstrap - Experienced in back-end functionality customization - Able to provide efficient and effective solutions for feature integration. Your work will be pivotal in ensuring that the project meets the standards of excellence that we aim for.

i have a php code from an application working on an external website, i want to inser it on a wordpress page

I'm looking for a skilled PHP developer, specifically with experience in cryptocurrency, to assist in creating an escrow service. The main goal of this service is to ensure secure transactions between parties, with an automatic payment release feature upon job completion. Key requirements for this project include: - Proficient in PHP: You should be well-versed in PHP to develop the necessary coding for this project. - Cryptocurrency Experience: A background in working with cryptocurrencies, especially Bitcoin, Ethereum, and Litecoin, is crucial for the escrow service. I'm looking for someone who can help me implement a reliable, efficient, and secure escrow system for my project. Experience in both PHP development and cryptocurrency are key criteria...

...for 4 hours for £20, rent for 5 hours for £25, or rent for 6 hours for £30. Instead, could this be a dropdown. Instead, I would like to replace this with a tick box that users tick to bring their own rifle or leave unticked if they would like to rent a rifle. The system should calculate the price automatically. I will give you a wp-content folder and sql file you can import and work with to make these changes. Simply import these folders in the zip to WP Local, which can be downloaded at or use any other software you choose. The maximum deadline where all files should be handed back by is Friday 24th May 2024 at 23:59 BST....

I require an expert web developer who ca...existing website, and as such, I insist on maintaining the current URL structure for SEO reasons. Key tasks for this job include: Figma Design - Translation of my figma design to a live website. - Maintaining the current URL structure - Creating 12 pages, an import of a blog (around 60 posts) and a pop up. The ideal candidate has significant experience with: - Figma - Website design and development. - SEO strategies, particularly URL structure. Please, only bid if you have a portfolio that demonstrates similar past projects. Looking forward to working with you. DO not contact me outside of Freelancer

...capability to code with JS, PHP, deeply knowing Prestashop controllers override. I need a prestashop expert to complete an erotic ecommerce shop. It is a drop shipping business and we have the interface with supplier constructed already. If your religion or environment does not allow you to review erotic pictures, this opportunity is not suitable for you. We still have below main jobs pending. You must be an expert on building website with prestashop and deeply know SEO. 1. Installing caching system as below and configure them to get my website speed faster. Memcached via PHP::Memcache Memcached via PHP::Memcached They can be found at advanced parameters/performance/caching 2. Develop a pricing module to set the retail price. There is a installed module to imp...

**Only looking for Sharepoint Design - Please do not respond...Clients and Jobs lists (e.g. New Client = Setup New Document Set) The lists above are linked so I want to columns to link to the appropriate list (e.g. Clients to their respective jobs). I won't be able to share the API key with you because of sensitive data however you can use the sample responses provided on the XPM site to design the power automate flows and SharePoint site. Once done, I can import into my environment as I have already setup the custom connectors. Ideal candidates for this project would have: - Proficiency in Power Automate and Sharepoint Design - Experience in creating custom Sharepoint lists and document sets - Proven track record in setting up data synchronization, particularly with extern...

...application for my project. This application requires: - User authentication and authorization, roles: Global Administrator: - Access to everything Application Administrator: - Access to application and data for all companies Company Administrator - Access to all applications and data for companies assigned to them Application roles (not administrator) - Supervisor - HR - User - Database: PostgreSQL - Integration with external APIs - Data processing and manipulation functionalities - Integration with a National ID validation API: - Security: JWT Token APIS: 1. User validation (username - password) - method: POST OK - Status 200 { jwt_token, refresh_token, user{first_name, last_name},global_permission,application_permissions} error messages: USER-DOES-NOT-EXIST

I am looking for a skilled developer to design and build a multi-tiered login system in PHP for an Alma Linux platform utilizing MySQL. The system should have specific functionalities as listed below: Key Functionalities: - User Login - User roles and permissions Roles and Permissions: - Admin - Supervisor - User Each role should be able to perform these actions: - Admin = Create, edit, and delete users - Supervisor = Manage content and posts - User = View and comment on content The ideal freelancer for this project should have a strong experience in PHP, MySQL, Linux, and understanding of user role management systems. Familiarity with Alma Linux is a strong plus. Your solution should be robust, secure, and scalable. Please provide examples of similar projects you have co...

...to column 1. same way if I add to column 1 it should add to column 2 table two. I am able to achieve for column 1 but not inside column 2 table. can you lee me know how to fix it. Providing my code and fiddle link below. ,src%,src%2FApp.jsx&terminal=dev import { useState } from 'react'; import reactLogo from './assets/'; import viteLogo from '/'; import './'; import { DragDropContext, Droppable, Draggable } from 'react-beautiful-dnd'; function App() { const [panelOpen, setPanelOpen] = useState(false); const [columns, setColumns] = useState({ column1: { id: 'column1', items: ['Sample_Step1', 'Sample_Step2'] }, column2: { id: 'column2', items: []...