Excel and VBA

Lauri Ojansivu edited this page Apr 30, 2018 · 3 revisions

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:

curl http://localhost:3000/users/login \
-d "username=USER&password=PASSWORD"

=>

{
 "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

Support priorities for new features and bugfixes

  1. Commercial Support and Bounties
  2. Community Support
  3. Debugging

Security

Backup

Repair

Features

Email

Logs and Stats

Migrating

Settings

Download

Webservers

REST API Docs

REST API issue

REST API client code

Webhooks

Case Studies

Development

Issues

Clone this wiki locally
You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.
Press h to open a hovercard with more details.