Vba access ado as400 start command työt

Access-tietokanta, joka sisältää tiedon syöttämistä, raportteja ja mahdollisuutta muokata tietoja.

Your task is to design automated solvers for the shift and Vigen`ere ciphers. You must use C as the underlying programming language, in order to get prepared for the following assignments. Each solver should be completely automated, i.e., upon reading a text file containing the target ciphertext (given as command-line argument), it should print the encryption key and the decrypted plaintext without any user interaction. Test your code on the following ciphertexts, and answer these questions: (a) What is the key of the cipher? (b) What is the decrypted plaintext? Ciphertext 1 (shift cipher) ODKBFAXASKBDQEQZFEMPURRUOGXFKZAFRAGZPUZZADYMXMOMPQYUOPUEOUBXUZQEFTQZQQPRADFTQBDABQDUZFQDM OFUAZARODKBFASDMBTKMZPODKBFMZMXKEUEFTUEMDUEQEAGFARFTQRMOFFTMFUZFTQMNEQZOQARDQMXOAYYGZUOMF UAZEDQCGUDQYQZ...

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.

I require a proficient developer who can code a stock checker bot for Lowe's. The bot will need to be compatible with Discord, as we'll be using commands there to pull product ID and zip code data. Key details include: - It must be coded in Python. - The bot should track stock availability at Lowe's ...coded in Python. - The bot should track stock availability at Lowe's for a specified zip code, in real-time. Requirements: - Competency in Python is a must. - Previous experience in developing bots compatible with Discord. - Understanding of real-time data tracking. - Knowledge of Lowe's system or similar would be advantageous. The final deliverable should enable users on Discord to run a command with the product ID and zip code to get real-time results...

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

I'm urgently seeking a Django expert to develop a backend application for my project. This application requires: - User authentication and authorization, roles: Global Administrator: - Access to everything Application Administrator: - Access to application and data for all companies Company Administrator - Access to all applications and data for companies assigned to them Application roles (not administrator) - Supervisor - HR - User - Database: PostgreSQL - Integration with external APIs - Data processing and manipulation functionalities - Integration with a National ID validation API: - Security: JWT Token APIS: 1. User validation (username - password) - method: POST OK - Status 200 { jwt_token, refresh_token, user{first_name, last_name},global_permission

I'm seeking a designer to create a minimalist landing page reminiscent of popular dating apps like Tinder, Bumble, or Hinge. The design should strike a balance between modernity and simplicity, p...concept for showcasing key features akin to a real app experience (e.g., background image reminiscent of the Tinder website). Space allocated for 2-3 videos or images featuring couples or testimonials. 2-3 prominent links to essential pages such as Terms & Conditions, Cookies, About Us, and Help. Convenient links for downloading the app from the Play Store and Apple Store. Social media links for easy access. The goal is to create a visually engaging and user-friendly landing page that effectively communicates the essence of the dating app while providing necessary information and...

...and find a license file to activate Labview. Unicorn 5.31 software needs a serial # to activate. I have lost the license from a fresh install and need it up and running again please. Key Requirements: *Experience in using a decompiler like x64dbg or similar tools for cracking software. Software is currently installed and ready for decompiling; preferably make a keygen after that inserts a jump command. • Familiarity with desktop-based software. • Must be able to complete the process without the need for additional purchases. *Teamviewer, Anydesk connection Upon project acceptance, I will provide the contractor with the necessary installation files. Please place your bids after considering the job requirements and complexity. Prompt and successful completion could lea...

...interactive and informative charts, graphs, and visualizations based on geofenced data. Utilize tools such as Tableau, Power BI, or similar platforms to convey insights effectively. 4. Cloud Platform Automation: Utilize cloud platform databases (e.g., AWS, Google Cloud Platform, Azure, etc.) to store and manage geofenced data efficiently. Automate database processes to streamline data handling and access. 5. Quality Assurance: Conduct thorough testing and validation of geofencing solutions, data integrations, and visualization tools to ensure accuracy and reliability throughout all stages of these processes. 6. Documentation and Reporting: Document processes, methodologies, and results effectively. Recommend and design reports and insights from geofenced data for stakeholders ...

... etc. • Take pictures of the subject company and its vicinity, as per Confirmis’ standard operating guidelines. • Provide observation about the company to gauge activeness, e.g., staff working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) Viale Luigi Majno, 26 20129 Milano MI • Has a camera or phone/tablet of quality with a camera, internet access • Must be available during business hours (9 AM - 4 PM) on working days Please see the attached file for the site visit guideline. You are only required to deliver the pictures, video & observations and are not expected to put together a report like the Sample Report. Note: Milestone will be released the following week after the site visit to g...

I need a skilled developer to modify a client-side executable file that connects to our gaming system. This file will allow users to interact with key features of our game. Key Requirements: - Modification of a client-side executable file through Configuration - Compatibility with Windows Operati...connecting to the old URL which already does not work (Gacha, Guild). We need to replace it with our current server URL (change the url pinpointing). The solution must be dynamic which means we can later on change it again without needing another development again in the future. Game client file that pinpoint to our test server environment will be shared once we had start the project. A sample of config that currently we use to access this client file is provided within this pr...

...of business, key executives' names, etc. • Take pictures of the subject company and its vicinity per Confirmis’ standard operating guidelines. • Provide observation about the company to gauge activeness, e.g., staff working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) Thane, India • Has a camera or phone/tablet of quality with a camera, internet access • Must be available during business hours (9 AM - 4 PM) on working days Please see the attached file for the site visit guidelines. You are only required to deliver the pictures, video & observations and are not expected to assemble a report like the Sample Report. Note: Milestone will be released the following week after the site visit to ...

We are seeking a skilled Python language tutor to provide online tutoring sessions for a group of three individuals consisting of two ...Provide clear explanations and examples to facilitate understanding. - Offer assistance with coding exercises and assignments. Requirements: - Proficiency in Python programming language. - Previous experience in tutoring or teaching Python to beginners. - Strong communication and interpersonal skills. - Fluent in French, as the sessions will be conducted in French. - Reliable internet connection and access to video conferencing tools for the online sessions. - Ability to create a structured learning environment conducive to learning and retention. Duration: 15 days, with four sessions scheduled throughout the period. We look forward to receiving ...

...business, key executives' names, etc. • Take pictures of the subject company and its vicinity per Confirmis’ standard operating guidelines. • Provide observation about the company to gauge activeness, e.g., staff working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) Valsad, Gujarat • Has a camera or phone/tablet of quality with a camera, internet access • Must be available during business hours (9 AM - 4 PM) on working days Please see the attached file for the site visit guidelines. You are only required to deliver the pictures, video & observations and are not expected to assemble a report like the Sample Report. Note: Milestone will be released the following week after the site visit to ...

...business on Google Maps. Provide timely and regular updates on the progress of review submissions. Requirements: Prior experience in providing Google Maps reviews is preferred. Ability to write compelling and genuine reviews that reflect positively on our business. Familiarity with Google Maps review policies and guidelines. Strong attention to detail and commitment to quality. Reliable internet access for submitting reviews. Payment: Payment will be provided on a per-review basis or as agreed upon. We are open to negotiating rates based on experience and quality of work. If you are interested in this opportunity, please submit your proposal detailing your experience in providing Google Maps reviews and your proposed rates. Additionally, include any relevant samples of your pre...

I'm seeking a proficient writer with a proven track record in personal branding, ideally with expertise in constructing engaging professional bios, slick LinkedIn profiles, and user-friendly websites. Key tasks include: - Drafting a compelling professional bio, embellishing on my education, qualifications, work exper...place to go in-depth. My linkedin profile would fall somewhere in between (given Linkedin's format and constrains) Candidates with a firm grasp of personal branding and experience in web content management will be given priority. The ideal candidate should have an innate knack for capturing and amplifying a professional persona across multiple platforms. A keen attention to detail and a strong command of English are also necessary to convey important inf...

...of business, key executives' names, etc. • Take pictures of the subject company and its vicinity per Confirmis’ standard operating guidelines. • Provide observation about the company to gauge activeness, e.g., staff working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) Basra, Iraq • Has a camera or phone/tablet of quality with a camera, internet access • Must be available during business hours (9 AM - 4 PM) on working days Please see the attached file for the site visit guidelines. You are only required to deliver the pictures, video & observations and are not expected to assemble a report like the Sample Report. Note: Milestone will be released the following week after the site visit to g...

Development of E-commerce Platform with Integrated Payment Split We are looking to develop an e-commerce platform wi...the platform, with a fee charged for each transaction. This fee needs to be divided into three distinct parts: for the merchants, for the marketplace, and for the payment gateway. The platform will operate under a subscription service model for buyers. To make purchases on the platform, the user will need to choose a subscription plan and make the payment. Only after this process will they have access to the functionality to purchase products offered by partner merchants. We are seeking a solution that meets these specific requirements. If you have a ready-made solution that can integrate these requirements, we would like to evaluate it and discuss the hb bolly r...

...Rust-Jackpot-Website. Project Specifications: - A maximum of five pages to keep it simple and intuitive. - Design should be original yet can draw inspiration from existing websites. Design Concept: - I already have some design ideas but they are not finalized, and I will need help in refining and implementing them. Steam API Functionalities: - Item prices update automation - Player item inventory access - Trade offer management User Management: - The website will require user registration and login. Developers should be adept in integrating this functionality with the Steam Login API. Ideal freelancers should have a portfolio of similar projects and a sound understanding of the Steam Market. This project will suit someone who has great communication skills and can work ...

...and its vicinity per Confirmis’ standard operating guidelines. • Provide observation about the company to gauge activeness, e.g., staff working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in Capital or Southern Manila District (Manila/Las Piñas/Makati/Muntinlupa/Parañaque/Pasay/Pateros/Taguig) • Has a camera or phone/tablet of quality with a camera, internet access • Must be available during business hours (9 AM - 4 PM) on working days Please see the attached file for the site visit guidelines. You are only required to deliver the pictures, video & observations and are not expected to assemble a report like the Sample Report. Note: - 1 city can only be taken by one freelancer (on a first-come, fir...

...business, key executives' names, etc. • Take pictures of the subject company and its vicinity, as per Confirmis’ standard operating guidelines. • Provide observation about the company to gauge activeness, e.g., staff working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) Barcelona, Spain • Has a camera or phone/tablet of quality with a camera, internet access • Must be available during business hours (9 AM - 4 PM) on working days Please see the attached file for the site visit guidelines. You are only required to deliver the pictures, video & observations and are not expected to put together a report like the Sample Report. Note: Milestone will be released the following week after the site...

I'm seeking a professional who can help me track the location of an Android and iPhone phone remotely for employee monitoring purposes. Key Requirements: - Secure and remote tracking: I don't have direct access to the phones I need to locate, so a solution that can track these phones without any physical access is crucial. - Stealth monitoring: The tracking should be discreet and undetected by the phone's user. - Accuracy and Reliability: The location tracking should be accurate and reliable to help me effectively monitor my employees' movements. - Real-time updates: I would prefer to receive real-time updates on the locations of the phones whenever possible. - Compatibility: The solution should work on both Android and iPhone devices. Ideal Skills and ...

I need a skilled Flutter developer to build an application tailored to businesses. The app should work seamlessly on Android, iOS, and Web platforms. Key features for the application to include are: - User Authentication: The app must have a secure login mechanism to allow businesses to access their unique profiles. - Push Notifications: There should be a smart notification system that informs the users about any updates or important info regarding their account or app usage. - In-App Messaging: The app should facilitate in-app communication to enable businesses to get answers to questions or troubleshooting assistance. The ideal freelancer for this project should not only be proficient with Flutter but also have a strong understanding of secure authentication methods, push notifi...

...salesperson. This person calls potential customers and takes orders directly, which are then sent with a delivery note and UPS. To do this, the employee must also access this market using the GLN number. If a market has already ordered goods, this market should be marked in the list for the field staff so that they can see that it no longer needs to be visited. additions If a supermarket has not reordered after x (4) weeks, then it should receive an automatic email/fax asking whether it should reorder. If the supermarket has not ordered within x (7) days, this supermarket must be added to a telephone list. An employee who has access to the list calls these supermarkets. If he called the supermarket, the employee must mark the market that he was called. To do this, th...

I'm looking forward to creating an extensive LoRa mesh network with more than 50 nodes. The primary purpose of this setup is for smart city infrastructure, industrial monitoring, and agricultural monitoring. This network will majorly handle the transmission of sensor data, commands for execution, scheduled on/off, node grouping, node discovery and group command. Ideal skills and expertise include: - Solid understanding and experience with LoRa Mesh networks - Ability to design and implement a network for more than 50 nodes - Experience with integrating sensor data, executing commands, scheduling on/off, node grouping, and disseminating group commands - Familiarity with smart city infrastructure, industrial monitoring, and agricultural monitoring applications. Succinctness, a...

I need an expert in VPN routers to assist me in setting up a router for a VPN switch. To show I am working in USA while I live in another country

Need some to program me a small function in this sdk to add RFID verification & then open gate for the user using following SDK.

This project focuses on configuring an existing high-performance computer to process and query large datasets using the Llama3 (70b) language model. The objective is to ...Operating System: Windows 11 or Linux Set up and optimize the Llama3 (70b) language model on the local system. Process 2,300MB of data to be optimized for use with the Llama3 model. Develop a user interface or command line utility to facilitate local data queries using the Llama3 model. Deliverables: Configuration and optimization of the existing computer system for the Llama3 model. Successful installation and setup of the Llama3 language model. Processed dataset, ready for efficient querying with the Llama3 model. A functional user interface or command-line tool for querying...

I need a website to create and manage redemption codes. Redeem codes should be generated automatically after creating the product offer, based on available stock of the product. The system must "burn" the code once it is used. Key requirements: - Frontend: Clients will access the code redemption page through a url provided by us. - Backend: Random code generation: the system must be able to generate redemption codes randomly in URL format. - The Backend page must have 3 sections. Create Offer / New Orders / Reports - Code management: the site must burn the codes already used. - Easy to use: the system must be intuitive and easy to use Ideal skills and experience: - Web Development: Competent in web development - Code Generation: Experience in implementing random code g...

I am interested in becoming proficient in navigating the platform for procurement purposes. As a result, I am seeking an Online Training Procurement Specialist who can provide personalized training sessions. Specifically, I would like to learn how to: Efficiently use for contract opportunities. how to search active contract able to bid Access contract data and reports. Understand how submit winning proposal how to fill up 1420 form Navigate the federal hierarchy and assistance listings. If you or your individual able to offer training services related to , I would greatly appreciate the opportunity to learn from your expertise. Please let me know if you can recommend someone or you available to offer me training..

I am seeking a skilled PHP developer to help me resolve an i...randomly, making it hard to predict and debug. Key Requirements: - Experience in PHP development - Strong knowledge of error debugging techniques - Ability to work with limited access to the codebase Your responsibilities will include: - Analyzing the codebase to identify the root cause of the error - Implementing a fix that will resolve the issue - Providing a comprehensive explanation of what caused the error and how it was fixed Given that the error only appears intermittently, it's crucial that you have a strong understanding of PHP development so you can quickly identify and resolve the issue. Also, the limited access to the codebase makes it essential that you are highly skilled in working with isol...

crear un instalador con cual pueda instalar selenium vba a computadoras de 32, 64 bits (debera poner el diriver chrome actualizado segun la arquitectura de la computadora), con sus driver Chrome actualizado segun la última version del navegador. - Agregar la librería de referencia de selenium vba a excel Todo esto de manera automática, sin presentar alguna interaccion por parte del usuario extra, aparte de la tipica instalacion selenium: Chromedriver:

I'd like an experienced developer to build a web application using C#. This application should have a functional interface interaction and efficient database management capabilities. I also need the implementation of an API for authentication and authorization purposes, ensuring secure access. Key expertise necessary: - Proficient in C#, ASP.NET - Strong skills in database management - Experience in UI design and interaction - Expansive knowledge in API integration, specifically for authorization and authentication.

"The Student Support Hub" is a tech platform designed to provide a safe and supportive environment for students struggling with mental or academic challenges. The project offers an interactive interface that connects students, academic advisors, and parents, facilitating communication and necessary support. It allows students access to various resources including educational articles, expert advice, and opportunities for personal communication with advisors. Through these tools and resources, students can feel the support, encouragement, and guidance needed to achieve their academic and personal success.

...runtime error in my ChatGPT Excel VBA script, specifically during data analysis. I need an experienced VBA developer to help me identify and resolve the issue. Key aspects of the project: - Debug a runtime error: The issue is occurring during the data analysis process. You'll need to identify the root cause of the error and implement a solution to ensure the script runs smoothly. Ideal skills and experience: - Proficient in Excel VBA: You should have a strong command of Excel VBA, particularly in handling data analysis tasks. - Debugging experience: Prior experience in identifying and resolving runtime errors in VBA is essential. - Familiarity with ChatGPT integration: While not mandatory, previous experience with integrating GPT mod...

...purchase solely, not fee payments or data transfer. - The interface for this automation tool will be command-line based. - There is no requirement for user authentication; the process should be seamless and without any user input required. The general working logic of the program should be as follows, We will give the CREATOR address of the token mint address that we will purchase through the program, so it will constantly control it via API. When the Mint address is found, it will buy and sell with the private key entered in the program, i.e. wallets. Ideal Skills and Experience: - Proficient in Rust and GeyserRpc. - Prior experience with Solana-based projects. - Capable of creating command-line user interfaces. - Strong understanding of blockchain transactions and...

I am looking for a committed, efficient, and tech-savvy virtual assistant to help streamline my activities and connect with my audience. Here's a nutshell overview of what you'd be doing: 1. Email Manageme...Assistance: Engage with my audience on both Facebook and Instagram. Posting updates, managing interactions and messages, and being involved in our online community are essential tasks. Including responding to positive reviews online from Google and Facebook. Skillset needed includes excellent organizational skills, proficiency in using social media platforms specifically Facebook and Instagram, good command of English, and a proactive mindset. The role is more than 20 hours a week, so I need someone who can commit to these hours. Familiarity with Google Workspace ...

...company efficiency through streamlined processes. Key objectives of the project include: - Designing a user-friendly interface: The software should be intuitive and easy to use for all team members regardless of their technical background. - Enhancing efficiency: The new software should improve the flow of work, reducing manual input and automating repetitive tasks. - Real-time data access: The ability to access real-time data is crucial for our project management, and the software should also have capabilities for data analysis. Ideal candidates will have: - Proven experience in developing custom software solutions, particularly in the construction industry. - Strong understanding of project management, financial tracking, and resource allocation. - Ability to streamlin...

ChatGPT is generating VBA to automate Excel data manipulation and other actions. As a VBA EXPERT, you will debug the code when it doesn’t do exactly what it was asked to. The project is being built module by module. There are about 6 modules.

I am looking for an experienced ASP.NET developer to create a Customer Relationship Management (CRM) system for my business. The system should have the following functionalities: - User Authentication and Authorization: The CRM should allow for different user roles with varying levels of access. - Database Integration and Management: The system should be able to store and efficiently manage data related to customer interactions, transactions, and any other relevant information. - API Integration: It should be able to communicate with other systems and services, ensuring seamless data flow and process automation. The primary goal of this application is to enhance our customer management capabilities. This will include, but not limited to, personalized customer interactions, efficie...

...various tasks within Excel, reducing manual work and minimizing errors. - **Data Visualization**: The software should also have the capability to visualize the data from my local files. The visualizations should be in the form of static charts and graphs. Ideal Skills and Experience: - Advanced Excel Skills: You should have extensive experience with Excel, including creating complex formulas, using VBA for automation, and chart creation. - Data Visualization Expertise: A strong understanding of data visualization techniques and tools will be beneficial. - Software Development: Experience in developing bespoke software within Excel would be advantageous. Please note that while the visualizations need to be created using Excel, I'm open to suggestions for automating spreadsh...

Want to setup one aws - subdomain for nodejs api to run - 2 public html domain website - install free ssl - provide proper ftp, putty access and ensure proper security to be taken care - Need to ensure no further issue come Only apply if you ok with 600 INR. and also in future ready to work on same price for 1 VPS setup work

I need someone skilled in Arduino for a robotics control project centered around security. Here's what I hope to achieve: - Integration of Arduino with an existing access control system. Ideal skills would be proficiency in Arduino programming, experience in security system control, and knowledge in automation. Your proposal would stand out if you have handled such tasks before and can complete the milestone within the budget of 2k INR. Looking forward to a successful collaboration.

I'm looking for a Virtual Assistant to grab leads, I’ll send material on how. It’s pretty simple. We'll specifically be targeting those who work in the nightlife industry and going down the research rabbit hole on Instagram. Ultimately I'm trying to sell high end social media services and night life people have access to a wealthy Rolodex so my goal is to gain a bunch of affiliates from this. Key Responsibilities: - Find mini partners (affiliates) in nightlife: vip hosts, promoters, club managers club partner companies, etc. - Inputing the above prospects info (names and emails) on a google excel sheet Skills and Experience: - Critical Thinking - Proficiency in using Instagram for business research - Experience in lead generation - Bonus: Experience...

...unique project involving Raspberry Pis and AWS Greengrass. Your main task would be to develop a system that allows Raspberry Pis to share updates with nearby devices offline. Key Requirements: - The system should be designed to share updates specifically with other Raspberry Pi devices running Raspbian, offline. - The purpose of sharing these updates is to cater to locations with limited internet access. This is essential for our project as it ensures that the devices can remain updated despite the lack of connectivity. - The system should be able to initiate the update process automatically. This means it should be able to detect nearby devices and share the necessary updates without requiring manual intervention. Ideal Skills and Experience: - Proficiency in Raspberry Pi hard...

I need a designer to create a captivating and informative poster intended for adults. The objective is not to promote a product or cause...Requirements: - Adhere to the principles of good design and maintain a professional look that appeals to adults. - Manage to convey a significant amount of information without overwhelming the viewer or compromising on attractiveness. - Due to incomplete details on the aesthetic preference, the designer should be skilled in adapting design styles as feedback is provided. Ideal Designer: - Excellent command of visual hierarchy and designing informative materials. - Experienced in graphic design, specifically in posters for adult audiences. - Open to iterative process and able to adapt designs based on feedback. SOMETHING SIMILAR TO THE ATTAC...

I'm looking for a skilled website developer to create a mental health website with the following features: - An online forum for community support - A resource library with articles and videos - An appointment booking system for therapy sessions - Screening tools - Online session capabilities - Access to various resources The ideal candidate for this project should have experience in developing clean and modern websites, with a special focus on user experience. Proficiency in integrating and customizing features for community engagement, appointment management, and content management would be greatly beneficial. Given the sensitive nature of mental health, a good understanding of privacy laws and data security is a definite plus.

I'm looking for a skilled website developer to create a sleek and user-friendly blogging website. The main focus of the website will be to provide educational content in a variety of fields. Key Requirements: - De...Requirements: - Development of a Blogging Website: I need a well-structured, modern blogging website that is easy to navigate for users. - Social Media Integration: Social media sharing and integration tools are essential for this project. - SEO Friendly: The website should be optimized for search engines to increase visibility. - User-Friendly Interface: A clean, intuitive design that allows easy access to a variety of educational content. Please showcase your experience in developing similar websites. Knowledge of SEO optimization and social media integration...