Sql server external table csv 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.

Firstname lastname company email City

server optimisation

File attached

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 ;)

...feature into my Crystal Report PDFs within my web application. This will serve the purpose of authenticating the reports. The signed reports should be saved into a SQL Server database. Key Requirements: - Implement a digital signature feature on Crystal Report PDF files. The purpose of this is to ensure the authenticity of the reports. - The digital signing process should be automated after an approval process. - Save the signed reports into a SQL Server database. Ideal Skills and Experience: - Proficiency with ASP.NET Web Forms and C# is a must. - Experience working with Crystal Reports would be a plus. - Familiarity with SQL Server database management. - Understanding of digital signature implementation and security in web applications. I&...

I'm in need of a skilled individual who can scrape data from various websites for the purpose of lead generation. The data should be delivered in Excel or CSV format. Key Requirements: - Proficient in web scraping - Experience with lead generation - Ability to deliver data in Excel/CSV Ideal Skills: - Proficiency in Python/R for web scraping - Previous experience in similar projects - Strong understanding of lead generation techniques If you have experience in web scraping and lead generation, I'd love to hear from you.

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

I am looking for a skilled freelancer to assist with a project that involves reading text from PDF files and answering questions based on the content. This task must be completed without using any external libraries. The ideal candidate should have strong programming skills and experience with text processing and file handling. Project Details: Objective: Extract text from provided PDF files and answer specific questions based on the content. Requirements: No use of external libraries for PDF reading and text extraction. Write custom code to parse and process the PDF files. Develop a method to accurately answer questions using the extracted text. Deliverables: Custom code/script for reading text from PDF files. A function or method to process the text and generate answers ...

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.

We are looking for a detail-oriented freelancer to help us gather specific icons from and organize them into an Excel table. The icons are for various amenities that will be listed on a real estate website. Responsibilities: • Search for icons on that match the list of amenities provided. The premium version of Flaticon may be used. • Ensure each icon matches the style and aesthetic suitable for a modern real estate website (in the style as attached files). • Document each icon in an Excel table with two columns: Title and Classname. List of Amenities: • See attached file. Requirements: • Experience with and familiarity with downloading and organizing icons. • Proficiency in Excel. • Attention to detail to ensure the icons are corre...

The objective of this project is to create a smart contract on Solana utilizing Rust programming language. The primary goal of this smart contract will be to generate revenue for a specific organization through automatic allocation of funds to an external wallet. KEY FEATURES REQUIRED: * The contract should have the ability to manage ownership transfer. * It would need to direct funds to an external wallet after every transaction is completed. The successful freelancer will have a strong understanding of blockchain and smart contracts, particularly on the Solana platform. Proficiency in Rust is a non-negotiable requirement. Experience of working on revenue generation projects would be a plus. Your tasks will include developing, testing and implementing the smart contrac...

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: - Con...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 conversion is required. This is a project with a potential for ongoing work, so a freelancer with good communication and reliability is highly ...

I'm looking to update the design of my website, www.comansservices.com.au. The current design is a bit outdated, so I'm keen to give it a more modern and sleek look. Key aspects of the project include: - **Visual Overhaul...skills and experience for this project: - Proven track record in website design and development, especially in modern and sleek design styles. - Familiarity with parallax scrolling and ability to implement it effectively. - Strong communication skills to understand the design brief and incorporate new content and pictures seamlessly. - Innovative and creative approach to bring fresh ideas to the table. - Previous experience with similar projects is a definite plus. Please share your relevant portfolio, and let me know your estimated timeline and rat...

i need a web scraper for get the info of , i need some spepecific info (payments transactions) and put this info in a table in mysql. please fell free to ask

This is the variant table with these fields CREATE TABLE ( id varchar(255) NOT NULL DEFAULT uuid_generate_v4(), name_lang json NOT NULL DEFAULT '{}'::json, data_area varchar(255) NULL, description json NULL DEFAULT '{}'::json, "type" bit(1) NULL, active bool NULL, created_by varchar(128) NOT NULL DEFAULT 'system'::character varying, created_on timestamp NOT NULL DEFAULT now(), updated_by varchar(128) NOT NULL DEFAULT 'system'::character varying, updated_on timestamp NOT NULL DEFAULT now(), CONSTRAINT category_pkey_1 PRIMARY KEY (id) ); this is the variant data table with these fields CREATE TABLE public.variant_data ( id varchar(255) NOT NULL DEFAULT uuid_generate_v4(), name_lang json NO...

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...

I'm in need of a skilled developer who can create an AI portal that is capable of efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise in Excel automation and customization. - Strong backg...

...in ad optimization techniques. Content Creation: * Collaborate with contractors (designers, video editors, actors) to produce high-quality promotional videos. * Utilize AI tools to create engaging marketing videos. * Design visually appealing ads using Canva. Collaboration and Communication: * Work closely with the CEO to align marketing strategies with the company's goals. * Coordinate with external contractors to ensure timely delivery of marketing materials. * Provide regular updates and reports on marketing activities and outcomes. ===================== Qualifications: * Proven experience in social media management and digital marketing. * Familiarity with Facebook Ads and analytics tools (experience preferred, training provided). * Proficiency in using Canva for desi...

I'm currently looking for a talented designer to create a compelling banner for my website. The aim of the project is to enhance the branding of the site and attract more visitors. Your responsibilities would include: - Crafting a banner with unique, photographic imagery that ties cohesively into the c...be 1280px x 320px - I just want to convert this poster that is attached into a banner, nothing different Ideal candidates should have: - Proven graphic design skills with a strong portfolio - Experience in creating branded banners - Experience with photography-based design - Attention to detail - A keen eye for aesthetics and visual details I'm excited to see what ideas you can bring to the table, so please feel free to show your creativity. Let's create somet...

...labels—“Stock Price in USD” or “Date D/M/Y” for example. Change the title of the graph to communicated what the graph is communicating. Add options—color, trendlines, legend, other? Calculate the mean, median, mode, and standard deviation of the adjusted daily closing stock price. Put answers of calculations in table format. Write several sentences explaining the process by which you calculated these statistics. Calculate the mean, median, mode, and standard deviation of the stock volume. Put in table format for easy review. Write a sentence explaining the process by which you calculated these statistics. Ideal freelancers for this project would be those experienced in statistical analysis and data visualization. Skills in using tools li...

I'm in need of a skilled developer who can create a comprehensive Vue 3 based template for learning purposes. The primary goal of this project is to have a solid ground for educational purposes, so you'd play a pivotal role in helping expand my understanding of Vue 3's capabilities. Key Requireme...I'm primarily looking for a template for learning, I would still appreciate basic comments within the code to guide me through the functionalities and structure of the template. Ideal Skills & Experience: - Proficiency in Vue 3 with prior experience in creating modular architectures - Strong background in Vue router and Pinia - Prior experience in setting up JWT authentication and working with external APIs - Excellent communication skills to ensure the code is ...

...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 w...

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 needed or to...

I'm looking for an interior designer to completely transform my living room into a minimalist haven. My living room is less than 40 square mt and I am interested in a simple yet sophisticated aesthetic. Key tasks include: * Analyzing the current state of the room and suggesting improvements * Developing a new layout plan * Providing a minimalist design concept that m...small spaces effectively Your bid should include design plan, sourcing furnishings and accessories, and implementation oversight. The room will be completely empty because the couch and other furniture will be removed. The flooring will stay the same bevande I would like to valorize it. Things that are mandatory to fit in the living room are: - smaller but a little darker couch - TV - dining table - vertic...

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

...focused on managing a restaurant's operations. The UI should be user-friendly and ideally suited for a restaurant environment. Key Features: - Order Management: I need the UI to include order tracking and menu customization features. I also require the ability to visualize the restaurant's floor layout to manage the orders efficiently. - Table Management: The UI must allow for table reservations, status updates, and merging. It should help in optimizing table assignments and order efficiency. - Inventory Management: The UI should support managing the restaurant's inventory to streamline operations and track costs. - Staff Management: I need a simple way to manage staff - from assigning tables, tracking orders, and ensuring smooth service. Ideal Cand...

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 am seeking a talented architect/interior designer to conceptualize a small capacity (up to 50 people) e-sport arena. This space should be multi-purpose, with areas for table top and card games, "video game tables", as well as adaptable space for B2B events or co-working. Key project elements: - The e-sport gaming area is the central focus. - A comfortable and homey interior design style is preferred. - Despite the diverse usage, the space should flow naturally and cohesively. - Incorporate dining areas where players can eat while engaging in video games. - The design should be flexible to also accommodate B2B events or transform into a co-working environment when needed. Ideal candidates should have: - Prior experience in architectural design of gaming or recreati...

...am seeking an experienced, talented individual to create an accurately measured floor plan based on a sketch, and perhaps 3d renderings if we align on the 2d. This project will require the inclusion of the following primary facilities: - 4-6 Treatment rooms - Sauna or steam area and day spa space - single-stall showers, changing areas, bathrooms - 1 yoga studio - Mixed use lounge with communal table, lounge area, and hidden AV - front desk - Spa Retail area - lockers - back office area for laundry, storage, and staff break If you have innovative and creative ideas beyond my sketch to further enhance the floor layout to attract more customers, they are more than welcome! You will be working closely with me to design a floor plan that truly captures the essence and objectives of...

I'm looking for an experienced freelancer to develop new widgets for our current dashboard in Sisense. Requirements: - Creation of specific widgets: Charts, Tables - Charts: Line charts, Bar charts, Pie chart...widgets will a show the following: - Top ten Selling Items (# units sold and $) - Upsells (# units sold and % of overall sales) - Modifiers (# units sold and % of overall sales) - Daily specials ($ sold and % of overall sales) The ideal candidate should have: - Proven experience in developing widgets for Sisense - Proficiency in creating various types of charts - Strong understanding of data table structures - Ability to design and implement effective summary and pivot tables I'm looking for a committed freelancer who can deliver high-quality work within a r...

I need a simple task done in FreePBX where incoming calls will be routed and forwarded to external number This task should not take more than 2 minutes for an experienced FreePBX user.

I need assistance with formatting a Word document. It is a 47 page word document that needs to be formatted in terms of look and feel. There are 4 table of contents in the document to be formatted and the page numbers of the document have to be fixed. There is a 13 page pdf that needs to be converted to Word and added to the document. The job has to be completed in the next 12 hours.

...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...

I need assistance with formatting a Word document. It is a 47 page word document that needs to be formatted in terms of look and feel. There are 4 table of contents in the document to be formatted and the page numbers of the document have to be fixed. There is a 13 page pdf that needs to be converted to Word and added to the document.

...to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attention to detail to ensure accurate transfer of all information This project is s...

I'm looking for a talented, imaginative logo designer to create a Christmas fair logo, which I'll provide. I require someone who understands the festive spirit and can bring fresh, creative ideas to the table. Key requirements include: - Incorporating the general typography style, color scheme, and layout composition of the provided logo, while ensuring it's not a direct replica. - Bringing a modern, eye-catching touch to the design that's aligned with the Christmas theme. - Your creativity and skills in adapting and enhancing existing designs are crucial to this project. Content: Rotary Masterton Christmas Fair Ideal Skills: - Graphic Design - Logo Design - Creative Thinking - Branding - Attention to Detail - Familiarity with Christmas design aesthetics ...

I'm in need of a PowerBi expert to resolve a critical error for me. The error message reads: "Failed to save modifications to the server. The error returned: 'Relationship '59f250b2-ca16-47f4-8a50-ba4d8636a1ed' points to deleted column 'Setter 2' in table 'Bridge of Setter'." - Urgency: The task should be completed within 24 hours. - Documentation: I don't need any documentation on how the issue is resolved, just the solution itself. - Dataset Access: Unfortunately, I can't provide access to the original dataset. The expert will need to resolve the issue without it. Skills and experience required: - Proficient in PowerBI with experience in resolving server-related errors. - Ability to work under tight deadli...