SQL Database migration jobs

As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting sol...Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to delivering high quality and defect-free output is imperative. Looking forward to he...

...website, currently on version 5.4, is presenting a 404 error and deprecated warnings. Sadly, I do not have access to the original server the site was hosted on before migration, and I'm unable to specifically point out if any plugins or themes may be causing these warnings. This project requires a skillful WordPress expert who is familiar with: 1. AWS migration 2. Troubleshooting for WordPress version 5.4 3. Identifying and resolving 404 errors and deprecated warnings 4. Investigating possible plugins or themes issues Ideal candidates should have proven experience in troubleshooting WordPress issues, specifically in a post-migration context. AWS proficiency is a big plus because of the platform's involvement. I welcome suggestions and look forward to re...

I'm urgently in need of a qualified developer to create a pipeline utilizing DBT and SQLLITE. T...appropriate error logging and handling mechanisms Ideal Skills and Experience: - Strong proficiency in DBT and SQLLITE - Experience with data pipelines, specifically involving text file processing - Familiarity with data transformation techniques - Quality assurance and bug fixing capabilities Deliverables: ● A DBT project containing models for company_analytics and skills_analytics tables. ● SQL scripts or DBT models to process JSON files and populate the analytics tables. ● Instructions for running the DBT command to process the data and execute data quality checks. ● Documentation on adapting the pipeline for continuous file deliveries and suggested additional data quality me...

I need a power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: -Retrieve product ID, Quantity and Location -Gather specific production data includin...production number. Ideal skills: -Proficient in DAX query language -Comprehensive experience with Power Bi -Excellent attention to detail -Previous experience in inventory data management will be a plus. What to do: I need to get a query in DAX (Power Bi) that gives me the same result as what I show in the excel file ( table ( column in yellow)). The excel file was obtained from the attached SQL query () The two screenshots show the power bi tables. I need to get a new column in power bi that shows me the results like in the yellow column in Excel.

I am looking for a skilled developer to create a Window...skilled developer to create a Windows-based application that can interact with a remote database. The application should primarily focus on retrieving and generating website sitemaps based on different criteria. The ideal candidate should have: - Proficiency in Windows application development - Strong experience in working with databases, particularly remote databases - Knowledge in data retrieval and data update functionalities - Ability to understand and incorporate additional requirements as the project progresses Please note that the selected freelancer may need to provide examples of past work and project proposals. Note: Application should be able to connect different type of databases such as MS SQL Server, M...

I'm facing an issue with my Laravel admin panel, specifically a database table owner error that's occurring when uploading a zip file. - The error seems to be centered around the database table ownership. - The error happens during the process of uploading a zip file. - I can provide more details on the issue if required. I'm looking for a professional with experience in Laravel, database management, and debugging to help resolve this issue. The ideal candidate should be familiar with Laravel's database interactions and be able to navigate and troubleshoot these types of issues efficiently.

...building a customized sales pipeline, managing contacts and leads effectively, and generating comprehensive reports. Key Tasks: - Customized Sales Pipeline: I need the freelancer to design a sales pipeline that aligns with our unique business practices and sales processes. The pipeline should be intuitive and easy to navigate. - Contact and Lead Management: The professional should ensure seamless migration of data from Insightly to Fresh Sales. They must create an organized system for managing contacts and leads, including appropriate tagging and categorization. - Report Generation: I require the freelancer to set up automated report generation which provides insights on sales performance, lead progress, and any other relevant metrics. The reports should be easy to interpret an...

I have the SQL file and main images of my current Wordpress site, and am looking for a professional to migrate and set it up on the new hosting account. We have the hosting account set up and will share the files with a dropbox link. Key Requirements: - Migrate current Wordpress site to a new hosting account - Setup and configure Wordpress in the new hosting environment - Ensure all site functionalities are working post migration - Provide login credentials for the access to Wordpress Please note: - There are no custom changes or updates needed during the migration - The new hosting environment is fully compatible with Wordpress Ideal Skills: - Proficient in Wordpress migration and setup - Knowledgeable in SQL databases and file handling - Experience ...

I'm in need of an experienced web developer to perform a site migration for my Drupal 7 website from its current host to a new one. The scope of work includes: - Carry out a full migration of a medium-sized Drupal 7 site (100 MB - 500 MB) - Ensure all basic content such as articles and blog posts are perfectly transferred - Ensure Hosting environments are the same will not cause any loss of integrity upon moving Key Requirements: - Proficiency in website migrations, especially for Drupal 7 - Understanding of hosting environments - Ability to perform the task without the need for any content or design updates - Excellent troubleshooting skills in the event of any issues during the migration This is strictly a migration task; no updates or changes are ...

Seeking a freelancer to revamp a WordPress webshop plagued by malware. Priority on simplicity in design, ensuring fast loading and security. Need existing products migrated to the new version seamlessly. Requirements: Malware removal & security enhancement Simple, elegant design Optimize for speed Seamless product migration WordPress expertise Timeline & Budget: Please propose timeline and budget. Previous WordPress experience required. If you're ready to tackle this project efficiently and deliver a sleek, secure WordPress webshop, send your proposal with relevant experience. Let's revamp this shop together!

I'm looking for a skilled professional who can help me in migrating my current website to WordPress. The website is to remain visually identical, with the same functionality and content. This is more about the back-end than the front-end. The ideal freelancer for this job should be: - Proficient in WordPress - Experienced in website migration - Able to ensure that my website remains fully operational post-migration Note: This is not a redesign or update project. It's about moving the existing website to a WordPress platform.

As a business user, I need assistance with the configuration of SS...WebPortal using Report Server Configuration manager and I am able to run SSRS reports from the Web UI. The project requires the following: 1. Automatically Scheduling of SSRS reports with default parameters. 2. Exporting the outcome of SSRS reports in a given folder every time a scheduled report runs I am experiencing the following issue while scheduling: Error: The SQL Agent service is not running. This operation requires the SQL Agent Service. You will need to help get rid of this error and set up scheduling and exporting of reports as mentioned. You will be required to get on a video call and help me set up the above over the call since this is a secured environment. Also, this needs to be executed...

Hi Mohammad, You did for me a Realestate site (https://www.freelancer.com/projects/php/Website-for-selling-properties/reviews) some time ago. May we chat for a new project? I would need: - Exactly the same structure, but with some new content and for another domain. - Fix the old site, as after a server migration it does not work anymore.

... we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. We're excited to collaborate with a dedicate...

I'm seeking a skilled developer who ...main responsibility on the design front involves refining my site's navigation. This implies that you'll need to understand how the navigation menu is currently arranged and accurately remove specific items. - Database Optimization: I am excited to augment the performance of my website. For this, I require optimal reformation of the existing database structure. This task demands proficiency in managing Laravel databases and an understanding of optimization best practices. The ideal candidate for this project is detail-oriented and exhibits a strong understanding of Laravel, database optimization techniques, and UI/UX principles. Knowledge of the latest design trends and how to selectively prune menus for user-frie...

I need a Power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: - Retrieve Product ID, Quantity and Location. - Gather Specific Production Data including t...number. Ideal Skills: - Proficient in DAX query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results like in the yellow column in Excel.

...for the Snipepay Payment Plugin: WooCommerce Integration: Develop a payment plugin to integrate Snipepay into WooCommerce, allowing users to choose Snipepay along with existing options like PayPal and GoUrl for payments. Deliverables: A fully functional WordPress plugin for hosting management. A Snipepay payment gateway plugin for WooCommerce. Skills Required: Proficient in PHP, JavaScript, and SQL. Experience with WordPress and WooCommerce plugin development. Strong understanding of RESTful API integration. Knowledge in payment gateway integration, specifically Snipepay, PayPal, and GoUrl. Excellent problem-solving skills and attention to detail. Project Timeline: Please provide an estimated timeline for completion with your bid. Budget: Your bid should include the total cos...

Hi Yasar W., I noticed you posted a following project ( https://www.freelancer.com/projects/sql/SQL-Expert-Needed-for-Data/details )

I need an expert to design a DICOM database specifically for storing and retrieving radiology images. Key requirements are: - Comprehensive understanding of DICOM Standards - Proficiency in database design and administration - Experience in handling medical images, particularly radiology The proposed database should support retrieval of images via Unique Identifier Codes (DICOM's UID). Being well-versed in medical systems integration will be considered a great advantage. This project will require strict adherence to privacy regulations and standards.

I need an expert to migrate my products from an Excel file to my WooCommerce store. Key Requirements: - Migrate products from an Excel file to WooCommerce - Use attributes to define variations within ...Excel file to my WooCommerce store. Key Requirements: - Migrate products from an Excel file to WooCommerce - Use attributes to define variations within a single product - Update existing product descriptions during the migration Ideal Skills and Experience: - Strong experience with WooCommerce and product migration - Proficiency in handling product variations using attributes - Attention to detail for updating and modifying product descriptions - Excellent knowledge of data import/export and product management on WooCommerce. - Ability to ensure a smooth and error-free ...

I need a proficient data specialist to compile a comprehensive database of Romanian companies. - Compatibility: The database must be compatible with Windows and Mac platforms. - Specific Details: Every company's record in the database must contain the company's name, phone number, and email address. - Extent of Database: Aim for a sizable database that contains information about 100,000 companies. Ideal candidates will have experience in data mining and database management, and an understanding of Romanian market dynamics. Strong accuracy and attention to high-quality data is a must.

I'm seeking an expert for a data migration endeavor from Salesforce Classic to Lightening Starter. This project involves: - Moving over 12,000 Accounts and Opportunties - Several custom fields need to be replicated in Opportunties - Total of three users - Migrate Notes, Reports, and Attachments This process demands careful handling of data to ensure smooth transition with no data loss. The data currently exists in the Salesforce Classic version. Experience with Salesforce Classic and the newer Lightning Starter version is necessary. Perks for the job: - Salesforce certification or proven experience in Salesforce data migration - Familiarity with data sets (10,000+ records) - Ability to mitigate risks involved in data migration and ensure full data integ...

...from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...

I'm looking for a developer who's proficient in C#, MS SQL Server, Dot Net, and XAMARIN to work on an already existing application. Need to improvise and add amend few things. Pls note we can pay maximum INR 4,000 for the work.

I am seeking an experienced Dynamics CRM 365 developer with Virtual Entity expirence. I have got few virtual entity tables link to Azure SQL database. One table has got 1:M relationship with another. In my form, I am trying to populate custom view in lookup field of this virtual entity lookup. I tried it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch XML query and use addCustomView method. This method works if filter...

I'm in need of a Machine Learning Engineer who can migrate our existing notebooks from RStudio and PySpark to AWS Sagemaker. Your task will be to: - Understand two models I have running locally. One is a Rstudio logistic regression model, and the other is a pySpark XGboost also running on local. - Migrate These two models to AWS SAGEMAKER. Data will be on S3 -Prepare models to run on sagemaker totally, so that we can do training and testing 100% on sagemaker.-Models are already running on a local computer, but I need to move them to Sagemaker 100%. Data is on S3 already. -You need to configure and prepare Sagemaker from end to end, and teach me how you did it, since I need to replicate it in another system. -I will give you the data and access to AWS Ideal Skills and Experience: -...

As the developer of an existing project written in Python, SQL Server, and MongoDB, I am currently facing a challenge. A logical error in the code is causing a bug, and I need an expert to fix it. High-level summary of the code- 1. Fetch records from SQL server ( total 680000 records) 2. Apply face recognition on each record 3. Insert the response from step 2 in MongoDB along with other data from the SQL server Issue- The existing code is currently doing steps 1 & 2 and performing step 3 at last when face recognition is applied on all records. Due to this it step 3 is waiting to complete the step 1 & 2. Expectation- After fetching each record from SQL server, the code should apply face recognition and then store the data in MongoDB immediately. I wil...

...from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...

We need Oracle resource who are expert in below skills and having 8+ years of exp. Mandatory Skills: *• Need candidates with extensive experience in data migration across CRP, SIT, UAT, and GoLive phases in Oracle Fusion ERP implementation, utilizing ETL tools. * Experience in SQL Server, T-SQL, and SSIS Job Responsibilities: Data Extraction: * Extract data from various source systems, including flat files, spreadsheets, legacy databases, and external APIs. * Develop and optimize SQL queries and scripts for efficient data retrieval. Data Transformation: * Perform data cleansing, validation, and transformation to ensure data quality. * Convert data from source formats to Oracle-compatible formats. * Apply business rules and data mapping for aligning sourc...

...expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficie...

...expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficie...

...system to accommodate a referral program. I envision this program to be multi-faceted, with the capability to track referrals, assign rewards and incentives to referrers, and provide benefits to referred customers. The system should also be able to manage and monitor the referral process with ease. There are other smaller improvements required to the website and the database we use to run our suppliers prices. Our stock database was designed by me and built by our then developers. We also link into accounting to import customers orders and convert to invoices. We also link / interface to Ideal skills for this project would include: - Proficiency in Opencart system development - Strong UI/UX design capabilities, especially in mobile responsiveness - Experience in de...

I'm currently looking for a freelancer to assist in running a request from to Nest.js. Requirements: - Expertise in : The successful candidate should have extensive experience and a proven track record of working with Nest.js. Steps : 1. Run locally 2. Create a nestjs server. Run the /transcribe endpoint currently running in nextjs to run from nestjs server (setup at a different endpoint)

I'm in need of a proficient database specialist to manually collect email addresses and phone numbers, and compile them into an efficient and reliable database system. The leads to be collected are specifically from the Social Media industry. Ideal Skills and Experience: - Proven experience in data collection and management. - Exceptional research abilities, particular in the social media landscape. - Ability to use manual collection methods efficiently and effectively. - Knowledge and understanding of database management and lead generation. - Accuracy and attention to detail in dealing with phone numbers and email addresses. Roles: - Locating and collecting required data from specific direct websites. - Organizing the data into a systematic database...

Hi I will share the details with the shortlisted candidates. Thanks

I need an Azure function to facilitate daily data transfer from Snowflake s3 storage to Azure blob storage. Key Requirements: - I have access to both the Snowflake s3 storage and the Azure blob storage. - The primary goal of this data migration is to integrate the data with other Azure services. - The data should be transferred on a daily basis. Ideal Freelancer: - Proficient in Azure Functions and Azure Blob Storage. - Previous experience working with Snowflake and its utility for data migration. - Strong understanding of real-time data transfer systems is an added advantage.

I'm seeking an expert in Entity-Relationship Modelling and Rational Database Design. Key Requirements: - I need an expert in this particular area. Please only apply if you have a proven track record in both Entity-Relationship Modelling and Rational Database Design. - I'm looking for a high-level overview of the Entity-Relationship Diagram. This means I don't need every minute detail, but rather a clear and concise depiction of the core entities and relationships. - Experience is key. Please share your past work in this field. Ideal Skills: - Proficient in Entity-Relationship Modelling - Experienced in Rational Database Design - Strong track record in this particular project type - Excellent communication and understanding of client needs. Pleas...

Need help with a simple task that involves writing simple SQL statements and completion of the relevant ER diagrams. This task is in the context of simple data analysis. To be completed within 2-3 days.

I have a running Python file, who parse data from xml and insert it into sql server. Currently it isnt working. need an expert in python, who can fix it and upgrade few things as well.

I'm in urgent need of skilled professionals with experience in MySQL and Digital Ocean recovery console. My MySQL server is locked and I require assistance in exporting a SQL file. The exact cause of the server lock is not currently known but it might be due to server resource overload or a potential security breach. Required Skills: - MySQL - Knowledge of Digital Ocean's recovery console - Server management The main objective of the task is: - Successfully export the locked SQL file for further analysis and resolution - Provide insights on the potential cause of the server lock for future prevention. Experience in server management, specifically in handling locked servers, will be a great plus. Thanks.

I am seeking a skilled database developer to convert my .frm and .idb files into a SQL file. The original files are in MySQL format. Key tasks will include: - Conversion of .frm and .idb files to SQL format. - Exporting these converted files to mysql server. I did not specify any special properties or features of the .frm and .idb files that need to be preserved, but will appreciate a careful and diligent conversion to ensure no data loss. The ideal candidate for this job would have: - Extensive experience with MySQL 5.7. - Proficiency in SQL file conversion. - Strong knowledge of database export practices. - Keen attention to detail to ensure data integrity.

...calculate the hourly rate and the time needed to complete different task documents, on an agreed fixed price. The best offers with the right experience will have the opportunity to work with us on a long-term basis. Also, Good prospects for the right developers, based on the performances evaluated over a period of time, once you established your skills. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Any bugs created due to your own developments are to be fixed on free of Charge. Recruitment is for a long-term big project as such, all the developers are subject to practical skill test for which not paid. Please send your details for the below-mentioned questions....

I am looking to migrate my existing Shopify store to WordPress. The primary reason f...Shopify plan. I'm looking to retain and migrate all the data, including products, customers, and any other essentials seamlessly. The ideal freelancer for this project should be proficient in: - Shopify and Wordpress - Shopify store migration - Data migration and retention - E-commerce platforms The project will involve replicating the current design and functionality of the Shopify store to the new Wordpress site. The freelancer should ensure that the SEO performance is not compromised during the migration. Please note that while the primary reason for migration is cost savings, I am open to suggestions and guidance on how to optimize my new WordPress store for both ...

...flight departure time, drop off location - Every day 3 buses are departing to airport. Say morning 8am, 1pm and 8pm. We need to get auto emails based on this bus timings of scheduled pax list and they take manually report with date/time filter. Ideal Skills: - Strong background in web application development - Experience in booking system or related is a huge plus - Fluency in database management, preferably SQL - Proficiency in PHP or a similar back-end programming language - Strategic problem-solving skills and attention to detail The success of this project requires not just technical expertise, but also a clear understanding of travel agency operations and the importance of efficient booking management. If you have relevant experience and the right skill set, I ...

I need a skilled professional to assist with a data entry task. The project involves the following: - The task is primarily image data entry. - The images will be provided in digital photo format. - The entered data should be compiled into a database. Ideal candidates should have experience with data entry, particularly with image data. Proficiency in database management is also essential. A keen eye for detail to ensure accurate data entry is a plus.

...I have about 4-6 websites which need to transfer to Siteground within a span of 24-48 hours. Key tasks: • Migration of WordPress-based (IS NOT E-commerce) websites on SiteGround • Ensuring site performance is intact or better post-migration Post migration, I'm contemplating a long-term relationship for enhancing the design and layout of our websites. I believe in improvement and iterative changes for best user experiences. Key skills required: ** YOU NEED TO KNOW HOW TO USE WPmigrate or to use siteground imgration OFFLINE download local files from Siteground** • Excellent understanding of WordPress and SiteGround capabilities • Proven experience in e-commerce website migration • Strong skills in WordPress UI/UX design a...

...I have about 4-6 websites which need to transfer to Siteground within a span of 24-48 hours. Key tasks: • Migration of WordPress-based (IS NOT E-commerce) websites on SiteGround • Ensuring site performance is intact or better post-migration Post migration, I'm contemplating a long-term relationship for enhancing the design and layout of our websites. I believe in improvement and iterative changes for best user experiences. Key skills required: ** YOU NEED TO KNOW HOW TO USE WPmigrate or to use siteground imgration OFFLINE download local files from Siteground** • Excellent understanding of WordPress and SiteGround capabilities • Proven experience in e-commerce website migration • Strong skills in WordPress UI/UX design a...

I'm currently in need of an experienced full stack developer who is proficient in both JavaScript and PHP. Key requirements: - Strong skills in front-end development, specifically using JavaScript. - Proven experience in handling backend development with PHP. - Knowledge of SQL is also important. - While not a strict requirement, familiarity with JavaScript frameworks such as React, Angular, or Vue and PHP frameworks like Laravel or CodeIgniter would be a big plus. - Experience with SSL implementation is a must, but there are no strict preferences as to the type of SSL to be used (Wildcard or EV SSL). Being able to pick the right SSL depending on the project’s needs will be part of your responsibility. If you're the kind of developer who is adept at managing the f...

...WordPress developer to convert my existing Shopify store into a WordPress website. The main reason for this migration is to enhance the SEO capabilities of the website. Key Features: - E-commerce Functionality: The new WordPress website should include robust e-commerce features, allowing for seamless product management and a smooth shopping experience for customers. - Blogging Capability: A key part of the website is its blog, which should be integrated into the new WordPress site to allow for easy content updates. - Inventory Management: I need the new WordPress website to offer an easy-to-use inventory management system, to efficiently handle stock levels and product updates. Product Migration: I'm looking to manually re-enter products from the Shopify store to th...

...(backend) application. This is a project that requires a strong understanding of both LAMP and MEAN stacks. Key requirements for this project include: - **Refactoring:** The existing codebase is procedural-functional, with a mix of HTML, DB-Queries, PHP echoing out JScript, and inline-stylings. I want to move towards a more organized, maintainable and modular structure, following MVC principles. - **Migration to Angular/Node.JS:** You must have a demonstrated experience in working with Angular for the frontend and Node.JS for the backend. The functionality of UI views is clear, and the queries on the DB are available, so the primary focus will be on refactoring and migrating the codebase. Ideal skills for the job: - Experience with LAMP for understanding the existing code - a...