Oscommerce database administration jobs

I am looking for a database website that serves as a customer form. This form will be used by customers to fill in various fields. Upon submitting the form, they will automatically receive a comprehensive response based on the information they provided. Key Requirements: - The customer form should include fields for Name, Contact information, Address, Location, Product or Service details, Width and Height, Dimensions, and Vertical or Horizontal preference. - The form should have an inbuilt auto-calculation feature that computes the Total cost, based on the area calculated, and any additional amount based on the customer's requirements. Delivery of Reverted Information: - The system should trigger an automated response to the customer. This can be in the form of an Email, a We...

I'm looking for a Kotlin developer with experience in migrating applications from local Realm to MongoDB Realm. The current status of the app is fully developed, and I'm only interested in converting the local Realm database to the MongoDB Realm database, without any additional feature or minor changes. The ideal candidate should: - Be proficient in Kotlin - Have experience with Realm - Have experience with MongoDB Realm - Understand database migration processes and best practices

I'm looking for an experienced freelancer to tackle data entry. The focus is on text data, which needs to be accurately inputted into a structured database. While attention to detail is important, issues checking for spelling or grammar errors will not form part of the job scope. In line with this, the ideal candidate should: - Have a proven track record with data entry projects - Have expertise in structured databases - Be able to work accurately with text data - Have the ability to complete tasks effectively within the given timeline.

I have a database that I need to be cleaned up. The main task is to remove duplicate entries. Key Points: - Main Task: The primary goal of the data cleaning project is to remove duplicate entries in the database. - Handling Duplicates: The duplicates should be automatically deleted, not merged or manually reviewed. Ideal Skills & Experience: - Database Management: A strong background in database management is crucial for this task to ensure the data is processed correctly without compromising the database integrity. - Data Cleaning: Experience with data cleaning processes, especially in handling duplicate records, is important. - Automation: The ability to automate the deletion of the duplicates efficiently and accurately is essential. Please bid...

I urgently require a thorough cleanup of my contact database. The main tasks include: - Verification of the correctness of email addresses - Authenticity check of RUTs - Verification of phone numbers The right candidate for this project should possess excellent attention to detail and experience in database management, particularly in contact cleaning. Familiarity with RUT verification will be highly valued. Please apply only if you can start immediately.

I'm in need of an expert to optimize my WordPress database speed. The current issues I'm facing involve slow loading times and prolonged database queries. The following tasks are essential for fixing the site's speed: - Updating and optimizing plugins: The site is currently slowed down by outdated plugins. An experienced professional should be able to update and optimize these plugins to enhance the site's performance. - Database performance improvement: As my priority lies in improving database performance, the freelancer should focus on database queries and other related optimizations to ensure the site runs smoothly and efficiently. - Site speed score: The ultimate goal is to achieve a site speed score above 95. The hired individua...

I'm currently encountering connectivity issues with my existing Azure Virtual Networks specifically with connecting to the MySQL database. I have a main Vnet with my mysql database in there. I have a virtual machine in there too which can connect to the database I have a second vnet which is peered to the main vnet. I have a virtual machine in this vnet too. It can talk to the virtual machine in the main vnet, but cannot connect to the database. I need it to be able to, and I cannot figure out why. You can tell me how to do it and I can test, this doesn’t need to be a long project!

I need an expert to help with advanced troubleshooting and optimization for my Oracle database. The ideal candidate should have: - Proven experience in database administration. - Proficiency in Oracle database. - Expertise in database troubleshooting and performance optimization. - Adept in using SQL Developer for managing database tasks. You'll be handling tasks such as: - Identifying and resolving performance issues. - Suggesting and implementing optimizations. - Monitoring database activities to ensure smooth operations. Your role will be crucial in ensuring the efficiency and security of our Oracle database.

I am in need of a skilled data entry operator to assist with the transfer of input of text data. Your main task is to take text data from an online database and accurately enter it into an Excel spreadsheet. Requirements: - Ability to accurately enter text data - Proficient in Excel - Experience sourcing data from online databases - Diligent and detail-oriented to ensure no errors are made during data transfer - Strong English language skills to ensure effective communication The ideal freelancer for this project is someone with proven data entry experience, excellent Excel skills, and vast familiarity with online databases. Being a detail-oriented person with great concentration skills will be a huge plus.

I'm in need of a designer who can create a Printed design for metal tin lids that will be used for food packaging. Having experience in designing for this particular type of product is a big plus. The designer should make sure that the design is compliant with the regulations of FDA (Food and Drug Administration).

...Oracle 19c database through JDBC. The primary goal of this project is to incorporate essential data operations into the application, mainly including reading, writing, and updating data in the database. Key Responsibilities: - Establishing a secure connection to an Oracle 19c database using JDBC. - Implementing CRUD operations (Create, Read, Update, Delete) features within the application. - Ensuring the application is optimized for efficient data handling and processing. Security Requirement: - The application must be able to securely access the database using username/password authentication. Ideal Candidate: - Proficient in Java and Springboot framework development. - Experienced with Oracle database SQL and JDBC connectivity. - Prior experience...

...structure development, team registration, match scheduling, event planning, marketing, and participant engagement. Budget Breakdown: Develop a detailed budget breakdown that accounts for all anticipated expenses associated with organizing and hosting the esports league. This should include expenses related to gaming infrastructure, facility rental, marketing and promotion, event production, league administration, participant support, and any other relevant costs. Qualifications: Proven experience in project management, particularly in the field of esports or event organization. Strong organizational and analytical skills with the ability to develop comprehensive work plans and budget breakdowns. Proficiency in financial analysis and budget management. Excellent communication ski...

We are looking for a MILVUS devOps expert who will know how to recommend and install the best Milvus hosting server. We are also looking for someone who has done this before MANY MANY times. The end goal is to 1/ recommend which Milvus install plan is best (K8, simple Docker, etc...) 2/ install Milvus and 3/ write detail documentation on how it was done. Then we may want to give you the chance to support and maintain the install. FOR us to consider your submission (WITHOUT the answers to these questions your submission will be automatically deleted) Question 1: Please let us know how many times you have configured and install Milvus. Question 2: Please describe the best architecture you recommend to install and host Milvus. Question 3: Will you be able to demo at leas...

I am in search of a proficient data entry specialist to integrate data into my online Microsoft Access database. Key Responsibilities: - Entry of a large volume of data accurately and efficiently - Verify the integrity of data before entry into the database Ideal Skills and Experience: - Proficiency with Microsoft Access - High attention to detail, precision and excellent organizational abilities - Prior experience with large database data entry is a plus Please note, the spreadsheet format requirement was skipped and so any standard format is acceptable. Only apply if you are proficient, accurate, diligent, and can meet deadlines.

Ease and flexibility of use by the site administration.    - A comprehensive control panel for dynamic content management.    - Multiple authority levels (manager, editor, publisher, etc.).    - An easy and integrated system for managing multimedia (images, video, etc.).    - Flexible tools for publishers enabling review and scheduling.    - Compatibility with C3W standards for cross-browser functionality.    - Possibility of future development without impacting existing content.    - An excellent, search engine-friendly system for periodic archiving of content (SEO).    - Multilingual support (Arabic - English).    - Design meeting standards for speed and ease of browsing.   &nb...

I'm looking for an experienced PHP developer to work on a new E-commerce website. The project involves: - **Website Development**: You'll be responsibl...E-commerce website. The project involves: - **Website Development**: You'll be responsible for creating a complete E-commerce platform. This includes setting up the necessary pages, product listings, and a user-friendly interface. - **Database Management**: Besides building the site, you'll also be in charge of managing its database. This involves ensuring data integrity, proper storage, and efficient retrieval. Ideal candidates for this project should have: - Proven experience in PHP development, specifically in E-commerce platforms. - Strong database management skills. - Understanding and e...

I'm in need of a professional who can efficiently handle data entry tasks into a database. The source of the data will be a mix of physical documents, digital files, and potentially web sources. Key Requirements: - Experience in online data entry. - Proficiency in database handling. - Strong attention to detail. - Ability to work with a variety of data sources. Your primary responsibilities will be: - Entering data accurately into a database from various sources. - Ensuring the integrity of the data being entered. The ideal candidate should be able to demonstrate a high level of focus and accuracy while working at a reasonable pace.

...have less than 10 columns, as I believe this will keep the sheet concise and easy to manage. The level of automation I am looking for is manual data entry with some formulas. This will help reduce manual work and ensure the data input is accurate. Ideal skills and experience for this job would include: - Proficiency in Excel: A deep understanding of Excel and its functionalities is essential. - Database Management: Experience in handling databases will help in setting up the product list and other related data. - Inventory Control Knowledge: Understanding of inventory control principles is a plus. - Report Generation: Experience in creating reports in Excel will be beneficial. Your goal is to create an efficient, user-friendly, and reliable Excel sheet that will help me manage...

...making some changes to the the user interface of my healthcare database website. The primary goal of the changes is to significantly enhance the user experience and make it more userfreindly. This is not a "redesign" task! The staff have learnt how to use the database and I don't want them to have to need to learn their way around a whole new database... not requesting any major changes, but a few points which are mostly related to the way the information is displayed not being user friendly. I need specific changes made. Please see document attached. I'm hoping to work with someone who has experience in both database website development and user interface design. It's important to me that you understand that the way the databa...

I am looking for an experienced professional to install a SIP trunk server on a Linux system. As part of the project, you should also set up access to the live voice stream with ...experienced professional to install a SIP trunk server on a Linux system. As part of the project, you should also set up access to the live voice stream with the primary purpose of real-time transcription. Key Requirements: - Install and configure a SIP trunk server on a Linux system. - Enable access to a live voice stream for real-time transcription. Ideal Candidate: - Proficient in Linux server administration. - Experienced in SIP trunk server installation. - Familiar with real-time transcription processes. - Skilled in setting up live voice stream access. - Strong problem-solving and troubleshooting ...

I have a database that I need to be cleaned up. The main task is to remove duplicate entries. Key Points: - Main Task: The primary goal of the data cleaning project is to remove duplicate entries in the database. - Handling Duplicates: The duplicates should be automatically deleted, not merged or manually reviewed. Ideal Skills & Experience: - Database Management: A strong background in database management is crucial for this task to ensure the data is processed correctly without compromising the database integrity. - Data Cleaning: Experience with data cleaning processes, especially in handling duplicate records, is important. - Automation: The ability to automate the deletion of the duplicates efficiently and accurately is essential. Please bid...

I have a project that involves entering text data from printed documents into a database. Ideal Skills and Experience: - Proficiency in data entry and accuracy in transcription - Experience working with printed documents - Knowledge of database management - Attention to detail to ensure complete and accurate data input Key requirements for the job include: - Efficiently entering text data from printed documents into a database - Ensuring the highest level of accuracy in transcribing the information - Organizing the data in the database in a logical and coherent manner - Completing the task in a timely manner without compromising accuracy. Your understanding of the importance of this task in the overall project and your commitment to quality and efficiency w...

As the owner of a growing tech startup with 10-50 employees, I am fully engaged in the business aspects and am in need of a dedicated professional to take over some of the critical HR functions. Your key responsibilities will be: - Employee Onboarding and Orientation: Ensure each new member of our team has a smooth transition into our company culture and workflow. - Payroll and Benefits Administration: Make sure all our people are compensated correctly and on time. Also administer the benefits we offer. Familiarity with payroll software is valued. The ideal candidate is experienced with these HR functions in the tech industry. You should be comfortable navigating both the legal aspects and the human elements of these roles with high organization and strong communication skills. P...

This project requires a specialist in Bash scripting to create a set of commands to read and write system configurations, specifically file permissions, into Linux non-volatile memory. The ideal candidate would have prior experience with Linux system administration and Bash scripting. A deep understanding of file permissions is essential to meet the project's objectives. The chosen script should be able to accurately perform the intended operations without the use of any other scripting languages.

I'm seeking a skilled developer to help build a dynamic and secure social registry database. The primary purpose of this database will be to store specific categories of user information, making it a critical data backbone for our social business operations. Key features will include: - Storage of Personal Identities: User's demographic and identity-related data. - Interaction Histories: Tracking user interaction data for better service delivery. - Location Data: Storing user location data to improve geographically targeted offerings. Moreover, I envision a flexible data entry process encompassing: - Manual Data Entry by administrators: Option for admins to input data manually, ensuring the correct configuration and verification of user information. - Automated Da...

I have a recent backup from 4/1/24 on a hard drive attached to my new computer. My previous computer died, the motherboard went out and somehow my SQL Server data was not saved on the original hard drive. I need to pull the data from a ".DATA" file, or find the missing SQL Server backup files and copy them into my existing program for use. Can anyone help?

...MySQL 8 Community edition. Lot of queries are stuck in "executing" state without any kind of database table locking. Most of the queries stuck are all "SELECT" queries. The queries itself is fully optimized using joins and indexing for better performance and those are regular queries which are executing just fine without any issue since many months. If you have a VAST amount of AWS experience, reply with the text "I have a vast amount of AWS experience and I am available right now to help." Thanks! --- Comments below are from AI -- I am in urgent need of AWS server administrator to resolve critical issues with my EC2 and RDS services. The server is currently experiencing performance degradation, database connection errors, and server downt...

I am looking for an expert in MS Excel and navigating a website. We will provide a list of certain colleges and universities in the United States, 258 of them. Go to and type the name of the school, then type “athletics staff directory” and hit enter/search. The first site listed will be the staff directory for the athletic department. Scroll down to the Football staff. For every member of the Football Staff who has an email address listed, you need to enter that staff member’s information (School Name, First Name, Last Name, Title, Email Address, Twitter) into the spreadsheet. This is a single project that would need to be completed each year. Pay would be made upon completion of the project. Mode of communication is English.

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

...environment, including SSL setup for enhanced security, domain redirection to maintain online presence, and all necessary settings adjustments to guarantee smooth operation. 5 - Testing and Quality Assurance: Conduct rigorous testing to verify that all services, functionalities, and integrations are functioning flawlessly post-migration. We require someone with expertise in WordPress and Moodle administration, along with proficiency in server management and cybersecurity protocols. It is imperative that the freelancer prioritizes security and data integrity throughout the entire process. Additionally, we kindly request: - An estimation of the time needed to complete the project, including individual timelines for each task. - A detailed breakdown of the costs associated with ...

I need an adept Teams Administrato...Administrator to set up and manage Powerbi report access and Share OneDrive accounts for the upper echelons of my company. The desired individual should ideally have experience handling Teams Administration for medium-sized groups (10-50). Details: • Allocate Powerbi report access: The task involves granting read-only access to Powerbi Reports for the Executive and Management teams in my organization. • Share OneDrive accounts: You will also need to set up Share OneDrive accounts specifically for these segments. Ideal Candidate: • The ideal candidate will have proven experience in Teams Administration. • Proficiency in managing and configuring Powerbi and OneDrive • Experience working with med...

...optimized for all devices and browsers. 5. Backend Features: • Robust CMS for easy management of products, categories, and pricing. • SEO-friendly structure to enhance visibility on search engines. • Secure payment gateway integrations. Deliverables: • Complete website design and development. • Initial set of products uploaded with categories as specified. • User manual/documentation for site administration. Project Timeline: • Please provide an estimated timeline for completion along with your proposal. Budget: • Include your pricing model and any other costs that might be anticipated for this project. Note: • Proposals without a detailed timeline and budget breakdown will not be considered. Please ensure your proposal is comprehensiv...

I'm looking for a professional to help in setting up an SQLite database which will store and manage moderate data with multiple attributes. Key requirements: - The database should be optimized for storing and retrieving moderate data, such as an inventory system with multiple attributes. - No complex data analysis is necessary, just a user-friendly system for managing and retrieving stored data. - Basic search and filter functionalities are required. Ideal skills for the job include: - Proficiency in SQLite database design and management. - Experience in setting up databases for inventory systems or similar systems. - Ability to implement basic search and filter functionalities.

I'm currently experiencing slow performance from my WordPress database that appears to be most apparent when using Mysql/MariamDB which is affecting my admin and dashboard areas. Ideally, I'm seeking assistance from a professional with substantial experience in WordPress and database optimization. The main skills and experience required include: - Knowledge and skills in MySQL/MariaDB - Expertise in WordPress database management - Experience working with websites having more than 20 plugins. Your task will include performing necessary optimizations to significantly enhance the performance of the website, specifically the admin and dashboard areas. Please, include examples of similar projects you've worked on when bidding.

...orders and inventory. I specifically prefer real-time inventory tracking to ensure accurate information at all times. Key requirements: - User registration and login - Order placement and tracking - Push notifications for order updates - Real-time inventory tracking Drive app for iOS and Android: Allows users to order products with an intuitive mobile app. 2. Website: Same as point #1. 3. Administration web application: Provides a dashboard for order management, inventory, and data analysis. 4. Order Preparation Application: Allows staff to manage and optimize order preparation. 5. Graphic charter provided Additionally, we need a preparation app for our staff to manage and optimize order preparation. This will ensure a smooth and organized process for our team, as well as effic...

I am in immediate need of a comprehensive database containing information about IT professionals with 2-3 years of experience. This is crucial for a current initiative, thus I need it ASAP. The database should provide: - Name - Phone Number - Skills - Educational Background - Work Experience - Salary Precision is of utmost importance to me. Therefore, an ideal freelancer for this task should have proven experience in data collection and data entry, with a keen eye for detail to ensure the accuracy of the database. Experience in the IT or HR industries would be a significant advantage.

I need to migrate 11-50 email accounts from Microsoft365 (specifically using Outlook Web Access) to CPANEL IMAP server. This task will require a freelancer who's proficient in both email system administration and migration. Key Responsibilities: - Transfer all existing emails, new IMAP server with zero data loss. - Ensure all the email accounts are set up and functioning correctly on the new server. I'm looking for a reliable freelancer who can deliver this task efficiently and with minimal disruption to our daily email operations.

...data into a database. While the data entry itself isn't particularly complex, a certain level of basic data cleaning will be required. Key Requirements: - Data Entry: The main task is to accurately input data from PDFs into a database. The data is mostly textual, so typing proficiency and attention to detail are essential. - Database Organization: The entered data needs to be organized in a clear, logical manner to ensure it's easily searchable and can be efficiently used. - Basic Data Cleaning: The data will need to be reviewed and cleaned up to ensure accuracy and integrity. This will involve identifying and removing any duplicate entries. Ideal Skills and Experience: - Proficient in Data Entry: Experience with data entry tasks, particularly those inv...

Develop client portal, With below minimum functionality 1. Security – it should be a secure system as it involves Customer information. This security should apply to data in motion and the rest. 1.1 use of SSL certificates 1.2 controlled user and administration access to the Loan System Management administration page and hosting environment. 1.3 Backup 1.4 Other security features – please propose. 2. Audit trail – the customer portal must have record all user transactions or activities and allow for retrieval when necessary (activity history). 3. Scalable – they customer portal must be scalable to accommodate new products that may be introduced. 4. Integration – the client portal must have the capability to integrate with USSD solution and Loan ...

...current EspoCRM installation, it is essential that these are migrated correctly to the new environment. You will need to ensure that all custom features and functionalities are preserved and functional post-migration. Ideal Freelancer: - EspoCRM Expertise: I'm looking for a professional with a strong track record of working with EspoCRM, particularly involving migration projects. - Server Administration: Proficiency in managing the new server installation is crucial for this project. You should be able to set up the server correctly, ensuring the CRM works seamlessly post-migration. - Customization Skills: Experience in handling customized CRM instances is a big plus. You need to understand how to transfer these changes without any loss in functionality. Please provide any...

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

I'm seeking someone who can help me configure my Windows PC as a webserver. I'm looking to: - Set up a web server that will be used to host my micro business website. - Potentially set up a dynamic website with server-side scripting in the future. Ideal skills and experience for this job include: - Proficiency in Windows system administration - Experience in web server setup and configuration - Knowledge of hosting dynamic websites If you have experience setting up web servers on Windows, let's discuss your approach and how you can help me achieve my goal. No hosting required. Just set up firewalls and webserver software, make sure the connection is valid, so I can build the website and get it online.... You know, done for me basics, so I can design website my...

...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 Skills: - Pro...

I'm in need of a professional academic researcher for my study in Business Administration. The main objective of the research is to analyze case studies. Therefore, I'm looking for an expert who's well-versed in quantitative research methodologies. Responsibilities: - Conducting thorough research in the field of Business Administration - Analyzing complex case studies - Providing a high-quality publication-ready report The ideal freelancer will have: - Extensive experience in academic research - A strong background in Business Administration - Proficiency in quantitative research methodologies - Excellent analytical and critical thinking skills - Strong writing and communication abilities I'm looking for someone who can deliver a top-tier publi...

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.

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'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 creation th...

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

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