Help with importing songs

I have a database of about 1,000 songs I'd like to import into Proclaim. I currently have most of them in an SQLite database and am happy to write a script to create an import file. I know there's an import facility, but I don't know the input spec to be able to create an import file.

In an ideal world, I'd want to import the following fields:

Title
Lyrics
Attribution
Hymn Number

MediaShout have a demo export file which looks very simple. Can I just use that format, and not worry about fields I don't have? What field would I use for Hymn Number?

Also, what would happen if some of the songs already existing in the database?

Find more posts tagged with

Comments

Scott Alexander

You can use the MediaShout format if that's convenient. The required fields for this format include Title, Author, Copyright, and CCLI

Also, what would happen if some of the songs already existing in the database?

If a song with the same title already exists it will be overwritten.

Mark Barnes

https://community.logos.com/discussion/comment/901737#Comment_901737

What's the field name for the hymn number?

Jordan Sjodin

https://community.logos.com/discussion/comment/901744#Comment_901744

Its called Hymnal

Like this

Hymnal: 1

Mark Barnes

https://community.logos.com/discussion/comment/901744#Comment_901744

Thanks.

Mark Barnes

https://community.logos.com/discussion/comment/901737#Comment_901737

The required fields for this format include Title, Author, Copyright, and CCLI

Thanks for this. I've been able to run a test import successfully.

One minor point: if you miss out the CCLI field, you get a very confusing error: "[No atttribution]". I spent a long time wondering what was wrong with my author field as a result of this error message.