Bulk data loads 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 ;)
Are you looking to master SQL, Excel, or Python? Look no further! With years of experience in data analysis and programming, I offer comprehensive tutoring services tailored to your learning needs. **What I Offer:** 1. **SQL Mastery:** From basic queries to advanced database management, I'll guide you through understanding SQL syntax, optimizing queries, and database design. 2. **Excel Expertise:** Whether you're a beginner or looking to enhance your Excel skills, I'll cover everything from formulas and functions to data visualization and automation. 3. **Python Proficiency:** Dive into the world of Python programming with personalized lessons covering fundamental concepts, data manipulation, scripting, and more. **Why Choose Me...
...drawings, and sculptures, of rising children artists (there is one artist but the number will gradually grow as the site grows) - Feature short bios for these artists to enrich the viewer experience Ideal candidates should have: - Experience in website creation, preferably involving art galleries - A knack for content writing, especially short artist biographies (thought parents will provide the bulk of the bio information as artist join). - An understanding of what engages viewers on an online art platform You will need to provide an easy to update interface to accommodate new artists and artwork collection. Our goal is to empower and showcase the talent of young artists while also facilitating the sale of their artwork. A passion for children's creativity and imagina...
...You will be working with the Microsoft SQL server, experience is preferred but not essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - Experience in handling multiple databases with SQL - Strong troubleshooting skills I currently manage over 11 databases via Microsoft S...
As an established business relying heavily on a comprehensive tech stack, I'm in ne...need of a seasoned .NET developer for a variety of tasks. Key responsibilities include: - Review and optimization of existing front-end, back-end, and database systems - Ongoing maintenance, troubleshooting, and improvements to enhance system performance Ideal candidates for this project should have prior experience with: - Front-end development utilizing HTML/CSS - Backend technologies such as SQL Server and Entity Framework - A strong grasp of the .NET framework This role is crucial to the successful functioning of our systems, so a proactive, detail-oriented approach and excellent problem-solving skills are must-haves. Your ability to communicate issues and improvements clearly is also ...
...shipment's journey, including its current location and expected delays & the warehouse rental fees Features: Shipment Management,Shipment Status Update,Shipping Charges,Shipment Tracking Shipment Documents,Shipment Labels,Excel Import and Export,Multiple Shipment Management Users and Permissions,Internal Messaging,Shipment Barcode,Payment Gateways Global Configurations,Shipping Rate,Proof of Delivery,Bulk Scanning,Real Time Notifications Google Map Integration,Manage shipment fields,Branch Manager,Containers and Manifest Shipment Consolidation,Item Consolidation,Parcel Consolidation Whatsapp Notification,One Way SMS,Twilio Ideal skills and experience for this job would include: - Proficient in WordPress plugin development - Experience in creating advanced shipment trac...
...weight capacity of up to 200 lbs, intended for indoor use. This design will incorporate an electrical start stop button equipped with LED indicator lights, adjustable speed control, and an emergency stop feature. Key Features: - capable to be mounted over stairs to get luggage from bottom to top or reverse luggage from top to bottom of stairs - Weight Capacity: The ramp should be able to handle loads up to 200 lbs, ensuring it's sturdy and reliable for everyday use. - Indoor Use: This device will be used in a home environment, so it should be compact, easy to maneuver, and suitable for indoor use. - Electrical Start Stop Button: This feature is crucial for user control and safety: - LED Indicator Lights: These will provide clear feedback to the user, improving usability...
...records and creating effective statistical models. A bulk of the work includes: - Analyzing patient medical records to glean important insights. - Building statistical models based on the data. The primary objective of these tasks is to delve deeper into the realm of elastography in order to augment our current understanding and practices. You're the right person for this job if you possess: - An experienced background in Data Analysis and Statistical Modeling. - A broad understanding and experience working with patient medical records. - A keen interest or previous experience in elastography studies. Not only should you have the technical skills to carry out this project but a deep understanding of medical terminology to make the data discernib...
We're in search of a highly versatile .NET developer for our undisclosed project. While we haven't stated specific skills or project type, candidates should have: - Broad knowledge in .NET and its most popular programming languages (i.e., C# programming, ASP.NET development, and SQL database) - Experience in various .NET projects (i.e., web and desktop applications, as well as enhancement of existing .NET applications) - Proficiency in Windows, Linux, and Mac development platforms Your flexibility and adaptability are our key considerations as project specifics will be discussed upon engagement.
I'm seeking a Salesforce Developer expert for a critical project. We are in the process of integrating Salesforce Sales Cloud with our ERP, Finnegans. **Project Details:** - The integration is already in development but needs completion. -...someone who can get into the project, complete this phase, and help us in setting 2 new integration points. The code appears to be set correctly, but it has issues of the way of settings, as it has a DML limitation on the Salesforce side. For anyone interested in the project, they must have built integration with RESP APIs, and know how to handle JSON formats for single record input and list bulk updates or creations. The idea, will be to set a short meeting to show the documentation and status of the project prior to start working....
... Key Requirements: - Each episode is approximately 30 minutes long, so the editing won't be overly time-consuming. - I'm looking for basic editing, focusing on removing silences and "ums", repeated sentences etc - at the beginning, you should be able to work on a bi-weekly schedule to keep up with my release frequency. I’m happy to batch the episodes and begin to provide the unedited ones in bulk as we build in the future Ideal Candidate: - Experience editing podcasts or similar audio content - Proficient in tools like Adobe Audition, Audacity, or similar - able to receive them in mp3 format, and deliver them back to me in mp3 format - Strong attention to detail and commitment to timely delivery Please include any relevant experience in your propos...
I've built a web application using .NET for the backend, Angular for the user interface, and SQL database. Now, I'm looking for someone to help me publish this website on the cloud and make it live. It's a small web app designed for a local business, with a limited number of users (around 15-20). Because of this, I'm aiming to keep costs as low as possible. I'm open to suggestions on which cloud platform would be best suited for this project. If you're interested in taking on this task and helping me get my website up and running, please reach out. Thank you!
I’m looking for an expert with MySQL skills to help me write a query or script. This task involves calculating the sum of items across three tables.. The complexity lies in filtering the said items between a certain date range and by a specific field value. Ideal Skills & Experience: • Proficient in writing SQL queries • Knowledge on MySQL, specifically on data manipulation among multiple tables • Excellent understanding of database design and principles • Problem solving ability to handle complex programming scenarios. Please note, I didn't provide the names of the fields to be summed in each table. So, the chosen freelancer will need to work with me and understand the complex structure of my database in order to pull this off. Therefore ...
**Project Scope** Seeking skilled Data Analyst specializing in PUBG Mobile to elevate our team's performance using data insights. Project goals: * Performance Baseline: Deep understanding of our team's key metrics (individual players & team stats). * Competitive Benchmarking: Analyze opponents to uncover strengths, weaknesses, strategic tendencies. * Optimal Rotation Analysis: Decipher winning map rotation patterns from videos. Find areas we can improve. * Data-Driven Recommendations: Provide clear report on insights and suggest changes to team composition, drop spots, in-game decisions. **Project Deliverables** * Structured dataset in Google BigQuery with our team's gameplay stats + relevant opponent data. * SQL queries designed fo...
I'm looking for someone to install a bulk SMS sending application for me: I also need the installation of an API and the configuration of settings. Please contact me and propose a reasonable price. Thanks Je recherche une personne pour m'installer une application d'envoi de SMS en masse : Je souhaite également l'installation d'une API et l'enregistrement des paramètres. Merci de me proposer un prix raisonnable; Merci
I am looking for a PERL, HTMX, MYSQL programmer who can help me with an intermediate level project. The ideal candidate should have experience in these areas and be comfortable starting a project from scratch. I will give you a dump from my MySQL table. From which I need an interactive HTML inter...entries into one, all via one HTML::Template file with a single perl script as interface to the MySQL table. I do want an active submit button for all changes, as well as a single interactive upload button for each field of the MySQL table. also each field needs to be validated via a given specification. All code needs to be well documented and commented. Perl based database interaction needs be "SQL Injection" save. So i want a maximum of 3 files. HTML page, stylesheet and cgi...
...seeking a talented professional who can revamp the static loading screen of my DayZ server. This entails integrating a system where 6-8 handpicked DayZ-themed images rotate randomly each time a player loads the screen. - Static Loading Screen: The current screen is static, and I'm looking to maintain this format. The key difference is the dynamic image rotation. - Image Variety: The ideal candidate will be able to source, or create, 6-8 DayZ-themed images that resonate with a dark, betrayal, distrust, and despair theme. - Image Rotation: These images should change randomly each time a player loads the screen. - Death Screen: Additionally, a separate, unique image should replace the main loading screen image when a player dies. This should also adhere to the theme ...
I need an in-depth and comprehensible 2000-word report on relational databases. This should include: - A focus on normalization and handling of relational database constraints. - An E-R diagram and an SQL query. The project description doesn't specify requirements for these, so use your expert judgment to determine what is necessary. - The report should also be accompanied by a 15-slide PPT presentation summarizing the report's highlights. Ideal Skills & Experience: • In-depth knowledge of DBMS • Expert understanding of relational databases • Proficiency in E-R diagrams and SQL query • Excellent report writing skills • Experience in creating engaging PPT presentations.
I'm seeking a professional who can help me craft a comprehensive 2000 word report on Database Management Systems (DBMS). The report needs to cover the key concepts of DBMS, including E-R Diagrams, Normalization (3NF), and crucial SQL queries. The report should be well-researched, well-structured, and free of any plagiarism. I also need a PowerPoint presentation to be created, consisting of 15 slides based on the content of the report.
For the Institute of Law & Economics at the Unive...entire journal and Book to HTML format while applying consistent styling - Ensure that the HTML results in consistently formatted, easy to read and searchable continuous text - Provide the HTML so that it can be imported into a knowledge database. -A programme or script that can also be used to convert the journal and books in the future is preferred Ideal candidates should have experience in: - Bulk PDF conversion, especially for large documents like scientific articles - Applying consistent styling across lengthy documents - Knowledge of techniques to ensure content is searchable and readable in HTML format An example PDF which is to be converted to HTML is attached. Please provide examples of previous similar projects in ...
I am looking for an expert to automate my daily incremental SQL scripting to extract multiple tables from my ERP system, and export them to CSV files. Key Requirements: - The system in question is Progress/OpenEdge. - The extraction should include tables such as Customers, Orders, Products, General Ledger detail, Job Costs, Invoicing, and Budgets. - The script should be set to run on a daily basis. I need a freelancer who: - Has a strong grasp of Progress/OpenEdge. - Has experience with automated SQL scripting. - Can efficiently export data to CSV files.
I'm currently seeking a skilled database specialist who can write sql query and can give me ai free report around the entity relationship diagram and normalisation. I need a 2000-word report + 15-20 slides presentation Objective: This assignment aims to enhance your understanding of database design through the practical application of Entity-Relationship Diagrams (ERD) and normalization techniques. You will work in groups to design a database system that is both efficient and scalable, addressing a real-world problem scenario provided below. Assignment Scenario: Your team has been tasked with designing a database system for one of the scenarios listed according to your group number; if you are in group N, you must choose scenario N. For example, Group 10 must choose Scenario...
Hello Greetings from Verbolabs! We have a potential ongoing task for Image Captioning Requirements 1. Language : English 2. Skills: Strong Writing Skills 3. Volume: Bulk 4. Start Date: ASAP We will provide guidelines and instructions, so you can understand what to expect and what to do with the project. If interested then Looking forward to your Bids.
I need an experienced graphic designer to create 100 brochures that promote a variety of courses that attract and provide essential information to professionals. The designed brochures should be eye-catching and informative, able to effectively communicate course d...effectively communicate course details and persuade potential students to enroll. Key requirements: - Professional design skills: able to create engaging and informative brochures. - Understanding of target market: experience designing for professionals in a learning environment. - Attention to detail: each brochure must be error-free and contain the necessary course information. - Ability to handle bulk orders: a total of 100 brochures is required. - Timely delivery: the project has a set timeline, so prompt delivery ...
I'm in need of a proficient PowerBI analyst who can effectively connect to different data sources: Excel spreadsheets, SQL database, and CSV files. Your tasks involve creating detailed reports and conducting: - Sales performance analysis - Financial dashboards - Customer segmentation I have a preference for Bar and Pie charts in the visualization of these reports. Ideal applicants should have valuable experience in these fields and have an innate knack for making data comprehensible. Excellence in the mentioned chart formats is paramount. Having a solid background in Excel, SQL and CSV data manipulation will be a plus.
I'm looking for a proficient software developer to create a bulk direct message tool specifically for Twitter. The primary goal of this tool is to enable me to send a pre-set message to multiple Twitter accounts at once. Key Requirements: - The tool should be able to send the same message to an unlimited number of Twitter accounts without any limits. - The message to be sent will remain the same for all accounts. There's no need for customization per recipient. Ideal Skills: - Proficiency in Twitter API and automation tools. - Previous experience in developing bulk messaging software. - Knowledge of best practices for bot development on Twitter.
...Integration of AI technology to extract data and analyze shopping cart contents. (Text extraction) - Implementation of APIs to collect and compare product data in real-time. - Creation of algorithms to identify and recommend similar products. (Might not be needed) - Development of a scalable backend to support real-time data tools and user analytics. Requested Technical Skills: - Experience creating sustainable Data modells - Experience in browser-extension development with JavaScript, HTML, CSS, and modern frameworks (React, Angular, Vue.js). - Proficiency in backend programming, particularly with Node.js or Python. - Strong understanding of RESTful API design and development. - Experience working with cloud services (AWS, Azure, Google Cloud). - Skills ...
I need a Python developer who can create an automated IME barcode system. The system should handle bulk entries and generate images. Barcode experience is essential for this project. Key Requirements: - Handling of Code 128 and IMEI barcode types - Generating barcode images in PNG format - Capability to handle bulk entries, preferably through CSV file uploads The ideal candidate should have: - Proficiency in Python - Experience with barcode generation and handling of bulk data - Familiarity with handling CSV files in Python This project is suited for someone who is detail-oriented and has a strong understanding of automation and barcode systems. Please apply if you have the required skills and experience.
I am working on React JS with Javascript Development Project. I need someone to Support me for this Project atleast 4 to 5 hours Per day. Project will Exist more than 2 years. I need support through Remotely(zoom). I am looking for Good Experienced(4+ years) Person as a Frontend Developer, Who can work on the tasks ...Experienced(4+ years) Person as a Frontend Developer, Who can work on the tasks Quickly. I am looking for Long term relationship. After this Project Completed means, we will give immediately another support project. I will Give you the Sample Task for 1 Hour, If you Completed ON TIME means we will give you the Project. Required Skills : React JS, HTML, CSS, Javascript, Cypress Test Cases(Mandatory), SQL Basics Language Speaking Person : English Note: I will pay on ho...
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
... Key Functions: - Extract data from a relational database via SQL queries. - The ability to process and analyze reviews from different platforms such as blogs, social media, and online stores. - Generate a coherent 300-word summary from a multitude of reviews. Required Skills and Experience: - Expert level understanding of Python programming. - Knowledge and experience in SQL querying is a necessity. - Experience with Natural Language Processing for summarization. - Familiarity in dealing with relational databases. - Prior experience with text summarization or related projects is a definite advantage. The task is not only to code but also to gain understanding of reviews and to generate a meaningful summary. So, anyone who bidded should be proficient in data...
I am seeking a technically proficient freelancer to help streamline the process of importing products - including their names, descriptions, and prices - from Shoptet (XM...freelancer to help streamline the process of importing products - including their names, descriptions, and prices - from Shoptet (XML format) to our current Shopify site. The project will also entail exporting data (comprising of product name, SKU, price, descriptions, image URLs, category, and quantity) from the website in CSV format. Key tasks include: - Mapping shoptet fields to those on Shopify to facilitate a seamless bulk import. Ideal Freelancer Profile: * Proficiency in XML and CSV formats * Expertise with Shopify's data organization * Experience with Shoptet data handling *...
...store will require bulk product uploads and inventory tracking. Efficient management and organization of products is crucial. - **Payment Gateway Integration**: Aspects of this job include setting up secure and seamless payment options for customers, ensuring their transactions are secure. - **Theme Customization**: The store should exude professionalism and corporate appeal. The ideal candidate will be sensitive to the need for a clean, minimalist design. The ideal freelancer for this project: - Proficient in Shopify store creation and management. - Proven experience in integrating a range of payment gateways. - Skilled in theme customization with a keen sense for professional and corporate aesthetics. - Previous experience with product catalog management, including bulk...
I'm in need of an expert to set up SQL Server 2019 on a Windows-based virtual machine. The system will be used to support website and desktop applications. Key Responsibilities: - Configuration of SQL Server 2019 on a Windows virtual machine - Ensuring secure and optimal performance of the system - Testing the setup to confirm seamless connectivity with website and desktop apps Ideal Skills: - Extensive experience in managing SQL Server 2019 - Expertise in Windows OS and virtual machines - Should have strong troubleshooting skills on SQL server - Familiarity with website and desktop app integrations.
Excited to work with an experienced ASP.Net webforms developer, who will bring their skills to facilitate the Database integration aspect of our project. Key Responsibilities: - Integrate SQL Server with our existing ASP.Net project. - Create smooth and efficient functionality. - Ensure system robustness and efficiency. Skills and Experience: - Strong proficiency with ASP.Net Webforms. - Knowledge and hands-on experience working with SQL Server. - Excellent troubleshooting capabilities. It is not necessary for this project to migrate data from an existing database to SQL Server. However, the capability to do so may be beneficial in the future. If you are an experienced developer with the aforementioned skills, I would love to have you on board for this p...
I am in need of a web speed expert, specifically someone proficient in optimizing loading times. My site currently loads in less than 3 seconds, which is just not up to par with my standards. Key Requirements: - to achieve passing grade for LCP, FCP ,CLS and TTFB - Pinpoint the images causing the most significant load times and offer optimized solutions. - Suggest best practices for other on-page elements affecting website speed. The ideal candidate will have proven experience in improving website speed, specifically regarding image optimization. All detailed reports, including improvements made and those suggested for the future, need to be shared at project completion.
E-comerce hecha con React, Tailwind CSS , Framer Motion y cuenta con un chatbot con IA como asistente virtual En el Backend cuenta con una base de datos SQL y node Js y Javascript para la conexión a la BD Tiene una auténticacion de usuarios Y cuenta con integración a MercadoPago
I'm in need of an experienced SQL developer who can assist with writing stored procedures in SQL Server. The purpose of these stored procedures is for data loading. Key Responsibilities: - Writing stored procedures for data loading Ideal Skills & Experience: - Proficient in SQL and SQL Server - Prior experience with writing stored procedures - Experience with data loading processes The complexity of the stored procedures is expected to be at the basic CRUD operations level. As this is focused on data loading, it requires someone who is meticulous and well-versed in data manipulation within a SQL environment.
I'm looking to create an application using NoCode developmen...credentials are securely handled and stored. Experience with implementing this in a NoCode environment is a must. - Database Integration: The project will make use of an SQL Server. The freelancer should be able to efficiently integrate and manage an SQL Server database with the NoCode tools. Previous experience with SQL Server is required. - We need to integrate some process, after all, we need to implement the solution in Azure. In summary, I'm looking for a freelancer who is skilled with NoCode tools, specifically Bubble and FlutterFlow, has implemented email/password user authentication before, and has experience with SQL Server database management. Please contact to get more deta...
I want to... Features: * E-mail me the Lead with all information collected * Save in Google Sheets as a database * Main thing is to have it look nice and don't look out of place, similar font style, sizing, font size, etc * Use embed code to copy and past into my page builder * Create a plugin to help me customize the quiz, like images, text & size, etc. Desired Programming Language: PHP / SQL * I'm looking for the best deal possible, please be very competitive. * Milestone release upon completion of the project & is bug-free. * Need Source Code when Job is Complete, After any Bug fixes, and Updates ⭐⭐⭐⭐⭐ Please post "I've read everything" when applying to be considered, too many bots applying. Failure to do this step, you will not be contacted ⭐⭐...
I'm in need of an expe...house located on the Gold Coast in Australia. Key Requirements: - The project is currently in the construction documentation phase, so I need support for this particular phase. - The primary focus of the engineering support is on the load-bearing capacity of the structure. - The house's location necessitates that the design is able to support the region's specific conditions, including its wind loads. Ideal Skills and Experience: - Proficiency in structural engineering, particularly in residential projects. - Prior experience with construction documentation for buildings. - Expertise in load-bearing analysis, and ideally experience with wind load analysis. - Knowledge of regulations specific to the Gold Coast, Australia would be beneficial...
