Vba parsing csvmunkák

Tecdoc adatok alapján szeretném összefűzni 6 nagyker készletét és árait. A legjobb árat és elérhető készletet egy CSV ben szeretném megkapni napi frissítéssel.

SAP-bol auto-exportalt xls adatfajlokhoz kellene vba makrokat szerkeszteni melyek szinten automatizaltan lennenek futtatva. Mintafajl mukodo makroval rendelkezesre all egy bizonyos celra mar, a metodustendszert kell duplikalni mas adatokra. Szoval nem nullarol kell kitlalnod az egeszet. Nem kell durvan erteni a makrok irasahoz. ha record funkcioval, es belenyulkalassal eligazodsz, az mar eleg lehet - en is igy irtam az eddigieket. ~Muveletek: fajlok nyitasa, mentese, zarasa, munkalapok valtasa, kepletezes, ezek lehuzasa, filter, adattipusok es stilus formazasa, vlookup xls fajlok kozott, chart frissites. Ennel sokkal bonyolultabb dolgokkal nem kell nagyon számolni. 4 fo elemunk van: 1, adatfajl letrehozasa es formazasa friss sap adatexport alapjan, kepletezes, osszegzes 2...

Hello, egy Woocomerce webshopról kellenének a termékinfók CSV-ben. Összesen kb 600-800 termék, 9 főkategóriából. Elég sürgős lenne! Köszönöm

Adott egy FÉLKÉSZ Access DB-re ültetett Excel VBA ügyfél nyilvántartó, projektkövető rendszer. A cégünk mérőeszköz kereskedéssel foglalkozik, 10-15 beszállítóval, 2-300 partnerrel és 2-3000 ügyféllel dolgozunk. Professzionális Access és VBA tudással rendelkező szakit keresünk, Magyarországon.

Nyomtató által létrehozott csv / vagy xml. fájlból kellene automatikus kimutatást készíteni. A csv-ben szereplő adatokból a "Media" tipusokat paraméterezni kell beviteli mezőben megadott árral. Az "ink" úgyszintén paraméterezendő az árral. Tervezett kb végeredmény a pdf-ben.

Kedves Attila, Érdeklődnék, hogy van-e szabad kapacitásod egy viszonylag egyszerűbb munka elvégzéséhez? Shopify - összekötésre lenne szükségem, de nem az app-store-ban található alkalmazás segítségével. Szeretném az exportált Shopify rendelés adatokat a tömeges számlázójába feltölteni csv formátumban. És az xls-ből csv-be konvertálást szeretném tömegesen elvégezni. Remélem érthető, ahogy leírtam! :) A projektjeim között megtalálod, mire is van szükségem! Üdv, Péter

Jelenleg wix weblapszerkesztővel dolgozunk, szeretnénk az oldalunkat összekötni az árukeresővel és árgéppel és szükségünk van a csv és xml fájlra, amelyet egy szerverre fel lehet tölteni, majd az URL-jét elküldhetjük a szolgáltatónak. Ezen az URL-en keresztül töltik be minden nap az adatokat. Az lenne a jó megoldás ha ezt a wixen belül meg tudnánk oldani.

Adott formátumú adatfile-ok átalakítása kívánt formátumra. Napi rendszerességel, e-mail formájában kapunk adatfile-okat. ezeket kellene egy kód automatikusan megnyitni, a mellékletet megnyitni, lementeni a fileban található információk alapján megfelelő ügyfél mappába, majd a tart...található információk alapján megfelelő ügyfél mappába, majd a tartalmát átalaítani, más néven lementeni, majd egy ftp szerverre feltölteni. Nagyságrendileg 8 különböző file template van, ezeket egységes formátummá kellene átal...

Egy 45 fős online poker stable tulajdonosa/oktatója vagyok. A játékot a piosolver nevű program segítségével elemezzük, amiből ki tudunk nyerni csv fájlokat. Ezt excellel elkezdtük feldolgozni, de akivel elkezdtem a munkát már nem ér rá, ennek a befejezésében szeretnék segítséget kérni. Illetve felmerült egy probléma, hogy az excel csak 1 millió sort tud kezelni, ezt is szeretném megoldani.

Kedves Sándor! Schemadovits Norbert vagyok, Thaiföldön élek, és a weboldalamon szeretném megjeleníteni az itteni aktuális időjárást. A rendszer már ki is van építve hozzá időjárási műszerrel ami egy számítógépen keresztül feltölti az adott fájlt a helyi szerverre .CSV formátumban amiből mindig az utolsó sort kéne kiírni a weboldalra. Ez a rendszer már működött is egyszer csak az a szerver amin az átjátszó fájl volt található és a .CSV fájlból kiolvasta az utolsó sort megszűnt. A kódsor megvan nekem is, de ...

...megbízhatóság, átláthatóság érdekében úgy látjuk célszerűnek kialakítani, hogy a forráskód a felhasználó számára látható legyen (ezért gondoltunk a Python-ra). A felhasználó itt tipikusan IT vagy adatelemző szakértő lesz. A program felhasználói (ablakokkal) felülettel rendelkezik. A program funkciói: 1. Fájl beolvasása Fájl kiválasztása (txt, csv) (később xml, Json egyelőre ez most nem a feladat része) elválasztójel definiálása (text, csv esetén egy checkbox listából pl....

Szia! Van szabad kapacitásod? Lenne egy sürgős munka, aminek lényege az, hogy egy meglévő VBA kódot kellene módosítani az elképzeléseimnek megfelelően. Kérlek jelezz vissza, ha érdekel és akkor mondom a részleteket! Üdv, Pisti

Szia CodeAmbassador, az oldalnál használt csv típusú termék behívófájl írására van szükségünk egy nemrég indult nemzetközi designer weboldalhoz. Tudnál benne "gyorsan" segíteni? Remélem igen..:) Részleteket, árat egyeztessünk majd. Válaszodat várnám, üdv! Váradi Melinda

- nagykereskedő weboldalára automatikus belépés után árlista/készlet információ letöltése ( tömörített file XLS vagy csv formátumban) - a fenit xls feldolgozása, mysql be való feltöltése, megadott paraméterek alapján - aloldal létrehozása, ahol viszonteladó meg tudja feleltetni nagykereskedő árlistában szereplő cikkszámokat a saját cikkszámaival ) tömeges feltöltési lehetőség csv ből - aloldal létrehozása, ahol gyártónként meghatározható a haszon % ami a következő pontban felhasználásra kerül ...

Egy meglévő weboldalról egy php kód csv adatokoat exportál az oldal számára. ebbe kell két plusz oszlopot létrehozni, hogy az exportnál a csv-ben már ez is szerepeljen. Elméletileg egy rövid, kis munka

1) Üzleti folyamat specifikáció alapján és a kész termékre vonatkozó elvárások megértését követően az alkalmazás Excel frontend és funkcionalitások tervezése. A megrendelő és a fejlesztő közösen alakítja ki a koncepciót. Becsült munkaóra (BMó): 40 2) A működési koncepció implementálása Excel/VBA/.NET VB környezetek felhasználásával. BMó: 60 3) Fejlesztői kód dokumentáció. BMó: 20 4) Teszt esetek kidolgozása a megrendelővel közösen, azok végrehajtása, dokumentálása. BMó...

Termék katalógus oldalt szeretnék létrehozni kép- és videógalériával egyedi mezőkkel. AJAX keresés és szűrés szintén kell. Valamint egy árösszehasonlitó modul amiben a termékek forgalmazóitól kapott árakat (CSV vagy XML) jeleniti meg a termék adatlapján.

I'm seeking an experienced data extraction specialist to scrape both HTML and text files for specific data. Particulars to look for will ...scrape both HTML and text files for specific data. Particulars to look for will involve the text content within these files that follows a mixed format structure so would require vast knowledge and understanding of both table format data and paragraph-style data. Key Skills and Experience Required: - Strong abilities in web scraping - Adept with HTML, text parsing - Knowledge of data formats and how to transform data - Proficient in CSV file generation. We need a comprehensive extraction that maintains the integrity and accuracy of the data. As these files do come in multiple formats, versatility and attention to detail are para...

I need a Python program to parse a JSON file and format it correctly to be JSON compliant. Key Requirements: - Input Data: The input data is in JSON format. - Output Data: The JSON output should be properly formatted and adhere to a specific schema or structure. Skills and Experience Required: - Proficiency in Python programming. - Strong understanding of JSON parsing and formatting. - Experience in adhering to specific JSON schemas or structures. Please let me know your experience in similar projects and any relevant information that would make you a strong candidate for this job. You will pass the name of the input file as an argument and the output file should be the same file name with the .output extension. The input file is attached. Pay attention to the backslashes (&...

I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis or visualization. A high level of accuracy and ef...

I need an experienced VB.net programmer to make modifications to existing source code. The project itself should include feature demonstration forms. Key Responsibilities: - Modify existing source code: T...adjustments, and ensuring the software continues to function as expected. - Demonstration forms: The project includes creating feature demonstration forms for the software. Ideal Skills and Experience: - Proficient in VB.net: The candidate should have a strong background in VB.net, with practical experience in modifying and building upon existing code for file IO, object generation and file parsing for data output. - User Interface Development: While the project involves existing source code, a good understanding of UI development will be beneficial for the feature demonstrat...

Request details FOR EXPERTS WITH EXTENSIVE EXPERIENCE IN THE FIELD ONLY Objective: Scoring Algorithm for evaluating potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing values, nor... logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g., accuracy, precision, recall, F1 score, ROC-AUC) • Score Calculation and thresholds • Deployment and Monitoring Tools available: • In use: Microsoft Fabric and Excel (VBA) • Potenti...

I need a bash script that can import and export data from my database to CSV files. Ideal candidate should be able to: - Create a bash script that can effectively import and export data - Have experience working with database management systems such as MySQL, PostgreSQL, or MongoDB - Ensure that the script securely creates user accounts and manages their access to the database. The script will be used for daily database management tasks, so it needs to be reliable, secure, and efficient.

I'm looking for a seasoned Python developer who can assist in two main areas: - Creation of PowerPoint presentation using a CSV data file - Automate the process via a public URL to upload the CSM file Creation of Powerpoint Presentation The CSV file will feature data-points in columns. A powerpoint presentation template will be provided for reference. The graphs and tables should be present as per the data-points present in CSV file. Automating the Process This is the secondary part of the job. Once we have are successfully able to convert a CSV data in PPT format, we should create a public secured link to upload the file. It should be auto-converted and file should be ready for download. The ideal candidate should be a proficient Python Developer wit...

I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.

I need a tool that extracts specific content (text and images) from PDF files and adds this data into a CSV file under designated headers. Key Requirements: - The tool should be designed specifically for Windows OS. PDF Data Extraction: - Need the tool to extract both text and images from the PDFs. CSV Insertion: - The extracted data should be sorted correctly under their respective column headers in a CSV file. Consistent PDF Structure: - It is important that the tool can handle data extraction from PDFs with a consistent structure. Ideal Skills and Experience: - Proficiency in developing Windows-based tools. - Experience with PDF data extraction. - Familiarity with CSV file manipulation in Python or related languages.

I'm looking for a skilled software developer to create a Windows-compatible software application. This software should be specifically tailored to help my sales team improve their performance and to...Windows. - Integration: There's no need for the software to be integrated with any existing systems, so you can focus solely on creating the best software for our sales team. - Data Input: The software should have the capability to import data from Excel/CSV files. This method will facilitate the input of sales data and make the software more user-friendly for our team. Ideal Skills and Experience: - Proficient in Windows software development. - Experience in creating software for sales teams or incentive calculation. - Familiarity with Excel/CSV data import for softw...

I'm looking for a capable developer to help me reorganize the layout of phpMyAdmin by utilizing CSS. Key responsibilities: - Rearrange the layout of the phpMyAdmin interface to suit my preferences and needs & upload CSV file. Ideal skills and experience: - Proficiency in PHP and CSS - Experience with phpMyAdmin or similar database management systems - An eye for design and user experience - Ability to understand and implement user requirements into the interface

As a business owner, I'm looking for a competent Xero data entry specialist to handle my bank transactions. Key Responsibilities: - Transferring bank transaction data from the exported CSV file into Xero - Correct categorization of all transactions as per Xero's standard chart of accounts Ideal Skills: - Proven experience with Xero and bank transaction data entry - Knowledge of Xero's standard chart of accounts - Attention to detail and accuracy in data entry - Good communication skills to clarify any uncertainties Please provide your relevant experience and availability for this task.

I am looking for an expert in Python programming to assist me in the creation of a multi-timeframe indicator merge. The project entails the merger of the 4hr, 1hr, 15min, and 5 min timeframes while including specific indicators, namely Moving Average, Relative Strength Index (RSI), ADX, and Webslingers. To make info... To make informed bids, it's important to note the following: Ideal Skills & Experience: - Extensive knowledge in Python programming - Proven experience in financial analytics - Expertise in working with listed indicators Project Requirements: - Code the multiple timeframes using Python - Integrate the Moving Average, RSI, ADX, and Webslingers indicators - Generate the deliverable output as a CSV file Please feel free to inquire if you need more clarificat...

I'm in need of a proficient developer to create a comprehensive computer (in a network) probe software compatible with Windows and Linux. The software should have the following key features: 1. find systems in a network and log details to a CSV file/db table. hostname, ip addresses , mac address etc along with hard disks ,os,version etc. 2. find applications installed in the computers Ideal Skills & Experience: - Prior experience in developing network monitoring and security auditing software. - Proficiency in programming languages suitable for cross-platform development. - Strong understanding of network protocols and security standards. - Experience with compliance monitoring tools and techniques would be an added advantage. Please include re...

I'm in urgent need of a detail-oriented freelancer who can assist me with enriching the data in a CSV file. This file contains information on over 6000 Fast-Moving Consumer Goods (FMCG) products, including product titles and barcodes. Key Tasks: - Go through the CSV file: Identify each product's title and barcode. - Search for the product image online: Using the product title or barcode, find a suitable image of the product. - Download the image: Save the image to your local system. - Organize the images in folders: Each image should be saved in a folder named after the product category. - Rename the image files: Each image should be renamed to match the product’s barcode with a .png/.jpg/.jpeg extension (e.g., ). Ideal Candidate: - Proficient in data analy...

I'm looking for an experienced Python coder to tackle two key aspects of my project - data analysis and automation. Here's a breakdown of the requirements: - **Data Analysis**: The primary task involves analyzing datasets in CSV format. The selected candidate should be adept with NumPy, able to make sense of the data and derive meaningful insights. - **Automation**: The second crucial aspect is automation. I'm looking to automate certain processes in my project that involve database queries. Proficiency in Django will be necessary here. Ideal candidates for this project would have: - **Strong Python Skills**: You should be well-versed with working on data analysis and automation tasks using Python. - **Experience with NumPy & Django**: Proficiency in these fra...

...creation and editing of digital job cards. There is also a requirement for quotes, parts / inventory, archived jobs, and customer management. Both employees and managers will need access to the system, with an admin login section for authorization of completed job cards. We would like the system to export completed jobs to CSV file for automated invoice generation in Quickbooks Online. We will also require the system to import the customer database from Quickbooks in CSV format. Key Functionalities: - Creation and Editing of Jobs - Ability to use system on-site / remotely through the use of iOS or Android web browsing. Some - Ability to select a simple job status from a drop-down combo box eg. In-progress, waiting for collection, waiting on parts, not started, complete...

Develop macro-enabled Excel file to handle CSV

Ho bisogno di un programma che mi permetta di aggiornare disponibilità e prezzo di vendita dei prodotti presenti nello store shopify partendo da un file excel/csv che viene generato automaticamente ogni x ore e viene esportato dal getionale su cartella FTP

I am in need of a Python expert, specializing in web scraping. I require someone who can proficiently extract data from various websites. The specifics of the data may vary fr...information. Your key responsibilities will include: - Writing effective and efficient Python scripts to scrape data - Ensuring the data is extracted accurately and in a structured format - Delivering the data in a timely manner The ideal candidate should have: - Proficient experience in Python and web scraping - A strong understanding of data extraction techniques - Proven experience in handling and parsing a variety of data types - Excellent communication skills and the ability to meet deadlines Please be prepared to provide examples of your previous work in web scraping. Looking forward to working...

...sheets for doctors' information and disease descriptions. Requirements: Programming Language: Preferably Python. Libraries: Experience with web scraping libraries like BeautifulSoup, Selenium, and data processing libraries like Pandas. Output Format: Ability to export data into an Excel file using Pandas or similar libraries. Error Handling: Robust error handling to manage failed requests and parsing errors. Compliance: Adherence to the websites' terms of service and rate limits to avoid being blocked. Project Scope: Input: A list of CRM numbers and a list of CID numbers. Process: Automate the lookup and data extraction process. Output: An Excel file with the compiled data. Skills Required: Web Scraping Python Programming Data Processing Automation Excel File Generati...

I'm looking for a skilled professional who can migrate an existing voicemail manager system from Google Script (Javascript) to Office365. The primary purpose of this migration is to rebuild the system on a completely different platform. Key Requirements: - Proficient in Google Script (Javascript) - Familia...intricacies of voicemail manager systems. The project's success will depend on the freelancer's ability to effectively transfer the existing system's functionalities to the new platform. The system must be rebuilt using Javascript, ensuring compatibility with the desired platform: Office365. I also need help to complete previous project. Help with the following: 1. Batch file to merge Ruckus csv files instead of overwriting. 2. Batch file to find missi...

...- Extract PDFs based on dates within the PDF text: The PDFs should be saved based on a specific criterion - dates within the PDF text. Your role will be to parse these dates and save the files in a designated folder on my computer. Skills and Experience: - Proficiency in Outlook: A deep understanding of Outlook's email management functionalities is a must for this project. - PDF Parsing: Experience with parsing text within PDFs is essential. - Automation: The ability to create a script or use a tool that can automate the process of saving the PDFs according to the specified criteria. - Efficiency: The project needs to be completed urgently, so the ideal candidate should be able to work swiftly without compromising on quality. If you're confident in your skill...

Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 300 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowled...

Hello, I need convert a PDF invoice to Excel to import to our invoices software

I have a Python notebook containing well-structured code that effectively translates a sample of a large dataset from English to Arabic. However, the current code cannot handle the entire dataset due to its size. using : model_name = 'Helsinki-NLP/opus-mt-en-ar' Tasks: - Modify the existing Python code in t...sample of a large dataset from English to Arabic. However, the current code cannot handle the entire dataset due to its size. using : model_name = 'Helsinki-NLP/opus-mt-en-ar' Tasks: - Modify the existing Python code in the provided notebook to translate the entire dataset from English to Arabic. - Ensure the translated data is saved in two formats: Comma-Separated Values (CSV), and Apache Parquet (.parquet) - Provide the CSV and parquet files aft...

I'm in search of an Excel expert who can assist me with complex tasks in Excel. Specifically, help is needed in two key areas: - Formulas & Functions: While basic arithmetic operations are simple for me, I need assistance with text and date functions. - VBA Macros: I'm looking for someone who can develop advanced user forms and interfaces. This requires a high level of VBA expertise. The ideal candidate would have a strong background in Excel, with a focus on formulas, functions, and VBA. Previous experience working on advanced macros and a deep understanding of text and date functions will be a huge plus. The ability to communicate effectively and understand my specific needs is essential.

I desire a professional Macrodroid developer with a strong portfolio to create a macro for any use. The objective of the macro is to read a CSV file and automatically send a specific WhatsApp message to each phone number listed in the file. Key requirements include: - import a CSV file (Name,Given Name,Additional Name,Family Name,Phone 1 - Type,Phone 1 - Value) - Creation of a macro that automatically triggers WhatsApp messages. - The macro should be programmed to initiate the messages when it reaches a phone number listed in the CSV file. - The message is from CSV or default the same for all numbers in the CSV file. Ideal Candidate: - Proficiency and extensive experience working with Macrodroid. - A proven track record with similar projects. - Strong...

What we have -------------------------- 1: Excel or CSV file. containing addresses to post letters 2: Letter Quality ( Paper weight, Sizes, Cost per letter etc configuration in JSON array) What we need -------------------- - Standalone PHP Script where we will be able to select an item from provided JSON. - Through DHL API we will validate the provided addresses(in the form of exel or csv) if each individual address is valid - or we should be able to select the areas of over choice over google map is shown in the provided video - this funcationaly is also provided over DHL api I think. and there demographic filters can also be applied which are provided be DHL api also shown in the video Please apply only if you the the required experience. these links may help

I am looking for a web-scraping expert to retrieve both images and text from a specific website for research purposes. The text data will need to be structured and saved in a CSV file, including paths to saved images. Key details to consider: - Knowledge of web scraping tools and techniques is essential to accomplish this task. - Quality control to ensure accurate data extraction and image quality is critical. - Structure page information and freeform descriptions should be made available in a CSV file. - The images should be saved in their original resolution and quality settings. Please provide any relevant experience you have in web scraping, including free and paid services you have used before to help with your work. I would like the project to be completed in the n...

...different dsp sites like Spotify, Beatport, Apple Music, etc and receive music from our industry partners. With functionalities where the user can upload any format of track file like mp3, wav, flac so that it can be encoded into different formats and can be distributed to different dsp sites depending upon required formats. The administrator can upload the royalty files in different formats like xls, csv, txt. provided by dsp sites and calculate the revenues for the artists and label user’s earned by their distributed albums. The encoded tracks need to be stored on cloud storages like amazon S3. The assets can be download from amazon s3 when ever required for distribution. The platform needs a: Distribution software with Release Creation System Catalog management Content ...

I'm looking for a data entry specialist to assist me with entering a mix of numeric, textual and formula-based data into a spreadsheet. The data will be provided in digital format, typically in CSV or Excel files. Key Responsibilities: - Accurately transcribing a mix of text, numbers, and formulas into a spreadsheet - Ensuring that the data is organized and categorized correctly - Delivering the completed spreadsheet on time, following provided guidelines Ideal Candidate: - Proficient in data entry with experience in handling diverse types of data - Familiarity with Excel and basic formulas - Detail-oriented and capable of consistently delivering accurate work - Able to work independently with minimal oversight If you have the required skills and are committed to high-quali...

Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.