github-mirrors/wekan
1
0
Fork 0
mirror of https://github.com/wekan/wekan.git synced 2025-08-15 16:53:57 -04:00
Code Issues Projects Releases Packages Wiki Activity
Page: Excel and VBA
Pages
ADFS AWS Accounts Lockout Adding new Snap settings to code Adding users Allow private boards only Android Apache Archive and Delete Asana AsyncAwait Azure B2C Backup Browser compatibility matrix Burndown and Velocity Chart CAS CSV Caddy Webserver Config Calendar Change Language Chromebook Cloud Foundry CloudFlare Cloudron Converting Meteor Stylus to CSS Cover Cron Custom CSS themes Custom Fields Custom Logo Customize Translations Dark Mode Day of week start Debian Debugging Deep Dive Into WeKan Delete Board Design Principles Developer Documentation Directory Structure Disable Password Login Docker Dome Drag Drop Due Date Emoji Excel and VBA Export Docker Mongo Data Export from Wekan Sandstorm grain .zip file FAQ Features Forgot Password FreeBSD Friend From Previous Export Gantt Google Cloud Google login Hall of Shame Helm Heroku Home IFTTT IRC FAQ If board does not open and keeps loading Impersonate user Install Wekan Docker for testing Install Wekan Docker in production Install Wekan Docker on SUSE Linux Enterprise Server 12 SP1 Install Wekan from source on Windows Install Windows Install and Update Install from source without root Install latest Wekan release on Uberspace Install source without sudo on Linux Integrations Java Jira Keycloak LDAP AD Simple Auth LDAP LaTeX Leo Let's Encrypt and Google Auth Linked Cards Local self signed TLS Logs Mac Mermaid Diagram Metal Meteor bundle Meteor Metrics Migrating from Trello Migrating from old Wekan manually Monkey Proof Software Move Docker containers to other computer Multiline Multitenancy NOT related to Wekan New card with Python3 and REST API Nextcloud Nginx Webserver Config Numbered text OAuth2 OVH Offline OpenShift OpenSuse OpenVZ Oracle Identity Cloud Oracle OIM Outgoing Webhook to Discord PWA Password Hashing PikaPods Planning Poker Platforms PostgreSQL Press Python Qnap NAS REST API Boards REST API Cards REST API Checklists REST API Code REST API Custom Fields REST API Integrations REST API Lists REST API Role REST API Swimlanes REST API User REST API Rancher Rancher Active Proxy Wekan MongoDB Docker Raspberry Pi Rclone Receiving Webhooks Repair Docker Repair MongoDB Requirements Roadmap RocketChat SAML Sandstorm Scaling Scalingo Secure Boot Security Disclosure Settings SmartOS Snap Source Subtasks Swimlanes Sync Team Templates Test Edge Time Tracking Timezone Touch Screen support Traefik and self signed SSL certs Translations Troubleshooting Mail UCS Ubuntu Core Upgrade Vagrant Vultr WSL Wait Spinners WeKan Multiverse Roadmap WebHook And CA Webhook data Wekan Markdown Wekan Sandstorm cards to CSV using Python Wekan vs Sandstorm Wekan vs Trello vs Restyaboard Windows ZenKit Zitadel autologin ppc s390x virtual appliance
4 Excel and VBA
Lauri Ojansivu edited this page 2023-06-29 12:43:25 +03:00
Table of Contents

Related projects:

For accessing Wekan with Excel VBA, you can use Wekan REST API:

https://github.com/wekan/wekan/wiki/REST-API

For example, with using curl, you first login with admin credentials, by sending username and password to url. Change your server url etc details to below:

Login with as JSON https://github.com/wekan/wekan/wiki/REST-API#example-call---as-json

curl -H "Content-type:application/json" \
      http://localhost:3000/users/login \
      -d '{ "email": "my@email.com", "password": "mypassword" }'

=>

{
 "id": "ABCDEFG123456",
 "token": "AUTH-TOKEN",
 "tokenExpires": "2018-07-15T14:23:18.313Z"
}

Then you update card content by sending to card URL the new content:

curl -H "Authorization: Bearer AUTH-TOKEN" \
   -H "Content-type:application/json" \
   -X PUT \
http://localhost:3000/api/boards/ABCDEFG123456/lists/ABCDEFG123456/cards/ABCDEFG123456 \
-d '{ "title": "Card new title", "listId": "ABCDEFG123456", "description": "Card new description" }'

When using VBA, you can optionally:

  • Use direct VBA commands to send and receive from URLs
  • Download curl for Windows, and in VBA call curl.exe with those parameters, and get the result.

You can also google search how you can use JSON format files in VBA, converting them to other formats etc. There could be something similar that exists in PHP, that JSON file can be converted to PHP array, and array items accessed individually, and array converted back to JSON.

Current Wekan REST API does not yet cover access to all data that is in MongoDB. If you need that, REST API page also has link to Restheart, that adds REST API to MongoDB, so you can use all of MongoDB data directly with REST API. https://github.com/wekan/wekan/wiki/REST-API

Wekan boards also have export JSON, where also attachments are included in JSON as base64 encoded files. To convert them back to files, you first get whole one board exported after authentication like this:

curl https://Bearer:APIKEY@ip-address/api/boards/BOARD-ID/export?authToken=#APIKEY > wekanboard.json

Then you read that JSON file with VBA, and get that part where in JSON is the base64 text of the file. Then you use VBA base64 function to convert it to binary, and write content to file.

CSV/TSC Import/Export

There is CSV/TSV pull request, but it has been made a long time ago, it would need some work to add all the new tables, columns etc from MongoDB database, so that it would export everything correctly.

Options are:

a) Some developer could do that work and contribute that code to Wekan as new pull request to Wekan devel branch.

b) Use Commercial Support and pay for the time to get it implemented.

Wekan

General

Fake: Not WeKan kanban

Security

Scaling

Migrating

Support priorities for new features and bugfixes

  1. Commercial Support
  2. Community Support
  3. Debugging

Backup

Repair

Themes

Markdown Syntax

Login Auth

Metrics, Logs, Stats

Integrations

Time

Features

Email

Required Settings

Download

Webservers

REST API Docs

REST API issue

REST API client code

Webhooks

Case Studies

Development

Issues

Wekan - OpenSource Kanban