03-30-2025, 08:43 AM
After purchasing Mobile Sheets a few days ago for Windows 11 I have not been able to import records to my satisfaction. I have "populated" the data fields using semi-colons but the finished result was a mess. I started small with a dozen records trying different layouts. The MS database is empty now as I deleted everything.
There are over 47,000 members registered on this Forum so I'm hoping for some straightforward guidance to get me started. Mike has been very helpful but I need an idiots guide. I read the manual cover to cover and checked this forum. I'm sorry computer guys but I shouldn't need to be using for example, %name% etc, to organise my data or reading about "strings" - the coding itself should deal with this. My needs are simple at present - to enter sheeet music, lead sheets and chord sheets mainly for popular music. The format I want is not difficult: 2 or more lines of text with the option to add futher data if needed at a later stage.
After checking on another forum several weeks ago, the recommended approach was to create an Excel file and then save it in comma separated format. As I'm very familiar with Excel I made a start on my collection of sheet music books like: "The 50 Top Singles of All Time" I call these "collections". I have about 30 or so of these books representing several hundred songs. In addition I have several single artist sheet music books like Adele , 30 that I call "albums". Not all of my books have been digitally scanned as yet.
A finished record in the A-Z song list should look like this:
Against All Odds (Take A Look At Me Now)
Phil Collins pages 12-14 Ab BPM 116 The 50 Top Singles of All Time
(No commas, clear spacing and an option to add a time signature at a later date if necessary. I am aware that I can create a field(s) and hide it.
I got something like this at a third attempt but badly spaced, commas and the worse thing was calling up the title just brought me to the image of the music book cover for each of the 12 records so the pages data didn't work.
Has anybody got
Thank you in advance.
There are over 47,000 members registered on this Forum so I'm hoping for some straightforward guidance to get me started. Mike has been very helpful but I need an idiots guide. I read the manual cover to cover and checked this forum. I'm sorry computer guys but I shouldn't need to be using for example, %name% etc, to organise my data or reading about "strings" - the coding itself should deal with this. My needs are simple at present - to enter sheeet music, lead sheets and chord sheets mainly for popular music. The format I want is not difficult: 2 or more lines of text with the option to add futher data if needed at a later stage.
After checking on another forum several weeks ago, the recommended approach was to create an Excel file and then save it in comma separated format. As I'm very familiar with Excel I made a start on my collection of sheet music books like: "The 50 Top Singles of All Time" I call these "collections". I have about 30 or so of these books representing several hundred songs. In addition I have several single artist sheet music books like Adele , 30 that I call "albums". Not all of my books have been digitally scanned as yet.
A finished record in the A-Z song list should look like this:
Against All Odds (Take A Look At Me Now)
Phil Collins pages 12-14 Ab BPM 116 The 50 Top Singles of All Time
(No commas, clear spacing and an option to add a time signature at a later date if necessary. I am aware that I can create a field(s) and hide it.
I got something like this at a third attempt but badly spaced, commas and the worse thing was calling up the title just brought me to the image of the music book cover for each of the 12 records so the pages data didn't work.
Has anybody got
- An Excel example showing column headings with a few records or so
- An Excel CSV file that was generated from this showing whatever punctuation has been added
- An image of what the finished result looks like in Mobile Sheets
Thank you in advance.