Parse xls jobs
I am creating a workflow in my CRM that requires some code to parse an incoming email. Attached is the documentation for the CRM. I want someone to write the code to properly parse the incoming emails that meet the subject that I am looking for.
1. Parse a SQL-like syntax from input 2. Modify the syntax based on certain logic 3. Test the SQL through azure API 4. Generate a flask UI page similar as: , where user can paste the data on left side, and see result on the right side
write python software using selenium to parse website
I need an apps for Nextcloud to show watermark within document with following condition: 1. If the file share to public and download, watermark will show downloaded IP Public 2. If the file share to internal download, watermark will show username who download the file Watermark will apply to PDF and office document such as: doc, docx, xls, xlsx, ppt, pptx. You must familiar with Nextcloud and have your own Nextcloud installation.
Need immediate assistance to perform Regression Analysis in Excel. to find >> b Coefficient >> Predict Allocation Next Period Scope = 5 questions from the same dataset (January to December | 22 variables)
We have an API URL need to pull data from that URL, parse the JSONP and filtering in the same page
Needing to convert a downloaded .xls excel sheet into another sheet with formulas and formatting included. At most the download would 200 rolls and 10 columns.
The website is a private LMS for an event...subscribers) based on Master Study LMS plugin and MasterStudy template I need to develop a plugin aim to export the following 1 ** Export the quiz results >> The Idea | The admin goes to plugin tap and selects the "Export Quiz Result" the select the quiz name or course name then export it as CSV and XLS if it's possible 2 ** Export the Gradebook results >> The Idea | The admin goes to plugin tap and selects the "Export Quiz Gradebook " the select the course name then export it as CSV and XLS if it's possible, or in the same quiz results file 3- allow adding a timetable option to the quizzes so student can only enter the quizz during date x to z only apply of you're okay with the ...
... Lighthouse and Google PageSpeed Insights starts to flag pages if any of the following conditions are met: Have more than 1,500 nodes in total. Have a depth greater than 32 nodes. Have a parent node with more than 60 child nodes. How DOM Size Impact Performance? Excessive DOM size can impact performance in different ways. Higher parse and render time (FCP) – A large DOM tree and complicated styles rules make a huge work for the browser. The browser has to parse the HTML, construct render tree etc. Every time user interacts or something in HTML changes, the browser has to compute this again. Increases memory usage – Your JavaScript code might have functions to access DOM elements. A larger DOM tree causes JavaScript to use higher memory to process these. An ex...
...perform a crawling;scrapping job in a particular website. It~s a portal containing doctors with many different expertises such as dermatologists, Dentists, Cardiologists, etc...it~s about 12 different class of expertises , each speciality with a page and each page with 20 differen tprofessionals and the number of pages per speciality may vary from 1 to 10 in average. We expect to receive a microsoft XLS file containing structured data, invcluding the URL of the profile picture. Also, for each professional listed, we need to get all the data inside, except the agendaand the comments - Only personal and professional related data. More info about the target data, please get in touch via chat. We expect to receive a sample of the work containing 3 records so we can evaluate the...
Building an app with drag & drop capabilities, an efficient UI, xls loads and pdf reports. The project has started and the technology stack is confirmed.
Hello web scraping experts, I need your help to download the campaign/project pages from Kickstarter.com. I already have a number of URLs (around 150,000) for the campaign pages we want to download. Mainly I just want to the webpages downloaded as local html files, so I can parse out the necessary information later (you can help me on this too, as a second, separate task request). For example, given a campaign page URL (), I need the whole webpage saved as local HTML file, so detailed campaign content displayed on webpage such as campaign story, risk, environmental commitments, and other information can be parsed out locally. The task seems simple, it only requests webpages to be downloaded as local HTML files. The reason I need your help
To write a python code to parse data using AI
We have a big excel mailing list. Columns for name, address, address 2, city, state, zip (postal), country, etc. My issue is this: right now we are spending too much time formatting the postal code cells by country. Different settings for all these countries for formats. Would be interested in a solution for this to automa... state, zip (postal), country, etc. My issue is this: right now we are spending too much time formatting the postal code cells by country. Different settings for all these countries for formats. Would be interested in a solution for this to automate it a bit more, perhaps checking the countries and then auto-formatting the postal code to necessary parameters, or something similar. We are not XLS experts so this must be easy to use and work in a Windows env...
Write PHP function to replace two placeholders fields like [keyword] in MySQL table with real data from xls connecting by product_id.
See attached image for full explanation. I need this done ASAP so please bid on this project early if interested. Uses:
We want you to parse through ~30 pdf files of variable sizes(~150 pages each) and convert them to structured excel files as per the instructions in the attached video. We can also convert the pdf files to word files.
Hi I need you to scrape a directory and create a xls file of it.
...run on demand and we should also support a simple command line that will also execute this immediately. lets assume for a minute just windows desktop folder. I want to run this exe and then it will sort all of the files on the desktop to folders. For example all of the images will go to a folder called IMAGEs. all of the spreadsheets will go to a folder called EXCELs, which is file types, xlsx, xls, csv, tsv, xlsm. We should be able to manage all of the file type associates in a simple csv that looks like this -if the extension is not in this csv then we leave it as is. -if the file is in use we should leave it alone and not try to use shadow copy etc.. now for the config of where to run
Project Budget: $100 Project Deadline: 1 Day Scrape Output: Excel XLS & CSV Overview: Scrape all listing from the following URL - Data Export Columns: # - (Auto Increment Number) Make Model Year Rating # Trips Price (GBP) URL 5* FEEDBACK WILL BE LEFT FOR YOU
I want a script to execute from the google sheet menu and parse all the current sheet to add a blank row when two consecutive words on a specific column cell are different. Need to start after row #4 and remove all the blank row
I need to parse data contained in a list of XML files contained in a folder. The XML structure is littlebit different between files but relevant data can be indexed with an ID (a timestamp) in the file so upi can use it as the key of array and avoid duplicates. Simply data blocks like this: <Start>2022/07/04 09:05:44</Start> <Name>C:EvolProductLSX</Name> <Program ID="20220704070548" L="2090.00" H="600.00" T="68.00" ListIndex="1"> <Start>2022/07/04 09:05:48</Start> <Name>C:EVOL4 ANUBATELAIO PORTE </Name> <End>2022/07/04 09:06:51</End> </Program> <End>2022/07/04 09:06:51</End> Have to be saved in an array like this $arra = arra...
i need a small program to be done with 2 row - on the 1st row there will be a "select file" button so i can select a xls file - on the 2nd row there will be a textarea where to enter javascript code to run with a "start" button, so when clicked it'll run the javascript code on the file selected and create a new file with same filename with "_1" to appear at the end of the new file // i can send you some sample javascript code you can use for testing
I need an xls spread sheet that will help me to determine the distance between two zip codes. I have it mostly built but I need support.
I have 30 or so schedules that were given to me in PDF format. I have converted them to Excel but I need help uploading them into P6 so I can have the schedules in .XER format. I would like whoever is doing this to try and match the PDF schedule format in P6 as much as possible. We received three formats of schedule throughout our project. I uploaded snippets of the column headers. Dark blue header: around 5 schedules Light blue header: one schedule Yellow header: 20 or so schedules (for this one, I received one file in XER format, so if this helps match formats when you do the conversion, I can send this XER to you as well)
...should have the following capabilities: the smartwatch FW via Bluetooth -> Retrieve firmware files from cloud server -> Upgrade smartwatch firmware via Bluetooth Low Energy -> Update cloud database with FW update information data from the smartwatch via Bluetooth API Protocol and upload it to the database -> Retrieve smartwatch fitness data via Bluetooth API GET commands -> Parse the data into human-readable format -> Upload data to cloud database the time on the smartwatch using current time on mobile phone -> Retrieve mobile phone current time and timezone -> Update smartwatch time via Bluetooth API commands Deliverables -Working Android & iOS Mobile App -Codebase on Github -Proper documentation of the app -Usable dashboard on AppSmith or equi...
This project is to take CDR data from FreePBX/PBXact in the form of a CSV and parse and upload to a Air Table Base with 3 Tabs see For the time being I would extract the CSV file from the BPX to upload. Use a tool like n8n to automate the project or suggest something else Write your experience with dealing with CDR/CEL data. I'm including a Link that contain a Word Doc and an Excel File that mimics the Air Table Base and clarify this project Include the word BlueMagic in your proposal List the tools you would use and don't bid over $550 for this project
I have files(.csv,.xls) in remote server which are generated daily, I need to download them daily and upload them into my googledrive daily. Based on the performance or quality, we can work for long term. This job should be done quickly. If you have any question, please feel free to ask, I am also technical guy who can understand your concerns and help accordingly.
I want to transfer Excel file (.xls or xlsx) from my local pc folder as it is to a specific Google Sheet file. It should only two inputs. 1) Excel file name with path. eg D:ProjectAbc.xls. 2) Google Sheet Id.
Background - We are qualifying several contacts using a linkedin scaper tool, wich generate a file generally on a monthly base (ATT1) - This file need to be processed using (ATT2) in order to be entered in crm - After processing sys need to return an output named (ATT3) Features and steps The process will consist of the following steps: - Look in the current Master table and add new records (rows import) only if the following conditions are met: o The member_id D is not already present -if already present return an error message put in a new spreadsheet o The email L is not already present -if already present return an error message put in a new spreadsheet o If there are fields (rows) with same name N and surname O highlight the mas potential double entries or homonyms - Add new c...
I need to be able to parse large xml files in my api. My current process bombs if the file is over 40 meg. I see references to DOM object and simplexml in the code - I can't manually split files before running conversions. Need to do it at a button press. Below is a portion of the code. The code works fine for smaller than 40m. Can it be changed to Stax or another parser that works with larger files. $csv_handler = fopen ('downloads_convert/' . basename($filename, ".".$ext) . "", 'w'); $l = 1 ; foreach($rline as $rlineech) { $domObject = new DOMDocument(); $domObject->loadXML($rlineech); $domXPATH = new DOMXPath($domObject); $sresults = $domXPATH->query("//soap/*"); // print_r($sresults); foreach($sre...
Hello, Since I found that there are many people who can do this I changed the project a little. Attached are 2 PDF documents which cont...there are many people who can do this I changed the project a little. Attached are 2 PDF documents which contain a table with some technical information in it. I need this file to be converted to a plain text XLS spreadsheets with 6 columns (n50Hz,.M2, fb, i, 1 &2) - marked with green and red on the photo attached The column marked with red should be separated in 2 columns (marked as "1" & "2") All other columns should be skipped. 1. Each row from the PDF should be created as a separate row in the XLS 2. Each column in the PDF should be created as a separate column in the XLS 3. The XLS shou...
I need someone to write an CLI tools to automate monitor creation on Datadog 1. Generate a JSON file from Monitor 2. Parse the JSON files 3. Create Monitor by changing some parameters based on parsed JSON
Hi I want a html file that uses javascript where I can upload a xls and it will then sort it as shown in the example and give me the sorted xls file. in the example sheet page 1 is the format of the orginal xls and sheet page 2 is the desired out put. Send a message asking for the xls and I will send it. Need someone who can do it quickly.
We have integration between an online platform and Magento 2, when this platform consumes the Magento API, the process returns the following error. Failed to download products from Magento channel. Error: Cannot get quantity info for next 1500 - 1800 products (Label Test DEV). Error:Could not parse response. Content: {"message":"One or more input exceptions have occurred. ","errors":[{"message":" "%fieldName" is required. Enter and try again.", "parameters":{"fieldName":"scopeId"}}, {"message":""%fieldName" is required. Enter and try again.","parameters": {"fieldName":"qty"}}]} I need to identify which records they are cau...
I have website with all the "Otmans" in this link you can see results number 10303 I need all the Otman in a csvxls - you can use phppython I also have a working php code to download those but my code only finds 7749 and the website tells there are total of 10303 can you Help me get all the Otmans? P.S the first 50 rows of Otman in my code are downloaded separately
...for access/upload/deletion, time of upservice, users/groups (1 group----> n users), logo, ... Admin no access to the application (file upload and management) but only environment configuration. Full details (images, user experiences, ...) after project assignment. Users side (using front-end layout), he can: - file upload (using drag & drop too) to server repository. Every type of file (.jpg, .xls, .doc, .dwg, ...); - file and directory browse (server repository) [something like "File explorer" of windows]; - download a file/directory. Download directory could be in .zip mode; - rename a file/directory; - check the differences between the contents of two directories (f.e. the file exists here and not there); - delete a file/directory (multiple selection). Ful...
Hi I want some php code that allows me to upload a xls with colum 1 = order numbers and colum 2 = tracking numbers. It will then get the order number and add meta to the order called trackinnumbers + tracking number from colum 2
Hi I want a html file that uses javascript where I can upload a xls and it will then sort it as shown in the example and give me the sorted xls file. in the example sheet page 1 is the format of the orginal xls and sheet page 2 is the desired out put. Send a message asking for the xls and I will send it. Need someone who can do it quickly.
Hello, Since I found that there are many people who can do this I changed the project a little. Attached are 2 PDF documents which cont...there are many people who can do this I changed the project a little. Attached are 2 PDF documents which contain a table with some technical information in it. I need this file to be converted to a plain text XLS spreadsheets with 6 columns (n50Hz,.M2, fb, i, 1 &2) - marked with green and red on the photo attached The column marked with red should be separated in 2 columns (marked as "1" & "2") All other columns should be skipped. 1. Each row from the PDF should be created as a separate row in the XLS 2. Each column in the PDF should be created as a separate column in the XLS 3. The XLS shou...
I need a simple bash script that parses a log file and joins/combines multiple lines into a single line based on the same transaction ID.
Hello, We are looking to send 50,000 to 100,000 or more Ringless Voicemails per month for various campaigns. We need a platform or a system that is very easy to use - a simple upload of audio file in either wav or mp3 files and contact list in either XLS or CSV files. Ideally, we would like to control the number of messages per hour or per minute. Ideally, we would like to control the times of day that the messages go out. Ideally, we would like to send a trial of 1,000 messages to test your system. Ideally, we would like to be able to reach both cell phones and landline numbers. Please quote the price by cents per successful message left. When leaving a bid, please let us know if we are able to throttle the number of messages per minute or per hour. When leaving a bid, ple...
Need the following points to be considered in rewriting the resume: -Using bullets to highlight pertinent information -Avoid passive words and use action verbs -Replace overused and monotonic words -Re-write the text to get the resume as achiever-oriented profile rather than, just a doer. -Parse the final edition by an ATS applicant tracking system. And deliver the results of it with the resume.
I want a 3 step process. I have large zip files anywhere from 400mb to 1000mb that will need to be uploaded to our server. (iostream) Once it's been uploaded it will collapses the zip file in the same folder will all the pictures and cvs file. the cvs file will be uploaded to SQL . I want a 3 step process separated
Create a platform to send bulk sms using 's api 1. Bulksms & Single SMS 2. Contact Books 3. Reports(Sent, Failed, Pending) 4. Export & Import Contacts(in xls,csv format) 5. Show balance amount
...program to: 1) scrape the URL from "See other items" link found on most every Ebay item page. example: 2) from the URL, parse the string found after: ssn= example: quality_treasures2 goodwillsa 3) from the URL, parse the string found after: store_name= example: goodwillmiddletn goodwillsabooks 4) save the scraped strings output to the clipboard: ssn=,store_name= example: quality_treasures2,goodwillmiddletn goodwillsa,goodwillsabooks a) if a string is not found save to clipboard as "none" example: none,store_name
Hello, The website is a private LMS for ...subscribers) based on Master Study LMS plugin and MasterStudy template I need to develop a plugin aim to export the following 1 ** Export the quiz results >> The Idea | The admin goes to plugin tap and selects the "Export Quiz Result" the select the quiz name or course name then export it as CSV and XLS if it's possible 2 ** Export the Gradebook results >> The Idea | The admin goes to plugin tap and selects the "Export Quiz Gradebook " the select the course name then export it as CSV and XLS if it's possible, or in the same quiz results file 3- allow adding a timetable option to the quizzes so student can only enter the quizz during date x to z only apply of you're okay with the ...
function storeDocument(document, documentNumber) { // TODO implement } function performSearch(search) { // TODO implement } (); ("ascii"); let input = ""; ("data", function (chunk) { input += chunk; }); ("end", function () { // now we can read/parse input const lines = ('n'); let index = 0; const N = parseInt(lines[index++]); for (let i = 0; i < N; i++) { storeDocument(lines[index++], i) } const M = parseInt(lines[index++]); for (let j = 0; j < M; j++) { (performSearch(lines[index++])) } });
Freelancer Post Please scrape 2 websites and export to an XLS file. The website is the BBB.org. Please note that I need ALL the results from the list. There are 352 results. Freelancer Detail • Website is • The filters should be o Location: Dayton (can change on the page before clicking export) o Distance: <25 miles (can change on the page before clicking export) o BBB Accredited: True • We need to pull the following fields from BBB o Business Name o Address o Website o Phone Number o Years in Business o Owner Name Note: Check for duplicates • Next week we need to google each business name and add these fields o Google Rating o Google Reviews o Double Check the web address to make sure it’s the same o Double Check Phone Number To ensure that you...