Midi into spreadsheets?

wws

Is there a way to get notes i play on a midi keyboard into a spreadsheet? Like if I am in a cell and play middle C, "C3" gets entered into the cell?

Maybe Bome for the MacBook or some other midi translator?

Thanks!

wim

Would it have to be realtime, or could something that simply converts a midi file to a format such as CSV that could be imported into the spreadsheet work?

McD

A Moziac script could log note names with comma separated values. Then you have to cut and paste that text into a file for import to a spreadsheet.

senhorlampada

@McD said:
A Moziac script could log note names with comma separated values. Then you have to cut and paste that text into a file for import to a spreadsheet.

That's an interesting idea

wws

@wim said:
Would it have to be realtime, or could something that simply converts a midi file to a format such as CSV that could be imported into the spreadsheet work?

Real time for me. So I could position a cell move and play into it, then change the position and play etc. Like a low budget tracker.

McD

@senhorlampada said:

@McD said:
A Moziac script could log note names with comma separated values. Then you have to cut and paste that text into a file for import to a spreadsheet.

That's an interesting idea

The logging facility in Mozaic is pretty useful and rarely used. I wish more people would buy the damn app so @Brambos might give us the occasional new feature like save log to file or a million other tweaks. It’s one of the most amazing pieces of software I own for creating virtual apps. It’s simply stunning to do what it can do without having to learn Swift, Objective-C, or C++.

I imagine there’s dozens that feel that way.

AlmostAnonymous

@McD said:
It’s one of the most amazing pieces of software I own for creating virtual apps. It’s simply stunning to do what it can do without having to learn Swift, Objective-C, or C++.

Mozaic is a giant reminder I should learn Swift, Objective-C, or C++

McD

@AlmostAnonymous said:

@McD said:
It’s one of the most amazing pieces of software I own for creating virtual apps. It’s simply stunning to do what it can do without having to learn Swift, Objective-C, or C++.

Mozaic is a giant reminder I should learn Swift, Objective-C, or C++

Good luck with that… call me in a couple years when you are ready to ship something.

AlmostAnonymous

@McD said:

@AlmostAnonymous said:

@McD said:
It’s one of the most amazing pieces of software I own for creating virtual apps. It’s simply stunning to do what it can do without having to learn Swift, Objective-C, or C++.

Mozaic is a giant reminder I should learn Swift, Objective-C, or C++

Good luck with that… call me in a couple years when you are ready to ship something.

It will be a lot quicker than a couple years and it wont be shipped but thanks for the encouragement!

McD

@AlmostAnonymous said:

@McD said:

@AlmostAnonymous said:

@McD said:
It’s one of the most amazing pieces of software I own for creating virtual apps. It’s simply stunning to do what it can do without having to learn Swift, Objective-C, or C++.

Mozaic is a giant reminder I should learn Swift, Objective-C, or C++

Good luck with that… call me in a couple years when you are ready to ship something.

It will be a lot quicker than a couple years and it wont be shipped but thanks for the encouragement!

Oh, if you don’t ship that’s a lot easier. Just for grins try the “AudioKit Swift” package and you’ll make something in a week or 2.
They prepared a video to walk you through install. Perhaps you’re past that point.

Now to the real question: what’s wrong with Mozaic? It’s an event driven model and that can really mess most scripters up.
It’s like playing ping-pong with a firehose of ping pong balls you must have a planned response for. You don’t really have control but with the right plan you can do some cool shit.

AlmostAnonymous

@McD said:

@AlmostAnonymous said:

@McD said:

@AlmostAnonymous said:

@McD said:
It’s one of the most amazing pieces of software I own for creating virtual apps. It’s simply stunning to do what it can do without having to learn Swift, Objective-C, or C++.

Mozaic is a giant reminder I should learn Swift, Objective-C, or C++

Good luck with that… call me in a couple years when you are ready to ship something.

It will be a lot quicker than a couple years and it wont be shipped but thanks for the encouragement!

Oh, if you don’t ship that’s a lot easier. Just for grins try the “AudioKit Swift” package and you’ll make something in a week or 2.
They prepared a video to walk you through install. Perhaps you’re past that point.

Now to the real question: what’s wrong with Mozaic? It’s an event driven model and that can really mess most scripters up.
It’s like playing ping-pong with a firehose of ping pong balls you must have a planned response for. You don’t really have control but with the right plan you can do some cool shit.

Nothing is wrong with mozaic. I love it. Theres just a lot more libraries to draw from in c++ land.

Edit: Plus I won't have to keep some old ipad in deepfreeze to keep some mozaic scripts running if the day comes mozaic is sunsetted

McD

It seems to work:

Mozaic Code:

@Description

   Log Notes in CVS format

@End

@OnMidiNoteOn

NoteStep = MIDINote % 12
NoteOctave = rounddown(MIDINote / 12) - 1

if NoteStep = 0
  log {C}, NoteOctave, {,}
elseif NoteStep = 1
  log {C#}, NoteOctave, {,}
elseif NoteStep = 2
  log {D}, NoteOctave, {,}
elseif NoteStep = 3
  log {D#}, NoteOctave,  {,}  
elseif NoteStep = 4
  log {E}, NoteOctave, {,}
elseif NoteStep = 5
  log {F}, NoteOctave, {,}
elseif NoteStep = 6
  log {F#}, NoteOctave, {,}
elseif NoteStep = 7
  log {G}, NoteOctave, {,}
elseif NoteStep = 8
  log {G#}, NoteOctave, {,}  
elseif NoteStep = 9
  log {A}, NoteOctave, {,}
elseif NoteStep = 10
  log {A#}, NoteOctave, {,}      
elseif NoteStep = 11
  log {B}, NoteOctave, {,}
endif

@End

Log output of some Note input when script is loaded:

C5,
B4,
A#4,
A4,
G#4,
G4,
F#4,
F4,
E4,
D#4,
D4,
C#4,
C4,
B3,
A3,
G3,
F3,
F#3,
G3,
G#3,
A3,
A#3,
B3,
C4,
C#4,
D4,
D#4,
E4,
F4,
F#4,
G4,
G#4,
A4,
B4,
C5,
D5,
E5,
F5,
E5,
D#5,
D5,
C#5,

Results of Mozaic “log” output pasted into Numbers:

![](https://forum.audiob.us/uploads/editor/fk/oy2u643c4dvc.png "

To place notes across a row we’d need to ask @Brambos to not place a Newline on every Log statement output.

McD

I do hope this hack sells a couple extra copies for those Spreadsheet addicts.

wim

@McD or simply ...

@Description
  Log notes in CVS format, one line per note
@End

@OnMidiNoteOn
  Log (NoteName MIDINote,YES), {,}
@End

McD

@wim said:
@McD or simply ...

@Description
  Log notes in CVS format, one line per note
@End

@OnMidiNoteOn
  Log (NoteName MIDINote,YES), {,}
@End

I knew you would do something like this… You read manuals. I’m going to update my script to add columns for Channel, Velocity, MIDI Note Number and System Time Stamp… I’ll let the spreadsheet macro writers make the formula for offset from Note 0. Wait… but the time @wim reads this he will post a version with “colors” or iPad snapshots or something truly magical I didn’t know was possible. He’s that good and really fast. If @_ki sees a use case like making a version that imports into some programmers XML Music format so Live MIDI could get into Staffpad reliably then we’re off to the future.

wim

I wasn't trying to one-up you @McD - I just figured if you or someone else was going to extend this, it'd be better to start off on the right foot. I won't be trying to do anything myself. Without any way to pipe the output anywhere it's no good for the OP's purposes anyway.

Now, wouldn't it be something if iOS had the ability to pipe std output to other apps like Linux and most other operating systems? That's never gonna happen though.

If I were looking into it, I would be looking first at using iDAM to pipe the MIDI to MacOS desktop where there are lots more potential ways to deal with it.

Poppadocrock

@senhorlampada said:

@McD said:
A Moziac script could log note names with comma separated values. Then you have to cut and paste that text into a file for import to a spreadsheet.

That's an interesting idea

Agreed.

AlmostAnonymous

Interesting take. Maybe I'll just add this into McD's Meesha script and open up my webshop on excelsheetz4u.com

McD

@wim said:
I wasn't trying to one-up you @McD

I know. Trust me, I’m used to it. I really don’t read manuals and I got through school without reading most of the text books too.
It’s a thing with me. Watch videos and keep pushing buttons in apps. People ask for manuals and I’m glad when they have to stoop to my level.

I just figured if you or someone else was going to extend this, it'd be better to get off on the right foot.

I do like it when someone cleans up my scripts and makes them usable. But they never write the manuals… slackers. No open except me will use an “app” without a manual.

I won't be trying to do anything myself. Without any way to pipe the output anywhere it's no good for the OP's purposes anyway.

We could ask @brambos for an update by just using his handle until he adds something to get us to STFU. You in?

Now, wouldn't that be something ... if iOS had the ability to pipe std output to other apps like Linux and most other operating systems.

“Pipes” and AUv3 app for tunneling text messages and sysex data.

That's never gonna happen though.

Never say never. THere are programmer’s out there that want to sell < 100 copies to avoid app maintance.

If I were looking into it, I would be looking first at piping the midi to MacOS desktop where there are lots more potential tools to deal with it.

This might be a job for “Visual Swift” to hack inter-species protocol stacks based on the Unix Read/Write File Semantics… send stuff until EOF.

wim

@McD said:
We could ask @brambos for an update by just using his handle until he adds something to get us to STFU. You in?

Nope. The farthest I've gone is to suggest that being able to read from and write to text files would be useful. I can completely see why he doesn't want to go there. I don't blame him.

Now, wouldn't that be something ... if iOS had the ability to pipe std output to other apps like Linux and most other operating systems.

“Pipes” and AUv3 app for tunneling text messages and sysex data.

That's never gonna happen though.

Never say never. THere are programmer’s out there that want to sell < 100 copies to avoid app maintance.

It's not up to developers. That would have to exist at the operating system level. There's no way I can convince myself that Apple will ever do that.

This might be a job for “Visual Swift” to hack inter-species protocol stacks based on the Unix Read/Write File Semantics… send stuff until EOF.

Not gonna take the bait on that one.

Anyway ... enuf thread-jacking. I'll leave you to your ideations. 👍🏼

AlmostAnonymous

@wws said:
Is there a way to get notes i play on a midi keyboard into a spreadsheet? Like if I am in a cell and play middle C, "C3" gets entered into the cell?

Maybe Bome for the MacBook or some other midi translator?

Thanks!

Exports to CSV:

https://hautetechnique.com/midi/midiview/

McD

@AlmostAnonymous said:

@wws said:
Is there a way to get notes i play on a midi keyboard into a spreadsheet? Like if I am in a cell and play middle C, "C3" gets entered into the cell?

Maybe Bome for the MacBook or some other midi translator?

Thanks!

Exports to CSV:

https://hautetechnique.com/midi/midiview/

Why can’t we gave the cool toys? Is it because we are too cheap? And this one is priced right for Mac and Windows… our favorite price: free. It’s intended to be a MIDI Monitoring app. Mozaic can make a cool MIDI Monitor with logging and I think there is one. I’ll wager @wim wrote it after reading some hacks terribly verbose code.

Listen, users don’t read code and know when 25 lines are being used when 3 do the job more efficiently. I’m with the users.
Don’t read code. Just paste it blindly into the code window and trust me.

McD

New version.

@ Description

 Log Notes in CVS format
 with a review and coding assist by @wim (infront of the whole class)

 NOTE: The log lists incoming notes in reverse time order. Must find a solution to reverse the order. Pyto script?
This code has yet to be subjected to adult supervision. Please fix it yourself if it’s not to your liking.

@End

@OnLoad

 log {"Channel"}, {,}, {"Command"}, {,},  {"Note"}, {,}, {"MIDINote"}, {,}, {"Velocity"}, {,}, {"TimeStamp"}

@End

@OnMidiInput

    Time = systemtime

    log MIDIChannel, {,}, MIDIByte1, {,},  (NoteName MIDINote,YES), {,}, MIDINote, {,}, MIDIVelocity, {,}, Time

@End

_ki

Sorry to be the bearer of bad news, but the whole idea of using Mozaics logging to generate csv won‘t work.

Moazic clears the whole log window when reaching a specific size, you never know exactly at which point this will happen. This is done to prevent overflow of the log buffer. It happens after about 100-150 lines, so Bram probabbly clears when reaching at a specific buffer text length.

Many of my scripts have optional, extensive logging - so i know this effect for sure. Just try the following script with AUM as host:

@OnLoad
  SetMetroPPQN 32
  tick  = 0
@End

@OnMetroPulse
  Log {Tick }, tick
  Inc tick
@End 

Open Mozaics log view, press play in AUM and wait some secs until the tick 200 is shown. Now stop AUMs transport and try to scroll back the console…. there are only about 100 lines in the buffer.

McD

@_ki said:
Sorry to be the bearer of bad news, but the whole idea of using Mozaics logging to generate csv won‘t work.

Moazic clears the whole log window when reaching a specific size, you never know exactly at which point this will happen. This is done to prevent overflow of the log buffer. It happens after about 100-150 lines, so Bram probabbly clears when reaching at a specific buffer text length.

Many of my scripts have optional, extensive logging - so i know this effect for sure. Just try the following script with AUM as host:

@OnLoad
  SetMetroPPQN 32
  tick  = 0
@End

@OnMetroPulse
  Log {Tick }, tick
  Inc tick
@End 

Open Mozaics log view, press play in AUM and wait some secs until the tick 200 is shown. Now stop AUMs transport and try to scroll back the console…. there are only about 100 lines in the buffer.

Well, imagine that. @Brambos manages the resources to insure Mozaic focuses on job #1: responding to MIDI events at the front door. He knows what he’s doing and unfortunately, other than upgraded IOS bugs he’s done. Still, it is amazing app… rock solid and stable. Throw MIDI at it with a firehose and it just works.

wim

Damn. There goes my dream of finishing my MIDI powered AI romance novel writing Mozaic script.
Somehow limiting it to smutty Haiku just isn't as satisfying.

McD

@wim said:
Damn. There goes my dream of making aMIDI powered AI novella writing script in Mozaic.

How about a “Magnetic Poetry” app using MIDI for word selection?

I’d pay the usual patchstorage fee for such a script: a hearty “cool beans”.

_ki

I only can offer kind of work-around to get midi into CSV on IOS only: Use a midi recorder capable of exporting to midi file (Atom, Helium, Midi Tape Recorder) and then write a python script making use of the MIDIFile v0.10 package to write to a CSV file. For pythonista, you need to download the source version of that package and copy the folders containing the sources - into the site-packages-3 folder of pythonista

I once looked into the possibility to have a python script serving a midi port - but (at that time) it wasn‘t possible to create new midi devices with Pythonista or Pytho.

wim

@_ki said:
I once looked into the possibility to have a python script serving a midi port - but (at that time) it wasn‘t possible to create new midi devices with Pythonista or Pytho.

I feel better about my own failed attempts at the same thing now.

On the other hand, if that data was sent to a MacBook via iDAM, python would be a distinct possibility.

zedzdeadbaby

wish I would have seen this earlier but if your still looking for both realtime and non, MY bestest of buddies the Ambient King Vir Unis about gosh maybe 12-15 years ago was commishoined by the City of Chicago for 2 projects.

1 Non realtime @ some Navy Pier event took the DnA sequences of diffetent flowers around the pier and converted it to midi to be played over loudspeakers.

2 Realtime on one of the CTA lines. departed from the city center and in realtime would parse the economic data of the very near surrounding homes and subdivisions all along the track to the cities outer limits. Basically showing the economic mapping of wealth closest to the center and all the flucuations out to the edges of city limits. Then made it into one Track. Extremely intresting to hear what the data sounds like.

Cheers