Creating Domain Lists

[wb]

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

 

[dotNetFreak]

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

 

[wb]

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!

 

[JDubya]

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.

 

[wb]

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.

Is a MySQL database the method that others creating/keeping lists use?

 

[monaghan]

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.

 

[wb]

Analysis / drop dates

 

[monaghan]

Analysis / drop dates

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.

 

[wb]

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.

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.