We would provide the following:
FTP with a folder with:
About 165 csv files with apprx. 260,000 lines each and 9 columns. There are unique identifiers in Column A and information about these unique identifiers in the following columns. Each csv file’s name is a timestamp showing the exact date of the information in the file.
One additional xlsb file with unique identifiers in Column A, Date in Column B and additional information for the unique identifier in the following columns.
We need the following to be performed:
All csv files to be combined into one database, keeping the date of each unique identifier.
All unique identifiers with their dates in the xlsb file to be matched against the same unique identifiers from the same date in the csv files.
Once matched, the data from column B to I from the csv files to be pasted in the xlsb files on the unique identifier’s line from column E to column L.
Example:
The xlsb file contains in Column A, unique identifier 123456, in column B, on the same line is date 01/08/2016
We would need to find the unique identifier 123456 in the csv file from 01/08/2016 and then copy the information from column B to I on the same line as the unique identifier, and then paste it in the xlsb file, on the same line as the unique identifier in the same order, starting from column E.
Then, we would need the xlsb file with all of the above information and one file with the combined csv files.
Hello, and thanks for the opportunity to bid on your project.
https://www.freelancer.com/u/TenStar718.html
I am an expert in many different area’s of web and mobile applications based on the following languages: Web(PHP, MySql, HTML5, Java) and Mobile (Native and Hybrid). I am also an expert in many different frameworks such as CodeIgniter, Laravel, Spring and jQuery.
I have over 5 years industry experience in development and graduated with a Masters Degree in IT from the Hong Kong University. My PHP L1 exam score in Freelancer places me in the top 3% of developers. Please have confidence in my skill and quality of work.
I assure, I will do my best to work with you on your project to present the best possible outcome for you and your customers. I will also do my best to correct any area of work where quality comes into question, I want to have pride in my service to your company and the final product provided.
While I am happy to make adjustments and alterations as your project progresses please understand that I am a dedicated freelancer and any work that is substantially different from the project description may need the awarded fee to be re-negotiated.
Feel free to contact me if you have any questions, and please review my 5 star profile.
I look forward to working together in partnership on your project and into the future.
Regards
Message me before you gonna award this project to me
Message me before you gonna award this project to me
Message me before you gonna award this project to me
Message me before you gonna award this project to me
Message me before you gonna award this project to me
Message me before you gonna award this project to me
Message me before you gonna award this project to me
Dear Sir,
I read your project description
I have experiences to do this project
I waiting your response
Look forward to working with you!!
Best Regards
Duc
Hello,
Hope You are doing well.
ARITY INFOWAY is complete web based solutions company. We able to provide web solutions from scratch to hosting .
We always go through every point of your projects scope and provide you our comments & suggestions. ARITY INFOWAY
is leading growing company in outsourcing business. We are having 15+ members with expertise in various technology.
Web Designing :-
HTML5/PSD to HTML/CSS3/JS/Angular JS/Node JS/jQuery/Responsive Web Designing/UI Development/Frontend
Development/Logo Designing/Theme Integration/AJAX/Web Services
PHP:-
MySQL/Core PHP/Magento/Joomla/Wordpress/CMS/Blogs/Codeigniter
/Smarty/Moodle/Symfony/Yii/Drupal/eCommerce/OSCommerce/Shopping Cart
.NET:-
ASP.NET/VB.NET/C#/MVC/ Umbraco/Entity Framework/BioSecure Software/SQL Server/HSQL DB/Kendo UI/Telerik
Control/Azure Storage/CDN Storage/WCF/WPF/Web API/HRM Integration/Desktop Applications
Mobile Applications:-
Android/iOS/Windows
Payment gateway Development & integration:-
PayPal/Avangate/Skrill/CCAvenue/WorldPay/Stripe
Web Hosting:-
(Linux/Windows) Hosting/Advance DNS Solution/Server Installation & setup/Mail Server/Router Configuration/Switching
& VLAN/VPN/Cloud Server/Critical Data Recovery/Remote Server Support/Server Security/Web Security/Computer Help
We never Place any GENERIC BID so we frequently contact you to meet you expectations.
We love to spread SMILES :-)
Dear Employer ,
i've read your project description and we're interested to discuss further with you.
we have been in this industry for more than 7 years and such a task is a daily job for us.
As you can see we have small amount of reviews but that because we have joined freelancer lately , but definitely you can see good reviews on our account.
Our team is fully available to be dedicated on your project to deliver in the time we will discuss in the highest quality with advanced technology.
We are waiting to hear from you to discuss further requirement for your project.
Best Regards
Hi sir,
I am expert in excel Handling, i can create macro to sort out/remove any unwanted data(even from urls or from any where in the sheet). I have done 300+ excel tasks like matching the results, comparing using macro and i have well versedskill in sorting, replacing, delimations, formulas etc. You will wonder if you see my work
Hi there,
Your requirement is pretty clear and straightforward to implement. At the end of the processing you'll receive 1 xlsb file containing all the matching records from csv files and one sql file containing all the records from csv files.
I can start as soon as you award the project and expect to be done within the next 24 hours at most. I suppose you're not interested in the actual script that'll do the job thus makes no difference but any case I'll use python to handle this.
Thanks
Ibrahim
Dear Project Poster,
I have relevant hands on 5 years of experience .We have a team of all the skills. I assure you about the work quality and time delivery. Please give me chance to complete this project.
I had already done the same work in past. Looking forward to hear from you.
Let me give an opportunity to work. We can talk further when you message me.
Hello,
I am interested in your project. I am a software engineer and I have professional experience with MySQL. Could you please provide sample files of your data?
Thank you,
Best regards,
David
Hi,
I understood the requirment. I can write a small java program for reading and matching data. Once match found, java code will right the matching data to XSLb
Hope we can have more conversation
Hi There!
I am a professional software developer and have very good experience in database development. i completely understand what you want to achieve.i can perform your task in a very very short time like in 1-2 days. i can make you a C# app that will do all this automatically and will create a database/csv file of your data.
Hello, sir. Freelancer with more than a decade of experience ready to carry out your project. Please, contact me for any further information.
Att,
Eduardo Capanema
I have excellent MySQL skills, including the ability to write stored procedures and handle file import tasks. I also am an expert at Excel, including macros. I believe I have the combined skills to complete this task very quickly and accurately.
I'm a Data Expert and works every day with massive amount of data.
I can any manipulation on the data you need and I can deliver you an efficient data loader in small period of time.
Hi,
First of all, thank you for your detailed description of the project.
Just to confirm I understand correctly, the xlsb file already contains Column A and Column B filled in and needs the other columns (E - L) filled in with data from the csv files matching the unique identifier in the csv file and the date (name) of the csv file.
The I would need to provide you with the xlsb file with all the data filled in and one file with the combined csv files.
Can you explain a little bit more about the one file with the combined csv files? Should this csv file be generated from the xlsb file or is it just combining all the csv files into one? If it is just combining the csv files into one, then the date information is lost, since it is in the filename (unless the date is also one of the other 8 columns).
If there is anything I missed, please let me know.
