Sql server database stored procedure web service wrapper jobs

I am in need of a results-driven digital marketer for my food service website. Its main objective is to generate leads for catering services. While the target audience has not been explicitly defined, an experienced individual will know which audience to target to yield the best results. The primary task would be to creatively place ads in free ad websites. If you can show me that you are effectively driving business, there's potential for increased budget allocation and ongoing work. While there is no strict timeline, it would be ideal to start seeing some progress as soon as possible. Key Skills/Experience Needed: - Proven experience in digital marketing, particularly lead generation - Excellent communication and creativity - Understanding of the catering services indust...

...in communicating complex business ideas in a concise manner. Key Requirements: - The deck should include a high-level market analysis. While I don't need an extensive deep dive into the market, it must still provide an overview that conveys the potential and viability of my business to potential investors. - I would like the deck to cover several key sections: - Company Overview - Product/Service Description - Business Model - Competitors - Strategic partners - Achievements - Next steps - Objectives/needs - Investment requirements - Team Ideal Skills and Experience: - Proven track record in creating successful investor pitch decks, ideally in the tech or startup sector. - Strong understanding of market analysis and the ability to present data in a clea...

I am looking for a skilled developer to create a Window...skilled developer to create a Windows-based application that can interact with a remote database. The application should primarily focus on retrieving and generating website sitemaps based on different criteria. The ideal candidate should have: - Proficiency in Windows application development - Strong experience in working with databases, particularly remote databases - Knowledge in data retrieval and data update functionalities - Ability to understand and incorporate additional requirements as the project progresses Please note that the selected freelancer may need to provide examples of past work and project proposals. Note: Application should be able to connect different type of databases such as MS SQL Server...

I'm facing an issue with my Laravel admin panel, specifically a database table owner error that's occurring when uploading a zip file. - The error seems to be centered around the database table ownership. - The error happens during the process of uploading a zip file. - I can provide more details on the issue if required. I'm looking for a professional with experience in Laravel, database management, and debugging to help resolve this issue. The ideal candidate should be familiar with Laravel's database interactions and be able to navigate and troubleshoot these types of issues efficiently.

As a business utilizing Salesforce, I am seeking admins and developers with deep understanding of the platform to craft insightful blogs focusing on: - Salesforce Administration - Salesforce Development This is not general content writing project instead need content creators who have base understanding of platform. The key requirement...desire to improve their Salesforce skills. Prior experience in blogging about Salesforce or similar CRM systems would be highly beneficial. Please include samples of prior work in your proposal if available. When responding, please give your estimate on per blog charge. As we are starting fresh, we are looking for blogs on all areas of Salesforce ecosystem targeting admins and developers on Sales, Service and Experience Cloud to begin with.

I'm in need of an SEO expert who can assist me in building a high-sales generating website for my carpet cleaning business. Please note that I'm looking for a business partner rather than just a service provider, with the expectation that we will share the profits. Watch this before you send me a quote. Key Goals: - Increase Website Traffic: The site should attract and engage a significant number of visitors. - Improve Website Conversion Rate: Conversion optimization is crucial - we need visitors to turn into paying customers. - Rank High on Search Engine Results: The site should be SEO-optimized to reach a top position in search engine rankings. Key Information for Applicants: - Please share your past

...Activity Logging: Implement an activity logging system that records all interactions performed through the application, including message sending, delivery status, etc. Technologies Used: PHP: Primary programming language for backend development of the application. MySQL: Database for storing user information, contacts, and activity logs. WhatsApp Business API: Official API provided by WhatsApp for sending messages from business applications. HTML/CSS/JavaScript: For frontend development of the administration and configuration web application. Deliverables: Complete source code of the PHP application. Detailed documentation on installation, configuration, and usage of the application. User manual to guide administrators in using the application. Considerations: It is impo...

I'm seeking a versatile call agent capable of juggling several tasks. Your daily responsibilities will span from answering inquiries to making outbound calls and taking sales orders. You’ll be primarily dealing with both business and individual customers - hence, excellent communicatio...responsibilities will span from answering inquiries to making outbound calls and taking sales orders. You’ll be primarily dealing with both business and individual customers - hence, excellent communication skills are a must. All-rounders who can handle product details, order status, and customer complaints proficiently will be an ideal fit. This job requires a keen eye for detail, sales and customer service expertise; multitasking proficiency is a must. Previous call center experie...

...We wanted to redevelop 3 existing Static HTML+PHP websites, and 2 new Wordpress website. I'm looking for a professional web designer to develop a unique, modern website. The website is to serve as an information sharing platform, targeted at the general public. We are planning for a wordpress website for a Interior Design Business. It should contain the below mentioned requirement. Key Points: - The target audience is the general public, so the design should be user-friendly and accessible to all. - The primary purpose of the site is to share information. It should be easy for me to add new content, such as articles, images, and possibly videos. Required Skills: - Web design expertise, particularly in creating user-friendly and visually appealing information shar...

I am in need of expert help to scrape text data from specified websites. After the data has been colle...scrape text data from specified websites. After the data has been collected, the next step is to clean the data, ensuring that it is in the appropriate format for use. The final output should be managed and stored in a Database Management System. The ideal freelancer for this project should have: - Proven experience in web scraping, specifically text data from websites - Advanced skills in data cleaning to ensure the data is usable and well-structured - Capabilities to manage and store the cleaned data into a Database Management System Please provide any relevant examples of previous work in web scraping and data cleaning and provide details about h...

I'm seeking a versatile call agent capable of juggling several tasks. Your daily responsibilities will span from answering inquiries to making outbound calls and taking sales orders. You’ll be primarily dealing with both business and individual customers - hence, excellent communicatio...responsibilities will span from answering inquiries to making outbound calls and taking sales orders. You’ll be primarily dealing with both business and individual customers - hence, excellent communication skills are a must. All-rounders who can handle product details, order status, and customer complaints proficiently will be an ideal fit. This job requires a keen eye for detail, sales and customer service expertise; multitasking proficiency is a must. Previous call center experie...

...letter to a company based in Japan. The chief grievance being poor customer service enlightened during an over-the-phone interaction, where the representative lacked essential knowledge about the product/service. Crucial expertise and skills required: - Professional level letter drafting and editing. - Knowledge and understanding of customer service standards in Japan. - Proficiency in conveying dissatisfaction professionally and constructively in written communication. - Previous experience in handling complaints or customer service related issues. The ultimate goal of this project is to achieve a satisfactory answer or some improvement in the customer service area.l from the company for their substandard service. Communication must r...

...with the sitelogo on it in the middle. - On a desktop view we want the left side of the screen to have a tree trunk run along on the left till the footer And leaves on the right. - Footer content should include: Column 1: Small kalataru logo and under it social media links Column 2: About us Contact us Careers Kalataru Magazine Column 3: FAQs Returns and exchanges Shipping and Handling Terms of Service Privacy Policy Column 4: Sign up to our email Newsletter (Email ID text box with validation) (Subscribe button) - Integration with payment gateway (phonepe) - Cart and login mechanism should be OTP based and very direct and easy - Collect user data in a proper format (ip, usage, email_id, phonenumber, name, etc) - Integrate with google analytics - The background needs to have flor...

I'm looking for a professional website designer to create a fully responsive portfolio site for my event company. Ke...professional website designer to create a fully responsive portfolio site for my event company. Key Features: - The design must be specifically tailored for an event company, focusing on showcasing our services and previous events. - The website should include sections for 'About us', 'Services', 'Gallery'. Ideal Skills & Experience: - Proven experience in designing portfolio websites, especially for service-oriented companies. - Proficiency in creating fully responsive websites that are optimized for mobile devices. - Familiarity with best practices for incorporating 'About us', 'Services', 'Galle...

I'm in need of a dedicated and skilled customer service expert with at least 5 years of experience to help me manage my e-commerce store's customer service operations. Key Responsibilities: - Handling order tracking and fulfillment - Managing returns and exchanges - Answering customer inquiries - Responding to live chat - Making phone calls when necessary - Reaching out to customers for reviews - Reviewing and auditing invoices from the optometry lab and fulfillment center - Responding to social media messages and comments - Assisting in signing up new affiliates - Conducting influencer outreach Skills and Experience Required: - At least 5 years of experience in customer service, preferably in an e-commerce setting - Proficiency in using Live chat softwar...

Get A to Z Professional Graphic Design Service within your Deadline. Powerpoint/Logo/Company Profile/Brochure/Flyer/Banner/Social Media Post

I have the SQL file and main images of my current Wordpress site, and am looking for a professional to migrate and set it up on the new hosting account. We have the hosting account set up and will share the files with a dropbox link. Key Requirements: - Migrate current Wordpress site to a new hosting account - Setup and configure Wordpress in the new hosting environment - Ensure all site functionalities are working post migration - Provide login credentials for the access to Wordpress Please note: - There are no custom changes or updates needed during the migration - The new hosting environment is fully compatible with Wordpress Ideal Skills: - Proficient in Wordpress migration and setup - Knowledgeable in SQL databases and file handling - Experience in configuring hostin...

I have a small building floor plan, and I need a 3D model of it, designed with a Starbucks theme in mind. Key Requirements: - The building is small, so the 3D model should be in proportion. - The interior design sh...proportion. - The interior design should be detailed and include branded elements associated with Starbucks. - Specific features to be included in the exterior design are a parking space, an outdoor seating area, along with a drive-thru service. Ideal Skills and Experience: - Proficient in 3D modeling software for architectural projects. - Experience in interior design with a focus on branded elements. - Creative approach to incorporating Starbucks theme. - Ability to include specific details like a parking space, outdoor seating area, and drive-thru service i...

I'm searching for an outgoing, eloquent individual to make calls to homeowners in New Hampshire, with a focus on selling our solar home improvement services. Responsibilities will include: - Communicating professionally to promote our product - Answering any questions homeowners may have about the service - Tailoring your sales pitch to persuade homeowners of our solar service's value It's essential that the candidate possess: - Exceptional communication and persuasion skills - Previous experience in telemarketing, preferably within the home improvement sector - Knowledge of solar energy systems and their benefits, as this will count heavily in your favor when conveying the product’s value to homeowners. If you are a determined go-getter with a knack for...

As the developer of an existing project written in Python, SQL Server, and MongoDB, I am currently facing a challenge. A logical error in the code is causing a bug, and I need an expert to fix it. High-level summary of the code- 1. Fetch records from SQL server ( total 680000 records) 2. Apply face recognition on each record 3. Insert the response from step 2 in MongoDB along with other data from the SQL server Issue- The existing code is currently doing steps 1 & 2 and performing step 3 at last when face recognition is applied on all records. Due to this it step 3 is waiting to complete the step 1 & 2. Expectation- After fetching each record from SQL server, the code should apply face recognition and then store the data in...

I'm looking for a skilled web developer who can create a stunning landing page to effectively showcase my product/service. Key Requirements: - Design a visually appealing and professional landing page that effectively presents my product/service. - Ensure the page is responsive and works well on multiple devices. - Implement the necessary SEO elements to optimize the page for search engines. Ideal Skills: - Proficiency in HTML, CSS, and JavaScript. - Experience in designing and developing landing pages. - SEO knowledge is a plus.

I am a logo design expert. I can create logos as well as design other projects using CorelDRAW application

I'm in urgent need of a Field Service Management Web & Mobile App that utilizes Google's Cloud Services. The app should have the following features: - **Scheduling and Dispatching:** The ability for a dispatcher to schedule and assign tasks to field service agents. - **GPS Tracking and Mapping:** For the precise location tracking of field agents and the ability to map their routes. - **Customer Relationship Management (CRM):** A robust CRM system that allows for customer data management, tracking of customer interactions, and more. The app needs to be accessible on iOS, Android, and the Web. I'm looking for a developer with experience in field service management systems and utilizing Google's Cloud Services. The ideal candidate...

...The form needs to be integrated with Contact Form 7 plugin - Should support multipage logic for better user experience - Collect and store user-provided data including: - Name and contact information - User input and preferences - Additional comments and feedback - Implement a method to save all incomplete form data. This data should be: - Sent to a designated email address - Stored in a specific page inside WordPress dashboard, already configured Furthermore, I require the setup of an export mechanism for this incomplete data, specifically in a CSV format. This CSV should: - Have separate columns for each field to ensure easy data processing - Include timestamps for each form submission for traceability and analysis. The ideal candidate should be proficient...

I'm looking for a proficient and creative...images and company information * Flyer to effectively communicate our junk removal services * Redirect audience attention toward our environmental-friendly procedures * Must be versatile for both print and web distribution * Captivating and professional design that presents trustworthy and reliable service The flyer will be distributed to the general public, hence it must be designed in a way that is engaging to diverse audience ages and backgrounds. Ideal skills: * Proficiency in graphic design software * Understanding of marketing strategies * Experience in creating product/service advertisement * Good understanding of the general public market segment. The attached flyer is not us and very bad design. This ...

I'm currently looking for a proficient paralegal based in Toronto who can advocate on my behalf during a small claims court proceeding. The claim revolves around a contract ...excellent negotiation skills - Is familiar with small claims court proceedings Key Responsibilities: - Representing me during the dispute - Analyzing written communications related to the dispute - Scrutinizing signed contract documents to identify areas of breach Proven experience in such cases will be highly appreciated. The preferable candidate should be efficient in delivering the required service and prompt in communication. Please provide your relevant experience when bidding. sould you need more evidence to support this case, please cal/txt/whtsp -416 -827 -4749 -SHAN then to povide you ...

Swedish speaking applicants ONLY! In need of an astute individual well-versed in criminal law to assist with a case involving assault and battery. The main tasks are: - Researching national case law relevant to the case - Analyzing precedents that could infl...that could influence our strategy It's critical to have experience in Swedish criminal law, and a proven ability to research and analyze case laws and precedents. Being well-knowledgeable about Swedish national jurisdiction will be a significant advantage. Specifics: The German attorney needs case law regarding and in accordance with Chapter 59, Section 1, first point of the Code of Judicial Procedure (1942:740): Gross miscarriage of justice, for an appeal to the Swedish court. You need to be an active Swedish lawy...

As a business user, I need assistance with the configuration of SSRS Reporting Service on a staging environment. I have configured the WebPortal using Report Server Configuration manager and I am able to run SSRS reports from the Web UI. The project requires the following: 1. Automatically Scheduling of SSRS reports with default parameters. 2. Exporting the outcome of SSRS reports in a given folder every time a scheduled report runs I am experiencing the following issue while scheduling: Error: The SQL Agent service is not running. This operation requires the SQL Agent Service. You will need to help get rid of this error and set up scheduling and exporting of reports as mentioned. You will be required to get on a video call and help m...

...intuitive user experience, catering specifically to our clientele who value ease and efficiency. Project Requirements: Branch-specific Design: Each of our four branches should have its own section within the app, complete with a unique logo and a tailored list of services. Service Listings: Detailed information on the variety of services offered at each location, including descriptions and pricing. Custom Pricing: The application should display different pricing structures for each branch, reflecting our diverse service offerings. Appointment Booking System: A straightforward, user-friendly system for customers to book appointments. This system should integrate smoothly with each branch’s schedule to offer real-time availability. Platform Availability: The app shou...

... we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. We're excited to collaborate with a dedicate...

...a fixed form. Employer can post as many jobs using an upload job form. The data is stored in a table. On clicking the Find Jobs button (after uploading resume) or Find Profiles (for each job posting uploaded) the results page will show the ranked results (either job or resume depending on user). Home Page - Login SignUp buttons only...no design or banner or random stuff. Profile Page - Form Filling page with resume details. Resume Form Page Job Description Page Simple Dashboard (employer only) page with My Jobs Results Page for job seeker and for employer. Deliverable is the Website. I will provide the algorithms coded in python on 18th morning. You must integrate everything and a fully functional web application by 19th evening. DO NOT WASTE YOUR BID IF YOU CANNOT D...

I'm seeking a skilled developer who ...main responsibility on the design front involves refining my site's navigation. This implies that you'll need to understand how the navigation menu is currently arranged and accurately remove specific items. - Database Optimization: I am excited to augment the performance of my website. For this, I require optimal reformation of the existing database structure. This task demands proficiency in managing Laravel databases and an understanding of optimization best practices. The ideal candidate for this project is detail-oriented and exhibits a strong understanding of Laravel, database optimization techniques, and UI/UX principles. Knowledge of the latest design trends and how to selectively prune menus for user-frie...

I am looking for someone who is very fam...specifically for developing an application that will interact with REST APIs. The primary function will be inter-service communication. In addition, a strong understanding of Docker is necessary for deployment purposes. Understanding efficient use of Docker will greatly influence the success of this project. Ideal candidates will have: - Expertise in Node.js, REST APIs, and microservices - Strong working knowledge in Docker for deployment - Experience with facilitating inter-service communication - Efficient problem-solving abilities This project will not only test your technical skills but also your ability to troubleshoot and problem-solve as we work together to create efficient inter-service communication methods using No...

I need a Power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: - Retrieve Product ID, Quantity and Location. - Gather Specific Production Data including t...number. Ideal Skills: - Proficient in DAX query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results like in the yellow column in Excel.

...automated, user-friendly manner without manual intervention. This includes the ability to manage domains, select hosting packages, and complete purchases with full integration of the payment systems we plan to use. Requirements for the Hosting Plugin: Automated Account Creation: Users should be able to sign up and automatically have their hosting account set up without manual intervention. Service Ordering: Integration with our control panel's API to allow users to order and manage their hosting directly through WordPress. Domain Management: Users should have the option to use a domain they own, select a free subdomain from us, or purchase a new domain during checkout. The option to buy a top-level domain should be toggleable in the admin panel. Customizable Hosting P...

Hi Yasar W., I noticed you posted a following project ( https://www.freelancer.com/projects/sql/SQL-Expert-Needed-for-Data/details )

We're on the search for a dedicated Customer Support Specialist for a part-time (4 hours/day) position to enhance our customer satisfaction. Key Responsibilities: - Handle communication via emails, live ...to enhance our customer satisfaction. Key Responsibilities: - Handle communication via emails, live chat, and social media. - Efficiently answer client inquiries. - Resolve customer complaints in a professional and timely manner. - Share accurate product information. - Amend product orders and customer accounts in Shopify as required. Ideal candidate should have prior experience in customer service. Excellent problem-solving skills, knowledge about our product line, and a can-do attitude are essential. Training will be provided to ensure familiarity with our product and co...

I'm in need of a digital marketing expert who can effectively manage my email campaign. The primary goal of this campaign is to promote a product or service to potential new customers. Key Responsibilities: - Develop and execute an email marketing strategy to promote our product/service - Monitor and optimize campaign performance - Ensure compliance with email marketing regulations and best practices Skills and Experience: - Proven experience in managing successful email campaigns - Understanding of email marketing regulations and best practices - Ability to engage potential new customers through email outreach - Proficiency with email marketing tools and analytics.

I need an expert to design a DICOM database specifically for storing and retrieving radiology images. Key requirements are: - Comprehensive understanding of DICOM Standards - Proficiency in database design and administration - Experience in handling medical images, particularly radiology The proposed database should support retrieval of images via Unique Identifier Codes (DICOM's UID). Being well-versed in medical systems integration will be considered a great advantage. This project will require strict adherence to privacy regulations and standards.

I’m seeking an experienced web designer to create a dynamic and intuitive online platform for selling my professional consulting, design, and writing services. Key Requirements: - The website will primarily focus on selling services. - It should be able to display my professional services in a user-friendly and visually appealing manner. - It should be designed with PayPal as the exclusive payment gateway. Ideal Candidate: - You should have excellent web design skills with strong knowledge of user interface and experience. - Having experience in creating websites in similar niche will be an advantage. - Prior experience in integrating PayPal for online transactions is required. I'm excited to see how your skills and creativity could enhance this project. Kin...

...maintaining high quality customer service standards. - **Data Entry and Organization**: You would be responsible for entering and organizing data within our Shopify platform. This would include product information, customer details, and other pertinent data. - **Customer Query Resolution**: Addressing customer queries in a professional, friendly and efficient manner is crucial. You would need to have good problem-solving skills. **Daily Volume**: The expected volume of emails and queries to be handled on a daily basis typically falls within the range of 50-100. It's important to maintain a quick turnaround time while ensuring accuracy. The ideal candidate should have: - Proficiency in Shopify platform administration - Strong experience in email handling and customer s...

I am in need of a modern and sleek logo for my locksmith business. The ideal designer will be able to incorporate the colors of pink, sky blue, and dark grey in an innovative way. Key Requirements: - Incorpor...blue, and dark grey in an innovative way. Key Requirements: - Incorporate symbols/icons: I'm particularly interested in the use of a lock, keyhole, or a protection/shield symbol. - Modern Style: The overall design should be reflective of a modern aesthetic, steering clear of anything overly traditional or vintage. Skills and Experience: - Proven experience in logo design, particularly for service-oriented businesses. - Proficiency in modern design approaches and understanding of color theory. - Ability to take visual concepts and translate them into a unique and pro...

I need a script to automate server updates. It should be able to handle operating system updates, software updates, and security patches. Key Requirements: - The script should be able to automate server updates - It needs to handle operating system updates, software updates, and security patches Ideal Skills: - Proficiency in scripting languages - Experience with server management and updates - Understanding of cybersecurity and best practices - Strong problem-solving skills and attention to detail.

Create a windows service to read data from RESTful API using Authorization Token

...maintaining high quality customer service standards. - **Data Entry and Organization**: You would be responsible for entering and organizing data within our Shopify platform. This would include product information, customer details, and other pertinent data. - **Customer Query Resolution**: Addressing customer queries in a professional, friendly and efficient manner is crucial. You would need to have good problem-solving skills. **Daily Volume**: The expected volume of emails and queries to be handled on a daily basis typically falls within the range of 50-100. It's important to maintain a quick turnaround time while ensuring accuracy. The ideal candidate should have: - Proficiency in Shopify platform administration - Strong experience in email handling and customer s...

I need a proficient data specialist to compile a comprehensive database of Romanian companies. - Compatibility: The database must be compatible with Windows and Mac platforms. - Specific Details: Every company's record in the database must contain the company's name, phone number, and email address. - Extent of Database: Aim for a sizable database that contains information about 100,000 companies. Ideal candidates will have experience in data mining and database management, and an understanding of Romanian market dynamics. Strong accuracy and attention to high-quality data is a must.

I'm seeking a professional who can effectively promote and grow a Facebook group dedicated to the exchange of free items like furniture, clothing, and tools. This group is primarily targeted towards community service groups advertising donations. I aim to quickly grow a Facebook group to 10,000 members, focusing on connecting individuals across the USA who offer free items like furniture, clothing, and tools. Our objective is to foster a community that provides easy access to these resources. Freelancers should use organic traffic strategies to attract members. I'd appreciate a demonstration of your ability to increase group membership. Successful completion of this task will result in a monetary bonus for outstanding performance. Link for facebook group -

I am seeking a skilled mobile app developer to create a cutting-edge mobile application for iOS & Andoid. The primary objective of this project is to develop a robust and user-friendly app that will be deployed as a Platform as a Service (PAAS) solution for business. Key Requirements: - Proficiency in IOS and Android app development - Experience with PAAS application development is a plus - Strong understanding of software development - Payment gateway development The ideal candidate should have a proven track record in building successful, high-quality mobile applications. The app should be designed to streamline business processes, enhance user experience, and provide a solid foundation for scalability and future feature additions. Please include samples of your previous...

...will include links for the homepage, “Our Services,” Job Board page and blog page. The 4 subpages will be linked in a submenu under the “Our Services” heading. The blog menu entry can be removed from the menu so as not to be accessed until I choose to turn it on. Homepage should highlight our 4 services and include royalty free images for each of our services. Each service should include a subpage with content detail of that service we offer (Lorem Ipsum content sufficient for design mockups). Each page will include a contact form to send a message. Our 4 Services (subpages) include: 1. Employers 1. Hero text: Most Placeable Candidates 2. Title: Employers start here 3. Contact Form sends email to given email address with a subject lin...