Enjoy unlimited access to all forum features for FREE! Optional upgrade available for extra perks.

TAG List

Discussion in 'Nominet Tag Holders' started by seanc, Jun 26, 2007.

Thread Status:
Not open for further replies.
  1. seanc United Kingdom

    seanc Well-Known Member

    Joined:
    May 2005
    Posts:
    1,197
    Likes Received:
    6
    i have sent a request to the automation to request a full list of all the domains on my TAG.

    the reply from the automation is a bit of a mess, does anyone have a util or tell me how i can tidy this list up? (can i import to excel?)


    Domain Name List follows...
    Domain name|reg-status|tag|created|changed|expiry|first-bill|recur-bill|auto-bill|next-bill|dns0|dns0-id|dns1|dns1-id|dns2|dns2-id|dns3|dns3-id|dns4|dns4-id|dns5|dns5-id|dns6|dns6-id|dns7|dns7-id|dns8|dns8-id|dns9|dns9-id|account-id|registrant
     
  2. Domain Forum

    Acorn Domains Elite Member

    Joined:
    1999
    Messages:
    Many
    Likes Received:
    Lots
    IWA Meetup
     
  3. SF

    SF Well-Known Member

    Joined:
    Jun 2005
    Posts:
    7,543
    Likes Received:
    58
    copy the email from "Domain
    name|ips-key|created|first-bill|recur-bill|registrant|reg-contact|reg-tr
    ad-name|reg-type|reg-co-no|reg-addr|reg-locality|reg-city|reg-county|reg

    processed.|||||||||||||||||ns1.fastpark.net.|ns2.fastpark.net.|||||||||0
    |0|20070516|20090516


    ie. leave off the bottom text sayiong Number of domains in the list: 1076.

    put that in a new text file called list.txt

    ok open up excel

    then click on the open file thing top left

    select the text file you just created

    ought to pop up with 'text import wizard'

    ok, click next on that first screen

    then on the step two window ... it says delimiters

    currently has tab selected

    see where it says 'other;'

    tick other

    then in the box by that put |

    you will know you have the right one as it will adjust the preview below


    hit finish

    then its in the spreadsheet
     
  4. seanc United Kingdom

    seanc Well-Known Member

    Joined:
    May 2005
    Posts:
    1,197
    Likes Received:
    6
    unfortunately it hasnt imported it correctly,
    its only listed 27 domains out of 100's

    somthings wrong somewhere, i'll have a play :D
     
  5. seanc United Kingdom

    seanc Well-Known Member

    Joined:
    May 2005
    Posts:
    1,197
    Likes Received:
    6
    s0rted...

    i switched off text wrap in my Outlook


    (thanks DB)
     
  6. SF

    SF Well-Known Member

    Joined:
    Jun 2005
    Posts:
    7,543
    Likes Received:
    58
    oki mate no worries! :)
     
Thread Status:
Not open for further replies.