Sql database import csv työt

...product name, product number, product description, price and image link. You should get automated product cards from this information. The product card is basically an A4-sized PDF document, one page containing one product. I mention InDesign here because I know how to use it and I thought that if I could define the positions of the fields in InDesign, would it be possible for the Excel data to import into these fields with the help of a script. The visual appearance and design would then be easily adjusted by me. BUT, if there is a more efficient way to do this than InDesign, please let me know! ...

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

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

We are looking for a skilled professional to scrape our competitors' platforms and retrieve their lead database, with a specific focus on contact numbers. This project requires someone with expertise in web scraping and data extraction. The successful candidate will need to have experience in handling large volumes of data and possess excellent attention to detail. The main tasks will include accessing the target platform, collecting the required contact information, and organizing it into a structured database. Additionally, the ability to handle any potential obstacles, such as CAPTCHAs or IP blocking, is crucial. This is a medium-sized project with an estimated duration of a few days or weeks. We require an expert-level freelancer to ensure the highest quality results...

I have a database that I need to extract specific textual information from, in a one-time extraction. The data needs to be structured in an Excel file. Key Requirements: - Extracting Textual Data: You'll need to retrieve text from the database. - Data Structuring: The extracted data should be organized and presented in an Excel format. Ideal Skills and Experience: - Database Scraping: Experience in extracting information from various types of databases. - Data Structuring: Proficiency in organizing and presenting data in Excel. - Attention to Detail: Ensuring that all relevant text is accurately extracted and included in the final Excel sheet.

I am working on React JS with Javascript Development Project. I need someone to Support me for this Project atleast 4 to 5 hours Per day. Project will Exist more than 2 years. I need support through Remotely(zoom). I am looking for Good Experienced(4+ years) Person as a Frontend Developer, Who can work on the tasks super...Quickly. I am looking for Long term relationship. After this Project Completed means, we will give immediately another support project. I will Give you the Sample Task on Cypress Unit Test Cases for 30 mins, If you Completed ON TIME means we will give you the Project. Cypress Unit Test Cases Immediately Required. Required Skills : React JS, HTML, CSS, Javascript, Cypress Test Cases(Mandatory), SQL Basics Language Speaking Person : English Note: I will pay on ho...

Your main task will be to integrate a Zebra RFID reader into an existing software application in Visual studio software. Note: Person who already has Zebra RFID reader 8500 or RFD40 reader must bid for the project, since it is hardware based integration project. Tasks: 1. Single read function 2. Import CSV and perform inventory check If you're a Visual Studio developer with a background in Zebra RFID reader integration, I'd love to discuss how you can help improve our existing software through your skills and expertise.

...seasoned developer to create a comprehensive KYC/AML processor. The system will be responsible for verifying the identity of our users through a multifaceted approach. Essential Features: - The processor should be able to identify user-provided information through the comparison of ID documents, facial recognition technology, and verification of phone numbers and email addresses. - A searchable database must be integrated for easy retrieval of stored documentation. Security Measures: - While I don't need two-factor authentication or regular security audits, I expect a robust security system in place. The encrypted stored data should meet industry standards to ensure user privacy and regulatory compliance. Ideal Skills and Experience: - Proficiency in developing KYC/AML...

I'm in need of a seasoned C# programmer with a proven track record in REST API integration and MS SQL Database management. Your primary task will be to create an interface between a C# application and FactoryTalk Optix software. Key Requirements: - Comprehensive experience in C# programming - Proven track record in developing REST APIs - Proficiency with MS SQL Database - Very familiar with FactoryTalk Optix software The primary goal of the REST API interface is to facilitate data exchange between applications. The interface should be able to handle text and numerical data. Please provide examples of previous REST API integrations and your specific experience with FactoryTalk Optix. Your understanding of data management and exchange will be crucial for...

...Objectives for the system: 1. It has to be completely offline (no online solutions will be accepted); 2. System has to be integrated with LLM (Llama or similar); 3. LLM must be capable on answering questions (via chatbot interface on GUI) on: a. DP’s; and b. Text it read while it was scanning the PDF and looking for DP’s; c. Previously read documents related to the same client. 4. DP’s are to be saved to SQL table; 5. We need a dashboard, to train the engine on finding DP’s in the document. Current problems: A. Large part of documents are scanned, but regardless if the document is scanned or not, it’s all in digital form format. It just so happens that some forms were populated digitally, printed, and scanned; B. As such, scanned documents are: a. T...

Hi I have an old system running in ASP on an Access database, its running slow, so we were told to change the database, but I have no experiences with MSSQL. I can open the Access database myself and export it as you like. Its a fairly simple database with only 3 tables but a lot of products (app. 8500) I hope the old ASP script will still be working, if so its only a new connection file I need, but you have to advice me, if anymore need to be done. I have a webhotel where this is running and the MSSQL database is ready but empty right now. Else there is less than 20 ASP-files calling the database - some just showing specifick producuts and som adding, editing and deleting products - but hopefully theese ASP file can remain as they are today......

...-Collections: Users can create thematic collections to categorize bookmarks -Tags: Suggested and custom tags for better searchability -Notes: Add custom notes to bookmarks for additional context Search and Access -Full-Text Search: Search within the content of saved bookmarks -Permanent Library: Retain access to saved content even if the original web page is removed Importing Browser Bookmarks -Import bookmarks from web browsers Objective: Build the foundational structure and ensure users can save and organize bookmarks efficiently. I don't have a specific design in mind, but the app should have a professional look and feel. The ideal candidate for this project should have: - Proven experience in app development, particularly for web browsers and iOS/Android devices - ...

Migrate 160 blogs from a platform to Shopify. It must be done manually, we dont have an option to export. We must keep the same content and same link structure (slug). Layout doesent matter, can be a standard one. Blogs have around 1000 words and 2 images. We need someone who is specialized on manually import Deadline maximum 1 week. Thank you.

...both Canvas and Model-driven Power Apps. These applications should be designed to interface seamlessly with SharePoint and SQL databases. Key functionalities to be incorporated include; * Workflow automation: Our applications should aid in achieving seamless workflow, eliminating unnecessary delays and redundancies. * Data integration: Facilitating effective synchronization of data across different platforms and databases. * Document management: Applications developed should have mechanisms that streamline the creation, storage, and retrieval of digital documents. The ideal freelancer should possess a wealth of experience in Power Apps development, SharePoint, SQL, and proficiency in Power Automate. We're looking for a skilled individual who understands the intric...

I want to make a export import compney logo and a compney letter head

...professional with the capabilities of facilitating data file downloads. The data in question does not specifically have to be text, numeric, or multimedia, as I have not stated a preference. However, I need it presented in CSV format for my review and analysis. Key duties include: - Assuring the secure and rapid downloading of data files. - Properly formatting the data into CSV files for easy accessibility and comprehension. The ideal freelancer for this job should possess: - Strong knowledge of data management. - Proficient skills in handling various data types. - Expertise in CSV formatting. - Exceptional skills in file download mechanisms and data security. This task requires a detail-oriented person who can accomplish tasks accurately and in a timely manne...

...allow students to use their username, password and SessionID to log in to the session (as long as they are logging in on the given timeframe of the session, as sessions have an initial and end date/time). Student conversations on a chat session get logged into the database. On the Teacher Backend, Teachers can download transcripts of all the conversations their students have had for a specific session (the transcripts would show the students username, the conversation and the transcript with timestamps). Passwords on the database are to be stored with MD5 or similar encription (there is no need for super high level as there is no identifiable information on the DB except for whatever conversations students have). Ideal Skills and Experience: * Proficiency in PHP and My...

...analytical and problem-solving skills. Strong communication skills, both written and verbal. Ability to work independently and manage time effectively to meet project deadlines. Preferred Qualifications: Experience with testing web applications in various browsers and devices. Knowledge of HTML, CSS, and JavaScript. Experience with bug tracking tools like JIRA, Bugzilla, or similar. Familiarity with SQL and scripting. What We Offer: Competitive project-based rates. Flexible working hours. Opportunity to work with a dynamic and innovative team. Potential for ongoing collaboration on future projects. If you are a meticulous QA professional with a passion for ensuring top-quality web applications and are looking for project-based work, we would love to hear from you. Please submit...

I'm in need of a competent and reliable all-around manager to assist with various important tasks in my food and beverage import-export business. These tasks include, but are not limited to: - Finding and liaising with suppliers - Effectively managing logistics and shipping processes - Efficiently handling customs procedures and documentation Given the nature of the business, it is vital that the hired professional has specific experience with food and beverage industry, as well as a deep understanding of the Asia region's import-export regulations and market dynamics. A critical understanding of international trade, meticulous attention to detail, excellent negotiation skills, and capability to manage logistical operations for swift and efficient shipping are es...

...ella, sólo es para mostrar los productos y generar leads. Quiero generar tráfico cruzado entre estos dos sitios, ya que en la tienda sólo estaré publicando productos aptos para ser vendidos online y su precio será distinto al que se obtiene a través de la atención personalizada tradicional (contacto web, teléfono, mail o presencial). Lo que requiero del Freelancer es: - Manejo de Excel y archivos CSV (para la carga de archivos). - Edición de fotos y utilización de programas como Photoshop, Edición de imágenes por Inteligencia Artificial, manejo de aplicaciones como Canva y similares. - Experiencia en armado de ecommerce en plataforma Shopify. - Experiencia en utilización de ASANA. En pr...

I am looking for a skilled developer who has experience working with Rust and CrustyDB to help implement a few operators for a Query Execution Engine. Key Objectives: - Implement join operators to support more complex queries Ideal Skills: - Proficient in Rust and CrustyDB programming - Familiarity with database systems and query execution - Understanding of join operators and how they function within a database system The deliverables will be clear, well-commented code that is consistent with the project's instructions, which can be found in the provided link. Your focus will be on implementing join operators, so experience and understanding in this area are crucial.

...MySQL database, to a new hosting environment. **Project Details:** - **Current Setup:** - Website developed in Umbraco (Microsoft open-source CMS). - Backend: C# coding. - Database: MySQL. - Currently hosted on a Windows server with IIS. - **New Hosting Environment:** - Hostinger VPS with Linux OS. - SQL Server installed via command line (no GUI). - No Windows server or IIS available. **Issues Encountered:** - Umbraco runs well locally on the VPS but not accessible externally. - Unable to attach the website domain. - Issues uploading the website from a local machine to the VPS. **Requirements:** - Expertise in Umbraco CMS. - Strong knowledge of C# and MySQL. - Experience with migrating websites from Windows/IIS to Linux environments. - Familiarity ...

I need a python programme to download historical prices on daily basis of a list of stocks from the BSE India (Bombay Stock Exchange) website. Data should be stored in csv or excel file. Retrieve data accurately and efficiently.

A website used to be a WP site. It is now remade with and the new version is hosted on a new server. I need to retrieve the old information from the DB drop. When I try to add the database entries to a freshly installed WP installation and access it (either localhost or server) it immediately throws 301 error and redirects to the new kobe-oukoku website. Please add this text in the beginning of your application so I know you've read the description: kobe animal kingdom.

DATA SCRAPPING DATABASE This is an interesting overview of the steps that might be involved in completing this project: 1. Develop a web scraping script using Python (e.g., BeautifulSoup, Scrapy) to extract data from relevant grant databases and websites (if possible, considering anti-scraping measures). Sites to be scraped: 2. Design a database schema to store the extracted data. 3. Write scripts to clean, transform, and load the data into the database. 4. Design a WordPress directory listing interface with search filters to display the grant information. 5. Develop a user interface to query and display the grant information based on customer criteria 6. Create a Python plugin for WordPress to automate the scraping

...to initiate automations based on specific actions (e.g., task creation, completion, or status change). Email Integration: Integrate our email system with ClickUp to enable direct email sending from within ClickUp. Ensure that email addresses prepopulate as contacts' details are typed into the email address field. Create and configure email templates for common communications. Contact Management: Import and manage a large contact list (approx. [specify number]) within ClickUp. Ensure synchronization of the contact list with external sources if needed. Checklists and Task Management: Organize and automate around 20-25 checklists with varying numbers of tasks. Set up dependencies and automate the flow of tasks within these checklists, ensuring that changes in due dates propagat...

I have a lot of data in a spreadheet. Have a look at attached spreadsheet. I need the sheet named "auto made" to be automaticly made. (it is now manually filled with data) What triggers data to be in "auto made" sheet is the value 1 in Ordre!B column. If no value in Ordre!B column the "auto made" sheet will only have headers. Description on where the data is from is described in row 10 in ...the sheet named "auto made" to be automaticly made. (it is now manually filled with data) What triggers data to be in "auto made" sheet is the value 1 in Ordre!B column. If no value in Ordre!B column the "auto made" sheet will only have headers. Description on where the data is from is described in row 10 in "auto made" sheet. ...

...suppliers, products, and purchase orders from various data formats (CSV, XML, JSON) and seamlessly import them into Microsoft Dynamics GP 2016. This will greatly enhance the efficiency of our purchasing workflow and eliminate the need for manual data entry. Ideal Skills and Experience: - **Microsoft Dynamics GP 2016 Proficiency**: A thorough understanding of Microsoft Dynamics GP 2016 is essential for this project. Previous experience working with this ERP system is a must. - **Database Manipulation**: Given the preference for direct database manipulation, the selected freelancer should be proficient in creating secure, efficient, and reliable integrations. - **Data Formats**: The ability to work with multiple data formats, such as CSV, XML, and JSON,...

Hi I will work for 6 hours and get website leads as many as possible till Tomorrow. Thanks

I'm in need of a freelancer who can help ...who can help me parse my VCF file and convert it to a different format. The main goal of this task is to extract the genotype information from the file. input will be VCF file (from ONT whole genome run) and csv file with columns containing rsID, chromosome number, position. output will be same as input csv file, with extra column showing genotype from VCF at the given position can run on Mac shell so either perl or python would be fine. Ideal Skills & Experience: - Proficient in parsing VCF files and understanding genotype data - Experience in converting files to various formats like CSV, TXT, and XLS - Attention to detail to ensure accurate extraction of the data - Knowledge of any data validation methods would be...

...can create a Windows GUI application. This app should be capable of opening and editing a pre-formatted CSV file. Key Features: - The app should have interfaces for inputting free-form English text in certain fields and selecting options from drop-down menus in others. - It must offer normal file saving and opening functionalities. - The design should incorporate a professional and corporate-looking splash screen graphic and an about page. User Interaction: I aim for a straightforward user experience. The app should be intuitive and easy to navigate without the need for an extensive guided walkthrough. Ideal Skills: - Proficiency in Windows GUI app development - Experience working with CSV files and handling user inputs - Strong understanding of UI/UX design, especially...

I'm in need of a skilled Shopify developer with solid experience in data import from Excel. Specifically, you'll be dealing with: - Product data import into my Shopify site from a URL download of a CSV - Importing simple data, without dealing with variants or complex attributes. - syncing of the products in the CSV with Shopify products would happen every 24 hours automatically - If an existing product on Shopify is not found on the CSV download, its status on Shopify needs to be changed to "draft" or "inactive". The ideal candidate should have: - Strong Shopify development skills - Familiarity with Excel or similar data management tools - Experience with product data migration or import Success in this project wou...

...of the school (e.g., only certain locations or only scheduling). Teacher Management Teacher Data Upload: Module to add and update teacher information, including: First and last name Email Phone number Subjects taught (both theoretical and practical) Hourly and daily availability Locations where the teacher is available to teach Intuitive interface for quick data entry with the ability to import data from CSV or Excel files. Tabular view of teachers with search and filter functionalities. Hourly and Daily Availability: Interactive calendar to set daily and hourly availability of teachers. Drag-and-drop functionality for easy time adjustments. Ability to set recurring availability (e.g., every Monday from 9:00 to 11:00). Option to add notes or comments for each availabilit...

...set up a WordPress real estate theme for my website. Additionally, I need the developer to transfer all listing information from an existing website to the new one. Project Details: Theme Installation: Install and configure a WordPress real estate theme that I will provide. Hosting: Recommend and choose a suitable hosting package. Data Transfer: Extract all listings from a specified website and import them into the new WordPress site. Focus Area: The new website will only feature the sales section. Requirements: Experience with WordPress theme installation and customization. Familiarity with real estate themes. Ability to transfer data accurately and efficiently. Strong attention to detail to ensure all listings are correctly migrated. Good communication skills to update me on...

...that I need. The data columns listed above will be need to be automatically pulled into tables and columns and stored in Microsoft Excel. I need to be able to use SQL or a UI and ultimately easily import/embed into Microsoft Excel - the data finally must be pulled into Microsoft Excel. The freelancer must be Proficient in working with Amazon Seller Central and pulling back the relevant info for comprehensive, robust reporting purposes. Understanding of reporting data from Seller Central data and experience in data reporting and data analytics. Also ultimately this data is to be stored into a database and to where I can use SQL to create queries and tables for dashboard reporting purposes. Your work will be crucial in creating and enhancing reporting f...

I'm seeking a Power BI expert to create a Territory Map of both Zip and State. Key Project Requirements: **Mapping:** Your task involves creating the map with both zip and state information. **Data Update:** The map should be updated periodically, not in real-time. I'm using ARCgis in Power BI to create maps. I can create a good map based on zip codes, or based on state, but I can't seem to figure out how to combine the two. Our CA territory is divided by zip code, but some states are considered one territory. So, I need to apply first a filter by zip code, and then a layer based on state on top of that. Attached is the territory map by zip code that I created with Power BI. I need it to look like that but with New Mexico, Arizona, and Nevada fully colored in with...

I'm looking for an expert who can accurately retrieve data from an AWS RDS Database. The task includes: - Extracting text data, specifically all customer data - Precise collection of customers' names, emails, and membership dates - This project involves data extraction of all customers, not just active members Ideal skills and experience would include a comprehensive understanding of AWS, RDS databases specifically, and a stellar ability in data extraction and management. You should be meticulous and maintain the integrity of the data while handling extensive datasets. Familiarity with customer database management would be an added advantage.

I require a meticulous professional, experienced in the workings o...functional - Solve data type mismatch errors, ensuring seamless data integration - Add some of the small functionalities to the application. - Need the full application to run smooth without errors. Ideal Skills: - Commitment to meet tight deadlines as an immediate resolution is vital - Prior experience in troubleshooting errors in Microsoft Access 2007 - 2010 - Expert understanding of database structures and Sql syntax Ultimately, the freelancer should bring this software application back to its most optimal version in the earliest possible timeframe. If you're that hands-on problem solver with a keen eye for detail, you could be just what this project needs. *Some of the sub-application the softwar...