I see...
Basically when you open the BAT spreadsheet it only shows the dev name/description columns.
This is not enough for an import. The idea is that the template contains standard configuration, and you override those configuration elements as required using BAT. If you just have device name and description, all the resulting phones will have identical configuration, and you haven't specified Directory Numbers for the phones.
What you need to do is:
1) Download bat.xlt from Upload/Download under Bulk Admin. Open bat.xlt. If you are on a modern version of Excel, watch for a message saying Macros are disabled like so:
If you see that, you must enable the macro by clicking options or going into the security settings in Excel.
2) Once that's done, you can click on 'Create File Format'. This presents a dialog that allows you to specify fields to include. At a minimum you would typically include a 'Directory NUmber' (i.e. extension number).
3) In your Phone Template, I would normally call the line 'Standard' where you would normally enter a DN. When you use the BAT export with a file containing a 'Directory Number 1' column it will default to getting all the properties you set on the template, but creating a directory number for each phone as you list the DNs in the sheet.
You may also want to add CSS or Line CSS to the sheet to insert different calling restrictions per user, or Display to insert display names etc etc. Play with it:-)
Aaron
