Libary import via xml

Help and Support
1

Hi there. I want to use osmc as on a rasberry pi 3b+ and have my tablet import the libary.

Idea behind this is with osmc i can use it without wifi connection by using the hotspot. Option. Is this possible. If so are there any guides on how to do this

2

Something like this…

https://kodi.wiki/view/HOW-TO:Share_libraries_using_UPnP

3

Thanks but im not a fan of upnp. Im intrested in the msql way

4

So you are trying to use your Pi as a server and the tablet as a client? Tell us more about your setup, like where are the files hosted etc.

5

There is a tutorial in the how-to section on setting up MySQL on your Pi. You can google “kodi android mysql” or “mrmc mysql” depending on what type of tablet you have to find instructions on how to take care of that end.

6

Yes i want use the raspi as server and multiple tablets as clients. I also want to make it portable so can use the server in the car and tablets as the client using the hotspot

7

If you have Android tablets then Yatse is the easiest way to go

8

What about kodi core app or is yaste better. My inital thought was to have kodi installed on each tablet. And then add i the advanced settings the details for the server.

In the advanced settings xml. Where it asks for ip address can i enter the ethernet and hotspot it or 0.0.0.0 so it listens to both ports.

9

Never used Kodi Core App, so can not judge.

0.0.0.0 is something that you would use for a bind address.
Not sure which setting/section you are referring to in advancedsettings.xml

10

This is what i mean. In the host settings can i add two ip address’s

advancedsettings.xml:

> <advancedsettings>
>   <videodatabase>
>     <type>mysql</type>
>     <host>***.***.***.***</host>
>     <port>3306</port>
>     <user>kodi</user>
>     <pass>kodi</pass>
>   </videodatabase> 
>   <musicdatabase>
>     <type>mysql</type>
>     <host>***.***.***.***</host>
>     <port>3306</port>
>     <user>kodi</user>
>     <pass>kodi</pass>
>   </musicdatabase>
>   <videolibrary>
>     <importwatchedstate>true</importwatchedstate>
>     <importresumepoint>true</importresumepoint>
>   </videolibrary>
> </advancedsettings>
11

No. You can only enter one MySQL server.

17

Hi there i am struggering to set this up at the moment, but has anyone got a step by step guide on hot to set up Maria DB and myphp admin. please

18

Hi,

Is this on a platform running osmc? If so:

if not, please provide some more details on what device you are trying to set this up on?

Thanks Tom.

19

I have moved these posts from the new thread you started as they were still on topic to your existing thread of the same subject.

20

I have got PHP my admin to work but when imporitng my lxml file into it i get this message

You probably tried to upload a file that is too large. Please refer to [documentation]

21

PLEASE stop creating new threads that are on the same topic!

22

I believe that there is a configuration in phpMyAdmin for how large an uploaded file can be. I’d suggest you read up on the phpMyAdmin documentation to learn more.

23

What kind of file is that you try to import?

24

Hi there i exported my kodi libary to a single file so i could choose its file locaton.

i thin went into php admin and tried to import the Kodi/OSMC libary into a new data base, it then advised that the file was to large to up load, my xml file was contains about 193 films., i have tried altering the confi file to increas upload etc, but still not good. i know there are apps that i can use to play the fils from localy etc but like the idea of using mariddb and having my rasberry pi 3b+ as the central server.

25

Once the MariaDB connection is established to KODI all you need to do is import the XML file via the KODI interface to insert your collection into the database. Conversely, you can simply update library and the movies will all be scrapped again.