Import Call MetaData from XML to SQL

$250-750 CAD

Completed

Posted

11 days ago

$250-750 CAD

Paid on delivery

*context* This is an export of a call recording system by mitel. We are moving out of the platform and wish to retain historical call recordings. Goal is to be able to quickly search and narrow down a result if we get a request for a old call recording. If all the XML data is inside a SQL database than we can write queries to narrow our results and ideally path to the exact MP3 file to play. *** I require a specialist to design, build and implement a system to batch import XML data containing specific call recording metadata into a SQL database. The required data points are: - Caller ID - Call duration - Call start time - Internal employee on call Specialists should possess expert knowledge and experience in handling XML and SQL databases, with an ability to read and interpret XML data structure and write necessary SQL queries/scripts. In addition, I need you to provide a script or process to upload future XML files easily and independently going forward. An ideal freelancer for this project would have: - Proficiency in XML and SQL - Experience with call recording metadata strongly preferred - Good understanding of database design and management - Ability to deliver the project within a month I am open to discussing the budget for the service, but I am mainly focused on quality and efficiency. If you meet the requirements, I look forward to discussing this project with you. Attached an example of a XML document. the filename of the document has a corrosponding .mp3 file in the same folder. Screenshot also of the general file/folder structure.

SQL

XML

Microsoft SQL Server

Project ID: 38039628

About the project

30 proposals

Remote project

Active 11 days ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@DebasisB

$0 CAD in 7 days

4.9

(51 reviews)

6.3

30 freelancers are bidding on average $495 CAD for this job

@AwaisChaudhry

Hi Good morning , I have read the brief details on your job listing and currently going through attached files . I see you have been looking for someone experienced with XML, SQL and Microsoft SQL Server. Its been 8 years since I have been working on freelancer.com, I have 9 years of experience doing similar jobs. I would request you to check my profile and review projects, feedbacks of projects related to those skills. Questions: 1. These are all the requirements of your job or do you have more? If yes, Please provide detailed requirements in chat and let me review and get back with queries. 2. Do you currently have anything done or this job has to be done from scratch? 3. What is the timeline to get this job done? 4. Are you open to use 3rd party APIS for it even if they are paid? Why Choose Me? 1. I have done more than 250 major projects only on freelancer.com. 2. I have not received a single bad feedback since last 5-6 years. 3. You will find 5 star feedback on last 100+ major projects which shows my clients are happy with my work. Portfolio: https://www.freelancer.com/u/AwaisChaudhry Timings: 9am - 9pm Eastern Time (I work as a full time freelancer) Please initiate the chat so we could discuss it in detail and we will continue from there. Thanks! Awais

$750 CAD in 14 days

5.0

(16 reviews)

5.8

@usuf001

Hi there, i can code the application in laravel to import the xml files in batch (zip of XML files) will be uploaded and a background job will import XML files data in to MySQL table, front end to search and show results. If we are allowed to download the mp3 file we can store locally while XML is imported for that specific call recording. Thank you

$500 CAD in 7 days

5.0

(48 reviews)

5.9

@haseeb6291

Hey there, With over 8 years of experience in SQL Server Development. I'm interested to discuss your project's timeline, budget, and detailed requirements. Let's schedule a meeting at your convenience to explore further. Best regards, Hassan Zafar Mirza

$250 CAD in 3 days

5.0

(15 reviews)

5.5

@ASSAMWEB

Greetings, I have read the project description I have been working on a similar project in recent time "sql db for company like -- Vidrio " I am interested in the work open a chat to discuss requirements in details.

$500 CAD in 2 days

5.0

(5 reviews)

4.0

@kkscwcd

Hi Sir, I have good experience ETL process and developed many Utility application for importing/exporting data from XML/CSV file to database . As I reviewed your job description it’s looking fine , I can develop a utility in Java which will look through folder , read xml file and extract data, insert it into SQL server. Can we have chat to discuss further and I will happy to help you. Thanks,

$570 CAD in 7 days

3.9

(10 reviews)

4.9

@rodweb

Hello, I read your requirements about this project. I can build for you a tool to handle your xml file. I have good experience in SQL

$500 CAD in 13 days

5.0

(4 reviews)

3.8

@poduzov

Hello I'm a software developer with 10+ years of experience that includes XML and SQL. The XML structure is quite clear, so there will be no issue developing a script/software that would do the migration. Please tell me more about your project. Best regards, Dennis

$500 CAD in 10 days

5.0

(2 reviews)

3.1

@souyah

Hi, there! Having confirmed the job posting, it seems like you might be looking for a senior developer for your project - Import Call MetaData from XML to SQL. I have worked with similar projects so that I can provide you with a satisfied result. This project really caught my attention because I have been working in this specific industry for 10 years now, and have not only gained experience or knowledge but, I have got the answer to the main problem which many clients face which is communication and I can assure that you will be satisfied and updated throughout the process, if we move forward. Can't wait to have you on chat with me, and to get started with this project. Regards

$555 CAD in 4 days

5.0

(1 review)

2.0

@escalantejoaquin

Hello jgrilopencircle I would like to grab this opportunity and will work till you get 100% satisfied with my work. I'm an expert full-stack developer which have 6+ years of experience on XML, SQL, Microsoft SQL Server. With years of experience in software development and a passion for creating innovative solutions, I'm confident in my ability to help drive the success of your business. Beyond the technical expertise, I'm an excellent problem solver and have strong communication skills. I'm also a friendly and easy-going team player who is well-respected by industry-leading companies and customers. Lets connect in chat so that We discuss further. Best Regards.

$500 CAD in 7 days

0.0

(0 reviews)

0.0

@UmairAnwar93

Hi , this is Umair. I have good experience with SQL, XML and Microsoft SQL Server. I am a practicing Developer/Designer Since 2015. I can perfectly work on this project regarding Import Call MetaData from XML to SQL. I can say this with conviction as my all reviews are 5 stars , I can do this task for you and the quality of work would be up to the mark. However, further discussions are required for more clarity. I will wait for your text to discuss the project in further detail. Thanks & Regards Umair A.

$700 CAD in 20 days

0.0

(0 reviews)

0.0

@jumppace

Hello there, With years of experience specializing in Microsoft SQL Server, SQL, and XML, I am confidently positioned to take on the challenge of your project which involves importing call metadata from XML into a SQL database. My extensive knowledge in these areas allows me to easily read and interpret the complex structure of XML files and efficiently write the necessary SQL queries to extract the required data points including Caller ID, Call duration, Call start time, and Internal employee on-call. Moreover, my understanding of database design and management will come into play when implementing a batch import system for your future XML files. My goal is not only about completing this project but also about empowering you and ensuring you have the process and script in place to handle future XML uploads independently. Given our successful track record of optimizing websites and driving digital conversion, I assure you that not only will I complete this project within a month but with an impeccable standard of quality. We look forward to leveraging our strengths in communication, experience, and affordable pricing model to deliver exceptional results for you and your team. Jumppace Pvt Ltd. h

$666 CAD in 5 days

0.0

(0 reviews)

0.0

@giaphung2k1

kii-te-daas a I can do this project. I am a professional Linux and developer in PHP, Wordpress, Laravel, Magento, Joomla, Prestashop, OpenCart, Yii, NodeJS, ReactJS, Angular, Vue.js, HTML5, CSS3 and jQuery. I can do this project. Please hire me. I think, You will contentment with my skills. I can fix your site issue successfully I am looking forward to having further discussions with you and can start working immediately. Best regards, Giáp Văn Hưng

$320 CAD in 7 days

0.0

(0 reviews)

2.4

@ahsan423

GREETINGS Excited about the prospect of collaborating on your project, confident in meeting your specifications, with 7 years of experience, I am well-suited to design, build, and implement a system for batch importing XML call recording metadata into a SQL database. With expertise in XML parsing and SQL database management, I will ensure seamless integration of the required data points such as Caller ID, call duration, call start time, and internal employee on call. Additionally, I will provide a script or process for easy and independent uploading of future XML files. My proficiency in XML, SQL, and experience with call recording metadata aligns perfectly with your project needs, and I am committed to delivering high-quality results within the specified timeframe. Best Regards, Ahsan

$500 CAD in 7 days

0.0

(0 reviews)

0.0

@muneebkhalid006

As an experienced and highly skilled developer, I believe I am the perfect fit for this project. I am well-versed in both XML and SQL, having worked extensively with them throughout my career. With my expertise, I can design and implement a system that can easily extract specific call recording metadata from your XML files and store it in a SQL database. My knowledge of SQL queries and scripts will allow us to create a search system that can quickly retrieve old call recordings based on various parameters such as caller ID, call duration, start time, and internal employee on call. In addition to managing your existing XML data, I will create a script or process that uploader future XML files securely using my vast knowledge of storage systems. My past experience in managing complex queries and designing systems like yours will also prove beneficial in developing a robust solution for you.

$350 CAD in 3 days

0.0

(0 reviews)

0.0

@vikatarasiuk1995

I have extensive experience and expertise in XML and SQL databases, making me the ideal specialist for your project. I will design, build, and implement a system to batch import XML data into a SQL database, capturing specific call recording metadata such as Caller ID, call duration, call start time, and internal employee on the call. I will utilize my knowledge of XML data structure interpretation and SQL query/script writing to ensure efficient search and retrieval of historical call recordings. Furthermore, I will provide a script or process for easy and independent upload of future XML files. With my proficiency in XML, SQL, and database management, combined with my understanding of call recording metadata, I am confident in delivering the project within a month. Quality and efficiency are my top priorities. Let's discuss the details and budget further.

$500 CAD in 7 days

0.0

(0 reviews)

0.0

@StoqNet

Our proposal involves expertly importing call recording metadata from XML files into a SQL database, focusing on key parameters like Caller ID, duration, start time, and employee information. We'll leverage our proficiency in XML parsing and SQL database management to efficiently interpret data structures and design an optimized schema. Our approach includes developing robust scripts for seamless future uploads. Rigorous testing ensures data accuracy, and our transparent project management guarantees timely delivery within an adaptable budget and timeline.

$500 CAD in 7 days

0.0

(0 reviews)

0.0

@DeveloperStation

With years of experience in XML and SQL database management, I have a proven track record of successfully handling complex data integration projects. I possess the expertise to interpret XML data structures and write efficient SQL queries/scripts tailored to your requirements. Moreover, my experience with call recording metadata further strengthens my suitability for this project. I understand the urgency of this project and am committed to delivering results within a month. As for the budget, I prioritize quality and efficiency above all else. I'm open to discussing the budget to ensure that we strike the right balance between affordability and excellence.

$500 CAD in 7 days

0.0

(0 reviews)

0.0

@ankeshvaishnav

As an expert web developer with over 9 years of experience, I've acquired robust skills in XML, PHP, and SQL that align perfectly with your project requirements. I have consistently leveraged these skills to handle complex front-end and back-end systems like the one you've described, enabling efficient data management for enhanced search functionality and seamless future uploads. In addition to my proficiency in handling XML and SQL databases, I take pride in my capacity to understand, interpret, and manipulate XML's intricate data structure, ensuring all crucial metadata points – Caller ID, Call duration, Call start time, Internal employee on call – are accurately streamlined into the SQL database. This process will allow us to write precise queries expedite your team's future call recording retrieval demands. Furthermore, my commitment to clean coding practices coupled with my familiarity with database design and management will guarantee a high-quality solution within our agreed-upon timeline. Rest assured that I'll prioritize your project's efficiency without compromising on quality. By selecting me for this task, you are opting for a long-term reliable partner who values your investment as much as you do. Let's discuss how we can bring the archive of Mitel's call recordings into the future seamlessly - communicating with ease 24/7 throughout the process.

$300 CAD in 3 days

0.0

(0 reviews)

0.0

@bkhalidwork

Hello, You are looking for an XML and SQL developer, to design and implement a system for batch importing XML data into a SQL database for call recording metadata. With 8+ years of proven experience in XML and SQL handling, I can assist you in achieving this goal. Having a strong background in XML and SQL handling, I have successfully designed and implemented similar systems for previous clients. As a candidate for the XML and SQL developer position, I have a few questions for you: 1: How many XML files do you anticipate importing initially? 2: Do you have any specific preferences for the SQL database structure? 3: Are there any particular security considerations for accessing and storing this call recording metadata? 4: What are the expected volumes of future XML file uploads? Regarding similar work I have done for previous clients, I would love to explain it in the chat (Very Quickly). If any of the above details connect with your requirements, let's have a chat. Regards, Bilal

$300 CAD in 9 days

0.0

(0 reviews)

0.0

@haroonfarman571

Hi there, I have seen the screenshot attached for the XML files and their corresponding mp3 files. I understand that you are looking to map this data into SQL database to retrieve specific data as you like. I want to know how you will be requesting the data from SQL -Would you like to have a front end to retrieve the data from SQL? -Or you just want to map the data into SQL and the DB will be utilized somewhere else? I have got all the experience required to get it done. Lets connect and finalize it to start ASAP.

$600 CAD in 10 days