Pull different named files 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 ;)
(Attachments: , data_{country}) I have a REACT.JS app project named that gets access to different data_{country}.xlsx (data_{country}.json) files, i.e, data_Australia or data_UK etc. I want the freelancer to adapt the attached code into a WordPress plugin (as in ) Skills: REACT JS; WORDPRESS DEVELOPER; WEB-DEVELOPER
Hello, we work in telecommunications and trading "capacity" such as submarine cables, satellites, fiber, etc. is very complex as every hour we get a lot of requests and offers - tracking these in an excel takes a lot of time and we lose opportunities. I need an AI based tool that : 1 - structure on an excel file or Sql database ALL the capacities that we have and that keep coming every hour. I will provide the structure and the route 2 - a tool that reads in my emails and whatsapp conversation and can extract and fill the database. For example "hello Tony, how are you - I have an urgent need of 100MB of Internet in New York, my target price is 10K USD" -- this would have to be properly read, extracted and summarized for my approval before being inserted. It nee...
Hi, i am Using Ghost as a Headless CMS with Static Site and like to Generator and Deploying to Cloudflare Pages. the work: static HTML files you could use an automation deployment workflow using Netlify . linking my Ghost installation and adding the repo to Netlify this can host static files in the same way you were on GitHub Pages, but the static files would be automatically redeployed whenever I make a change in your Ghost content with the use of webhooks. more info on how to do it ca be found at:
...capable of running smoothly on Linux. This self-installing system should be adept in reading logs sourced heterogeneously from SQL Server databases and file systems. Post reading, the software should be equipped to accurately transfer these logs either to an FTP folder or a predetermined online database. Ideal Suitabilities: - Significant experience in Linux-based software development - Proficient in managing SQL Server-based logs - Strong understanding of file system log management - Experience with FTP file transfer protocols - Familiarity with online database systems Given the complex demands of this project, bidders will require a deft understanding of several different log management principles, and should ideally demonstrate experience in creating similar sy...
More details: Which specific export portals do you want your business to be listed on? Exporters India Could you specify the type of goods your business exports? Textiles and garments Do you have specific descriptions or keywords you want to emphasize in your listings? This question was skipped
I'm looking for an experienced data scraper to pull product information and pricing details from an automotive company's website weekly. - Data to be scraped: - Product names - Product descriptions - Pricing details You should have a good track record of accurate and efficient data collection, with the ability to deliver results on a regular and timely basis.
Please I have now had a number of sql developers who just disappear, cannot do teh job right now and start BS about php work. Stay away if you do not have time and understanding of how to work with sql. Timeline: Start immediately Deliver within the day. Issue: I describe the below issue as one of the issies There is a second issue that has a similar problem but it cannot be explained here due to the cinfidentiality NDA: my code is private and paid for. You sign my NDA which is a standard nda. It can be signed in Adobe reader which is free. Type in, save and send back. Very easy. Freelancer has approved this nda many times since they cannot force anyone to use their nda. This is a legal thing where the country law force them to approve my nda. The country law is always...
I am seeking an experienced ASP.NET and SQL database expert to collaborate on an unspecified developmental project. While the expected outcome of this engagement remains fluid, a strong grasp of these two key technologies is non-negotiable. Ideal skills and experience: - Proficiency in ASP.NET and SQL databases - Proven ability to work on undefined, evolving tasks - Ability to apply technical skills creatively I encourage you to include details of any relevant experience and past work in your application to demonstrate your proficiency and versatility. A detailed project proposal will also give me a glimpse into how you intend to approach this task. Note that specifics of the task will be further clarified during the selection process.
I am looking for a line art image of five hands making different hand signs (shown in pictures below) in one horizontal line. I am flexible between minimalistic and slightly detailed images.
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
...Descriptive and inferential statistics skills are advantageous, but not required. THE QUESTION THAT I NEED YOU TO ANSWER BEFORE YOU REPLY: If you have a column named "target" and two other columns named "1" and "2," you can calculate the correlation between the "target" column and each of the other two columns separately. This will give you an indication of how each of the independent variables (columns "1" and "2") is related to the dependent variable (column "target"). What if you don't want to these tow columns separately, i want to see how both these tow together correlated to the target? I have more than 20 columns and one column named target... if i take each column separately i will...
...craft a unique logo for me. Here's a brief about my requirements: - The logo design needs to be a combination of text and images reflecting the construction business. - As for the color scheme, the primary colors should be black and white but I am open to creative suggestions. - I used ChatGPT to create a rough idea of what I'd like. But, it's not quite perfect. The construction company is named CerroWorks. Cerro means mount or hill in Spanish and that reflects my heritage, so I'd like it incorporated into the logo design. Ignore the wrong spelling in the images attached, ChatGPT does NOT know how to spell when it makes graphics with text. - I will need variations on the logo that I can use for business cards, letter head and my website which is under de...
I'm in need of someone skilled in epub document editing. There are several changes that need to be made to my current book, "Bonus Time Extreme Lives and Second Chances", to prepare it for print on demand. Here are the tasks: - Change the publishing house information. - move a caption on an existing photo The publishing house information that needs updating is the publ...Here are the tasks: - Change the publishing house information. - move a caption on an existing photo The publishing house information that needs updating is the publisher's name and address. Your expertise in epub formatting and past experience in preparing documents for print is much needed. Attention to detail is also crucial for this job. I look forward to working with someone who can help me ...
...validating and including transactions from a given set of transactions. The repository contains a folder mempool which contains JSON files. These files represent individual transactions, some of which may be invalid. Your goal is to successfully mine a block by including only the valid transactions, following the specific requirements outlined below. Objective Your primary objective is to write a script that processes a series of transactions, validates them, and then mines them into a block. The output of your script should be a file named that follows a specific format. Requirements Input You are provided with a folder named mempool containing several JSON files. Each file represents a transaction that includes all necessary information for valida...
...which: Describes the reasons for chlorination of water Presents findings in an in-depth report which: Explains the effect of chlorination of water both advantages and disadvantages (to the individual) Presents findings in a comprehensive report which: Multiple links to the local community and further afield using chemical ideas and terms Identifies two different views/outlooks/ opinions/perspectives with supporting evidence (named people or groups). Takes a position on the issue. Takes and justifies a position on the issue (with reference to specific evidence or information). Students must state their position and explain why using evidence from research. Makes a recommendation for action, which is justified by their position on the issue. Students must expl...
I'm looking for an individual with skills in digital image editing to perform a moderate detail object transfer from one picture to another. Here's what the project entails: 1. Object Extraction: The selected candidate must first extract the object of moderate detail from the first picture. The object's original colors should be preserved - no blending or color adjustments are needed. 2. Object Installation: Once the object is extracted, it must be inserted into the second picture. The ideal candidate for this project would be somebody with a background in graphic design, specifically with skills in photo editing. Knowledge of professional tools such as Photoshop and attention to detail in maintaining the color and texture of the object are key for this project.
...project to display textual and numeric data extracted from SQL. The system's features should include capturing inputs from the website and storing the information directly into MySQL. Key Responsibilities: - Develop a Django system with capabilities to interact with SQL and MySQL databases - Display both numeric and textual data on the website - Implement features to capture user inputs directly from the website and store them in MySQL Design Aspects: - A minimalistic approach is preferred for project design for ease of navigation and user interaction - The design should also be clean and professional to affirm the project's credibility Ideal Skills and Qualifications: - Expertise in Django frameworks - Strong knowledge in integrating SQL and MySQL wit...
I'm seeking a seasoned SQL developer with specialized skills in: - Database design - SQL query optimization - Data modeling Main tasks will include optimizing my existing MySQL database and modifying current queries. Proven experience in MySQL is crucial, and an ability to effectively optimize and streamline existing databases is required. Show me your magic touch in transforming my current setup into a well-optimized machine.
Dear designers, We need a unique, stylish and clean company logo for a car dealership in The Netherlands named "Moss Automotive". This company will be working in the import and export of premium luxury cars. Please note that our target audience will be traders in high end cars from all over the world. The logo design must match our target audience. We don't have a specific design in mind and we want to see some nice and creative ideas from you. I will provide regular feedback and remove the designs we don't like to keep the entries clean. Please don't submit used logo's from generator AI tools. We need something unique designed from scratch. Please don't submit 3D entries with storefront or wall background. Just the logo in 2D please so we can ...
Looking for a proficient developer skilled both in PHP and WordPress. The requirement includes: **Overview** Create a web portal using PHP and WordPress that facilitates hospital appointment bookings, integrates with WhatsApp Business, and provides essential features for patients, hospitals, and administrators. **User Roles** 1. **Patients**: - Can book appoint...doctor details. - Include basic information and contact details. **8. Export Reports** - Administrators and hospitals export reports (e.g., appointment statistics). - Export data in CSV or PDF format. **9. Search Functionality** - Search bar to retrieve bookings based on keywords (patient number). **10. Logout** - Secure logout functionality for all users. **Database Setup** - Create a MySQL/SQL server within ...
...Features Required: - Nutritional Database: A comprehensive library of ingredients and their nutritional values is crucial for effective operation. Previous experience building or consulting, specifically Chinese Nutrition Facts label and ingredient databases, is a must. - Ingredient Databases: Must provide Chinese Ingredient Databases and other relevant files/attachments - Identify ingredient databases/and other pertinent files for usage in our SQL Database by our in-house software engineers - Recipe Analysis: The ability to break down Chinese nutritional content into their constituent parts and analyze and present information in an easily digestible way. A background in developing similar functionalities is preferred. - Customizable Labels: A key feature of t...
Build snowflake view to replace Alteryx workflow so there is an Alteryx workflow that I have provided XML code for (EU Global Test Mix Alteryc XML). I am trying to join the 6 SQL Queries in the SQL Development Project file to create the same output as the Alteryx workflow. I have also attached samples of the data that queries 1-6 create. Is this something that you can help with? DELIVERABLES The final product should include SQL executable in Snowflake based on logic in Alteryx workflow. The view should update every 6 hours.
i want to convert some files into a json tree format files are complex cad files but I have a lib you can use. see here for more info and apply here : say snookile somewhere in prop. and I
I'm seeking a talented developer to create an application that can pull data (both text and images) from a specific website and send it directly to a printer. The website's data would be retrieved using URL and ID parameters. This app should also allow user to select their preferred printer. Key responsibilities for this project would include: - Understanding the requirements and objectives - Extracting data from a website based on specific parameters - Incorporating printer selection functionality in the app Ideal skills and experience needed: - Proven experience in app development, particularly with functionalities related to web data extraction and printing - Strong understanding of different printers (Inkjet, Laser, Thermal) Applicants are requested to prov...
I'm seeking an Excel expert who can proficiently extract and clean data from Microsoft SQL Server databases. Your skill set should ideally encompass: - Proficient knowledge of database extraction processes particularly from Microsoft SQL Server - Advanced Excel capabilities, particularly in data cleaning - Familiarity with data structures within databases You will be expected to apply your Excel knowledge to clean up the extracted database data and make it ready for further analysis. Previous experience with similar projects is preferred. This project will require excellent attention to detail, precision, and consistency. Familiarity with database manipulation and data extraction tools, in addition to Excel, is a plus. Looking forward to your applications!
...are named by the document number. i.e 000001.pdf. I want a python or delphi program that will check the folder for a document. When you find one. you will process it as follows. 1. found document to process. 2. open text file. Probably CSV format. Lookup document number and get email address from 2nd Field. 3. Create email with predefined subject and content (html) 4. send message to a specific ip address and port. 5. on sucess. Move file to done folder. 6. on fail. If failure is Missing record for email address. Move to “missing email folder” if any other error move to failed folder. Add to reason for failure. 7. process next file. (add short sleep to not overload mail server 2 seconds) 8. all files completed sleep for a predetermine time (5mins) 9. ...
I'm seeking an experienced web developer to create a web application exclusively designed for office assignments in different buildings. This application is required to be built with the features such as: 1. Enter buildings and office information by area, floor, size, type, etc. 2. Assign an employee to each office 3. Generate various reports by the organization that the employee belongs to, by occupancy, by building, etc. 4. Database to be developed using Access database then SQL server once stabilized. 5. Must use suitable bootstrap The web application will be hosted on a local Windows server in the LAN. The User will be authenticated using network ID. Terms: - Only freelancers who are capable of delivering within 10 working days. - Companies are not ac...
I'm in search of a proficient database engineer whose area of expertise lies in ERD design, SQL, PLSQL, and database application. The selected candidate will be tasked with: - Designing a medium complexity ER diagram with numerous relationships. - Implementing a PostgreSQL database application for the purpose of storing substantial customer information. The ideal candidate must have a sound knowledge of PostgreSQL, SQL, PLSQL, and be able to create succinct yet comprehensive ER diagrams with multiple relationships. Proven experience in similar projects and a knack for developing reliable storage solutions will be a plus.
...management from admin dashboard. 2 fixed position with automatic rotation or manual selection. Different ad/size if desktop. 5. Fully secure and up to date security features. 6. Restructure and merge both scripts to work as wanted. More details will be provided. 7. Add futures to admin to get a fully manageable system. More details will be provided. 8. Need to run in sub folder. Design requirements: 1. Fully responsive on 6” display 2. Desktop and smartphone responsiveness. 3. Pixel perfect design. Design examples for guidelines will be provided. Full vision will be provided before start of project. Minor changes and improvements will occur on the way if needed. Php, sql, html, css only. No backdoor connections No hidden code Full transpa...
...user enters the website, they will select the product they want to buy, including the size and color. Then, they will add it to the cart. From the cart, they will proceed with the payment and fill out a form with their complete details to place the order. An order will be generated, and an order number will be issued. This information will also be sent to you via email, stating that the person named XYZ placed this order, and the order ID is XYZ. Shipping will be locally/worldwide. Payment’s method, will be either cash or Local Transfer (OMT, MoneyGram, Wish Money) The total number of products is between 40-50, with the availability to add in the future new items or categories. For sure you will add: Content like about us, for the homepage & for the product description....
I'm on the hunt for a skilled drawer and illustrator, proficient in cartoon-based work. Your primary task would be to create unique, vintage American style drawings with a focus on retro fashion. Ideal skills and experience: - Expertise in cartoon-style illustrations - Deep understanding of retro American fashion - Prior experience in freelancing, drawing for projects ...focus on retro fashion. Ideal skills and experience: - Expertise in cartoon-style illustrations - Deep understanding of retro American fashion - Prior experience in freelancing, drawing for projects Your drawings will be primarily used for developing custom content, with a hint of nostalgia. Creativity and a keen eye for the old-fashioned style is a must. Get ready to dive into the past and pull out som...
Hi, can you please do a similar animation for the following logo?
I'm searching for a knowledgeable graphic designer to create a compelling logo for my existing motorcycle repair business named Moto Shop Service. The successful freelancer should be able to capture the essence of the business which is centered on motorcycle repairs. My business has a local and ecommerce presence. Google motorsports logos for creative inspiration. Key requirements include: - Ability to translate motorcycle repair terminology into understandable visual concepts - Prior experience in logo design and a portfolio demonstrating this - Adept with Adobe Illustrator or similar Designers with previous experience working with motorcycle businesses will be highly regarded. Your innovative ideas and suggestions are also welcome to make a logo that truly stands out.
...send your expected monthly salary if working on a monthly salary basis. The lowest, but experienced offer will have a better chance. Monthly salary will be considered to 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. Recruitme...
...Hours for downloading stuff are not payable. You should turn off the timer while you wait for downloads as we cannot be held accountable for poor connections. 3. We don't agree to pay for research for basic stuff e.g.: - how to create a prestashop module, - how to change the domain - how to create a staging site - how to fetch from git - how to add a git repo - how to make commits - how to do Pull Requests We agree that research is part of our project but on a higher level, not for basics. 4. If you have something you don't undersatnd in the tasks always consult with us first and don't do what you imagine we want. Just ask first. 5. We value good communication and on-time delivery above all even if you can't perform some tasks. Just be transparent wi...