I'm in need of an experienced Shopify developer to create an online store for my physical products. The main aspects of this project include: - The store will be designed to sell physical products, so your expertise in e-commerce and Shopify development is crucial. - Integration with payment gateways such as PayPal, Stripe, and credit/debit cards is a must. Your experience in configuring these payment gateways on Shopify will be an advantage. - Your knowledge of Shopify's features and how they can be tailored to create a seamless and user-friendly online shopping experience is key. Ideal Skills and Experience: - Proven experience in developing e-commerce websites, particularly on the Shopify platform. - Expertise in integrating payment gateways, specifically PayPal and...
...levels effectively, avoiding overstock or stockouts, and improving customer satisfaction. - Sales Tracking: The integration needs to allow for seamless tracking of sales across both platforms. This will help in identifying trends, analyzing performance, and making informed business decisions. - Order Processing: The software must be capable of processing orders efficiently and accurately. This will help in reducing errors, improving customer service, and maintaining a good reputation in the market. sending order to clients unleashed ready for shipping. - ISO27001 or similar control to protect data security. The ideal candidate should have: - Extensive experience in software integration, particularly in cloud-based systems. - Proficiency in Unleashed software i...
I'm in need of assistance to resolve an ongoing issue with the PayPal module in my Prestashop site (8.1). Without an...module in my Prestashop site (8.1). Without any recent changes or updates, the module simply doesn't stop loading, making it impossible to configure it. The ideal freelancer for this job should: - Be an expert in PrestaShop - Have proven experience and skills with PayPal integration - Understand the typical causes of endless loading issues and their solutions Your task will be to identify and fix this issue to assure a smooth payment processing for my customers. Experience with PrestaShop and PayPal module integration is a must. Please provide a brief overview of your relevant experiences and how you plan to tackle this issue. I anticipate a sm...
I am looking for a Shopify and Ebay integration expert to help me with the following tasks: - Setting up product listings on Ebay platforms - Clear the errors in integration. Requirements: - Experience in integrating Shopify and Ebay platforms - Proficiency in setting up product listings on eBay Additional Information: - I already have existing product listings on Shopify If you have the necessary skills and experience in Shopify and Ebay integration, please reach out to me to discuss the project in more detail.
1. Need a page made for inputting phone numbers in iOS Xcode storyboard with ViewController 2. Need a page made that pulls from an API via AlamoFire and also plays an audio file with each item from the database (array) - also need to add a description field under each item in the array.
...Experience: You should have experience in developing smart contracts preferably in the blockchain space. Your responsibilities will include: - Implementing the smart contract on the Ethereum network, ensuring it works seamlessly with the Nextjs frontend. - Collaborating with our team to ensure the project meets our requirements and specifications. - Providing technical support and guidance on the integration of the smart contract. Ideal Skill Set: - Proficiency in Nextjs - Experience with Ethereum and smart contract development - Strong problem-solving and communication skills - Prior experience working in a similar capacity would be advantageous If you believe you could meet these requirements and are interested in this project, please get in touch. I'm looking forward t...
We are developing a dropshipping website using WordPress, specifically focusing on the Beauty niche. The site will be connected to the BigBuy API for seamless product integration. To achieve rapid SEO positioning, we will utilize ChatGPT to automatically generate enriched product descriptions, including tips and benefits for each product. These enhanced descriptions will be used on product pages and automatically generate blog posts that include additional brand information for improved SEO. In the 2 attached files you can see the technical specifications and an outline of the programing already executed on our side and validated by GPT Chat code correction tools. Furthermore, we plan to create short videos explaining the product advantages and tips, which will be uploaded ...
I need someone to assist with ZMNinja from ZoneMinder. I am getting API Errors, but everything seems fine with the server
...site using WooCommerce. The site is for selling digital products and will require custom design work. Key Requirements: - Development of a complete WooCommerce store: This includes product listing, checkout, cart, and all the necessary pages. - Custom Design: I need a visually appealing site that is unique and reflects the brand's image. You will be responsible for the design aspect. - Stripe Integration: The payment gateway to be used for this eCommerce site is Stripe. Ideal Skills and Experience: - Proven experience in developing eCommerce sites, particularly with WooCommerce. - Strong understanding of UI/UX principles. - Proficiency in customizing designs within WooCommerce. - Prior experience with integrating and configuring Stripe payment gateway. - Good communication...
I need a skilled Node.js developer to implement s...Requirements: - Modify the game logic: Primarily, I want to change the scoring system. This will require a deep understanding of how the game currently operates and how to adjust it effectively. The new scoring system should enhance user engagement and retention. - Connect APIs from other websites: I need to integrate external services into the game, which will require knowledge of API integration processes. This integration should be seamless and reliable, and will play a crucial role in the game's overall functionality. - Implement JWT token for user authentication - Basic error fixing: There are some minor issues in the existing code that need to be addressed. An attention to detail and the ability to trouble...
...Additionally, I need help in creating a small WooCommerce database interface. The specific requirements: - Socket Programming: You will be responsible for establishing a server connection, sending and receiving data packets, and managing socket errors. - WooCommerce Database Interface: We will be integrating a small interface to manage product inventory. In this case, we are looking for basic integration - primarily focused on reading product data. The ideal candidate should have: - Proven experience in C# programming, particularly with a strong understanding of socket programming. - Prior experience working with WooCommerce or similar e-commerce platforms for database interface design. - Ability to deliver precise and efficient coding solutions. - Proficient in working with ...
Tengo un error en codeigner con la api de mikrotik , necesito hacer funcionar este script corrigiendo este error: }catch(Exception $e){ return $e->getMessage(); } } } } // Mikrotik API if (!function_exists('mkClient')) { function mkClient() { return new PEAR2NetRouterOSClient(settings()[0]->mkipadd, settings()[0]->mkuser, settings()[0]->mkpassword); } } // Mikrotik API Util if (!function_exists('mkUtil')) { function mkUtil() { return new PEAR2NetRouterOSUtil(mkClient()); } } Class 'PEAR2NetRouterOSUtil' not found
I'm using the payment gateway plugin called 'MercadoPago' on my WooCommerce store. I need to duplicate this plugin to be able to use it for both Colombia and Mexico. Currently, the plugin is configured for any country by entering the corresponding API Key and API Secret. However, WooCommerce doesn't allow having two identical plugins installed. I will provide the functional plugin, and you will make the necessary changes within the plugin so that Woocommerce does not detect it as a duplicate plugin, and does not have compatibility problems with the original plugin
...staff onboarding /offboarding , absence management , time tracking management , leave management , payroll management , online pay slips , request management , document management Key Functionalities: - Payroll System: I need a comprehensive payroll system that can accurately calculate and manage employee salaries, deductions, and tax withholdings. Integration or Custom Built: - I am not sure whether I prefer a custom built HRMS or integration with an existing platform. I am open to suggestions and recommendations from the freelancer based on their expertise and experience. Skills and Experience: - Experience in developing and implementing payroll systems for existing businesses. - Knowledge of HRMS best practices and compliance regulations. - Proficiency in relevant pr...
...diposiciones del RDLC, todo esto en tiempo de ejecución. Es decir paso 4 outputs distintos y me genera un PDF con datos dispuestos coherentemente. Todos los archivos Inputs y Output van en el zip adjunto. Se puede partir con una prueba de concepto, en donde se pinten al menos un par de campos en las posiciones basadas en el RDLC y tambien la tabla de datos que corresponde de los nodos Detalles del XML llamado dtetimbrado....
I'm looking for a skilled professional who can help me monetize my Kannada News Blog through advertisements. - The primary method of monetization should be the integration of various types of advertisements such as banner ads, video ads, and native ads. - The goal is to increase the visibility of my blog, and potentially have it featured in the 'Discover' section. - Your responsibilities will include setting up the ad placements, optimizing their performance, and ensuring they are relevant to the content of the blog. Ideal candidates should possess: - Prior experience in monetizing websites, especially news blogs. - Proficiency in setting up and managing different types of online advertisements. - A good understanding of the Kannada language and the target audience&...
1. *Data Collection and Analysis:* Gather historical and real-time cryptocurrency market data, cleaning and processing it for meaningful insights. 2. *Algorithm Development:* Utilize Python's machine learning libraries to create predictive models capable of identifying potential trading opportunities. 3. *Risk Management Integration:* Implement risk mitigation strategies within the algorithm to minimize potential losses during volatile market conditions. 4. *Backtesting and Optimization:* Test the algorithm's performance using historical data to refine and optimize its effectiveness. 5. *Live Testing and Deployment:* Gradually introduce the algorithm to live market conditions, continuously monitoring and fine-tuning its performance.
...can fulfil my requirements. Key Features to be added in my website: - Interactive HTML and CSS website preview(like section preview in ) - Code received from an API - Selectable HTML elements, with selection passable to an API - Editable HTML text and optional images - Chat-like text box popup on selecting HTML elements Level of Interactivity: - Basic interactivity is needed for the HTML/CSS website preview. This includes hover effects and clickable elements. Ideal Skills and Experience: - Proficiency in Flutter, with prior experience in front end development - Strong understanding of HTML, CSS, and API integration - Ability to create a user-friendly and interactive web interface - Good problem-solving and communication skills If you're a talented Fl...
I need a Node.js expert to finalize the OTP system for user registration on my website. Key Requirements: - Full Implementation: The system is partially implemented, and I need someone to complete it. The project involves integrating OTP functionality into the user registration...- OTP Delivery: The OTP should be sent to users via SMS. - and when user forget password it ask otp Pages are already created Ideal Skills and Experience: - Proficient in Node.js: As a core requirement, you should have extensive experience with Node.js development. - Authentication Systems: Prior work on OTP-based authentication systems is highly desirable. - SMS Integration: Experience with SMS gateways and API integration is a plus. Please note, I am looking for a prompt completion of...
necesito crear una api en power bi para encontrar a un santiagueño
I'm looking to automate podcast transcription service. 1. I need a service to follow Podcast Rss Feeds and listen for new episodes 2. I need Listen Notes to download the podcast audio file 3. I need Chatgpt to transcribe the audio file 4. I need an output of the transcribed text made into a google document 5. I ne...transcribed text made into a google document 5. I need Chatgpt re-write the transcribed text into an article with a Title, meta text and the content of the article. 6. I need the re-written article to be saved in a Google document 7. I need the document to be re-written in 8. I need the re-written document by saved in google document You should know python and have api integration skill set you should know how to use and the process flow
I'm seeking a skilled developer to create an AI solution that mimics the conversational style of Elvis Presley. It's intended for a radio show, so integration with MP3 is essential. Key Requirements: - Conversational AI: The primary aim of this project is to have an AI that can engage in meaningful and charismatic conversations similar to Elvis Presley. The AI should be able to handle various topics and respond naturally to user input. - Natural Language Processing (NLP): It's crucial that the AI incorporates advanced NLP techniques to ensure its responses are coherent, contextually relevant, and sound like Elvis. Ideal Skills: - Experience with creating conversational AI interfaces. - Proficiency in Natural Language Processing. - Familiarity with integrating AI sol...
I am looking for a professional with experience in AWS API Gateway, Python, and possibly other related technologies to troubleshoot and fix a persistent connection issue I'm facing. Requirements include: - In-depth knowledge of AWS API Gateway, for REST API specifically - Solid experience with Python, as my backend system is built using this language The issue I'm having involves regular 'connection refused' errors when trying to fetch data from the API. This has been an ongoing issue, and I need an expert who can identify the root cause and implement a solution to ensure reliable, uninterrupted connectivity. It would be beneficial if you have experience in troubleshooting and resolving similar API Gateway issues in the past. A pr...
I'm in need of a skilled individual who is proficient in both PHP and Google Gemini. The primary task is to integrate this platform with my PHP website. Key requirements include: - Basic data syncing: The main goal is to ensure that the PHP website and Google Gemini can share important data seamlessly. This includes basic data such as user information, clicks, and impressions. The...to ensure that the PHP website and Google Gemini can share important data seamlessly. This includes basic data such as user information, clicks, and impressions. The ideal candidate must have: - Demonstrated expertise in PHP and Google Gemini. - Prior experience in integrating Google Gemini with websites. - Strong communication skills to understand my requirements and provide updates on the integrati...
Are you a creative and experienc...reading orientations for a seamless user experience. - Variety of Designs:Generate three distinct design variations to provide variety and cater to different preferences, ensuring each design is modern, entertaining, and engaging. - SEO Optimization:Implement SEO best practices for both Arabic and English languages to enhance visibility and drive organic traffic to the landing pages. -Domain Integration: Link all six domains associated with Rush Rooms to the landing pages, facilitating easy navigation and access for our platform. We need you to be expert and creative in making stuning landing pages with 2d/3d elments and expert in SEO arabic and english we need our landing pages to be in the top in the search engines. You should able to creat...
I'm looking for an experienced full-stack developer to build a custom admin dashboard for a Flutter app backed by Firebase. The dashboard should have a clean, minimalist design and robust functionality to manage the platform. Core Features: - Firebase Integration - Comprehensive Data Visualization - Content Management (Articles, Quizzes, Categories) - Feedback Management - Notification System (In-App, Push) Other Key Features: - Secure Admin Authentication - User Management (Roles, Permissions) - Content Packaging & Distribution - Content Localization - Import & Export Functionality - Settings & Integrations - Security & Compliance - Performance Monitoring & Optimization The ideal candidate should have: - Proven experience developing admin dashboards ...
I need a Python developer to create a bot that scrapes data from APIs on an hourly basis. - The bot's primary function is to scrape data - The data will be sourced from APIs - The bot needs to run on an hourly basis Ideal candidate: - Proficient in Python and API data scraping - Familiarity with creating bots - Able to ensure smooth hourly operation, possibly using a scheduling library such as APScheduler
...class, exam, hall, and scheduling. - CRUD Operations: The system should allow for Create, Read, Update, and Delete operations for the mentioned entities. Admin User Features: - Access Control: The admin user should have the ability to control user access and manage permissions. - Reports Generation: The system should be able to generate exam scheduling reports. I will provide you with the Swaggy API list for this project. The deadline for this project is Saturday night. Ideal skills and experience: - Proficiency in React - Previous experience in building CRUD applications - Understanding of user access control and reporting functionalities - Ability to work with provided APIs - Deadline-oriented with excellent communication. If you're confident in your React skills, h...
Hi there. I'm running XCode 15.3 and I need a few pages done with simple, clean storyboards and View Controllers. I use Alamo Fire and Swift, so if you could use that to pull my data via my API links and display it in several pages that would be great. Categories > Collections > Items > Item Details You select one and it shows a list - Item Details is one record from a MySQL db I need each selected item to be a variable in the code of the ViewController so if I use the print function, I can see it at the bottom of XCode. I'll give you the 3 or 4 API webservice links. I can give you a super simple app to put it in too...
I'm seeking a highly skilled professional to develop an Google Map API of my hotel. This API based project should include some distinctive customised data, such as: * Hotel Amenities: Don't worry about detailing each amenity, this was left vague on purpose. * Nearby Attractions: Not only should you include their names but also a description, how far they are from the hotel, and their rating. * Room Rates: Standard and peak rates. * Pickup and Drop Facility: A briefing about it * Cab Requirements: I do have some specific needs when it comes to this, but you'll learn more about them later. * "Book Now” Button: Yes, I even need a button on the map. Your experience in Google Maps API, data customization, and interactive design will be invaluable...
I'm looking for a talented developer to...sales reporting. Key Features: - Web-based POS system: The system should be accessible through the website itself, offering an intuitive interface for easy use. - Daily Sales Reporting: It's crucial that the system provides detailed and comprehensive daily sales reports. These reports should be easy to read and interpret. - Customization: The system should allow for future customization and integration of additional features, as the business grows. Ideal Skills: - Proven experience in developing POS systems, particularly web-based. - Strong understanding of sales reporting and data analysis. - Ability to create user-friendly interfaces. Please share relevant experience, and provide a detailed proposal outlining how you would ap...
Description: We are seeking a skilled freelancer to integrate soc...functionality into our WordPress website for users, utilizing the PeepSo theme with integrated plugins. The task involves creating developer accounts, obtaining API access, and remotely installing keys and APIs. Please note that admin access will not be provided; all installation must be performed remotely. Deliverables: - Developer accounts created & validated on selected social media platforms. - API access keys and tokens securely generated and stored. - Integrated social media login functionality on the WordPress website. Additional Information: The freelancer will be required to have expertise in WordPress development, PHP, and API integration. Familiarity with PeepSo theme and so...
To integrate my Elmo alarm system with openHAB through bi-directional binding, I need a developer with openHAB and Elmo experience. The binding should be developed for E-connect, Elmo's cloud integration model. The features I'm after are: - Arm/Disarm functionality - Real-time status updates - Alarm event notifications - Sensing and sending sensor status to openHAB items. Anytime there's an event, status change, or a sensor goes on/off, I need the binding to provide immediate updates. Your skills in openHAB binding, Java, and IoT integrations will be essential for this project. The same project is just written in python for homeassistant
...creating successful e-commerce platforms. - It's crucial that the site supports a shopping cart feature, enabling customers to add, remove, and manage their selected products easily. - Customer reviews play a significant role in building trust and credibility. The site must include a review system for customers to share their opinions on the products. - A secure and reliable payment gateway integration is essential. The developer should have prior experience with different payment methods and be able to ensure a safe transaction process for customers. - I plan to sell between 50-100 products on the site, so the platform should be able to handle this volume seamlessly. Ideal skills and experience: - Proven track record in developing successful e-commerce websites - Proficien...
I'm looking to integrate Pusher into my Laravel 11 project to facilitate real-time transactional notifications. Key Requirements: - The goal is to have Pusher handle real-time notifications for transactional events in the application. - These are intended to be transactional notifications, so they should be triggered by specific events or user actions and delivered to the user immediately. - The notifications will be based on predefined templates, meaning they should follow a consistent structure and format. Ideal Skills and Experience: - Proficiency in Laravel, with prior experience integrating Pusher for real-time communication. - Experience with developing and implementing transactional notification systems. - Strong understanding of front-end development to ensure notificatio...
Hello Aldin, As we discussed, i will wotk on ocr , spring boog boot api. I will pro ide the app on or before 15 days from today. Thanks Sabareesan
I need a seasoned web developer for my e-commerce website project; specific coding languages and frameworks are flexible as the user skipped the relevant question. The primary goal is to create an e-commerce site with certain critical features. Important Points: - Must-have E-commerce features: Payment gateway integration and a system for customer reviews and ratings are essential. - Skills and Experience: Web development experience is necessary, preferably with a focus on e-commerce sites. Knowledge in PHP, Python or JavaScript would be advantageous, but not mandatory. - Objective: The ultimate goal of this project is to create a user-friendly platform where customers can make purchases smoothly and share their experiences via reviews and ratings.
I'm looking for someone to integrate an existing machine learning model into a Discord bot. The bot should cater to three main functionalities - sending daily race predictions, responding t...outcomes, and providing real-time race updates. Key Requirements: - Integrate an existing machine learning model into a Discord bot - Implement a feature to send daily race predictions on a specific channel - Develop a query system that effectively responds to user queries about race outcomes - Enable the bot to provide real-time race updates Your Skills: - Proficiency in machine learning model integration with Discord bots - Experience in developing chatbots, particularly for Discord - Knowledge of horse racing and related terminologies - Ability to create an efficient and responsive r...
As a professional in need of a portfolio website, the main objective is to create a sophisticated and corporate online presence that showcases my work. I'd like to have a blog section incorporated into the design, which will allow me to share my insights and valuable content with the audience. Key requirements: - Development of a responsive portfolio website - Integration of a blog section - Design should be professional and corporate - Final product can be comparable to this example The ideal freelancer for this project should be experienced in web development, particularly in creating portfolio websites. The ability to design in a professional and corporate style will be crucial. A good understanding of user experience (UX) design will also be important, to ensure
...Automate the process of contacting couriers via Outlook, including sending inquiry emails and processing their responses. Automate Order Processing: Automatically generate an order form based on the selected courier's details, convert it to PDF, and send it to the courier for confirmation. Technical Requirements: Platform: Microsoft Excel and Outlook. Preferred Methodology: VBA for seamless integration with Microsoft Office suite. Other suggestions are welcome if they provide a better solution. Deliverables: Automated Excel Workbook: An Excel file with VBA scripts to automate data entry, courier selection, and order form generation (if chosen methodology). VBA scripts to automate sending and receiving emails via Outlook (if chosen methodology). Documentation: Detailed do...
...currently leveraging several Zoho applications including CRM, Books, Inventory, People, Recruit, Shifts, Project, Survey, and Forms. I am seeking a skilled freelancer who can effectively integrate these applications with our existing ERP system. Key project aims include: - Customer data synchronization: Ensuring consistent, accurate customer information across platforms. - Order management integration: Streamlining order processes for increased business efficiency. - Inventory management synchronization: Maintaining real-time, synchronized inventory data between Zoho and ERP. With 11-50 users expected to utilize this integrated system, the ideal freelancer should not only possess strong experience with Zoho One and ERP integrations but also have a deep understanding of ...
I'm in need of an intermediate level mentor to guide me on XML and XSD through Zoom. I want to explore these technologies further and their practical applications. Key points: - Intermediate level expertise: I'm looking for someone who can provide me with in-depth understanding and hands-on experience in XML and XSD. - Zoom sessions: You need to be comfortable with conducting mentoring sessions over Zoom. Please ensure good communication and screen sharing abilities. - Live Screen Sharing Feedback: I prefer feedback to be given in real-time during our sessions. This will allow for immediate clarification and implementation of suggestions. Ideal skills and experience: - Proficiency in XML and XSD. - Prior mentoring or teaching experience. - Excellent commun...
I'm in need of an experienced developer to provide long-term maintenance for my e-commerce website. The ecommerce is up and running and fully operational and we need a FULL STACK developer that can code in ALL AREAS of the webapp. - Frontend: React (JavaScript) - Backend: Node.js - Services: Python - Database: MySQL RESPONSIBILITIES: - Integration of new B2B APIs - New payment gateway integration - - Implementation of bug fixes and performance improvements. - Regular software updates and security patches. - Feature additions and enhancements. Skills and Experience: - Proven experience in maintaining e-commerce solutions. - Proficiency in React, Node.js, Python, and MySQL. - Strong problem-solving skills. - Excellent understanding of software best practices and design...
I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.
...creating an XML file and validating it with an XSD file. I am trying to work with and XSD files but hitting roadblocks. The result I'm seeking is an XML file which encapsulates transaction data. This specific data will be gathered from a database, making database management skills essential for this project. Key things I require guidance on include: - XML element creation for transactional data pieces - Using a database for XML data source - Validating the XML with an XSD file The successful freelancer for this project will need a high degree of proficiency with XML and XSD files. They will need the ability to explain complex concepts in an easy-to-understand manner as this project is about learning these skills for me. A strong backgro...
I'm looking for a Figma expert to help cre...have the mobile version completed, but need the PC version developed. Key Requirements: - Figma Expertise: You should be proficient with Figma and able to easily translate the existing mobile design into a desktop version. - Ecommerce Design: Experience with e-commerce design is a big plus. Understanding of factors such as product catalog layout, navigation menu placement, and shopping cart integration is crucial. - Attention to Detail: You should be able to replicate the existing design on the desktop version, ensuring that no detail is lost in the translation. If you have a good eye for design, are proficient in Figma, and have a knack for e-commerce layouts, I'd love to hear from you. Please share examples of your previous ...
...ticket booking system specifically for Windows. Key features should include: - Ticket Booking: The software primarily needs to focus on facilitating ticket booking. It should be linchpin of the operation, thus needs to function seamlessly, quickly, and without glitches. - Booking Confirmation: Once a ticket is booked, an immediate confirmation should be sent to the user. This will require integration with email or other notification systems. - Seat Availability Check: Crucially, the software should allow users to check seat availability in real-time. This feature is crucial for making instant decisions on bookings. Ideal skills and experience for the project include proficiency in Windows-based software development and previous experience creating booking systems or similar s...
Please develop a Python script to retrieve restaurant data from Google Maps using the Maps/Places API. The script should specifically target restaurants that have a phone number but *without* a website. The inputs I need to enter are: - Location (latitude and longitude) - Search Radius (meters) - Restaurant Type (including catch all types in the "Food and Drink" category) Key Data to Retrieve, output in a .CSV: - Name - Address - Phone Number - Google Maps URL Ideal skillset: - Proficient in Python - Strong experience with Google Maps/Places API - Ability to deliver results promptly and efficiently - Attention to detail to ensure accurate data retrieval
