Transact sql import excel jobs

I'm in need of a SketchUp expert to complete a basic context model. This project is primarily for architectural visualization, so the focus is on creating approximate representation of the basic shapes and structures, using a google maps 3d import as a guide. I've set up the file, so it just requires the rest of the buildings to be modelled. Ideal Skills and Experience: - Proficiency with SketchUp. - Previous experience in architectural visualization projects. - Strong understanding of basic building structures. - A keen eye for detail and design aesthetics.

Please Sign Up or Login to see details.

hello everyone we have a CRM which allows us to manage our customers, a CRM entirely coded by us in html php and javascript. we have started to integrate a function which allows us to insert customers into our CRM using an excel file, but I don't have the time to finish that. It must be ready before the end of the day, today! mandatory deadline. if we are satisfied we will entrust you with many other missions on this brand new CRM

I am in need of an individual with skills to assist with the migration of data from FS5 and .IDX files. My project involves: - files in FS5 or .IDXfiles that need to be migrated into a usable, readable CSV format that can be edited a - Handling text data specifically, and ensuring its integrity is maintained throughout the conversion. Potential freelancers need to have: - Knowledge of FS5 /.idx files. - Strong knowledge and understanding of text data management. - Excellent problem-solving aptitude, as the difficulty level can vary across files. I look forward to a thorough demonstration of your ability.

Apply VBA code in new Excel file

As a vendor, I have three excel sheets containing product numbers and corresponding data. Both sheets are error-free and completely filled in, but the second sheet has its entries in a mixed order. I need a freelancer who is adept in working with Excel to match the data in the sheets based on product I.D number using the product numbers and or product name (TRS Direct Sheet) to match the size dimensions in the other sheets as highlighted via colored columns (must match colors) Sheet format cannot be moved or changed or altered in the cells already published on the 2 sheets as listed only the DATA MASTA it effects the upload process. area highlight pink no information or changes to be made or added please scroll through to observe existing pink cells. Here's a detailed b...

Looking for a skilled developer to fill in for a team member on vacation. The ideal candidate should have: - Strong experience in C# and ASP.net - Good knowledge of SQL Server The role involves: - Troubleshooting and fixing bugs in our existing applications - Enhancing and adding new features to our applications The projected timeframe for this position is less than a month, but the role could potentially be extended. You're being hired for not only your skills but also your problem-solving abilities - an essential trait when dealing with application bugs/issues. The key objectives for this role are: - Improving the performance and stability of our applications - Enhancing the user experience and application functionality Note: We skipped the outcome due to the job's shor...

I'm in need of an adept hydraulic or fluids engineer to create a PVC pipe gold trap tailored specifically for high water flow. Key components for this project would be: - Efficiency: The design should excel in gold particle collection, regardless of particle size - from less than 0.5mm to 2mm. - Adaptability: The trap will be utilized in a sandy soil environment. - Durability: The trap should possess a high erosion resistance to exceed in everyday wear and tear in mining operations. Your expertise in fluid mechanics, material selection and applying scientific principles to practical application would make you an excellent fit for the task. An understanding of the gold mining process would be a plus but isn't necessary. I'm looking forward to discussing your ideas an...

I'm requiring aid in managing and optimizing my SQL database. This database is currently handling a range of information including product details, customer details, and order details. Key Tasks: - Improve the existing SQL database - Ensure efficient handling of product, customer, and order data Ideal experience and skills: - Proficiency in SQL queries - Experience in database management - Familiarity with inventory management processes, specifically handling a limited range of 20 different products. This project will require a keen attention to detail and a comprehensive understanding of SQL database manipulation.

I'm currently facing potential malware attacks causing unexpected slowdowns, particularly affecting my website load times. Hence, I'm i...security professional who can identify and rectify issues within my server files. Key Responsibilities: - Investigate the root cause for the slowdown of the website load times - Pinpoint potential malware in server files - Advance and fortify the security system to prevent future occurrences Ideal Skills: - Proficiency in cybersecurity - Solid understanding of server operations, particularly SQL - Experience in malware detection and prevention Your task: Use your expertise to bring back operational efficiency and bolster my domains server's security. If you can catch the malware predator and restore the peace of my server wor...

As your client, I'm looking for a specialist having a proficient knowledge of Microsoft Excel to achieve a simple data manipulation project. The task involves predictive analysis of data, heavily leveraging date and time functions. Key Responsibilities: - Manipulating data using simple Excel functions. - Predictive analysis using Excel based on the manipulated data. Ideal Candidate: - Sufficient proficiency in Microsoft Excel, with specialised expertise in date and time functions. - Strong attention to detail and accuracy in data entry and analysis. - Superior skills in organising and ability to handle increasing complexity when required.

I am seeking a skilled freelancer to manage my MLS listings. Your responsibilities will include: P...projects with this developer (and of course later we will be providing details of other developer websites with their own different projects) it's important to understand that each developer will display the information in a different way so you need to know what information to look for. That's the main purpose of this first exercise….. Before bidding please look at these 2 videos showing the import of the first project “The Bliss Village”…. We have got just less than 5 weeks to get around 200 developments done.

I'm seeking for an expert in Excel VBA with strong debugging and troubleshooting skills along with the ability to optimize the performance of existing macros. The key responsibilities would be: - Debugging and troubleshooting my created Excel VBA Macros - Enhancing the efficiency and performance of these Macros - Inclusion of new features as required - And finally be able to explain the code for each module. What I'd really value is a clear and concise explanation of what each module does, and this requirement would be fulfilled best by providing detailed comments in the code. This project is perfect for anyone with a deep understanding of Excel VBA, Macro functionality, and a passion for clear and enlightening code documentation.

I'm seeking an expert in PrestaShop and data migration who can efficiently perform a full data import from my current PrestaShop 1.7.5 site to the new version, 1.7.8. Specific Requirements: - Absolutly all data should be transferred. - The primary focus will be on migrating 'Customer Data' and 'Order history'. Therefore, these two areas have must be accurately and efficiently imported without loss. There are around 40 items to be imported, 900 customers. The new graphics will need to be set as per my instructions for the "warehouse" theme, The development web space for the new site is already ready with the new wharehouse theme already installed. Ideal Skills: - Proven experience with PrestaShop is a must, particularly with data migrati...

I'm in need of an expert who can proficiently convert a 12-page Excel document into an editable PDF while maintaining its original layout. Key requirements: - Preserve the current layout of the Excel document in the converted PDF. - Ensure the PDF is editable not a read-only. - Important: There are links and media embedded in the Excel document that must remain functional in the PDF. Ideal skills to have: - Strong experience with Excel and PDF conversions. - Attention to details especially concerning layout preservation and media functionality. - Excellent communication skills to address any clarifications promptly. This project requires specific expertise, and the exact replication of the Excel layout is critical. If you feel suited for this ...

I'm seeking a SQL and snowflake expert. I have a small table in snowflake, for which I need a view to be created. The view will have some failed from the table and then some calculated fields based on the original table.  Needs to be done asap. Will share the table data and columns of the table in and excel sheet and the desired results as well for your reference.

To fill this position, I am looking for a seasoned Tableau Expert who can efficiently create a dashboard that helps in tracking and visualizing Employment Metrics. Key Project Requirements: - Connect and import data from CSV files - Visual representation of data utilizing Line charts, Bar charts, and Geographical maps - All visualizations must be designed to track Employment data pulled from a pre-existing census Ideal Experience: - Proven experience in creating interactive Tableau dashboards - Proficient in handling CSV data within Tableau - Excellent experience with line charts, bar charts, and geographical mapping - Experience in employment data analysis or HR data visualization is a distinct advantage This is a fascinating project that needs advanced skills on Tableau. I lo...

...continuously improve our data solutions Key Skills :- • Bachelor's degree in Computer Science, Information Technology, or related field. • 4-5 years of professional experience as a Data Engineer with a focus on Azure Databricks and Azure Data Factory. • Strong proficiency in SQL, Python, and/or Scala for data manipulation and scripting tasks. • Experience working with data lakes, data warehouses, and ETL processes. • Familiarity with cloud platforms (preferably Azure) and related services such as Azure Blob Storage, Azure SQL Database, etc. • Excellent problem-solving skills and attention to detail. • Effective communication and collaboration skills to work with cross-functional teams. • Azure certifications (e.g., Microsoft ...

need seo experts/developer to fix google search console/SQL index issue. we have many pages not indexed on gsc, need seo experts/developer to fix it. I'm currently facing an issue with pages on my website not being indexed and therefore not showing in Google's SEO results. It's crucial for the successful completion of this project to have these pages visible on Google again. Ideal candidates for this task should have: * Extensive experience with Google Search Console * Proven expertise in resolving indexing issues * A deep understanding of SEO best practices Please include your past work related to resolving such issues in your application. A detailed project proposal would certainly be a plus. Prompt completion is advantageous, although a precise timeline has...

I'm in need of a professional developer who can create a web-based part navigation system for my business. The site should be user-friendly and similar to a few examples I can provide for reference. Key Features: - Search Function: The website should have an easy-to-use search function that allows u...c=TOYOTA00&ssd=%24%2AKwHh1cTP4ruKk-bk467w57mtjYqU5ern5vTb6KCmlYGdmZuY3crmjKKmopOFnI3L1tzh6JKYkpyPlvTq2Kjwofbp8I_1pqb78ejkqa2nvLPK_7qwu7H26eP59ezt_PHo9-Xi4uD1pqbxvfDv9uLjkOS5t7qurKO9t5Ku9ennuuny9-Xg4Obmuqa08_C8oPHo9fXaxcqSn_f48_C4tKi-uPGZ5OaegPiQwtzfmIr3-PPwo7Sovrjx6uTshPD596ji8bfw7_ThrwAAAABNkruS%24&vid=0&cid=1&uid=29070&q= The Wire Frame and navigation will be designed by us. The PDF along with Excel files with reference and page number will be provides...

...large Telegram channel and groups. The ultimate goal is to invite these subscribers to my own channel. Key Results: - Extract or scrape customer data from specified Telegram channels or Groups. - The type of data required is mainly (phone number - user) - Extracting data from private channels or groups - Provides a complete list of extracted customers - Ensure customer data is ready to easily import into my channels for invitations Ideal Skills & Experience: - Proficiency in web scraping tools and techniques - Experience with Telegram algorithms - Experience with Telegram API or similar platforms - Proven track record in handling and managing large amounts of data - Strong communication skills to provide detailed project proposals Please ensure that your application contai...

I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing

I'm in need of a skilled developer with expertise in Yii framework to add new functionality to our existing system that serves a financial services purpose. The successful candidate will be responsible for implementing the following features: - Add menu new menu items using the language file - Bank statement mapping - Bank statement import - Bank statement transaction allocation A full specification is available for the selected candidate. Ideal skills and experience for this job include: - Proficiency in Yii framework - Strong PHP skills I look forward to your proposal for this project.

I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing

I am in need of a dedicated, smart, and detail-oriented Virtual Assistant to help me for 10-20 hours per week with specific emphasis o...detail-oriented Virtual Assistant to help me for 10-20 hours per week with specific emphasis on data entry and analysis. Key tasks will include: - Data input - Data categorizing and sorting - Providing analytical summaries of data - Exploring trends and patterns - Collaborative problem-solving based on findings The ideal candidate should have strong experience with data entry, analysis, and Microsoft Excel, along with solid administrative skills. Attention to detail, strong organizational skills, and the ability to work independently are crucial for this role. If you're versatile, motivated, and have an analytical mind, I would love to have ...

I need a skilled freelancer to convert several Excel spreadsheets into interactive PDF files, preserving the original Excel formatting. The converted PDF files should retain all functionality, including interactive components such as forms or clickable links. Ideal Skills: - Proficiency in Excel - Expertise in PDF conversion with interactive elements - Exceptional attention to detail to ensure formatting preservation Experience Required: - Extensive experience in converting Excel to interactive PDFs - Proven track record of working with similar projects from the past - Familiarity with handling complex Excel formatting.

I'm on the lookout for proficient freelancers who excel in web development, app creation, and video editing. This is a great opportunity for those who are able to deliver top-notch results efficiently and at a reasonable cost. What I'm Looking For: - Web Development: The primary focus is on creating an e-commerce website. Ideal candidates should possess a strong foundation in e-commerce website development and a keen eye for design. - App Creation: I'm seeking app developers with a proven track record. Your ability to develop seamless, user-friendly apps that deliver a great user experience is essential. - Video Editing: Skilled video editors with experience in producing high-quality, professional results. In Your Application: I'm most interested in your exper...

I am looking for a data scraper to extract information from the JazzCash agent locator list available on their website (). Key Requirements: - I need the data to be delivered in an Excel spreadsheet format. - The specific details that I require for each Jazz locator are the Name and Address, along with the Services offered. - The scraping needs to be done only once; it will not be recurring. Ideal Skills and Experience: - Proficiency in web scraping, particularly using tools like Python's Beautiful Soup or Scrapy. - Experience in extracting data from websites with dynamic content. - Strong attention to detail to ensure accurate data extraction. - Previous experience with similar data scraping projects will be an advantage. I am particularly interested

I am seeking a skilled freelancer to guide me in creating Power Automate flows that efficiently import data from a single worksheet Excel document into Dataverse. Key Tasks: - Develop a couple of Power Automate flows to import Excel data into Dataverse. - I have had many difficulties with date and lookup/choice columns not correctly importing. Ideal Candidate: - Expert knowledge and experience in Power Automate. - Proficient in Data Integration between applications. - Knowledgeable in creating approval workflows and automated notifications. - Previous experience with Excel-data integration into Dataverse. - Excellent communication skills.

...seeking a highly skilled data engineer with a strong proficiency in Apache Kafka to work on a data integration project. The main objectives of this project are: - Integrate various data sources: structured (SQL database), semi-structured (XML, JSON), and unstructured (emails, documents) - Develop a robust data flow architecture - Ensure efficient data transmission across systems The perfect freelancer for this job should possess the following characteristics: - In-depth knowledge and practical expertise with Apache Kafka - Experience with integrating diverse data sources, such as SQL databases, XML, JSON and unstructured data (emails, documents) - Proven track record of successful data integration projects Feel free to schedule a meeting using this link.

I am looking to create an Excel tool that will streamline our disbursement process. The tool needs to handle data entry automation, calculation of disbursement amounts, and generation of disbursement reports. Key Features: - Data Entry Automation: This will help us input information quickly and without errors. The tool should automate data entry to reduce human error and increase efficiency. - Calculation of Disbursement Amounts: Once the data is entered, the tool should automatically calculate the disbursement amounts based on predefined criteria. This will help us ensure that the amounts are accurate and consistent. - Generation of Disbursement Reports: After the calculations are done, the tool should be able to generate reports in a clear and user-friendly format. This will h...

...full-stack JavaScript developer to help construct a remarkable web application. While I don't necessarily have a preference for the specific platform, I'd appreciate it if the developer can provide recommendations and explain their platform choice, whether it's React.js and Node.js, or Angular.js and , or Vue.js and Django. Your role will encompass both front-end and back-end development. To excel in this job, you need to have: • A strong grasp of full-stack JavaScript development • A robust knowledge of various frameworks • Experience in building web applications • Excellent problem-solving abilities and detail-orientated approach • Strong communication skills to ensure clear discussion of the project details and progress This project...

I'm currently in need of a competent individual proficient in data entry tasks. The ideal candidate must have strong experience and skills in managing and operating data with Excel Spreadsheets. Your task revolves primarily around: - Data entry into an Excel Spreadsheet Experience with Excel Spreadsheets is a must for this project. Perfect attention to detail and accuracy are vital. Applicants should be able to work autonomously and deliver high-quality results. Please note that the type of data to be handled has not been specified; it may include text, numerical, or image data.

...enhance our customer segmentation strategies. As such, the project will require a deep understanding of customer behavior and sales patterns. - **Data Type**: The data provided for this project is structured, primarily in Excel and CSV files. Your ability to effectively manipulate and analyze this data will be crucial. Ideal Skills and Experience: - Proficiency in Azure and strong experience in running ML models on the platform - Proven track record in customer segmentation and sales data analysis - Ability to work with and manipulate structured data effectively, particularly in Excel and CSV formats I'm looking for someone with a solid understanding of sales data and a keen eye for customer segmentation. If you're confident in your ML skills and Azure proficie...

I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks

We are engaged in the bag industry import and export supplier of the company, is committed to providing customers with more cost-effective bag production services. Now we need an engineer to help us build a company promotional page, which is required to meet the aesthetics of European and American customers. If you are good at it and interested in this job, welcome to contact me and communicate the design details. Please confirm with a reply starting with Hello World.

I'm in need of a website and custom...(Django/Flask), Ruby (Ruby on Rails), or PHP (Laravel).  Database: MySQL, PostgreSQL, MongoDB, or similar.  Web server: Apache, Nginx, or equivalent. 3. Payment Gateway Integration:  Select and integrate with a payment gateway provider that meets the project requirements (e.g., Stripe, PayPal). 4. Security Measures:  Implement secure coding practices to prevent common vulnerabilities (e.g., SQL injection, XSS).  Use encryption for sensitive data storage and transmission. 5. Hosting and Deployment:  Leverage existing hosting provider of the platform supports the required technologies; otherwise recommend an alternative platform.  Set up automated deployment pipelines for continuous integration and delivery (CI/CD).

This project requires a freelancer with advanced skills in Excel. I am outsourcing tasks revolving data management. Key Aspects include: - Advanced manipulation of Excel functions - Complex calculations - Refined data analysis When applying, please focus on: - Your practical experience with similar tasks Having realized the depth of this project, it's pivotal that you have an advanced understanding of Excel. Ideally, your background should perfectly align with data management, advanced calculations, and analytical tasks. Demonstrating this through past projects and describing your specific insights gained from those experiences will be a big plus.

I have C# MVC Web App that works using SQL Server Database & using APIs at the same time. For the functions that use the database, I want to replace them with the APIs 1- Error message appear with no details, need to make the error message has Show More to display the details of the error. 2- Load Codes from APIs instead of loading from JSON file. (1 API) require updating treeview to load on demand 3- Packages Load from APIs instead of loading from DB (2 APIs) 4- SubscribedPackages Call API instead of inserting into a DB (1 API) 5- Schemes Load from APIs instead of loading from DB (1 API) 6- Uploads Call API instead of inserting into a DB (1 API) 7- Users Call API instead of inserting and reading from a DB (5 APIs) you must have C# MVC experience. ------------------...

...completion and enhancement of a CSV file for upload to Square. This extensive project requires three core competencies: meticulous data extraction from our website, proficient data entry into an Excel form, and the creation of engaging service descriptions using AI tools. The ultimate goal is to craft a CSV file that not only meets but exceeds the requirements for Square's platform, ensuring a seamless upload process. Key Responsibilities: Data Extraction and Accuracy: Initiate the project by extracting data from specific sections of our website. This data must be accurately transcribed into an Excel form, adhering closely to the required fields. Attention to detail is paramount to ensure that the information captured is both precise and aligned with our needs. Cont...

I have a Java application currently running on Java 8 that demands an urgent cert...application currently running on Java 8 that demands an urgent certificate update. The application connects with an AWS RDS instance using PostgreSQL and current requirements necessitate an upgrade to a new certificate. Upon successful import and upgrade of the new cert in the AWS environment, the change then needs to be effectively verified through a manual testing process. Skills & Experience required: • Profound understanding of and substantial experience in Java 8 • Experienced working with AWS RDS (specifically PostgreSQL) • Capable of certificate upgrade & import in AWS • Well-versed in manual testing procedures. Please, only submit a proposal if you ca...

I require an Excel specialist proficient in creating dynamic and functional spreadsheets. This project involves designing a new Excel sheet that handles both numerical and text data. You would need to: - Set up the sheet, capable of performing multiple features such as automated calculations and conditional formatting rules. - Configure simple calculations for GP indicators basing on specific cost prices. - Ensure the spreadsheet can efficiently process a mix of numeric and text data. Strong skills in Excel and data management are essential for this project. Familiarity with advanced Excel functions and an ability to provide quick, efficient solutions to data processing problems would also be very beneficial. A good understanding of GP indicators and cost pri...

I'm seeking a professional with a strong background in Excel to develop a keyword search tool for an Excel database. This tool will primarily be used for filtering data and linking to articles hosted on a network. Key Requirements: - Experience creating and managing Excel databases - Proficiency in implementing keyword search tools in Excel I would like the sheet to have a Main/Search Page and another page for the database. I want to be able to add new entries to the database section and have them be searchable on the main page. I want to be able to create new searchable keywords on the database page and have them populate and be searchable on the main page. I would like to be able to enter multiple search terms into the search box to narrow the results....

I need this to be done IMMEDIATELY! - Extract data in a specified format. - Transfer data from the price listing PDF to an Excel spreadsheet. - Input details such as SKU, Name, Description, Brand, Cost Price, Length, Width, Height, and Weight, which are highlighted in blue. - If any title or heading is not mentioned in the details provided in item #3, add it to columns U-Z. - Ensure all data is formatted correctly, with names in proper case and prices as numerical values. I'm in need of a proficient data entry freelancer to help convert a scanned image PDF to an Excel spreadsheet. Key Details: - The PDF contains less than 50 pages. - The data in the PDF is in the form of scanned images, making it crucial that the freelancer has experience in handling this ...

I am seeking a skilled freelancer to guide me in creating Power Automate flows that efficiently import data from a single worksheet Excel document into Dataverse. Key Tasks: - Develop a couple of Power Automate flows to import Excel data into Dataverse. - I have had many difficulties with date and lookup/choice columns not correctly importing. Ideal Candidate: - Expert knowledge and experience in Power Automate. - Proficient in Data Integration between applications. - Knowledgeable in creating approval workflows and automated notifications. - Previous experience with Excel-data integration into Dataverse. - Excellent communication skills.

I'm launching an import and distribution enterprise and require an impressive, eye-catching logo that captures the spirit of our new business. The logo's color scheme must include Red, White, and Blue and incorporate a "Star" symbol. Although our business focus is global, our primary target markets will be Chile, New Zealand, Australia, and China. Key Qualities To Reflect In Design: - Innovation - Reliability - Stability - Trust - Confidence Skills & Experience: - Previous experience in designing logos for startups or import/export businesses. - Strong understanding of color theory and symbolism. - Ability to effectively incorporate symbols into design. - Proficiency in contemporary design trends. - Familiarity with cultural nuances of our target mar...

I'm in need of a freelancer who can automate my Excel spreadsheet to increase efficiency and accuracy in data entry and analysis. Key Duties: - Automate data input, validation, and manipulation - Perform calculations and formulas automatically - Generate reports and summaries for the data Ideal Skills: - Proficiency in Excel - Excel input form design - Previous experience in automating data entry processes - Understanding of data manipulation

I'm seeking an experienced Google Script specialist to automate tasks and manage data for my project. Here are the specifics: Automating tasks: Your main responsibility will be to automate data import/export processes using Google Script. I need to take the data attahed to a daily email in excel format, upload this data (and historic) to a data base and then allow to consult that data from different spreadsheet in google with a query. Ideal skills and experience include: - Proficiency in Google Scripts and automation - Experience in data management - Google spreadsheet analisis reports If you have the needed expertise, I'm excited to work with you!

I'm in need of assistance for importing physical products to my WooCommerce store. The main requirements of the project are as follows: - **Product Import:** I have a feed of physical products that need to be imported into my WooCommerce store. - **Filtering:** These products should be filtered based on their category before being imported. - **Product Updates:** Once imported, the system should update product prices and stock regularly, and add any new products to the store. This process should be automated and occur every hour. I'm looking for a freelancer with the following skills: - Strong experience with WooCommerce, including product importing and updating - Proficiency in creating smart filters for product selection - Automation expertise to ensure product upda...

I'm in need of an application that prints labels from an Excel spreadsheet. The scope is to print personalized employee labels with names and respective earnings for cash payments. Key project features: • Read an Excel spreadsheet in a consistent format, with different entries for each worker's name and earnings. • Print labels with the worker's name and corresponding earning. Candidates should have: • Extensive experience in programming • Familiarity with reading data from Excel • Expertise in printing functions Just to clarify, the format of the spreadsheet will always be the same, only the contents (worker names and earnings) will differ. Please ensure the program is capable of handling this accurately. Your...