Export mysql excel using php jobs

I need a custom Windows executable program built that converts .pdf files into Excel (.xlsx) files. The program should take files from a pre-defined folder and leave the converted Excel files in the same location. Key requirements include: - The program should have no external inputs or outputs - Each PDF page should be converted to a separate Excel sheet - The program needs to only process files in the specified folder, with no need to process sub-folders Ideal candidates for this project would have a strong background in software development, specifically with expertise in Windows applications and file conversion programming. Experience with PDF layouts and Excel file structure will also be greatly beneficial. Experience with Python may be useful.

I'm seeking an experienced individual who can assist in formatting my Excel spreadsheets and creating informative charts/graphs. Specific tasks include: - Organizing existing data into cohesive tables - Crafting graphs to illustrate data points in an easily digestible format The data specifics were not provided but given its complexity, your experience in organizing diverse data types would be beneficial. Proficiency in Excel with a strong understanding of data analysis is expected. Your ability to present data in clear, comprehensive ways will be extremely valuable in this project.

...experience in the React ecosystem. They should also be well-versed in both node and mysql, as these will be crucial elements of the project. In their application, successful freelancers are encouraged to detail their prior experiences, particularly with regards to React-based projects. Knowledge of Redux, , and would be a plus, though not mandatory. However, strong proficiency in node and mysql is non-negotiable. Overall, I'm looking for someone who can provide a smooth hosting experience for my website, ensuring optimal functionality and user experience. The more experience you have in this area, the better. Ideal skills for the job: - Proficiency in React - Knowledge of Node and MySQL - Experience in website hosting - Problem-solving capab...

We are looking for an experience IT Recruiter to help IDENTIFY potential candidates to some of our roles in the Mexico Market. Principal profiles: -Software Developers (Java, Python, .Net, JS,) -Mobile developers (android, iOS) -Architects -QA (Automation tester, Manual tester) -Cloud ...-Cloud Engineers What you will be doing: -Linkedin Searches -Identify potential candidates -YOU DON'T NEED TO CONTACT OR SCREEN THE CANDIDATE -Work 10 vacancies per day -Present at least 10 candidates per job, per day (around 100 profiles per day) You won't be calling or screening or interviewing the candidates, just present the profile and we will do the rest. Your deliverables will be: -Word, Excel, PDF or text file, listing all the potential URL Linkedin profiles to each vacancy (...

I'm in urgent need of a WordPress and JavaScript expert to implement a new custom function on my website. The job entails debugging, fixing potential issues, and most importantly, adding our custom-desired function. You need to be adept at: - PHP and MySQL programming - Proficiency in WordPress (theme customization, plugin development) - Strong knowledge of JavaScript Timelines are critical for this project, as I have a specific deadline to meet. Hence, your responsiveness, reliability, and ability to work under time pressure will make a difference. Only seasoned WordPress coders with demonstrated experience in similar projects, please apply. Your bid should reflect your competence and ability to deliver within timelines.

I have a current single page HTML page () that requires modifications to align with a pre-existing design (screenshot). The final product should completely fill an A4 page when converted to PDF (using the export as PDF function within a browser), with the footer locked to the bottom of the page. Key Requirements: - Update design layout to match provided screenshot design - Ensure content fits into one A4 page - Footer must adhere to the bottom of the page in PDF Ideal skills for this job: - Proficiency in HTML, CSS, and Javascript - Detail-oriented with keen attention to layout design To make sure you have fully read and understood the requirements you will start your bid with the sentence: Yes, I have! Also make sure that you can start right away! And finally: this i...

**Project Description:** (Required knowledge of flutter and laravel, php ) We are seeking a skilled freelancer to undertake installation and modification services for the GroFresh project, available on Codecanyon ([GroFresh]()). Before proceeding, we kindly ask all interested parties to review the project's documentation ([Documentation]()) thoroughly. **Project Requirements:** 1. **Fix Country Code Issues:** Address country code inconsistencies in registration, login, forgot password, and other relevant pages. 2. **Checkout Page Modification:** Implement necessary modifications to enhance the checkout page functionality

More details: What is the purpose of the structures you want to build? Residential buildings How many different design variations do you want for the structures? One design What specific features are you looking for in your residential building's design? Glulam arches and connected roof

I am in need of an expert in any server-side language to review and fix my web scraping code, which recently stopped functioning. for NOW and must be fixed asap.

Objective: Upgrade an existing ETL process to enhance data validation, error handling, and user feedback for structured Excel files uploaded to SharePoint 2019, for subsequent transfer to a database. The solution could be also implemented via Azure Functions and Sharepoint online if deemed possible. Existing Setup: A basic ETL process developed with the Luigi library, lacking advanced validation and user feedback mechanisms. Solution uses parsing code (Pandas) for Excel files data parsing that can be utilized for the upgrade also. There are 4 different excel files, so 4 different parsers will be provided. The system should manage four unique Excel file types, each in its own SharePoint folder, requiring separate parsers for their distinct structures. An ini...

We are currently working on an oil and gas projet. We already prepared the loads on excel, prepared the 3D models, and the load combinations. We need an experienced engineer to add the loads, and the design of the structure.

...system's features should include capturing inputs from the website and storing the information directly into MySQL. Key Responsibilities: - Develop a Django system with capabilities to interact with SQL and MySQL databases - Display both numeric and textual data on the website - Implement features to capture user inputs directly from the website and store them in MySQL Design Aspects: - A minimalistic approach is preferred for project design for ease of navigation and user interaction - The design should also be clean and professional to affirm the project's credibility Ideal Skills and Qualifications: - Expertise in Django frameworks - Strong knowledge in integrating SQL and MySQL with Django - Proven experience in minimalistic and professional...

As an online business owner, I'm seeking a web designer with vast experience in user experience (UX) to perform various improvements on my existing website. Specifically, I require: - Navigation: The current layout needs a complete overhaul to make it more user-friendly and intuitive. - Page Loading Speed: My we...Page Loading Speed: My website needs to be optimized to ensure faster loading times for a better user experience. - Responsiveness: I need my website to be fully functional and responsive across different devices, from desktops to mobile phones. Although I don’t have specific examples of websites to emulate, I trust in your expertise and creativity to take my website to the next level. If you excel in creating fluid, intuitive, and fast-loading websites, this ...

I'm seeking a seasoned SQL developer with specialized skills in: - Database design - SQL query optimization - Data modeling Main tasks will include optimizing my existing MySQL database and modifying current queries. Proven experience in MySQL is crucial, and an ability to effectively optimize and streamline existing databases is required. Show me your magic touch in transforming my current setup into a well-optimized machine.

I'm seeking a proficient video editor capable of trimming a video so it is engaging, paced well, and under 5 minutes in duration. I have certain unnecessary parts in the video which need removal, and w...so it is engaging, paced well, and under 5 minutes in duration. I have certain unnecessary parts in the video which need removal, and want to highlight crucial moments. You must ensure there is no deterioration in video quality after editing. Key requirements: - Experience with editing videos, specifically in removing unwanted sections. - Skills in improving video pacing and flow. - Ability to export final product in MP4 format. - Zero compromise on video quality post-editing. This role best fits someone with a meticulous eye for detail and a passion for storytelling through...

...Python and JavaScript. Experience with for API integration and management. Strong problem-solving skills and the ability to adapt to changing requirements. Excellent teamwork and communication abilities. Technical Skills: Proficiency in Python, with experience in frameworks like Django or Flask. Knowledge in frontend technologies (JavaScript, HTML, CSS). Experience with databases (MySQL, PostgreSQL), version control (Git), and cloud platforms (AWS, Azure). Familiarity with multi-language support is an advantage. Additional Skills (Preferred): Background in AI and machine learning for enhancing bot functionalities. Experience in data analytics and dashboard creation for bot management. If you possess the necessary skills and experience for this project, please share examples of

I need a thorough scraping of seven websites, extracting both the text content, images, and links. Not a single element should be left...paragraphs, lists, everything. I'm not particularly choosy about the tech you use to get the job done, but it will need to be delivered in an Excel format. Ideal Skills: - Experienced in web scraping across various websites - Proficiency in using scraping tech and tools - Familiarity with Excel or similar data processing platforms - Strong attention to detail to ensure completeness of data extraction - Previous experience with large-scale data collection projects would be a bonus. Major kudos for managing data extraction projects involving multiple sites. Remember, the key here is thoroughness - I need every bit of data ext...

I am in need of an expert in any server-side language to review and fix my web scraping code, which recently stopped functioning. for NOW and must be fixed asap.

I am in need of an expert in any server-side language to review and fix my web scraping code, which recently stopped functioning. for NOW and must be fixed asap.

As an online business owner, I'm seeking a web designer with vast experience in user experience (UX) to perform various improvements on my existing website. Specifically, I require: - Navigation: The current layout needs a complete overhaul to make it more user-friendly and intuitive. - Page Loading Speed: My we...Page Loading Speed: My website needs to be optimized to ensure faster loading times for a better user experience. - Responsiveness: I need my website to be fully functional and responsive across different devices, from desktops to mobile phones. Although I don’t have specific examples of websites to emulate, I trust in your expertise and creativity to take my website to the next level. If you excel in creating fluid, intuitive, and fast-loading websites, this ...

Dear designers, We need a unique, stylish and clean company logo for a car dealership in The Netherlands named "Moss Automotive". This company will be working in the import and export of premium luxury cars. Please note that our target audience will be traders in high end cars from all over the world. The logo design must match our target audience. We don't have a specific design in mind and we want to see some nice and creative ideas from you. I will provide regular feedback and remove the designs we don't like to keep the entries clean. Please don't submit used logo's from generator AI tools. We need something unique designed from scratch. Please don't submit 3D entries with storefront or wall background. Just the logo in 2D please so we can ...

I am in need of a freelancer with excellent attention to detail to enter both text and numerical data from PDF files into an Excel sheet. The work involves: - Typing data from PDF files into Excel. - The Excel sheet has between 50 and 100 columns and rows. The perfect candidate will have: - Experience in data entry - Accurate typing skills - An excellent understanding of Excel - Previous experience with PDF to Excel data transfer. All information required for this project is contained in the PDF files. Accuracy and adherence to the format and structure are vital. This is a straightforward task, yet attention to detail is crucial.

Looking for a proficient developer skilled both in PHP and WordPress. The requirement includes: **Overview** Create a web portal using PHP and WordPress that facilitates hospital appointment bookings, integrates with WhatsApp Business, and provides essential features for patients, hospitals, and administrators. **User Roles** 1. **Patients**: - Can book appointments but can't view bookings or manage profiles. - Redirected from WhatsApp to the booking webview form or booking form. - WhatsApp Business integration: Pass phone number and name via API/Webhook. - Details (phone number, name, hospital, doctor, slot, amount, payment status, timestamp, etc.) stored in the database upon booking. - Payments via UPI. - Booking confirmation sent via ...

As notes project is running on 7.4 must have php 7 to be able to run it. Please submit your bid and how log. You can complete it. I m not gonna read a paraphraph from your bid. Keep it short and precise 1) on this page here http://localhost/4CornersERP/ i want to show a video that takes the full screen. when the user isnt logged in. you can use any mochup video or picture as space holders and i i will change the source after. Ina addition if possible, i want to be able to show our live youtube services when we have live services. I want to have the name in a heading phone and a paragraph centered at the bottom 2) about us page i want to use this as an example how they do it, but i want mine to look more mordern. I want to include a story about us, our plan our vision. here is a...

I'm in need of expert legal guidance to help me navigate through the complex process of ...As an international logistics company, I need to comply with a multitude of regulations. I'm looking for an individual or firm who can provide compliance advice in all areas - from transport regulations to import/export rules. The ideal candidate will have extensive experience in international law, particularly pertaining to the logistics industry, and have a deep understanding of regulatory compliance. Ability to seamlessly navigate and expedite the licensing process in various countries and regions is a must. An in-depth knowledge in the field of transport, import, and export regulations is also crucial. Proficiency in English communication both written and spoken is a pre...

Hello, I am seeking someone who is an expert in amazon EC2, mysql, laravel, web security and node.js. This project has several components. First off, I need you to upgrade my laravel website to the latest version and help harden the installation against vulnerabilities. Ideally I would like to incorporate some type of 2FA into the admin login area. Secondly, I also would like you to add rate limiting to the node installation for this website. My ideal candidate will have the following qualities: 1. You must clearly communicate in English 2. You need to be able to work independent once the task has been assigned. 3. You need to be a problem solver Please let me know what types of steps you would take to harden the laravel installation as part of your proposal. Looking forward...

I am on a mission to create a unique colour prediction website aimed primarily at the thrilling world of gambling games. I need a talented freelancer to develop this tool with the following: * A clear focus on predicting game outcomes by utilizing various colours. * A user-friendly interface that modern day gamblers can easily navigate and understand. * An inherent knowledge of the gaming industry is crucial to ensure the prediction tool is accurate and applicable. * Previous experience in developing similar prediction tools is a major plus. In addition, having a creative mindset while an analytical outlook will be beneficial to create a tool that matches the dynamic nature of gambling games. This is a grand opportunity for anyone skilled in game design, colour theory, and prediction alg...

I am seeking a talented and creative web designer to construct a modern E-commerce website for my business. The primary focus of the website is to sell our products or services directly. Key requirements I would like to have on the website include: - Comprehensible product listings - Efficient and secure shopping cart - Reliable payment gateway The ideal candidate for this job would be someone with: - A solid track record in web design, especially modern designs. - Experience in developing E-commerce websites. - Profound knowledge of shopping cart systems and payment gateways. - Ability to create unique and attractive product listings. With your help, I hope to seamlessly introduce our customer base to our online storefront. Let's create a modern and convenient shopping experienc...

I need a proficient Python programmer to generate code that scrapes text content and links from a specific government tender website (). Information to extract includes: - Headings - Paragraphs - Item...results page and individual tender pages. The website is I need to scrape all current and closed bids with the search term "school trips", along with all relevant information including but not limited to: - who won the bid - who bid for it - bid description - at how much - title of the bid - contact information of the teachers Finally, the data has to be updated into an Excel sheet. The ideal candidate for this job has experience in Python web scraping, understanding of data extraction, and knowledge of parsing diverse website structures.

I'm seeking collaboration with developers experienced in HTML, CSS, JS, PHP, and MySQL to create an intuitive, balanced, and user-friendly Project Manager system for personal use. The successful freelancer will need to design a modern, responsive interface that includes key features like a login page, note creation, calendar view, event creation for the calendar, task management, file manager, link management, and project management. Key requirements include: Successful creation of a system that can be easily deployed without root access Ability to run on any hosting service. Required skills: HTML, CSS, JavaScript, PHP, MySQL UI/UX Design Project Management Software Development Effective communication and problem-solving skills.

We are looking for a skilled developer to join our team and work on our RAGEMP server project. The ideal candidate should have strong skills in JavaScript, HTML, CSS, and MySQL, along with a basic understanding of game development concepts. Responsibilities: Develop and maintain scripts for our RAGEMP server Collaborate with the team to implement new features and functionalities Ensure the server runs smoothly and efficiently Requirements: Proficiency in JavaScript, HTML, CSS, and MySQL Basic knowledge of game development Ability to work independently and as part of a team Excellent problem-solving skills Payment: We offer competitive pay per script developed, with the potential for long-term collaboration. If you are passionate about game development and have the skills ...

...developer who can convert our Excel books into a MySQL-driven application. The software should include the following: - Search Functionality: The ability to quickly retrieve specific data from the database. - Data Import/Export: The capacity to smoothly import data from our current books to the application and export it when necessary. - User Access Levels: The system should differentiate user roles and permit each level to only access designated areas. In terms of security: - Basic authentication: A simple username/password login system. - Two-factor authentication: Additional security measure to verify users. - Role-based access control: Enhanced security to designate access based on role. A successful freelancer for this job should be proficient in ...

I am seeking a dedicated mid-level freelancer, who will be integral to my project. You must have 3-5 years of solid experience with the following technologies; ASP.NET MVC, Node.js, .NET, MySQL, Crystal Reports and AngularJs 1.5. I am also requiring your commitment to my project for long-term support. Key Requirements: - Proficiency in ASP.NET MVC, Node.js, and .NET. - Solid background in MySQL and Crystal Reports. - Able to work with AngularJs 1.5 - Mid-level (3-5 years) work-experience required. - Strong evidence of past experience. - Full-time commitment to the project. Only apply if you can dedicate yourself fully to this project and have ample experience in the mentioned technologies. Your application should clearly demonstrate your skills and commitment to this role...

I'm seeking an Excel expert who can proficiently extract and clean data from Microsoft SQL Server databases. Your skill set should ideally encompass: - Proficient knowledge of database extraction processes particularly from Microsoft SQL Server - Advanced Excel capabilities, particularly in data cleaning - Familiarity with data structures within databases You will be expected to apply your Excel knowledge to clean up the extracted database data and make it ready for further analysis. Previous experience with similar projects is preferred. This project will require excellent attention to detail, precision, and consistency. Familiarity with database manipulation and data extraction tools, in addition to Excel, is a plus. Looking forward to your applications...

I'm in search for a proficient PHP developer to assist with the development of an e-commerce website utilizing Shopify. The project entails not only constructing the website, but effectively integrating the necessary databases as well and utilizing custom PHP coding. Key Tasks: - Construct a user-friendly e-commerce website on Shopify platform - Ensure database integration for optimal functionality - Utilize custom PHP coding where necessary Ideal Skills and Experience: - Extensive experience in PHP development - Proficiency in Shopify website development - Strong knowledge in database integration - Proven expertise in e-commerce website construction - Excellent problem-solving abilities, attention to detail, and deadline-driven Your role in this proje...

I'm seeking a senior level associate/assistant auditor for financial and compliance auditing tasks. The ideal candidate should demonstrate: - Proficiency with Excel for auditing tasks - Ample experience in financial and compliance auditing - Strong analytical, and communication skills - Familiarity with local audit regulations and standards - Experience performing audits in the country (Zimbabwe) Possession of relevant qualifications and previous experience in a similar role is essential.

...conservation, and inelastic collisions in 2D - Experience with Pygame is highly desirable. - Presentation of the theory and small examples of collisions using pygame in Jupyter Notebook following these steps: 1) Introduce the equations (listed below) 2) explain the lost cinetic energy in each example by showing the variation of the volume of collisions sound in each situation (bigger loss of cinetic energy = bigger sound of crash) E_k = ½ mv^2 3) explain that the images of the cars DONT deform during collision (the loss of cinetic energy is transformed ONLY TO sound energy). 4) Show a basic example of car-to-car collisions (moving forward) and explain using supporting diagrams (animation) 5) Show a basic example of car-to-car collisions (both cars reversing) and ex...

I am in need of a capable individual who can juggle a few tasks, nam...who can juggle a few tasks, namely copywriting, data entry, and account management. This position is open for only US. • Copywriting: The ideal candidate should be able to effectively write content for our website, product descriptions, and marketing material. Good command over the English language is crucial. • Data Entry: Accurate and efficient data input skills are required. Experience with Excel and other data entry platforms will be useful. • Account Management: The ability to efficiently manage and maintain client accounts is essential. Experience at an entry to intermediate level (0-5 years) in these tasks is required. Overall, I'm seeking a reliable, multi-tasker with a knack for w...

I require an AWS expert for the setup of Secure Socket Layer (SSL) on my EC2 instances and RDS databases, configuration of GIT and establishment of a Continuous Integration/Continuous Deployment (CI/CD) pipeline. Key Responsibilities: - Set up SSL on EC2 instances and RDS databases - Configure GIT - Establish a CI/CD ...of a Continuous Integration/Continuous Deployment (CI/CD) pipeline. Key Responsibilities: - Set up SSL on EC2 instances and RDS databases - Configure GIT - Establish a CI/CD pipeline Ideal Candidate: - Proficient in handling AWS services specifically EC2 and RDS - Well versed with Apache web server - Deep understanding of GIT - Familiarity with CI/CD pipelines - Strong experience in PHP, Laravel, MySQL Its a small task of 1 hour and hence I am willin...

...Skills and Knowledge: Frontend Development: Proficiency in HTML5, CSS3, and JavaScript for building responsive and visually appealing user interfaces. Backend Development: Expertise in server-side scripting languages such as Python, Node.js, or PHP, along with knowledge of databases like MySQL or MongoDB for managing product data and user accounts. E-commerce Platforms: Experience with e-commerce platforms like WooCommerce, Shopify, or Magento for setting up and managing online stores. Mobile App Development: Skills in mobile app development using frameworks like React Native or Flutter for building cross-platform applications compatible with iOS and Android devices. UI/UX Design: Understanding of user interface design principles and user experience optimizatio...

We are seeking a highly skilled and experienced Linkbuilder and Outreach Specialist to join our dynamic team. Qualifications: - At least 1 year of experience as a link builder. - English language proficiency of at least Intermediate (B1) level. - Ability to conduct business correspondence in English. - High productivity and responsibility. - Proficient in Google Spreadsheets and MS Excel at an advanced level (knowledge and ability to use formulas, filters, formatting). - Ability to quickly find required information independently. - Excellent knowledge of Ahrefs, SEMRush, and/or other web tools for backlink analysis (competitor analysis). - Ability to create specifications for content, as well as to check content for compliance with the specifications. Responsibilities: - Analysi...

For this project, I'm seeking a seasoned PHP Laravel developer with experience in both Android and iOS platform deployments. I have a specific design already in mind and will be providing all the necessary content. The primary functionality needed in this mobile application is the incorporation of in-app purchases. I bring the design and content; your job is to bring it alive. Ideal Skills: - Strong proficiency in PHP Laravel - Demonstrated experience in app development and deployment on both Google Play Store and Apple App Store - Good understanding of in-app purchase integration - Being able to work closely with me to implement the predefined design effectively. If you can offer commitment, technical expertise and a keen eye for details, let's connect. I h...

Cost minimization question using Excel

I am seeking a highly skilled Symphony PHP Developer with extensive experience in user authentication and database integration. The project necessitates a responsive design with a custom theme to ensure the best user-friendly experience. The selected freelancer should have: * Proficiency in developing responsive designs. * Skill in creating custom themes to fit the specific requirements of the project. * Deep knowledge of Symphony PHP, specifically in creating robust user authentication and seamless database integration. Note: At this point, there's no need for any third-party APIs or services integration into the project. Potential collaboration may further extend depending on the needs of the project. The perfect fit would be someone innovative, highly cooperative, a...

...a skilled Email Marketing Manager for an outreach campaign targeting venues, event managers, and entertainment agencies in the Netherlands, Belgium, Germany, and France. Your main task will be to build relationships with industry professionals so that they will invite us to perform. The person must possess: - A solid background in Lead Generation - Proficiency in managing and sorting data in Excel - Email Marketing Expertise - Exceptional English communication skills In your role, you will be: - Managing and measuring campaign effectiveness - Performing lead generation and following up Showcase your ability to extend a band’s reach and deepen industry connections by applying for this role. We need a dedicated professional who knows how to strike a chord with the right ...

...get a fully manageable system. More details will be provided. 8. Need to run in sub folder. Design requirements: 1. Fully responsive on 6” display 2. Desktop and smartphone responsiveness. 3. Pixel perfect design. Design examples for guidelines will be provided. Full vision will be provided before start of project. Minor changes and improvements will occur on the way if needed. Php, sql, html, css only. No backdoor connections No hidden code Full transparency of code No ownership over code/project for developer No tip No access to server No zip file No extra payments No delays over 10 days. No delays Need to run in sub folder. If no returning correspondence from developer for more than 24h the project will go to another developer. Live demon...

I urgently need a highly proficient PHP and .NET developer to build an advanced, feature-rich project. I am providing all the assets needed to complete the task. Some key points include: - Intensive development of advanced features with high-end sophistication. - Integration of all assets provided by myself into the project. Your skills and experiences should include: - Proficiency in both PHP and .NET programming languages. - Experience in creating high-end features and sophisticated solutions. - Aptitude for integrating a variety of provided assets into projects. Delivering this project in a timely manner will be crucial. Your ability to combine speed and quality while using both PHP and .NET will be highly valued. Location - Ahmedabad

For my project, I'm seeking a freelancer with strong competency in Power BI, Excel, and Power Automate, knowledgeable in data analysis from GA4. The main task would involve accurately pulling data from GA4, migrating it on to Power BI for a comprehensive analysis, and subsequently exporting it to Excel using Power Automate. Key Responsibilities: - Extract relevant metrics from GA4 to Power BI. - Focus on the analysis of the conversion rate data. - Proper utilization of Power Automate to export the final data to Excel. Ideal skills and experience: - Proficiency in Power BI and Power Automate - Comfortable with Google Analytics 4 (GA4) - Experience with conversion rate analysis and reporting - Proficient in Excel The ultimate goal of this p...

We have an API consisting of 8000 lines of code written in PHP that we would like to migrate from PHP 5.6 to PHP 8.x.

Need website changes in PHP laravel based application, I will provide website & cpanel logins Website: Changes: 1. Add XML Sitemap with auto crowl all pages. 2. On the blog posts, add keywords/tags sections change the Select All tags at time.