Crm retrieve data sql server työt

Usealla isolla yrityksellä on käytössään Suomessa eräänlainen heidän alansa ERP-paketti, joka on koodattu Visual Basicillä. Tarvitsisimme VB-osaajaa ylläpitämään ohjelmistossa mahdollisesti tehtäviä muutostöitä. Tekniikka lyhyesti: • Visual Basic -koodia noin 280-290 000 riviä • Integraatio taloushallintoon ja palkan maksuun • raporttipuolella n. 50 000 riviä • Crystal Reports • Microsoftin SQL Server -kanta Työmäärät vaihtelee, mutta keskimäärin 1-2 päivää/viikko. Välillä hiljaista.

Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). -------...

Konsultointipuolen yrittäjä hakee osa-aikaista assaria 15-20 tunniksi viikossa. Mieluusti työ tehdään kello kymmenen ja kuuden välillä. Tehtävänäsi on liidien generointi, tapaamisten sopiminen (chatissa) ja follow up. Päävastuut: -Identifioi hyvät liidit LinkedInistä jotka osuu meidän kriteereihin. -Laita niille kustomoituja viestejä LinkedInissä, sähköpostia jne. -Pidä meidän CRM ajan tasalla ja laita follow-upit ajallaan. -Träckää myyntiin ja liidien generointiin liittyviä numeroita. Vaadimme hakijoilta: -Sujuva suomenkielen kirjoitus. -Vakaa netti jossa Skype pelaa hyvin. -Detailorientoitunut ihminen joka pystyy keskittymään kyll...

Webservicen luominen sql tietokannalle. Perus toiminnot webservicelle ja kehitys ympäristön pystytys. Tarkempi speksi on saatavilla NDA:n kirjoituksen jälkeen. Kehitys mielellään Eclipse ympäristössä.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.

Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.

Java, J2EE, JDBC, SQL, java Threading,GWT,Html,CSS

CRM, reseller, finance, etc

server optimisation

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ŠŠ ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

...VPN/Internet gateway solution. This project involves building server software capable of authenticating client connections and providing access to the internet. Requirements: Master's degree or PhD in Computer Science, Cybersecurity, or a related field Extensive experience in internet security, privacy, and VPN technologies Strong proficiency in server-side software development Familiarity with OpenWrt and router firmware development (preferred) Passion for internet security and privacy Responsibilities: Develop robust Wireguard exit nodes and VPN server software Ensure seamless integration with existing client software and VPN router firmware Implement secure authentication mechanisms for client connections Design scalable server architecture for hos...

I'm seeking an experienced .NET developer with over 4 years of expertise in C# programming and SQL databases. Key Responsibilities: - Enhancing existing software application - Adding new functionalities The ideal candidate should possess: - Strong experience in C# programming - Solid knowledge and practical experience with SQL databases Be ready to dive into the project and help us bring significant functionality enhancements to our existing software. Your experience and skills in C# and SQL will be invaluable in this task.

I need a talented VB.net developer with a strong background in SQL Server. Key Responsibilities: - Develop software applications using VB.net - Efficiently manage databases - Designing, coding, testing, and debugging software applications using VB.NET. - Calling third-party API - Payment gateway integration - Stored Procedure Ideal Candidate: - Proven experience in VB.net development - Strong familiarity with SQL Server - Good problem-solving skills - Ability to work independently and meet deadlines. Please provide relevant work samples in VB.net development and describe your experience with SQL Server.

I'm looking for an experienced server administrator to optimize my dedicated server running Almalinux 9.3 + Plesk. The server is currently performing poorly with slow website loading times and database slowdowns, which is unacceptable as I regularly have more than 500 concurrent visitors. The primary focus of this project will be optimizing the server's Plesk settings, Postgres and MariaDB databases, and PHP 8.2 configuration. Key tasks will include, but are not limited to: - Configuring Plesk for optimal performance, including adjusting server pool size - Identifying and implementing improvements to Postgres and MariaDB settings to reduce slowdowns - Tuning PHP 8.2 to enhance website speed and performance Ideal candidates for this project will ha...

I'm seeking a skilled HubSpot professional to provide me with training. Although I'm a beginner, I'm eager to get up to speed on Marketing and Sales Hubs. My primary goals for using HubSpot are to enhance our lead generation, customer relationship management, and sales pipeline management. Key Requirements: - Strong experience with HubSpot, specifically Marketing and ...and Sales Hubs. - Prior training experience, especially with beginners. - Ability to tailor the training to my goals. Your responsibility will be to provide clear, engaging, and actionable instruction to help me utilize Hubspot effectively. You should be patient, good at explaining complex concepts simply, and able to adapt to my pace and learning style. A background in marketing automation and CRM...

...Bahmni: As an important aspect of this project, the candidate would need to integrate Odoo and OpenMRS with Bahmni. Having previous experience in integration with third-party software would be critical to execute and ensure seamless synchronization. The ideal candidate for this project should preferably have a robust background in working with Odoo and OpenMRS systems, Bahmni, and other renowned CRM systems. The ability to effectively improve the user interface and experience will be an essential deal breaker in this role. As a professional in software development, your innovative solutions for custom module development will play a pivotal role in enhancing overall functionality. I am looking forward to receiving bids from enthusiastic, hands-on individuals who are open to engag...

I'm searching urgently for an experienced PHP architect who can const...items. - Integrating an 'Add to cart and checkout' feature ensuring a simple and smooth transaction process. - Developing order management and inventory tracking system within the admin panel to help me keep track of orders and product stocks. Skills and Experience Required: - Proficient in PHP programming - Experience in developing e-commerce websites - Solid understanding of databases and SQL - Familiarity with different payment solutions Although there is no specific requirement for payment method integration at the moment, the ability to seamlessly add these in the future is essential. My project requires immediate attention and the chosen freelancer needs to be able to commit and delive...

...lots of Shopify repositories here: along with lots of code on the web. Ideally much of the functionality would come from already existing code, but GPT can also be used to rapidly develop code. Here's a breakdown of the APIs, webhooks etc. needed for the functionality we'd like: 1. Order Tracking Shopify Admin API: Use this API to access and manage order data, providing real-time tracking updates to customers. Webhooks: Implement webhooks to receive real-time notifications on order status changes. 2. Shopping Cart Management Shopify AJAX API: Use this API for a seamless shopping cart experience that allows customers to add items to the cart, update quantities, and view cart contents without reloading the page. Storefront API: Allows management

I was utilizing a server running Alamlinux9.3 with Virtualizor for my virtualization needs. However, after a recent reboot, the server failed to start up properly. Despite troubleshooting attempts, the system remains inaccessible. The datacenter has provided access to the server via sysrcd (SystemRescueCd), but I lack the expertise to efficiently recover the system and get it operational again. I am seeking assistance from experienced system administrators or IT professionals who have expertise in Alamlinux, Virtualizor, and system recovery. The goal is to diagnose the issue, recover the system, and ensure it is functioning correctly. Tasks: Diagnose the cause of the server failure after reboot. Implement necessary steps to recover the Alamlinux9.3 system. E...

...equipment or related industry. • Excellent communication and presentation skills, with the ability to articulate complex concepts in a clear and compelling manner. • Strong understanding of customer needs and the ability to tailor sales approaches accordingly. • Self-motivated and results-oriented, with a drive to exceed sales targets and deliver exceptional customer service. • Familiarity with CRM software and sales tools is a plus. • Passion for our products and dedication to promoting our unique value proposition. Benefits: • Lucrative commission structure with unlimited earning potential. • Comprehensive training and support to equip you with the knowledge and tools needed to succeed. • Opportunity to represent an industry-leading bran...

I need a professional to set up the WooCommerce Zapier plugin for me...professional to set up the WooCommerce Zapier plugin for me. The tasks include: - Configuring plugin settings - Creating Zapier workflows for automated tasks - Mapping data between Woocommerce and other apps - Ensuring customer details remain in the database on my site In addition, I require assistance in transferring the WooCommerce account ownership on my site to a new WooCommerce account. Ideal Skills: - Proficient in Woocommerce and the Zapier plugin - Experience in setting up automation workflows - Familiarity with CRM and email marketing platforms such as HubSpot CRM, Salesforce, and Mailchimp - Skilled in account management and data migration Please bid if you're confident in...

I am in need of a Telegram bot that can provide user registration and efficiently store and retrieve data from a Firebase database. Key Responsibilities: - Implement a user registration system directly on the Telegram bot interface itself. - Develop a clear and efficient data storage and retrieval process from the Firebase database. - Ensure that the bot can handle user profiles, user activity logs, and applications in the database. Ideal Skills and Experience: - Proficient in Python, especially for developing Telegram bots. - Extensive experience working with Firebase databases. - Prior projects that involve implementing user registration systems. - Strong understanding of data storage and retrieval systems. - Good communication skills to ensure the system i...

I am seeking an expert in AWS servers, particularly in the problem-solving aspect of EC2 instances. Key tasks to be performed: - Diagnose the specific issues of the server - Suggest and implement suitable solutions to rectify the problems - Maintain and improve server performance Ideal Expertise and Skills: - Strong technical skills and deep understanding of AWS, specifically EC2 instances - Proven track record in handling server emergencies and solving server issues - Competence in developing and maintaining customer-focused, high-performance AWS infrastructure - Proficient with best practices in ensuring server security

I'm in search of a proficient Sales development professional with a proven track record in Cold emailing and outbound campaigns. We are a remote bookkeeping firm targeting small business owners and CPA firms in the US We're looking for a superstar for Business Development and Linkedin outreach. You must be based in US. The job will consist of: - Reachin...generation. - Proficient in creating and managing outbound campaigns. - Proven track record in generating leads. - Deep understanding of B2B targeting. The ideal candidate should possess: - Strong communication and interpersonal skills. - A good understanding of Small Business landscape. - Ability to work autonomously to deadlines. - Strong analytical and problem-solving skills. - Familiarity with CRM software and le...

I urgently need an expert in Linux and Nginx who can help me: - Configure my Nginx server - Optimize server The ideal candidate should have: - Extensive experience with Nginx and Linux - Excellent troubleshooting and problem-solving Time is of the essence, so please get in touch if you can jump straight into action. Ubuntu Nginx

I'm looking to create a custom CRM platform that leverages NFC card technology, and an accompanying iOS app. Here's a breakdown of the project's key components: - **NFC Card Interface Features:** - Payment Processing: Users should be able to make purchases directly through the interface - Access Control: Secure access to certain information or features based on user roles - Loyalty Program Management: Implement a loyalty program to incentivize user engagement - User Portfolio: Users should be able to customize their interface with links, contact information, and product displays - **iOS App Development:** I need an iOS app to complement the NFC interface and provide a seamless user experience across different platforms. Ideal candidates for this p...

...a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual representations of data. - Previous experi...

...developer to create a Chrome extension that interacts with a specific API. The extension will need to accomplish the following: - Retrieve data from the given API. - Use the retrieved data to make changes to the user's browser. Key requirements: - The extension should use an API key for authentication. - Storing the API key in plain text is acceptable. Your role will involve: - Developing the extension in a way that is efficient and user-friendly. - Ensuring that the extension works seamlessly with the API. Ideal skills and experience: - Proficiency in Chrome extension development. - Experience in working with APIs and handling authentication. - Strong understanding of data processing and manipulation. - Attention to detail to ensure the extension is...

I want to set up an online shop on my website and have it connected to Fresha CRM, the system I currently use. This shop should have a sophisticated design that complements my brand image. Key Requirements: - Development of a product catalog with detailed descriptions and prices - Inclusion of a shopping cart and a seamless checkout experience - Integration of online ordering and payment functionalities - Payment gateway setup to accommodate credit card and bank transfer options - Customization to align with an elegant and sophisticated design style Ideal Skills and Experience: - Proficiency in e-commerce development and CRM integration - Strong portfolio of elegant and sophisticated web design projects - Previous experience with integrating payment gateways - Excellent un...

I am looking for an expert in RFID technology and .NET programming to integrate the RFID into our current weighbridge system. Key Details: - 3rd Party System was developed using .NET and it does support API or external interface connections. - The task will involve programming to fully integrate the system with RFID technology. Skills and Experience: - Proficiency in .NET programming & SQL Database - Previous experience with RFID technology - Knowledge of API integration - Experience with weighbridge systems would be a huge advantage. Your role will be to ensure the smooth functioning of the weighbridge system post-integration and provide us with a user-friendly, effective RFID solution.

...*** I'm facing significant challenges with my WooCommerce website's performance. Here's what I'm experiencing: - Slow page loading - High server load - Database query delays Although I’m already employing caching plugins and techniques for performance optimization, the difficulties persist. My WooCommerce site is hosted on a VPS/Dedicated hosting package. I'm in need of a WooCommerce expert who has significant experience in performance optimization, handling high server loads, and reducing database query delays. The ideal candidate should have: - Proven experience in troubleshooting and improving WooCommerce site performance - Strong knowledge of server management, particularly VPS/Dedicated hosting - Expertise in database managem...

...developer to help me with two main tasks, namely fetching data from a remote source and integrating a cryptocurrency payment option into my website. - Data Fetching: The fetched data, which will be in HTML format, should be displayed on a specific page of my site. Your task will be to use CURL to retrieve this content and have it dynamically updated on the website whenever the remote source updates. - Cryptocurrency Payment: I'd also like to have a cryptocurrency payment option incorporated into the site. The checkout should be seamless and intuitive for users, with the ability to complete transactions using popular cryptocurrencies. Ideal candidates for this project should have: - Proficiency in PHP and experience with CURL for data fetching ...

I am seeking a talented website developer to construct a formal, corporate-style ecommerce platform for my business. This high-quality site should be designed with the following features: - User registration and login capability - Product search a...the site, there would have to be membership levels, the site would sell merchandice and on-line coureses also charge for consultation on a timed basis. there would have to be upload and download capability for documents and images. it would be good if we could post to the social media account from the site. there would have to be a messaging system throughout the site (google workspace). Also a CRM as many messages to the site will be inbound leads. There can be other suggestions for development. scalablity, desktop, phone and tablet ...

• Experience with Testing tools Experienced using SQL Advanced experience developing test metrics and reports Experience with Automated Testing Five (5) • years of Testing experience in a Software Development Lifecycle environment Five (5) • SQL and PLSQL Programming in SQL Server ETL and Data warehouse process Informatica 10 • 20 Informatica Data Quality Profiles , Score Cards SQL Server RDBMS SQL Server Analytics Services SSAS SQL Server Reporting Services SSRS Tableau Reporting BMC Control M Scheduler Tool Data Analysis Data Profiling Application Life Cycle Management Complete Testing process SDLC, Agile Process, SAFE and Kanban methodologies, TFS Tool Good Communication...

...operations and customer interactions. In terms of functionalities, I require the following: - User authentication: The applications should have a secure login system. - Data storage and retrieval: The ability to store data and retrieve it when needed. - Integration with third-party APIs: Seamless integration with external APIs is a must. I'm expecting a relatively small user base initially, but these applications should be scalable and able to handle growth. Ideal candidates would have: - A strong background in low-code development - Experience in building web, mobile, and enterprise applications - Proficiency in user authentication, data storage, and API integration - The ability to design scalable systems - A good understanding of security principl...

...js application. These include improper error handling, server banner disclosure, and misconfigured CORS. Requirements: - Identify and rectify improper error handling, ensuring that user-friendly error messages are displayed and errors are logged for debugging purposes. - Address server banner disclosure, to enhance the security of the application. - Modify CORS configuration to prevent misconfigurations and enhance security measures. I am looking for an expert who is well-versed in AWS, particularly in working with applications. The ideal freelancer for this job should have: - A thorough understanding of AWS services and its integration with Next.js. - Proficiency in addressing security vulnerabilities, in particular server banner disclosure and CORS misconfig...

I need a fully bilingual professional (I will interview in English) to do some tasks for my agency such as: PR Outreach Content editing or creating CRM management Email marketing Email scraping Researching Organizing data in spreadsheets Copywriting Wordpress And others You must be a fast learner, attentive, curious, with great writing skills. Looking for someone that pays attention and doesn’t keep making the same mistakes. This job will start part-time as a test period, after that it will be full-time. Payment for part-time during trial period: Fee: 250 USD Performance bonus: 50 USD Results bonus: 50 USD If your work complies with my quality requirements and you give more than asked, you’ll get performance and results bonuses each month. After a tw...

...tailored to the gold and diamond jewellery industry. This system will be integrated with e-commerce and feature several additional modules. Key features required: - Inventory Management: The system should efficiently track our jewellery stock levels. - Sales Tracking: Real-time data on our sales performance. - Customer Management: To maintain a customer database. - Credit Management: Tracking outstanding credit and sending payment reminders. - Finance Management: Tracking income and generating financial reports. - CRM: To maintain good relationships with our customers. - E-commerce Integration: Development of a functional e-commerce website and application. - POS: A point of sale system for store transactions. - WhatsApp Features: Integrating WhatsApp for customer communi...

...This system will need to be compatible with both Windows and Mac operating systems. Key Features: - Inventory Management: A robust tool to manage my stock of jewellery items, including tracking and updating inventory levels in real-time. - Sales and Order Management: A seamless system to handle the processing of orders and managing sales records effortlessly. - Customer Relationship Management (CRM): A centralized platform to store and manage customer information, with a focus on providing personalized and exceptional customer service. - POS & Credit Management: An integrated point of sale system that also incorporates credit management functionalities. - Finance Management: A module dedicated to tracking financial transactions, generating reports, and managing financial rec...

I am looking for a skilled freelancer to effectively integrate Zoho CRM and Zoho Campaigns to enhance the functionality of our sales team. **Key Responsibilities** - Successfully integrate Zoho CRM with Zoho Marketing Campaigns - Ensure all features are functional and optimized for our sales team - Troubleshoot any issues during the integration process **Application Requirements** - In your application, provide a detailed proposal outlining your method for this project. This should include your process and estimated timeline for completion. **Ideal Candidate** - Extensive experience with Zoho CRM and Zoho Marketing Campaigns (eblast, google ads, etc) required - Previous successful integrations of these software would be advantageous

...innovation, respect, integrity, and a continuous quest for excellence. We are on the lookout for a commitment to leveraging Zoho CRM and Zoho Campaigns to enhance our operations and customer engagement. Position Summary: We are seeking a dedicated Zoho CRM & Zoho Campaigns Specialist to optimize our CRM strategies and processes. The ideal candidate will have a deep understanding of Zoho CRM & Zoho Campaigns capabilities and a proven track record of implementing and managing CRM solutions that increase efficiency and customer satisfaction. The Opportunity: As a Zoho CRM Specialist, you'll play a pivotal role in customizing, configuring, and maintaining our Zoho CRM system and Zoho Campaigns buildouts to improve our sales p...

I am looking for an experienced developer that have worked on the signal messenger app to rebrand the app change icons and colours. We need installation on our amazon instance signal server and included all required backed services database etc. and publish application with custom icon colours and icons markets google and apple. you can look signal application

We need a dedicated customer support telecaller to act as a devoted link to both our existing and potential customers. You will be responsible for offering support for our services, responding to inquiries, resolving issues, and ensuring overall satisfaction. This role requires:...telecaller to act as a devoted link to both our existing and potential customers. You will be responsible for offering support for our services, responding to inquiries, resolving issues, and ensuring overall satisfaction. This role requires: - A proven track record in customer support roles, ideally over the phone - Confidence and skill in handling all types of customer queries - Knowledge of CRM tools - Exceptional communication and problem-solving abilities - Experience with service-centric businesses...

We are currently struggling with our WordPress site which is plagued by slow loading times, frequent server crashes and persistent error messages. Given the criticality of the platform, We need an expert who is adept in Internet Information Services (IIS) server management running WordPress environment and troubleshooting it at server level. To be successful in this role, you should demonstrate the following: - In-depth knowledge of IIS servers and WordPress operations - Proven experience in diagnosing and resolving server and website errors - Proficiency in optimizing WordPress sites for enhanced performance Please note, no recent changes or updates have been made to the website or server configuration that could be contributing to these issue. I...

I'm in need of an expert who can help in developing a relational database using SQL and Python. The project will primarily revolve around database management. Consequently, I would appreciate assistance in the following tasks: - Designing a new relational database, ensuring it's optimized for efficiency and performance. - Implementing data import and export capabilities for seamless data movement. - Developing queries to support the database's functionality and ease of use. The ideal candidate for this project should have a strong background in both SQL and Python, with a specific focus on database development. Experience with optimizing databases for performance and some knowledge of data import/export mechanisms would be advantageous. M...

WhatsApp CRM with Scheduling & Workflows I'm looking to create a WhatsApp CRM that incorporates a variety of features to improve our customer relations and team management. Key Features: - Scheduling Surveys: The system should support date availability checks, scheduling and booking confirmation via WhatsApp to our staff. Their responses should organise them into yes and no groups. This will help us automate repetitive tasks and sharing of information to groups of people. - CRM Management: I am an agent to film ans supply extras for background. This requires searching for certain character features of our staff. For example brown hair, 5"4 female. of male 6'2 blonde. I then send a availability check to work on certain dates and if they agree i send...

I'm in need of an expert developer with a keen understanding of PHP, Heroku, and Shopify. This project entails the deployment of a Heroku server where my API key will be secure and stored in an environment variable. You'll also need to utilize this Heroku-based API key on my Shopify platform to access and display user data through API calls. Ideal Skillset and Experience Required: - Proficiency in PHP - Expertise in deploying and managing Heroku servers - Understands how to secure API keys on Heroku - Experience with Shopify API integration and displaying data.