Survey ivr asterisk mysql jobs

...developer to create an Interactive Voice Response (IVR) system for my project. The primary goal of this IVR system is to Play a pre-recorded message when a customer calls a DID, then route the call according to any routing rules configured on the dialplan. This means that the system needs to be designed to handle customer queries and direct calls to the appropriate department. Ideal Skills: - Proficient in ASTPP/Freeswitch - Experience in IVR system development - Strong understanding of customer support processes - Ability to design system for call routing The project is expected to be completed within a reasonable timeframe. A successful candidate will be able to understand the nuanced requirements of the system and develop a user-friendly IVR which al...

I urgently need a skilled professional to set up a E-commerce website on AWS. Website is already hosted in AWS instance but due to some error website is stop, We need to start website Tools : php Mysql

I require an experienced Web Developer to undertake a project we have. The website we need is a comparison website for Coach hire. This will entail a booking system where Coach companies (Operators) will bid/tender for work etc. Below are the features. User Registration and...Users can rate and review operators. • Reviews influence operator rankings. Admin Dashboard: • Admins manage users, operators, bookings, memberships, and more. • Monitor platform activities and resolve disputes. This kind of platform requires a combination of front-end technologies (HTML, CSS, JavaScript), back-end technologies (server frameworks like Node.js/Express or Django, databases like MySQL or MongoDB), and potentially third-party APIs for features like payment processing and Googl...

I am currently in need of an experienced Django developer to assist me in deploying my Django web application on a VPS hosting provider. To bid on this project, you should: - Have intermediate to advanced level experience with Django and its related technologies. - Be proficient in MySQL, as this is the specific database system that my Django application is built with. - Understand VPS hosting thoroughly. Your role will be to guide me through the deployment process, ensuring that the application runs smoothly and functions as expected on the VPS host. Please show proof of similar projects handled in the past. Your time commitment should be immediate and full-time until completion of deployment. Your proposal should include a plan of action detailing how you intend to carry out ...

...primary goal is to automate data entry processes. The current application contains manual data entry. I am attaching a screenshot of how it is entered manually and a picture of the paper from which it is typed. OCR should be done automatically. We can take pictures with a mobile phone in a few seconds so that everything is finished. The application is in spring boot and angular. The database is mysql. Functionality for Taking Photos Using HTML5 and JavaScript, you can use an input element with the type file and the attribute accept="image/*" to allow users to take pictures of documents directly from the browser on a mobile device. Uploading the Image to the Server When a user takes a picture and clicks the save button, the image is sent to the backend server via an ...

I am hiring for a Full Stack Web3 developer for my team. Tech Stack: Blockchain: Blast (EVM) Frontend: Typescript + NextJS + Tailwind + Vercel + WAGMI + Ethers V5 + Typechain Backend: Typescript + Vercel Lambda + tRPC + AWS + Prisma ORM + Ethers V5 + Typechain + Upstash Redis Database: MySQL (Planet Scale) + AWS S3 Storage Randomization: Gelato VRF Static File Hosting: AWS S3, Pinata Smart Contracts: Foundry, Hardhat Monorepo. Here you go: Objective: Design and implement a scalable backend and frontend system for tracking and displaying NFT transactions similar to the "Activity" feature on OpenSea The system should handle varying loads seamlessly, from 500 to 50,000 users. Tasks: System Architecture Design: Task: Design the overall architecture for the activity

...require a freelancer skilled in survey design and impactful visual content to make changes to an existing electronic survey I have in Survey Monkey. Here is some insight into the specific tasks you'll be undertaking: - Update and enhance the current survey: This involves infusing fresh content by updating existing questions, introducing new questions, and replacing the current graphics. - Create an entirely new survey: This will include a mix of existing and new questions, along with logos and product images. The goal of this survey will be to gather customer feedback, so creating questions that retrieve valuable customer insights will be essential. - Build a survey flow and link answers for follow up automated EDMS and other for...

...full time developers. This platform will reside on the AWS network, preferably using MySql and Linux. We will be recreating a PHP/MySQL platform to a JavaScript/MySQL platform with approximately 200 features. This new platform will require a significant upgraded user experience, integration of animated graphics and faster reports processing. Our current platform has some components that are 10 to 20 years old. You will be creating from scratch and not using ANY of the current code. Key Developer Requirements: - Extensive experience in JavaScript platform development. - Access to skilled User Experience programmers - Knowledge in Google Mapping - Knowledge with AWS and setting up Linux servers and MySql databases Your team will be replicating our current s...

I'm looking for a quantity surveyor experienced in residential construction. Key Requirements: - Provide both preliminary and detailed i...a quantity surveyor experienced in residential construction. Key Requirements: - Provide both preliminary and detailed itemized estimates. - Expertise in estimating for structural components, finishing materials, and MEP systems. Your job will include: - Detailed take-offs and measurements for all elements of a residential building. - Translating the measurements into a comprehensive quantity survey. - Providing both high-level preliminary and detailed itemized estimates. This role requires a meticulous eye for detail and a strong understanding of construction materials and techniques. Experience in working on similar residential project...

...experienced in Apache NiFi to create a workflow pipeline. This will involve converting and integrating data into MySQL. Key Requirements: - Proficiency in Apache NiFi: You must have a solid understanding of the platform to develop efficient and reliable data conversion workflows. - MySQL Integration: Experience in integrating data with MySQL is essential. - Data Conversion: You will be responsible for converting the data - previous experience in this area is highly desirable. Please note the following: - The type and source of data to be converted is not yet defined. - The triggering mechanism and frequency of workflow runs are also pending. Ideal Skills: - Proficient in Apache NiFi - Strong MySQL Integration skills - Previous experience in data conversion...

I'm searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solutions according to the basic complex...

I am experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall database performance.

I need assistance to effectively integrate a post form into my project. The form should be skillfully designed to send data to a MySQL database, and to handle CRUD operations. Key Requirements: - Collaborate with me to understand the form's workflow and user interaction. - Skillfully implement the form to effectively send user data to a MySQL database. - Ensure the form is able to perform Create, Read, Update and Delete operations, where necessary. Ideal Skills: - Proficiency in form implementation. - Strong experience with MySQL databases. - Good understanding of web project workflows. Your bid should demonstrate your understanding of the requirements and provide a clear strategy for how you intend to approach this project.

...structure, directories, and templating system (Liquid). Experience manipulating orders, grabbing data from the database, and crafting custom views using Liquid shortcodes. Proven ability to develop custom Shopify plugins to achieve complex functionalities. Technical Skills: Proficiency in Shopify development languages (Liquid, JavaScript, HTML, CSS). Experience with database manipulation (likely MySQL). Communication & Collaboration: Excellent written and verbal communication skills in English. Ability to clearly explain technical concepts to non-technical stakeholders. Comfortable participating in regular video calls to discuss project progress. This is a long-term project for a passionate developer who thrives on pushing boundaries. Are you ready to take Shopify to the ne...

I'm looking to integrate Optical Character Recognition (OCR) into my web application. The primary goal is to automate data entry processes. The current application contains manual data entry. I am attaching a screenshot of how it is entered manually and a picture of the paper from which it is typed. OCR should be done automatically. We can take pictures with a mobile phone in a few seconds...primary goal is to automate data entry processes. The current application contains manual data entry. I am attaching a screenshot of how it is entered manually and a picture of the paper from which it is typed. OCR should be done automatically. We can take pictures with a mobile phone in a few seconds so that everything is finished. The application is in spring boot and angular. The database ...

The aim of the project is to create a nodeJS program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, ...

We are a market research survey firm and looking to conduct a study focusing on customer preferences and feedback for MoneyGram money service provider. Ideal Candidate: - Have you used or would you consider using a service to transfer money to another person. - Familiarity with the remittance service providers of MoneyGram, Wise, Revolt etc

...scalable backend infrastructure that can handle high volumes of bookings while ensuring a smooth user experience. I need a skilled Core PHP Developer to build a custom web application with database management capabilities, using MySQL as the preferred database management system. The application should be well-structured and efficient with an emphasis on data handling. Key Requirements: - Extensive experience working with Core PHP. - Proven track record of developing dynamic, secure, and efficient web applications. - Strong understanding and experience with MySQL database management. - Ability to ensure the application is well-structured and follows best practices for data handling. - Strong problem-solving skills and the ability to work independently. ?️ Key Responsibi...

I have an existing Laravel-based ecommerce application that requires a series of modifications and additions. Key Tasks: - **New Tables & Conditions**: I'm looking to add several new tables and conditions to the application. Skills & Experience: - **Laravel Proficiency**: I'm seeking a seasoned Laravel programmer who has extensive experience ...Proficiency**: I'm seeking a seasoned Laravel programmer who has extensive experience with ecommerce applications. The ideal candidate should be highly proficient in Laravel framework and comfortable creating new tables and conditions within the application. - **Database Management**: A solid grasp on database management is crucial to successfully add and integrate these new tables. Experience with MySQL or other r...

I'm looking for an experienced PHP developer who is well-versed with MySQL to help me with editing the search module of my website. The primary focus of this project is on modifying the way images are retrieved then displayed in the search results. Key Requirements: - Modify the retrieval of images in the search results to use URLs for specific sizes as opposed to the current methodology of storing images locally and then displaying. - No specific enhancements are needed for the image thumbnails, just an adjustment in the retrieval and subsequent display methodology. Ideal Skills: - Proficiency in PHP and MySQL - Experience with implementing search modules in web development - Familiarity with retrieving and displaying images in various sizes - Strong problem-solving ...

...artificial intelligence (AI) features. • The website aims to leverage AI technologies to enhance user experience, improve job matching accuracy, and streamline the recruitment process for both job seekers and employers. • Development should be based on modern web technologies, such as HTML5, CSS3, JavaScript, and server-side scripting languages like PHP or Python. • Database management system (e.g., MySQL, PostgreSQL) for storing user data and job listings. • Integration with third-party APIs for features like job search, location services, and social media. • The recruitment website will incorporate AI-powered features such as natural language processing (NLP), machine learning (ML), and data analytics to deliver advanced functionalities including intel...

We are seeking an experienced custom web developer to create a unique web application tailored to our specific needs. The ideal candidate will have expertise in the following areas: Recommended applications and Technology: HTML, CSS, JavaScript, React/Vue/Angular) Laravel, CodeIgniter, Node.js, Python, Ruby on Rails, PHP, or similar - Database management (MySQL, PostgreSQL, MongoDB, etc.) - API integration - Responsive design **Responsibilities:** - Develop and maintain the web application according to the project specifications. - Collaborate with our team to refine and improve features. - Ensure the application is secure, efficient, and scalable. **Requirements:** - Proven experience in custom web development. - Strong portfolio showcasing relevant projects. - Excellent proble...

Current project is built on Laravel for both front and backend. Need to build React frontend to replace Laravel frontend side. All the pages inside current pages should be moved to React with new template UI and all same functionalities. Main Laravel fronten...All the pages inside current pages should be moved to React with new template UI and all same functionalities. Main Laravel frontend back end Login this saas/superadmin version (include All modules) USE THIS Admin TEMPLATE FOR Frontend Current system making this stacks - Laravel, MySQL, VueJS, JQuery & Bootstrap, DOCUMENTATION API DOC

I need a custom AutoDialer to automate survey calls for my Magnus Billing business. Key Requirements: - The main purpose of the AutoDialer will be to conduct survey calls. - The integration with our existing system must be through txt and xlsx files. Specifics: 1. The auto-dialing module should retrieve numbers from a text (TXT) file. 2. Ability to view statistics for numbers (overall): - Answered - Unanswered 3. Ability to assign a call campaign to each agent individually: - Other agents cannot see each other's campaigns. 4. Ability for the main agent to assign one campaign to all of their agents. 5. Exporting statistics by agents: - Export a text (or any other) file with answered/unanswered numbers specifically for that agent. - Export statistics for a specific c...

...Function to an Azure MySQL database. The function is being used as a Web API, and I need it to be able to both read and write data to the MySQL database. Key Requirements: - Development: You will need to establish a secure, reliable connection between the Azure Function and the Azure MySQL database. - Data Handling: The API should be able to retrieve data from the database as well as input new data into it. - Security and Optimization: Ensure proper security measures are in place to protect the data, and optimize the API for performance. Skills and Experience: - Proficient in C#: You should have strong experience working with C# and Azure Functions. - Azure Services: A solid understanding of Azure services and how they interact. - MySQL Database: Previous e...

Hello, I need a reliable, fast, and affordable installation of the Stripe payment processor for my website, from someone who keeps their commitments. This person must have knowledge of HTML, PHP, and MySQL. Regards

Please Sign Up or Login to see details.

I have 2 PDF survey drawings that I need to be converted into site cross-sections. Key Requirements: - Convert two PDF survey drawings into cross-sections. Additional Information: - The survey drawings are in PDF format. - The cross-sections will be used for construction planning, so they need to be accurate and detailed. Ideal Skills: - Proficient in using drafting software (e.g. AutoCAD, Revit). - Strong understanding of civil engineering and construction planning. - Previous experience working on similar projects.

...WordPress site on the chosen hosting platform. Ensure HTTPS is enabled for secure data transmission. Provide documentation and a brief training session on managing the site and handling common issues. Technical Requirements: Frontend: HTML, CSS, JavaScript (with jQuery or a framework like React/Vue if necessary). Backend: PHP, WordPress, Google Cloud Text-to-Speech API, FFMPEG. Database: MySQL or equivalent (if needed). Hosting: Recommendations for hosting solutions that support WordPress and required processing capabilities. Deliverables: Fully functional WordPress website with the described features. Custom WordPress plugin for handling audio generation and integration. Documentation for setup, maintenance, and troubleshooting. Brief training session for site ad...

...need an expert to pull data from my MySQL database, specifically from the Customers and Orders tables, and send it to a Slack channel in a unified message. The data includes text, numeric, and date entries. Key Requirements: - Integrate MySQL data with Slack: I need the freelancer to help me integrate the data entries from the specified tables with a Slack channel. - Collide Entries: The entries from the Customers and Orders tables need to be combined into a single, coherent message. - Include Specific Fields: The message should include specific fields from the MySQL tables. These fields include Customer Name, Order ID, Order Date, Customer Phone Number, Customer User ID, Product Details, and Product Quantity. Ideal Skills and Experience: - Proficient in MySQL...

...developer with experience in creating automation tools. We're looking to build a sophisticated website and dashboard, which will be later integrated with API and MySQL. The final product should be a robust, blockchain-based automation platform. Key responsibilities include: - Building a website and dashboard from scratch - Implementing blockchain technology for automation - Ensuring seamless integration with API and MySQL The ideal freelancer should have: - Extensive experience in web development, particularly in creating automation tools - Proven track record in implementing blockchain technology - Strong understanding of API and MySQL integration - Ability to deliver high-quality work within a short timeframe This is an urgent project, and we need someone ...

I need a developer proficient in and a good understanding in API development. I have a parameter I would like to pass which is a string value to pull an entire user object with all of the properties in a database. this would be a string parameter passed into a Get request with a response of an entire record pulled from a MySQL database and using an Interface to extract the properties into a page. This is a very small project and should only take a few minutes of time.

I'm looking for a professional Flask and Python developer to help me implement a user management system for my website. The user management system should have Social Media login integration. Additionally, I would like the selected developer to set up a payment gateway and a MySQL database. Ideal Skills: - Proficient in Flask and Python - Experience in implementing user management systems with social media login integration - Proficient in setting up payment gateways - Proficient in working with MySQL databases

...Tailored Solutions: We create custom web applications that meet your specific business needs, enhancing productivity and operational efficiency. ● Versatile Applications: Our solutions range from customer portals to complex inventory management systems, each built to address unique business challenges. ● Technology Stack: Node.js, , Ruby on Rails, Django, Laravel, MongoDB, PostgreSQL, MySQL, AWS, Docker....

...talented full stack developer, specialized in Flutter, jQuery, MySQL, AWS, and Google Cloud Platform, to help me bring my vision to life. I plan to develop a premium content platform for the web. The platform will provide a seamless user experience yet restricts premium content behind pay walls. Key requirements: - Develop a web-based premium content platform using Flutter and jQuery - Implement a secure and reliable system for MySQL database management - Integrate an inbuilt payment gateway for user subscriptions - Utilize AWS and Google Cloud Platform to ensure the platform's scalability and performance Ideal candidates should have: - Extensive experience in full stack development - Proven expertise in Flutter, jQuery, MySQL, AWS, and Google Cloud Platform ...

Project Description: I am seeking an experienced freelancer to develop a directory listing website, similar in design and functionality to the following template: The design will be provided by me. Requirements: 1. Technical Specifications: - Framework/Technology: Please suggest suitable technologies. - Database: MySQL, PostgreSQL, or another relational database. - Responsiveness: The design must be fully responsive and work flawlessly on all devices (desktop, tablet, smartphone). - SEO: It must be possible to optimize each individual listing for SEO, as well as the overall website. - Security: Implementation of security measures to protect user data. - Performance: The website must load quickly and

I've been facing issues with a MySQL table that seems to be taking up too much space in my database, despite there being no data in it. The table is almost 2MB in size while it has no rows at all. The database was originally like 50kb a few weeks ago. Recently we made some minor changes, like adding index. Then it suddenly become so huge. Key points: - Table size issue: The MySQL table is bloated despite having no data, and it's causing performance problems. - Insertion operations: The table is mainly used for inserts, which are what I need it to be optimized for. The work needs to be done remotely using anydesk. If you know how to do it, it should be just a few min fix.

I need an expert to configure my email accounts for Domains 1, 2, and 3. In addition, I require the design and implementation of tailor-made survey forms based on a specific model I have in mind. - Email Configuration: I need my email accounts to be set up in an efficient way in these three domains. You should be experienced in domain management and email setup. - Form Creation: I will provide a specific model for the survey forms that need to be created. Previous experience with custom form creation and design is a must. Looking to get this project completed as soon as possible. Those who can deliver fast results will be given higher consideration.

I'm seeking an experienced website developer to create a functional site with an in-built multiple-choice survey feature. Key project demands include: - Creating a clean, intuitive website. - Integrating a multiple-choice survey into the website. Ideally, you possess: - Proven experience in website development and survey integration. Looking forward to your bids.

...developer who can build an automated document verification system to simplify the document management procedure in educational institutions. The system must include the following features: - Database Integration: Integrate with MySQL, our preferred database management system, to make document retrieval and management easier. - User Authentication: I want the system to authenticate users via Single Sign-On (SSO) using existing authentication platforms like Google and Facebook. This is to ensure a secure, seamless and user-friendly sign-in process. Proficiency in MySQL, SSO Integration, and system development is required. Prior experience in document management system creation will be preferable. The ideal candidate should understand the intricacies of data security and ...

My existing React Native application, which is supported by NodeJS and backed by a MYSQL database, needs immediate attention. Here's what needs to be done: User Interface Updates: The component related to photos in the application requires significant changes. I also need a feature that shows the GPS route to the specified delivery point. This functionality was not implemented in the initial version of the application. Additionally, changing screen configuration doesn't display corresponding states with their color (only changes upon updating the application). Functionality Improvements: On top of the UI changes, the app needs general functionality improvements to enhance user experience and the app's efficiency. Also, create a button for downloading PDF files; the ...

Website Designer , Php , E Commerce having knowledge of MySQL

I'm looking for someone to work with me on an automated crypto trading bot. It will use Tradingview alerts, (which uses Webhook URL) to ping a script on a server, which then uses an exchange API to execute crypto trades. I will integrate the script into MySQL using php to track the amount traded and set a e.g. a sell price for the crypto just purchased after the alert... I can do that... But I need help with the integration of alerts from Tradingview and the API code to the exchange.

Project Overview: We are in need of a skilled backend developer to implement the necessary functions for our financial services website. The primary goal is to ensure smooth operation and functionality across various sections of the site. Project Details: Functionality Scope: Implement backend functions to support the frontend interface. Develop APIs ...discussed based on project scope. Timeline: Fastest to complete. Preferred Communication Channel: Freelancer platform messaging system. Additional Notes: Collaborate closely with frontend developers to ensure seamless integration. Prioritize security and data integrity in backend implementation. Skills Required: Node.js RESTful API Development Database Management (e.g., MongoDB, MySQL) Authentication and Authorization Systems

I'm seeking a skilled system administrator to replace my current MariaDB with MySQL 8.0 on a CentOS server. The ideal candidate will be able to: - Completely remove MariaDB ensuring no data loss - Install and configure MySQL 8.0, adhering to: * Default configuration * Custom storage engine Security is a key concern. Remote access to the MySQL installation must be restricted. This is crucial to maintain the integrity and security of the server and its data.

...abstract for the research paper 2- Introduction: The introduction is written you just need to adjust it based on some comments that I will send you once you are awarded 3- Literature Review: This part is complete you have to just check for grammers 4- Methodology: The methodology is written. You just have to make it more clear, and mention more things. Once you are selected for the job the survey that has been done for this is going to be sent to you. so that you are going to have a clear Idea what to do. 5- Result and discussion: This part is not completely written and it has some minor issues. I will send you more info. on how you are going to do it. 6- conclusion : you have to write the conclusion for me it is not written. 7- References: FOr the refrences you should use...

...an experienced AWS DevOps specialist to host my business management tool which consists of a React-based front-end, an ASP.NET API and a MySQL database on AWS, specifically using Elastic Compute Cloud (EC2). Key requirements: - Hosting: Set up and manage the hosting environment on AWS EC2, ensuring the site is stable and accessible. - Scalability: Implement strategies to accommodate low traffic, up to 100 users per day. - Security: Ensure the highest level of security and integrity of the data. Ideal candidates should have: - Proven experience in DevOps and cloud hosting, particularly with AWS EC2. - Background or familiarity with React, ASP.NET, and MySQL. - An understanding of best practices for hosting and optimizing web applications. This project is crucial for my b...

I require assistance with land survey drafting, specifically focusing on topographic details and boundary and property lines. The project must cater to: - A comprehensive understanding of land survey drafting - A keen eye for topographic details and boundary/property lines - Proficiency in delivering high-quality DWG files Ideal skills include proficiency with drafting software, attention to detail, and experience with land survey drafting. Please provide examples of similar projects you have completed in your proposal.

??? ?????: ????? ?????? ????????? (????-????, ??????) Salary: up to 4000$ USD/month The ideal candidate will have a passion for algorithmic trading and extensive experience with the NinjaTrader platform software. This is a fully remote position with a flexible schedule, but the candida...Experience with version control and continuous integration tools such as GitHub/GitLab • Knowledge of third-party libraries and APIs • Proficiency in building enterprise web solutions using the MERN stack • Strong proficiency in HTML, CSS, JavaScript, and JavaScript frameworks like Dart, React, and Node • Experience with server-side languages such as Python, PHP, and C# • Knowledge of databases such as MySQL, NoSQL, and GraphQL Ability to accurately forecast and communicate ...

...visualization to create a series of infographics based on survey results. The infographics must be tailored for a general audience, making complex data easy to understand and engaging. Key Requirements: - Proficient in Data Visualization: You should be well-versed in creating visually appealing infographics that effectively convey survey data. - Audience Understanding: The ability to simplify complex information for a general audience is crucial. - Survey Data Expertise: Experience with survey data interpretation and visualization is preferred. - Creative and Innovative: I'm looking for someone who can think outside the box and deliver unique, engaging designs. - Strong Communication Skills: Clear communication will be essential for understanding the ...