# Import sng song-file (Songselect)

**URL:** <https://quelea.discourse.group/t/import-sng-song-file-songselect/759>\
**Category:** Uncategorized\
**Created:** [December 29, 2021, 3:35am UTC](https://quelea.discourse.group/t/import-sng-song-file-songselect/759 "2021-12-29T03:35:08Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![\_jes](https://yyz2.discourse-cdn.com/free1/user_avatar/quelea.discourse.group/_jes/32/283_2.png) [@\_jes](https://quelea.discourse.group/u/_jes)\
**Post date:** [December 29, 2021, 3:35am UTC](https://quelea.discourse.group/t/import-sng-song-file-songselect/759/1 "2021-12-29T03:35:08Z")

</div>

Hi,  
i would like to import my songs trough the import function, i get my files from Songselect and its either a .sng or an -txt file, i would like to import the -sng file so the ccli number and so on are directly added in the corect field.

If somone could either show me an way to do it or lead me to where i maybe add a proper importer myself i would really appreciate that.

> **Example file**
>
> Name:
> 
> ```auto
> Above All.sng
> 
> ```
> 
> Content:
> 
> ```auto
> #LangCount=1
> #Title=Above All
> #Editor=ChurchTools
> #Version=3
> #Author=Lenny LeBlanc, Paul Baloche
> #CCLI=2672885
> #(c)=1999 Integrity's Hosanna! Music (Admin. by SCM Hänssler) / LenSongs Publishing (Admin. by Small Stone Media Germany GmbH)
> #VerseOrder=Verse 1,Verse 2,Chorus 1
> ---
> Verse 1
> Above all powers above all kings
> Above all nature and all created things
> Above all wisdom and all the ways of man
> You were here before the world began
> ---
> Verse 2
> Above all kingdoms above all thrones
> Above all wonders the world has ever known
> Above all wealth and treasures of the earth
> There's no way to measure
> What You're worth
> ---
> Chorus 1
> Crucified laid behind the stone
> You lived to die rejected and alone
> Like a rose trampled on the ground
> You took the fall and thought of me
> Above all
> 
> ```

(There is a “Presentation Manager” .sng importer but it is not compatible.)

---

<div class="post-metadata">

**Author:** ![DeeTigIT](https://avatars.discourse-cdn.com/v4/letter/d/74df32/32.png) [@DeeTigIT](https://quelea.discourse.group/u/DeeTigIT)\
**Post date:** [December 30, 2021, 7:03pm UTC](https://quelea.discourse.group/t/import-sng-song-file-songselect/759/2 "2021-12-30T19:03:21Z")

</div>

You could transform manually your .sng song file into a Plain Text file that can be imported by Quelea by using an editor like Notepad++. Make sure your text file is in the UTF-8 characterset.

> **Contents: Above All.sng.txt (Notepad++, UTF-8)**
>
> Title: Above All  
> Author: Lenny LeBlanc, Paul Baloche  
> Ccli: 2672885  
> Copyright: Integrity’s Hosanna! Music (Admin. by SCM Hänssler)  
> Year: 1999  
> Publisher: LenSongs Publishing (Admin. by Small Stone Media Germany GmbH)  
> Key:  
> Capo:  
> Notes:
> 
> Verse 1  
> Above all powers above all kings  
> Above all nature and all created things  
> Above all wisdom and all the ways of man  
> You were here before the world began
> 
> Verse 2  
> Above all kingdoms above all thrones  
> Above all wonders the world has ever known  
> Above all wealth and treasures of the earth  
> There’s no way to measure  
> What You’re worth
> 
> Chorus 1  
> Crucified laid behind the stone  
> You lived to die rejected and alone  
> Like a rose trampled on the ground  
> You took the fall and thought of me  
> Above all

 ![S1](https://global.discourse-cdn.com/free1/uploads/quelea/original/1X/10e767e4982defd02e10eaf6e27c6b18cc82a783.jpeg)

---

<div class="post-metadata">

**Author:** ![\_jes](https://yyz2.discourse-cdn.com/free1/user_avatar/quelea.discourse.group/_jes/32/283_2.png) [@\_jes](https://quelea.discourse.group/u/_jes)\
**Post date:** [December 30, 2021, 7:19pm UTC](https://quelea.discourse.group/t/import-sng-song-file-songselect/759/3 "2021-12-30T19:19:18Z")

</div>

I have about 150 songs where 50 are used regularly, i would prefer to automate that in some way.

---

<div class="post-metadata">

**Author:** ![\_jes](https://yyz2.discourse-cdn.com/free1/user_avatar/quelea.discourse.group/_jes/32/283_2.png) [@\_jes](https://quelea.discourse.group/u/_jes)\
**Post date:** [January 14, 2022, 7:16am UTC](https://quelea.discourse.group/t/import-sng-song-file-songselect/759/4 "2022-01-14T07:16:46Z")

</div>

Wrote a simple script that formats the songs in the right way to import.

Where can i close this topic?

---

<div class="post-metadata">

**Author:** ![\_jes](https://yyz2.discourse-cdn.com/free1/user_avatar/quelea.discourse.group/_jes/32/283_2.png) [@\_jes](https://quelea.discourse.group/u/_jes)\
**Post date:** [April 28, 2022, 10:12am UTC](https://quelea.discourse.group/t/import-sng-song-file-songselect/759/5 "2022-04-28T10:12:56Z")

</div>

So i got asked about the script i wrote, and it wasn´t really presantable.  
I now made it cleaner and also a little improvment.

The Code:

```auto
mkdir ./out/ -p
for file in ./*.sng
do

	tr -cd '\11\12\40-\176' < "$file" > "./out/$file"
	diff $file "./out/$file" -q
done
#https://www.sciencebuddies.org/science-fair-projects/references/ascii-table

```

And The Explonation:

```auto
Copy the script to the folder with the sng files and execute it.
There will be made a subfolder named out where the cleaned files are pasted.
If there is no output there where no caracters removed and your problem lies in a other place

```