Domain Manage

Creating Domain Lists

Discussion in 'Domain Research' started by wb, Jun 6, 2011.

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

    wb Well-Known Member

    Joined:
    Mar 2009
    Posts:
    2,072
    Likes Received:
    34
    Looking to manage my custom domain lists better, but think I may be missing an obvious way of doing it...

    Currently, I'm just using an Excel file which I started on a few months ago and have been adding lists of domains to. Unfortunately it only holds just over 1 million records per sheet, and in addition to not being ideal for browsing all domains in one go, it's also starting to lag when loading as the file is only getting larger.

    The structure of the file and how columns can be sorted etc works fine, but ideally I would like something which can have more records on a sheet and faster running.

    Am I missing an easier way which everyone else is doing to create drop lists? Any suggestions? :)

    Cheers
     
  2. Domain Forum

    Acorn Domains Elite Member

    Joined:
    1999
    Messages:
    Many
    Likes Received:
    Lots
     
  3. dotNetFreak

    dotNetFreak Well-Known Member

    Joined:
    Jul 2009
    Posts:
    1,416
    Likes Received:
    25
    Probably overkill and not the easiest way, but you could install a copy of MySql and use something like Sql Manager for MySql from http://www.sqlmanager.net/en/products/mysql/manager.

    Import your Excel spreadsheet, learn a little SQL to create a few queries (or use the visual filtering/sorting tools) and then export the results back to Excel when you need them.

    I'm sure there are a) better ways and b) open source replacements to Sql Manager, but it is one way :)
     
  4. wb United Kingdom

    wb Well-Known Member

    Joined:
    Mar 2009
    Posts:
    2,072
    Likes Received:
    34
    Thanks for the reply :)

    Funnily enough I've just been playing around with phpMyAdmin for the past hour or so, trying to get it working how I want to. Managed to get domains imported from CSV without any problem, but the main annoyance seems to be sorting the date column by ascending/descending values (DD/MM/YYYY).

    For some reason, it doesn't seem to take into account the year, and only uses the day/month when sorting (i.e. if sorted from today it would display all 06/06/11 domains then 06/06/12 etc, rather than 07/06/11). Might not have explained that too well but hopefully it makes sense.

    Any more suggestions would be appreciated!
     
  5. JDubya

    JDubya Active Member

    Joined:
    Apr 2010
    Posts:
    94
    Likes Received:
    7
    What column type is your "date" field stored as?

    If stored as VARCHAR Mysql will not be sorting it as you would expect a DATE column.

    If you do just change the column type to DATE though it expects the format to be YYYY-MM-DD, but your csv format was DD/MM/YYYY.

    So if you change your csv formate to YYYY-MM-DD and import the data again, ordering should work if this column is set to DATE.
     
    • Like Like x 1
  6. wb United Kingdom

    wb Well-Known Member

    Joined:
    Mar 2009
    Posts:
    2,072
    Likes Received:
    34
    Ah, perfect I will give that a try.

    It was set to 'date' earlier but when it imported and didn't display the values, I set it 'text' without thinking of formatting the date values differently. :oops:

    Is a MySQL database the method that others creating/keeping lists use?
     
  7. monaghan United Kingdom

    monaghan Moderator Staff Member

    Joined:
    May 2007
    Posts:
    1,993
    Likes Received:
    45
    Are you managing lists for analysis / drop dates or a list of your own domains?

    For drop dates, then certainly a database is the route to go.
     
  8. wb United Kingdom

    wb Well-Known Member

    Joined:
    Mar 2009
    Posts:
    2,072
    Likes Received:
    34
    Analysis / drop dates :)
     
  9. monaghan United Kingdom

    monaghan Moderator Staff Member

    Joined:
    May 2007
    Posts:
    1,993
    Likes Received:
    45
    Definitely want to use a database, you can then run queries against the data to get the data presented filtered and sorted as you like. If you are a Nominet member and know a little bit of scripting you can easily hook this database to the DAC and update your relevant dates automatically to make the system self maintaining.
     
  10. wb United Kingdom

    wb Well-Known Member

    Joined:
    Mar 2009
    Posts:
    2,072
    Likes Received:
    34
    Yep, I'm a member but unfortunately know little about scripting (learning as I go along).

    At the moment I've been using Dale's DAC Research Tool to output data into a CSV then adding a new column of +92 days to get the drop date. Sounds like an automated system would work very well indeed though, so will definitely look into it.
     
Thread Status:
Not open for further replies.

Share This Page