Sql query access 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). --------------...
Access-tietokanta, joka sisältää tiedon syöttämistä, raportteja ja mahdollisuutta muokata tietoja.
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 ;)
My Server that I access via remote desktop services has stopped allowing remote desktop access. it was working fine for months, now it is not. the error message is: "NO remote desktop license server is available. REmote desktop services will stop working because this computer is past its grace period and has not contacted at least a valid windows server 2019 License." I had this issue before about 4 months after I initially set up the server, I went through multiple steps to register and it began working again for the past 5 months or so, and now it has stopped again. I need someone to help configure/reconfigure the server properly to allow remote desktop to function properly. I have physical access to the server and can work at that server terminal to...
...learning model. The primary goal of this application will be to evaluate student applications in real-time. Key Features: - Real-time evaluation feedback: The application should provide instant feedback on student applications, based on the integrated machine learning model. - User authentication: The application should include a secure user authentication system to ensure only authorized users can access and use it. - Data visualization: The application should have data visualization capabilities to help users understand the evaluation process and results better. Integration: - The application will need to integrate with existing systems or databases. The specifics of this integration can be discussed in further detail with the chosen developer. Skills and Experience: - Prof...
I need a machine learning model developed in Python. This model should be able to evaluate prospective student applications by...should be able to evaluate prospective student applications by comparing them to historical data sets. The goal is to classify and sort the new applicants efficiently. Key Requirements: - Develop a classification-based machine learning model in Python - Understand and work with historical data sets to evaluate new student applications - Deploy the model in a web application format for ease of access Ideal Skills and Experience: - Strong background in machine learning and Python - Previous experience in developing classification models - Ability to understand and work with large data sets - Prior experience with deploying machine learning models in web ap...
I need a tech-savvy professional with vast experience in social media account recovery. I lost control of my old Instagram account but I have the username. My main goal is to regain access and permanently delete the account. Key Responsibilities: - Recover lost Instagram account using the provided username - Delete the account upon recovery Essential Skills: - Knowledge and expertise in Instagram account recovery - Experience in similar projects - Understanding of privacy and data security protocols I can provide a driver's license as proof of identity. Confidentiality and transparency during this process are paramount, and I look forward to a successful collaboration.
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
I'm looking for a skilled Wikipedia editor to update a public figure's Wikipedia page with verifiable, online sources I will provide. Key Requirements: - Skilled Wikipedia Editor: You should have a proven track record of editing Wikipedia pages, ideally public figure pages. - Access to Online Sources: You will need to be able to access and incorporate the online sources I provide.
I need a bash script that can import and export data from my database to CSV files. Ideal candidate should be able to: - Create a bash script that can effectively import and export data - Have experience working with database management systems such as MySQL, PostgreSQL, or MongoDB - Ensure that the script securely creates user accounts and manages their access to the database. The script will be used for daily database management tasks, so it needs to be reliable, secure, and efficient.
...system supports IP whitelisting for added security. - Configure the dialer to handle multiple campaigns simultaneously. - Integrate a basic CRM to manage and search client information efficiently. - Ensure the system can support a minimum of 10 representatives. - Provide the capability to handle "N" number of lines per representative. - Design a user-friendly interface for agents to manage calls and access customer information. - Provide real-time analytics and reporting tools to monitor performance metrics and track agent productivity. - Ensure the system is scalable to handle varying call volumes. - Provide ongoing technical support and maintenance for the dialer system. **Requirements:** - Proven experience in developing and implementing outgoing predictive dialer s...
As part of my endeavor...will be to prevent unauthorized access. Here's what I require: * In-depth evaluation and analysis of our data security framework * Identification of any potential vulnerabilities and security loopholes * Devise strategies to fortify the data security dimensions against malicious hackers The ideal candidate should possess: * Extensive experience in ethical hacking and data security * Strong analytical skills and a keen eye for spotting weaknesses and vulnerabilities in data security * Ability to devise actionable strategies to address the identified issues Rest assured, full access to the necessary systems will be granted for the successful execution of the job. Please note that a thorough professional background check will be performed be...
I have a SQL Server that needs to be accessible over the internet. However, I'm facing connectivity issues, possibly due to closed or blocked ports on my ComCast router model CBR2-T. I need a freelancer to open the necessary ports on the router. The task involves: - Checking the current port status on the router - Identifying the SQL Server port - Opening the port on the router Please bid if you're experienced with network configuration and have dealt with ComCast routers before. Necessary Skills: - Network Configuration - Router Administration - ComCast Router Experience - SQL Server Configuration
I require someone experienced in Linux server management to help optimize the performance of my server. Linux Server Performance Optimization Plesk Obsidian, SQL, PHP Key Responsibilities: - Review the current server setup and performance - Identify areas for improvement - Implement solutions to optimize server performance - Fix the 2 errors. This is not a one-time setup; I may require ongoing management based on the initial optimization results. Your expertise in Linux server management is crucial to this project.
I'm in need of a professional web developer to create a platform that serves as an agent management website. The website should have an elegant interface, account logins, and a simple credit system that can be administered by an admin account. Key Features: - Agent Registration and Login: The website should allow agents to create accounts and log in securely. - Profile Manag...agent registration and login feature is not fully defined yet. The ideal candidate for this project should have experience in building similar systems, understand user account management, and have the ability to design an aesthetically pleasing interface. Requirements can be asked if you are interested, you can build with any framework, preferably javascript based frameworks. Minimal SQL is required, a...
I'm looking for an experienced full stack developer to help me with a project. This role requires a professional who is well-versed in both front-end and back-end coding. i need someone with great experience to deploy my webesite, i will give access to my sourcecode
I'm having an issue updating my WordPress site plugins due to a checksum error. Along with this, I can't download newer versions of WordPress. I also need to make sure that my website is compatible with Consent Mode V2. Your responsibilities include: - Diagnosing and resolving the checksum error that prevents me from updating plugins and downloading ...other issues that could be causing the problem. Skills and experience needed: - Proficiency in WordPress, its functioning, and its common issues. - Experience with plugin management and troubleshooting. - Familiarity with web compliance, especially with Consent Mode V2. - Ability to work around potential issues caused by uncertain changes to the site. I'll provide you with WordPress admin access so you can troubl...
As I am looking for an experienced Android app developer, I have a vision for an educational app that helps learners to access educational content with ease. Detailed walk through will be provided on call as I have the front end concept simulation ready. However here are some... Key Project Features: - User login & Registration: We require a secure user login and registration setup that protects the user's data and ensures only registered users have access to our app. - Requires Map integration and working with object on a map (google maps/mapbox, etc). - Implementation of Modal screens. Ideally, the freelancer should have a robust experience in the development of Android apps. The freelancer should be well-versed in creating apps that offer user-friendly inte...
...information is to be taken from Local Planning Authority official websites (publicly available information and no logins required). An in-depth knowledge of planning submissions and permissions and BNG is NOT needed. What is however required is accurate information to be taken from those websites and converted into a database for us. - This work can be done remotely and only requires a computer and access to the internet. - The geographical focus of the UK planning authorities we require information from will be provided to you in a prioritised list This is a meticulous role that requires sound organizational skills, attention to detail and an ability to efficiently analyse and interpret information. Candidates with extensive experience in market research, particularly wit...
...live sound engineer to ensure the best audio experience for our audience. - Event Type: Your main focus will be to manage the live sound at a rock concert, ensuring a vibrant, smooth, and balanced output. - Music Genre: Having experience with rock music is critical as you'll be balancing and mixing sounds for such a performance. - Sound Equipment: We've got the basics covered; you will have access to microphones, speakers and mixers at the venue. Your expertise on how to utilize these equipment to create the quintessential rock concert atmosphere will be key. Ideal candidate should have: - experience as live sound engineer, ideally with rock concerts. - comfortable level of skill in sound mixing and balancing. - Familiarity with the use and management of sound syste...
...This app should cater to the needs of individuals and should be fully responsive as I want it to be accessible across various devices, particularly mobile. Key Features: - User Registration and Login: A seamless and secure process for users to create accounts and log in. - File Upload and Storage: A functionality that allows users to upload and store files. This should include a system for easy access and organization. - Payment Processing: A secure payment system that enables users to make transactions within the app. Ideal Skills & Experience: - Proficiency in web development, particularly in creating user-friendly interfaces. - Experience with security protocols for managing user data and payment processing. - Strong knowledge of cloud storage and data management system...
...process with your valid translation certificate or degree **Tasks**: * Create a account with the client's provided information * Configure the account for shared access * Provide login credentials for the client to access the account * Assist the client in understanding the features of the platform **Selection Criteria**: * Qualifications and experience in translation * Quality of CV and references provided * Ability to pass 's verification process with a valid translation certificate or degree * Competitive pricing for services offered **Additional Terms**: * The freelancer will have access to the account and will be able to use it for their own translation projects. * The freelancer will receive 45% of the earnings generated by me on the platfor...
1) Configure the OpenVPN CloudConnexa Client on TP-Link (OpenWRT) so that other CloudConnexa Clients can access the devices behind the router. For example (see attached image), CloudConnexa Client should be able to access and 92.168.17.20. 2) Document required changes in a README file.
This project involves cleaning up an MP3 audio file. Key requirements are: - Experience with audio editing and noise reduction - Expertise in removing embedded sounds, particularly the echo and piano sounds which are equally distributed throughout this file - Delicate handling is needed as the given audio...editing and noise reduction - Expertise in removing embedded sounds, particularly the echo and piano sounds which are equally distributed throughout this file - Delicate handling is needed as the given audio file has low quality (distorted or noisy) - Ability to complete tasks within deadlines - Experience with handling audio files of less quality like this one will be favorable - Should have access to high-quality audio processing and editing software to deliver optima...
I'm currently facing an issue with my MySQL replica. Although there are no errors, the data isn't being synced and the "Seconds_Behind_Master" is consistently increasing. I'm looking for a professional who can help me with this problem. I can't give you access to the server(s) but we can troubleshoot together. Key Requirements: - Expertise in MySQL command line - In-depth understanding of MySQL replication mechanisms - Experience in troubleshooting replication lag - Ability to work quickly and efficiently Max 50 euros. Thank you.
Project Title: Basic Audio Note Organizer App (Working Title) Projec...upload audio files (3 seconds max) - MP3 format preferred Option to add simple labels (e.g., "Meeting Notes," "Quote") to each audio file Ability to sort and filter audio files by upload date or label Basic interface for browsing and listening to uploaded audio files Secure storage of user data (audio files and labels) Target Audience: This app caters to users who want a simple way to organize and access short audio snippets for personal use. Think of it as a basic audio version of a text-based note-taking app. Please Note: This is a very basic project focused solely on functionality. No need for fancy features like audio editing, playback speed control, or file sharing. Design aesthetics ...
I have access to the aircraft and can get many photos. I also have access to schematics to support the design. The end product will need to be in a format readable by 3DS Max 2023 and will then be imported into a game engine. Both high detail exterior and interior models will need to be made with milestones on 3D Geometry and artwork.
I'm looking for a freelancer to be the model for ultrasound demonstrations at a medical conference. These demonstrations will not focus on diagnosing a medical condition, but rather showcasing a particular company's medical device and technology. Ultrasound is a safe and non-invasive way to look into the body, it is used on children and pregnant people and had no xrays o...isn't about detecting specific medical condition. It's solely for the purpose of demonstrating the usage of an ultrasound medical device. - The successful candidate should have abilities to get onto a scanning table, to lie on your back and on your sides. - Professionalism in presentation and ability to be discrete about the company's activities at the conference. _ Lunch and breaks will have ...
In my project, I'm looking to set up ActiveMQ JMS messaging for our system, focusing on synchronous and asynchronous messaging. We anticipate a low scale of message traffic, not exceeding 1,000 messages per day. Key responsibilities will include: - Set...framework to publish and subscribe messages to ActiveMQ queues Create queries to make sure data is published into the respective tables and assertions to validate Ideal skills and experiences for this role would include: - Proficient in ActiveMQ and JMS messaging - Previous experience in setting up asynchronous messaging systems - Familiar with SOAPUI and its capabilities for message testing - SQL developer for database queries and validations Please bid on this project if you're confident in your ability to deliver on...
Looking for help in modifying an existing python script and related sql database table The current script - (1) scrapes company financial data from website and populates database (2) scrapes news related to keywords from google news (3)sentiment classification of news items (4)pushes data to sql database The company names and keywords are currently hardcoded in the script Requirement- (1) Company names/urls/keywords (will be provided) to be put in master table in the database (2) The script to loop through and scrape the relevant data and put in database
I'm looking for an Android developer to create a simple news app for me. The key feature that I'd like to prioritize is an offline reading capability, which is essential for my users who may not have constant internet access. The news articles should be displayed in a list of headlines. This layout will allow users to quickly scan through the news and pick out articles of interest. The ideal candidate for this project would be a developer with experience in Android app development, particularly in working with APIs. Experience in designing user-friendly and intuitive interfaces would also be a plus.
I'm looking for a freelancer who's great at web scraping to help with a project involving a specific website initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide source code, documentation and deployment info...
As an employer with a significant team size (more than 50), I need a custom built employee process tracking software. The software needs to be desktop application-based for easy access and user interface. Key features that the software should have are: - Time tracking: To help monitor how much time each employee is spending on their tasks. - Task Management: The ability to assign, manage, and monitor tasks is crucial. I want to keep track of who is doing what and when. - Performance analytics: The software should have robust analytics capabilities to measure performance and productivity for everyone on the team. The freelancer should ideally have experience in building similar applications and a strong understanding in incorporating the required analytics within the software. ...
...maintainable, and efficient front-end code using modern web technologies such as HTML, CSS, and JavaScript. - Integrate the front-end with the back-end API endpoints to enable seamless communication and data exchange. - Optimize the web interface for performance, ensuring fast loading times and smooth user interactions. - Implement user authentication and authorization mechanisms to ensure secure access to the application. - Conduct thorough testing and debugging to identify and fix any front-end issues or bugs. - Stay up-to-date with the latest front-end development trends, techniques, and best practices, and incorporate them into the project when appropriate. - Collaborate with UX/UI designers to create visually appealing and user-friendly interfaces. - Participate in code revi...
I am seeking native Portuguese speakers with a partner to aid in a dual channel natural conversational audio recording project designed for speech recognition trai...Each topic must be 15 minutes of natural conversation - Record these conversations in two methods, which applications and also Skype. It needs two phones during the recording and need to be together on the same room with the parnert. Ideal candidates are native Portugal Portuguese speaker if aren't native but have the accent can also participate , with good conversation skills, and have access to recording equipment. A partner with the same skills is also needed. We need 2 persons , so the candidate must have a dialogue partner (anyone around them is ok). We will use this recording for speech recognition...
I need a skilled social media marketing expert to run a unique and engaging campaign primarily aimed at driving footfalls to my stores. While I hold no strict deadlines, the project completion should align with a steady and robust increase in store visits. Ideal expertise would include: ...brief but comprehensive strategy on how you plan to execute this. Roles may potentially extend provided significant revenue boosts are seen during project duration. Please note that we do not have a website. We have three retail stores in North Chennai dealing with home appliances, mobiles and furniture. Kindly also note that we would like individuals or companies based in Chennai only for ease of access and site visits if needed. All this will be discussed as part of the compensation and budge...
...involves creating daily orders from templates, designing new product images, and assisting with branding efforts. Responsibilities: Utilize Adobe Illustrator to create and modify designs based on provided templates. Generate new product images for our online listings on platforms like Amazon and eBay. Assist in branding projects to enhance our company's visual identity. Work with provided files and access resources to fulfill daily orders. Input information from spreadsheets into AI templates, adjust text, and save the files as needed. Requirements: Proficient in Adobe Illustrator with a strong understanding of the software. Experience in creating product images and listings for Amazon and eBay marketplaces. Excellent attention to detail and ability to follow instructions...
... (ns-2 not yet added in the .net zone). Server locations are AWS Oregon, Germany, and Germany, respectively, all on different AS. DNS services run on TCP and UDP ports of IPv4 and IPv6. The name servers are their own authoritative servers, so there are glue records in the .net zone, see attachment. I can send you the bind configuration files. Unfortunately, I cannot give you SSH access to the servers. If you need to add records to the servers for debugging purposes, I'm happy to do that. Can you help me?...
I'm currently facing an issue where my neighbour has erected fences, shed, and posts outside their curtilage which impede access to my property. Despite my previous attempts to address this issue with Cheshire West and Chester's planning department, they acknowledged the breach, but opted for nonintervention. I am seeking professional legal assistance from a freelancer with a strong background in property law and proven track record in handling similar cases. Key Responsibilities: - Understand the case circumstances - Develop and execute an effective legal strategy - Communicate with the neighbour and relevant authorities Ideal Qualification: - Law degree with specialisation in property law - Demonstrated experience in dispute resolution - Excellent interpersonal ...
Required a dot net developer. Speacialized in Microservices acrhitecture based solution. Dotnet Core, C#, SQL, Data transformation, API gateway, Auth based security.
I'm seeking a professional to help me with a personal E-commerce data analysis project. I have access to a range of data sources including E-commerce platform data, sales data, and payment data. The primary goal is to create a comprehensive report that delves into the sales and payment analysis of my E-commerce business. Key objectives for this project: - Identify sales trends: I'm looking to understand the various sales trends that have emerged from the data over the period of time it covers. - Analyze payment methods: I want to categorically understand how my customers are paying for their purchases, and if the payment methods are changing over time. - Discover customer preferences: The project also aims to uncover key customer preferences and behaviors. Your role will...
I'm looking for a skilled individual to assist me in adding unlimited plays to a magnetic swipe arcade game card. Key Requirements: - The card used is a magnetic swipe card, so prior experience with this type of card technology is essential. - I don't have access to the card's management system, so the solution needs to be standalone. - The primary purpose for this task is for research and testing purposes. The task itself is relatively straightforward - I need you to bypass any limitations set on the card to allow for unlimited plays. This project is time-sensitive, so I'm looking for someone who can deliver efficiently and communicate effectively throughout the process.
