Extract database data sql 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). --------------...

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

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 ;)

I am in need of a technophile with expertise in Microsoft Access databases. Your task will involve: - Populating my database with customer data which includes names, addresses, phone numbers, organisation affiliations, and details of last interactions. - Inputting sales transactions data which include dates, product names, and prices. The ideal freelancer should demonstrate an adept understanding of database management, particularly Microsoft Access, and be able to accurately input data with keen attention to details. Efficiency, accuracy and attention to detail will be paramount for this project.

...high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that the new PySpark script can handle a larg...

...emotions expressed through various modalities, including text, images, and audio. The primary objectives of this urgent project include: 1. Multi-Modal Data Integration: Develop algorithms to effectively fuse information from text, images, and audio sources to capture the holistic context of emotional expression. 2. Text Analysis: Implement state-of-the-art NLP techniques to extract sentiment and emotion from textual data. This involves sentiment polarity detection, emotion classification, and fine-grained sentiment analysis. 3. Image Analysis: Utilize deep learning architectures such as convolutional neural networks (CNNs) to extract features from images and recognize emotional cues, facial expressions, and body language. 4. Audio Analysis: Employ signa...

...experienced individual to fill the role of Database Architect/Lead Developer specializing in Netezza and Oracle databases. The ideal candidate will be responsible for designing, implementing, and maintaining database solutions that meet the needs of our organization. This role requires strong technical expertise in both Netezza and Oracle platforms, as well as leadership capabilities to guide a team of developers. Responsibilities  Design and implement efficient database solutions for our organization, leveraging Netezza and Oracle technologies.  Lead a team of developers in the implementation and maintenance of database systems.  Collaborate with other stakeholders to gather requirements and define database architecture to meet business needs.  O...

I need an expert to collect transaction history and wallet addresses from a specific TON wallet and deliver the data in an Excel spreadsheet. This job is a one-time project; there's no need for weekly or monthly reporting. The ideal candidate should: - Be experienced in data collection from TON wallets. - Have a proficient command of Excel. Your task will be to: - Extract transaction history from the wallet. - Obtain wallet addresses linked to the wallet. - Present this data in an organized Excel spreadsheet. Your main goal is to provide me with a comprehensive view of the wallet's transaction history and addresses. The data should be well-structured and easy to interpret. The main requirement is below. Please read. The wallet address is U...

Our existing CGI script is encountering issues ...when importing the exam's section breakdown from a .dat file. Due to this, we are unable to import the breakdown of results per section of the exam into the SQL database. We are seeking a proficient developer who can: - Analyze our existing CGI script and identify the cause of the breakdown import issue. - Provide actionable advice and steps to troubleshoot and resolve the problem. - Ensure the script effectively imports the section breakdown from the .dat file as intended. The ideal candidate for this project should have: - Extensive experience in CGI scripting and SQL database management. - Proficiency in handling and troubleshooting data import/export issues. - Ability to work quickly and effici...

...users based on their reading habits and preferences. Secondary Goals: Implement data visualization features to display trends and sentiment analysis of news articles. Minimum Requirements: Content Aggregator: Develop a system that pulls news data from various APIs or web scraping. User Profile Management: Create functionality for users to register, login, and specify their interests and preferences. Recommendation Engine: Implement a machine learning model to analyze user behavior and curate news content accordingly. Optional Enhancements: Sentiment Analysis: Integrate a sentiment analysis model to evaluate the tone of news articles, helping users understand the general sentiment of the news they are reading. Data Visualization: Use libraries like Matplotlib and Sea...

I am in need of a skilled freelancer who can help me extract all products from an online shop and import them into my Shopify store. Key Responsibilities: - Extracting all products from an existing online shop - Importing/copying these products into my Shopify store I expect the freelancer to: - Ensure all product information is correctly ported over like variants, prices, ean/gtin, description, collections,... - Maintain the quality of product listings - Ensure the product images are not lost during the import I'm looking to work with someone who has: - Experience with product extraction and import - Proficiency in Shopify - Attention to detail Please provide a timeline for completion when bidding. Please check the size of the shop and the number of products you need to c...

I'm seeking a skilled data architect for providing consultation and recommendations on a Statement of Work (SOW) that involves data warehousing, ad hoc reporting, complex SQL formation, and more. The primary purpose of the project is to streamline and enhance our data storage capabilities. By integrating new data into our warehouse on a monthly basis, we aim to improve our decision-making and business performance through enhanced data access and analysis. Key responsibilities include: - Reviewing and providing recommendations on the SOW for data warehousing - Offering expertise on ad hoc reporting and complex SQL formation - Helping to streamline data storage and improve decision-making - Ensuring the architecture can su...

I require a proficient web scraper to extract varied data types including text content, images, and metadata from specific websites. The primary function will be to gather, organize and present data in a structured and usable format. - Skills and Experience Required: - Strong knowledge in web scraping tools and techniques - Familiarity with data extraction, mining, and storage - Proven track record in delivering similar projects Due to a time-sensitive nature, I will need this project to be completed within a month. The quick turnaround shouldn't compromise the quality or functionality of the web-scraper. Do bear in mind that reliability, efficiency, and accuracy of the data extraction process should be prioritized in the scope of th...

I am looking for a skilled data entry professional who can help me collect and organize stock data from my trading view strategy. The person must have experienced in strategy test option in tradingview. No pragramming language required, just manually check. Note that my strategy name is BRAMMA 1. Objective - Find every stocks in US exchange (Nasdaq and NYSE) that meet the BRAMMA strategy conditions Steps to do before everything. - Please gather all the names of US stocks market in both exchange (Nasdaq and Nyse), then please manually check every stock that meet condition and extract them to excel file. - Please select the trigger that match with the tradingview ticker -Please find list of company in Nasdaq exchange here: - Please find list in

I have to transfer data and tables from oracle to postgres.

I need a skilled developer who is proficient in working with Google Cloud's OCR functionalities. The project involves the following specifics: - File Format: The OCR system should be able to extract text from PDF files, no other formats are required. - Output Format: The extracted text should be converted into a word file and worksheets. - Language Support: The OCR should be able to recognize and extract text in English only. This task requires someone with expertise in Google Cloud's OCR, the ability to generate word files and worksheets, and a solid understanding of language processing for English. High attention to detail and accuracy is crucial for this project. Basic UI is also needed for file management like input, output, split and review.

...are in search of a skilled freelancer proficient in web scraping with Scrapy to extract product data from This project involves scraping the Category page to retrieve product details including name, price, SKU, URL, breadcrumb, currency, and brand. Targeted webpage: Category page of Required data: Product name, price, SKU, URL, breadcrumb, currency, and brand Experience: Prior experience in scraping product-related information from e-commerce sites is essential, with proficiency in Scrapy being crucial for accurate and efficient data extraction. Data Handling: Ability to ensure accuracy and consistency of extracted data. Familiarity with different data formats is advantageous. Dynamic Scraping: Navigation logic for all categories must

I'm in need of a desktop software that can analyze a specific type of data within a PDF table. The software should: - Read and extract data from a PDF table - Compare this data against another table - Identify and save matching data in the form of an Excel file. The tables in question will contain numerical data only. Ideal Skills and Experience: - Proficiency in developing software for Windows - Experience with data extraction from PDFs - Strong capabilities in data comparison and analysis - Knowledge in Excel formatting - Understanding of numerical data handling.

Looking for a Senior BDA with experience in. AZURE SQL SERVER. English mandatory. 1d per week helping to improve and maintain our main DBs.

I'm looking for someone to help me extract information from various video game guides and websites through an LLM or chatgpt. This data needs to be organized into a Questions and Answers format in a JSON file. I will need to process several game guides using the prompts provided. Currently going for $1 per game (I will provide the links and guides to the document, it is fairly a copy and paste job with minor quality checks) Key Responsibilities: - Extract data from a provided set of video game guides and websites - Organize the extracted data into a structured, Question: Answer format - Format the final output into a JSON file Ideal Skills and Experience: - Proficient in English - Experience in data entry or content extraction - Familiarity ...

I need an expert in Python web scraping to help me extract specific data from a website. - The website I need data from will be disclosed once the project is awarded. - I have a specific list of data points I need extracted. - The frequency of updates for this data is not set yet. Ideal skills: - Proficiency in web scraping with Python - Experience in extracting data from dynamic websites - Ability to follow instructions and deliver precise data outputs - Good communication skills for potential project extensions and updates

I need an expert in Python web scraping to help me extract specific data from a website. - The website I need data from will be disclosed once the project is awarded. - I have a specific list of data points I need extracted. - The frequency of updates for this data is not set yet. Ideal skills: - Proficiency in web scraping with Python - Experience in extracting data from dynamic websites - Ability to follow instructions and deliver precise data outputs - Good communication skills for potential project extensions and updates

I have a significant amount of text data from physical documents which I need entered into a database. The ideal candidate will have experience with both data entry and database management. Key Project Requirements: - Data Entry: You will be responsible for accurately transcribing text data from physical documents into a digital format. - Database Management: The entered data needs to be organized correctly in the database. Prior experience in managing databases is essential. Ideal Skills and Experience: - Proficiency in data entry - Strong attention to detail - Experience in database management - Familiarity with data organization techniques I'm looking for someone who can complete this efficiently...

I have a Word document that contains some text which needs to be copied to a specific location. The text is to be copied from a Word document, so you must be proficient in working with Word documents. Specifically you should be able to: - Open and extract text from a word document - Have a basic understanding of formatting in Word - Be able to handle document errors or formatting issues The text is going to be pasted to a specific location so you should have: - Good attention to detail - Precision in copying and pasting text - Ability to follow instructions accurately This is a simple project that requires precision and attention to detail. You must be able to follow instructions carefully.

...an existing Google App Script that's currently dealing with scraping linkedin from google search api. The purpose of the limit was initially for getting quality data, however, it's currently hindering my ability to extract more social media content - which is crucial for my project's success. I need quick tweak to the script to ensure the limit is removed. It should not only allow for a larger volume of data to be extracted but should also be optimized to prevent any potential server resource issues. Ideal skills and experience for this job include: - Proficiency in Google App Script - Prior experience with web scraping and data extraction - Ability to optimize scripts for performance Please let me know your experience with similar projects...

...developer. To qualify you must be full stack and conde in . , .NET ASP WEB API + MS SQL Details of our current project STACK can be seen here -> Prerequisites: For this optimization task you can bid your normal hourly rate but for the long term project the starting wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) Accept and start work immediatly 3) Have MINIMUM OF 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 02:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales This is for ongoing long term development and we

...am looking for a cloud engineer who can assist with deploying an ASP.NET Web Form application on a Windows Server 2022 on VPS. Key Requirements: - The SQL Server DB and ASP.NET Forms have already been set up on the VPS Windows Server 2022. The main task is to ensure the successful deployment of the ASP.NET Web Form application. Additional Details: - The cloud provider I am currently using is WABYNE. Ideal Skills and Experience: - Proficiency in cloud engineering and deployment processes. - Experience with ASP.NET Web Form applications. - Familiarity with Windows Server 2022 on VPS. - Knowledge of SSL certificate installation, database configuration, and firewall settings is a plus. Please provide your relevant experience, certifications, and portfolio when applying. ...

I am in need of a data analyst who can dissect reports and extract necessary data daily. The task involves delving into data reports and accurately churn out meaningful information in required format. Your responsibilities include: * Analyzing various reports. * Precisely capturing key information based on pre-decided format. This project requires someone with Eye for Details, Working knowledge of MSOffice especially Ms Excel. Good English communication acumen, to understand and interpret data and derive meaningful information. Understands general market & business terminologies, Able to invest atleast 4-5 hours daily. Ideal time between 2pm to 7pm IST. Proficiency in interpreting data and a keen eye for details are highly recommended for t...

...detail-oriented and expert data analyst with proficiency in SQL and R for a comprehensive evaluation of a recently completed data analysis project. This project requires a review of SQL queries, R scripts, and database connections as detailed in a provided PDF. If you're ready to start right away and can deliver within 24 to 48 hours, please get in touch. Responsibilities: Conduct a thorough review of project requirements as specified in the PDF. Evaluate the accuracy and efficiency of SQL queries and R script implementations. Verify database connections and the effectiveness of data visualizations. Identify any discrepancies or areas for improvement. Deliver a comprehensive report detailing findings, issues, and potential i...

...skilled full stack developer to help with a web application project that I'm working on. The ideal candidate should be proficient in JavaScript and .NET, with specific experience in Angular and SQL Server. Key Skills and Experience: - Proficiency in JavaScript and .NET. - Strong knowledge of Angular and SQL Server. - Previous experience in developing web applications. - Ability to work collaboratively in a team setting. Responsibilities: - Develop the front-end using Angular. - Design and maintain the back-end of the application using .NET. - Ensure seamless integration of SQL Server for database management. - Conduct thorough testing to guarantee the application's functionality. This is a great opportunity for a skilled full stack developer to c...

I need a professional to create an ER diagram for a moderately complex database I'm designing. - This is specifically for database design purposes, using Chen notation. - The database structure I have in mind falls between 10-20 entities, so the ER diagram will need to reflect this level of complexity. - You should have in-depth experience with database design and ER diagramming, particularly using Chen notation. - The ER diagram should be clear, well-structured and accurately represent the relationships and entities within the database. - Previous experience with similar projects is a plus.

I'm seeking a FileMaker Pro expert to modify the existing project database for our small architecture firm. Your main tasks include: - Rectifying existing bugs - Enhancing reporting capacity - Introducing new mapping features, if possible. Some issues have been detected in the current system with features not working properly, particularly in the reporting capacity. A new mapping feature is optional and can be discussed further. There isn't a strict time frame for project completion, but I'm hoping to get it done as soon as possible. Ideally, the applicant should have a strong background in FileMaker, bug fixing and data mapping.

I am in need of a Laravel Developer to work on my website. The changes involve backend functionality and database modifications. Ideal Skills: - Strong experience with Laravel - Expertise in backend development - Proven track record of database modifications Tasks Include: - Implementing API integration, specifically e-commerce APIs - Database modification to accommodate new functionalities I need someone with a high level of expertise in Laravel and backend development. Your ability to integrate e-commerce APIs and modify the database accordingly is crucial for the success of this project. Your focus will be on enhancing the backend functionality, ensuring it's robust and efficient. Your attention to detail and ability to work independently will be high...

...can help me create a movie database website that is connected to a Telegram bot. Key Features: - Movie Database Website: The core of the project is to build a movie database that's user-friendly and comprehensive. - Telegram Bot Integration: I need a Telegram bot that can seamlessly connect to my movie database. The bot should be able to handle user queries and provide relevant movie recommendations. Telegram Bot Functionalities: - Movie Search & Recommendation: Users should be able to search for movies based on different criteria and receive tailored recommendations. - URL Shortener: The bot should be able to generate a shortened URL for the movie being recommended. Ideal Skills and Experience: - Proficiency in web development, particularly in ...

Main Features: 1. Image Upload: Users will be able to take a photo of handwri;en text or upload an exis9ng image. 2. Technical Characteris9cs Analysis: Using op9cal character recogni9on (OCR) algorithms and handwri9ng analysis, the tool will extract text from the image and analyze technical features of handwri9ng such as size, inclina9on, spacing, pressure, etc. as well as characteris9cs that come from that analysis (extroverts person, shy, etc.) 3. Prac9cal Characteris9cs Analysis: Based on a reference book, the tool will analyze prac9cal features of handwri9ng such as speed, rhythm, le;er shape, readability, etc. 4. Personalized Feedback: Users will receive personalized feedback describing the detected characteris9cs and providing an explana9on of their meaning. Addi9onally, there...

I'm in need of a professional to optimize my PL/SQL code for better performance. The primary focus of this project is to enhance the overall efficiency of the code. Key Responsibilities: - Perform PL/SQL performance tuning to improve the execution speed of queries. - Implement bulk collect operations to enhance data retrieval efficiency. - Optimize the compilation of procedures for better code execution. I'm seeking someone with extensive experience in PL/SQL, particularly with performance tuning and bulk collect operations. Proficiency in procedure compilation optimization will be a bonus. Your expertise will play a crucial role in achieving the project's goals.

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

...WORTH 5$, 5 WORTH 3$ AND 10 WORTH 1$ AND ALSO THE OPTION OF GOALS BY POINTS. 3.2 - AT THE MOMENT THE USER PAYS FOR HIS SUBSCRIPTION, IT IS AVAILABLE TO HIM TO GAIN SUBSCRIPTION LEVELS FOR 10 LEVELS OF HIS TEAM. THE % MUST OF EACH LEVEL MUST BE SET IN THE ADMIN. 3.3 - THE SUBSCRIPTION ENVIRONMENT MUST SHOW USERS IN DETAIL EVERYTHING THAT IS OFFERED TO THEM FOR BEING A SUBSCRIBER, AS WELL AS AN EXTRACT WITH THE FINANCIAL INFORMATION OF EARNINGS, OF EACH USER AT EACH SUBSCRIPTION LEVEL, PROFIT ON INVESTMENT, ETC. .. IN THE MOST DETAILED WAY POSSIBLE SO THAT THERE IS CONTROL. 3.4 OPTION TO EARN BY GOALS: WHEN THE USER MAKES THE PAYMENT FOR HIS SUBSCRIPTION, HE ALSO RELEAS THE OPTION TO COMPLETE GOALS SET BY THE SYSTEM, THE GOALS CONSIST MAINLY OF RESPONDING TO SURVEYS, WATCHING VIDE...

I have a JSON data set that I need to work with in Oracle 12c. It contains nested objects and I need to extract specific values from these objects. select json_query('{ "validationResults": { "errorMessages": [], "status": "PASS" }, "clearanceStatus": "CLEARED", "clearedInvoice": "PD94bWwgdmVyc" }','$.validationResults') as aaa from dual; Key objectives and requirements: - Retrieve data from nested objects: The data set contains nested objects and I need a solution that can delve into these structures and retrieve the desired values. - Aggregation of values: Once the data is extracted, I need it to be aggregated in a specific way. ...

I have a civil case that necessitates filing and review for a pre-trial conference. I'm seeking a legal expert to carry out: - Moderate legal research: Adept at combing through case files, statutes and previous court decisions related to my case. - Highlighting relevant facts: Extract and underline pertinent facts within the case to ensure compelling arguments are emphasized. - Deliver concise communication: As an added advantage, a candidate with the ability to clearly explain any complex legal concepts discovered during research would be particularly desirable. Relevant legal experience in civil cases is crucial. Express in your proposal how your skills and background match up with the task.

...1, 2, and 3 emissions database through web scraping and data moderation. The selected developer will be responsible for scraping emissions data from global listed companies, implementing a moderation system, and enhancing our current offering by providing a database of published emissions data for ASX companies. Responsibilities: 1. Web Scraping - Web scrape scope 1, 2, and 3 data points from global listed companies to populate the VeriCO2 emissions database initially. - Develop scripts or tools to automate the web scraping process and ensure efficient data collection. 2. Data Moderation - Implement a moderation check to review and update data points based on user feedback and VeriCO2's own data collecti...

...emissions database as part of our automated quantification of scope 3 emissions project. The selected developer will be responsible for setting up the database, developing a user contribution system, and implementing security measures to ensure data integrity. Responsibilities: 1. Database Setup - Set up a database to store scope 1, 2, and 3 emissions data for global listed companies. 2. User Contribution System - Develop a system for users to contribute data via LinkedIn by signing up and providing their company's scope 1, 2, and/or 3 emissions. - Implement a security check to ensure the user's email domain matches the company name and send a verification email. - Allow users to download scope 1, 2, or 3 information ...