Find Jobs
Hire Freelancers

XML editor app for Music Digital Distributor

$250-750 USD

Zaprt
Objavljeno pred približno 15 leti

$250-750 USD

Plačilo ob dostavi
About Loft01 Loft01 is a small and independent digital music distributor. We work with labels and artists and distribute their music to different music online stores such as iTunes, Beatport… We are based in Barcelona (Spain), therefore our main catalogue are local and national labels, but we also have some nice foreign labels. Basically our job is to encode and deliver content of our labels into the specs and technical requirements of the online stores we work with. Then we process the payments for each label, aggregating all the different sale reports of all stores. What we need: Each online store we work with has its own way of encoding and processing the audio and metadata from the catalogue we represent. The content is processed in two main areas: Audio and Metadata info from the albums and tracks. We encode the audio with the different specs of each store, some need WAV files, others mp3 at different beat rates (320 kbps, 192 kbps..) The metadata is processed mainly with excel: At Loft01 we have a metadata template that includes all the metadata and tag info from the different albums and tracks we encoded and are due to be delivered to the different stores. But the stores we send the content process these metadata via XML, each different store has its own XML specs and schemas. SO what they need is for us to send them an XML file matching their specs and schemas in order to do a mass ingestion of metadata in their system. What we need is to develop an application or method that uses an available XML processor (we can work with Altova XML) that converts our excel spreadsheet into XML files for each store we distribute too. We will provide our excel metadata template and some of the XML specs and schemas from some of the stores we work with. Therefore what you would have to figure out is a way that would automatically convert our excel template into the different XML schemas of the different stores we distribute to. I can send you a workflow of how the distribution and metadata processing works. Also I can send our excel metadata template and some of the XML templates and schemas of some of the stores. Please take into account that not all XML schemas are included, the system ideally should be able to integrate new XML schemas and templates from other online stores. The process ends when the online stores send us the sale reports. These reports are many times sent also with an XML format, the system ideally should be able to process such XML specs and transform them into Excel files. If you have further questions you can contact me at guillermo (at) loft01 dot com Thanks and looking forward to receiving your proposals and solutions. Employer Questions: (1) Solution that you would use to process the excel metadata with the XML specs of online stores. (2) Will this solution allow the inclusion of new XML specs? (3) Will the solution allow the invert process of ingesting XMl and transforming that info into excel or other docs?
ID projekta: 367280

Več o projektu

6 ponudb
Projekt na daljavo
Aktivno pred 15 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
6 freelancerjev je oddalo ponudbo s povprečno vrednostjo $475 USD za to delo
Avatar uporabnika
Dear Loft01, As I understand your request, you would like to build a system which can take your music track metadata currently stored in Excel xls files and transform it into the xml import formats required by the various stores. You would like to continue to use Excel xls files to edit and store the data, and would like to convert the data to an import format each time it is needed. Each of the stores has a different import format. The formats differ not only in what information is required, but also in how the information is broken up into fields, and how the fields are encoded. For example, in your Finetunes xls format, people in the same role are separated by semicolons in the same field, while in Rhapsody format each person is in a separate xml element. Examples of different encodings include dates, durations, genres, and territories. Therefore it is not practical to create a simple direct map between fields; instead, a converter for each import format is needed. From your reference to the Altova tool, I understand you are interested in using xml standard languages such as XSLT or XQuery. For this project I would use XQuery for the XML converters, since the project involves gathering tracks of an album, and writing some string manipulation functions to convert data formats. This project also needs a way to convert the xls files to and from an xml data format. A simple converter is easy to build with the Apache POI library in java, and then the more complex xml transformations can be done in XQuery. New xml import formats can be added with additional XQuery files. (The transformations can be reversed by writing XQuery files to do the inverse conversion and converting the result to xls; again, the formats are too different to make this a simple inverse mapping of fields.) Regards, Grammal
$400 USD v 10 dneh
5,0 (3 ocen)
3,0
3,0
Avatar uporabnika
Please see PM
$750 USD v 15 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
i did similar projects in the past. i will 100% satisfy u. view PM for details
$250 USD v 5 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
XML editor expert here Please check PM
$550 USD v 10 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
ve exp. on such projects converting XLSXML, Its doable
$400 USD v 20 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
I'm an expert in XML technologies and I did projects like this earlier.
$500 USD v 10 dneh
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava SPAIN
Barcelona, Spain
0,0
0
Član(ica) od jan. 7, 2009

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.