Merging Excel/ CSV table to MongoDB collection
$250-750 USD
Paid on delivery
We have a mongodb database with one collection containing millions of documents in Arabic and Latin scripts. The main fields are: firstName, lastName, fatherName, motherName and dateOfBirth, we want a software that can connect to that collection, then we can load any excel or csv table containing different columns and rows.
The software will check the header of the excel/csv file and detect the columns. And ask the user what are the columns that he wants to include in the matching decision, and to which mongodb field it must be compared.
The software will then ask the user what are the columns in the excel/csv table that are required to be merged.
For each excel row, if one match is found in our database the software will merge it automatically, so the columns of that row that are required to be merged are added to the corresponding mongodb document.
At the end of the automatic merging:
1- The software must list the excel rows (one by one) that had multiple matches and show all the matches (found in our mongodb collection) to the user, and the user must be able to choose manually the correct match.
2- Then the software must start listing (one by one) all the excel rows without a match, and suggesting the closest matches, like for example if one letter is different in the father’s name, or everything is matching except the date of birth. So, the software must list all potential matches, and the user of the software can choose the correct match, and the software will then do the merging according to the chosen match. The manual merging part must be savable. So that the user is able the continue his work even after restarting the software.
Project ID: #31426149
About the project
20 freelancers are bidding on average $385 for this job
PYTHON MONGODB developer I have read your job description and I am pretty sure that I can complete every bit of your requirements. Further details and cost can be discussed in chat
Yes, i can Merging Excel/ CSV table to MongoDB collection. message me i am ready to start work form right now.
Hello. I've read your job very carefully. I'm the perfect person for you. Because I've much experineced in Panda and MongoDB. I'm quite sure about your project. pls ping me asap. Thanks.
Hi , I am an experienced Python programmer with 5 years of experience is software and web development, design and implementation. I can deliver well within your budget and deadline. I'm willing to work in your time zon More
Hi, I have a deep understanding and experience in csv, excel data to mongoDB. ******************************************************************************* I've full experience on this kind of project so can comple More
Hello , Read your requirements I can give you the best service . Looking forward to work. Thank you.
Hi buyers, B2B Lead Generation | Business Leads | Email Addresses | B2B/B2C LinkedIn I am a professional LinkedIn B2B Lead Generation Expert & find 100% verified Business Lead, Business Email Lists, and addresses for More
Hi, I've read your description carefully. I have full experience with Excel, MongoDB. I've also worked on several similar projects. So I can complete your project with high quality on time. Looking forward to hear more More
--------------------------------Python Expert--------------------------- Hi, there As a Senior Python Expert I have 5+ years rich experiences working with Python I can help you with my experiences perfectly Please con More
Dear Client Thank you for your job post. Today I show this special job post look at my profile and give this job to me. I can do it high quality with the high quality please send me a message about your job Regard Lasi More