What Music 1 Knowlege Can We Help You With?
Search for answers or browse our knowledge base.
< All Topics
Print
Connect M1 to PlayoutONE sql
0
0
Early versions of PlayoutONE use an Access database. Later versions use sql with a log-in and password required to connect Music 1 to the P1 sql file. Here’s what to do:
-
Categories
- Categories 101 - The Need To Know Basics
- Category - Rank Order Fix
- Category View Design
- Selection Categories
- Selection Category - Removing
- Shuffling Categories
- A Question About The Average Turnover Number
- Shuffling Categories - Update
- Allow Repeat Play After x-% of Tracks Have Played
- Can I Search For Songs From A Specific Year?
- Category Rotation Changes With Clocks
- Controlling the Tempo Mix
- Customizing the Start/End Date Columns
- Packets - No Rotation Prediction
- Help Me With My Rotations
- How can I change the way the 'date added' field is displayed?
- How Can I Make Some Songs By An Artist Play More Than Other Songs By The Artist?
- How can I set it so a song doesn't repeat for 14 days?
- How Do I Change The Fonts In My Categories?
- How Do I Change the Scheduling Order Of My Categories?
- Packets - How do I create a packet?
- How do I make a simple report that will show me the percentage of plays by Category? I want to see if my formatting is delivering 15% Hot Current, 20% Medium Current and so on.
- Packets? How Do I Use Them?
- Packets - When To Packet
- Packet Removal
- How does Title Separation work within the categories?
- I'm not seeing the rotation grid..says "category not included in any clock" or something like that for each category??
- On one of my rotation prediction charts, I've got some Orange squares mixed in with the normal Blue squares. What's up with that?
- On the Category Rules screen, I see: Maximum Number of Choices and an option to "set automatically." What exactly is that feature?
- Play By Percentage
- Play Number
- Play Number Option
- Power Oldie Rotation Evaluation - What To Look For
- Recycle Categories
- Removing Duplicates
- Shuffle and Shuffling Categories
- The Flip/Don't Flip Category Rule
- Play Number, Total Plays and Category Spins
- Play Number Explained In Detail
- Shuffle the HOT category weekly? Is that good to do?
- Categories 101
- Show all articles ( 26 ) Collapse Articles
-
Song Cards
- Song Cards 101
- Non-Music Cards
- Converting Tracks to the Other Card Type
- Importing and Merging New Song Data
- Merging Song Data onto MusicONE Song Cards
- Importing Audio Tag Data - Unique Titles
- Removing Duplicates
- Mass Change Sound Codes
- Mass Change Tempo
- Play Number Option
- Player Controller
- Change the Drive Letter and Path on Song Cards
- Scheduling Daily Voice Tracks and Rotators
- Total Plays Re-Set
- Can I Search For Songs From A Specific Year?
- Is there a way to go into a single Log after I've scheduled and check song roations?
- I'm playing two versions of the same song, a 'live' and a 'studio' recording. How can I make sure those two get separated and don't schedule too close together?
- Show all articles ( 2 ) Collapse Articles
-
Clocks
- Scheduling Rules - Basic Settings
- Over Ruled
- Adding Spot Break Units
- How do I add Spot Break Markers to my clocks?
- New Clock to Dayformat (Hour Clock Lineup)
- Clock Items - How To Mass Change
- Category Rotation Changes With Clocks
- Clock Rules - Female Separation
- Clock Rules: Separation vs Run
- Clock Rules Time/Content
- Controlling the Tempo Mix
- Format Clock - Clusters
- How To Delete A Format Clock
- Formatting Christmas with Music 1
- How can I put some empty space onto the clocks to make room for announcer talk?
- How can I schedule programs that are more than an Hour in length?
- Can I Schedule Some Hours With No Slow Songs At All?
- Formatting A Weekly Top 40 Countdown Show
- I'm not seeing the rotation grid..says "category not included in any clock" or something like that for each category??
- Linked Tracks - Advanced
- Linked Tracks - Hit Year
- Linked Tracks - Linking To Songs
- Linked Tracks - Video
- Managing Female Content
- Tempo / Transition Jingles
- TrafficONE Spot Breaks - Fixed Start Time Enabled
- How do I merge my commercials into M1?
- Importing Traffic Log Files
- Can I set it so the hour will never end with a song that has a “cold” ending?
- Importing Natural Log advertising logs.
- How Do I Tell M1 To Schedule An Item At A Specific Time?
- Show all articles ( 16 ) Collapse Articles
-
Formatting
- A Primer On Three Formatting Basics
- Linked Tracks - Linking To Songs
- Over Ruled
- Daylight Saving Time Shift
- Formatting Syndicated Shows - Wolfman Jack
- Voice Track - Auto Numbering
- Formatting Tempo'd Jingles
- Formatting Hit Year Stagers
- Formatting Hit Year Stagers - Second Option
- Format An Open Slot for DJ Choice
- Formatting No Repeat Workdays
- Linking Hit Year Intros and Stagers
- Linked Tracks - Video
- Announcers - Naming & Dayparting
- Adding Spot Break Units
- Adding Song Notes to the Log
- How to Schedule A Promo 3x's More Than the Others
- Scheduling Category Tracks vs Scheduling Rotators
- Platooning for Tempo Control
- Packets to Limit or Increase Airplay of Songs
- Play By Percentage
- I'm not seeing the rotation grid..says "category not included in any clock" or something like that for each category??
- Importing Traffic Log Files
- How Do I Schedule Day-Specific Jingles?
- How Do I Tell M1 To Schedule An Item At A Specific Time?
- How do I prevent a jingle which fades out slowly from being followed by a song where the artist starts singing immediately?
- We’re going to be running a 70s and 80’s Gold Program on weekends and I need to have a lot of songs from those years to schedule on Saturday night but I don’t want to have to move them out of their regular categories that are used during the week. Is there a way to have songs in TWO categories at the same time?
- Formatting A Weekly Top 40 Countdown Show
- Why would I want to merge the commercials into M1 when my automation system has its own merge function that does the same thing?
- How do I merge my commercials into M1?
- Show all articles ( 15 ) Collapse Articles
-
Artists
- Artist Separation - History, Theory and Music Radio Today
- Artist Separation - During Scheduling
- Artist Separation Setting
- Artist Separation From Previous Day
- Artist Separation Not Working
- Artist Separation Problem - Special Case
- Artist Separation Problem Investigation
- Artist Separation - Problem Investigation 2
- Artist Separation - Problem, But Not Every Day
- Mass Change Artist Genders
- Setting Default Genders
- Sorting "The" Artist
- What Are Double-Shots?
- Artist Grouping - Link One Artist to Another
-
Scheduling
- Scheduling Basics
- Scheduling Rules - Basic Settings
- Scheduling - Automatic Scheduling
- Scheduling in Automatic vs. Interactive
- Hybrid Scheduling System
- Scheduling In Automatic Mode
- Unscheduling
- Re-Schedule Hours or Delete a Log
- How To Search and Schedule a Song
- Importing Traffic Log Files
- Over Ruled
- Understanding Rule Violations When Scheduling - 2
- Alternative Categories
- Artist Separation - During Scheduling
- Can I get M1 to schedule one song every hour?
- Can I make M1 schedule exactly 60 minutes' content in the hour?
- Can I set it so the hour will never end with a song that has a “cold” ending?
- Artist Separation Problem Investigation
- Changing Font Preferences In Scheduling View
- Changing the Columns and Colors in the Scheduling View
- Counting "Song From Search" Plays
- Designing Templates for Printing Logs / Playlists
- Drag, Drop and Swap During Scheduling
- Editing Tip: De-glitching An Artist Separation Anomaly
- Flip Function - Category Refresher
- How can I change the Song Rotation Chart Settings?
- How can I get M1 to schedule the whole day without stopping for rule violations?
- How can I put some empty space onto the clocks to make room for announcer talk?
- How can I schedule programs that are more than an Hour in length?
- How Do I Change the Scheduling Order Of My Categories?
- How do I insert a specific non-music thing?
- How Do I Make Sure GOLD songs don't play within the same day part of the previous day?
- How do I prevent a jingle which fades out slowly from being followed by a song where the artist starts singing immediately?
- I had a song schedule today much sooner than it should. It is in a category with a 5 day turnover. What happened?
- I have a problem scheduling Female songs...
- I haven't made a log for today (I used an older one), now I need to schedule a playlist for tomorrow, but M1 will only do one for today's date...
- I'm scheduling a full day's worth of music, but my playout system always comes up short.
- I've got a category that has a 3 day turnover, but one song got scheduled twice within three hours. How did that happen?
- Artist Separation - Problem, But Not Every Day
- Linked Tracks - Advanced
- Log Dating Trick
- M1 keeps stopping as it schedules with the rule violation "Same Song Previous Day". What can I do to fix that?
- My "Dig" Button Is Not Working
- My "Last Played" Data Isn't The Same As the Song Rotation Chart
- One of my Currents just scheduled way sooner than it should, how come?
- Play Number Explained In Detail
- Playlist Hack - Use A Past Schedule on a New Date
- Quick Scheduling Pop Up Promos
- Rule Violation: Time
- Running Radio Remotely
- Scheduling A Non-Audio Unit
- Scheduling A Specific Track
- Scheduling A Year-End Top Hits Countdown
- Scheduling Countdown Shows
- Scheduling End-Dated Units
- Scheduling Stop With No Choices Showing
- Scheduling Two-For Tuesdays
- Scheduling With A "Search"
- See The Timing Boxes - Make The Taskbar Go Away
- Setting The Player Behavior
- Song Rotation Grid During Scheduling
- Song Search
- Song Swap and Move
- Tell me how the Title Separation rule works.
- The Updated QuickStart Manual
- View Only and the .ML File
- Viewing The Song Rotation Chart During Scheduling
- We’re going to be running a 70s and 80’s Gold Program on weekends and I need to have a lot of songs from those years to schedule on Saturday night but I don’t want to have to move them out of their regular categories that are used during the week. Is there a way to have songs in TWO categories at the same time?
- What does "Overplay" Mean?
- What's the Easiest Way to Manually schedule some Artist "Drops"?
- Artist Time Violation: What does that mean?
- Reconcile - Why I Don't
- Why Does M1 Stop As It Schedules?
- Why Doesn't M1 Search the Entire Category to Find A Song That Won't Violate One of My Formatting Rules?
- Stuck In View-Only And Recovering From It
- Including Spots in the Playout Schedule
- Errors Found During Load Message
- Understanding Rule Violations When Scheduling -1-
- Show all articles ( 63 ) Collapse Articles
-
Rotations
- A Question About The Average Turnover Number
- Can I get M1 to schedule one song every hour?
- Category Rotation Changes With Clocks
- Counting "Song From Search" Plays
- Daypart Rotation
- Help Me With My Rotations
- How can I change the Song Rotation Chart Settings?
- How can I set it so a song doesn't repeat for 14 days?
- How Do I Make Sure GOLD songs don't play within the same day part of the previous day?
- I had a song schedule today much sooner than it should. It is in a category with a 5 day turnover. What happened?
- I'm not seeing the rotation grid..says "category not included in any clock" or something like that for each category??
- Is there a way that I can check the average turnover of a SINGLE track?
- On one of my rotation prediction charts, I've got some Orange squares mixed in with the normal Blue squares. What's up with that?
- One of my Currents just scheduled way sooner than it should, how come?
- Other than by category scheduling, how can I control spins of individual (current) songs within a category?
- Play Number
- Power Oldie Rotation Evaluation - What To Look For
- Recycle Categories
- Song Rotation Grid During Scheduling
- Tell me how the Title Separation rule works.
- Viewing The Song Rotation Chart During Scheduling
- Show all articles ( 6 ) Collapse Articles
-
Rules
- Over Ruled
- Scheduling Rules - Basic Settings
- Category Rules - Refresher
- Clock Rules: Separation vs Run
- Clock Rules Time/Content
- Clock Rules - Female Separation
- Tempo Flow Rules
- Tempo / Transition Jingles
- Title Separation Rule
- The Flip/Don't Flip Category Rule
- Common Rule Violation Notices
- Rule Violation: Time
- Allow Repeat Play After x-% of Tracks Have Played
- Artist Separation - History, Theory and Music Radio Today
- Artist Separation From Previous Day
- Artist Separation - Problem Investigation 2
- Artist Separation Not Working
- Can I Schedule Some Hours With No Slow Songs At All?
- Controlling the Tempo Mix
- Daypart Rotation
- How Do I Make Sure GOLD songs don't play within the same day part of the previous day?
- How do I prevent Fast and Slow songs from scheduling next to each other?
- How To Mass-Change / Mass-Apply Hour Restrictions
- I'm a bit confused about Sound Codes. What should mine be?
- M1 keeps stopping as it schedules with the rule violation "Same Song Previous Day". What can I do to fix that?
- Managing Female Content
- I have a problem scheduling Female songs...
- On my finished schedule, every song is showing in red (violations) font. What does this mean?
- On one of my rotation prediction charts, I've got some Orange squares mixed in with the normal Blue squares. What's up with that?
- Understanding Rule Violations When Scheduling -1-
- Understanding Rule Violations When Scheduling - 2
- Artist Time Violation: What does that mean?
- Tell me how the Title Separation rule works.
- Tempo Rule Problem
- Tempo'd Jingles
- What does "Overplay" Mean?
- Rule Violation: Artist Period. What does that mean?
- Some Rules to Disengage in SE Version 7
- Show all articles ( 23 ) Collapse Articles
-
Rule Violations
- Understanding Rule Violations When Scheduling -1-
- Understanding Rule Violations When Scheduling - 2
- Common Rule Violation Notices
- Rule Violation: Time
- On my finished schedule, every song is showing in red (violations) font. What does this mean?
- Artist Separation - During Scheduling
- Rule Violations - Artist Separation
- Artist Separation Not Working
- My "Last Played" Data Isn't The Same As the Song Rotation Chart
- Products and Product Rules
- Rule Violation: Song Prev Day
- Tempo Rule Problem
-
TrafficONE
- A TrafficONE Demo Video
- Convert a Non-Music Card To a Spot Card
- Importing Advert Schedule From TrafficONE
- TrafficONE - Agency Billing
- TrafficONE - Entering Complicated Ad Orders
- TrafficONE - Formatting a News Sponsorship Order
- TrafficONE - Mass Delete Old Orders
- TrafficONE - Order With Different Rates
- TrafficONE - Product Separation
- TrafficONE - Scheduling Spots 2 to 1
- TrafficONE - Scheduling Spots for Specific Hours
- TrafficONE - Splits
- TrafficONE - Spot Break Insert/Fill Function
- TrafficONE and Avail Types
- TrafficONE Spot Breaks - Fixed Start Time Enabled
- TrafficONE User Manual Being Updated
- TrafficONE User Manual Update
- TrafficONE- Auto Fill With Only One Spot
- TrafficONE- Break Balancing
- TrafficONE- Convert Tracks
- TrafficONE- Packets
- Show all articles ( 6 ) Collapse Articles
-
Importing Data
- Importing Library Data From Text Files
- Click-and-Hear Auditioning
- Converting Tracks to the Other Card Type
- Edit mp3 Tags - How to
- Importing and Merging New Song Data
- Importing Audio Tag Data - Unique Titles
- Importing Data from Mp3Tag software
- Importing Data From WideOrbit
- Importing Song Data From Mp3 Tags
- Meta-Data Editing with Mp3Tag
- Re-Importing Library Data
- Using MediaMonkey To Edit mp3 Tags
- When I import from a .csv, not all of the records are imported.
- Folders vs Categories
- What's the best way to name my audio files?
- Mp3 Tags - Explained
- Importing Natural Log advertising logs.
- Importing from Simian
- AudioVault Flex - Exporting and Importing into M1
- Show all articles ( 4 ) Collapse Articles
-
Automation Systems
- All Installed Automation System Outputs
- Audio Folders
- Audio folders for Internet Radio
- AudioVault Flex - Exporting and Importing into M1
- Automation - Rivendell
- Automation / Playout System Selection
- Automation Format Selection
- Automation General Tab
- Can I use M1 with StationPlaylistStudio?
- Cloud Storage - Log Folders
- Dadpro Log File and Player Command Setup
- Date Fields In Automation Log Formats
- Enco Digilink Output For Multiple Streams
- Folders vs Categories
- Hard Syncs and Soft Syncs for StationPlaylist Creator
- I'm Using the Jazler Automation System. How Do I Configure M1 To Work With it?
- Importing from Simian
- Importing Data From WideOrbit
- WideOrbit - WorkFlow Commands
- WideOrbit Time Updates
- Jazler Commercial Breaks
- Log Folder
- M3U Playlists
- Player Commands
- Player Commands - Overview
- Player Commands 2
- Player Commands For StationPlaylist Creator
- Proppfrexx Event Type Customization
- RadioDJ - Hourly Playlists
- Re-Importing Library Data
- Reconcile - Why I Don't
- Rivendell Connection
- SAM Broadcaster - PAL Scripts
- SAM Broadcaster - Moving to Music 1 Scheduling System
- SAM Broadcaster Timing Issues
- Simian Commands in Music 1/Professional
- Skylla Commands
- StationPlaylist Creator Log Importer Settings
- StationPlaylist Creator Setup
- System Settings - Automation Params
- Using Player Commands
- Which automation systems does M1 work with?
- We're switching from our old automation system to SS32, what do we need to do with M1 to get it to work with the new system?
- Show all articles ( 28 ) Collapse Articles
-
PlayoutONE
- Connect M1 to PlayoutONE sql
- PlayoutONE - Import Settings
- PlayoutONE - Importing Types
- PlayoutONE - MusicONE Connections
- PlayoutONE Commands - Hard and Soft Syncs
- Importing and Not Importing from PlayoutONE
- Formatting Daily Voice Tracking for PlayoutONE
- PlayoutONE - Adding Voice Track Markers
- PlayoutONE - Disconnecting M1 To Work Remotely
- PlayoutONE - Log Notes
- PlayoutONE - Voice Tracking Future Hours/Days
- PlayoutONE and Music 1 On Separate Computers
- PlayoutONE Processsor Settings
- PlayoutONE Time Update Player Commands
- Switching To PlayoutONE From Another System
- Add Social Media Posts to PlayoutONE
- PlayoutONE - Music 1 Setup
- Show all articles ( 2 ) Collapse Articles
-
System Settings
- Backup And Restore
- Automatic Shutdown
- Automation Format Selection
- Automation General Tab
- Canadian Content
- Lost Database Recovery
- Multi-User Mode Passwords
- Multi-User Update
- Restore From Backup
- System Settings - Automation Params
- System Settings - Insert Tab
- The Music 1 Player Isn't Working
- Version 7 Keeps Closing On Me
- Restoring M1 Library data from a zip archive
- Spam & Phishing
- Click-and-Hear Auditioning
- Using Dropbox with M1
- Log Folder
- I see I've got about five years worth of old log files in my M1 Logs folder. What's the best way to delete them?
- Another Way to Backup Your M1 Database
- Show all articles ( 5 ) Collapse Articles
-
Reports
- Report Design
- BMI, ASCAP and SoundExchange Reports
- SoundExchange Reporting
- NPR/SoundExchange Report
- Category Statistics Report
- Design a Weekly Spins Report
- How Do I Create A "Spins" Report
- Reports - Exporting to CSV
- Print a Playlist
- Printing to PDF
- Printing PDF Playlists for Announcers
- Can I Print a Playlist To PDF? And, Can I Make It In Color?
- Printing List of Most Recent Adds
- Artist Content Report
- Song Plays Report
- Track Plays Report
- Make A Report Showing Average Tempo's, Genders, Sound Codes
- Is there a way that I can go into a single LOG after I've scheduled it and check the rotations?
- Merging Song Data onto MusicONE Song Cards
- How do a get M1 to print the playlist in color?
- Track Plays Report
- How do I make a simple report that will show me the percentage of plays by Category? I want to see if my formatting is delivering 15% Hot Current, 20% Medium Current and so on.
- Show all articles ( 7 ) Collapse Articles
-
Radio Stuff
- Artist Separation - History, Theory and Music Radio Today
- Artist Trivia Pop-up
- Genesis of the Music Scheduler
- Music Information Site
- Principles of Music Radio Formatting
- Production Service & Monitoring Service
- The New Cirrus Player from SecureNet
- The RodeCaster Pro
- What Is A Format?
- Products Old and New
-
Installation
- Installing Music 1
- Music 1 on a network...Multi-User Mode
- Moving Music 1 to Another Computer
- Using Dropbox with M1
- "error initializing audio reader"
- Audio Folders
- Automation Format Selection
- Automation General Tab
- Can I Run Music 1 On A Network From Different Computers?
- I see I've got about five years worth of old log files in my M1 Logs folder. What's the best way to delete them?
- Do you have a version for the Mac?
Table of Contents
