Mysql load data infile replace jobs

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....

● Visually Appealing and Responsive: We design websites that are visually engaging and fully responsive, ensuring a seamless experience across all devices, from desktops to mobile phones. ● Performance Optimization: Our focus is on optimizing website performance to ensure fast load times and smooth user interactions. ● Technology Stack: HTML5, CSS3, JavaScript, React.js, Angular, Vue.js, Bootstrap, SASS.

I've attached two drawings which is what I would like professionally replicated so I can eventually print across say 3 x A3 sheets and display on an easel. I have attached a photo of what the old building looks like which is what one of these two drawings will replace.

...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 ...

...net/item/guido-directory-listing-html-template/31702545 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 be highly performant. - Import Functionality: Ability to import an Excel file so that entries are automatically created in the backend. 2. Design and...

...seeking an experienced engineer to implement finite element analysis using ansys software. The engineer will perform structural analysis on our steel tank reinforced with u channel on the circular joint under specific load conditions. Primary Responsibilities: - Execute a structural analysis on a steel tank - Consider both static load and hydrostatic pressure loads in the analysis - Use ansys software for the simulation Ideal Skillset: - Extensive experience with structural analysis and finite element methods - Proficiency in using ansys software - Strong understanding of different load concepts: static and hydrostatic pressure loads - Familiarity with steel as a material for structural analysis You should be able to interpret the results of the analysis and pro...

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've been facing an issue with the images on my WordPress website that only load after I scroll down on mobile devices. Ideally, I need them to load as soon as the page is loaded without any delay. Key Requirements: - Immediate image loading on mobile devices - No specific plugins for image optimization or lazy loading Ideal Skills and Experience: - Proficiency in WordPress development - Experience in optimizing websites for mobile devices - Understanding of image optimization techniques If you're confident in resolving this specific issue and improving mobile user experience, I'd be glad to hear from you.

I need a skilled Photoshop expert to transform the drizzle in a photo to a sauce. The edited photo should look as realistic as possible. Here are the key points: - Replace Drizzle with Sauce: The main task is to replace the drizzle in the original photo with a sauce(the organge color). The sauce should blend seamlessly with the rest of the image, making it hard to discern the editing. The end result should look as if it was the original intention of the photo. - Realism: The level of editing required in this project is photo-realistic. The sauce should not only look like a sauce but should also appear as if it belongs in the original image. - Attention to Detail: I am looking for someone who can pay close attention to details and ensure that the edited photo is of high qua...

I need a proficient structural engineer to design a pole barn that will serve as a workshop. The barn will principally store lightweight materials, so the designed structure should be able to support such load with future-proof adaptability. Preferred Skills and Experience: - Extensive experience in structural design, particularly with wooden structures. - Knowledge in the design of functional workshops. - Understanding of lightweight materials' impact on structure designs. The barn will be constructed primarily from wood. Therefore, prior experience in designing and working with wooden structures is crucial. The final deliverable will be a detailed structural design, including blueprints, suitable for immediate construction.

I am on the seek for a ...manipulation. Your task is to incorporate my image as a main character, specifically replacing Vito Corleone, on The Godfather movie poster. Ideal Skillset: - Strong command on Photoshop and photo editing. - Understanding of movie poster aesthetics and design. - Experience with image manipulation on pre-existing artwork. - Fan of The Godfather series - a plus. Project Specifics: - You are to replace Vito Corleone's face with mine. - Photo realism and seamless integration into the artwork is essential. - The final image should adequately capture the intensity and style integral to 'The Godfather.' This project demands precision, creativity and a keen eye for detail. If you fit this description, I'd love to hear from you. Let's ...

...multi-story building project that requires an experienced structural engineer. Your primary task would be to evaluate the necessity of central RC columns in the building by checking the load distribution from the provided load calculation sheets. Key responsibilities: - Evaluate the need for central RC columns in a multi-story building - Thoroughly analyze the provided load calculation sheets for structural integrity - Provide alternative design solutions if necessary Ideal skills for this job would include: - Professional experience in structural engineering, especially for multi-story buildings - Expertise in evaluating load distribution and structural integrity - Ability to provide alternative design solutions based on your analysis Your work will great...

I'm looking for a skilled professional to create a Load, Functional testing, Security testing LLM to test our internal websites. Key Requirements: - Operating System: The LLM must be compatible with Windows. - Reporting: The LLM should report test results through an integrated dashboard. - Testing: The LLM must be capable of performing Load, Functional, and Security testing. - Test Cases: The LLM must be able to create tests cases based on the current state of the website. Ideal Skills and Experience: - Prior experience in creating and working with LLMs. - Proficiency in load, functional, and security testing. - Familiarity with Windows OS and dashboard reporting systems.

I am looking for an expert React developer to help me with front-end development and state management. I am new in react. i am using adminity html template for react. after converting to jsx. when i am login then dashboard sidebar design scrumble due to some js but component navigation w...state management. I am new in react. i am using adminity html template for react. after converting to jsx. when i am login then dashboard sidebar design scrumble due to some js but component navigation working fine but if i reload the dashboard page then scrumbled design is ok as per template but if i click on navigation then it reloaded complete page. I want Single page Application buth somehow it load complete page when navigate to other page. Some JS loading issue Budget INR 600-800 Anydesk w...

...to select a device to load its statistics via API. Graphs and Data Tables: Around 10 different graphs and several data tables with pagination. Time Ranges and Filtering: Options to select time ranges and apply filters from the UI. API Integration: Fetch device statistics from a backend API. Modern UI: Clean, intuitive, and well-designed user interface. Key Features: Device List Display: A dashboard-like interface showing all IoT devices. Dynamic Graphs: Display statistics and data in a graphical format (around 10 different graphs). Data Tables: Tables with pagination to display detailed data. Filtering and Time Ranges: UI elements to filter data by different criteria, including time ranges. API Integration: Seamless integration with back...

I'm in need of a skilled WordPress developer who can help me in optimising my WordPress site, https://feufo.com. I require a comprehensive set of services that include: - Speed Optimisation: My website needs to load faster. This includes improving the page load time, optimising server response time, and minimizing browser render time. - SEO Optimisation: I need to enhance my website's SEO with a focus on keyword research and optimisation. In addition, I'd like assistance in creating a privacy page on my website. This page should clearly outline the privacy policy of the site and be in line with current legal requirements. Ideal candidates for this project should have: - Proven experience in WordPress site optimisation - In-depth understanding of SEO str...

hi There, We are looking for a developer with substantial expertise in Text-to-Speech (TTS) technology, and AI. Our project involves creating a Text-to-Speech and Translate and replace Audio Line solution for the Kurdish language. *****About Our Tool***** We Build a Tool that have as Frontend WPF and as Backend Python and Django and as DB is MongoDB The Tool is ready to use and u will get access when we Start ****How we will Work*** We have Server that have enough resources that will help u to work on the Tool We will create a RDS Access for u where u can access to the System and Start ur work using our Server "VMWARE" ****What is your Work***** Coz u dont speak our kurdish Language we must train the tool by our self, thats mean u have to do Adjustments in the Tool ...

I require general labor help for moving medium-heavy objects weekly. The job involves moving boxes, and thankfully, there are no stairs involved - everything is on one level. The person needs to accompany me to a restaurant supply store lift boxes from the shelf to the cart and then load all the boxes into my pickup truck. Ideal Skills: - Physical strength and fitness - Experience with heavy lifting - Attention to detail Your main responsibilities will be: - Moving boxes from one location to another - Ensuring items are handled with care - Working efficiently and effectively to complete the task promptly

I'm searching for a developer who can build an automated document verif...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 be able ...

...email addresses in a Google Sheets document. Your job will be to: 1) verify these contacts by checking if they are still active on LinkedIn, and if so, 2) determine where they are currently employed. 3) Do a test email and verify if the email address is currently active 4) Replace an inactive email with a new active email address Key Requirements: - Experience with LinkedIn verification - Strong organizational skills to handle 10,000 contacts - Expertise in using Google Sheets - Ability to cross-check large volumes of data swiftly - Attention to detail to ensure accuracy Deliverables: - A revised Google Sheets document with active contacts' current employers listed Timeframe: - I'm looking for a quick turnaround on this project This is a high-volume task, so...

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 ...

I'm looking for a CSS expert who can help me identify why CSS is failing to load on all pages within a particular section of my website. - The issue: The CSS of this particular section of the website is not loading at all, affecting the overall appearance and functionality. If I put any characters before the HTML, the CSS is loading. - Website status: Other sections are not impacted, and the pages in this section are loading, but without proper CSS. - Validation: Please, start your answer with "Validation Stable MARK" to prove you read the description. Quotes without validation won't be accepted. - Recent changes: I haven't made any recent changes to the CSS or the website code. The hosting was changed. On the local server, it is working fine. - Code: The w...

Website Designer , Php , E Commerce having knowledge of MySQL

I am seeking a well-versed freelancer in cognitive psychology to produce a detailed, advanced level report. The main focus should be on the cognitive underpinnings of political attitudes. - relationships between cognitive processing including Need for Cognition, Inherence Heuristic, Cognitive Load and political ideology including Political Attitudes, Conservative and Liberal Ideologies. I have put two starter refernces we must put in this report, but also you must find four to five references to include in this essay. Those are the report that canbe usuful: - Not All Ideologies are Created Equal: Epistemic, Existential, and Relational Needs Predict System Justifying Attitudes - Motivated Closed-Mindedness Mediates the Effect of Threat on Political Conservatism H. Thórisd...

...the LEDs, the circuit should also be able to control a small 3-4 V motor. A potentiometer should control how fast the motor turns in order to power the speed of the fire truck. - Control Sound: The Arduino MKR Zero should be able to output a sound file (either WAV or MP3) to two very small speakers. The sound file would be a siren with an intermittent horn. I can compose the sound file myself and load it onto the Arduino. There should be a separate potentiometer to control the sound volume. It would be nice if the battery could last an hour or so on a full charge. Once installed into the fire truck, the battery should be able to be recharged through the onboard USB port so as not to have to remove it from the fire truck. Obviously, this would all have to be very small. I have m...

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.

...Functionality Scope: Implement backend functions to support the frontend interface. Develop APIs for data retrieval and manipulation. Ensure seamless integration with the chosen frontend framework. Sections Requiring Backend Functionality: User Authentication and Authorization Data Retrieval for Services Newsletter Subscription Management Interactive Content Management Blog and Opinion Management Event Management Comment Section Functionality Social Media Integration Contact Form Submission Handling Specific Requirements: User Authentication: Implement secure user authentication and authorization mechanisms. Data Management: Develop APIs for retrieving and managing service-related data. Subscription Management: Implement functionality for managing newsl...

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.

...proper error handling and logging mechanisms are in place. Optimize the worker scripts for performance and scalability. Integration and Testing: Integrate the master script, worker scripts, and Apache Kafka setup to create a cohesive distributed messaging system. Conduct thorough testing to ensure the system functions as expected, including message filtering, distribution, and processing. Perform load testing to validate the system's ability to handle high message volumes. Documentation and Handover: Provide comprehensive documentation on the Apache Kafka setup, master script, and worker scripts. Include instructions for installation, configuration, and usage of the messaging system. Conduct a handover session to transfer knowledge and ensure smooth operation of the sys...

Hi I need a elementor pro licence. I recently used a cracked on and it is causing cross site scripting. So I need to replace it with a paid one. Regular one for one site is costing me a higher prices. If anyone can offer me for a cheaper price. it would be great Thanks

I'm in need of a seasoned professional with extensive Wordpress knowledge to revamp our website with a focus on user experience, website traffic increase, and mobile optimization. The ultimate aim is to appeal more to my B2C consumer base. Key Aspects: - Improve navigation: Make the site more user-friendly ensuring smooth navigation across all pages. - Increase page load speed: Ensure the site runs faster with optimized codes that guarantee speed and superior performance. - Mobile Optimization: With a considerable amount of traffic coming from mobile users, the site should be seamlessly responsive on all device types. Ideal Skills: - Proven experience in Wordpress development and design upgrade - A strong understanding of UI, cross-browser compatibility, and general web fun...

I'm seeking an experienced SEO expert to improve the current performance and visibility of our website. Here's what the project entails: 1. Find out all of AI article and listed it from our corrently article. 2. Write high quality 2000-2500 new articles to replace the AI articles, we can talk about this price later on. 3. Anylasis all of post according to keywords, find out repeated or nearly repeated url list, and give suggestion on which list should be deleted or replaced - On-Page Optimization: The SEO specialist will also need to optimize our website's on-page elements. This includes refining meta tags, heading tags, image alt attributes, and other on-page SEO factors. The primary goal is to make our website more search engine friendly and improve our ranking in...

I'm in need of an experienced structural engineer with a background in weight calculation and industrial design. Key project goals: - Assess our existings mezzanine floor a...on this floor safely - The mezzanine floor will need to be robust enough to withstand use of pallet jacks for moving items around. Requirements: - Proven experience in industrial weight load calculations specifically for mezzanine floors. - Understanding of safety regulations and necessities when designing heavy load structures. - Ability to work within budget restraints and timeframes. - Located in Ireland (Dublin) as a site visit will be necessary. The successful bidder will guide me in obtaining a safe, economical, and practical solution for this project with close attention to the he...

...systems to send and receive messages through SMS, Email messages or Mobile Push Notifications with a variety of connection options and integration channels. - A dedicated on-premise messaging gateway that provides better visibility and control on sent messages and notifications - Improved security and control over sent messages with masking and filtering options - Higher availability with offered load balancing, bulk providers switchover and different sending methods - Seamless operation and integration with a dedicated system inside the network to integrate with all sending applications and all bulk providers Ideal Skills and Experience: - Proficiency in developing messaging gateways and integrating with different platforms. - Strong understanding of security protocols and ...

I'm looking for an experienced app developer to create a versatile webapp for both iOS and Android, with the following key features and functionalities: - The webapp should have a hybrid design, but I'm not sure yet if it will be a hybrid app or separate apps for iOS and Android. Your insights and expertise in this regard will be greatly appreciated. - The primary function of the app is to load a specific website URL. In addition to this, the app should have a menu at the bottom of the screen with 5 specific links that will be provided. - The website URL should be loaded within the webapp itself, rather than opening in a separate browser. - The app should be user-friendly, responsive, and optimized for both iOS and Android platforms. Ideal Skills and Experience: - Profic...

I'm in need of an Ansys expert who can help me simulate a mechanical component and analyze it for stress. The simulation is to be conducted under dynamic load conditions. Key Responsibilities: - Understand the product design and its intended usage. - Create a dynamic loading situation within Ansys. - Conduct a thorough stress analysis of the mechanical component. - Provide a detailed report on the simulation results. You should have: - Proficiency in Ansys, particularly in stress analysis. - Experience in working with mechanical components. - Understanding of dynamic load simulations. - Ability to interpret and present simulation results. Your work will be instrumental in helping us ensure the reliability and safety of our product.

...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 f...

I'm looking for a skilled WordPress developer to create a custom design for my restaurant website. I want the site to be fully functional and visually appealing, incorporating specific elements such as: - Menu and price showcasing website, - It should be Mobile responsive, and fast-load site - Anyone can order food from this site -Demo site - Key information I would like featured on the site includes our menu with prices, our location accompanied by contact information, and an online reservation system. Proficiency in Wordpress along with experience in custom theme creation and restaurant industry knowledge would be ideal for this project.

...and you'll play a crucial role in updating the design/layout, adding new pages/content, and improving the website's speed and load time. Key Tasks: - Update design & layout: I'm looking to freshen up the website with new typography and fonts. I would appreciate your creativity in giving the site a more modern and appealing look. - Add new pages & content: There are a few additional sections and content I need to integrate into the website. Your ability to seamlessly incorporate these additions is key to this project. - Improve the website's speed & load time: Website performance is vital, and I'm looking for you to optimize the site for faster speed and quick load times. Add-on: - Contact form: I would like a contact form to b...

...samples of your realistic characters you have made. You will need to show me how to use Wonder Studio and show my what apps or plugins are needed. The Robot must look great and look 100% real. The robot design must work perfectly with Wonder Studio to be overlaid over a real person in my videos. I will need daily updates of the design work so I can add my input if needed. You will need to help me load the finished character into my video on wonder studio and make sure it works perfectly. Key Requirements: - Realistic Style: The character must be designed with a realistic style, suitable for high-quality animations. - Animation: The character should be capable of performing various animations such as walking, talking, and interactive gestures, and work perfectly with Wonder S...

...natural and unaltered. - Shirt Replacement: The current shirt in the photo is not my preference. I'd like to replace it with a casual shirt. The replacement should be seamlessly integrated and look realistic. - Background Replacement: The current background is not suitable. I'd like a professional background, such as a solid color or an office-like setting. The new background should match the lighting and color tone of the rest of the image. Ideal candidates for this project should have: - Proven experience in photo retouching with a specific focus on facial and clothing elements. - A strong portfolio that demonstrates high-quality, natural-looking photo manipulations. - Ability to replace backgrounds seamlessly, ensuring the new setting looks realistic. If yo...

??? ?????: ????? ?????? ????????? (????-????, ??????) 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 ...

We know that Google Chrome no longer allows auto-play of a MP3 unless a user interacts with the page...meaning clicking a button or some other way. I have a Basic Time Out Page and wondering if I had 2 radio buttons: with a heading " Do you want to hear sound on next page load" Yes [] No [] Not sure even if that time out page on next page load would even auto-play Just looking for a working idea if anyone has done this with any success $10

I'm seeking a creative and experienced architect to design a small, efficient home in the style of tropical Thai Balinese. The design will incorporate non-load bearing Hempcrete blocks, ideally suited for the hot and humid conditions of the Thai countryside. Key Features: - Size: The footprint should be under 500 square feet, with a layout that maximizes space and functionality. - Kitchenette: A small, but fully functional outdoor kitchen - Outdoor Living: Expansive, usable outdoor living space. - Open Sky Bathroom: An outdoor bathroom with a shower area and tub, designed to be open to the sky. - No Garage: The design should not include a garage. - Open Concept: An open-plan layout with the kitchen, study, and two bedrooms. - Cooling: The home should utilize innovative cooling...

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.

1)Same as Shaun Bowler Body & Mind except 'where 'BODY & MIND' appears to replace those words with the words '& ASSOCIATES' - same font. Will need transparent, white, PNG, JPG etc. Same for the version that says 'A division of Bluefin Ltd'. Twitter and Linkedin Header versions - where it says 'PSYCHOLOGY | WORKPLACE WELLBEING' please replace with 'NZ's LOCAL GOVERNMENT RECRUITERS' -same font - both 32 characters. Also web header logo for website - needs to be not very high

I'm in need of a script that can load a list of proxies/ IPs and establish a rotating SSH tunnel connection through these proxies. The purpose of this is to maintain anonymity. Key Requirements: - The script should be designed for Windows OS and in exe or bat extension - It needs to handle failed connections by moving on to the next proxy in the list immediately - The script should interact with an OpenSSH server installed on my personal computer Ideal Skills: - Proficiency in scripting for Windows environments - Experience with creating and managing SSH tunnels - Understanding of proxy management and error handling The primary goal of this script is to ensure a seamless, rotating connection through proxies for anonymity. The ability to move on to the next proxy if the curre...

I'm looking for a skilled web designer who can provide HTML for our in-house web development and create a fresh, clean design for about six pages. The purpose of this project is to enhance our website's appearance and functionality. For more detailed information on the content and functionality that we're looking for, please re...content and functionality that we're looking for, please refer to www.sendaparcel.co.nz. Key responsibilities include: - Providing HTML for our in-house web development - Developing a clean and fresh design for six pages This project requires expertise in: - Web design - HTML development - Strong attention to detail and creativity we have built a freight portal but the current design is slow to load, we need this tweaked and subpag...