Sql server read csv file työt
web-lomakkeelta tulevaa .csv-imuotoista tietoa pitäisi lukea FreeCADiin, sen pohjalta avata ja päivittää oikea malli ja piirustus ja lähettää niistä exportit takaisin asiakkaalle. Csv-puoli on kunnossa ja paikka minne exportit menee. FreeCADin komentaminen siis puuttuu
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
Toimitamme tuotetietokannat excel-tiedostoina, tuotteiden valokuvat ja tuotteiden avainsanat yms. ja ne syötetään csv-tiedoston avulla hakukoneystävällisesti (esim. Woothemes Product CSV Import Suite + Yoast Woocommerce) wordpress-sivustolle, jolle on jo asennettu woocommerce ja jossa on jo tuotteita. Tuotteita tulisi lisää noin 200-400. Woocommercea käytetään Catalogue-modessa, eli sivusto ei ole varsinaisesti automatisoitu verkkokauppa.
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 want to configure out attendance system with ZKteco Bio ADMS communicate with server 1) Send realtime attendance data from device to remove cloud server through PHP 2) Add user from server to device 3) delete user from server to device 4) finger store in DB and send to device when needed 5) Clear admin from device through api when needed Apply if you already work on such thing.
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
I require a professional to convert a PDF file to a Word document. The purpose of this conversion is to make the content editable. It is crucial that the Word document retains an exact match of the formatting in the original PDF. Ideal skills and experience for this job include: - Experience in converting PDF files to Word documents, ensuring high accuracy in formatting - Proficiency in Microsoft Word or similar word processing software - Attention to detail and commitment to delivering high-quality work - Understanding of document structure and formatting Please note that although the client skipped a question about additional elements, it would be beneficial to have a general understanding of how to incorporate images, tables, and hyperlinks in Word documents.
I need a freelancer to convert a series of simple, text-based PDF documents into Word. Your job is to ensure that the text in the Word documents is fully editable, and that the original formatting is preserved. Key Responsibilities: - Convert multiple text-based PDF documents into fully editable Word documents. - Ensure the text is accurately extracted and maintained, without any errors or omissions. - Preserve the original formatting of the documents in the Word version. Ideal Candidate: - Proven experience in PDF to Word conversion, especially with multiple documents. - Proficient in software for text extraction and formatting preservation. - Attention to detail and ability to meet deadlines. Please note that the documents are text-only, so no experience with image or table conversi...
Paris, thanks for discussing the project with me. This is for what was entered at this project: -Create a worksheet to analyze purchase orders (pending balance to receive from open orders, total cost of the purchase after considering extra expenses, follow up on payment, etc) I did it as a fix price considering something close to the hours you mentioned you would need. If you think that would need to be adjusted we can review. Project requires NDA and IP Agreement.
I'm in need of a logo for my education charity that embodies the professional and modern aspect, while also carrying a playful and approachable vibe. I have attached our current logo here. It is a bit bland and you cannot tell what our company does based on this logo. We can keep the purple ribbon in the logo, as this is our recognized symbol. I want the tag line to read, "Transforming Lives Through Education" Essential Elements: - Books - Globe - Purple Infinity Ribbon Color Scheme: - Green - Purple - White The logo should be a pictorial representation of our mission - global education and the infinite possibilities it offers. The design should be: - Modern: in terms of style, shape, and design - Playful: to appeal to the younger audience, making it approa...
Currently using .Net Framework 4.5 and looking to upgrade project. The main goal for this upgrade is to ensure compatibility with modern systems. I don't require any specific performance improvements, just upgrading the framework is the main focus. The code base is for a Web API that integrates with SQL Server. There is a separate UI front end that is not included. The current version is .Net Framework 4.5 with the following target techical Stack • ASP.NET Core 8.0 (with .NET 8.0) • ASP.NET WebApi Core • ASP.NET Identity Core • Entity Framework Core • FluentValidation • Swagger UI • GIT Key requirements: - Expertise in C# - Strong understanding of .Net architecture - Previous experience in upgrading .Net projects to ensure compatibili...
I'm in need of a proficient professional who can set up, configure, and manage a Windows-based virtualization server. The primary goal for this server is to host more than 10 virtual servers dedicated to running web applications. Key Responsibilities: - Configure and deploy a Windows-based virtualization server - Set up and manage over 10 virtual servers - Ensure all virtual servers are optimized for hosting web applications - Implement best practices for security and performance Ideal Candidate: - Proficiency in Windows Server OS - Experience with virtualization technologies (Hyper-V, VMware, etc.) - Background in managing and configuring virtual servers - Strong understanding of web hosting practices - Familiarity with security measures for virtual envi...
...English Accent • Quality Microphone Ready to take your sales career to the next level? We are! How to Apply? (Do the Following to be considered, copy and paste the template below and use as your cover letter) 1. Record Your Voice: Read the following sales script with your voice: 2. Speed Test Goto: Change server to any Los Angeles, CA Server. Screenshot or link me to your test result. 3. Are you able to work in USA Time? (-8 PST) working 8am-4pm or 8am-5pm? 4. What is your Sales Experience and Website Design knowledge? 5. Are you able to make 100-200 calls per day? 6. Do you have a quality mic and quiet working
I need a skilled React and React Native developer to prioritize on web application development. Web App (React & Ant Design): Login/Register Page: User authentication and registration. Landing Page: Welcome page post-login. Create Record Page: Form to create a new record. Read Details of the Record Page: Display details of a specific record. Mobile App (React Native): Login/Register Page: User authentication and registration. Landing Page: Welcome page post-login. Read Details Page: Display details of a specific record (No create record page required). Additional Details: Figma designs will be provided. Clean and maintainable code is a must. Adherence to best practices in both React and React Native development. Requirements: Proficiency in React, Ant Design, and Re...
I'm seeking an exam invigilator with at least a Bachelor's degree to administer an on-site exam in S...test takers for their approved accommodations. We provide complete training and assignments pay hourly for the entire scheduled time, even if the exam ends early. We have a computer exam coming up where a test taker has been approved for communication assistance. The candidate is deaf or hard of hearing but is able to read lips. For this assignment, you would be required to be on site and repeat communication from staff and content from the exam in a way that the candidate may read your lips. The exam is taking place at a professional testing center in Salmiya, Kuwait. Date: Thursday, 30 May, 2024 Time: 9:30 AM to 1:00 PM We provide full training, and this ass...
I require a skillful freelancer who is experienced with Blender and 3D model modification. I aim to alter an existing STL file to prepare it for an upcoming LED installation project. The primary tasks will include: - Adjust my 3D model to create holes or channels that will accommodate the wiring of the LED system. My McDonald's Sign is a big seller on Etsy. I want to put LED lights in it. I am skilled at creating things to 3d print however for this task, I need someone who can do it in their sleep. This task should not take a professional/well-skilled person more than 30 minutes. The ideal candidate would have previous experience in modifying 3D models, particularly STL files, with Blender and an understanding of LED installations and their requirements in 3D printed stru...
...of experience do u have? 2. Are you an independent freelancer? 3 do you know how to fix sql injections? - Give 2 example of how to fix sql injections in forms 4. what are the ways you can secure a payment api to protect it from spamming charges- considering that the api information is secured and spamming is not happening by any registered users but through external users 5. what are the ways you can protect smtp apis to protect from email spamming?- considering that the api information is secured and spamming is not happening by any registered users but through external users 6. What are the ways you can show thousands of data on a page? how will you implement it so that it doesn't have load on server and page doesn't hang? 7. Have you worked on any m...
I need an AI agent script that is browser based without a local computer install that will do two things. 1. Research current job postings on various job platforms base...emails as well and 2. Gather email for those related postings that did not have the emails in the posting by researching the agents. So these are either two agents or two tasks. I need the output in a csv file with the name of business, job posting link, job category, name of contact if exists email address, phone number if exists. I only want the line saved if there is an email address. Again, I want something I can run from a browser without having to install python or anything in my computer. Please give a price for completing this project. If necessary I can provide access to a server if neede...
I'm in need of a logo designer who can create a modern and innovative logo that successfully combines an icon and text elements . The design must be eye catching and easy to read. The logo will be for all types of marketing including, vehicle identification, yard signs, online platforms such as websites, social media, and digital ads. Key Requirements: - Proven experience in creating combining text and icon-based logos - A portfolio demonstrating ability to design modern and innovative logos - Familiarity with creating designs suitable for online platforms Your design should be able to convey a sense of modernity and innovation while maintaining a professional and sophisticated look.
I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.
I'm seeking an AWS expert to help me with configuring and optimizing my AWS server. Key Responsibilities: - Evaluate my existing AWS setup and recommend improvements for performance, security, and cost-effectiveness - Assist in configuring EC2 instances, S3 storage, and RDS databases as needed - Ensure the server is scalable, reliable, and can handle future growth Ideal Skills and Experience: - Proven experience with AWS services, particularly EC2, S3, and RDS - Deep understanding of server optimization, security, and scalability - Excellent troubleshooting skills and an ability to work proactively to prevent issues - Familiarity with best practices for cost-effective AWS usage - Strong communication skills and the ability to explain complex technical concepts ...
The target is to write a Java, console program (public static void main) that will generate a docx Word file. Program needs to use docx4j library () Programm needs to generate many parts: Heading1, Heading2, Heading3, every with some content (lorem ipsum) Make a table of contents (showing on which page is a given Heading1, Heading2, Heading3 - not hard coded, but detected) Heading1 --Heading2 ----Heading3 ----Heading3 --Heading2 ----Heading3 ----Heading3 Heading1 --Heading2 ----Heading3 ----Heading3 --Heading2 ----Heading3 ----Heading3 In the text put links to a concrete Headings, eg. "read in Heading2 - abc (page 4)" - it should be link to this section and "(page 4)" should Make a footer showing the number of page and first Heading on the
I'm seeking a knowledgeable writer to update an under 500-word article on Visuals SQL. Key tasks include adapting the article to a manufacturing context and replacing outdated information with the latest industry trends. The desired freelancer would have experience in technical writing, specifically within the manufacturing industry, with an in-depth understanding of Visuals SQL.
I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample
...Daily Sales Report: Display daily sales data with graphical representation. o Monthly Sales Report: Display monthly sales data with graphs. o Annual Sales Report: Display yearly sales data with graphical representation. o Data Source: Multiple MS SQL databases. 2. Collection Reports o Daily Receipt Report: Display daily receipt data with graphs. o Monthly Receipt Report: Display monthly receipt data with graphs. o Annual Receipt Report: Display annual receipt data with graphical representation. o Data Source: Multiple MS SQL databases. 3. Inventory Management o Full Inventory List: Display a comprehensive list of inventory items. o Export Functionality: Export inventory data to PDF or Excel files. 4. Customer Data Analysis o Outstanding Amount...
...designer who can help me with converting my existing logo into various file formats. Requirements: - I already have the logo, I just need it converted into PSD, JPG and PNG file formats. - The logo will be used for printing on shirts, so it's important to ensure that the converted files are high-quality and suitable for this purpose. Preferences: - I have specific color preferences for the logo and would like the designer to match the colors to the copy sent. - The font and typography used in the logo are the same as the image I've sent, please ensure this is kept consistent when converting to the different file formats. Ideal Skills: - Proficiency in graphic design and editing software - Experience in logo design and file conversion - Attentio...
I'm in need of a professional Linux server expert to assist with my CentOS-based web hosting server. Requirements: - Expertise in CentOS: In-depth knowledge and experience working with CentOS as the primary operating system of the server is crucial. - Web Hosting Knowledge: Understanding of web hosting principles such as server configuration, performance optimization, and troubleshooting is highly desired. - Security Audits: The task will also include conducting a comprehensive security audit on the server to ensure it is adequately protected against potential threats. - Performance Optimization: Assistance with identifying and improving performance bottlenecks will be required. Ideal skills and experience for this job include: - Strong Linux ...
...and customize WordPress themes - Ensure all code is high quality and maintainable - Troubleshoot and debug complex technical issues - Collaborate with other teams to create successful project outcomes - Maintain a high level of awareness of industry trends and technologies Ideal Skills and Experience: - Proven work experience as a WordPress Developer - Proficient in PHP, JavaScript, HTML, CSS and SQL - Excellent knowledge of WordPress, plugins and themes - Experience with RESTful APIs - Strong problem-solving skills - Good understanding of website architecture and aesthetics - Ability to manage priorities and work in a fast-paced environment - Excellent communication skills This is a long-term project, so I'm looking for someone who is dedicated and can work well also in a...
very simple trivia game ask 10 questions with true/false answers capture user details at the beginning answer 10 questions log user details and response times in a leaderboard, save user details to a CSV file More details to the person who can show skill in this area to work on windows in portrait mode
I have a 120MB JSON file with nested objects, and I am in need of a skilled professional who can convert this data into a CSV format. Specifically, I require the following: - The nested JSON objects should be flattened into single columns in the CSV. - The column headers in the CSV should match the keys in the JSON file. The ideal candidate for this job should have: - Proficiency in handling JSON and CSV data structures. - Experience in working with nested JSON objects and flattening them. - Ability to accurately map JSON keys to CSV column headers. If you've successfully converted complex JSON files into CSVs before and you're confident in your ability to deliver clean, well-structured data, I'd love to hear from you.
We need a freelancer to Wordpress: website eat server resources, fix and optimize You will not have to make custom programming. WORKS TO DO ON 2 WEBSITES: 1- website 1 = - weabsite reaches resources limit all the site (Error 508); - optimize database, cache, etc.M - must load fast and not eat resources (detect the origin and fix it forever); 2- website 2 = - is a simple site made with Gutemberg and Generate Presss. Need to add blog categories on homepage, 3 per row; - search form must look ok + about us page loos broken, must look correcly with margin and in order; Total budget for this job is $ 30,00.- Dollars, since it is just small fixes. Please do not bid more than that amount. A plus can be paid if done fast and as indicated. Please only bid if you...
I need a simple static HTML banner ad designed, sized at 250x250 pixels. The banner is intended to promote my business by displaying a clear message, 'We Pay for our Clients Inspections!'. i was thinking "We Pay" could be larger on the first of 3 lines and 2nd line could be smaller and read "for Clients" and the bottom line would be "Inspections" it should be colored similar to this page coloring: Key requirements: - The banner should be static, no animations are needed. - The design should be eye-catching and present the message in a clear, visually appealing way. - It should be suitable for web placement. Ideal skills and experience for this job: - Proficiency in HTML and CSS to design the banner ad. - Previous
I'm seeking an experienced C++ developer to create an effective Parallel File System based on the Google File System (GFS) - a system we'd like to dub as miniGFS. This project seeks to achieve: - Efficient storage and access of large files: The miniGFS should handle large data quantities seamlessly, allowing both read and write operations swiftly. - Data replication and fault tolerance: This project prioritizes data integrity and availability, necessitating a system designed for data replication and recovery in the occurrence of a fault. - Parallel processing: Optimum speed during file operations can be achieved through parallel processing functionality and the miniGFS should capitalize on this. - Data distribution across multiple nodes: To ensure...
I am seeking a skilled developer who can design and implement a system that will automatically post in Laraclassified ( LaraClassifier - Classified Ads Web Application ) websites from csv files. Key Project Requirements: - The system should be capable of posting the ads daily without human intervention. - The ads must be posted with consistent formatting and accuracy. - Development and implementation should be carried out with a focus on the user's perspective, ensuring the ads are easy to understand and engage with. Ideal Skills and Experience: - Proficiency in web development and automation technologies. - Previous experience with classified ad posting in Lara classified - Strong attention to detail and the ability to deliver a user-friendly experience. - Timely and consist...
I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample
I'm looking to transform my Linux laptop into a hosting server to sell hosting plans. I will provide root access for setup and maintenance, so you'll have full control to configure and manage the server. I prefer using cPanel as the hosting control panel for managing hosted sites. The main tasks and requirements for this project include: - Setting up the laptop as a hosting server - Installing and configuring cPanel - Advising on any additional software or configuration needed to make the hosting business-ready - Ensuring the server is secure and properly maintained Ideal applicants will have experience in: - Linux server administration - Setting up hosting environments - cPanel and web hosting control panels - Network and server secur...
**Please read the attached job post carefully and apply if interested. This is a full-time at least 6 months contract to be renewed. An interview will be required before selecting the right candidate.** I am looking for a marketing specialist with a strong understanding of various marketing strategies and the ability to target specific audiences. The goal of the campaign is to increase brand awareness. Ideal skills for this job include: - Flyers creation - Proficiency in social media marketing, email marketing, and influencer marketing. - Experience in creating and executing multi-channel marketing campaigns. - Strong understanding of the target audience of young adults (18-24), working professionals (25-35), and parents (30-45). - Ability to analyze campaign success and adjust s...
...This project involves reviewing the existing code and it's performance, efficiency, and quality. Ultimately, we need a detailed documentation on the code's state and recommendations on the necessary steps for completion. (See attached file) Key Tasks: - Review and assess existing C# and PHP code for performance, efficiency, and quality. - Identify completion steps. - Create detailed document outlining current state and necessary completion steps. - Recommend testing Ideal Skills and Experience: - Proficiency in C# and PHP. - Experience developing SQL database applications (MySQL is preferred) - Extensive experience in software development and code assessment. - Strong understanding of code efficiency, performance, and quality. - Previous work on d...
