Data warehouse in dbmsprojekty

Zlecę Poprawienie wyświetlania listy produktów ORAZ napisania dokumentacji zmian ( dla ułatwienia przyszłej pracy chcę mieć dokumentację ) Przy liście produktów oraz GRID chcę żeby wyświetlały się wybrane prze...utworzy plik tekstowy (dokumantację zmian) w którym są wskazane pliki i fragmenty kodu który został wklejony bądź zmodyfikowany Chodzi o to - aby na naszej stronie wyświetlały się cechy tak jak na stronie ( np rodzaj : zamiennik wydajność 300 str ) Klasycznie w szablonie warehouse tego nie ma Twórca szblonu warehouse przesłał wskazówki ( może się przydadzą) - mogę je podesłac przed lub po przyjęciu zlecenia Możliwa szersza współpraca

Szukam systemu magazynowego oraz do śledzenia zakupów i sprzedaży produktów. I am looking for a warehouse system to track purchases and sales of products.

...Inne modyfikacje które mogą wyniknąć w trakcie konsultacji. Jesteśmy w stanie dobrze zapłacić ale wymagamy też dobrze wykonanej pracy, profesjonalnego podejścia, komunikatywności, gwarancji działania i supportu. We are looking for a contractor who will create a professional and extensive online store with full integration into Baselinker. The most important warehouse of the store is to be the Baselinker warehouse, it is the truth in the system, products, information about them, photos and parameters are to be downloaded from it, and orders from the store are to be sent to it. The store itself must be modular, something similar to popular CMSs such as WordPress or Prestashop for self-configuration, it can also be a properly modified and secured ready CMS i...

I need somebody who integrate xlm file from warehouse to my shop. I have a documentation. Let me price or call me 0048 721 264 118 Potrzebuję kogoś kto zintegruje plik xml z hurtowni do mojego sklepu Posiadam dokumentacje Zaproponuj cenę lub zadzwoń [REMOVED BY FREELANCER.COM ADMIN]

Instalacja i konfiguracja podstawowych funkcjonalności sklepu, płatności, kurier na platformie shopify. Połączenie platformy sprzedażowej z systemem zarządzania magazynem my warehouse.

Wykonanie researchu dostępnych na rynku systemów klasy WMS (Warehouse Management System) oraz zaprojektowanie makiet UX dla aplikacji WEB (preferowane narzędzie Axure). Podstawowe zagadnienia WMS: 1. Obsługa danych towarów (tworzenie, zarządzanie, edycja). 2. Obsługa danych magazynu (projektowanie struktury, stref, miejsc składowania, etykietowanie). 3. Proces przyjęcia towarów. 4. Proces wydania towarów. 5. Proces przesunięcia magazynowe. 6. Proces inwentaryzacji. Prace nie powinny trwać łącznie dłużej niż 6-10 dni, a wyniki doprowadzone do gotowości w 2-3 iteracjach.

Poszukuję do okresowej współpracy programisty znającego dobrze Java Stansard Edition z ukierunkowaniem na Swing oraz znajomością SQL/Baz danych/PostgreSQL. Znajomosc EJB nie jest konieczna. Zadania: - tworzenie prostych GUI w swingu wedlug istniejacego projektu - sporadyczne modyfikacje struktury bazy - tworzenie zapytan sql, mile widziana znajomość PostgreSQL albo innego DBMS Celem tego ogloszenia jest stworzenie grona wspolpracownikow do rozwijania istniejacej aplikacji, wiec prosze o kontakt na priv jesli ktos jest zainteresowany. Konkretne stawki beda omawiane przy konkretnych zleceniach. Pozdrawiam

* Znajomość oraz co najmniej 3-letnie doświadczenie w pracy z bazami danych Oracle 10g lub nowszej wersji * Doskonałe zdolności zarządzania dokumentacją i wiedzą * Doświadczenie w pracy z technologiami hurtowni danych (Data Warehousing), w szczególności optymalizacja, tuning i kontrola procesów ETL oraz utrzymanie w środowisku produkcyjnym * Znajomość Business Objects * Doświadczenie w określaniu koncepcyjnych i fizycznych modeli danych * Doświadczenie w zakresie analiz biznesowych i gromadzenia wymagań * Znajomość Oracle Warehouse Builder

* Znajomość oraz co najmniej 3-letnie doświadczenie w pracy z bazami danych Oracle 10g lub nowszej wersji * Doskonałe zdolności zarządzania dokumentacją i wiedzą * Doświadczenie w pracy z technologiami hurtowni danych (Data Warehousing), w szczególności optymalizacja, tuning i kontrola procesów ETL oraz utrzymanie w środowisku produkcyjnym * Znajomość Business Objects * Doświadczenie w określaniu koncepcyjnych i fizycznych modeli danych * Doświadczenie w zakresie analiz biznesowych i gromadzenia wymagań * Znajomość Oracle Warehouse Builder

* Znajomość oraz co najmniej 3-letnie doświadczenie w pracy z bazami danych Oracle 10g lub nowszej wersji * Doskonałe zdolności zarządzania dokumentacją i wiedzą * Doświadczenie w pracy z technologiami hurtowni danych (Data Warehousing), w szczególności optymalizacja, tuning i kontrola procesów ETL oraz utrzymanie w środowisku produkcyjnym * Znajomość Business Objects * Doświadczenie w określaniu koncepcyjnych i fizycznych modeli danych * Doświadczenie w zakresie analiz biznesowych i gromadzenia wymagań * Znajomość Oracle Warehouse Builder

Opis projektu: Aplikacja ma służyć sprzedawcom pracującym w sklepie , kierownictwu sklepu oraz klientom. Powinna być ona zrealizowana: Stworzenie modelu koncepcyjnego bazy danych (encje, relacje) w środowisku PowerDesigner 9.0 Normalizacja bazy danych DBMS Sybase SQL Anywhere 8.0 i stworzenie modelu fizycznego. Wygenerowanie kodu SQL do stworzenia tabel bazy danych. Utworzenie bazy danych w Sybase SQL Anywhere 8.0 i wypełnienie jej testową informacją. Stworzenie odpowiednich zapytań SQL do bazy danych na potrzeby aplikacji. Opis modelu konceptualnego Opis modelu fizycznego Baza powinna zawierać nie mniej niż 5 tabel, np.: ZAMÓWIENIA KLIENCI PRACOWNICY TOWAR MUZYCY lokalna aplikacja bazodanowa - Java internetowa aplikacja bazodanowa - przy pomocy t...

...odpowiedzialna za realizację funkcjonalności biznesowej aplikacji oraz za generowanie dokumentów dynamicznych XHTML przesyłanych zwrotnie do warstwy prezentacji PL, czyli do klienta aplikacji. 3. Warstwy dostępu do danych (Data Access Layer – DAL), odpowiedzialna za udostępnianie danych przechowywanych w bazie danych dla potrzeb utworzenia dokumentu dynamicznego (z danymi z bazy danych), czyli odpowiedzialna za udostępnianie danych przechowywanych w bazie danych dla potrzeb warstwy BLL oraz PL: 4. Warstwy danych (DataBase Management System– DBMS), odpowiedzialna za wykonywanie podstawowych operacji na bazie danych: SELECT, INSERT, UPDATE, DELETE. Warstwa danych jest obsługiwana przez serwer bazy danych odpowiedzialny za interpretację wyw...

Celem wyznaczonym jest zaprojektowanie, implementacja i uruchomienie aplikacji służącej do zarządzania uprawnieniami użytkowników i kontroli dostępu wg wybranego modelu DBMS i sposobu autoryzacji. MAC / Java / MySql więcej info na mail. hunterek@

Szukam osoby która jest obeznana w tym narzędziu. Chodzi o pomoc w wykonaniu zadania, polegającego na odczycie repozytorium metadanych.

Szukam osoby która wie co to jest repozytorium metadanych, potrafi je wyeksportować i przedstawić w oracle designerze oraz opisać co do czego służy.

...our company. What We Offer: Global Transportation Solutions: We provide comprehensive transportation services, including sea freight, air freight, and road freight, catering to clients worldwide. Customs Clearance: Our team specializes in handling customs clearance procedures, ensuring seamless import and export processes for our clients. Documentation Services: We offer a full suite of import/export documentation services, streamlining the paperwork required for international shipments. Customs Bonded Warehouse: Benefit from our secure customs bonded warehouse facilities, providing a convenient storage solution for your goods. Additional Value Proposition: Tailored Solutions: We understand that every client is unique, and we pride ourselves on offering customized...

I require a Warehouse Inventory Management Software to efficiently track, manage and report on our inventory. Key Features: - Real-time Inventory Tracking: This is essential for us to maintain accurate stock levels. - Reporting and Analytics: We need the software to generate insightful reports on inventory trends, stock levels, and other key metrics. User Base: There will be a limited number of users accessing the software, specifically 1-10 users. Ideal Skills and Experience: - Proficiency in developing inventory management software - Strong background in real-time tracking and reporting - Experience in creating user-friendly interfaces for non-technical users would be a huge plus

I'm looking for a civil engineer or a structural engineer to Check design a steel structure and concrete foundation for a warehouse . Key details include:

...software developer to create a program that integrates a robot and RFID reading system, primarily for automating inventory management in a warehouse setting. The successful freelancer should strongly grasp robotics, RFID technology and software development. Their responsibility will be developing a software compatible with both Windows and Linux operating systems that smoothly facilitates communication between the robot and RFID reading system. Requirements: - Expertise in robotics and RFID technology - Proficient in coding for both Windows and Linux systems - Experience in developing software for inventory management - Understanding of warehouse processes and operations Goal: The objective is to make our inventory management mor...

I've got a commercial warehouse that requires an efficient, robust photovoltaic system designed to satisfy high levels of energy consumption, more than 5000 kWh per month. I am seeking an experienced professional with: - In-depth knowledge of photovoltaic system design, especially for commercial use. - Demonstrated expertise in designing systems for high energy consumption environments. - Proven experience in integrating such systems in warehouse environments. The selected candidate should excel at: - Evaluating the energy requirements of the warehouse. - Suggesting and utilizing top-notch equipment to ensure a well-functioning, high-performance system. - Instituting measures for peak energy consumption periods, and providing a syste...

Looking for an experienced social media marketer who can skillfully utilize Facebook free ads to heighten used pallet commercial industrial warehouse racking stock offers to UK- based commercial buyers. I will forward all stock details and photo images for upload each time. • Targeted free Facebook ad campaigns

My company is A A Shipping Inc. www.aashipping.com. 26yrs old company. warehouse may need some modifications but we need aggressive marketing. We also engage in real estate NOW READ BELOW: I need help to arrange with an IT person to coordinate my social media platforms for monetization, you can consider contacting social media managers or digital marketing agencies. These professionals specialize in optimizing social media platforms to attract and engage a target audience, driving traffic and potential revenue. Additionally, they can assist in developing a monetization plan tailored to your specific goals and target audience.

I need a proficient Power Apps developer to create a canvas application for Dyna...through signature before proceding with the work - Activating an approval flow from the manager if the quote exceeds $500 in product cost - Allowing the final work to be signed by the customer, subsequently converting the quote to an invoice - Checking real-time inventory status in Dynamics However, it should also list any non-stock items in the assigned warehouse and create an order for them. This project will involve an integration with Dynamics 365 Field Service, Power Automate, SharePoint, as well as Dataverse. An ideal candidate would have a solid understanding of Power Apps, SharePoint, Dataverse, Power Automate, and Dynamics 365 Field Services. Proven experience in...

...manufacturers themselves will not have a direct role or interactive presence on the website. This setup ensures a focused and specialized user experience for our reseller clients. The ideal freelancer for this job would have strong knowledge of Magento 2, particularly in the B2B context, and experience in UI/UX design. Ideal Skills and Experience: - Proven experience in Magento 2, particularly in B2B contexts. - Strong UI/UX design background. - Familiarity with wholesale pricing functionalities. - Previous experience in creating complex user approval systems. --- **Project Requirements for Magento 2 E-commerce Development** 1. **Core Magento 2 Functionality:** Utilization of Magento 2's robust e-commerce capabilities. 2. **Product Catalog ...

I'm in need of an experienced SQL professional to assist me with data warehouse. The ideal candidate is someone who has: - Proven experience in designing data warehouses - Advanced SQL skills - Excellent understanding of data volumes and the implications for data warehousing If you are interested in this project, please provide details of your experience in similar projects. Thank you.

We need a freelancer to carry out a simple task. It is about verifying that a shipment matches against a packing list. The Freelancer must go to the factory or warehouse where the shipment is located, count the products and take photos according to a manual that we will send; stay in the factory or warehouse until the containers are filled out and take pictures of the loading process according to the manual we would provide

...customization of ERP solutions using Odoo. We offer an opportunity for hands-on practice as well as insights into developing ERP software. We are currently in need of motivated freshers and interns to assist in developing ERP services. This focuses on Inventory management, Financial accounting and Human resources management and many more modules. Ideal candidates should have the tenacity to learn, innovate, and work well in a team setting. Key Responsibilities: Familiarity with Python programming language is advantageous. • Basic understanding of web development technologies such as HTML, CSS, and JavaScript. • Strong knowledge on postgreSQL DBMS • Strong analytical and problem-solving skills. • Excellent communication and teamwork abi...

I'm urgently in need of a skilled professional who can swiftly deploy a database server for me. Key Responsibilities: - Establishing a server primarily intended for databases - Choosing the suitable database management system (DBMS) Ideal Competencies: - Extensive experience with multiple DBMSs as I'm not yet decided on which one to use - Ability to work under pressure and deliver swiftly since the project is urgent - Prior experience with server deployments will be highly advantageous.

I am in need of a skilled and experienced architect or 3D artist who can create high-quality, photorealistic renderings for a commercial project. Specifically, I need exterior visualization renderings that will help with the planning and design of the building. Key Project Details: - The renderings are primarily for visualization and planning purposes. - The building is commercial in nature, so prior experience in designing commercial structures is highly desirable. - The project will specifically involve creating exterior renderings only. Ideal Skills and Experience: - Proficiency in architectural visualization software (e.g., SketchUp, 3ds Max, Rhino, etc.) - Experience in commercial building design - Strong portfolio of previous architectural ren...

I am in need of a talented illustrator to bring a series illustrations to life for my website. - **Timeline**: This is an urgent project, so I need these illustrations completed as soon as possible. Loom Video Describing what I want done- Illustrations- 1. Above the fold- Agouti proud next to agouti van 2. Home Standby Generators- Need ALL agoutis in an agouti uniform. Id love to have the generator on the side of the house and the agouti standing with a customer (or husband and wife) who are obviously happy and the agouti is happy as well. 3. Commercial Generator on Services- The agouti needs to have an agouti uniform on with our colors. Needs to have the cayman islands in the background

...subscription options once ready. This would all be done under a shopify store which has a warehouse template purchased if it was needed for use. Key Requirements: - Integration with TCG player store for inventory tracking. - Connection to our Etsy store and our own stock for a complete view of our inventory across platforms. - A user-friendly interface for customers to browse and purchase our products. - A workout framework for tiered subscriptions, allowing us to reward faithful customers with exclusive content and offers. Ideal Candidate: - Experienced in web development for e-commerce, preferably within the gaming industry. - Familiarity with subscription-based business models. - Strong experience in integrating multiple platforms (specifically Etsy and TCG pl...

...and we're in search of a skilled professional with expertise in data warehousing in Oil and Gas sector. We are going to use MongoDB. Key Requirements: - Data Integration: We need someone who can seamlessly blend data from various sources, ensuring accuracy and consistency. - Data Modeling: The ideal candidate should have a deep understanding of how to organize data in a way that supports business needs and decision-making. - ETL Processes: The selected freelancer will be responsible for the extraction, transformation, and loading of data into our warehouse. We are working with a medium-sized dataset (1-10 terabytes), so we need someone who is not only experienced in data warehousing but al...

As a customer service executive for this project, you'll be directly engaging with 3 key aspects of customer care: - Answering phone calls - Responding to customer emails - Assisting with customer complaints In addition, there's a crucial onsite requirement. You will be required to visit our warehouse in order to address delayed shipments, a current logistical issue we're facing which affects our service quality. This role requires strong problem-solving skills, a proactive attitude, and hands-on experience in logistics resolution.

I'm in need of a highly skilled and creative logo designer to create an impactful logo for my business. The primary purpose of the logo is to help with brand identification. Key points to consider: - The logo should be professional, sleek, minimalistic and easily recognizable - It should appeal to a corporate audience and reflect a sense of discipline & credibility - Logo should resemble or relate to a warehouse with a hinge of exclusivity of the company name - I am open to suggestions concerning color but we should avoid any bright or cartoonish tones - A strong portfolio of previous professional logo designs is a must. Your expertise in branding and logo design will be vital to the successful realization of this project. I look forward to seeing your pro...

We are seeking an experienced Project Manager to lead ＂Project Pyramid" to implement a data warehouse for International. The successful candidate will play a pivotal role in driving this project forward, focusing on the P&L and collaborating closely with IT, data analytics, and FP&A teams across multiple regions.

...app focused on warehouse stock tracking. Here’s the overview of the core functionality the app should have: - **Stock Level Updates**: The app should encompass a real-time updated inventory that reflects the current stock levels. I'm interested in exploring the possibility of updates via manual input and barcode scanning. Ideal candidate should have: - Strong experience in Android app development - Knowledge in inventory management or similar apps - Familiarity with using barcode scanning for inventory tracking(Barcode scanning could be a future option, not interested to have it in the early version, could be integrated at later stages off the app) A successful collaboration could lead to more work in the future. Please include pa...

I'm looking for a skilled data engineer to help me with the OMOP ETL process. Your main responsibilities will be: - Extracting and transforming data: You'll be working with me to extract data from a data warehouse and transform it into the OMOP CDM. - Loading data into a database: After transforming the data, it will need to be loaded into a PostgreSQL database. Experience with ETL processes and PostgreSQL is critical. You should also be familiar with data validation checks, as we need basic data type and range checks applied during this project. You must have experience loading data into the OMOP CDM.

I am seeking a professional who can elegantly present a site plan for a commercial construction project. The primary purpose of this presentation is to obtain necessary approvals. The key requirement for the presentation is highlighting the building layout prominently. Budget is $100 USD. Ideal candidates will have: - Proven experience in creating site layout presentations - Understanding of commercial infrastructure (Warehouse Operation) - Strong communication and presentation skills. - Attention to detail. Can present the plan accurately and neatly from basic inputs. We have a marked up PDF and some JPG files. Need to enhance them / recreate them into a presentation level PDF and Powerpoint.

I'm seeking a dedicated person who knows data engineering and data analysis with special expertise in AWS services. Your primary responsibilities will include: - Data cleaning and preprocessing: Handling a variety of data structures, from unstructured to semi-structured and structured - Data modeling and warehousing: Proficiency in using AWS S3, Athena, Glue, and other analytical services - Data analysis and visualization: Delivering insights through efficient data analysis and visualization techniques Ideal candidates for this role should have: - Experience with MS Fabric, specifically working with Lakehouses, Warehouse, SQL Endpoint, Data Flows, and Notebook - Proficiency with SQL Server, VBA, and SAS - Pr...

Project Description: We are seeking a talented video producer to create an engaging and informative video that explains the social responsibility and business model of CEMCUI. The video should be produced in both English and Spanish versions. Objectives: Highlight Social Responsibility: The video should emphasize our commitment to social responsibility through our workshops and partnerships with artisans. Explain Our Business Model: Detail how CEMCUI connects customers with artisans by designing custom products that go beyond commodity items. Explain the entire process including quality inspection, logistics, and distribution. Visual Branding: Incorporate our business brand logos and color scheme (#382f2d, #dad6ca, #cdcb5f, #ffbe72, #f17ca0, #94c7cf, #ffa168, and #e8b2d3) to maint...

I'm in need of a skilled developer to build a detailed warehouse management software, proficient in creating feature-rich applications. This project includes aspects such as inventory management, SKU linking and comprehensive sales reports. Features: - Inventory management: This involves tracking item quantities, receiving and restocking items. - Setting up alerts for low stock, and providing daily updates on stock in and out. - SKU linking: The ability to link SKUs effectively to a master SKU. - Generating detailed sales reports, including merging data from all sales channels, which must be compatible with uploading to Tally. Ideal freelancer would have previous experience in Python-based application development, and a solid understanding o...

...competitively. - Acquiring new clients, particularly from logistics, warehousing, transportation companies, and other entities in need of drivers or warehouse staff. The ideal candidate should have: - Proven experience in sales and business development, ideally within the logistics sector. - Strong knowledge of the UK's logistics, warehousing, and transportation sectors. - Exceptional communication and negotiation skills, as well as the ability to close sales. - A track record of utilizing cold calling, prospecting, and online platforms for lead generation. - Creativity and proactivity in identifying new client acquisition opportunities. Your role will be crucial in expanding our client base and positioning our recruitment services successfully...

...design and build a basic data warehouse utilizing MS SQL Server's various services such as SSIS, SSAS, and SSRS. This includes analyzing and reporting on large sets of data while integrating and transforming data from different sources. Key specific requirements include: - Creating a basic data warehouse structure. This should involve a few tables and relationships. - Using SSIS (Integration Services) for transferring and integrating data. - Implementing SSAS (Analysis Services) for performing advanced analytics. - Utilizing SSRS (Reporting Services) for generating comprehensive reports. The ideal freelancer for this gig should have: - Proficiency in MS SQL Server, specifically in SSIS, SSAS, and SSRS. - Experience ...

I am seeking a professional with proficiency in MS SQL Server’s SSIS (Integration Services), SSAS (Analysis Services), and SSRS (Reporting Services) to create a basic level, sample case for using data warehousing. Specific Goals: - Develop a data warehouse for analyzing business data. - The case should familiarize the users with the concept, rather than providing an advanced level of expertise. In SSIS Integration section, the following concepts are to be included: - Data Extraction - Data Transformation - Data Loading The ideal candidate will have a solid understanding of data warehousing and extensive experience with MS SQL Server’s services. A knack for simplifying complex information and a background...

We need a freelancer to carry out a simple task. It is about verifying that a shipment matches against a packing list. The Freelancer must go to the factory or warehouse where the shipment is located, count the products and take photos according to a manual that we will send; stay in the factory or warehouse until the containers are filled out and take pictures of the loading process according to the manual we would provide

I'm looking forward to having a 3-D rendering of a warehouse, focusing on interior layout and exterior design. While the main feature of the warehouse will be for storage, an innovative design approach that fosters efficient space utilization is essential. Here's what I'm looking for: - Creativity in presenting the interior layout based on rough ideas. - Sophisticated 3-D representation of exterior design. - A sleek, professional warehouse design that prioritizes functionality. Skills required include proficiency in 3-D designing, with an emphasis on architectural designs, as well as an ability to creatively transpose rough ideas into well-thought-out designs.

...my business. This dashboard will need to integrate data from our MySQL orders and stocks, and it will determine the shipment location based on certain criteria. Key Requirements: - Develop a live dashboard: The end goal is to have a dynamic, real-time dashboard that displays relevant information from our orders and stocks. - Implement shipment logic: The dashboard needs to determine the shipment location based on the stock availability. If an item is not in stock at either of our regional warehouses (Belmont and Richmond), the order should be fulfilled from our India warehouse. Ideal Candidate: - Proficient in Power BI: You should have a solid understanding of Power BI and previous experience in creating live dashboards. - Skilled in SQL: K...

As a client in need of a video creator/editor, I'm looking to collaborate with a talented professional who can develop an engaging promotional video for my warehouse management application. Key requirements include: - The video should last more than 2 minutes, ensuring a comprehensive overview of the product. - I envision a live-action video with screen recordings. This style is aimed at capturing the attention of warehouse managers in particular, and it should clearly showcase the interface and functionality of the application. - Experience in creating similar videos, especially in software or app-related spaces, is highly preferred. Understanding of the target audience and the ability to effectively communicate the benefits of the applicat...

I'm in need of a webpage for my small (250m2) warehouse rental business. The primary role of this webpage will be advertising our warehouse spaces. Small rental business consists: * one larger warehouse rental are * smaller warehouse units * outdoor area rental * car tyre "hotel" for winter/summer season * motorcycle winter "hotel" for winter season Webpage would have 7-9 sites. I would prefer using Wordpress and some popular builder. List with Details and Specifications: Our available warehouse spaces need to be showcased in a detailed and informative manner. This requires a structured listing layout that presents specifications such as size, location, accessibility, and other relevant details. If you have expe...

I am looking for a prep center Is a small warehouse that customers send me products I scan the barcode of the product and register for the customer. Also the generato a invoice for each customer depending of the preparation of the product . I am doing a prep center warehouse an I need a software that I can .register customer .Each customer is going to send multiple product . Depends on the product needs different preparation (price) . Register each product in the customer portal whit the product barcode including picture of the product . Location in the warehouse for the product . Invoice Generator for each customer . Also how much the business is generated monthly, yealy. I give the details price of all the preparation Key requirements: - E-comme...