[07:40:16] (PS3) MathiasLidal: Add parameter 'pagelabel' to map query [extensions/SemanticMaps] - https://gerrit.wikimedia.org/r/89487 [12:33:51] (PS1) Netbrain: Initial import of code [extensions/SemanticSifter] - https://gerrit.wikimedia.org/r/89815 [13:28:24] (CR) Siebrand: "(4 comments)" [extensions/SemanticSifter] - https://gerrit.wikimedia.org/r/89815 (owner: Netbrain) [13:28:34] (CR) Siebrand: [C: -1] Initial import of code [extensions/SemanticSifter] - https://gerrit.wikimedia.org/r/89815 (owner: Netbrain) [14:18:03] (CR) Jeroen De Dauw: [C: 2] \SMW\DISerializer is in fact a \SMW\Serializers\QueryResultSerializer [extensions/SemanticMediaWiki] - https://gerrit.wikimedia.org/r/89627 (owner: Mwjames) [14:20:43] (CR) Jeroen De Dauw: "(2 comments)" [extensions/SemanticMediaWiki] - https://gerrit.wikimedia.org/r/89147 (owner: Mwjames) [14:21:24] (CR) Jeroen De Dauw: [C: 2] Fixed special case when searchbox is enabled. There is a special case when the searchbox is enabled where one can have markers and other map [extensions/Maps] - https://gerrit.wikimedia.org/r/87040 (owner: Netbrain) [14:21:45] (Merged) jenkins-bot: Fixed special case when searchbox is enabled. There is a special case when the searchbox is enabled where one can have markers and other map objects beneath the search input box. [extensions/Maps] - https://gerrit.wikimedia.org/r/87040 (owner: Netbrain) [15:13:30] Hey guys. I'm working with the ExternalData extension [15:13:42] I'm pulling data from two different databases into my wiki [15:14:01] Each database has an id number which matches eachother [15:14:12] Is there a way to mirror this data up? [15:15:09] For example if db A has widget 1 and db B has widget 2, I want to see data for ID1 widget A, widget B [15:23:44] [travis-ci] wikimedia/mediawiki-extensions-SemanticMediaWiki#262 (master - abafe8e : Jeroen De Dauw): The build was broken. [15:23:44] [travis-ci] Change view : https://github.com/wikimedia/mediawiki-extensions-SemanticMediaWiki/compare/10f8e3a4f38f...abafe8ee4a74 [15:23:44] [travis-ci] Build details : http://travis-ci.org/wikimedia/mediawiki-extensions-SemanticMediaWiki/builds/12571240 [15:46:57] splitwire: I just saw this now. [15:46:57] I don't quite understand... what is "ID1" an ID of? [15:49:03] Yaron, are you the one who created the external data extension? [15:49:03] Yeah. [15:49:04] Awesome, i just bought your book [15:49:14] Oh, great! [15:49:20] Great resource, thanks for that [15:49:21] I hope it'll be helpful. [15:49:32] Its already been a great addition [15:49:57] That's really good to hear. [15:49:57] So, to your question [15:50:07] I have a MySQL DB and an Oracle DB [15:50:16] Each one holds data about a product [15:50:40] The data is different but they each have an identifying number which is the same [15:51:08] So SQL DB might have Product 1 and Oracle DB would also have Product 1 [15:51:57] And each product has multiple widgets? [15:51:59] Well each product has multiple columns of data that describes it [15:52:10] Think of 'Product 1' as the widget [15:52:23] I'm sorry if my explaination is difficult to understand [15:53:40] So what does "ID1", in your original question, correspond to? [15:54:55] I'll put it into a better context -- I'm working with aircraft. SQL DB would have Tail Number, Wing Length, and Body length; Oracle DB would have Tail Number, Altitude ceiling, Climb rate and fuel capacity [15:55:08] I want to match up the two different databases using the Tail Number [15:56:40] So the ID is the aircraft ID, essentially? [15:56:40] Yes [15:56:54] The tail number can be the ID [15:57:33] Thats how we identify them anyway [15:57:34] Right, okay. [15:57:38] Are you going to have a page on the wiki for each aircraft? [15:57:46] I want to [15:57:56] Alright, cool - it makes sense. [15:58:05] A different question would be if a query which automatically makes the pages [15:59:00] No. But there are various ways to create pages automatically. [15:59:00] I'm using MediaWiki to sew together data from two different systems that this company uses [15:59:00] Right. [15:59:00] So I'm tying in to their Databases [15:59:08] I could use a query to export to CSV then upload that to create them in bulk [15:59:52] That would be quick and easy [15:59:52] In that case, you don't need External Data. [15:59:52] Well that still pulls all the data for me in real time [16:00:00] I'm using it to also count how many aircraft changes are pending, etc [16:00:15] It is a very dynamic system [16:01:27] Alright. [16:01:29] Anyway - I would have an "Aircraft" template (or whatever you want call it), on each aircraft page, that in turn uses External Data to get and display the data for that one aircraft. [16:02:23] Using {{PAGENAME}} [16:04:07] Yaron, I'm sorry but I have to go to a meeting. [16:04:41] Alright. [16:04:41] I'll work with that information. Thanks a lot for the info and the book! [16:10:25] Sure! You can always ask more questions here. [17:35:31] Yaron, I made a template to incorporate External Data with and had a parameter |where=tail_number='{{PAGENAME}}' [17:35:54] Alright. [17:36:05] I didn't even think of this, when I try to save the the template it trys to run the db call [17:36:17] And I get an error because the templates name is Template:Aircraft [17:36:33] Ah - you should use and for templates. [17:36:33] Well that's not a valid number for the extension to try and run in the DB [17:36:38] No doubt. [17:36:46] Ohhhh [17:36:53] Shoot, I should know that [17:37:08] Well, it's a learn at the beginning. [17:37:17] (it's a lot to learn) [17:37:22] Yes it is [17:37:52] Is there a community or a way to get more involved with mediawiki/smw [17:38:13] I've been using it for several years and I want to participate a little more than as an end user [17:40:10] splitwire: yes, definitely - there are mailing lists, online groups, conferences... [17:40:44] What kind of stuff do you want to do? [17:41:24] I would like to develop, advocate its use, just get more involved i guess [17:41:31] I'm starting to learn php but that will take awhile [17:42:55] Okay, cool. [17:43:51] Well, there's ways to get involved in all of those: development, evangelism, user support, consulting even... [18:42:45] (CR) Mwjames: "(2 comments)" [extensions/SemanticMediaWiki] - https://gerrit.wikimedia.org/r/89147 (owner: Mwjames) [19:23:28] (PS8) Mwjames: \SMW\ApiBrowse enables to browse a subject via api.php?action=browse [extensions/SemanticMediaWiki] - https://gerrit.wikimedia.org/r/89147 [21:15:42] [travis-ci] wikimedia/mediawiki-extensions-SemanticMediaWiki#263 (master - bd596c2 : Translation updater bot): The build is still failing. [21:15:42] [travis-ci] Change view : https://github.com/wikimedia/mediawiki-extensions-SemanticMediaWiki/compare/abafe8ee4a74...bd596c2c9dba [21:15:42] [travis-ci] Build details : http://travis-ci.org/wikimedia/mediawiki-extensions-SemanticMediaWiki/builds/12584856 [22:00:36] (PS1) Mwjames: Fix PHP_CodeCoverage_Exception on QueryResultSerializer [extensions/SemanticMediaWiki] - https://gerrit.wikimedia.org/r/90033 [22:00:55] (CR) Mwjames: [C: 2 V: 2] Fix PHP_CodeCoverage_Exception on QueryResultSerializer [extensions/SemanticMediaWiki] - https://gerrit.wikimedia.org/r/90033 (owner: Mwjames) [23:05:18] (PS1) Mwjames: Simplify SemanticData subobject serializer/deserializer [extensions/SemanticMediaWiki] - https://gerrit.wikimedia.org/r/90052 [23:08:33] (CR) Mwjames: [C: 2] Simplify SemanticData subobject serializer/deserializer [extensions/SemanticMediaWiki] - https://gerrit.wikimedia.org/r/90052 (owner: Mwjames) [23:09:35] [travis-ci] wikimedia/mediawiki-extensions-SemanticMediaWiki#264 (master - 6549258 : mwjames): The build was fixed. [23:09:35] [travis-ci] Change view : https://github.com/wikimedia/mediawiki-extensions-SemanticMediaWiki/compare/bd596c2c9dba...65492582b7c3 [23:09:35] [travis-ci] Build details : http://travis-ci.org/wikimedia/mediawiki-extensions-SemanticMediaWiki/builds/12591379 [23:32:02] (CR) Jeroen De Dauw: "(1 comment)" [extensions/SemanticMediaWiki] - https://gerrit.wikimedia.org/r/89147 (owner: Mwjames) [23:35:12] [travis-ci] wikimedia/mediawiki-extensions-SemanticMediaWiki#265 (master - a33411f : mwjames): The build was fixed. [23:35:12] [travis-ci] Change view : https://github.com/wikimedia/mediawiki-extensions-SemanticMediaWiki/compare/65492582b7c3...a33411f361d2 [23:35:12] [travis-ci] Build details : http://travis-ci.org/wikimedia/mediawiki-extensions-SemanticMediaWiki/builds/12593877 [23:35:51] (PS9) Mwjames: \SMW\ApiBrowse enables to browse a subject via api.php?action=browse [extensions/SemanticMediaWiki] - https://gerrit.wikimedia.org/r/89147 [23:37:21] (CR) Mwjames: "(1 comment)" [extensions/SemanticMediaWiki] - https://gerrit.wikimedia.org/r/89147 (owner: Mwjames) [23:47:31] (CR) Jeroen De Dauw: "For the functionality that is not implemented, you can fall back to mysql. For the stats stuff there really is no reason to use mongo, as " [extensions/SemanticMediaWiki] - https://gerrit.wikimedia.org/r/88534 (owner: Mwjames) [23:47:43] (CR) Mwjames: "Any other suggestions that would prevent this from merging?" [extensions/SemanticMediaWiki] - https://gerrit.wikimedia.org/r/89147 (owner: Mwjames) [23:57:55] (CR) Mwjames: [C: -1] "I have to rework this a bit since the SemanticDataSerializer/Deserializer is now available in core (as used by the ApiBrowse) therefore do" [extensions/SemanticMediaWiki] - https://gerrit.wikimedia.org/r/88534 (owner: Mwjames)