Hi Bidders,
I m building a CRM software that implements complex functionality and calculations. Hence the CRM has complex DB structure and a lot of tables with a lot of proxy (bridge) tables.
I need a parser module that would parse XLS files where my client used to store his data. The parser should be responsible to do the following:
1. parse cells of the XLS sheets. Some cells contain two or 3 fields concatenated , so the parser must break down these cells.
and other cells shoudl be merged based on certain conditions.
2. The parser should then load the extracted data into the correct fields in the correct DB tables.
3. Some fields do not exist explicitly. Instead they should be calculated according to some business logic or according to the relative location of the XLS sheet that s being parsed.
Please note that i need a senior developer in order to be able to understand the DB structure of the CRM. The developer would also need to understand the business behind each table and each bridge table in order to successfully save data in its right field.
plz dont bid if u r no confident about ur technical and mental skills.
Happy bidding