Import Events Data Quickly from Text File via URL Arguments

So I’m not sure how to tackle this yet, but I would like some assistance if possible to help reduce time and increase the speed at which I can enter information.

I have been collecting various “advertisments” for events from magazines for a while now, and some of these can include many dates at different locations.

At the moment, I can of course, just add these into MusicBrainz one at a time, typing in the text manually but it’s a long process and my hands begin to hurt eventually.

My idea would be for me to input a lot of this data into some kind of text-file like a csv/JSON/XML which a script of some-sort could read through, and then insert into the MBz Event submission form/create a URL with arguments with the values mostly (if not all) pre-populated, allow me to check all is good and hit the submit button.

Here’s an example of an advertisment with many dates:

I know that when you’re on an artist page you can click Add Event URL and the URL is formed like this:
https://beta.musicbrainz.org/event/create?rels.0.target=e0195400-ad63-4a21-8d56-9a96647cb24e

This pre-populates the linked artist (you just need to then choose the relationship)… but I am wondering if there are more things I can add to this URL to populate things like the Name, Type, Date and Location?

Many thanks in advance

3 Likes

Yes, you can: Log In - MusicBrainz

It is possible to seed all fields of all entity types’ editing forms, yambs does support artist, labels, releases, recordings and works so far:
https://yambs.erat.org/#source=text

You could ask @derat to add support for seeding events if you don’t want to build these URLs by hand :slight_smile:

3 Likes

If you are adding details from an advert like that, I would also (approx) date of the advert source when adding. Sometimes tour dates get rearranged\postponed so would be handy to note how far in advance the advert flyer was.

I had a tickets for gigs in 2020 which ended up happening in 2022…

2 Likes

Sure, that doesn’t seem too hard to add. I’ve filed https://github.com/derat/yambs/issues/27; I’ll probably be able to look at this today or tomorrow.

3 Likes

Thanks :smiley: that would be suuuuuper duper helpful :smiley:

1 Like

A-ha thanks, is there a document that gives all of the field names (i.e. “edit-event.name”)?

Yep I am aware of that problem. I will often go back and mark an event as cancelled if its date is marked as so in a later publication or update the date if a revision is made.

Of course I am working here with very old data, so knowledge of such amendments will only come to light if someone bothered to make a record of it (sometimes it won’t be in the same publication, I’ve seen amendments listed in the daily/weekly local newspaper for example)

2 Likes

I assume you know this site: WorldRadioHistory: Radio Music Electronics Publications ALL FREE I use that a lot for issues of Music Week. All kinds of gems on there.

One thing for the wish list - wouldn’t it be great if we could put these images on the CAA as part of the edit notes. Or even better if Events got the ability to include artwork like this.

1 Like

I did not, and here I am being a mug and buying magazines (and also there’s a few music mags on Internet Archive [Smash Hits, Muzik] + Google Books)

Yep, I’d love that, I think I mentioned it previously. The suggestion was to upload the advert/poster/flyer seperately and then just link it but it didn’t look very nice.

1 Like

Not a real document, but once you have understood the basic principle, you can find the field names with the browser’s “Inspector” tool:

1 Like

Cool, thanks for the pointer!

Sure thing! I think that this should be working now.

Here’s some example input that can be entered at https://yambs.erat.org/#source=text&textFormat=csv&textType=event to seed two concerts for MusicBrainz Test Artist with different places:

Values to set on all entities:

type=1
rel0_target=7e84f845-ac16-41fe-9ff8-df12eb32af55
rel0_type=798
rel1_type=794
edit_note=info copied from poster at https://example.org/foo

Input fields:

name,begin_date,end_date,time,rel1_target

Input:

Some Concert,2021-03-24,2021-03-24,20:00,8b162dca-51f0-40b3-860a-d109d5128c3c
Another Concert,2021-03-25,2004-03-25,21:00,f4fe8c21-2219-43e7-a9a7-db67b70c3404

Don’t hesitate to let me know if you run into problems or if it doesn’t make sense!

2 Likes

I am constantly using Music Week as it is UK industry press. So if you know the rough week somethings was released, you can find the table in there of “this week’s releases”. Or even better the write-ups and reviews.

The funny part I find is seeing the artists they missed… the ones who got huge but barely got a few lines at the time.

So you don’t want to know that old editions of Melody Maker are on there… Far too much gig info in there. I downloaded a random issue which had some scruffy people on the cover doing a “Magical Mystery Tour”…

But online PDFs can never beat the feel and smell of real magazines…

1 Like

Oooh so excited to test out @derat’s importer!!

It looks like it doesn’t seed artists, which is probably the bulk of the work for events, or am I mistaken?

Please feel free to bang this drum with me :blush:

17 votes and counting

it’s working well so far, just did 10 in the time it would probably take me to do 2.

I’m not sure exactly what needs to happen, but as I’m doing lots of events for the same artist my CSV just uses the MBID for their entity over and over :slight_smile:

1 Like

Do you mean artist-to-event relationships like “main performer” or “support act”? Those seemed to be working in my limited testing (and it’s demonstrated in the example I posted above – I set a single relationship with the same artist for both events, but you could specify different relationships for each event instead). If you specify an artist name instead of an MBID, the search field will be seeded.

Let me know if there’s some other sort of artist seeding that I missed.

1 Like

Thanks @derat, I’m traveling so I hadn’t actually tried yet, just looked at your examples! Impressed by your quick work on this :muscle:

1 Like