知識、スキル | クライアント、企画、営業 | ウェブ ディレクター | ウェブ デザイナー | フロントエンド エンジニア | バックエンド エンジニア | システム保守、 運用 | |||
---|---|---|---|---|---|---|---|---|---|
企画 | 課題発見 | アンケート調査、インタビュー、SEO | ◯ | ||||||
ビジョン設定、 コンセプト立案 | 課題発見、概念図作成、ワークショップ、ファシリテーション | ◯ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
### このシェルスクリプトは、Latin1のテーブルにUTF8でコンテンツが書き込まれてしまったデータベースを修復します。 | |
my_db='dbname'; | |
my_user='dbuser'; | |
my_pw='dbpassword'; | |
for my_table in $(mysql -u$my_user -p$my_pw -N -s -r $my_db -e 'show tables;'); do | |
for my_column in $(mysql -u$my_user -p$my_pw -N -r -s -e "use $my_db; show columns from $my_table" | cut -f1); do | |
echo $my_column; | |
mysql -u$my_user -p$my_pw -N -r -s -e "use $my_db; UPDATE $my_table SET $my_column = CONVERT(CAST(CONVERT($my_column USING latin1) AS BINARY) USING utf8);" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
## -*- mode: perl; coding: utf-8 -*- | |
# blogger2octopress.pl | |
# Author: Takuji Tokiwa | |
# | |
# About: | |
# Export entries from blogger backup file to octpress format entries. | |
# | |
# Usage: | |
# 1. Install XML::Simpe, DateTime::Format::ISO8601 and HTML::WikiConverter::Markdown via cpan, cpanm or 'Carton Install'. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
pid=$$ | |
date=`date '+%Y-%m-%d-%H_%M'` | |
outdir="." | |
if [ $# -le 1 ]; then | |
echo "usage : $0 channel_name duration(minuites) [outputdir] [prefix]" | |
exit 1 | |
fi |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
LANG=ja_JP.utf8 | |
pid=$$ | |
date=`date '+%Y-%m-%d-%H_%M'` | |
outdir="." | |
if [ $# -le 1 ]; then |