Sql convert excel työt
FIN... Excel-tiedosto sisältää satoja rivejä eri tuotteita, joista on esimerkiksi seuraavat tuotetiedot: positio, tuotepyyntö, tuotevaatimus, tuotenimi, tuotenumero, tuotekuvaus, hinta ja kuvakuvalinkki. Näistä tiedoista pitäisi saada atomatisoitua tuotekortteja. Tuotekortti on käytännössä A4-kokoinen PDF-dokumentti, jonka yksi sivu on yhden tuotteen tuotekortti. Mainitsen tässä InDesignin, koska sitä osaan käyttää ja ajattelin, että jos voin määrittää InDesigniin kenttien paikat, niin olisiko mahdollista, että Excel-tiedot tippuisivat jonkin scriptin avulla näihin kenttiin ja ikään kuin visuaalinen ulkoasu pysyisi koko ajan omissa hyppysiss&a...
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.
Hei, Olen tuore asfalttialan yrittäjä (yrityksessä neljä henkilöä) ja tarvitsen seuraavia palveluita: myyntilaskujen luominen työkirjanpidosta (kilometrien laskeminen, eri työkohteiden erittely ja eri työtyyppien erittely). Osaat käyttää sujuvasti exceliä ja muita perustoimisto-ohjelmistoja. Laskut kootaan viikon loppupuolella, kun viikon työt on tehty. Mahdollisesti muuta toimistotyötä tarjolla myöhemmin, jos osaava henkilö löytyy.
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.
2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.
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 have a PDF document that I need to convert into a typed format for easier editing and updating purposes. The volume of the document is between 50 to 100 pages and I need the freelancer to preserve the original formatting during the typing process. Key Requirements: - Convert a 50 to 100 pages PDF document into a typed format - The typed document should retain the original formatting (fonts, alignments, etc.) - The main objective of this task is to facilitate editing and updating the content in the future Ideal Freelancer: - Proficient in typing and data entry - Familiar with PDF conversion tools - Attention to detail to ensure accurate and precise typing - Previous experience in similar projects would be an advantage Please bid on this project if you have the necessary s...
As the client, I require someone skilled in computer graphics and specifically dealing with image enhancement. The task entails: - Removing background noise - Amending colors for precision - Extracting the image background - Polishing and refining lines - Converting the final image into SVG format The ideal candidate should possess profound skills in graphic editing software. It is essential to keep the original image style intact, hence your ability to enhance while maintaining originality will be crucial. Please note, the final deliverable must be in SVG format.
I have C# MVC Web App that works using SQL Server Database & using APIs at the same time. For the functions that use the database, I want to replace them with the APIs 1- Error message appear with no details, need to make the error message has Show More to display the details of the error. 2- Load Codes from APIs instead of loading from JSON file. (1 API) require updating treeview to load on demand 3- Packages Load from APIs instead of loading from DB (2 APIs) 4- SubscribedPackages Call API instead of inserting into a DB (1 API) 5- Schemes Load from APIs instead of loading from DB (1 API) 6- Uploads Call API instead of inserting into a DB (1 API) 7- Users Call API instead of inserting and reading from a DB (5 APIs) you must have C# MVC experience. ------------------...
...completion and enhancement of a CSV file for upload to Square. This extensive project requires three core competencies: meticulous data extraction from our website, proficient data entry into an Excel form, and the creation of engaging service descriptions using AI tools. The ultimate goal is to craft a CSV file that not only meets but exceeds the requirements for Square's platform, ensuring a seamless upload process. Key Responsibilities: Data Extraction and Accuracy: Initiate the project by extracting data from specific sections of our website. This data must be accurately transcribed into an Excel form, adhering closely to the required fields. Attention to detail is paramount to ensure that the information captured is both precise and aligned with our needs. Cont...
I have a PNG file that I need the text extracted from and accurately transferred into a Word document. This is to preserve the text and make it editable for future use. The key requirements for this job include: - The extracted text must be precise, with no paraphrasing. - Th...ideal freelancer for this project should: - Have experience in text extraction and document formatting. - Be proficient in Microsoft Word and capable of using its advanced features to meet the specified formatting requirements. - Have an eye for detail and a commitment to delivering work accurately and efficiently. By providing this service, you are helping me to efficiently and effectively convert a non-editable file into an editable format. This will allow me to easily work with the extracted text in t...
I require an Excel specialist proficient in creating dynamic and functional spreadsheets. This project involves designing a new Excel sheet that handles both numerical and text data. You would need to: - Set up the sheet, capable of performing multiple features such as automated calculations and conditional formatting rules. - Configure simple calculations for GP indicators basing on specific cost prices. - Ensure the spreadsheet can efficiently process a mix of numeric and text data. Strong skills in Excel and data management are essential for this project. Familiarity with advanced Excel functions and an ability to provide quick, efficient solutions to data processing problems would also be very beneficial. A good understanding of GP indicators and cost pri...
I'm seeking a professional with a strong background in Excel to develop a keyword search tool for an Excel database. This tool will primarily be used for filtering data and linking to articles hosted on a network. Key Requirements: - Experience creating and managing Excel databases - Proficiency in implementing keyword search tools in Excel I would like the sheet to have a Main/Search Page and another page for the database. I want to be able to add new entries to the database section and have them be searchable on the main page. I want to be able to create new searchable keywords on the database page and have them populate and be searchable on the main page. I would like to be able to enter multiple search terms into the search box to narrow the results....
I need this to be done IMMEDIATELY! - Extract data in a specified format. - Transfer data from the price listing PDF to an Excel spreadsheet. - Input details such as SKU, Name, Description, Brand, Cost Price, Length, Width, Height, and Weight, which are highlighted in blue. - If any title or heading is not mentioned in the details provided in item #3, add it to columns U-Z. - Ensure all data is formatted correctly, with names in proper case and prices as numerical values. I'm in need of a proficient data entry freelancer to help convert a scanned image PDF to an Excel spreadsheet. Key Details: - The PDF contains less than 50 pages. - The data in the PDF is in the form of scanned images, making it crucial that the freelancer has experience in handlin...
I need an experienced professional who can help me increase the sales on my website through email marketing. Key Points...through email marketing. - Content Creation: It's important to note that I don't have existing content for the promotion, so the freelancer is expected to create the content as part of the project. The ideal candidate should have: - Demonstrable experience in boosting online sales through email marketing. - Strong content creation skills. - Understanding of consumer behavior and strategies to convert leads into sales. - Proven record of successful e-commerce promotion through Email Marketing. - A good understanding of the latest tools and techniques in Email Marketing. Please provide examples of previous work and strategies you have employed to in...
I'm looking to develop a targeted marketing and advertising strategy that will effectively reach professionals & home owners and convert to sales. Key Objectives: - Increase sales: The main goal of this project is to boost sales through marketing and advertising efforts. Your strategy should be focused on generating leads and converting them into actual sales. Target Audience: - Professionals: The strategy should be tailored to engage and appeal to professionals. Understanding their needs and preferences is crucial for the success of this project. -Home Owners: We manufacture construction related products (windows and doors) which we need to get in front of decision makers to be specified into projects. Preferred Channels: - Social Media & Search Engines: While the...
I'm searching for an experienced translator who can convert my non-fiction book from English to Spanish. The word count is less than 10,000 words. The ideal candidate will also be able to assist with publishing it on Amazon. Key requirements: - Translate from English to Spanish - Experience in translating non-fiction texts - Familiar with the Amazon publishing process - Ability to professionally format and design the Spanish version of the book Please share previous translations and publishing works when you bid.
I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing
I require, a professional with keen knowledge of Python and ArcGIS Pro, to create a script that can convert my ArcGIS Pro lyrx documents into the Geostyler format. The script must include the conversion of colors, labels, symbols, and fonts. Any individual with substantial experience and demonstrated skills in this field is strongly encouraged to bid. We are aware there are many libraries out there that can convert into many formats but not directly. We are ok with the document being converted several times as long as the end results are correct. We need this completed as soon as possible. Ideal Skills: - Proficiency in Python programming language - ArcGIS Pro expertise - Understanding of mapping elements including colors, labels, symbols, and fonts - General know-how o...
I am seeking a skilled freelancer to guide me in creating Power Automate flows that efficiently import data from a single worksheet Excel document into Dataverse. Key Tasks: - Develop a couple of Power Automate flows to import Excel data into Dataverse. - I have had many difficulties with date and lookup/choice columns not correctly importing. Ideal Candidate: - Expert knowledge and experience in Power Automate. - Proficient in Data Integration between applications. - Knowledgeable in creating approval workflows and automated notifications. - Previous experience with Excel-data integration into Dataverse. - Excellent communication skills.
...(SOC), and state of health (SOH) based on the paper. Set up the objective function to minimize charging time while minimizing battery degradation. 3- Optimization Method: Implement the Legendre-Gauss-Radau (LGR) pseudo-spectral method. Use adaptive multi-mesh-interval collocation to transcribe the optimal control problem into a nonlinear programming (NLP) problem. 4- Algorithm Implementation: Convert the differential equations for each submodel into a numerical format compatible with optimization algorithms. Write the pseudo-spectral method for numerical optimization using libraries like SciPy for Python or built-in MATLAB optimization tools. 5- Optimization Execution: Define multiple test cases for minimum-time, minimum-aging, and balanced charging. Analyze results and generate ...
I have 3 custom services written in node, database and a few other services that i need to convert into dockerfiles. Also i want to build Ubuntu and Debian templates with manually built dependencies and end use those as base images i can customize easily.
Tengo una asesoría energética, la cual paga comisión por contrato. La comisión depende de distintos factores. Actualmente tenemos un backend en excel y un frontend en pdf, es decir: Creamos las comisiones en excel para agilizar la creación, las copiamos en un POWERPOINT algo más atractivo y visual, y las convertimos a pdf. Nos gustaría poder implementar la subida de estos excels en una interfaz BONITA, incrustrada en una web. Lo ideal sería poder cargar estos excel a la web y que la web "pintara" estas comisiones a través de una interfaz visualmente atractiva y llamativa para nuestros agentes comerciales. Adjuntamos ejemplo de excel de comisiones de algunas de nuestras compa...
I'm in need of an experienced translator, ideally a native Peruvian, to convert a 50-minute Spanish video into English subtitles. This is an ongoing project with more than 10 similar tasks waiting for completion. Key Requirements: - Fluency in Spanish and English - Professional experience in subtitling and translation - Capability to provide verbatim translations i.e. capturing every word and sound - Expertise in time-coding for editing purposes The ideal candidate should be able to deliver high-quality, accurate translations within a reasonable time frame. Please include your previous experience in similar projects in your proposal.
I'm in need of a freelancer who can automate my Excel spreadsheet to increase efficiency and accuracy in data entry and analysis. Key Duties: - Automate data input, validation, and manipulation - Perform calculations and formulas automatically - Generate reports and summaries for the data Ideal Skills: - Proficiency in Excel - Excel input form design - Previous experience in automating data entry processes - Understanding of data manipulation
I'm seeking an experienced Google Script specialist to automate tasks and manage data for my project. Here are the specifics: Automating tasks: Your main responsibility will be to automate data import/export processes using Google Script. I need to take the data attahed to a daily email in excel format, upload this data (and historic) to a data base and then allow to consult that data from different spreadsheet in google with a query. Ideal skills and experience include: - Proficiency in Google Scripts and automation - Experience in data management - Google spreadsheet analisis reports If you have the needed expertise, I'm excited to work with you!
I am in need of a virtual assistant who can efficiently handle my Instagram & FB business account. It involves the following: - Fast SEO for startup and ranking them - Proactively DMing and reaching out to my target audience with the goal to enhance leads and ultimately convert them to sales. Initial target 100 DM’s per day - Responding to messages in a prompt and friendly manner. - Managing and moderating comments to ensure a positive experience for my followers. This is a part-time role requiring 1-2 hours of your dedicated service every day. You need to have excellent interpersonal skills and a knack for sales talk. Preferably, you have experience with Instagram's and Facebook business interface and are familiar with its demographics. I look forward to your bid.
...with strong skills in data scraping and extraction, particularly with textual content and figures, from a specified public website - Tasks: - Effectively pull relevant textual content and figures - Ensuring the scraped data is comprehensive, accurate, and neatly organized Excel Skills: - The data collected must be meticulously stored in an Excel database - The organization method within the database is by entity An effective freelancer must be detail-oriented, proficient in using Excel and knowledgeable about data scraping techniques from public websites. A background in handling similar tasks would be advantageous. Accuracy and neatness in data organization are also paramount. Please indicate you reviewed the information above and attached and specify the a...
I'm seeking a skilled digital marketer who can assist in creating a multi-channel strategy to boost our lead gene...assist in creating a multi-channel strategy to boost our lead generation efforts. Your responsibilities will include: - Developing and executing a comprehensive social media marketing plan that targets our key audience segments. - Implementing SEO techniques that will enhance our online visibility and help us attract more quality leads. - Crafting a series of engaging email campaigns designed to convert leads into customers. I'm looking to boost our lead generation significantly, so the ideal candidate for this project will have a proven track record of successful lead generation through digital marketing channels. Experience in our target market (if provid...
I am in need of a translator to convert my personal documents from Castilian Spanish into English. The freelancer does not need to be a native speaker, but should possess basic communication skills. No business or website content will be included, purely personal documents. Experience with Castilian Spanish nuances is a must for understanding context and subtlety. Basic skills in both English and Spanish are required in order to perform this job effectively. Thank you!
I'm in need of an application that prints labels from an Excel spreadsheet. The scope is to print personalized employee labels with names and respective earnings for cash payments. Key project features: • Read an Excel spreadsheet in a consistent format, with different entries for each worker's name and earnings. • Print labels with the worker's name and corresponding earning. Candidates should have: • Extensive experience in programming • Familiarity with reading data from Excel • Expertise in printing functions Just to clarify, the format of the spreadsheet will always be the same, only the contents (worker names and earnings) will differ. Please ensure the program is capable of handling this accurately. Your...
I'm in need of a proficient social media manager who can post daily content on Facebook, Instagram, TikTok, and other platforms through Loomly. The job will mostly entail modification of existing content. However, your creative input is most welcome. There is an official step-by-step Process to follow. Minor Excel reporting is required as well. I need somebody who is proficient in English-written and listening/talking. Must be able to work in a New York time zone between the hours of 12 PM and 8 PM. Roughly 2-3 hours a day total Monday-Friday at $30 a week! This role requires: - Excellent understanding of these four platforms - Proven ability to edit and modify existing content in an appealing way - Capacity to deliver consistently on a daily basis - Attention-to-detail...
...Freelancer – I will decide on the project in 3 days. The business evaluator estimates what your business is worth and offers a blueprint for scaling your business to the next level. The blueprint will establish your business baseline, identify your peer group, and advise you on what you need to do (people and budget) to accelerate to the next peer group level. Currently: 1) Written in MS Excel and utilizing Macros for a. Navigation between Sheets b. Set a subscription, 1st time the Worksheet is run, it writes a date in a database worksheet 2) There are 2 worksheets for Input: a. Customer Main Input Screen - worksheet (90% of the application runs off data from this worksheet i. The information from this worksheet is utilized for all 8 other reports (worksheets...
I'm looking for a skilled animator with experience in creating 3D characters to bring my 2D robot character to life in a 3D hologram fan. The character will be used in a school stage setting, interacting with a child and delivering a motivational script. Key Responsibilities: - Convert 2D character to a detailed and expressive 3D robot for the hologram - Create a dynamic script that is engaging and motivational for our script. - Ensure precise lip-sync of the robot's movements with the voiceover - The overall aim is to inspire and encourage students Ideal Freelancer: - Proficient in 3D character design and animation - Experienced in creating hologram presentations or similar projects - Ability to create precise lip-sync for a natural and engaging presentation In your p...
...Existing Environments. Maintain Documentation For System Processes And Procedures. Participate In Code Reviews, Contribute To Team Knowledge, And Mentor Junior Developers. Required Skills: Strong Proficiency In Perl Scripting And Python Programming. Experience With XML Technologies, Including XML Parsing And XSLT Transformations. Good Understanding Of Relational Database Management Systems And SQL. Excellent Problem-Solving Skills And Ability To Think Analytically. Strong Communication And Interpersonal Skills, With An Ability To Communicate Complex Concepts To Non-Technical Stakeholders. Additional Qualifications: Experience With Web Technologies (HTML, CSS, JavaScript) Is A Plus. Familiarity With Software Development Methodologies Such As Agile/Scrum. Perks And Benefits:...
I'm seeking a talented developer to create a custom Telegram bot for my company. The bot will serve as a communication tool and a source of information. Ideal Skills & Experience: - Proficiency in Telegram Bot API - Experience with bot design, including user input and automated messagin...Documents and presentations - Training materials - Policies and procedures Your design should ensure the bot is user-friendly, reliable, and able to handle the company's internal resources efficiently. The Most important thing is the BOT must be PRIVATE and the only method to subscribe to BOT channel is by OTP sent to the registered e-mail in my company domain. The email list will be provided by excel sheet to you. The second MOST important thing is that the bot channel must be un...
I need a senior Nextjs developer to convert figma to frontend urgently.
I'm in need of a skilled freelancer to set up and install Primavera P6 EPPM 21.12 locally on Windows. This is a single user setup, with SQL database configuration included. Key Tasks: - Install Primavera P6 EPPM 21.12 on a Windows system - Complete and configure the SQL database for the software Ideal Freelancer: - Experienced with Primavera P6 EPPM installations - Proficient in SQL database setup and configuration - Understands the intricacies of Windows OS - Prompt and clear in communication
I'm looking to convert my current WordPress website to , using the template from The main focus of this project is enhancing the speed of page loading and ensuring that the site is fully optimized for mobile devices. Key Points: - The current WordPress website consists of less than 10 pages, each of which needs to be accurately and efficiently converted to Next.js. - The converted website should have improved page loading speed compared to the original WordPress site. - Mobile responsiveness is a critical aspect. The site should be designed to operate smoothly and effectively across a wide range of mobile devices. - As for the design and layout, I have a specific reference website in mind. I will provide further details and guidance
The request is to convert this website into a WordPress site. We have already set up a server with version 6.5.2 to which we will provide access via FTP and admin user. The website is a landing page that will contain the following sections: Home About Services Projects Gallery with video Contact : In the contact section the user could send an email to a specific email, configurated in some place. I also need the user to be able to write a WhatsApp message. In addition to the conversion, we need to add a JavaScript script that will be provided to you, that contain GDPR regulations. All materials (images, videos, graphic templates) will be sent to you after the selection phase. The site should be set up in Italian, but we will change the