I would like the calendar to display the price using the data from the Excel document. This is part of the fixed price , in order to cover all the latest tables. Currently I am using PHP Excel, to migrate to MySQL if possible. MySQL 5.5 PHP 5.2 Basically: I want to display the captured data in XLS (Excel) to MySQL in calendar form. PS. if there is the necessary support, we can do this monthly PPS. For the test site , I can prepare it in the same server. ---------------------------------------------------------------- エクセルファイルのデータを使って料金をカレンダー表示したい。 料金を一部変えることは無く、最新のシートですべて上書きする。 現在はPHPExcelを使っている。 できればMySQLに移行したい。 MySQLは5.5 PHPは5.2 ・XLSをMySQLに取り込む ・取り込んだデータをカレンダー状に表示する 月を区切るためにエクセルになにか追記が必要な場合対応可能。 テストサイトは、同じサーバーで用意できます。
We are looking for a computer program that can take over some of the repetitive tasks we currently do manually. The program will primarily be used on Windows OS and should be capable of performing the following functions: - Automating data entry tasks - Organizing files efficiently - Managing emails effectively - Checking invoices to prevent double billing Ideal candidates for this project should have: - Experience in developing Windows-based automation software - A strong understanding of data entry, file organization, email management, and invoice checking processes - Proficiency in designing user-friendly interfaces - Ability to integrate error prevention mechanisms to ensure accuracy Your solution should help us streamline our work processes, reduce human error, and increase ...
I'm seeking a talented developer to fix an issue with gtag on my WordPress website. The specific problem is that gtag is not tracking website events as expected. Key Responsibilities: - Troubleshoot and rectify the gtag implementation for event tracking on a WordPress website. - Ensure that all events are being properly tracked and sent to Google Analytics for accurate data collection. Ideal Candidate: - Proficient in WordPress development with a deep understanding of gtag implementation. - Experienced in resolving tracking issues and ensuring data integrity in Google Analytics. - Familiar with debugging tools to identify and fix the gtag tracking issue effectively. I have previously attempted to address the problem by using a plugin for gtag integration...
* Please deliver a locally working (DDEV!) composer based installation of TYPO3 v12. * Use Bootstrap for Frontend! * You will receive a PSD file and 2 Font files * Page Template Header (see attached JPGs): ** main navi (should come from TYPO3 page tree), 2 levels, burger menu for mobile ** logo, Insta-Icon and red "bubble" can be hard coded in template * Page Template Footer ** hard coded button: "Jetzt Kontakt aufnehmen" with link to "contact" page in page tree ** hard coded link: "Impressum" with link to "impressum" page in page tree (hidden in menu) * Content Elements: ** Please style the "Text with media" appropriatly (see ""): Image, Headline etc ** Element "Card Group" to display a variable amount of E...
We need a one-page landing page for an IT-product created, if this works out well, we need help to create more landing pages. 1.) Make a design proposal of a one-page landing page site 2.) Create the design (with SEO in mind) in Wordpress with Divi or Maxiblocks (preferred), preferably populate with suitable free (usage rights) pictures. 3.) Possibly some minor design adjustment after we add our own data to the page. We want a static price for this. Thank you!
...candidate will be proficient in using ChatGPT, Shopify, research, copywriting, and various social media platforms to help us execute our comprehensive content and marketing plan. Responsibilities: -Content Creation and Management: -Develop and schedule daily posts for Instagram, TikTok, and Twitter. -Write weekly blog posts and newsletters. -Manage and create content for our YouTube channel, including weekly AMA (Ask Me Anything) sessions. Event Coordination: -Assist in organizing and promoting monthly influencer events -Engagement and Community Building: -Engage with followers and respond to comments and messages. -Organize and manage giveaways for followers Research and Analysis: -Conduct research on digital beauty trends and skincare ingredients. -Monitor and report ...
JUST Design only: I need a nonfunctional PHP or HTML form based on a concept I have. The form should be beautifully designed and should be able to toggle between light and dark modes. I only need the design. This form does not require a database. - The form should be designed to be versatile and multiple types of utility forms - The form should include various fields, including but not limited to Name, Email, Phone number, Address, and Message. - The form should be equipped to handle and incorporate different types of utility forms such as Contact form, Feedback form, Registration form, and Survey form. I will provide you with a mockup of the form; you will be tasked with transforming this concept into a functional form. Most have side admin panel Ideal Skills and Experien...
We are looking for a developer with a strong understanding of Ultimate Members, WooCommerce, Event Management, and Job Manager plugins, proficient in troubleshooting and enhancing WordPress-based websites. Tasks Include: • Fixing errors (e.g., missing error messages on content upload failures) • Developing new pages and forms • Enhancing the landing page • Optimizing website performance and security Must-Have Skills: - WordPress development and customizations - Experience with HTML, CSS, JavaScript, and PHP Strong problem-solving abilities Please send us your resume including the experiences you have. We are looking forward to meeting you.
Experienced Developer Needed for Live Video with Advanced Group Chat and Community Feature for Description: We are looking for an experienced developer to create and integrate a new feature into our existing news platform, Medunews.com. This feature will include a live video functionality with group chat, advanced community/group creation options, and a temporary email address blocking system. The design and structure of this new feature must align with the current design of our website, which is built using the CodeIgniter 4 framework and running on AlmaLinux v8.9.0. The web server is Nginx. Project Requirements: Live Video with Group Chat: Implement a live video streaming feature that allows users to broadcast and watch live videos. Integrate a real-time group chat system
I am in need of an imaginative and technically proficient after effects editor. The nature and style of the videos are not specified, so versatility and adaptability will be crucial in this role. I am looking for someone who can make a stage background with our logos for a sporting event open to your ideas - it will be for a bodybuilding event and need it to be unique for audience showcasing our logos ( reveal ) whilst playing nice and engaging background elements for visual / background behind athletes. The final deliverable should be crisp, engaging and clocking anywhere from 1 to 3 minutes ( show is about 3 hours and can loop ) , highlighting the most important aspects in a creative and concise manner. Skills Required: - Superior knowledge in After Effects - Ability ...
...000. Key Responsibilities: - Develop and implement robust safety measures addressing key anticipated issues including Crowd Control, Medical Emergencies, and Fire Hazards. - Review and approve all safety arrangements and plans prior, during and after the event, - Continuously monitor safety compliance during the event. - Quality control - Auditing and monitoring - Document management - Policy and procedures implementation - Other events safety related matters Skills and Experience Required: - Proven experience in large scale event safety management. - Expert knowledge of various safety threats and first-hand experience in planning for and mitigating these issues at events. - Excellent crisis and crowd control management skills. - Relevant qualifications in...
I'm seeking a skilled web developer to create a financial information website with features similar to forexfactory.com. The website will be designed with a modern and minimalist aesthetic. Key features include: - Live forums page: This will allow users to engage in financial discussions, share insights, and connect with other members of the community. - Economic calendar: We need a comprehensive economic calendar that notifies users of upcoming reports, events, and indicators that may impact the financial markets. We will need to find all the sources the main information comes from and scrape them using provided API's from the government sites that they provide usually. - SEC Insider Traders Page: This is a vital component of the website. It should include:...
Ενδιαφερόμαστε για την προώθηση ενός event το οποίο θα πραγματοποιηθεί τέλος Νοεμβρίου. Αναζητούμε social media expert που θα ασχοληθεί αποκλειστικά με την προώθηση του &sigma...
I need your help in listing approximately 2300 products from my eBay store to my website. Here's what I'm looking for: - **Product Listing**: You will be responsible for manually copying and pasting the product details from my eBay store to my website. This will include images, descriptions, prices, SKUs, etc. - **Category Structure**: I do not have a specific category structure in mind. You will be responsible for organizing the products in a logical and user-friendly manner on my website. Ideal freelancer for this job would have: - Strong attention to detail to ensure accurate data transfer. - Proficient in data entry and working with online platforms. - Good organizational skills to structure the products effectively. - Prior experience in eCommerce product listing w...
I'm looking for a skilled React developer who can help me create an e-commerce platform for my service-based business. Key Requirements: - E-Commerce Focus: The website will primarily sell services. - Payment Integration: I need a seamless, secure payment integration system to handle transactions. - Efficient Service Booking: While calendar scheduling is not a priority, the system should allow for easy booking of services and should be user-friendly. Ideal Skills and Experience: - Strong command of React for front-end development. - Experience in creating e-commerce platforms and integrating payment gateways. - Understanding of service booking functionalities in e-commerce context. If you're a developer with the right skills and eager to take on this project, I&#...
I'm looking for an exhaustive list of Australian gym owners, with a focus on capturing between 100 to 500 individual records. The data needed includes, but not limited to: - Owner's Email Address - Gym's Name - Gym's Website Ideal candidates for this job are experienced data miners and researchers. Having a good understanding of the Fitness industry would be beneficial. Strong attention to detail is paramount, ensuring accuracy in data collection and entry. Additionally, demonstrating respect for privacy laws and guidelines, including GDPR, is essential. Experience with spreadsheets and CRM systems would be advantageous. Gyms must be privately owned only, non franchise. Offer Personal Training. Boutique Exclude: Category - Fitness Equipment Category - Community He...
I own a company that host events in Europe. We are now looking for entry-level virtual assistant to join our team. The scope of work is: You need to install an app called Feeld , create a profile there using our instructions and chat with our potential event visitors using our selling script. All the data (photo, profile text, scripts) will be provided to you by us. No need to upload any personal details there. Before starting the job, we will provide you 3min long short test task. Apply if you are interested to be our VA for this role.
I'm in need of a skilled Laravel developer to create a QR scanner-enabled webpage. This webpage should be capable of updating a database based on the scanned QR code information. I'm not entirely sure whether an existing database can be used for this project, so your experience in setting up databases would be a plus. Key requirements and decisions to be made: - Setting up a Laravel project with QR scanner functionality - Integration of the scanner with a database to update it according to scanned QR codes - The system should handle multiple scans of the same QR code by the same user by ignoring subsequent scans - The primary action the system should take is a check-in/check-out registration process, triggered by the QR scan Ideal skills and expe...
Before you respond on Freelancer.com, please take a minute to read this document in full. There is no rush. Also view our "Client profile" before you bid. We are a reputed employer with excellent previous ratings. The chosen freelancer will receive positive feedback score and prompt payment. ----------------- About the subject ----------------------- This is a 3-hour project to create 3 videos which explain how to use a new software which we have created The deadline is sacred, we cannot extend the 3 hour timeline. ---------------- About the video ------------------- Video script: (See attached file - Video ) --------- Other details ------------------------- No voiceover is required. Generic background music is required, something light and peppy. Please bid ...
...to enhance my diesel performance workshop's social media presence. The goal is to keep my Instagram account engaging, showcasing our service quality, and attracting potential customers and build an engaging follower base. Key Responsibilities: - Develop a content (including themes for stories) calendar, considering a mix of vehicle showcases, before and after photos, and customer testimonials. The calendar should be designed for posts 2-3 times a week in a mix of reels and posts. The grid calendar should show a sample photos of what the post/reel cover should look like and a theme fot the post. The stories should be general ideas for daily stories (5 days per week) - Implement a balance between thematic content planning and random content. I am open to a mix o...
I have ongoing work related to our previous project 'Professional Event Poster Design'
I need a virtual assistant who can help me with a range of tasks, including administrative, research, and customer support tasks. The ideal candidate will work part-time and have great communication skills. Key Tasks: - Help with administrative tasks: This includes managing my calendar, setting up meetings, and handling basic bookkeeping. - Conducting Research: I need someone who can gather information for me on topics that I provide. - Assisting with Customer Support: You will need to handle customer inquiries and provide basic support. Communication is key for this role, so I need someone who is comfortable with various communication channels. I expect you to be responsive to emails, phone calls, and instant messages. Ideal Skills and Experience: - Proven experience as a virtua...
I need a Google Sheet that will serve as a simple database for my business. Here's what I need: - Data entry and storage: This is the primary function of the sheet. My team will need to manually input data into the sheet on a regular basis. The sheet should be well-organized to easily accommodate new entries without compromising the existing data. - Access control: Only I, as the owner, should have the permission to edit the sheet. It's important that this access control is robust to maintain data integrity and security. I'm seeking a freelancer who is proficient in Google Sheets and can deliver a simple, user-friendly, and secure solution for this project. Experience in data management, user access control, and business data storage would be a plus. Your bi...
wordpress site with home - 4 more tabs and contact page
I need a seasoned designer to create a modern and sleek pitch deck for my upcoming event. The purpose of this pitch deck is to attract potential investors. - The ideal candidate should: - Have prior experience in designing pitch decks - Be proficient in creating professional and modern designs - Have experience in incorporating financial projections and market analysis into a visual format - Be able to translate complex data into visually appealing infographics - Be able to adhere to strict timelines and deliver quality work within the given timeframe The pitch deck should include: - Financial Projections: This should clearly and effectively present the financial outlook of the event, making it appealing to potential investors. - Market Analysis: A co...
I am looking for a skilled designer to create a poster and matching return card for a dinner. Wording is attached. The poster size should be 8 1/2 x 5 1/2 and the attached card should be 5 1/2 x 4 1/4. Also attached are some of our previous designs which you can use for inspiration. Please create a new look for this year. Ideal skills and experience for this job include: - Proficiency in graphic design software - Experience in creating posters for formal events - Ability to work with custom sizes and formats - Strong attention to detail and an eye for design aesthetics If you think you have the skills and experience needed to create a stunning poster for my event, please submit your proposal. I look forward to seeing what you can come up with!
...venues for a variety of events including weddings, corporate events, and concerts. The venues should accommodate up to 50 guests. Essential requirements for the job include: - Extensive knowledge of available venues suitable for a range of events - Excellent negotiation skills for getting the best booking rates - An understanding of the logistical requirements for each event type Candidates with experience in event planning, venue sourcing or a related field will be highly regarded. It's crucial that you are detail-oriented – I need someone who will consider all variables to select the perfect venue. You'll be paid a percentage of what the booking fee is. I'm looking for acoustic bookings socials: Tik Tok:codylanemusic04 Insta: Excited to witn...
Create a PDF and Excel exporter download for both tabs Specifications and Questions (8hours) (160 USD) Layout for the mains page (4 hours) (80 USD) Documentations (1 hour) (20 USD) Plugins (16 USD Excel) you will buy directly from Bubble in your account Plugin (100 USD PDF) there is al alternative plugin (20 USD)you will buy directly from Bubble in your account
Before you respond on Freelancer.com, please take a minute to read this document in full. There is no rush. Also view our "Client profile" before you bid. We are a reputed employer with excellent previous ratings. The chosen freelancer will receive positive feedback score and prompt payment. ----------------- About the subject ----------------------- This is a 4-hour project to create a 30-second to 1-minute video (time can be slightly more or less, it is up to your judgment when making the video) The deadline is sacred, we cannot extend the 4 hour timeline. ---------------- About the video ------------------- Video script: (See attached file - video ) Platform brief (see attached Powerpoint presentation) --------- Other details ------------------------- No voice...
...awareness among general consumers. Key Responsibilities: - Strategizing, planning, and executing PR campaigns across different platforms, including social media, traditional media, and through event sponsorship. - Building a positive image of our brand and fostering a strong relationship with general consumers. Ideal Skills: - PR Management - Social Media Marketing - Crisis Management - Event Sponsoring - Media Relations Your proven skills and experience in PR strategies targeted at general consumers will be crucial. Expertise in various platforms, especially social media, traditional media, and event sponsorship is essential. The ideal candidate should possess significant experience in managing PR in diverse environments and a track record of improving...
Before you respond on Freelancer.com, please take a minute to read this document in full. There is no rush. Also view our "Client profile" before you bid. We are a reputed employer with excellent previous ratings. The chosen freelancer will receive positive feedback score and prompt payment. ----------------- About the subject ----------------------- This is a 4-hour project to create a 30-second to 1-minute video (time can be slightly more or less, it is up to your judgment when making the video) The deadline is sacred, we cannot extend the 4 hour timeline. ---------------- About the video ------------------- Video script: (See attached file - video ) --------- Other details ------------------------- No voiceover is required. Generic background music is require...
I'm creating a personal prom short film and require a filmmaker that can create a pre-prom montage focusing on family and relationship. In this short social media film, a distinctive scene needs to be included featuring my friends and taking group photos. It’s important to capture not just the final pose but a mixture of both the process of taking photos and the final image. Consequently, the freelancer ideally should have experience with event-based filmmaking, specifically capturing candid moments and cool editing into an instagram video. Proven ability to tell a clear and compelling visual narrative is required.
Before you respond on Freelancer.com, please take a minute to read this document in full. There is no rush. Also view our "Client profile" before you bid. We are a reputed employer with excellent previous ratings. The chosen freelancer will receive positive feedback score and prompt payment. ----------------- About the subject ----------------------- This is a 4-hour project to create a 30-second to 1-minute video (time can be slightly more or less, it is up to your judgment when making the video) The deadline is sacred, we cannot extend the 4 hour timeline. ---------------- About the video ------------------- Video script: (See attached file - video ) --------- Other details ------------------------- No voiceover is required. Generic background music is require...
I'm looking for a skilled developer to create a custom appointment booking system, akin to popular solutions like Amelia, Bookingpress, or Calendly, using Svelte or Sveltekit. I do not have any fixed budget in mind, if you can provide quality we can adjust the budget accordingly. Key Features: - Online appointment scheduling - Seamless calendar integration - Automated reminders - Page creation Users: The system will cater to three distinct user types: - Customers: Those looking to book appointments - Service Providers: Entities offering services and managing their availability - Administrators: Responsible for overall system management Appointment Booking: - The primary booking method will be through a dedicated website. Ideal Skills & Experience: - Proficiency ...
I'm in need of a skilled web developer who's proficient in HTML/CSS and JavaScript. I require the person to be Australian based The main tasks include: - **Interactive Forms Implementation:** The developer should be able to create interactive forms that are user-friendly and smoothly integrate with our current web page. This will involve a combination of design and programming skills to ensure a seamless user experience. - **Shopify Linking for Event Ticketing:** The main function that needs to be implemented is a robust ticket sales tracking system. This will involve setting up a connection between our web page and Shopify, ensuring that ticket sales data is accurately tracked and reported. Ideal skills and experience for this project include: - Proficiency in...
We at "A Song For You" are looking for a Wordpress and Divi pro for monthly updates for our website. Every month, we'll be needing new artists & posts added, our events info updated, and other tweaks & updates to be made current. This is an ongoing project and would ideally suit someone who is passionate about the arts since we're a nonprofit in that niche working at the intersection of music and service. This is an ongoing role, but to start only about 2 hours a month of work will be required. Key tasks include: --Monthly updates - publishing blog posts - Updating event data and artist roster as well as hospital listings --Connecting socials with website A solid understanding and proficiency in Wordpress and Divi is necessary for this...
...seeking a skilled developer to convert my existing PortVB Desktop App into an iOS/Mac Desktop App. It a small tool that runs on a Windows PC and reads some flat XML files and inserts/updates a mySQL database. We need the same program to be able run on a iOS/Mac desktop. I have all the VB Project files/ Source code. - Skills in app development for iOS/Mac, ideally with previous experience in app conversion - Knowledge of data syncing, user authentication, and offline access, in case these features need to be incorporated - Familiarity with contacts management, communication, scheduling, calendar integration, and file/document management functionalities for potential focus areas - Creative design skills to potentially revamp the user interface and overall design of t...
I'm in need of an office assistant residing in Pune who can support me with managing emails, scheduling appointments, and help in daily activities. The role will require 50 hours of work per week. Key responsibilities: - Responding to emails and managing my inbox - Scheduling appointments and managing my calendar - Assisting in daily activities and other office related tasks as needed The ideal candidate for this role will have: - Proven experience in managing emails and scheduling - Proficiency in Microsoft Office suite - Strong organizational skills - Previous experience in customer service would be a plus Candidate has to be from Pune, India Your ability to prioritize tasks, communicate efficiently, and maintain a high level of confidentiality will be critical for this ...
We are seeking an experienced developer or team to create a comprehensive web software and database system for the remote monitoring and control of cathodic protection stations (SKZ) equipped with TE-RCU control units. This project involves developing web applications, database design, and integration of communication modules for real-time data acquisition, SMS/GPRS control, and SCADA system interfacing. More details will be sent in private.
...across,1.2 down) with the word "Begin" in it. 2: Draw a rectangle with width 6 and height 2 at point (5.3 across,1.5 down) with the words "Find node that represents the itemset" in it. 3: Draw a line pointing from 1 to 2 I don't care how the definition works other than how general it is. The above is just to show what I mean. 1. You could provide the flowcharts that some app allows you to make manually. 2. You could provide what the attached 30 files (or a subset) show. 3. You could propose the capabilities as a specific spec for what the input text file contains. 4. You can make it a price depending of what it can do and list possibilities. 5. If there is an app that allows a TXT definition like what I am saying, then I would consider buying that, but ...
I'm looking for a talented individual who can help me develop an LLM text model which behaves like a virtual girlfriend. This text model must be engaging in intelligent dialogues with emotions and feelings. Here are the primary requirements for this project: - Create an AI-driven text model: I need a text model that is capable of engaging in intelligent dialogues. This means understanding context, providing relevant and meaningful responses, and exhibiting emotional intelligence. - Incorporate emotional responses: The text model should be capable of expressing emotions and feelings in a realistic manner. This is crucial for creating a believable and engaging virtual girlfriend. - The model can be trained from scratch or, if you have knowledge of current models, adapt it to you...
I'm looking for someone to help me create a list of 2000 business contacts from specific websites, particularly names, company names, position, location information, event information, number of events, current events, past events in 2024, and email addresses. I would like this list to be compiled through online research only. Key responsibilities: - Researching and compiling a list of business contacts - Ensuring all email addresses are verified and duplicates removed. Note: The focus should be on getting accurate, up-to-date information.
Looking for a short Video Clip, not longer than 10 Seconds. We need a perfect Transition to present our Shirt Design. You decide the Intro and create a perfect Transition to show our final Shirt in a final Sequence. Attached you will find the Design and the Shirt you can usw for the Clip and final Outro ourLogo. If you need any Sequenze with the Shirt, just let us know, we try to create it. LONG TERM JOB CONTRACT IS POSSIBLE . Here are a few Ideas: 1. Turbocharger Transition Description: The image of a turbocharger appears as if it is being shot out of a vehicle. The turbocharger spins, and as it rotates, it transforms into the final image on the shirt. Animation: A fast, rotating motion that simulates a "boost" effect, transitioning the graphic from blu...
...awareness among general consumers. Key Responsibilities: - Strategizing, planning, and executing PR campaigns across different platforms, including social media, traditional media, and through event sponsorship. - Building a positive image of our brand and fostering a strong relationship with general consumers. Ideal Skills: - PR Management - Social Media Marketing - Crisis Management - Event Sponsoring - Media Relations Your proven skills and experience in PR strategies targeted at general consumers will be crucial. Expertise in various platforms, especially social media, traditional media, and event sponsorship is essential. The ideal candidate should possess significant experience in managing PR in diverse environments and a track record of improvin...
...who can help create a user-friendly website to promote my business. The business revolves around organizing and promoting various types of events, including business conferences, social gatherings, and live performances. Key Requirements: - Aesthetic appeal: The website should have an attractive layout, capable of engaging visitors and driving attendance for our events. - User-friendly interface: Ease of navigation is crucial. Visitors should find it easy to explore our upcoming events. - Robust features: The website should enable promotional activities such as ticket sales, event schedules, event descriptions, and a gallery for previous events. Required Skills: - Experienced in web development and design - Proficiency in using CMS tools and SEO - Experience in w...
I'm seeking a freelancer with skills in either ESP8266 or ESP-NOW. The project involves integrating a reed switch and relay with two ESP8266(D1 Mini) devices. There's one transmitter and a gateway that communicates with a local Mosquitto. Here...skills in either ESP8266 or ESP-NOW. The project involves integrating a reed switch and relay with two ESP8266(D1 Mini) devices. There's one transmitter and a gateway that communicates with a local Mosquitto. Here's what you'll mainly be doing: - Setting up the reed switch to trigger an event. - Ensuring that event sends a message via the gateway to Mosquitto. Experience with IoT technologies, particularly reed switches, relays, mosquitto and wireless communications would be ideal. A good understanding of ...
I'm in need of a modern logo that will represent my event decorating company based in sunny South Florida. THE NAME IS “BOUNCE N’ PARTY” - Specializes in birthday and corporate events - The logo should exude a modern aesthetic - Avoid any childish imagery - Open to having subtle hints of pink - The logo should be versatile enough to be used across various mediums and sizes No water colors Submit ICON, no abstract features Vibrant but not childish
We need a page design with picker wheels like this
Idea is to be able to manage my current users in my dev cluster, most of them have cloudadmin permissions, idea is to have a whitelist of users, I will be providing you access to my API Keys and repo for this, also the whitelist based on the users email, I am using azure devops to do CI-CD Tasks, idea is to create a yaml file pipeline able tu run this process everyday at midnight.
