Php parse csvроботи

Завдання: Система представляє собою "хаб" API інтеграцій між іншими системами. Необхідно вміння роботи з різноманітним API. Розуміння та вміння налаштовувати CRON задачі. Робота з БД mysqli. Ключові навички: php, mysqli, фреймворк, cron, API, keitaro/tiktok/facebook. (removed by Freelancer.com admin)

Треба переписати сайт з html на php, створити вкладку "login" де можно увійти у режим адміну де можна керувати сайтом, та підв'язати до цього всього датабазу

Для нашого онлайн магазину шукаємо PHP розробника фрілансера Маємо два цікаві проекти. Завдання: Шукамо фрілансера для розвитку наших веб-магазинів електронної комерції за допомогою найсучасніших веб-технологій для різних пристроїв (мобільних, планшетів) Профіль: • Хороші знання з програмного забезпечення (об'єктно-орієнтований дизайн, шаблони проектування, тестування) • самостійна робота та вирішення проблем • високий рівень мотивації • Досвід роботи з PHP, Symfony, Laravel або Zend, є перевагою • Вільне володіння німецькою чи англійською мовами • Дуже хороші знання PHP, MySQL та JavaScript • Добре знання HTML (5) та CSS (3)

Потрібно поступово (по частинах) переписати застарівший самописний PHP інтернет-магазин з асортиментом декілька тисяч товарів на фреймворк Django, розширюючи його теперішній функціонал. Обов'язково: - попередній досвід веб-розробки на Django; - досвід створення RESTful API; - розуміння PHP. Бажано: - досвід на подібних проектах в ролі Senior; - досвід роботи з Flask; - досвід роботи з Vue.js; - досвід роботи з PostgreSQL.

needs to be finalized - add btc, payeer, perfect money, yandex money, visa / mastercard, pay pal payment methods. And also to add the calculator of interest calculation concerning the purchased investment packages by the client (so that the client can see the purchased package and accruing on it depending on the elapsed time and for the current period after payment in his own office). Change the site's payment currency to dollars, euros, rubles, pounds. The project budget is 50 Euros, but we can discuss.

Рекламна агенція Афіша Прикарпаття шукає PHP-програміста для виправлення технічних помилок на сайті ap.if.ua. Сайт написано за допомогою фреймворку Laravel, попередній програміст пояснить всі технічні деталі. Приблизна вартість всіх виправлень на сайті - 10000 грн. Можливо будуть добавлятись нові пункти, за додаткову оплату. Якщо працювати 5 днів в тиждень то все можна закінчити приблизно за пару тижнів, залежить від ваших навичок. Нам потрібна тільки людина з Івано-Франківська(та області) для того, щоб ми могли зустрічатись в офісі Афіша Прикарпаття, також при необхідності можливе виділення робочого місця.

Потрібно реалізувати автоматичну вигрузку csv файла з фтп в БД сайта. На сайті повинно бути поле вводу номера телефона (для перевірки кількості бонусів на сайті) після вводу, людині повинна прийти смс з кодом підствердження, після вводу відкривається інформація про клієнта, а саме ПІБ, номер телефону, номер бонусної картки та кількість накоплених бонусів

Доброго дня. Я партнер міжнародної IT-компанії, яка займається розробкою додатків та сайтів (від звичайних лендінгів до повноцінних адмін-сторінок) для американського ринку. Ми шукаємо працьовитих і готових до навантаження PHP девелоперів. У команді мало людей, тож усі мають достатньо роботи і справді дружні між собою. Майже усі наші працівники з України, тож проблем з комунікацією немає. Більшість контактів будуть здійснюватись через менеджерів компанії та мене, тож безпосередній контакт з клієнтами англійською буде відсутній. Однак володіння англійською хоча б на простому розмовному рівні потрібне, оскільки мій парнер по бізнесу - американець, і комунікація з ним у вас буде. Розпочати роботу ви зможете після кількох етапів відбору (тест на навики та коротка скайп-розмова) та р...

Потрібно розробити імпорт інформацію з csv файлу та створити під неї сторінку телепередачі для сайту Детальне ТЗ в доці Приклад файлу імпорту прикріплений, для імпорту буде такий же, але в форматі csv

Я маю довгострокову роботу, яка пов'язана з нашим попереднім проектом 'Change Framework CMS from Shopify to Prestashop - PHP, HTML, CMS, SQL'

I'm looking for an experienced developer who can help me convert my existing PHP project to CodeIgniter. Key requirements: - Expertise in PHP and CodeIgniter. - Ability to understand and work with existing PHP code. - Experience in converting PHP projects to CodeIgniter. - Strong problem-solving skills to handle any issues that may arise during the conversion process. Please note: - The main purpose of the project has not been specified. - The version of CodeIgniter to be used is also undecided. - No additional features or improvements are required during the conversion.

I am experiencing some bugs in my PHP CodeIgniter software that need to be rectified. The issues mainly pertain to the User Interface and some Functional errors. - UI Issues: These are primarily related to the software's interaction with users. - Functional Errors: I'm encountering problems with form submissions and database retrievals. The ideal freelancer for this project should have: - Extensive experience with PHP and CodeIgniter. - A strong background in troubleshooting UI issues and functional errors. - Proven skills in debugging and rectifying software bugs. - Ability to work efficiently and communicate progress regularly. Please reach out if you believe you can assist with these issues.

I'm in need of a skilled PHP developer to create an e-commerce website. The site should include a shopping cart, user accounts, and payment gateway integration. Key Features: - Shopping Cart: The site should have a reliable and user-friendly shopping cart. - User Accounts: The site needs to allow users to create personal accounts for a tailored shopping experience. - Payment Gateway Integration: The developer will need to integrate secure and efficient payment gateways. Ideal Skills: - Proficiency in PHP and e-commerce website development - Experience with integrating shopping carts and user accounts - Skilled in secure payment gateway integration Please note: Specific payment gateways have not been decided yet, but experience with PayPal, Stripe, and would be bene...

I'm looking for a professional web developer to build a classic and professional PHP website for my travel agency. The site should include a comprehensive package booking system and an admin panel. Key Requirements: - Real-time availability checking: The booking system should be able to show real-time availability of travel packages. - Package customization options: Users should be able to customize their travel packages. The site should have a classic and professional user interface. It needs to be user-friendly and easy to navigate. Please note, I do not require any payment methods to be integrated at this time. Instead, I need an enquiry and booking form. Ideal Skills: - Strong proficiency in PHP and web development. - Experience in creating travel agency websites ...

I'm seeking a skilled PHP developer with experience in working with MySQL and Cassandra. The task involves creating a succinct PHP script that can: - Continuously read user data from MySQL and write it into Cassandra. - Read user data from Cassandra and write it back into MySQL. The environment for testing is already set up locally, and the task is expected to be completed within 2 hours. The data transfer process does not require any transformations; the user data will be directly transferred without adjustments. Given the short time frame and nature of the task, I appreciate freelancers who have prior working experience with this kind of project. Your understanding of both databases and PHP is key to the success of this project. Looking forward to your bids.

I need a Python script that reads amounts from a CSV file, verifies stock tickers across NASDAQ, NYSE, and S&P 500, and places market orders using TWSAPI. The script should log an error if it encounters an invalid or unverified ticker. Key Requirements: - Read amounts from a CSV file. - Verify stock tickers from NASDAQ, NYSE, and S&P 500. - Place market orders using TWSAPI. - Log errors for invalid or unverified tickers. Skills and Experience: - Proficiency in Python. - Experience with TWSAPI. - Familiarity with stock market tickers and order types. - Ability to work with CSV files.

Hi I need a working example in PHP using the libraries Slim and Stripe for pre-authorizing cards and then charge charge them. Max 50 euros.

I need a skilled PHP/SQL programmer to help me troubleshoot and fix issues in my existing code. I'm currently facing a couple of challenges that need immediate attention. 1) PDF Files Preview Issue: I have PDF files that are not previewing properly on three different pages and a 'save to PDF' page. Some PDFs are displaying while others aren't. All these files are stored in a database table. 2) Setting Up New Database Fields: I need assistance in creating three new fields in my database. This will involve integrating these fields in the front-end and back-end of my existing system. Ideally, I would like to complete these tasks within three hours, though I anticipate we could finish sooner. If you're available now and ready to work with me, please respond w...

I'm seeking a skilled PHP Laravel developer with experience in Backpack for Laravel. Most of the work is complete; however, there are approximately 50 outstanding defects primarily related to: - Website (User Panel) - API integrations The immediate priority is fixing these defects to ensure the site and its associated APIs are functioning correctly to support a mobile application. There is potential for long-term work following this project, as I will require support and maintenance. Ideal candidates would also have: - Proficient experience with PHP and Laravel - Previous work with Backpack for Laravel - Not mandatory but Good to have if your team has React Native for mobile development - Payment gateway integration

... customized control panel per user. Modern Interface: Clean, user-friendly and mobile-friendly interface. Per Message Charge: A system of charging per message sent. Users are charged according to the campaign type and sending volume. 2. WhatsApp Marketing Tools Bulk Message Sending: Sending messages to multiple people with a single click. Uploading Contacts: Uploading numbers in bulk via Excel/CSV file. Message Scheduling: Automatic sending of messages at a specific date and time. Multimedia Messages: Sending messages that support images, videos, documents and other media files. 3. Chatbot Features Auto Responder: Automatic sending of predefined responses to incoming messages. Smart Chatbot: Customizable message flows based on user behavior. Keyword Detection: Sending messages ...

I need a skilled data scra...need a skilled data scraper to extract information on auto parts from various sources. You will be responsible for collecting the data, organizing it into a CSV file, and ensuring it's properly formatted for Shopify. Key Responsibilities: - Scrape data from retail websites, manufacturer websites, and third-party marketplaces. - Collect product names and descriptions, prices and availability, and manufacturer details and specifications. - Organize and format the scraped data into a CSV file for Shopify upload. Ideal Skills and Experience: - Proficiency in web scraping tools and software. - Experience with Shopify and knowledge of its CSV formatting requirements. - Attention to detail and ability to verify data accuracy. - Understan...

I'm looking to create a modern, sleek business website in PHP. The website should encompass essential pages including Home, About Us, and Contact Us. Ideal skills for the job: - Extensive knowledge of PHP - Web design experience with a modern aesthetic - Ability to create user-friendly, responsive layouts Please include samples of your previous work that demonstrate your ability to deliver a website of this caliber. Your understanding of modern web design principles and PHP will be key in successfully executing this project.

Need minor edits to my POS system. Tasks include: - Logo update - Modifying the Scripture - Changing a description to 'Warranty' I have the new warranty information ready to go. Ideal skills and experience: - Proficient in PHP - Familiar with point-of-sale systems - Able to make quick, precise changes - Good understanding of UI/UX for POS systems

I'm in need of a skilled web scraper capable of extracting data from a webpage with 5,500 products. These products do not have variants, which should simplify the task. Data to be scraped: - Product name - Product...These products do not have variants, which should simplify the task. Data to be scraped: - Product name - Product Part Number - Product description (The product descriptions aren't formatted the same way for each product. They are inconsistent but similar.) The final deliverable should be an Excel/CSV file containing all the scraped data, sorted by product name. Ideal skills for this project include: - Proficient in web scraping - Proficient with AI - Experienced in data organization and Excel/CSV Please, only bid if you can deliver quality work in ...

I'm seeking a data research expert with a strong background in data scraping. Your task will be to gather relevant data on gyms in Qatar. Ideal skills and experience for the job include: - Proficient in data scraping techniques - Able to fi... Please note, the specifics of the data types needed (contact details, number of members, available facilities) and the primary source of data (websites, social media, public records) will be determined based on your expertise and the information available. While the preferred format for final data delivery hasn't been specified, previous projects have typically used an Excel spreadsheet or a CSV file. A familiarity with Google Sheets would also be beneficial. Your ability to deliver comprehensive, accurate and relevant data is ...

I'm in urgent need of a professional to help me skip trace around 6K US real estate records. The primary goal is to obtain property owner's contact details, including phone numbers, email addresses, and mailing addresses. Ideal Skills and Experience...phone numbers, email addresses, and mailing addresses. Ideal Skills and Experience: - Prior experience in skip tracing, especially with real estate records. - Proficiency in data processing and management. - Ability to deliver high-quality work under tight deadlines. - Excellent communication skills for timely updates. Deliverables: - All information should be compiled and delivered to me in a CSV file. Please note that I need this completed ASAP. Your promptness and efficiency will greatly influence the likelihood of fu...

I'm looking for a skilled PHP Laravel developer who can create a robust vehicle tracking system. The system should be capable of tracking vehicles' locations in real-time. Key Features: - The system should track vehicles, focusing primarily on their location - Real-time updates: The tracking information should be updated in real-time Ideal Skills: - Proficient in PHP 8 and Laravel - Extensive experience in developing GPS tracking systems - Knowledge of TCP server implementation in PHP - No JavaScript skills required for this project Please note that the project should not involve any JavaScript. Your proposal should clearly demonstrate your relevant experience and how you plan to deliver this project.

Looking to create an adult (porn) aggregator from multiple porn tube sites. We aren't hosting videos or playback. Partners will provide CSV/XML feeds of content which we aggregage into categories / models / tags and display on our site. Thumbnails of content should have a CTR algo in place. Site needs to be extremely fast, golang, sphinx/elasticsearch, node.js, caching etc. Should be able to handle 100s of millions of videos, users and a partner who can work quickly, understand this is pornography and be ok with that and great english skills. Ideally looking for a team to get this task completed as soon as possible.

I'm looking for a skilled professional who can help integrate my payroll software with an internal CSV database. The goal is to generate specific payroll reports which meet the requirements of New Jersey and New York City certified payrolls. Key Responsibilities: - Integrate payroll software with an internal CSV database - Generate New Jersey Certified payroll report - Generate New York City Comptroller Certified payroll report Ideal Skills: - Strong experience with payroll software - Proficiency in handling and integrating CSV files - Prior experience with generating certified payroll reports Please note: The ability to understand and meet the requirements of certified payroll reports for New Jersey and New York City is crucial for this project. This report i...

I'm seeking a skilled data scientist to create a full Machine Learning model using SVM, GA-SVM (Genetic Algorithm Optimized SVM), and gcForest. The task involves evaluating their performance based on the following metrics: Accuracy, Precision, Recall, F1-Score, and AUC-ROC. The validation method to be employed is Stratified K-Fold Cross-Validation. Key Details - Dataset: Custom dataset in CSV format - Preprocessing: The dataset is already preprocessed, so no additional handling of missing values or feature scaling is necessary. Ideal Skills - Proficient in SVM and gcForest - Experience with Genetic Algorithms - Strong understanding of performance metrics - Familiarity with Stratified K-Fold Cross-Validation Project deadline: 2 weeks (if possible)

...seamlessly appended to the database without overwriting existing records. • Implement deduplication processes to avoid redundant data entries. • Maintain timestamps to indicate when data was last updated. 4. Optimization and User Access • Optimize the database for high-speed querying using indexing, normalization, and caching. • Include features for filtering, sorting, and exporting data (e.g., CSV or Excel formats). • Develop a user-friendly interface (if required) for accessing and analyzing data. • Ensure secure authentication and access control mechanisms. 5. Testing and Maintenance • Conduct thorough testing of the database and web scrapers under multiple scenarios to ensure reliability. • Establish a maintenance plan to han...

I'm in need of a seasoned PHP Laravel 11 and JavaScript developer to enhance my marketplace. The key areas needing customization involve the cart and product variation. Key requirements include: - User Interface (UI) improvements, particularly on the product variation display - Functionality upgrades across the cart and product variations - Enhanced error handling and validation processes The successful freelancer will have a solid background in PHP Laravel and JavaScript, with a keen eye for visual design and user experience.

I need a PHP expert to implement a caching mechanism for my RAND() results. I have 3 PHP files: - The first file contents a list of words. - In the second file, I randomly « echo » one word at a time. In the third file, I want to include the result of the second file in 2 different positions of the page. But the issue is that as I see, without caching, I get 2 different words in the third file. So I need the result of the second file to be cached every 2 or 3 requests and include that cache in the third file to get the same word in all positions. Key Requirements: - Include the cached result in another file. - Refresh the cached RAND() result every second or third request. - Utilize a file-based cache for this purpose. Ideal Skills: - Proficiency in ...

...calculation, clarifying the practicality and utility of each element within the model and highlighting the added value it provides. Data Requirements The software will be based on the BTC-USD price history from the past 5 years. The data should be continuously updated, and a daily granularity is recommended. It is preferable to directly implement data retrieval using yfinance, avoiding reliance on a CSV file for management. Feature Engineering The extracted features should include: • ATR (Average True Range) • Bollinger Bands • Moving averages • Logarithmic returns (Additional suggestions and implementations are welcome.) For this specific part, training an LSTM model is advised. Modeling 1. Train a GARCH(1,1) or GARCH(2,1) model on the logarithmic returns ti...

I'm looking for a web developer with experience in integrating Stripe into PHP websites. The project involves creating different payment buttons for various payment methods, including Credit/Debit Card, PayPal, Apple Pay, Google Pay, Giropay, and Klarna, all through the Stripe gateway. Key Requirements: - Integrate Stripe payment system into a PHP website - Develop individual payment buttons for various payment methods - Ensure the design of the buttons is sleek and modern - Prioritize the integration of specified payment methods Ideal Skills: - Proficiency in PHP - Extensive experience with Stripe integration - Strong web development skills - Good understanding of modern design principles - Familiarity with creating custom payment buttons

I'm looking for a script or API that can export my Active Campaign Deal Notes into a CSV/Excel file. Key Requirements: - The script/API must export the Deal Notes in a CSV/Excel format. - The output should include the note content, the date created, and the username of the note creator. Ideal Skills: - Proficient in scripting and API integrations, especially with Active Campaign. - Strong understanding of data export and manipulation. - Experience in generating CSV files from API data. Please, do not apply if you do not have the required skills and experience.

I'm in need of a skilled professional who can help with the extraction of text from my PDFs. This is an ongoing project with new PDFs coming in regularly. I need the code in a Colab notebook that i can run myself and upload new PDFs to run text extraction. Key Requirements: - Extract all text from multiple PDFs. - Store the extracted data into a CSV or data frame. Ideal Skills: - Proficiency in Python or similar languages for data manipulation. - Previous experience in text extraction from PDFs. - Familiarity with data cleaning and preparing data for analysis. The ability to work on a consistent basis and deliver high-quality work promptly is essential. Please provide examples of similar projects you've completed in your proposal. Example PDF is attached,

...from a source website. The goal is to create 4000 entirely new, unique, and plagiarism-free articles for publication on our website. The rewritten content must maintain the original meaning and factual accuracy of the source material while sounding natural, engaging, and human-written. We want to avoid any robotic or AI-generated tone. Content Volume: 4000 articles Source Material: Provided in CSV format (containing article titles and content). Deliverables: 4000 rewritten articles in a specified format (e.g., .docx, .txt, or directly into a WordPress staging environment – to be discussed). Content Requirements: Uniqueness: 100% original content, free from plagiarism (verified using plagiarism detection tools). Accuracy: Maintain the factual accuracy and core message of ...

I need to create an output csv file in a template

...from a source website. The goal is to create 4000 entirely new, unique, and plagiarism-free articles for publication on our website. The rewritten content must maintain the original meaning and factual accuracy of the source material while sounding natural, engaging, and human-written. We want to avoid any robotic or AI-generated tone. Content Volume: 4000 articles Source Material: Provided in CSV format (containing article titles and content). Deliverables: 4000 rewritten articles in a specified format (e.g., .docx, .txt, or directly into a WordPress staging environment – to be discussed). Content Requirements: Uniqueness: 100% original content, free from plagiarism (verified using plagiarism detection tools). Accuracy: Maintain the factual accuracy and core message of ...

...**trading volume** data of the stock. - **Technical indicators**: Create various **technical indicators** for the stock data. For example, **Moving Average (MA)**, **Relative Strength Index (RSI)**, **MACD**, **Bollinger Bands**, etc. - **API Utilization**: To obtain stock data, you can use **Yahoo Finance API**, **Alpha Vantage API**, **Quandl**, etc. to get real-time data, or save data locally as a **CSV file**. ```python import yfinance as yf # Example: 5 years of Apple stock data data = ('AAPL', start='2015-01-01', end='2020-01-01') print(()) ``` ### 3. **Calculating technical indicators** AI basically learns through **technical indicators**. For example, it can calculate indicators such as **Moving Average**, **RSI**, **MACD**, etc. These ind...

...website. The goal is to create 4000 entirely new, unique, and plagiarism-free articles for publication on our website. The rewritten content must maintain the original meaning and factual accuracy of the source material while sounding natural, engaging, and human-written. We want to avoid any robotic or AI-generated tone. Project Scope: Content Volume: 4000 articles Source Material: Provided in CSV format (containing article titles and content). Deliverables: 4000 rewritten articles in a specified format (e.g., .docx, .txt, or directly into a WordPress staging environment – to be discussed). Content Requirements: Uniqueness: 100% original content, free from plagiarism (verified using plagiarism detection tools). Accuracy: Maintain the factual accuracy and core message of ...

I am seeking a Mail Merge expert to assist with document creation from Excel or CSV files. The project involves: - Utilizing a non-specific mail merge platform to execute the task efficiently. - Creating a variety of documents using Mail Merge. - Working primarily with data sourced from Excel or CSV files. Ideal candidates should have extensive experience with Mail Merge, particularly with non-Microsoft or non-Google platforms. Proficiency in handling Excel and CSV files is essential.

I have multiple CSV files containing data downloaded from an SAP tool. The primary focus is on extracting specific sales data from these files. Ultimately, I need someone to create a chart or dashboard based on this data, comparing sales across different regions. Key Requirements: - Extract specific sales data from multiple CSV files - Create a chart or dashboard comparing regional sales - Use either Power BI or Excel for the analysis and visualization Ideal Skills: - Proficient in data extraction from CSV files - Experienced in using Power BI or Excel for data visualization - Able to create insightful and easy-to-understand charts or dashboards. Please note, the purpose of this project is to visualize regional sales comparisons. Your expertise and attention to d...

I need a skilled bug hunter or vulnerability tester for my custom-built PHP website. Your task will primarily be to identify SQL injection vulnerabilities on the site and its APIs. Key details: - The website is custom-built using PHP - Potential for a high payout, as I am willing to pay $300 for each SQL injection vulnerability identified Ideal Skills & Experience: - Extensive experience in vulnerability testing and bug hunting - Proficiency in identifying SQL injection vulnerabilities - Prior experience with PHP-based websites is a plus - Familiarity with API testing Please note, the question regarding specific areas of the website where vulnerabilities might exist was skipped, so a thorough examination of the entire site and its APIs will be required.

I'm in need of a professional data scraper to extract contact information from 1400 profiles on a particular website and import it into an Excel CSV file. Key Requirements: - Scraping of 7 specific fields of contact information from each profile, including: - First name - Last name - Email address - Phone numbers - Social media links - Opponent - Win or loss/method Ideal Skills: - Proficient in web scraping tools and techniques. - Excellent attention to detail to ensure data accuracy. - Experience with data processing and Excel. Please bid if you have prior experience in this type of project.

I'm seeking a technical recruiter who can help me find a proficient PHP developer. This developer will be responsible for creating plugins across various frameworks and developing a WordPress plugin from scratch. Key Requirements: - Expertise in Laravel, CodeIgniter, Symfony, and Node.js - Proven experience in WordPress plugin development - Strong PHP skills - Ability to create plugins in different frameworks The ideal candidate would have a strong understanding of PHP, a good grasp of multiple frameworks, and extensive experience in developing WordPress plugins from the ground up.

- środowiska - import zamówienia kontrahenta z pdf, xlsx, csv itp - automatyczny import zamówień z plików przesłanych na dedykowany e-mail - integracja z - - dostęp do hurtowni po zalogowaniu - rejestracja wymaga akceptacji - automatyzacje

My existing website is encountering multiple technical errors primarily affecting the product pages. These issues include broken links, page loading difficulties, and script errors. I need an experienced PHP developer to help troubleshoot and resolve these issues.

Saya mencari pengembang yang terampil untuk membuat aplikasi web yang tangguh menggunakan PHP Laravel dan JavaScript. Aplikasi tersebut akan memerlukan: - Login/Registrasi Pengguna: Ini akan mencakup fitur-fitur seperti verifikasi email, login media sosial, dan autentikasi dua faktor untuk meningkatkan keamanan dan kenyamanan pengguna. - Formulir Pengajuan Data: Ini akan menjadi bagian integral dari interaksi pengguna dengan aplikasi. - Pembaruan Waktu Nyata: Ini akan memastikan pengguna menerima pembaruan dan pemberitahuan segera, yang akan meningkatkan interaktivitas aplikasi. Kandidat yang ideal akan memiliki pengalaman luas dalam PHP Laravel dan JavaScript, dengan portofolio aplikasi web serupa yang kuat. Keakraban dengan penerapan sistem login yang aman dan pemba...