This command not live yet, we are just designing this cli library

Introduction

We need a set of command to manipulate the data on Office 365, especially SharePoint.

Developers

Peter [email protected] , System Architect

Tiffany [email protected] , Programmer

Installation

npm i -g @quantr/quantr-365-cli

Development

Compile

Edit src/index.ts, then

npm run build

Run

node dist/index.js -c clonelist --username [email protected] --password xxx --from https://quantr.sharepoint.com/quantr-365-cli/lists/list1 --to https://quantr.sharepoint.com/quantr-365-cli/lists/list2

Commands

This command support these functions:

1. Create list (done)
2. Copy list items to
3. Clone list
4. Clone user groups
5. Export list to excel (done)
6. Import excel to list
7. Clone site
8. Google drive to SharePoint folder

Create empty list option

Options

1. --username
2. --password
3. --from
4. --listname

quantr-365-cli -c createlist --username [email protected] --password xxx --from https://quantr.sharepoint.com/tiffany/Lists/testing4 --listname testing4

Create list

--type(s)

1. 9 (number)
2. 2 (text)
3. 3 (note)
4. 4 (datetime)

Propertie(s)

1. title (necessary)
2. required
3. default
4. unique
5. readonly

quantr-365-cli -c createlist --username [email protected] --password xxx --from https://quantr.sharepoint.com/tiffany --listname testing --field type=9,title=testnum1

Create list from json

quantr-365-cli -c createlist --username [email protected] --password xxx --from https://quantr.sharepoint.com/tiffany/Lists/testing4 --listname testing4 --json xx.json

Export list

quantr-365-cli -c exportlist --username [email protected] --password xxx --from https://quantr.sharepoint.com/tiffany/Lists/testing4 --listname testing4

Clone list (Same tenant)

quantr-365-cli -c clonelist --username [email protected] --password xxx --from https://quantr.sharepoint.com/tiffany/Lists/claim%20form --to https://quantr.sharepoint.com/tiffany/Lists --titlefield Title

Clone list (Different tenant)

quantr-365-cli -c clonelist --username [email protected] --password xxx --usernameDest [email protected] --passwordDest xxx --from https://quantr.sharepoint.com/dev/lists/list1 --to https://xxx.sharepoint.com/eform/lists/list1 --titlefield Title

Get list

node dist/index.js -c getlist --username [email protected] --password xxx --from https://quantr.sharepoint.com/tiffany --listname testing6