| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Miss Spunky
   |
Posted - 2010.03.20 11:46:00 -
[1]
Is there a way to export a corps current memeber list to excel format?
All that I really need is member name & date joined. This would be amazingly helpful and would save me a load of typing 
|
Desmont McCallock
|
Posted - 2010.03.20 15:28:00 -
[2]
I need to know what Excel version you are using, in order to provide you a step by step guide?
|
Miss Spunky
|
Posted - 2010.03.20 16:20:00 -
[3]
Excel 2007
|
Johnathan Roark
Caldari
The Graduates
Morsus Mihi
|
Posted - 2010.03.21 23:52:00 -
[4]
Under EVE Insider, My Character, click on your character. There is a link that says Member Auditing. Download that, open in excel. Not very hard as long as you don't need it to auto update.
POS-Tracker 3.0 Hosting |
Desmont McCallock
|
Posted - 2010.03.22 22:05:00 -
[5]
If you want to have an update-able xls file, follow this steps.
1. Open Excel with a blank sheet.
2. Select "Data" Tab.
3. Select cell A1 (assuming you want the data queried to begin from that cell).
4. Select "From Other Sources > From XML Data Import".
5. In "Filename" address bar type: http://api.eve-online.com/corp/MemberTracking.xml.aspx?userID=(your userid)&apiKey=(your full apikey)&characterID=(your characterId).
6. Click "Open". (Excel will query the server at this point)
7. Press OK (assuming you want the data to begin from that cell).
Now every time you want this list to update, you only have to click the "Refresh All" button in the toolbar.
|
Elrianmk2
Gallente
|
Posted - 2010.03.25 09:54:00 -
[6]
Edited by: Elrianmk2 on 25/03/2010 09:57:55
CharacterID== character name? if not where do we get this?
[Edit] Doh, nm, just remembered you can get it from the xml export, nevermind
If it wasnt for bad luck, i wouldnt have any luck at all |
Tonto Auri
Vhero' Multipurpose Corp
|
Posted - 2010.03.25 11:10:00 -
[7]
 Originally by: Elrianmk2
Edited by: Elrianmk2 on 25/03/2010 09:57:55
CharacterID== character name? if not where do we get this?
[Edit] Doh, nm, just remembered you can get it from the xml export, nevermind
You can get it from API directly.
--
Thanks CCP for cu |
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |