# export
**URL:** https://community.mp3tag.de/t/export/5247
**Category:** Export
**Created:** [August 3, 2007, 9:17am UTC](https://community.mp3tag.de/t/export/5247 "2007-08-03T09:17:00Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@nelisje](https://community.mp3tag.de/u/nelisje)
#### Post date: [August 3, 2007, 9:17am UTC](https://community.mp3tag.de/t/export/5247/1 "2007-08-03T09:17:00Z")
here s the thing, im trying to get all my files into a mysql database and i have a script that will do the query for me, but i miss a couple of fields
i have these columns in the database:
track, artist, title, album, albumcd, genre, length, bitrate, type, filesize, filesizeinbytes
and the mte file has
$filename(txt)$loop(%\_filename\_ext%,%album%,%track%)
%track%--%title%--%artist%--%album%--%comment%--%genre%--%\_length\_seconds%-- here bitrate -- here filetype --%\_file\_size%--%\_file\_size\_bytes%
$loopend()
so, is there also a %option% to determine what type of file it is? all i need to know is or a file is mp3 or wma, and the bitrate.. i want this output type: '224 kbps VBR' or '160 kbps CBR'.
thanks
ps
would be possible to post a topic with all available %options% ? just the standard not the ifs..
---
### Author:  [@Mizery\_Made](https://community.mp3tag.de/u/Mizery_Made)
#### Post date: [August 3, 2007, 10:49am UTC](https://community.mp3tag.de/t/export/5247/2 "2007-08-03T10:49:23Z")
Click on Help - \> Contents -\> Configuration, Export
%\_bitrate% & %\_extension% would likely do the trick for you.
---
### Author:  [@nelisje](https://community.mp3tag.de/u/nelisje)
#### Post date: [August 3, 2007, 1:41pm UTC](https://community.mp3tag.de/t/export/5247/3 "2007-08-03T13:41:26Z")
thanks a lot 🙂
EDIT: %\_bitrate% kbps %\_vbr% doesnt seems to work with WMA files ...
---
### Author:  [@Mizery\_Made](https://community.mp3tag.de/u/Mizery_Made)
#### Post date: [August 3, 2007, 3:13pm UTC](https://community.mp3tag.de/t/export/5247/4 "2007-08-03T15:13:52Z")
Bitrate worked fine on the ONE wma I have, VBR didn't seem to. Can't be of much help, maybe Florian knows what's up?
---
### Author:  [@nelisje](https://community.mp3tag.de/u/nelisje)
#### Post date: [August 3, 2007, 3:52pm UTC](https://community.mp3tag.de/t/export/5247/5 "2007-08-03T15:52:00Z")
i mean that wma files dont show whether they are cbr or vbr, i do get the bitrate
and i have 1 mp3 which gives this:
8 --Jönssonligan --Novabase--Top 100 Best Techno 6--CD1--Dance--1210--32 kbps CBR--mp3--5,20 MB--5450211
which isnt right
the song isnt 1210 secs long and hasnt 32 kbps CBR
the song is 136 secs long and has 320 kbps (from wmp)
is this due the 'ö' ?? ( i have 1 song with this)
a song with a 'å' worked fine