| Author |
 Topic  |
|
|
GreenGremlim
New Member
Portugal
55 Posts |
 Posted - 28 Apr 2010 : 08:28:52
|
| Hi I don't know if this is possible to do or has already be done but I wanted to split mya database in several databases each for an alphabet letter, I've tried the special filters function to make possibleto select only the movies that start by each letter but then it is not possible to export them to another database or do anything like it. Sorry for my bad english and thanks in advance |
|
|
JDommi
Administrator
Germany
4638 Posts |
Posted - 28 Apr 2010 : 08:37:13
|
| Just click on the column header of the title in main grid to sort alphabetically. Then mark all movies with your desired letter and export them - No need to break a database for that ;) |
In order to achieve what is possible, you have to try the impossible over and over again.
Hermann Hesse |
 |
|
|
GreenGremlim
New Member
Portugal
55 Posts |
Posted - 28 Apr 2010 : 08:40:35
|
| Please explain better, export them how? And will that create a new database? Because I want a database for each letter, it's easier if i add new movies to export the database by letter than the "all" database |
|
|
|
JDommi
Administrator
Germany
4638 Posts |
Posted - 28 Apr 2010 : 09:18:37
|
You can export only as HTML/XML, CSV or TXT. But exporting into a new database is not possible.
BUT (I never have tested it!) you could create multiple empty databases and exchange movies between them.
You can reach these options by clicking on the blue down arrow on top left. |
In order to achieve what is possible, you have to try the impossible over and over again.
Hermann Hesse |
|
|
|
GreenGremlim
New Member
Portugal
55 Posts |
Posted - 28 Apr 2010 : 09:30:12
|
| Yes I've tried that and it's almost perfect but in the exchange window the movies are sorted by movie ID and not by title wich makes it to much dificult to select all movies for each letter,if only it waspossible to sort them by title that would be really good |
|
|
|
JDommi
Administrator
Germany
4638 Posts |
Posted - 28 Apr 2010 : 10:56:06
|
Yes, you're right... the list should be sortable by click on the column header.
Best to ask Alessio directly if he could implement that function.
Another possible solution: open your db with MS Access, sort by title and change the movie ids. On google I have found ways to change the primary (movie) id. |
In order to achieve what is possible, you have to try the impossible over and over again.
Hermann Hesse |
|
|
|
GreenGremlim
New Member
Portugal
55 Posts |
Posted - 30 Apr 2010 : 08:27:37
|
| I've tried using MS Acess but I get an error message saying that I can't change the movies ID because it would create duplicate entries :S |
|
|
|
JDommi
Administrator
Germany
4638 Posts |
Posted - 30 Apr 2010 : 09:09:13
|
Please have a look at google. I think You have to remove that id and add it again.
And as always the reminder to test only with a backup ;) |
In order to achieve what is possible, you have to try the impossible over and over again.
Hermann Hesse |
|
|
| |
Topic |
|
Split database alphabetically