Vbscript excel example sql server connection string jobs
Simple task I have a .CSV file and I want a program that translates it to .SQL with the existing database
I am seeking a skilled Flutter developer with experience in USSD_Advanced to help with an issue I am experiencing. - The Challenge: The problem centers around my inability to retrieve the last USSD response in a multisession USSD. This specifically concerns USSD_Advanced integration for Flutter. - Desired Outcome: In a perfect scenario, I would like to be able to correctly retrieve a string of text as a response. Currently, the last response within the multisession is not being returned, which is proving problematic. - Use of Last Response: While the specific use within the application is currently classified, understanding the ability to retrieve complex strings of text within USSD responses will be helpful. Skills and experience needed: - Proficiency in Flutter - Experience...
As a seasoned C# developer, I need to create a complex mapper function that can efficiently extract data from Excel. The .xlsx files contain variable patterns spread across different sheets, so having the flexibility to handle such diversity will be key for this task. Key Requirements: - Develop a mapper function in C# to process Excel files in .xlsx format. - Deal with variable data patterns having different layouts spread across numerous sheets. - Extract and process data from all sheets in the Excel file. Skills and Experience: - Profound expertise in C# programming. - Experience in handling Excel data with variable patterns across multiple sheets. - A robust understanding of data extraction processes. - Proven experience in developing mapping functions...
...Retool Engineer to join our team for a 2-month contract position. The ideal candidate will have a minimum of 2 years of experience in software engineering, with specific expertise in Retool and SQL. This individual will play a key role in developing, maintaining, and optimizing Retool applications to meet the needs of our clients. Responsibilities: Collaborate with cross-functional teams to understand business requirements and translate them into functional Retool applications. Design, develop, and implement custom Retool solutions to streamline processes and improve efficiency. Write complex SQL queries to extract, manipulate, and analyze data from various databases. Troubleshoot and debug issues in existing Retool applications, ensuring smooth functionality. Conduct re...
...you looking for a great opportunity to start working part time and eventually get a full time remote job from home? We’ll that’s what you’ll get with World Kwest! Requirements • Develop and maintain our database system using PHP and SQL. • Optimize database performance for efficiency and scalability. • Collaborate with the development team to implement new features and functionality. • Troubleshoot and resolve database issues in a timely manner. • Stay updated on industry best practices and technologies. ROLE RESPONSIBILITIES : • Proficiency in PHP and SQL is essential. • Experience with HTML, JavaScript, and/or React is a plus. • Strong problem-solving skills and attention to detail. • Excellent communicat...
I require a talented editor to improve and uplift my current 1600-word case study focused on Cyber Extortion. The case study is in dire need of refinement in several crucial areas, which I believe are preventing it from realizing its full potential. I want to add a more human element to the case study to help readers connect with the material. The content shouldn't sound like AI generated. - Clarity of Content: As it stands, the point of the case study might not be crystal clear to every reader. I want to ensure every bit of information provided adds value and moves the narrative forward in a clear, concise manner. - Grammar and Punctuation: While content is key, impeccable grammar and punctuation are non-negotiable. These are foundational aspects of high-quality writing and prov...
As the project lead, I am in urgent need of a self-driven and detail-oriented freelancer who specializes in online data entry. This project's volume isn't specifically set, but the selected individual should be prepared to handle a potentially large amount of data entry tasks. Tasks will include but are not limited to: - Prompt and accurate entry of data into our online system. Ideal candidates for this job should have the following skills and experience: - Proven online data entry experience, with references or portfolio to back it - Dedication to efficiency and accuracy - Ability to work under unknown volume pressure - Availability to start immediately would be an advantage Unfortunately, we have not yet established a definitive deadline, so freelancers with some de...
...from a remote server in a simple script on my main server. The script on the main server will execute the PHP to retrieve information from several other sites. I know that this is not the preferred method, but there are absolutely no security risks involved. This is a super simple script that runs a Woocommerce database update. I want to avoid to upload the script on every Woocommerce site for two reasons: 1. I would like to maintain only one single script, if changes are needed. 2. More important: I try to avoid any additional files in the root of a WordPress installation. This can sometimes cause trouble with malware scanners. Just to make this very clear: I don't need the scripts itself. This is all working fine. I need a solution to include the script fr...
I am currently seeking a highly qualified candidate with robust experience in developing web applications and designing database structures. The location of operation will be Hyderabad, and preference will be given to local candidates. Key responsibilities: - Development of both in...local candidates. Key responsibilities: - Development of both interactive and informational web applications - Designing suitable database structures To perform efficiently in these tasks, the candidate should ideally have: - A minimum qualification of graduation - At least 9 years of relevant experience, which should reflect in their seniority level - Expertise in C#, ASP.NET, .NET COO, and SQL databases For your bid to be considered, please ensure your profile aligns with the aforementioned req...
I am looking for a skilled data analyst who can proficiently use Excel to perform text matching between two different Excel files for the purpose of matching the most appropriate description given to a medical service code . No significance testing is needed in this project, it is purely a direct comparison task. I have particular requirements pertaining to "Data set A". Your role will be primarily centred around: - Matching text in one Excel sheet to another. - Consolidating data based on text matches. - Focusing specifically on "Data set A". Ideal candidates should be experienced in Excel, data consolidation and comparison. Knowledge on data set handling would be a plus. Please bid accordingly, ensuring your capabilities in these areas ar...
I'm looking for an experienced data manipulator who can efficiently reformat my data according to CRM-specific requirements. Specifically, I need the address and names in my data to be split into separate columns. Key requirements: - Break down the existing 'Address' field into: 'City', 'State', and 'ZIP code' columns. - Split...split into separate columns. Key requirements: - Break down the existing 'Address' field into: 'City', 'State', and 'ZIP code' columns. - Split 'Names' into two separate columns: 'First Name' and 'Last Name'. This does not require any data entry, just an understanding of data structures, and layout according to CRM needs. Ideal freelancer should h...
I urgently need an experienced ASP.NET developer to perform a ...specific bugs are not defined yet but it involves issues that usually occur in ASP.NET applications. - Freelancers applying should specifically include details about their experience in ASP.NET development. - Although specific skills or knowledge weren't mentioned, an understanding of general ASP.NET development processes and troubleshooting errors is crucial. - Familiarity with .NET Core, SQL Server, and Entity Framework would be a plus. Your job will be to pinpoint the sources of these issues and resolve them. Ideally, your bid will reflect an understanding of the volatility of bug fixing, where some issues may be quick fixes while others may present more of a challenge. Please include relevant examp...
I am setting up a new business, selling Moodle courses online. I will be using EKM as my website / payments platform. I will need to automate the following 1) Customer order in EKM Trigger = new customer order. Automate the entry of key data into a Google Sheet or Excel File 2) Customer details added to Google Contacts 3) Integration with Moodle - Creating a new Moodle account (if a new customer) - Giving access to the particular Moodle course that the customer has purchased I am still in the set up phase, so can design my processes / workflow to make automation easier (i.e. this is, relatively speaking, a blank piece of paper). I am seeking an expert who is proficient in Zapier automation. My project revolves around streamlining the user enrollment process. Project brief: -...
I'm seeking an efficient freelancer who has a keen eye for detail to perform an online data entry task. Precision and speed are crucial aspects of this project as it involves sourcing and inputting textual information from online sources. Key Responsibilities: - Copy textual information from designated online sources - Accurately paste the gathered information i...Responsibilities: - Copy textual information from designated online sources - Accurately paste the gathered information into the specified format Ideal Skills: - Proficient in data entry - Attention to detail - Excellent web navigation skills - Good command over the English language for understanding and interpreting textual data Experience in the field of online data entry is a plus. A fast internet connection is...
As a booming brand on Instagram, Facebook a...compelling Meta ads and formulating innovative strategies. *Key Areas of Focus:* 1. **Strategy Development:** Demonstrated experience in creating strategies to increase engagement on social media. 2. **Meta Ads Expertise:** Proven ability in leveraging Meta ads effectively. Experience creating captivating ads that drive engagement is key. 3. **Cross-Platform Proficiency:** Ideal candidate should excel in Instagram, Facebook, and YouTube; ability to create cohesive strategies across all platforms. Our perfect fit would be someone who is a pro at researching, understanding and connecting with our audience, inciting genuine interactions to foster a deeper relationship with our brand. Think you can make this happen? Then we can't wa...
I have a simple Excel VBA macro file (attached). The file shows up an additional toolbar on my personal PC, but does not show toolbar on client's PC. NOTE: The client can still run the macro code using the button placed on the grid. I just need to know the right group policy that needs to be setup correctly.
I am seeking an experienced data entry clerk for the task of entering data offline into a Microsoft SQL Server database system. Key Tasks: - Entering large amounts of data consistently and accurately - Ensuring all offline data is represented accurately in our SQL Server system Ideal Skills and Experience: - Proven offline data entry experience; accuracy and attention to detail are crucial - Hands-on experience with Microsoft SQL Server - Knowledge of database structure and data principles - Excellent time management skills to meet deadlines. Prior experience with large databases is highly beneficial. The successful candidate should be familiar with SQL Server, familiar with offline data entry, and have a keen eye for detail.
I'm seeking a proficient Excel user who can deftly analyze my amalgamation of patient's research data. The data in question comprises of medical histories, treatment outcomes, and demographic information. Further, I need an in-depth exploration of the correlation between investigations and treatment outcomes. The ideal candidate will need to: - Process and analyze lab test results, heart rate, and temperature records. - Correlate these factors with treatment outcomes. - Extract meaningful insights from medical histories and demographic data. Experience with health-related research data is a plus. Your analytical skills, attention to detail and knowledge of Excel are paramount.
As the client, I'm seeking a skilled Excel VBA macro specialist who can create an automated system for a repetitive task in our operation. The task in question involves a data entry form consisting of Product, Quantity and Price fields that needs to be automated. As a professional with deep knowledge in Excel VBA, automation and data entry, you have: - Proven experience in crafting Excel VBA macros. - Proficiency in automating repetitive tasks. - Extensive understanding of data manipulation. - Excellent knowledge of Excel formulas and functions. Your main job will be to create a macro to automate this data entry form. This will involve auto-filling data into the respective form fields where necessary. This efficiency-generating macro should serve to eli...
I'm on the hunt for a proficient Facebook ad expert who will drive our digital agency forward on the basis of lead generation and sales. The successful candidate must: - Be knowledgeable and experienced in generating leads and sales through Facebook ad campaigns - Excel at developing and implementing ads targeted towards our tailored audience - Be proficient in designing and promoting compelling video ads Having a background in digital agencies would be highly advantageous. It's paramount for the candidate to be results-driven and have a track record of successful lead generation.
I need an Excel expert to customize specific features in my existing utility. The chosen freelancer will focus on the following: User interface modifications: I have a preference for a minimalistic design. The interface should be clean, intuitive and not cluttered for easy navigation. Formula automation: I want to automate various tasks like data validation rules, calculation automation and data sorting and filtering. You should be able to craft these tasks to improve efficiency in data administration. Data analysis enhancements: Lastly, I want to enhance the data analysis functionalities to help with strategic decision-making. The ideal person for this project should have in-depth experience with excel and particularly in building and customizing excel utiliti...
I'm seeking an experienced developer to configure my Odoo 17 SH platform with my current business email provider, Outlook, a part of Office 365 suite. Required Skills and Experience: - Proven experience with (version 17 specifically) - Experience with Office 365 (Outlook email integration) - Problem-solving abilities and diligence in execution Project Requirements: - A flawless connection between and Outlook (send and receive emails via Odoo) - Reliable syncing of emails between the two platforms Looking for a quick and efficient freelancer who has experience in troubleshooting email integration in Odoo with Office 365.
I am looking for an expedient and detail-oriented freelancer who can perform data entry tasks for my project within 1 to 2 weeks. The task will involve entering a mix of numeric and textual data accurately into an Excel spreadsheet. Requirements would include: - Proficiency in Excel for efficient data entry - Excellent attention to detail to ensure data accuracy - Ability to meet strict deadlines to complete the task within the agreed timeframe - Prior experience in data entry, specifically with mixed data types Preferred Skills: - Proficiency in Excel - Attention to detail - Time management skills - Experience with handling mixed data types This job will entail the completion of data entry requirements with attention to detail, speed, and accuracy. Please submi...
I need expert guidance to optimize and integrate our in-house applications built on Django. Our applications range from AI chatbots for consultants to excel mapping. Django has already been installed, a main APP has been created, each application is intended to run as an API. Here's where you come in: - Optimize Application Performance: Help us enhance the speed and efficiency of our apps. - Integrate with External APIs: Guide us on how to effectively link our applications with external APIs. - AI Application Development: We want to create AI apps in a more efficient manner. Your insights will be valuable. I expect freelancers applying to this project to have: - Experience: relevant experience in Django and AI application development, and API integration. To make an inf...
As someone with a keen eye for detail and a knack for keeping things organized, I’m seeking an expert freelancer who is proficient in Excel for some important data entry work. Main responsibilities: - Entering mixed type data (both numerical and text) on an Excel sheet - Ensuring accuracy and precision in data entry - Clear understanding and implementation of data verification/validation rules during the process The ideal candidate should have: - A solid 4-5 years of experience in a similar role, preferably in freelancing - Competence in Excel and general data entry tasks - Ability to work efficiently and effectively without compromising on quality Kindly submit bids with proven track record and specific previous project details. Applications without this may ...
...public_html directory. Preceding the public_html (in the / directory), there are additional system files that are essential. I currently have 1 TB of data on the server, comprising images and other files. Up until now, I've been using FTP to manually upload code changes. However, I aim to transition to using GitHub, allowing me to leverage familiar code editors and enabling automatic updates to server files upon saving. However, the issue I'm encountering is that when attempting to update the server from GitHub, it scans for changes and potentially deletes files not present on GitHub. I don't want, for instance, the images stored on the server to be included in a separate defined folder on GitHub. Essentially, I only want the source code witho...
I am on the look-out for skilled individuals who excel in the spheres of web creationn and social media marketing to join my agency. The primary goal of our agency is to increase brand awareness for diverse businesses, our target audience. Required Skills and Experience: - Expertise in web creation: Being able to create user-friendly and visually appealing websites is crucial. You should also be adept at responsive design to ensure the sites function well on varying devices. - Proficiency in social media marketing: Proven expertise in developing and executing social media strategies to boost brand visibility and engagement is needed. Familiarity with marketing analytics to monitor and adjust strategies as required would be advantageous. Past experience working with businesses and ...
...areas such as entrances, waiting areas, or near cafeterias are highly desirable. I'd greatly appreciate the help of a professional real estate expert, someone with experience or a vast network in commercial leasing, especially in hospital settings. Previous experience in finding similar leases in the food and beverage industry will be highly beneficial. I'm ready to discuss further details upon connection and look forward to finding the perfect location for my business!...
I need a diligent and efficient worker to help with data entry into an Excel sheet. The scope of work will be entering simple text entries. Requirements: * Reliable and fast typing skills * Prior experience in data entry * Ability to pay attention to details * Deliver on-time and with accuracy Application: In your application, kindly include your past work related to Excel data entry. I am interested to review your related experiences and proficiency. This assignment could lead to an ongoing partnership if your work is of high quality. Thank you in advance for your interest in this project.
I am in need of a seasoned professional for my database migration project. My existing database resides on SQL Server 2022 and I am aiming to migrate it to Oracle 19c. - The size of my SQL Server database is small, amounting to under 1 GB, but there are around 450 procedures and functions which have to be migrated - Experience with handling similar sized databases and an in-depth understanding of SQL Server 2022 and Oracle 19c is a must. - Proficiency in SQL and database migrations are critical, along with a problem-solving attitude. - The freelancer must ensure smooth transition with no data loss and optimal functionality post migration. - An established process, clear communication and deadline adherence are necessary. This is a challeng...
I'm looking for a detail-oriented professional capable of typing data from a variety of sources, including online databases and software outputs, into Excel. The objective is to conduct data analysis. Though the typical size of each data entry has not been specified, a flexible approach to handle varying volumes of data will be beneficial. Ideal Skills: - Strong data entry skills - Proficient in Excel - Strong understanding of data analysis - Capable of adapting to varying data volumes - Experience with online databases and different software outputs.
Full details will be provided once an NDA is signed Requirements Familiar with SCADA, industrial control systems Knowledgeable with the following MQTT Mosquitto MQTT broker SQL mySql PHP Phyton scripting Web server
PHP script needs to be setup for SSO. After successful login the users email and a random string needs to be entered into a database then the user should be redirected to another site with email and random string passed with the url.
I am seeking a proficient freelancer with solid Excel skills who can help me populate my Excel sheets. While no specific type of data is mentioned, good typing skills and attention to detail will be beneficial due to the nature of the project. The work would require timely and accurate typing of any kind of information whether it's text, numbers, or dates into Excel sheets. Since no further specific details were provided, showing an array of competencies, from past experience to detailed project proposals, in your application would set you apart. Ultimately, the main intent here is to organize information effectively without a specific analytical or reporting goal in mind.
we are looking for a senior PHP developer with a minimum of 15 years of experience Skills and Experience MUST HAVE: - 15-20+ years of PHP development experience. - Proficient in Laravel framework. - Experience SQL Injection prevention/fixing - Finding and Securing any loop holes in the system - implementing new features , for enhancement of the platform, - **must be an independent developer, not an agency! - must be able to work on github - proficient in converting figma design to html/bootstrap - lastly making sure platform is mobile responsive Must have experience in social media or multi-user platform, chat system, ecommerce platform Must be knowleadble in updating designs as well when needed.u ar ******* DO NOT BID if you are an agency, if you are a marketing person or proje...
I'm looking for a proficient freelancer who can design and implement customised, interactive charts, graphs on a Superset dashboard. Here's more about what I need: - Creation of bar a...interactive charts, graphs on a Superset dashboard. Here's more about what I need: - Creation of bar and line charts primarily. Your creative judgment in presenting information would be valued. - The ability to connect to a MySQL database from the dashboard is essential. - I expect you to have strong SQL skills, to accurately translate data into valuable, visual insights. Ideal skills and experience include: - In-depth knowledge of chart creation in Apache Superset - Sound experience with SQL operations and MySQL databases - Ability to interpret data and present it vis...
I am urgently in need of a technician capable of setting up Sylius on our Linux server. The task needs to be expedited and experts with a proven track-record in similar projects will be ideally suited. Requirements: - Proficient in Sylius installation - Comprehensive understanding of Linux server operations - Ability to work quickly and meet deadlines The successful candidate will be well versed in managing servers with quick response times and high efficiency, particularly on a Windows platform. Please only bid if you can complete the project immediately.
I need a proficient developer to set up an ICE (STUN / TURN) server and a signaling server on my VPS. Key tasks include: - Enable real-time communication - Improve server performance - Enhance video call quality Features required: - Establish peer-to-peer connections - NAT traversal - Media relay Programming languages preferred: - Python - Java - Node.js Ideal candidate should have robust knowledge of real-time communication systems and good hands-on experience with server setup. Knowledge of network traversal using STUN/TURN server would be an add-on. In addition, familiarity with Python, Java, and Node.js is also highly desirable.
I need a professional who is skilled in Excel data analysis. The project revolves around typing text data from an Excel sheet for the purpose of analyzing it. Here’s what you have to do: - The data to be typed is text data. - The data needs to be in tabular format. - You should be experienced in typing and data analysis. The ideal freelancer should know Excel inside out, be highly efficient in data typing, and have a strong track record in data analysis. Being detail-oriented and having strong organizational skills will be a plus.
I have a .XML file but I want this information in .SQL. So that means that it should be make fit for my website. I want a program that takes all the information and translates them to a .sql format
I am on the search for a capable PART TIME virtual assistant to manage tasks for my small website company. The successfu...primarily through email communication. The following set of responsibilities are expected: - Conducting efficient email management. - Effectively managing calendar schedules. - Carrying out regular data entry tasks. Primarily, the assistant will be in charge of: - Scheduling essential meetings. - Assigning tasks and deadlines. - Keeping track of progress and deliverables. Ideal candidates should excel in project management, have strong attention to detail, be adept at multitasking, and possess excellent interpersonal and written communication skills. Previous experience in a similar role or in the midst of a team would be highly valued. Looking forward to ...
...) Login, logout, roles (ACL if available in build) 2.) Users section with list, add, edit, delete, active and inactive user. Use ajex to check duplicate user email while adding and updating user. 3.) Categories and sub-categories 4.) Blogs (List, add, edit, delete, active and inactive), Meta title, Meta keywords, Meta description 5.) Page Manager 6.) Contact us list (With email) 8.) Export an excel having blog title, number of views, date created, user name columns and in last total of columns. Front-end: 1.) Landing page showing featured blogs and having menu of categories and sub-categories. 2.) Categories list page showing number of sub-categories of that category with categories. Sub category wies page showing number of blogs in that sub category. 3.) Blog list page (Cate...
Maintenance: AWS Restful API Server Experience AND PHP Laravel Backend Restful API Expert AWS Requirements: - Create/Configure a new instance for a PHP and DB RESTFUL instance. The instance must be capable of 60 simultaneous Restful API server connections. Each Restful connection must support up to 60 seconds of single-call data transfer. The largest PHP Restful API call data transfer is up to 4 MB with an average of. Document the steps of creating and configuring this instance so that a Program Manager role can replicate it. Note: This work is to duplicate the Production Server on another AWS account. We need to create a Dev Server for mobile app development and understand the Production Server. We also need to configure a DB with...
...kinds of expenses for my business. This should include: - An understanding of how to categorize expenses into staff salaries, subbie payments, materials, and individual staff hours on a daily basis. - The ability to record relevant information for each expense entry, such as the date, description, amount, payment method, as well as individual employee details including dates and times. - Advanced excel skills and experience in financial data management will be ideal for this task. You will be building a tool that will be central to my business's financial tracking, so an attention to detail and understanding of financial data is key. - Experience in creating similar tracking spreadsheets will be highly valued. Please include details of similar projects in your proposal. A p...
I'm in urgent need of a native Hebrew speaking freelance for a voiceover role for an advertisement. The tone and style I'm after is friendly. Idea...for a voiceover role for an advertisement. The tone and style I'm after is friendly. Ideal Skill Set: - Proficient in Hebrew language with clear pronunciation and eloquence. - Experience with recording advertisement voiceovers. - Able to convey the right amount of friendliness in their delivery. Your task will be to deliver a friendly, interpersonal voiceover that facilitates the viewers' connection with the advertised product. Please ensure prior experience with voiceover projects, particularly in the advertisement sector, is well elaborated in your proposal. Thank you for your interest, and I look forward to...
I am in need of a proficient web developer to build an intricate platform specifically designed to connect qualified doctors and nurses to healthcare facilities in Australia. The platform needs to be user-friendly, secure, and efficient with minimalistic design. Key Features Required: - User profiles for doctors and nurses, including an easy to navigate employment search and application process for healthcare facilities. - User profiles for healthcare facilities to post job vacancies and search for suitable candidates. - A streamlined communication system between the healthcare facilities and healthcare professionals. Skills & Experience Needed: - Previous experience in building professional networking platforms is a huge plus - Strong UI/UX design skills - Proven experience with s...
I need virtual assistant, easy work just copy paste. More discusse with freelance chat...
...charges in bid for this project For this project, I'm looking for a talented programmer who is highly-experienced in working with MySQL and Excel VBA. Your task will be to create a MySQL table with 3 columns. This table will be used in conjunction with Excel VBA to import data. Here are some specifics about the project: - The Excel sheet contains similar data types in a single sheet. - The data type is primarily text strings. - We need a VBA process to export these Excel data strings into our newly created MySQL table. Ideal Skills and Experience: - Expert knowledge in MySQL and Excel VBA. - Proven experience in data import/export between Excel and MySQL. - Detail-oriented and accurate in data handling. - Focused on meeting project ...
I'm looking to build an innovative robot capable of performing a domino show. This robot should be able to operate effectively and efficiently on flat indoor floors. **K...4cm x 2.7cm x 0.7cm - The vehicle must be fully autonomous, with no manual intervention allowed during the tile placement and triggering process. - Commercial sensors that interface via standard protocols such as I2C, SPI, or RS232 may be used for navigation and control. - No loose wires are permitted, we have to use pcb for all the connections (exceptions are there like motor to motor driver connection, battery to pcb connections,etc.) **Final Deliverables:** - A fully functional autonomous vehicle that meets the project specifications. I need this work done in 25-30 days. You can freely message me for f...
I'm seeking a skilled Python programmer to develop a software module that can retrieve and process data from an Excel file. This bespoke software needs to display the data like a railway station scroller, strictly text-based. Key functionalities required include: * Picking data: The tool should extract data from the Excel file and output each row sequentially. * Sorting: While the display should be row by row, the order should be according to a certain criterion, instead of the original Excel sequence. Ideal Python programmer would bring: * Proficiency in Python programming, particularly in handling excel files and data sorting. * Previous experience or knowledge of creating text-based scrollers would be a plus. * Understanding of data presentation and...