Data Transformation - horizontal embedded tables into child tables

I have read your requirement in spreadsheet shared and I believed that I can build this application for you in 1 day. I will C# to build this application and accept many type of excel file such as csv, xls, xlsx. feel free to contact me then I will consult you how to do and use this application.

Hi, I have been working as Database Analyst Programmer more than 10 years. I became OCP, CCNP, RHCE 3 years back. Earlier I completed B.Sc. Enng and M.Sc. Engg both in computer engineering. Check my works here https://www.freelancer.com/projects/Software-Architecture-Engineering/Entity-Relationship-Diagram-ERD.html https://www.freelancer.com/projects/PHP-HTML.1/Database-Project.html https://www.freelancer.com/projects/database-administration/Database-Coursework.html I'm looking forward to hearing from you very soon

Hi, I have lots of experience with databases and can help you in short terms with this project. I checked the spreadsheet for information, but can you share the data which need to be changed so I can work on it and show you results quickly? I'm proposing to do this with VBA and excel macro which will be more handy than any executable code and is easy maintainable for the future.

Hi there! Listen, I have already done the program, just missing the SQL part, thats why I can have it ready in 1 day. I downloaded a csv version of the sheet you have in google documents and I worked with it. For the 2500 fields capacity, I develop a function that reads a field a a time, and then use it to develop a function that reads and entire line returning and array with all the fields in the line. Just as an example of the data structures the program construct with the headers of the csv fie: [A.11] => Array ( [head] => TYPE CODE(A.11) [start] => 10 [end] => 12 [records] => 3 ) [A.12] => Array ( [head] => PACKAGE NUMBER(S)(PHOTO LOG)(A.12) A.12,A.13 [start] => 13 [end] => 31 [records] => 19 [rel_num] => 0 ) So if you choose me you got almost intant delivery of a tested and verified program and a low price whithin yuor budget. What I ask for is to rate me high, comment and whatever you can do to increase my reputation on freelancer.com as I'm new. As you can see on my profile, this will be my 2nd project and you can read the feedback of my 1st employer. By the way, I'm flexible and open to hear proposals.

Hi, I am a database programmer and work with php and mysql. I found this project interesting and am researching it. What is not clear are the exact relationship between a property detail and the cell number (example A.12. A.13) in the column name. If you can help make sense of the column name then the relationships can be coded and the tables formed recursively. If you make this a hourly project then I can work for $20 per hour for a max 10 hour per week for 2/3 weeks. If you have any questions please let me know and I will be happy to answer them. Thanks Deb

Hi, Greetings for the day, we have gone through the data provided by you and would like o bid on this project , Time line will be 15 Days , Fixed cost is 555 USD , Approach , will try to create a macro in Excel to have the desired result , Assumption 1- The data table will remain constant .IE Column will not be changed also you are looking Creating a new tab in Excel with PROPERTY ID as the first column, then A.12 and A.13 as the next columns and if there is no data you want to skip that row , Just wanted to know how many row and column are you looking at for conversion Thanks for your kind consideration Best Regards Micoline BD team

A proposal has not yet been provided

A proposal has not yet been provided

I currently extract non-normalized data from car dealers' DMS systems on a weekly basis and update a MySQL database. The major difference here is that I must assume that each new input file is a different format and I need to identify the non-normalized data from the header record. 1. Timeline - 10 days from award of bid and delivery of a real input file 2. Fixed cost - $750 (includes a week of support) paid upon completion 3. Description of the approach to how you will transform the data (i.e. what coding language) VB program will read header record, decide which fields are non-normalize and map how to output the new data. Output will be provided in CSV and SQL (insert commands). I propose SQL syntax that is standard and that I can check with MySQL. 4. Assumptions you are making regarding your approach The input data is in CSV format and that each row is a complete record (a data item is not split into multiple rows). Langston

A proposal has not yet been provided

Dear Sir : I was excited when I saw your job postings online for data entry person. I have three years of data entry experience, and I have performed all of the duties listed in your job description. I type 42 wpm with almost 100% accuracy, and my employers have praised me for my focus, speed, accuracy, and professionalism. I hope these are qualities you look for in your data entry employees. I am looking forward to discuss you further on chat where we can discuss the open positions in more detail, and you can ask any questions you may have. Please schedule a time to meet. Thank you I look forward to meeting you. Sincerely, Rahul Gupta

Hello, I found your job advert and I like to apply for the job. I have professional experience in excel/table computing. I have worked for various organizations like provision stores, pharmacies, government organizations, researchers and private sectors on data collection in tabular arrangement and analysis. I have a very fast typing skill and would be able to get your job done in a short period of time. I assure you that I will give you my best. I am open to any question or interview you may have for me or concerning my skills. I look forward to giving you my best services and getting a recommendation from you at the end of the day. Thank you, Akanbi, M.O.

I am a Technologist, with emphasis in Databases. I have experience as an Architect, Administrator, and Developer. Therefore, I have the knowledge to build and support Enterprise Database Systems from the ground up. I have many years of experience building Reporting Systems, from operational reports to cubes to dashboards. This includes designing databases, developing ETL systems, and coding reports, such that it supports business processes to easily store data and transform into custom reports.

I am here to deliver beyond your expectations. I am an experienced of Data Entry and Data Processing and so my other services that will provide useful benefits to your project. I have a distinguished career as a Copy Typing and Editing Expert. I can comfortably handle Data Entry, web scraping, Data Processing and Editing. I also hold experience in Excel and Data Base. I am ready to be hired by you and start work today