Skip to content

Instantly share code, notes, and snippets.

View guillearch's full-sized avatar

Guillermo Castellano guillearch

5 followers · 3 following
View GitHub Profile
@guillearch
guillearch / videojuegos.rdf.xml
Created May 23, 2019 07:06
Tesauro de géneros de videojuegos en formato SKOS
<?xml version="1.0" encoding = "UTF-8"?><rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:skos="http://www.w3.org/2004/02/skos/core#" xmlns:dc="http://purl.org/dc/elements/1.1#" >
<skos:ConceptScheme rdf:about="videojuegos/5000"><dc:title xml:lang="ES">Videojuegos</dc:title>
<dc:creator xml:lang="ES">root</dc:creator>
<skos:definition xml:lang="ES">Géneros de videojuegos</skos:definition>
<skos:hasTopConcept rdf:resource="videojuegos/16ae376d84c-3fd3a736cfc85"/>
<skos:hasTopConcept rdf:resource="videojuegos/16ae377cea9-3fda300e060fe"/>
<skos:hasTopConcept rdf:resource="videojuegos/16ae377ad00-3fd1291e9ca8b"/>
<skos:hasTopConcept rdf:resource="videojuegos/16ae3778eed-3fe02d4f49fcd"/>
<skos:hasTopConcept rdf:resource="videojuegos/16ae3771261-3feb49b516260"/>
<skos:hasTopConcept rdf:resource="videojuegos/16ae3774581-3fb9bb261d7cf"/>
@guillearch
guillearch / openkm_metadata_definition
Created April 12, 2019 14:51
OpenKM Metadata Definition Example
<!-- AP INVOICE METADATA DEFINITION -->
<property-group label="AP Inovice" name="okg:apinvoice">
<suggestbox label="Vendor" name="okp:apinvoice.vendor" width="200px"
table="vendor" dialogTitle="Choose vendor" filterMinLen="3"
filterQuery="select $vendor_id, $vendor_name from DatabaseMetadataValue dmv where dmv.table='vendor' and lower(dmv.$vendor_name) like '%{0}%' order by dmv.$vendor_name"
valueQuery="select $vendor_id, $vendor_name from DatabaseMetadataValue dmv where dmv.table='vendor' and dmv.$vendor_id='{0}'"/>
<!-- SELECT INSTEAD OF SUGGESTBOX
<select label="Customer" name="okp:apinvoice.vendor" type="simple">
<option label="ACME" value="ACME"/>
<option label="Capsule Corp." value="Capsule Corp."/>
@guillearch
guillearch / okm_db_metadata_type
Last active April 12, 2019 14:50
OpenKM OKM_DB_METADATA_TYPE Example
--DELETE FROM OKM_DB_METADATA_TYPE WHERE DMT_TABLE='vendor';
INSERT INTO OKM_DB_METADATA_TYPE (DMT_TABLE, DMT_REAL_COLUMN, DMT_TYPE, DMT_VIRTUAL_COLUMN) VALUES ('vendor', 'col00', 'integer', 'vendor_id');
INSERT INTO OKM_DB_METADATA_TYPE (DMT_TABLE, DMT_REAL_COLUMN, DMT_TYPE, DMT_VIRTUAL_COLUMN) VALUES ('vendor', 'col01', 'text', 'vendor_name');
--DELETE FROM OKM_DB_METADATA_VALUE WHERE DMV_TABLE='vendor';
INSERT INTO OKM_DB_METADATA_VALUE (DMV_TABLE, DMV_COL00, DMV_COL01) VALUES ('vendor', '001', 'Capsule Corp.');
INSERT INTO OKM_DB_METADATA_VALUE (DMV_TABLE, DMV_COL00, DMV_COL01) VALUES ('vendor', '002', 'Planet Express');
INSERT INTO OKM_DB_METADATA_VALUE (DMV_TABLE, DMV_COL00, DMV_COL01) VALUES ('vendor', '003', 'ACME');
SELECT * FROM OKM_DB_METADATA_VALUE WHERE DMV_TABLE='vendor'
@guillearch
guillearch / bibliografia-slgd.md
Last active July 2, 2018 16:00
Bibliografía sobre software libre de gestión documental

Bibliografía sobre software libre de gestión documental

Contenido elaborado por Guillermo Castellano y publicado bajo licencia Creative Commons Attribution-ShareAlike 4.0 International.

1. La revolución del software libre y de código abierto

AMADOR, J. L. "Software libre y administraciones públicas: amigos para siempre". En: OpenExpo [blog]. 13 febrero 2017 [consulta 01-02-2018].

BALTER, B. “Open source license usage on GitHub.com”. En: GitHub [en línea]. 9 marzo 2015 [consulta 05-05-2017].

@guillearch
guillearch / install-tomcat-8.5.31.sh
Last active June 10, 2019 07:48 — forked from Clivern/install-tomcat-8.5.14.sh
How to Install Apache Tomcat 8 on Ubuntu 16.04
#!/bin/bash
# For More Info http://clivern.com/how-to-install-apache-tomcat-8-on-ubuntu-16-04
sudo apt-get update
sudo apt-get install curl
sudo apt-get install unzip
cd /opt
curl -O http://apache.mirrors.ionfish.org/tomcat/tomcat-8/v8.5.31/bin/apache-tomcat-8.5.31.zip
sudo unzip apache-tomcat-8.5.31.zip
sudo mv apache-tomcat-8.5.31 tomcat