Bulk Load Example¶
task: Bulk load instances of
relation/LineRelation/user: provider administrator
hierarchy:
55b9daeca6165413b9d166deBulk load file:
LineRelation.xlsx
Snippet of file to Bulk load: LineRelation.xlsx
# Hierarchy Node |
# Device |
# CFT Template |
# Directory Number |
# Alerting Name |
|---|---|---|---|---|
sys.prov1.cust1. locus1 |
10.120.2.216, 8443, prov1.cust1 |
line-cft |
90218 |
techsupport |
sys.prov1.cust1. locus1 |
10.120.2.216, 8443, prov1.cust1 |
line-cft |
90219 |
techsupport |
sys.prov1.cust1. locus1 |
10.120.2.216, 8443, prov1.cust1 |
line-cft |
90220 |
techsupport |
sys.prov1.cust1. locus1 |
10.120.2.216, 8443, prov1.cust1 |
line-cft |
90221 |
techsupport |
sys.prov1.cust1. locus1 |
10.120.2.216, 8443, prov1.cust1 |
line-cft |
90222 |
techsupport |
Upload the file:
$ curl -v
-H 'Authorization: Basic YWRtaW5AcHJvdjEuY29tOnBhc3N3b3Jk'
-F uploadedfile='@LineRelation.xlsx'
'http://localhost/api/uploadfiles/
?hierarchy=55b9daeca6165413b9d166de'* About to connect() to localhost port 80 (#0)
+ Trying 127.0.0.1... connected
> POST /api/uploadfiles/?hierarchy=55b9daeca6165413b9d166de HTTP/1.1
> Authorization: Basic YWRtaW5AcHJvdjEuY29tOnBhc3N3b3Jk
> User-Agent: curl/7.22.0 (x86_64-pc-linux-gnu)
libcurl/7.22.0
OpenSSL/1.0.1
zlib/1.2.3.4
libidn/1.23
librtmp/2.3
> Host: localhost
> Accept: */*
> Content-Length: 10455
> Expect: 100-continue
> Content-Type: multipart/form-data;
boundary=----------------------------5a0f36378f19
>
< HTTP/1.1 100 Continue
< HTTP/1.1 200 OK
< Server: nginx/1.1.19
< Date: Thu, 30 Jul 2015 15:09:25 GMT
< Content-Type: text/html; charset=utf-8
< Transfer-Encoding: chunked
< Connection: keep-alive
< Vary: Accept-Encoding
< Vary: Accept, Cookie, Accept-Language, X-CSRFToken
< Content-Language: en-us
< Allow: POST, OPTIONS
< X-CSRFToken: C4ceiFEWSbjif1O4Jzhr1gZV9ytd9f2F
< Set-Cookie: csrftoken=C4ceiFEWSbjif1O4Jzhr1gZV9ytd9f2F;
SameSite=Lax;
httponly;
Path=/
< Set-Cookie: sessionid=07z03pbatb1qelahcc01ygufgzsr6i35;
SameSite=Lax;
httponly;
Path=/
<
+ Connection #0 to host localhost left intact
+ Closing connection #0
{"uploadedfiles": [
{"name": "LineRelation.xlsx",
"id": "55ba3e25a616541bb906b209"}
]}
Bulk load the file:
$ curl -v
-H 'Authorization: Basic YWRtaW5AcHJvdjEuY29tOnBhc3N3b3Jk'
-H 'Content-Type: application/json'
-H 'accept: application/json'
--data-binary '{"bulkload_file":"LineRelation.xlsx",
"execute_immediately":true}'
-X POST 'http://localhost/api/tool/BulkLoad/?
hierarchy=55b9daeca6165413b9d166de
&method=bulkload_spreadsheet
&nowait=true
&format=json'
+ About to connect() to localhost port 80 (#0)
+ Trying 127.0.0.1... connected
> POST /api/tool/BulkLoad/
?hierarchy=55b9daeca6165413b9d166de
&method=bulkload_spreadsheet
&nowait=true
&format=json HTTP/1.1
> Authorization: Basic YWRtaW5AcHJvdjEuY29tOnBhc3N3b3Jk
> User-Agent: curl/7.22.0 (x86_64-pc-linux-gnu)
libcurl/7.22.0
OpenSSL/1.0.1
zlib/1.2.3.4
libidn/1.23
librtmp/2.3
> Host: localhost
> Content-Type: application/json
> accept: application/json
> Content-Length: 64
>
+ upload completely sent off: 64out of 64 bytes
< HTTP/1.1 202 ACCEPTED
< Server: nginx/1.1.19
< Date: Thu, 30 Jul 2015 14:51:22 GMT
< Content-Type: application/json
< Transfer-Encoding: chunked
< Connection: keep-alive
< Vary: Accept, Cookie, Accept-Language, X-CSRFToken
< Content-Language: en-us
< Allow: GET, POST, HEAD, OPTIONS
< X-CSRFToken: iFh5q8FUBxoXyyiLcELHoO8W5IDFbAiP
< Set-Cookie: csrftoken=iFh5q8FUBxoXyyiLcELHoO8W5IDFbAiP;
httponly;
Path=/
< Set-Cookie: sessionid=3ayny2y73i43u6sj9bdyoawhhtr8wbm8;
httponly;
Path=/
<
+ Connection #0 to host localhost left intact
+ Closing connection #0
{"href": "/api/tool/Transaction/16e1e599-494a-4898-944a-0528915d2f42/",
"success": true,
"transaction_id": "16e1e599-494a-4898-944a-0528915d2f42"}