*** It is recommended that you do the "How to drop a proof" guide before attempting this one
This is a simplified guide based on the instructions in the official Baseledger Docs
https://docs.baseledger.net/howtos-1/how-to-sync-two-excel-sheets-with-baseledger
Part 1 - Setup the Spreadsheet and workgroups
Step 1 - Download Spreadsheet
Download and open the excel spreadsheet from the Baseline Protocol examples repo
https://github.com/eea-oasis/baseline/blob/main/examples/baseledger-excel/BaseledgerExcel.xlsm
Once you have download make sure to enable editing and macros
Step 2 - Generate a Workgroup ID
Go to https://www.uuidgenerator.net/version4 and click generate on version 4 UUID
Copy the generated ID and paste it into both the spreadsheets (Alice and Bob)
Step 3 - Generate Access Token (JWT)
Follow steps 1 to 3 from "How to drop a proof"
Go to The Swagger UI for either of the two preconfigured nodes Alice or Bob
Register - Click "Try out" and then input you email and choose a password. Click Execute.
Login - Click "try out". Login with your created details. Click execute.
After you click Execute, you will get a "response body". This is your JWT token. Copy that text, you will need it for the next step.
Paste this JWT into the relevant box on the relevant spreadsheet.
Repeat for the other node (eg you did Alice, now repeat for Bob and paste it in the Bob sheet)
Step 4 - Confirm everything is correct
Click the hyperlinked text "new workgroup", then "participation", then "participation" on both sheets.
If everything is correct then you will see "Add" and "get" buttons appear
You are now ready!
Part 2 - Syncing the Sheets
Obviously this is a demo, and in the real world you would have the two spreadsheets separate computer systems.
But it is a demo you are doing on your own, so you have to pretend for now...
Step 1 - On Alice click the "Add New" button. A new row will appear.
Step 2 - Type a name into the pinky/beige boxes. Then click "suggest"
Step 3 - Load up the trustmesh page by clicking on the "show" hyperlink in the status box under trustmesh. Then you will be able to see what happens.
Step 4 - Now switch to the Bob sheet, and click the "Get new" button. You can now accept or reject the name.
Click reject so you can see what happens
Step 5 - Go back to Alice and click "Latest", it will show as rejected. Suggest an alternative.
Step 6 - Switch to Bob, and click "latest". This time Approve it
Step 7 - Back to Alice and click "latest". It will show as synced. Now suggest a nickname
Step 8 - Back to Bob and click "latest". And you will be asked again to approve/reject. Approve it.
It will then show as "Exited". Final step is to click "Latest" one last time.
You are done! You synced the name and the nickname using Baseledger Lakewood testnet, and you can see a record of what you did on Trustmesh.
Click on the Etherscan hyperlink and you will see the transactions are rolled up to the Ethereum Ropsten testnet!
Baseledger - The Blockchain built for Baselining
A public-permissioned, council-governed blockchain network that fulfills the major requirements of enterprise organizations for participating in Baseline-enabled processes: A unified architecture ensuring service quality, data privacy and integration.
Baseledger has been launched by Unibright and others as an open-source initiative, aiming to build a tokenized ecosystem and open community around Baseledger.
Unibright and partners bundle years of experience in (enterprise) blockchain development, product building and customer satisfaction (Lufthansa, CONA (Coke One North America), Deutsche Bahn among them). Unibright are one of the main drivers of the Baseline initiative, which was launched together with ConsenSys, Microsoft and EY.
Official Website: Baseledger.net
Governance Council: Baseledger.Foundation
Official Twitter: BaseledgerNet
UBT Token Details on Coingecko
