Toastie 93d6cd25fa moved files from vba repo 4 年 前
..
tests 93d6cd25fa moved files from vba repo 4 年 前
.gitignore 93d6cd25fa moved files from vba repo 4 年 前
INSTALL.Dependencies.Windows.md 93d6cd25fa moved files from vba repo 4 年 前
README.md 93d6cd25fa moved files from vba repo 4 年 前
config-windows.txt 93d6cd25fa moved files from vba repo 4 年 前
excel.vba 93d6cd25fa moved files from vba repo 4 年 前
parse-vcf.py 93d6cd25fa moved files from vba repo 4 年 前
powerquery.md 93d6cd25fa moved files from vba repo 4 年 前
run.bat 93d6cd25fa moved files from vba repo 4 年 前
vdirsyncer.bat 93d6cd25fa moved files from vba repo 4 年 前

README.md

Calendarsync

Purpose of this project is to replicate contacts from CardDAV to Microsoft Excel.

Components:

  • Docker Container to test vdirsync (start-docker-container.sh)
  • Windows shell script (vdirsync.bat) to run vdirsync
  • Python script to parse carddav files to csv (parse-vcf.py)
  • Script to start the vdirsync and parse script (run.bat)
  • PowerQuery to load CSV to Excel (powerquery.txt)
  • VBA script to update Excel with the CSV file (excel.vba)

Pipeline:

  • User clicks button in Excel which runs the load vba function
  • vba starts run.bat and consequently
    • vdirsync pulls latest vcard files (*.vcf) to ./contacts/
    • parse-vcf.py parses the vcards to book.csv
  • vba pulls the data via powerquery from %userprofile%\bin\contactsync\book.csv

Configuration

For Linux, set your address book url, username and password here:

  • data/carddav.url
  • data/password
  • data/username

Set your book url, username and password here:

  • config-windows.txt

Testing

  • For testing under Linux, set your address book url, username and password here:
    • carddav.url
    • password
    • username
  • run.bat equvivalent is run.sh
  • vdirsync.bat equvivalent is vdirsync.sh