Protect word document using access databaseроботи
I'm looking for a knowledgeable professional to create a potent sponsorship presentation aimed specifically at corporate sponsors. The primary mission of this presentation will be to attract and engage potential sponsors. Substantial knowledge of corporate demographics is essential as you will need to effectively demonstrate that sponsors will have access to a particular audience demographic. Your presentation should highlight this value proposition compellingly and convincingly. Ideal Skills: - Experience in corporate sponsorship acquisition - Proficiency in presentation creation - Familiarity with audience demographic analysis - Strong persuasive skills
I'm urgently in need of a skilled professional who can swiftly deploy a database server for me. Key Responsibilities: - Establishing a server primarily intended for databases - Choosing the suitable database management system (DBMS) Ideal Competencies: - Extensive experience with multiple DBMSs as I'm not yet decided on which one to use - Ability to work under pressure and deliver swiftly since the project is urgent - Prior experience with server deployments will be highly advantageous.
I require a proficient developer with expertise in Laravel PHP to translate a Figma design into a fully functional HTML document. The design is already completed and responsive, so your primary task is to implement it accurately. You will need to pay attention to every detail, ensuring a pixel-perfect representation of the original design. Major components of this project include: - Implementing all functionality from the Figma document. This encompasses a range of interactive features, animation effects, and form validation. - Integrating a login/admin panel. The code for this is ready but may require some minor modifications. Your responsibility is to seamlessly include it in the project. Ideal candidates should have: - Proficiency in Laravel PHP. - Strong experience in ...
I’m experiencing a persistent issue with lagging or delayed replication in my SQL Server database. The primary problem revolves around the replication process not effectively happening in a timely fashion. Ideal Skills-needed: - Solid skills in SQL Server management - Proficient understanding of database replication processes - Excellent problem-solving and diagnostic abilities in the context of database administration The ideal freelancer for this project will be able to not only identify the source of this issue but will provide a solution to improve the replication time. It's crucial that you have managed SQL Server databases before, ideally in a high-transaction environment, and have a deep understanding of data replication.
...responsive and able to adapt well to various screen sizes on Android and iOS mobile devices, both smartphones and tablets. 4. System Integration a. The application must be able to integrate with existing systems at [redacted] such as Single Sign-On (SSO) and Document Management System. 5. Security and Privacy a. The application must comply with ISO 27001:2022 security standards and ensure data security when transmitted and stored. b. User authentication and access authorization must be implemented to ensure that only authorized users can access sensitive information. 6. Performance and Efficiency a. The application must have fast and responsive performance, especially in loading AR visualization data and processing equipment information in real-time. b. Perform...
...thorough pre-employment vetting process for our prospective employees in Zweibrücken, Germany. Your primary tasks will include: - Background Checks: This will involve digging deep into the candidate's history to ensure they are suitable for the role and our organization. - Reference Checks: You'll be responsible for verifying the provided references to ensure their authenticity and relevance. - Document Verification: It's crucial that you validate the documents provided by the candidates, especially their employment certificates. It's important to note that I only require the employment certificate from the candidates at this stage. The details are up to you to decide the most relevant parts for our vetting process. Your ability to maintain confidential...
I'm in need of a skilled PDF editor that can oper...and Mac systems. Key Requirements: - Compatibility: The editor should be able to work effectively on Windows and Mac operating systems. - Text Editing: I prefer a separate text editing panel for this task. - Additional Features: In addition to the standard functions, I'm particularly interested in the following features: - Ability to insert my own logo into the document. - Ability to insert my own text into the document. I'm open to recommendations on other features that might be useful, however, these are the core requirements for the project. Ideal Skills: - Proficiency in PDF editors and their features. - Experience in working with both Windows and Mac systems. - Ability to implement custom t...
Responsibilities • Gathering data from one source ( Drive) to enter into document management (databases or partner websites by case) • Checking and reviewing documents for accuracy and completion • Attaching supporting files to the document management • Searching for additional information for documents that are incomplete • Verifying, correct, and delete unnecessary data, or combine data The requirements for the applicant include strong attention to details, college degree, access to email and knowledge of use a device (computer or phone), basic software tools Office - Word & Excel). Candidates should live in Europe , North America and / or South America
I require a professional with a keen eye for detail to verify the job title and positions on employment documents. While there's no specific industry or job field to focus on, you'll be verifying documents from various s...require a professional with a keen eye for detail to verify the job title and positions on employment documents. While there's no specific industry or job field to focus on, you'll be verifying documents from various sectors. Ideal skills and experience: - Experience in document verification processes - Familiarity with various professional job titles and positions - Excellent attention to detail and accuracy - Strong organizational skills No specific industry knowledge is needed- this task is solely focused on document verificatio...
...of an Access database that can primarily handle generating reports and analytics. The main goal is to keep track of internal data for further analysis and reporting. Key Features and Functions: - **Reports & Analytics:** The database should have the capacity to generate comprehensive and insightful reports from the data gathered. It's crucial that these reports are insightful and easy to understand. - **Data Tracking:** The database will be used for tracking internal data. This needs to be done with precision and the ability to link data for comprehensive tracking. - **Data Input & Updates:** The system should allow for easy input of data and updating when needed. This will facilitate the generation of accurate and updated reports. Ideal Ski...
I need a seasoned MS Office expert who can assist me with crafting and formatting documents on Word and PowerPoint. The task involves: - Creating and formatting documents - Ensuring a consistent and professional design throughout Ideal candidates should: - Have extensive experience with MS Word and PowerPoint - Be proficient in document formatting - Possess an eye for design and aesthetics - Demonstrate the ability to follow corporate branding guidelines If you have the right skills and can step in to manage the formatting and design needs of my documents, please get in touch. I look forward to hearing from you.
...design is essential. Reference : Key Features: - User Registration and Login: Users should be able to create accounts and access the site - Flashcard Creation and Management: I will be creating the flashcards as admin and uploading them - Stripe Payment Integration: For premium features, I'd like to incorporate a payment system using Stripe Ideal Skills: - Proficiency in web development and design, with a focus on user experience - Prior experience with the integration of payment systems like Stripe - Understanding of interactive learning platforms or similar projects IMPORTANT : Please mention the tech stack you will be using. I dont want anything complicated. Just a simple flask backend with react frontend will do. Or if you have any better ideas let me ...
...user interactivity. Key features: - **Streaming Videos**: Your primary task will be to implement a robust streaming system. This includes ensuring that the videos are accessible to users in a smooth and seamless manner. - **User Registration and Login**: The duplicate site should offer a secure, user-friendly registration and login process. Users should be able to create accounts and log in to access content. - **Design and Layout** The website will be a carbon copy of the original website - just streaming under a new URL Content Management: - **Automatic Sync**: The duplicate site should be able to automatically pull in content updates from the original website. This is imperative for keeping the content on the duplicate site up-to-date. Ideal skills for this job include e...
...program that can fetch player profiles as images from CricHeroes and store them into a folder. The ID and profile link of these players will be provided in a JSON array. Here is what the program needs to accomplish: - The program must be able to crawl the given links and fetch the profile images. - If a player's profile link is no longer accessible or can't be crawled, the program should attempt to access the link again at a later time. - The images should be saved in a standard resolution PNG format. - In the case of duplicates, the program should overwrite the existing image with the new one. The ideal candidate for this project is proficient in Python, web crawling, and working with JSON arrays. Knowledge in image handling and error management is also necessary. e...
...Implementation of an IP rotation strategy to prevent blocking by ISPs. Automatic rotation of IP addresses based on various criteria, such as delivery rates or number of sending attempts. Utilization of more than 20++ IP addresses to ensure continuous email deliverability. Additional Requirements: The solution must be scalable to accommodate a larger volume of emails. The solution must be secure and protect against spammers and hackers. The solution must be user-friendly and easy to use. Expected Outcomes: Upon completion of development, this solution is expected to enable the sending of large volumes of emails with high delivery rates and minimal risk of being blocked by ISPs. The solution will also provide the user with the ability to track and optimize the performance of thei...
I am looking for English Typing, Formatting, Correction - PDF to Word File conversion experts. I need only Indian freelancer who is also fluent English speaker. You have to do the work manually and accurately. I need high-quality and accurate services.
...to continue development on existing web application! The specific Task - Requirements Document will be provided. Project will be developed by Phases(milestones). Selected team will be having opportunity to work for long term! Skills and Experience: - Extensive experience in Laravel development - Proficiency in Laravel customization and optimization - Strong understanding of Gitlab - version control !* - Strong understanding of web development principles and best practices - Ability to work on a large-scale project and deliver high-quality results - Excellent problem-solving skills and attention to detail - Database Design & Management: The ability to design and manage a highly organized, efficient database is crucial. Skills that would be beneficial: - Thorou...
I'm leading the development of a cutting-edge video streaming app using Flutter. Our aim is to provide users with a seamless entertainment experience, offering a wide range of content including novels, series, and movies. Key Responsibilities: As the Backend Developer for this project you will: 1. Design and develop scalable server-side applications. 2. Implement robust APIs for seamless communication with the Flutter client. 3. Integrate third-party services to enhance platform features. 4. Manage data storage solutions and optimize database performance. 5. Ensure server-side code is optimized for performance and reliability. 6. Implement security measures to protect user data. Requirements: To excel in this role, you should: 1. Have proven ba...
I'm urgently looking for an expert in Optical Character Recognition (OCR) to automate the conversion of scanned PDFs into editable Google Documents. This demands precision as high accuracy is critical for the output. Key skills and experience include: - Extensive background in OCR technology - Google Docs API - Proven ability...accuracy is critical for the output. Key skills and experience include: - Extensive background in OCR technology - Google Docs API - Proven ability to deliver OCR projects with high-accuracy outputs Remember, Speed is of the essence as I require this project completed ASAP. Your commitment to both accuracy and efficiency will be highly valued. Detailed requirement:
? Seeking Participants for a Focus Group Survey and WhatsApp Activity! ? Are you a user of Associates Management Software? We're looking for participants to join our upcoming focus group survey and 5-day WhatsApp group activity! Activitie...and experiences with Associates Management Software. -WhatsApp Group Activity: Engage in daily 10-minute discussions on WhatsApp over 5 days. Requirements: Current user of Associates Management Software (examples include): -SAP SuccessFactors -Oracle HCM Cloud -Workday HCM -BambooHR -Namely -ADP Workforce Now -Paycor -Zenefits -Able to commit to the full duration of both activities. -Must have access to WhatsApp. Benefits: Compensation: RM 150 upon completion of both activities. Opportunity to directly influence software development an...
Need to open port 25 and 53 using VPN.
I am in need of a skilled professional, capable of reorganizing my database of approximately 1,000 customers. To be specific: - The Excel database contains the following data field: Name, Email, Phone number, Address, City, and Country. - The organization should be done alphabetically by name. - The new Excel template format should have each field in a separate column. For this job, it'll be ideal if you possess exceptional Excel and data organization skills and have prior experience in Database Management. Efficiency in Excel, coupled with keen attention to detail, will aid in the successful completion of this task. Anyone with a seasoned approach to the task will be greatly appreciated.
...and upscaling resolution. The target audience will be broadly composed of videographers, content creators, and general users. Key Features: - The system should be capable of enhancing video quality, removing background noise, and upscaling resolution. - A clean, user-friendly interface, suitable for users of varying backgrounds. - A secure and seamless direct upload function for users to easily access the video enhancement services. - Efficient processing and turnaround time for enhancing videos. Ideal Skills and Experience: - Strong background in AI and machine learning, with a focus on video enhancement. - Experience in developing user-friendly and visually appealing websites. - Proficiency in secure direct upload functionality to handle large video files. - Understanding of...
I am seeking a well-versed Zabbix expert capable of setting up specific health checks on a JSON response, and able to provide documentation on how to replicate these settin...0", "id": null, "result": { "health_ok": true, "epoch_time": 1714458226.6386402, "date_time": "2024-04-30 06:23:46", "services": { "http_ok": true, "cron_ok": true } } An alert should be triggered in response to the 'false' status code specifically. Importantly, I need your proposed solutions to be documented in a Word Document format. This guide will be used to configure other hosts with the same JSON. In-depth awareness of...
I'm seeking an expert in AWS and Cloudflare to assist with the deployment of a SaaS-based software website. This role should primarily focus on facilitating an efficient hosting environment for the site w...primarily focus on facilitating an efficient hosting environment for the site with potential for scalability. Key responsibilities: - Set up of necessary AWS services; while I skipped the AWS services question, I'm open to recommendations based on your expertise. - Configuration and integration of Cloudflare CDN to ensure optimal site performance. - Ensuring secure and seamless data storage and access. Ideal freelancer should have: - Proven experience in AWS cloud deployment. - Familiarity with SaaS-based software structures. - Extensive knowledge of Cloudflare CDN ...
I'm looking for a proficient web developer to create a cutting-edge web app tailored for educational institutions. The main features of the app should revolve around seamless video communication between users. Key Features: - One-to-One Video Calling: Implementing a robust video calling functionality that can support both one-to-one sessions. - Live Chat: A real-time chat room integrated within the app for additional interaction. - Screen Sharing: Facilitating screen sharing among the participants. Customization Level: - The primary focus of this project is on basic video call functionality. No need for advanced features such as filters, effects, or custom backgrounds. The emphasis is on providing a stable, user-friendly video calling experience. Ideal Skills: - Proficiency in M...
I'm in need of a professional translator to help me with the translation of 4 pages of a Balance Sheet from English to European Spanish. The document is related to finance so prior experience with financial terminology is a must. Key Requirements: - Industry Experience: You should have a background in finance or accounting to accurately translate these terms. - Language skills: A native Spanish speaker or someone with equivalent proficiency in European Spanish would be ideal. - Accuracy: The translation must be precise and true to the original content. - Confidentiality: The document contains sensitive financial information, so I need someone who can maintain confidentiality and privacy. If you have previous experience with financial translation, please include detail...
I want to integrate Flutter website and create the UI design of a website. The website application is created in Flutter web and uses Firebase services for APIs. So this backend Flu...created in flutter (backend, that we have already created), with the design you created and the website will be ready to go. The stripe payment method must also be implemented. When the user wants to access the some pages/button, they must receive a subscription message. I still need a separate page, something similar to announcements or a blog, where it will be easy for me to add different texts, announcements. This page must be easy to write in, so that I don't have to add lines of code. The user must register with a username and password, and after making the payment, he will receive acce...
I am looking for a talented freelancer to help me create an online job platform. This platform will cater to both freelance and part-time job opportunities. Key Requirements: - **User Account Creation**: I want users to be able to create accounts in order to access the full functions of the platform. - **Direct Communication Tools**: The primary feature of the platform is direct communication tools. I want users to be able to interact with potential employers or employees seamlessly. Ideal Skills and Experience: - Experience in web development, particularly in creating user account systems - Proficiency in creating direct communication tools within a web platform - Understanding of the freelance and part-time job market is a plus
...My current solution for managing workflow (job status, assigning photographers, accounting for payouts) is done through Google Sheets. I'd like to explore the potential of Airtable (and possibly other platforms) as a replacement. Objective 1 Consolidated Spreadsheet/Database. I currently use a spreadsheet (Google Sheets) for each photographer when assigning jobs. This requires excessive data movement and tracking. If feasible, I'd like to construct a spreadsheet/database where all the data is consolidated. Access by users (photographers) will be confined to the jobs they are assigned. Ideally, a more centralized and manageable solution can be put in place for assigning, tracking, and making payments on jobs. Objective 2 Automate the Job Creat...
...executives' names, etc. • Take pictures of the subject company and its vicinity, as per Confirmis’ standard operating guidelines. • Provide observation about the company to gauge activeness, e.g., staff working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) San Salvador, El Salvador • Has a camera or phone/tablet of quality with a camera, internet access • Must be available during business hours (9 AM - 4 PM) on working days Please see the attached file for the site visit guidelines. You are only required to deliver the pictures, video & observations and are not expected to put together a report like the Sample Report. Note: Milestone will be released the following week after the site visi...
...to continue development on existing web application! The specific Task - Requirements Document will be provided. Project will be developed by Phases(milestones). Selected team will be having opportunity to work for long term! Skills and Experience: - Extensive experience in Laravel development - Proficiency in Laravel customization and optimization - Strong understanding of Gitlab - version control !* - Strong understanding of web development principles and best practices - Ability to work on a large-scale project and deliver high-quality results - Excellent problem-solving skills and attention to detail - Database Design & Management: The ability to design and manage a highly organized, efficient database is crucial. Skills that would be beneficial: - Thorou...
...enhancements, and updates for my client's Magento Enterprise Edition (also called Adobe Commerce) website. - The website is on a Magento Enterprise license on Cloud, with Development/Staging server as well. All Magento vendors files are uneditable, codes can be updated from GitHub. - The inventory is synced with a CRM called Navision. - You will need to setup the system on your own local. - All access will be provided: production, staging, cloud, etc. Key responsibilities: - Ensuring the smooth operation of the site. - Regular maintenance and updates. - Immediate bug fixes and touch-ups as required. Ideal Candidate: - Proficient in Magento Enterprise/ Adobe Commerce. - Strong experience with Magento Enterprise development - Experience in consistent troubleshooting and pl...
I am in need...page in draft word document. Key Tasks: - Review and enhance current Industry Policy content. - Ensure the language, tone, format, and flow of the document is coherent, precise, and informative. - Emulate the whole document based on model content pages 1 - 4. Pg 6 - pg.14 is in table format and needs to be rewritten to be the same as pg.4. Ideal Candidate will: - Have great writing skills and testimonials * Have prior experience in policy writing. * Have excellent proofreading and copyediting skills. * Have experience in writing and editing policy documents. This project will require a well-experienced individual who can deliver quality and professional work in a timely manner. I am looking forward to see your bids and expertise to bring ...
I'm in need of a skilled developer to build a custom ecommerce platform for me, with a special emphasis on AI integration. The key features and requirements for this project include: - User Interface: I envision the user interface to be minimalist and clean. The design should be intuitive, user-friendly, and mobile-responsive. Ideal candidates for this project should have experience...and clean. The design should be intuitive, user-friendly, and mobile-responsive. Ideal candidates for this project should have experience in ecommerce platform development, a deep understanding of AI integration, and a strong portfolio showcasing similar projects. Please provide examples of your previous work and a detailed proposal outlining your approach to this project. Please see attached doc...
I have a task that requires merging data from two Microsoft Excel documents. Both documents contain contact information, but I need an expert to copy email addresses and phone numbers into the original document that includes names. This will create a comprehensive list of 900 contacts. I need US-based freelancers. Specifically, I'm looking for a professional who: - Is an expert in data entry - Has English as their first language for accuracy in handling personal contact information - Can handle the merging process efficiently and with high attention to detail - Can organize the merged data alphabetically based on names It's crucial that you're able to respect the confidentiality of the personal contact information in the documents. Experience in handling sensitive ...
I need someone to add a total of 50 bookmarks to my Word document. Essential Requirements: - Add 50 bookmarks to the document - create a excel; audit xls with 50 rows listing the bookmark name and the section text name (we use that as quality control and testing)
...configuration. The base of this configuration is , which will function as a Multitenancy CMS. Key attributes of the project: - The base website () needs to be accessed independently. - The secondary URL structure ({}) also needs to be independently accessed via its own domain (). Your role is to configure nginx to allow for domain access for website and also teach me how this is accomplished so that i can learn how to do this Ideal Skills: - Strong understanding of Nginx configurations - Previous experience setting up multi-tenancy website configurations - Strong knowledge of CMS, particularly relating to text-based content - Experience with domain setup and management. Please note, this project does not require any user management
I have a Google document that primarily consists of text and I need it converted into a Word file. The main reason for this conversion is to enable editing using Microsoft Word. The document has a certain style and formatting that I want to fully preserve during the conversion. Ideal Skills: - Knowledge of both Google Docs and Microsoft Word - Attention to detail - Expertise in converting and preserving formatting across platforms Experience: - Previous successful work in similar tasks - Proven experience in maintaining formatting while converting files.
I need a professional presentation created from a Word document. I have a document with key points and information, and I'm looking for a freelancer to turn this into a visually engaging, clear and effective presentation and add visually appealing and relevant images. Ideal skills and experience: - Experience in creating presentations - Ability to condense and highlight key points - Strong visual design skills - Familiarity with effective presentation techniques Please include past relevant work and a detailed project proposal in your application.
...Full Stack Web Developer to work on building and maintaining our web applications. The ideal candidate should have a strong command of both front-end and back-end technologies. Responsibilities: - Develop and implement user-facing features using front-end frameworks/libraries like React - Build and maintain server-side applications using programming languages such as Python, PHP, or Node.js - Design, develop, and optimize RESTful APIs and web services for data integration - Implement authentication and authorization mechanisms for secure user access - Work with SQL and NoSQL databases to build efficient data storage and retrieval systems - Collaborate with cross-functional teams to translate requirements into technical solutions - Perform testing, debugging, and o...
...looking for a WordPress Plugin that can implement a real-time chat system for a multi-vendor eCommerce platform. Key Features: - Real-time Chat: The primary functionality of the plugin should be to enable users to communicate directly with the vendors through a real-time chat interface. - File Sharing: The plugin should allow users to share files with vendors, facilitating communication and document exchange. - Logistic Enquiry: Users should be able to inquire about the logistics charges for their orders to the vendors within the chat interface. - Requesting Payment: Users should have the ability to request payment details or make payment requests to the vendors through the chat. - Creating Invoice: Vendors should be able to generate and send invoices to users within the chat f...
Hi Tanmay, Could you please follow this brief to add "Our People" section to each page as per brief. This is one of the websites you have created a while back.
I need an indicator that marks fractal ceilings and bottoms in 3 different temporalities, these zones being the high and low wicks of the impulse and also marking the break zone of the fractal as a horizontal line. If the budget fits, I will send a detailed explanatory document with images. 7:24
I'm looking for a skilled location scou...both indoor and outdoor settings for an upcoming film production. The film will be set in various rustic small towns, a high school track, a barn, and a farm. Your responsibilities will include: - Identifying and researching suitable locations based on the given criteria - Providing detailed information about the locations, including potential challenges - Negotiating with property owners for access and permits - Providing images and/or videos of the locations Ideal candidates should have: - Previous experience in location scouting - Excellent research and negotiation skills - Knowledge of local areas with rustic small towns - Ability to work within a budget Your expertise will be instrumental in creating the perfect ambiance for thi...
I'm looking for an expert with exceptional skills in Microsoft Access/Database, Excel, and VBA coding. The main focus of the project is on Access/Database, the specific tasks include: - Data Entry - Query Building - Database Design Ideally, I need someone who can efficiently handle a database containing 10-20 tables. You should be detail-oriented, experienced in managing medium-sized databases, and proficient in maximizing the functionality of Access. Excel expertise and VBA coding skills will also be highly valuable in this project. ONLY ACCEPT TASK IF YOU CAN DELIVER WITHIN 3 HOURS
I need a detailed consultancy proposal compiled - 3299 words 13 pages Seeking assistance with layout and document formatting, grammar and content editing Key Details: - The primary goal of this proposal is to provide a detailed plan for the consultancy project. - The proposal should encompass three key sections: 1. An Executive Summary, that includes the project goal and objectives, expected outcomes and the project timeline. 2. A comprehensive Project Description. 3. A detailed Budget Breakdown. Ideal Freelancer: - A professional with experience in consultancy proposal writing is highly preferred. - Understanding of the consultancy sector and the key components of a successful proposal is essential. - Strong communication skills to ensure the message is...
I'm seeking a skilled backend developer to assist with API development and integration with a MySQL database. To help build a website that has this purpose- The purpose of the 'Thai Wills' web application is to provide a user-friendly platform where registered users can create legal wills online. The application aims to simplify the process of will creation through an automated system for basic wills, while facilitating access to legal services for more complex will situations. Scope • The development of the'Thai Wills' web application which includes user registration, questionnaire-based will generation, and an interface for admin and legal professionals to manage and facilitate the will creation process. The scope includes: ▪ Basic will crea...
I'm looking for a proficient person that can go into links and write emails and phone numbers. There are 15,000 Records to revise. Work needs to start asap and be completed with a good team. This is not a one person job. I need all records completed real time from a file on google drive. Must be complete with 24 hours Currently, I'm using Excel spreadsheets, which is proving inefficient. I require an effective solution to input data and offer functionality that makes the information more accessible. Your Tasks: Go into profile and extract email, phone number , link in the bio and also any nics in the bio Required Skills and Experience: - Understanding of search functionalities - Data Entry - Knowledge in data export would be a plus. You should have a strong trac...
I'm in need of an experienced data analyst who can help me merge and clean up my Excel database. - Database Type: It is an Excel database that's in need of expert merging and clean-up. - Number of Files: The project revolves around a single Excel file with 4 sheets - Data Type: The data in question falls under the category of customer data. We have exported 4 databases from all our software. Basically we want all the duplicates to be deleted and the final file to be clean and able to be uploaded to mailchimp