Switch to full style
Discussions about Coollector.
Post a reply

Database in Excel

Mon Jan 23, 2012 4:55 pm

Hi,
Am I able to get hold of the movie database in excel so I can do a lookup from another database?

Thanks,

Ed

Re: Database in Excel

Mon Jan 23, 2012 5:01 pm

I'm not sure that I understand what you're trying to do, please give me more details.

Re: Database in Excel

Tue Jan 24, 2012 5:23 pm

I thought I would keep it simple by keeping it vague but was obviously a bit too vague....

So basically I have a large database full of data, some of the data is movie titles, some are other superfluous entries. I want to find out which are the movie titles.

I want to do this by cross referencing/ looking up against a database of movie titles.

Hope that explains...

Re: Database in Excel

Tue Jan 24, 2012 5:39 pm

ed.navas wrote:Hope that explains...

Yes, now I understand.

Unfortunately, our movie database isn't standard, and only our program can read it.

Re: Database in Excel

Tue Jan 24, 2012 8:11 pm

Thanks for the prompt response Hector. Is there no way to get a data dump of just titles in excel or as a .txt file?

Re: Database in Excel

Tue Jan 24, 2012 8:53 pm

A data dump of just titles as a .txt file ?

If that's all you need, yes, it's possible.

You just display the list of all the movies (in the order that you want) and press the "print list" button.


P.S: the current version has a bug with the alphabetical order.

Re: Database in Excel

Wed Jan 25, 2012 10:54 am

Great I'll give it a try!
Post a reply