Media List Editor Examples
#46
List to show only watched movies with a user rating under 7:

SELECT DISTINCT *
FROM
  movielist
WHERE
  movielist.iLastPlayed IS NOT NULL AND
  movielist.iUserRating < 7
German Ember Media Manager Support

Daily Builds - Link
Latest official Ember-MM version - Ember Media Manager 1.4.x
Reply
#47
Hi,

can someone please help with following filter:

All movies with "HDDVD" in filename, Thanks.

Tried some SQL without success Sad
Reply
#48
Found the variabel StrFilename in the help section, but can't figure out the correct sql.....
Reply
#49
(2018-01-11, 21:55)Anderella Wrote: Hi,

can someone please help with following filter:

All movies with "HDDVD" in filename, Thanks.

Tried some SQL without success Sad
SELECT DISTINCT *
FROM
  movielist
WHERE
  movielist.MoviePath LIKE '%hddvd%'
German Ember Media Manager Support

Daily Builds - Link
Latest official Ember-MM version - Ember Media Manager 1.4.x
Reply
#50
Thx.
Reply
#51
I am on the latest Git build, and I created for the first time a media list to sort 1080p bluray. Anyways, after making it it required me to reboot Ember. I did, and the list works fine however I can not go back to settings now, I just get:

Value cannot be null
parameter name: value

In windows log:

Code:
Fault bucket 1630300406890070320, type 5
Event Name: CLR20r3
Response: Not available
Cab Id: 0

Problem signature:
P1: Ember Media Manager.exe
P2: 1.4.90.0
P3: 5aa00980
P4: System.Data
P5: 4.7.2633.0
P6: 5a4ed9ed
P7: 2ec8
P8: a
P9: System.InvalidOperationException
P10: 

Attached files:
\\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER9836.tmp.mdmp
\\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER9D97.tmp.WERInternalMetadata.xml
\\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER9DA7.tmp.csv
\\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER9DC7.tmp.txt
\\?\C:\Users\donal\AppData\Local\Temp\WERA2A9.tmp.appcompat.txt
\\?\C:\Users\donal\AppData\Local\Temp\WERA2E9.tmp.WERDataCollectionStatus.txt

These files may be available here:
C:\ProgramData\Microsoft\Windows\WER\ReportArchive\AppCrash_Ember Media Mana_9dd17fbdd63028dc54211ba9753315b1b9104f64_96bd37a6_1f08a2f4

Analysis symbol: 
Rechecking for solution: 0
Report Id: 43784712-ba8d-4346-b28c-439a152cd484
Report Status: 2147487752
Hashed bucket: 7a397ee0d4051233669ffd9515db8130

Code:

Application: Ember Media Manager.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.InvalidOperationException
   at System.Windows.Forms.Control.MarshaledInvoke(System.Windows.Forms.Control, System.Delegate, System.Object[], Boolean)
   at System.Windows.Forms.Control.Invoke(System.Delegate, System.Object[])
   at Ember_Media_Manager.frmMain.ShowSettings()
   at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
   at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
   at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object)
   at System.Threading.ThreadHelper.ThreadStart()

Code:

Faulting application name: Ember Media Manager.exe, version: 1.4.90.0, time stamp: 0x5aa00980
Faulting module name: KERNELBASE.dll, version: 10.0.16299.248, time stamp: 0x4414ec23
Exception code: 0xe0434352
Fault offset: 0x0000000000014008
Faulting process id: 0x34c8
Faulting application start time: 0x01d3b7d5109e496e
Faulting application path: C:\Ember Media Manager BETA\Ember Media Manager.exe
Faulting module path: C:\WINDOWS\System32\KERNELBASE.dll
Report Id: 953ecd66-285f-47e5-a77a-52c85e6b40be
Faulting package full name: 
Faulting package-relative application ID: 
Living Room: Vizio 65" 4K HDR/DV, Apple TV | Mancave: Panasonic 46" Plasma, FireTV | Bedroom: Panasonic 32" LCD, FireTV
NAS: unRAID 6.x (21.5TB + cache) | AZZA Helios 910 | ASRock Z68 Extreme4 | Intel Core i7-2600K Sandy Bridge Quad-Core 3.4GHz | Antec NEO ECO 520W | G.SKILL Ripjaws Series 16GB | Supermicro CSE-M35T-1B
Reply
#52
(2018-03-09, 20:47)thrashmagazine Wrote: I am on the latest Git build, and I created for the first time a media list to sort 1080p bluray. Anyways, after making it it required me to reboot Ember. I did, and the list works fine however I can not go back to settings now, I just get:

Value cannot be null
parameter name: value

In windows log:

I need the log of Ember to show a usefull information. Please the upload the log (.\Ember Media Manager\Logs) to http://pastebins.com
German Ember Media Manager Support

Daily Builds - Link
Latest official Ember-MM version - Ember Media Manager 1.4.x
Reply
#53
Is there a way to find fanart with resolution 720p or even by filesize to clean up low res fanarts...
Reply
#54
(2018-03-12, 12:54)shwetkprabhat Wrote: Is there a way to find fanart with resolution 720p or even by filesize to clean up low res fanarts...
No, image resolutions and trailer qualities are not saved in the database. Maybe that will be a feature of Ember 2.0...
German Ember Media Manager Support

Daily Builds - Link
Latest official Ember-MM version - Ember Media Manager 1.4.x
Reply
#55
(2018-03-11, 23:10)DanCooper Wrote:
(2018-03-09, 20:47)thrashmagazine Wrote: I am on the latest Git build, and I created for the first time a media list to sort 1080p bluray. Anyways, after making it it required me to reboot Ember. I did, and the list works fine however I can not go back to settings now, I just get:

Value cannot be null
parameter name: value

In windows log:

I need the log of Ember to show a usefull information. Please the upload the log (.\Ember Media Manager\Logs) to http://pastebins.com 
That link didn't work for me so hope this is ok, but I put it here: https://drive.google.com/open?id=1a7Clld...8deBpxBot_
Living Room: Vizio 65" 4K HDR/DV, Apple TV | Mancave: Panasonic 46" Plasma, FireTV | Bedroom: Panasonic 32" LCD, FireTV
NAS: unRAID 6.x (21.5TB + cache) | AZZA Helios 910 | ASRock Z68 Extreme4 | Intel Core i7-2600K Sandy Bridge Quad-Core 3.4GHz | Antec NEO ECO 520W | G.SKILL Ripjaws Series 16GB | Supermicro CSE-M35T-1B
Reply
#56
(2018-03-12, 14:54)thrashmagazine Wrote:
(2018-03-11, 23:10)DanCooper Wrote:
(2018-03-09, 20:47)thrashmagazine Wrote: I am on the latest Git build, and I created for the first time a media list to sort 1080p bluray. Anyways, after making it it required me to reboot Ember. I did, and the list works fine however I can not go back to settings now, I just get:

Value cannot be null
parameter name: value

In windows log:

I need the log of Ember to show a usefull information. Please the upload the log (.\Ember Media Manager\Logs) to http://pastebins.com  
That link didn't work for me so hope this is ok, but I put it here: https://drive.google.com/open?id=1a7Clld...8deBpxBot_ 
Can you also upload your library? I think that's a special issue that I can't find without your database. You can find the file in .\Ember Media Manager\Profiles\Default\MyVideosXY.emm
German Ember Media Manager Support

Daily Builds - Link
Latest official Ember-MM version - Ember Media Manager 1.4.x
Reply
#57
(2018-03-12, 19:48)DanCooper Wrote:
(2018-03-12, 14:54)thrashmagazine Wrote:
(2018-03-11, 23:10)DanCooper Wrote: I need the log of Ember to show a usefull information. Please the upload the log (.\Ember Media Manager\Logs) to http://pastebins.com  
That link didn't work for me so hope this is ok, but I put it here: https://drive.google.com/open?id=1a7Clld...8deBpxBot_ 
Can you also upload your library? I think that's a special issue that I can't find without your database. You can find the file in .\Ember Media Manager\Profiles\Default\MyVideosXY.emm 
here it is. https://drive.google.com/open?id=1bSyyF6...e9rD99Uev_
Living Room: Vizio 65" 4K HDR/DV, Apple TV | Mancave: Panasonic 46" Plasma, FireTV | Bedroom: Panasonic 32" LCD, FireTV
NAS: unRAID 6.x (21.5TB + cache) | AZZA Helios 910 | ASRock Z68 Extreme4 | Intel Core i7-2600K Sandy Bridge Quad-Core 3.4GHz | Antec NEO ECO 520W | G.SKILL Ripjaws Series 16GB | Supermicro CSE-M35T-1B
Reply
#58
(2018-03-13, 15:00)thrashmagazine Wrote:
(2018-03-12, 19:48)DanCooper Wrote:
(2018-03-12, 14:54)thrashmagazine Wrote: That link didn't work for me so hope this is ok, but I put it here: https://drive.google.com/open?id=1a7Clld...8deBpxBot_
Can you also upload your library? I think that's a special issue that I can't find without your database. You can find the file in .\Ember Media Manager\Profiles\Default\MyVideosXY.emm     
here it is. https://drive.google.com/open?id=1bSyyF6...e9rD99Uev_ 
Looks like it's possible to add a custom tab that's no set to a custom view/SQL query. You can fix that in the file .\Ember Media Manager\Profiles\Default\AdvancedSettings.xml. Search for this line:

<Item Name="1080p" />

and replace it with

<Item Name="1080p">movie-1080p Bluray</Item>
German Ember Media Manager Support

Daily Builds - Link
Latest official Ember-MM version - Ember Media Manager 1.4.x
Reply
#59
Wondering if anyone has any query to grab 1080p "bluray" only rips? I can't seem to find where "bluray" is stored.
Living Room: Vizio 65" 4K HDR/DV, Apple TV | Mancave: Panasonic 46" Plasma, FireTV | Bedroom: Panasonic 32" LCD, FireTV
NAS: unRAID 6.x (21.5TB + cache) | AZZA Helios 910 | ASRock Z68 Extreme4 | Intel Core i7-2600K Sandy Bridge Quad-Core 3.4GHz | Antec NEO ECO 520W | G.SKILL Ripjaws Series 16GB | Supermicro CSE-M35T-1B
Reply
#60
(2018-03-14, 15:52)thrashmagazine Wrote: Wondering if anyone has any query to grab 1080p "bluray" only rips? I can't seem to find where "bluray" is stored.
SELECT DISTINCT * FROM  movielist WHERE movielist.VideoSource = "bluray"
German Ember Media Manager Support

Daily Builds - Link
Latest official Ember-MM version - Ember Media Manager 1.4.x
Reply
 
Thread Rating:
  • 1 Vote(s) - 5 Average



Logout Mark Read Team Forum Stats Members Help
Media List Editor Examples51