Skip to content

Instantly share code, notes, and snippets.

GautierMichelin gautiermichelin

Block or report user

Report or block gautiermichelin

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View item_request.json
{
"intrinsic_fields" : {
"idno" : "TEST-123",
"type_id" : 43
},
"preferred_labels" : [
{
"locale" : "en_US",
"forename" : "Walter",
"middlename" : "H.",
View gist:c5634a65334248788035
$vs_buf .="Ajouter une nouvelle <select name='type_id' id='caAddObjectToLotForm_type_id'>
<option value='4'>&nbsp;&nbsp;&nbsp; Mesure</option>
</select> à la session";
@gautiermichelin
gautiermichelin / detection-images-being-processed.php
Created Apr 16, 2015
CollectiveAccess : detection & reprocessing of media not treated by queue (either for access permission or format error)
View detection-images-being-processed.php
<?php
require_once('setup.php');
require_once('app/models/ca_object_representations.php');
require_once('app/lib/core/Db.php');
$o_data = new Db();
$qr_reps = $o_data->query("
SELECT *
FROM ca_object_representations
@gautiermichelin
gautiermichelin / Eml2csv.sh
Created May 11, 2015
Eml2csv : shell script to extract To/From/Subject/Date from eml files inside a folder
View Eml2csv.sh
#!/bin/bash
FILES=*.eml
TARGET=./emails.csv
SAVEIFS=$IFS
IFS=$(echo -en "\n\b")
echo "To\tFrom\tSubj\tDate" >> $TARGET
for f in $FILES
do
echo "Processing $f file..."
@gautiermichelin
gautiermichelin / md-toc.rb
Created Jul 7, 2015 — forked from JenniferMack/md-toc.rb
Traduction en français
View md-toc.rb
#!/usr/bin/env ruby
toc = "# Sommaire\n"
newmd = ""
ARGF.each_line do |line|
newmd << line
next if !line.start_with?("#")
heading = line.gsub("#", "").strip
@gautiermichelin
gautiermichelin / elissa.sql
Created Jul 31, 2015
E-lissa (decalog) simple db structure extraction
View elissa.sql
SELECT notices.Titre,
sup1.ISBN,
sup1.Qualif_ISBN,
stitre.Sous_Titre,
para.Titre_Para,
t_forme.Titre_Forme,
t_uni.Titre_Uniforme,
langue.Lib_Langue,
langue.Code_Langue,
langue_originale.Lib_Langue AS Lib_Langue_Originale,
@gautiermichelin
gautiermichelin / objects_list_items.sql
Created Aug 14, 2015
CollectiveAccess SQL request : used list items inside object records
View objects_list_items.sql
SELECT ca_list_labels.list_id,
ca_list_labels.`name`,
ca_attribute_values.item_id,
ca_list_item_labels.name_singular,
group_concat(distinct ca_attributes.row_id) as objets
FROM ca_list_labels LEFT OUTER JOIN ca_lists ON ca_list_labels.list_id = ca_lists.list_id
LEFT OUTER JOIN ca_list_items ON ca_lists.list_id = ca_list_items.list_id
LEFT OUTER JOIN ca_attribute_values ON ca_list_items.item_id = ca_attribute_values.item_id
LEFT OUTER JOIN ca_list_item_labels ON ca_list_item_labels.item_id = ca_attribute_values.item_id
LEFT OUTER JOIN ca_attributes ON ca_attribute_values.attribute_id = ca_attributes.attribute_id
View keybase.md

Keybase proof

I hereby claim:

  • I am gautiermichelin on github.
  • I am gautiermichelin (https://keybase.io/gautiermichelin) on keybase.
  • I have a public key whose fingerprint is E7FD B88C 31D2 1C45 8096 71FF E663 1B33 C92C 9963

To claim this, I am signing this object:

View PafiExternalDB.php
<?php
/** ---------------------------------------------------------------------
* app/lib/core/Auth/Adapters/PafiExternalDB.php : External database authentication backend using Joomla for CollectiveAccess
* ----------------------------------------------------------------------
* CollectiveAccess
* Open-source collections management software
* ----------------------------------------------------------------------
*
* Software by Whirl-i-Gig (http://www.whirl-i-gig.com)
* Copyright 2014 Whirl-i-Gig
View PafiPlatformExternalDB.php
<?php
/** ---------------------------------------------------------------------
* app/lib/core/Auth/Adapters/PafiPlatformExternalDB.php : External database authentication backend using Joomla for CollectiveAccess
* ----------------------------------------------------------------------
* CollectiveAccess
* Open-source collections management software
* ----------------------------------------------------------------------
*
* Software by Whirl-i-Gig (http://www.whirl-i-gig.com)
* Copyright 2014 Whirl-i-Gig
You can’t perform that action at this time.