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, ...
I'm urgently seeking an experienced freelancer to help me update my Joomla template and modules. Your responsibilities will include: 1. **Color Scheme Revamp:** The updated design should reflect the specific designs I've prepared. Expertise in creating an exact match is crucial. 2. **Adding New Functions:** Some new functions to improve my website's interactivity and user-experience need to be introduced. Having prior experience delivering such features will be advantageous. 3. **Styling Update:** I also require modifications and tweaks to the existing Joomla components and modules. Your skills should include Joomla templating and module modifications. The timely completion of this project is essential as I'm looking to implement these changes u...
Estoy buscando un experto que me ayude a migrar una aplicación web PHP y Ruby on Rails desde Node JS a un servidor con Cpanel. Detalles clave del proyecto: - La aplicación web actual está construida utilizando una combinación de PHP y Ruby on Rails. - La aplicación interactúa principalmente con una base de datos MySQL. Habilidades y experiencia ideales: - Competente en Node JS, PHP - Fuerte conocimiento de MySQL. - Experiencia previa con tecnologías del lado del servidor y migraciones. - Familiaridad con Cpanel. El candidato seleccionado debe poder garantizar que el proceso de migración sea fluido, sin pérdida de funcionalidad o datos. Este proyecto es urgente, por lo que estoy buscando a alguien que pueda real...
...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 ...
I need a Student Information Manageme...contact information and medical details. - Student details and parent details will be collected using Office 365 Forms and the replies should write directly into the student management system. **Document Storage** - A document storage section is required for maintaining relevant records and resources. Including student documents like passports, reports, etc. **Grid View and Dashboards** - Information should be displayed in a grid view with filters for ease of access, and customizable dashboards for broader review and analysis. Ideal freelancer should have proven experience in SharePoint and PowerApps development, with a strong understanding of education management systems. Expertise in user-friendly interface design and data securit...
Objetivo El proyecto implica el desarrollo de un MiniCRM con las siguientes características principales: Autenticación y Gestión de Perfiles Implementación de un sistema de inicio de sesión seguro. Gestión de perfiles y roles de usuario para garantizar accesos independientes a cada módulo del sistema. Diseño ...Mantenimiento de un historial detallado de cada transacción de entrada y salida de stock, incluyendo observaciones para el seguimiento del movimiento de inventario y el usuario que realizó cada transacción. Consideraciones Adicionales El sistema se desarrollará utilizando PHP sin el uso de frameworks, asegurando una solución personalizada y optimizada para las necesidades específicas d...
Hi, Nee one simple PhP,MySQL app which will prompt/require for Document-URL: and extract all the short abbreviations inner in (....) from entire document(with PDF,...extensions). The report/result will like this table with 2 columns: sentence | terms-founded | string of terms | check-selection | button "do-it" Then I will select the terms by checking and then I will press the button "do-it" and the selected terms founded between (...) will be savet into MysQl Table. So for Document-URL: this is simple example of line from this report -sentence: "With the deployment of
...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...
...ensure your submission is read. I have a Joomla site that I need to port over to WordPress, and I'd like to get a unique design for the new site. Key Requirements: - Porting Joomla site to WordPress: I need an experienced developer who can smoothly and completely move the content, structure, and functionalities of my existing Joomla site to WordPress. - Design: I will be working on building the User Experience, All I need is the data in a structured format using ACF. Your Responsibilities: - Migrate all the existing content from Joomla to WordPress staging site. This includes pages, posts, images, videos, and any other relevant content. Skills and Experience: - Proficiency in Joomla and WordPress: You should have a strong background in both ...
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
...to use texts in local language "CZECH" - pictures can be used from Shutterstock or google (for now without buying just for presentation) - needs to show flexibility and high focusing company - so can be used some images of universe and so on, but in limited matter - we need just graphic design of only Home page for now - The resolution should be 1920 x ???? depends on the height of design, inner grid should take 1300px, if you decide to go fullwidth is also possible - we need also show of available positions - output can be JPG, PNG or figma/sketch designs Favorite designs - - - Contents of webdesign of HP in order from top to bottom - Main slider with claim, menu and logo and some call to action button - 3 columns of services
...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
...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...
I have a Joomla website that needs optimization. It's currently displaying Database connection and Internal server errors which I haven't experienced before. I have not made any recent changes to either the website or server configuration before these errors started occurring. I'm primarily aiming to increase the speed of the website. Therefore, I need someone who is experienced in Joomla website optimization, particularly in resolving internal server errors and database connection issues. Knowledge in enhancing website speed while ensuring its stable performance is crucial. Your expertise in Joomla is a must, as I would like these issues resolved promptly without any unintended consequences.
...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
Se busca persona con experiencia superior a 5 años administrando sitios en Joomla y que también tenga experiencia comprobable en Drupal
...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'm in need of a proficient web designer to help bring my static website to life. The website should include the following sections: - Home - About Us - Services - Contact - Portfolio - Testimonials Your skills and experience should ideally include: - Expertise in popular web development languages wordpress, sitejet builder, joomla, drupal - Previous work designing static websites - A strong understanding of UX design principles - Quick turnaround ability Please note, the completion of this project is required as soon as possible. Any clarification will be provided promptly to ensure the accurate and speedy development of the website. Your proposal should include your plan for the job and time estimates. 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 ...
The project involves designing two specific pages for a website - the Home page and Voucher Redeem page. - Pages to be Designed: - Home Page - Voucher Redeem Page For the Home Page specifically, I need an expert who can: - Create a grid layout to display all co-company logo images. - Incorporate the displayed logo images with their respective information. - Ensure the design is visually appealing and user-friendly. Ideal skills for this project include proficiency in HTML, UI/UX design, and a strong understanding of layout design in a web environment. Please note that the Voucher Redeem page will be discussed in further detail once the Home page design is finalized. sample homepage design:
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.
PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH UR...starting wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) Accept and start work immediatly 3) Have MINIMUM OF 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 02:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales This is for ongoing long term development and we will start with some short sprints to be delivered in 1-2 days and then start gradually adding larger sprints for more improvements to our w...
...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...
??? ?????: ????? ?????? ????????? (????-????, ??????) 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 ...
Hola, Tengo un wordpress 6.5 con elementor 3.20 y tengo un problema con el proceso de paginado. He encontrado información sobre el posible problema pero no logro que me funcione correctamente. Necesito que el interesado tenga los siguientes Skills: - Experiencia en WordPress con versión 6.5. - Experiencia con Elementor. - Experiencia en resolución de incidencias. - Experiencia en modificación de código PHP sobre capa Wordpress. - Conocimientos con la capa de plugins de Wordpress. Para esta oferta, únicamente se aceptan ofertas para usuarios de habla hispana. En cuanto al acceso a la plataforma para analizar el problema, se realizará de forma conjunta dado que no se dan datos de acceso.
We have a website developed in PHP & MySQL database. We need to add news section in the home page. The same should be available to be edited from the Admin Section for the user to change contents in the News Section.
...(CMS) such as WordPress or Joomla. This will allow me to easily update and manage the content in the future without requiring technical expertise. - I want the website to have a user-friendly interface, making it easy for visitors to navigate and access the information they are looking for. - The design should be clean, professional, and reflect the nature of our business. A sleek, modern aesthetic is preferred. - Given the nature of the content, the visuals and layout should be appropriate for an industrial service, yet still appealing to potential clients. - SEO best practices should be implemented during the development to ensure the website is easily discoverable by search engines. Ideal Skills and Experience: - Proficiency in a CMS platform (e.g., WordPress, Joomla) ...
I am currently looking for a professional to help integrate PayPal legacy buttons into my existing shopping cart system. PayPal's documentation for the legacy buttons is not helpful. My add-to-cart button gets information from a mySQL database, but I'm unable to get the add-to-cart and view-cart buttons to work together. These used to work on an older web site. Key Requirements: - The main functionality is to enable my shopping cart to be able to process payments via PayPal. - The integration should direct customers to the PayPal website for payment processing. - I am looking for a manual coding integration, so experience in this is a must. Your Skills: - Proficiency in PayPal integration - Experience in manual coding for shopping carts - Attention to detail to ensure...
Estamos buscando un programador Android Studio para crear una app cuyo funcionamiento es conectarse a una base de datos mysql y consultar datos a partir de escanear un codigo de barras o QR. Buscamos a alguien de Argentina o al menos de America Latina.
I'm seeking a skilled developer to build a professional and user-friendly dashboard using NextJS Ideal Skills: - Proficiency in NextJS for building feature-rich, responsive dashboards. - Experience with Paddle API integration, particularly for subscription management. - Strong knowledge of MySQL for robust database functionality. - A keen eye for UX design to ensure the dashboard is intuitive and user-friendly. - Ability to work efficiently and communicate effectively throughout the development process.
I'm currently looking for a skilled and experienced developer for backend CMS development. Key responsibilities: - Develop a Content Management System using PHP, Laravel, MySQL, and Python. - Design, implement and maintain python-based backend application. Essential Skills: - Proficient in PHP, Laravel, MySQL, Python. - Extensive experience in backend development. - Knowledge in CMS development and implementation. - Strong understanding of data structures and algorithms. Your analysis skills will also be put to good use to solve complex problems in this role. As an experienced backend CMS developer, you can expect to work closely with me to deliver a robust, performant, and scalable system.
We've a design created on HTML and we want to implant it on Cassiopera HTML. The design are already created on HTML/CSS/JS. You've "just" to transfer it on Cassiopea template
I have a Wordpress plugin called Sales Agents B2B and I'm looking for a skilled Wordpress developer to make 4 small customizations to it. The customiz...subagents created by agents in their account - Showing the assigned sales agent in the list view of users - Modifying existing features: - Ensuring sales agent visibility in the list view of users The ideal candidate should have experience in: - Expertise in Wordpress plugin development - Understanding of user roles and permissions - Proficiency in PHP and MySQL for plugin customization - Previous experience in CRM system integration would be a plus Please only apply if you have relevant experience and can deliver quality work within a reasonable timeframe. I'm looking forward to hearing from you.
I am seeking a skilled PHP developer to create a distance calculating sript for me. This script will be responsible for calculating the distance between multiple coordinates stored in a MySQL database. No user interface required as the coordinates will be retrieved from the database directly. Key requirements for the project include: - Create a script that can fetch the coordinates from a MySQL database - Calculating the distance between these multiple coordinates accurately If you're a developer with experience in MySQL PHP and distance calculations, I would love to hear from you.
Perfect english is needed. You need to be able to teach and tutor me in relational data bases and sql. You must...answer questions about the following: The required tasks include: - Relational data bases ( administration, normalisation, sql workbench, my sql, data modelling) - Writing SQL queries - Designing the database schema - Optimizing query performance This project specifically involves MySQL, sql workbench, so proficiency in this database system is a must. The complexity level of the project is intermediate, focusing on tasks like joins and subqueries. Ideal candidates will have: - Extensive experience with MySQL databases - Strong SQL querying, schema design and query optimization skills - Proficiency in working with relational databases - Experience in databa...
I am looking for a freelancer who can help me with Web Scraping. We have a list of websites that we would like to scrape specific data from, and have them put into a set of MySQL Databases (or maybe something else). The website that we would like to scrape data from each contain thousands of articles, and we would also want other metadata, such as Author name, article date, number of views, or any other metadata that we can take from the pages. Please bid, and we can discuss the first website, you can tell us how long you think it'll take to write the scraper. There are maybe 50 websites to begin with that we would like to do this for, in this one project, and we also have another couple of similar projects. Ideally, the scraper will run form a program, so that we can run it...
