coollector.com
https://www.coollector.com/

Database in Excel
https://www.coollector.com/viewtopic.php?f=1&t=866		 Page 1 of 1
Author:  ed.navas [ Mon Jan 23, 2012 4:55 pm ]
Post subject:  Database in Excel
Hi,
Am I able to get hold of the movie database in excel so I can do a lookup from another database?

Thanks,

Ed
Author:  (cool) Hector [ Mon Jan 23, 2012 5:01 pm ]
Post subject:  Re: Database in Excel
I'm not sure that I understand what you're trying to do, please give me more details.
Author:  ed.navas [ Tue Jan 24, 2012 5:23 pm ]
Post subject:  Re: Database in Excel
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...
Author:  (cool) Hector [ Tue Jan 24, 2012 5:39 pm ]
Post subject:  Re: Database in Excel
ed.navas wrote:
Hope that explains...

Yes, now I understand.

Unfortunately, our movie database isn't standard, and only our program can read it.
Author:  ed.navas [ Tue Jan 24, 2012 8:11 pm ]
Post subject:  Re: Database in Excel
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?
Author:  (cool) Hector [ Tue Jan 24, 2012 8:53 pm ]
Post subject:  Re: Database in Excel
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.
Author:  ed.navas [ Wed Jan 25, 2012 10:54 am ]
Post subject:  Re: Database in Excel
Great I'll give it a try!
Page 1 of 1 All times are UTC + 1 hour [ DST ]
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/