Small program 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 ;)
java program ..three ............................................................................................................................................
...if candidate is good at shell script. It’s a small project but if we are satisfied we will give you more project in future . You thave to automate these task , Now i am doing this manually ---------------------------------------------------------------------------------------------------------- have to accept the subdomain as input and 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
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.
...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 criteria is small. If I pass filter for say 50 GUIDS the...
I'm seeking an interior designer with the skills and experience to create a Bohemian-style design for a /laboratory and living room. The ideal candidate will be able to deliver a design that is both aesthetically pleasing and cost-effective. Key Requirements: - Design for a small space - under 500 sq ft - Bohemian style - Earth tones color scheme Ideal Skills and Experience: - Proven experience in small space design - Creative flair for Bohemian design - Ability to work within a budget - Strong understanding of working with earth tones This project will require close collaboration and communication on design choices and adherence to a strict budget. I'm looking for a designer who can bring fresh, innovative ideas to the table while keeping the project afforda...
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...
...if candidate is good at shell script. It’s a small project but if we are satisfied we will give you more project in future . You thave to automate these task , Now i am doing this manually ---------------------------------------------------------------------------------------------------------- have to accept the subdomain as input and 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
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 source data ...
I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.
...need of a professional with 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: - Proficiency in ...
...need of a professional with 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: - Proficiency in ...
...for these stoves). We expect to see at least another 5 years from this business. We have been told by our current developers we should look at a google shopping program, however, we are concerned the margins are not in the products to compete in this market. We believe there is another way of increasing our business which is to introduce a referral program to those already connected and have a relationship to the business (ie chimney sweeps and stove installers and coal merchants) - the very people who touch the customer whom we target. I'm keen on expanding the 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 benefit...
I'm on the hunt for a skillful coder proficient in web scraping, specifically for Website A. The goal of this project is for obtaining valuable and significant data for analysis, competitive intelligence, and price comparison. While there's no explicit mention of the type of data to be scraped, I anticipate that a capable offering will cater to a variety of needs such as: - Text content - Image content - Metadata Ideal Experience and Skills: - Proven experience with web scraping - High proficiency in handling large data sets - Comfort in navigating Website A - Ability to collect comprehensive data categories Looking forward to a potential collaboration to achieve this goal!
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.
...drive downloads for our small business owner-focused app. MUST HAVE EXPERIENCE WITH APP INSTALL GOOGLE ADS CAMPAIGNS Please provide a link to an example of your results from a previous customer Google Ads App Install Campaign. Key Project Details: Objective: Increase app downloads among small business owners seeking marketing strategy support. App Description: Our app provides marketing strategy and business growth insights tailored for users with limited marketing experience. Current Situation: Existing ad campaigns are in place, but we need optimization to attract high-quality, relevant downloads and minimize irrelevant installs (e.g., looking to start a business or students). Desired Outcome: Enhance ad campaign setup to increase app installs from established ...
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'm fairly new to R, but need to apply linear regression to predict an outcome. I'd be grateful to work with someone who can guide me through this process. Ideal skills: - Expertise in R - Profound understanding of Linear Regression Experience: - Previous projects involving regression analysis - Proven results in predicting outcomes using R
I'm on the hunt for a skillful coder proficient in web scraping, specifically for Website A. The goal of this project is for obtaining valuable and significant data for analysis, competitive intelligence, and price comparison. While there's no explicit mention of the type of data to be scraped, I anticipate that a capable offering will cater to a variety of needs such as: - Text content - Image content - Metadata Ideal Experience and Skills: - Proven experience with web scraping - High proficiency in handling large data sets - Comfort in navigating Website A - Ability to collect comprehensive data categories Looking forward to a potential collaboration to achieve this goal!
I need a ...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 look forward to...
I am seeking a skilled architect or drafter to create detailed facade, plan, and section drawings for four structures. Each drawing must be completed using a template I will provide to ensure consistency with the final output style. Scope of Work: Small Residential House (12 sqm) - I require a complete set of drawings (facade, plan, and section) for a small 18 square meter residential house. Reference images with dimensions are available. L-Shaped Small Residential House (65 sqm) - This task involves creating architectural drawings for a 65 square meter residential house in an L-shape. I will provide images with handwritten dimensions for guidance. Covered Outdoor Seating Area (24 sqm) - Drawings are needed for an outdoor seating area with a roof, covering 24 squar...
I'm looking for a professional who can help me set up my video coaching program on Digistore. The program I'm offering is designed for beginners in the subject area. Key requirements for this project include: - Setting up the course on Digistore as a seller - Providing a seamless download experience as the program includes downloadable resources Ideal candidates for this project should: - Have experience in setting up courses on Digistore - Be able to cater to beginner-level audiences - Be able to integrate and manage downloadable resources on the platform.
I'm on the hunt for a skillful coder proficient in web scraping, specifically for Website A. The goal of this project is for obtaining valuable and significant data for analysis, competitive intelligence, and price comparison. While there's no explicit mention of the type of data to be scraped, I anticipate that a capable offering will cater to a variety of needs such as: - Text content - Image content - Metadata Ideal Experience and Skills: - Proven experience with web scraping - High proficiency in handling large data sets - Comfort in navigating Website A - Ability to collect comprehensive data categories Looking forward to a potential collaboration to achieve this goal!
I run a software company catering mainly to small businesses. Our services include software development, mobile app development, web design and development, and cyber security. I need a professional and corporate website that reflects the serious nature of our business. Key Requirements: - The website should prominently feature our main services. - It should have a professional and corporate design style. - The site must be optimized for desktop, tablet, and mobile devices. - A well-organized navigation system that makes it easy for potential clients to find the information they need. Ideal Skills: - Proficiency in web design and development - Experience creating corporate websites - Knowledge of SEO best practices - Understanding of small business needs Please provide ...
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...
I'm seeking a capable programmer with expertise in using C and Atmel Studio and a good understanding of Atmel microprocessors. The project involves developing a Simple Program capable of: - Reading analog sensor values - Reading digital input signals - Controlling digital output signals Using a combination of analog and digital inputs and outputs is key to the project, so demonstrated experience in this area is required. Prior knowledge of Arduino would also be beneficial. The right freelancer should be proficient in microprocessors, specifically with Atmel typed ones, and comfortable using both digital and analog inputs and outputs. Familiarity with wireless communication protocols is an added bonus.
We manufacture shade sails which may be 3, 4, 5 or 6 sided shapes, mounted on poles of varying height. These are difficult to measure accurately so we need a measurement verification program where we can input the perimeter measurements of the shape, the pole heights and the diagonals. The program needs to mathematically check the entered measurements and indicate the % of error and which measurement(S) are most likely incorrect. There are two parts to the project: 1. A JavaScript or similar program created to run in an ecommerce website which has a product configurator interface which will be used to input the measurements. The interface will be built by another supplier. 2. A stand-alone app able to run on Android, iOS and Windows PC. ADDITIONAL INFO Th...
...time a change is detected. Freelancers with experience in creating similar systems or possessing a deep understanding of the workings of Windows OS will be preferred. Additional Details: Monitor Regedit for the changes related to the policies applied through Service. Send notification to server, send mail to a group, in case of change not applied through Service. 7. Logs needs to be updated to SQL via a API POST call (this endpoint is developed you need to call this Only) and keep a backup at local database. POST JSON - { "Username": "", "MachineName": "ABC", "Timestamp": "", "appliedPolicies": [ { "Policy1": "0", "Policy2": "2" } ], "removedPolicies": [ { ...
I'm on the lookout for a proficient web designer with expertise in HTML, CSS, SASS, JavaScript, AJAX, and jQuery to bring to life an informational website oriented towards professionals. Key Responsibilities: - Creating a website that effectively provides details about our specific products and services. - Crafting a user-friendly layout that resonates well with professionals. Preferred Skills and Experience: - Profound knowledge and practical application of HTML, CSS, SASS, JavaScript, AJAX, and jQuery techniques. - Demonstrated experience in designing informational websites. - Capacity to understand and target professional audience's needs and preferences. - Strong eye for detail and commitment to webpage optimization. I look forward to hearing from you, preferably throug...
Need help digitising my paperwork. This entails entering text and numbers from hardcopy documents up to 100 entries in total. The ideal freelancer should be: - Detail oriented to ensure accuracy in entries. - Proficient in fast and accurate typing. - Experienced with data entry tasks. - Familiar with document scanning and digitisation. Please take note, this project requires on time delivery and accuracy.
I'm looking for an experienced Electrical Engineer to design a custom electrical system for my small commercial space, which is less than 500 sq ft. Key Requirements: - Design should include lighting fixtures, outlets & switches and HVAC controls. - Pay special attention to unique needs of our restrooms and retail area. - Previous experience in electrical design for commercial spaces will be advantageous. Scope includes CAD drawings showing the correct locations for lights, switches, exits, retail window, small bathroom. This needs knowledge of US electrical code. Can you help? Please do not apply and then change your bid once I accept... I will cancel the job. I have included a sketch of basic plan outline to review before accepting the job. Ideal candidat...
I'm looking for a skilled develo...company. The platform should be comparable to Vista Print, with a focus on catering to the needs of small businesses. Key Points: - The platform is primarily for small businesses. It should be designed to cater to their specific needs, such as offering competitive pricing, ease of use, and effective customization options. - My ideal freelancer should have a strong background in e-commerce development, with a proven track record of creating similar platforms. - Experience is key. Please highlight your previous work in e-commerce, particularly projects that cater to small businesses. The main goal of this project is to provide a user-friendly, efficient, and cost-effective e-commerce platform for small businesses to explor...
I have a proprietary program that was originally written in C# for Windows and I need a skilled coder to decompile it, incorporate some new features, and recompile it. The new features to be integrated are: - Paint Tool - Erase Tool - Selection Tool - Zoom in and out feature - Ability to resize the software windows The ideal freelancer for this job should have a strong understanding of C# and Windows programming. Proficiency in reverse-engineering and decompiling software is a huge plus. Strong communication skills are essential to ensure that the added features are seamlessly integrated into the software without compromising its functionality.
I'm seeking a reliable data science professional skilled in Exploratory Data Analysis (EDA) with the ability to rank rows based on the EDA. Must be completed in less than 24 hours
...for jobs, and managing profiles and portfolios. - Build an admin portal with role-based access for monitoring user activity, managing complaints, and generating reports on job listings and user satisfaction. Preferred Tech Stack: - Front End: TypeScript framework with Server Side Rendering (React.js or Vue.js for web, React Native or Flutter for mobile) - Back End: Utilize GCP services (Cloud SQL, Cloud Functions, etc.) - Payment Gateway: Midtrans Indonesia. This work is going to be divided into 6 major stages, corresponding to 6 milestones: 1. Planning 2. Designing (Software design) 3. Developing 4. Testing 5. Implementation & Integration 6. Maintenance Details upon each stage will be discussed through online meeting If you're passionate about creating innovati...
I am looking to develop a specialized program for the PN5180 reader with a focus on reading ID card data. This is a personal project aiming at making ID card management more efficient. The program just need joint with our team and help to code for read data from reade with scan time below 3 second. Reading the mifare ISO 14443 card, using mrz information and APDU command for selecting, reading data Ideal skills and experiences include: - Proficiency in programming the Esp32 platform - Experience with PN5180 reader - A good understanding of ID card reading procedures and requirements. Please ensure to provide relevant examples of your past projects.