...web designer who can make improvements to my existing website's design, update content, and enhance functionality. The site also needs a dedicated focal point for customer requests via chat. The candidate must know a wide range of design styles. The key factors of the website are intuitiveness, user-friendliness, and a modern outlook. The idea is for a continuative job relation not only for a delimited period. Ideal applicants should have: - Speak a mother tongue or fluent Italian - Comprehensive knowledge of web design principles - Relevant experience in improving website aesthetics - Proficiency in making functionality updates - Experience with integrating efficient chat systems on websites The emphasis has to be on quality work and feasibility, aprx 20h per...
I'm in need of an experienced C# software developer to complete a desktop application to load a CSV file (|-delimited) and allow the user to look up a customer based on a scanned barcode or entered number, and to display customer information in different fields. The user needs to be able to copy each field into the clipboard by just clicking on it. Requirement: * Need to be able to access a network drive and authenticate if necessary * Need to reload the data file (CSV file) if and only if it has changed since last time it was loaded (based on timestamp). * Need to load the file asynchronously while allowing the user to interact with the UI using the existing data. Once loading is done it needs to show a visual clue (maybe a spinning icon while loading) * When t...
I'm seeking a professional to convert a delimited (tab or comma separated) txt file into an excel (xls) file through an online portal.. The key aspects of the project include: - Maintaining the same order as the original txt file in the xls file - Special handling of certain data types is necessary, but to be discussed upon project engagement Prospects should have experience in handling different data types and expertise in converting txt files to xls. Strong attention to detail is also crucial to ensure data integrity. A background in data entry or previous experience with similar projects would be a bonus.
...PHP and MySQL to develop a system that will import a tab-delimited text file directly from a user's computer to MySQL. Key responsibilities include: - Create an interface for file selection and import to MySQL - Develop the system in PHP 8.3, having it capable of importing a tab-delimited text file - Database tables should be created from the file itself. The format of the file is as follows: The source file type is an Primavera XER file, renamed to txt file. The first row of data in the file is irrelevant, it can be skipped from there on each row starts with two characters. if the row start with %T it is the table name, if row data starts with %F it is the field names within that table, if it starts with %R it is the record data in that tabl...
...highly skilled freelancer to develop a comprehensive Powershell script capable of parsing both CSV and Excel file formats. This script is a crucial component of our data processing tasks, aimed at effectively managing and extracting specific data points from our datasets. **Requirements:** - The script must accommodate files containing two header rows plus a unique "header" column that precedes the data columns. - It should efficiently extract data, ensuring to handle the dual nature of the headers and the "header" column seamlessly across both CSV and Excel formats. - The goal is to parse these files to extract specific columns of data, entire rows based on certain conditions, and identify unique entries without duplicates—d...
The attached zip file contains 126 excel s...excel spreadsheet files with a total of less than 230 sheets. 13 of them contain 6 to 8 sheets and the rest are a single spreadsheet. Your job is to save every spreadsheet and every sheet within them as a Text Tab Delimited file. Include a spreadsheet that you create that contains the following columns: 1. Name of spreadsheet 2. Number of sheets 3. Name of 1st sheet. 4. Number of filled in rows in 1st sheet 5. Name of 2nd sheet if any. 6. Number of filled in rows in 2nd sheet if any. 7. Name of 3rd sheet if any. etc. How do you save an excel spreadsheet as a Text Tab Delimited file? When will you start on it and how long will you work on it if needed when you start? Will you send me what you have done so far as soon as you fin...
...freelancer who can effectively manipulate both text and Excel data for an important project. The project requires downloading approximately 260 online text files and combining all records to a master text file of approximately 3.5m records. Converting master text file to a master Excel template file with delimited fields. Simple sorting and deletions, Matching for duplicates with a second excel file and deleting non duplicates. The requirements are quite specific and require someone with a keen eye for detail and a strong background in data management. **Scope of Work:**file - The project involves handling both text and Excel data. - The main tasks include organizing and sorting the data. - After manipulation, the final data should be ...
As the client, I'm in need of a dependable and skilled Python developer to assist in creating a script to transfer my text data. The data is currently stored in a text file and is delimited (CSV, TSV). This project will entail: * Extracting data from its current storage location, a text file. * Data migration to a new platform using a Python script. Ideal Candidate: * Advanced proficiency in Python * Experience with data extraction * Understanding and experience in handling delimited (CSV, TSV) formats. Timely delivery will be appreciated, as it is crucial for my project's success.
...last project. 2-Grid feature: Option to retain the horizontal and vertical scroll bar position between reload. Just like the sort/filter etc in the last project. 3-Grid functionality: Edit mode of grid to be able to change values in cell and write it back to database table the query results. Have checkbox to enable on grid, as it should be ready in only first. 4-Merge 2 files data. These are tab delimited files. I need them to be merged so no duplicates. 2notes: a)-a duplicate could also be the left and right on either side. meaning, dog,cat is same as cat,dog. so only one should be there, not both. b)-there is a column for group number. this number should not have to match to b considered a duplicate, but all rows of the group need to be evaluated together to ...
I am looking for a freelancer who can help me convert a large comma delimited file to an Excel file. The file size is greater than 10MB. I do not require any specific formatting or data sorting in the Excel file, just a simple conversion. There is also no specific version requirement for the Excel file compatibility. Skills and experience required for this job: - Proficiency in converting comma delimited files to Excel - Knowledge of Excel file formats - Attention to detail to ensure accurate conversion - Ability to handle large file sizes efficiently
I need a freelancer to transfer data from a delimited (comma, tab, etc.) txt file to csv and pdf formats. The data does not need to be manipulated or transformed during the transfer, just a direct transfer is required. There is no preferred layout for the csv and pdf files, so a standard layout is fine. This needs to use a python script Ideal Skills and Experience: - Strong experience in working with data transfer and file conversion - Proficiency in handling delimited txt files and converting them to csv and pdf formats - Familiarity with standard layouts for csv and pdf files
I am looking for a freelancer who can help me with a data extraction project. Here are the details: Desired Format: - The initial format is a pipe delimited txt format. - This data need to be extracted and will then be worked and altered in excel before being converted back to a txt file. - The final product needs to be in a pipe delimited txt format which matches the exact format of the initial data file including spacing. Data File Size: - The data file that needs to be converted is less than 1GB. Data Fields: - I want to extract all the data from the file, so there are no specific fields to focus on. Skills and Experience: - Experience in data extraction and conversion. - Proficiency in working with txt and Excel...
...forum thread specified by the user. You can explore XenForo via their demo: -Retrieve all posts from the selected thread, capturing the username of the person who made each post. -Display the retrieved posts as plain text in the API Gateway response. Remove all HTML and image tags, except for quotes, which should be enclosed in square brackets. The output should be tab-delimited with usernames in the first column and corresponding post content in the second. -Users trigger the script by accessing an API Gateway URL in their web browser. The target thread will be specified via a GET variable that contains the thread's system ID number. -Store the XenForo forum's base URL in environment variables for easy configuration. -The script should only retrieve posts existing a...
I am looking for a winforms VB.NET applicaiton using DevExpress gridview to allow users to delete, reorder, and group data that is in a file. Attached is a sample of the data in the file. Initial Load: 1-All items = This means all items from the tab delimited file will be loaded to be edited. or 2-Filtered Items = There will be a textbox above the grid that the user can enter a name and filter to only rows that have that name (in either side-left or right). NOTES: Each row in the file, is a row in the grid. The grid is read only, user can not edit items. Functionality: Delete = The grid will have an additional column at the right end with a red x icon. When the user clicks this, it will delete the row. Reorder = The user will be able to click and drag the ...
...DevExpress gridview to allow users to pick which data to use from a file. Attached is a sample of the data in the file. Initial load: Mainform = I need a gridview (can be one column), with some or all of the names from in the file. Functionality: When the user clicks a name in the grid, it will popup a form with a grid that contains data from a file that matches the name the user clicked on. If there is no match, then nothing will happen. The data for the grid will be concate as: LEFT_NAME.LEFT_EXTENSION = RIGHT_NAME.RIGHT_EXTENSION The data needs to be initial sorted by ORDER column, then combined name. In the data file, if there are rows with a number in the group column, all the rows with the same group number need to be combined with c...
I would like a Windows 10 desktop application that does the following: 1. The user browses to a text file that contains lines that define how to find a JPEG to be created. 2. Each line consists of tab-delimited fields: a. Line Number (sequential) b. Path to an MP4 video file c. Frame Number or Time Hour:Minute:Second:Frame Number 3. The frame at that point in the MP4 file is copied to the same directory that contains the text file, with a name equal to the line number. 4. While this is happening the current line number is displayed and after it is processed it displays “ok” or an error message. 5. I will have a document that explains how to install and run it (as above) and the meanings of the error messages. 6. I have a trial period of time to test it with watermarks a...
...player's selected answer choice. ---The new DISPLAY SCREENS are intended for VIEWING ONLY by the players and audience and should be shown on the computer’s extended monitor. No game controls will be on this screen. This will require the user to have an extended monitor connected in order to properly run Easy Quiz PLUS. ---IMPORT capability must be provided to import questions/answers from a tab delimited file (sample attached). The correct answer to each question will be the FIRST shown in the list of multiple choice answers. ---The option to provide for graphics files or sound files as part of the question is also desirable. For graphic files, display the graphic at the same time as the text. For sound files, display the text but wait for operator action to play the...
...https://www.visitnsw.com. Only those in Port Stephens & Newcastle. The list of websites should be organized in a comma-delimited format. This means that each website should be separated by a comma, making it easy for me to import the list into a spreadsheet or database. For example; ,, etc etc Ideal skills and experience for this job include: - Website scraping skills to find relevant tourism-related websites in Port Stephens, Australia - Attention to detail to ensure that all 200 websites are included in the list fall under the accommodation and attractions categories - Proficiency in organizing data in a comma-delimited format I am looking for a freelancer who can complete this project efficiently and deliver the list of websites
Sql Query Parse Join Columns. I need a way to parse sql queries and build a list of used in the join criteria. 1-Needs to be able to paste text (queries) in a textbox or load from a file. They can be many stacked in one file. 2-It needs to extract the join criteria from the queries. 3-It needs to format in a tab delimited file. +Tabe delimited. +Schema and table name written out (not alias) and combined. 4-If there are more than 1 criteria between 2 tables (meaning joining on more than 1 column), they both need to be listed and have a unique group number associated (that does not exist in the output file). 5-If the join is between a nested query (a derived table), that join does not need to be included. Only table to table. 6-The output file can not have duplicates
Develop Summary tables: 1. Show both results in a single cell 2. Show only sub values 3. Show only hyp values 4. Total Subs & Total Hype (delimited by months)
...application users will simply scan a line or two of text. these need to go into a table in their appropriate columns (max 10 columns). sometimes these will have been written by hand and need to be captured also. A printed page with boxes/placeholders will be used for making manual entries. Users are expected to upload these scanned values to excel or CSV file export or any other comma or tab-delimited file. Approximately 100 such scans will be done in a day and may be done in succession throughout the day. Example of values: AA=1.22 BB=2.2 CC=3.3 DD=4.4 numbers can vary upto 20 or 25 , max 7 -10 columns. Excel sheet will have the preceding letters as column numbers, and only values need to be in the cells. after capture we should see each item and in case of dou...
1. Download all .TAB files from an FTP location. Example Attached as "" 2. Combine all data into one file. 3. Map data to new headers. (attached as ""). There is some data massage necessary. See notes in file highlighted in Blue. 4. Remove duplicates using 'order-item-id' as unique primary key. 5. Save result as tab delimited txt file in a local file C:/LakesideBooksClient/Downloads/ as AlibrisOrdersImport YYYY-MM-DD 6. Save an additional copy to %UserProfile%DropboxFTPRepositoryAlibrisOrderArchive 7. Delete any left over files from step 1. I would prefer a batch file or Node JS. I will be setting this up as a Scheduled Task to run every 30 minutes.
I am looking for a Wordpress Woocommerce Plugin developer who can create a plugin to import a database, images, and XML into my website. Requirements: - Ability to import database, images, and XML files - Experience with Wordpress and Woocommerce - Familiarity with plugin development and integration The data for import is already prepared and ready to be imported. It is a fairly complicated set of instructions and files. I can email all the files and instructions to anyone interested. The company with the database does not currently have an api but they do have the ability to download the files. Timeline: - The import process should be completed within more than two weeks. If you have the necessary skills and experience to complete this project, please submit your proposal and...
I am looking for a ...select any XLSX file and have it downloaded as a txt tab delimited file. Desired Output File Format: - The output file should be in TXT format. Specific File Structure: - Yes, I have a specific file structure in mind for the output file. It is an ASP.net core web app and it is not MVC just plain structure Sample Input and Output Files: - Unfortunately, I cannot provide any sample input and output files. However, I can describe the structure and format of the files for reference. Ideal Skills and Experience: - Proficiency in ASP.net Core 6 - Experience in file conversion and manipulation - Strong knowledge of working with different file formats, especially XLSX and TXT - Attention to detail and ability to accurately convert and preserve data from one ...
for example the first spot play, simple m detects vulnerable favorites in a thoroughbred horse race. only look at pages 1-4. the programmer must have extensive knowledge of both bris comma delimited single file format and thoroughbred horse racing.
for example the first spot play, simple m detects vulnerable favorites in a thoroughbred horse race. only look at pages 1-4. the programmer must have extensive knowledge of both bris comma delimited single file format and thoroughbred horse racing. i don't know if you are going to do this as a separate project, but i enclosed which if it is easier for you and hopefully less expensive you can add simple m to. thanks!
I am looking for a skilled freelancer who can help me convert a Postgres sql file into a comma delimited csv file. The ideal candidate should have experience in handling sql files and converting them into csv format. The project requires the following skills and experience: - Proficiency in Postgres sql - Experience in converting sql files into csv format - Familiarity with comma delimited csv formatting If you have the necessary skills and experience, please submit your proposal with relevant examples of your work.
Our current work requiere to connect daily to an hotel PMS platform (Opera) and request three reports that need to be downloaded as data delimited by '|'. What we need is three playwright scripts (in typescript) that automate the download of the files. The expectance is to copy the scripts in the 'tests' directory where playwright is installed (it is a Mac OS laptop, but we also have a Debian server with Playwright installed). The process of the report generation is very direct, you select the specific report, then the range of dates, which is always from January 1st, of the current year to December 31, next year. And then download the file to ../test-results (relative to /tests/ directory) The details of the process are described in the document attached...
I am in need of a freelancer who can assi...am in need of a freelancer who can assist me with bulk email verification and cleanup. I have over 100,000,000 email addresses that require verification and cleanup. the file will be provided as .TXT with just the email addresses OUTPUT should be email and RETURN STATUS (comma or tab delimited - up to you). Ideal skills and experience for this job include: - Experience with email verification and cleanup - Knowledge of various email verification tools and services - Ability to handle large amounts of data - Attention to detail and accuracy In your application, please include your experience with email verification and cleanup. I am open to suggestions for email verification tools and services, so please feel free to share your...
I am looking for a freelancer to complete a project using boost lib to load and display a serialized Binary Search Tree file to the console. The file is written in C++ and requires an in-order traversal to be displayed to the console as text comma delimited with /n at the end of each line. This program is a proof of concept that will end up with us needing another project to import csv file to this format etc. The assignment should be completed in a timely manner with code that is commented and well-documented for future maintenance. Thank you for taking the time to consider my project and I look forward to hearing from you.
I need a macro for Excel 365 that will allow me to export specific columns of data to a new CSV file. The exported file must be in CSV tab delimited format. The criteria for selecting the data to export will be based on specific columns. I also need the macro to match data in the other 4 sheets and delete certain rows based on criteria before exporting. Ideal skills for this job include experience with Excel macros and proficiency in VBA. Match, Delete and Export Excel 365 Macro This project is based on the enclosed sample active workbook, which has the following worksheets (one in each tab, labeled: Cases, Casework, Comments, Contacts, plan_request The macro should run in Excel 365. The macro should basically delete all the entries from a specific &ldquo...
I need some python programs for tab delimited text ( which will have date, name, name, quantity, amounts and will have at least 150 rows of records ) to html conversion and an adroid program to tiger a realy and get some numbers from user before getting the rely on which will have 99 user
...recognized (OCR) and converted into delimited text/ASCII format so that they can be loaded into a database on a Windows machine, in a Windows Server environment. The PDF documents are lists of data (I have included an example which is explained below). The PDF files all have essentially the same format, with very small variations. The final solution will be called from a management system (spawning a DOS box) and run either via an executable or a batch file, for example: C:> or C:> The file is the PDF that needs to be scanned and converted into text, and the results of which are then sent to the file. Included in this project is a 3 page test PDF document which contains test data using the format I need interpreted
...recognized (OCR) and converted into delimited text/ASCII format so that they can be loaded into a database on a Windows machine, in a Windows Server environment. The PDF documents are lists of data (I have included an example which is explained below). The PDF files all have essentially the same format, with very small variations. The final solution will be called from a management system (spawning a DOS box) and run either via an executable or a batch file, for example: C:> or C:> The file is the PDF that needs to be scanned and converted into text, and the results of which are then sent to the file. Included in this project is a 3 page test PDF document which contains test data using the format I need interpreted
...user which have acces at this modul press a button from that location open Google Maps and create the route from user location until that location. This module must have the option to select which users can access those informations. 3. At this point we need something like a document management with GIS system and working like this: - In the city area there are a lot of plots of land very well delimited thru GPS points and each plot of land have an unique cadastrial number, a part of these plots of land belong to the citizens or companies, other parcels of land belong to the municipality. Each citizen, company or municipality will have an unique identification number which will be the username for login to the platform. - We need to have the option to create the plots of each par...
...user which have acces at this modul press a button from that location open Google Maps and create the route from user location until that location. This module must have the option to select which users can access those informations. 7. At this point we need something like a document management with GIS system and working like this: - In the city area there are a lot of plots of land very well delimited thru GPS points and each plot of land have an unique cadastrial number, a part of these plots of land belong to the citizens or companies, other parcels of land belong to the municipality. Each citizen, company or municipality will have an unique identification number which will be the username for login to the platform. - We need to have the option to create the plots of each par...
Need unix command to split file based on first two columns in a data file with pipe delimited
hi i have a csv file with delimited comma and i want to return it to their original status, no bar bettween column just commma (simple csv file). i accedentily change it to with delimited comma!
We’re looking develop formulas and a macro to reformat a document for our regular data import process. We receive a report from a partner organization on a daily basis and regularly need to reformat and upload the ticket data into our system. These are the basic requirements to make the sheet ready for our import: • Partitioning the Name field provided into First, Last, First 2, Last 2 columns • Partitioning the Csz column into separate city, state and postal code columns • Removing foreign country zip codes • Adjusting zip codes that start with 0 (the file does not include the 0 if it’s the leading number) • Removing extraneous columns • Removing rows with missing seats/seat locations • Partitioning the Seat Location col...
We have an existing plugin for exterior ballistics and need to update/add new bullets to the plugin. I have all the bullet information in a comma delimited file. I need someone to import those into the plugin and advise how we can do it ourselves int he future.
I need develop a suite script to extract and SFTP data in pipe delimited format text file from Netsuite to third party application.
I have a Signup Genius signup connected via Zapier to my Airtable database. I have 3 custom questions in the signup and Signup Genius exports those all in a single comma delimited field. I need those 3 separate responses separated into 3 distinct fields in my base. I don' t know how to do that but assuming it involves a formula to separate them.
Data scientist needed UX already exists and is attached to this project. Have a working system that reads 2 columns of a csv the matches questions to answer Column A of the data file the Keywords (Questions) Column B of the data file the Answers system currently using Cosine Similarity From import os import io import random import string # to process standard python strings import warnings import numpy as np from import TfidfVectorizer from import cosine_similarity import warnings Steps to make product work. 1) Navigate to the "Product Name" selection field and select the desired product. * needed- --There are 3 product which are the previously mentioned csv files and those in UI is not hooked up Want a separate app called
I have data from camp registrations I need to export into Google Sheets. If you have done this in the past, please show me your results. I'm open to other suggestions as long as I don't have to pay big fees every year. Currently my website is using Woocommerce. Then I'm requesting new data via Woocommerce Extra Product Options. From there, I'd like for you to transfer to Google Sheets. I'm not totally in love with the Woocommerce Extra Product Options because it doesn't seem to validate phone numbers or dates. If you have a better plugin that validates, please let me know. What is not working is: 1) The developer used Extra Product Options & Add-Ons for WooCommerce plugin for all the registration fields and they aren't coming into G...
Hi I would like an Angular expert to log into my PC (screen share) and assist me with fixing the Form validation I have started in an Angular 14 project. There are 3 fields to validate before submit: one field requires comma delimited text, one requires a valid url and one requires a prefix (IBA or EC). Should not take an expert long. The html and form already exists, just need the form validation imported and used properly.
...capture and organize property data for quotation and record-keeping purposes. Body: * Allows users to take between 5-50 photos and add typed or verbal notes for a property * Property address can be looked up and saved, including street number, street, business name, city, and zip code * Data can be populated into a quote that can be printed on-site for clients * Records are stored in a private online database * Imports owner data from membership sites such as through API or scraping * User-friendly, functional, and simple design with minimal graphics * Intended for small scale use (1-3 users) and not intended for the Apple store * Compatible with recent iPhone and iPad versions, IOS only. * Outputs to common file types such as XLS and comma delimited for im...
I have 2200 images in an HTML file that have associated text elements. I am looking to download the images, and name the image file using components of the text element. The text element will appear to have 4 sections: random numbers, random alphanumeric string, item name, and a final digit. I want to extract the first set of random numbers as a string and the final digit, delimited with a character. So the final file name would look like My deadline is Wed Feb 1 by 5pm EST
...scrape are: 1. Ad Title 2. Description 3. Price 4. Images (filename in comma delimited) (see attached csv file as example) - Original images needs to be saved locally. 5. Seller Name 6. Mobile Number I have highlighted in green (in ) the data that is needed, the not highlighted can leave it blank. Also links above ( is an example) has all the ads that needs to be scraped but needs to go inside to the ad (see ) to get the other contents. Also to take note that the images download needs to be renamed in a random filename so it won't get conflict or overwritten. (see the .csv file under images to get what I mean). You can scrape and provide me the data... or probably a script to run this on a server. Lets chat/discuss.
We would like a simple program(script) that sits and waits to read from a USB RFID device the RFID card number and create a log. Type, ID, Date Time entrance, 09836735, 1/27/2023, 13:00 if when the card reads and the ID and date already is there then it automatically makes it as type exit Type, ID, Date Time exit, 09836735, 1/27/2023, 18:... Date Time exit, 09836735, 1/27/2023, 18:00 where the log can be something like this: Type, ID, Date Time entrance, 09836735, 1/27/2023, 13:00 entrance, 00063534, 1/27/2023, 13:10 entrance, 00036735, 1/27/2023, 14:30 entrance, 01068834, 1/27/2023, 15:10 exit, 09836735, 1/27/2023, 18:00 exit, 00036735, 1/27/2023, 18:30 at the end of the day the log is stored as a text delimited file with the filename of...
