README

在 kimai 上运行此 SQL 以导出现有 kimai 数据。

cat <<EOF > kimai-dump.sql
select \
    t.id          as id,       \
    c.name        as customer, \
    p.name        as project,  \
    a.name        as activity, \
    t.start_time  as ddate,    \
    t.duration    as duration, \
    t.description as title,    \
    u.username    as username  \
from \
    kimai2_timesheet t \
    inner join kimai2_users u on t.user=u.id \
    inner join kimai2_activities a on t.activity_id=a.id \
    inner join kimai2_projects p on a.project_id=p.id \
    inner join kimai2_customers c on p.customer_id=c.id;
EOF

现在将其作为批处理导出运行，并删除头部行（TODO 可能有一个 mysyl 命令可以抑制头部）。您需要调整 SQL 详细信息以匹配您的设置。

    mysql -B -u root -pchangeme kimai < kimai-dump.sql > export.orig.csv

在容器 SQL 上运行此操作

    docker exec -i mysql mysql -B -u root -pchangeme kimai < kimai-dump.sql > export.orig.csv

获取项目列表，我们需要将这些与 Trello 板匹配起来

    docker exec -i kimai00_mysql_1 mysql -B -u root -pchangeme kimai -e "select name from kimai2_projects" > projects.txt

然后您需要规范化数据以便安装。这假设您已将 LDAP 身份验证添加到此 Drupal。

    .fixtures/convert-and-map.sh

tobybatch / timesheet

维护者

详细信息

README