2012-05-02, 14:46
Hello
I've been trying to find out how to simply export a list of movies I have already watch. All I could find was this guide....
http://www.waldherr.org/?p=166
I didn't get very far with converting the file, so I simply tried to open videodb.xml within Excel and my results are as followed. I've written myself a guide and so thought I'd share it with you guys and hopefully it will help others. It may be common knowledge to the more experienced Excel users, but here it is anyway. I did try to post in 'Step-by'step guide' forum but I do not have permission.
1. Export XBMC database to single file.
2. Open videodb.xml in Excel. Now you will be given three options, select ‘Use the XML Source task pane’.
3. A new spreadsheet will now open, but you will also see an XML source panel to the right. Click on any of your chosen categories you would like to import and drag to a column of your choice.
4. For this example I have selected and dragged ‘title’ to A1, so now A1 has been populated with the category ‘title’. Now right click on A1 > XML > Import, select your videodb.xml and all your movie titles will be imported.
5. You can now pick and choose which categories to import.
You will find that each category populates in a new row rather than B1, C1 etc for the same movie. I’m not sure how to correct this so perhaps someone can advise, but for now I use a work around.
1. Simply highlight the column you would like to move up the spreadsheet so that the data starts from the top (ie B1, C1 etc), cut and paste and do this for each column until all the data for that one film is displayed on a single row.
2. Depending on how many categories you have chosen to import, you will now have a various number of blank rows. Highlight all data within A column, press F5 > Special > Blanks > OK. Right click on a row > Delete > table_rows, the blank rows will be deleted and now all your data for a particular movie will be present on a single row.
Jackhulk
I've been trying to find out how to simply export a list of movies I have already watch. All I could find was this guide....
http://www.waldherr.org/?p=166
I didn't get very far with converting the file, so I simply tried to open videodb.xml within Excel and my results are as followed. I've written myself a guide and so thought I'd share it with you guys and hopefully it will help others. It may be common knowledge to the more experienced Excel users, but here it is anyway. I did try to post in 'Step-by'step guide' forum but I do not have permission.
1. Export XBMC database to single file.
2. Open videodb.xml in Excel. Now you will be given three options, select ‘Use the XML Source task pane’.
3. A new spreadsheet will now open, but you will also see an XML source panel to the right. Click on any of your chosen categories you would like to import and drag to a column of your choice.
4. For this example I have selected and dragged ‘title’ to A1, so now A1 has been populated with the category ‘title’. Now right click on A1 > XML > Import, select your videodb.xml and all your movie titles will be imported.
5. You can now pick and choose which categories to import.
You will find that each category populates in a new row rather than B1, C1 etc for the same movie. I’m not sure how to correct this so perhaps someone can advise, but for now I use a work around.
1. Simply highlight the column you would like to move up the spreadsheet so that the data starts from the top (ie B1, C1 etc), cut and paste and do this for each column until all the data for that one film is displayed on a single row.
2. Depending on how many categories you have chosen to import, you will now have a various number of blank rows. Highlight all data within A column, press F5 > Special > Blanks > OK. Right click on a row > Delete > table_rows, the blank rows will be deleted and now all your data for a particular movie will be present on a single row.
Jackhulk
