| An easy alternative method for importing songs from
Excel is with "Copy" and "Paste Append". Here's
how:
1. Set up your Excel spreadsheet so the songs have
the following column headings:
| Title |
Artist |
Manu |
DiscNo |
TrackNo |
(Note: If you've exported a songbook from KJ Pro,
it will have a column called "Description".
Rename this column to "Manu". If there is
already a column called "Manu" in addition
to the Description column, delete the "Manu" column
and rename "Description" to "Manu".
Sorry, this is a quirk in the program.)
2. Select the range of songs you want to copy, including
the column headings in your selection. (KJ Pro needs
these to match up with the fields in the program.)
Use "Control+C" to copy them to the Windows
clipboard (or "Edit" - "Copy").
3. Open KJ Pro and open the custom songbook you want
to copy the songs to by clicking "View/Filter" under
Custom Songbooks. Select your custom songbook from
the drop-down box. Then click on the "Add Songs" button
on top of the window.
4. Click the "Paste Append" button on top
of the Window. Your Excel songs should be pasted from
the Windows clipboard into your custom songbook.
|