Yeah, I left out a word there. Programs like Excel or the free Excelviewer can do the job for you. Sorry, but I'm very web security conscious, so I have a policy of keeping my phone number (and other personal information) off the internet. So we'll need to do this by email.
Sent from my HAL 9000 in transit to Jupiter -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Joe Giovanelli Sent: Friday, May 14, 2021 6:07 PM To: QWS list <[email protected]> Subject: Re: QWS List program and bank assignments and spread sheet Hello, Nicole, I understand much of what you wrote here. I do not yet know how to start the process. You wrote: What you need: A spreadsheet that'll read the file Microsoft Notepad An instrument definition file to make sure you're getting the format right. Obviously a spread sheet isn't a program. Looks like there's supposed to be a program which can work with a spread sheet, and I do not know what that is. Is there a possibility that we could talk on the phone and work with me to create the instrument list? We could exchange phoneoff list if desired. At my age opf 92, I'm pretty sure I'll need some assistance. I sincerely thank you for your interest. Joe G. On 5/14/2021 3:14 PM, Nicole Massey wrote: > I used to do this all the time. It's been a while, though my explanation is > on this list somewhere. > What you need: A spreadsheet that'll read the file > Microsoft Notepad > An instrument definition file to make sure you're getting the format right. > Chances are good what they sent you will have the bank, program, and patch > name, and most likely it'll be in different columns. > You need to add the MIDI channel for each program, which goes first. So the > order is MIDI channel, Bank, Program Number, Program name. > If you're using a multi-timbral instrument that'll play on all 16 channels > (with channel 10 doing drum sounds) you can use a MIDI channel of -1 for the > normal programs and 10 for your drum maps. > So get things set up so it matches the structure above. While you're doing > this, go through the program names and look for odd characters, because some > will cause the file to stop returning information when encountered. When > you've got your table set up, open a notepad session and also open the > definition file you've selected as an example. > Press Control+End to get to the last cell in your table in the spreadsheet. > Then press Control+Shift+Home to select everything. Press Control+C to copy > everything in the spreadsheet. > Go to Notepad, and use Control+V to paste the table in. Go to the top and > highlight the first tab and the numbers surrounding it, which will probably > be a 1 from the MIDI channel and a 0 from the bank. Press Control+H to open > the find and replace. Control+V to paste the numbers with the tab in the > middle into the find box, then delete both numbers so only a tab is in that > box. Press the tab key to get to the replace box and type a comma. Tab down > to Replace all and hit the spacebar. It may take a moment to get through > everything. Give it a bit of time then press Cancel and you should find > everything separated by commas instead of tabs. Go back to the top and copy > the format header and instrument name line from the other definition file, > changing any instrument references to the synth you're referencing in the new > file. Save it, using the QWS instrument definition list naming protocol. Open > QWS, load it, and check that it works. If you get an error you've stumbled > somewhere or one of those illegal characters snuck past you and you'll have > to find it. > Hope this helps. > Sent from my HAL 9000 in transit to Jupiter > > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Joe > Giovanelli > Sent: Friday, May 14, 2021 12:32 PM > To: QWS list <[email protected]> > Subject: QWS List program and bank assignments and spread sheet > > Good Afternoon, > > > > > I recently purchased a Medeli SP-4200 keyboard. The piano nand other sounds > are quite ngood. > > > > > The manual did not have the program and bank assignments so I emailed Medeli > and nI immediately received nthe informationn but it was on a spread sheet. I > was able to read a bit of the data but how can this be used to make an > instrument list? > > > > > > I asked them for a different file format but all they did was resend the same > file. I have to think they do not speak good English. > > > > > This is very disconcerting as you can imagine. I hope someone has a thought > as to what I can do. > > > > > Thank you for reading this. > > > > > Joe Giovanelli, W2PVY > > > > To unsubscribe or change list options, see http://lists.andrelouis.com > > for archived list posts, see http://www.mail-archive.com/[email protected] To unsubscribe or change list options, see http://lists.andrelouis.com for archived list posts, see http://www.mail-archive.com/[email protected] To unsubscribe or change list options, see http://lists.andrelouis.com for archived list posts, see http://www.mail-archive.com/[email protected]
