Import CSV - Ultipa Transporter

Change Password

Submit

Change Email

Submit

Change Nickname

Current Nickname:

Submit

Profile

Account ID:

Full Name:
Phone:
Company:
Company Email:
Country:
Language:

Change Password

Apply

You have no license application record.

Apply

Certificate	Issued at	Valid until	Serial No.	File

Serial No.	Valid until	File

Not having one? Apply now! >>>

Product	Created On	ID	Amount (USD)	Invoice

Product	Created On	ID	Amount (USD)	Invoice

No Invoice

Create Ultipa Account

Already have an Ultipa account? Sign in now!

Forgot Password

Reset Password

Back to sign in

Import CSV

Header without Type

Read node files person.csv and company.csv and edge file holding.csv from SFTP or local directory, import into Ultipa graphset shareholding:

From CSV (Header w/o Type) to Ultipa

1. Generate sample configuration file

./ultipa-importer --sample

2. Modify configuration file

# Configure data source type
mode: csv

# Configure SFTP information where the files locate, or read from a local direcotry by default
sftp:
  host: 10.132.3.136:22
  username: admin
  password: abcd1234
  # Path of key, configuring this will ignore the 'username' and 'password'
  key:  ./my_secret

# Configure Ultipa server
server:
  # Ultipa server, use comma ',' to separate multiple server nodes of cluster
  host: "192.168.2.149:60075"
  username: "admin"
  password: "abcd1234"
  # Graphset name, or use graphset 'default' by default
  graphset: "shareholding"
  # The directory of the SSL certificate when both Ultipa server and client-end are in SSL mode
  crt: ""

# Configure node data
nodeConfig:
  - schema: "human"
    file: /Data/person.csv
    head: true
    properties:
      - name: id
        type: _id
      - name: name
        type: string
      - name: type
        type: _ignore
  - schema: "firm"
    file: /Data/company.csv
    head: true
    properties:
      - name: id
        type: _id
      - name: name
        type: string
      - name: type
        type: _ignore

# Configure edge data
edgeConfig:
  - schema: "hold"
    file: /Data/holding.csv
    head: true
    properties:
      - name: from
        type: _from
      - name: to
        type: _to
      - name: shareInt
        type: int32
        new_name: share
        
# Configure global settings
settings:
  batchSize: 10000
  importMode: insert
  # auto-create graph, schema, and properties if not existent
  yes: true

3. Execute import

./ultipa-importer --config ./import.sample.csv.yml

Header with Type

Read node files person.csv and company.csv and edge file holding.csv from SFTP or local directory, import into Ultipa graphset shareholding:

From CSV (Header with Type) to Ultipa

1. Generate sample configuration file

./ultipa-importer --sample

2. Modify configuration file

# Configure data source type
mode: csv

# Configure SFTP information where the files locate, or read from a local direcotry by default
sftp:
  host: 10.132.3.136:22
  username: admin
  password: abcd1234
  # Path of key, configuring this will ignore the 'username' and 'password'
  key:  ./my_secret

# Configure Ultipa server
server:
  # Ultipa server, use comma ',' to separate multiple server nodes of cluster
  host: "192.168.2.149:60075"
  username: "admin"
  password: "abcd1234"
  # Graphset name, or use graphset 'default' by default
  graphset: "shareholding"
  # The directory of the SSL certificate when both Ultipa server and client-end are in SSL mode
  crt: ""

# Configure node data
nodeConfig:
  - schema: "human"
    file: /Data/person.csv
    head: true
    properties:
      - name: type
        type: _ignore
  - schema: "firm"
    file: /Data/company.csv
    head: true
    properties:
      - name: type
        type: _ignore
        
# Configure edge data
edgeConfig:
  - schema: "hold"
    file: /Data/holding.csv
    head: true
        
# Configure global settings
settings:
  batchSize: 10000
  importMode: insert
  # auto-create graph, schema, and properties if not existent
  yes: true

3. Execute import

./ultipa-importer --config ./import.sample.csv.yml

Headerless

Read node files person.csv and company.csv and edge file holding.csv from SFTP or local directory, import into Ultipa graphset shareholding:

From CSV (Headerless) to Ultipa

1. Generate sample configuration file

./ultipa-importer --sample

2. Modify configuration file

# Configure data source type
mode: csv

# Configure SFTP information where the files locate, or read from a local direcotry by default
sftp:
  host: 10.132.3.136:22
  username: admin
  password: abcd1234
  # Path of key, configuring this will ignore the 'username' and 'password'
  key:  ./my_secret

# Configure Ultipa server
server:
  # Ultipa server, use comma ',' to separate multiple server nodes of cluster
  host: "192.168.2.149:60075"
  username: "admin"
  password: "abcd1234"
  # Graphset name, or use graphset 'default' by default
  graphset: "shareholding"
  # The directory of the SSL certificate when both Ultipa server and client-end are in SSL mode
  crt: ""

# Configure node data
nodeConfig:
  - schema: "human"
    file: /Data/person.csv
    head: false
    properties:
      - name: _id
        type: _id
      - name: name
        type: string
      - name: _ignore
        type: _ignore
  - schema: "firm"
    file: /Data/company.csv
    head: false
    properties:
      - name: _id
        type: _id
      - name: name
        type: string
      - name: _ignore
        type: _ignore
        
# Configure edge data
edgeConfig:
  - schema: "hold"
    file: /Data/holding.csv
    head: false
    properties:
      - name: _from
        type: _from
      - name: _to
        type: _to
      - name: share
        type: int32
        
# Configure global settings
settings:
  batchSize: 10000
  importMode: insert
  # auto-create graph, schema, and properties if not existent
  yes: true

3. Execute import

./ultipa-importer --config ./import.sample.csv.yml

Folder

Read CSV files in SFTP or local directory, import into Ultipa graphset shareholding. Individual configuration of file is not supported, use name of target schemas to name the files, and use the name and type of target properties to describe headers:

From CSV (Folder) to Ultipa

1. Generate sample configuration file

./ultipa-importer --sample

2. Modify configuration file

# Configure data source type
mode: csv

# Configure SFTP information where the files locate, or read from a local direcotry by default
sftp:
  host: 10.132.3.136:22
  username: admin
  password: abcd1234
  # Path of key, configuring this will ignore the 'username' and 'password'
  key:  ./my_secret

# Configure Ultipa server
server:
  # Ultipa server, use comma ',' to separate multiple server nodes of cluster
  host: "192.168.2.149:60075"
  username: "admin"
  password: "abcd1234"
  # Graphset name, or use graphset 'default' by default
  graphset: "shareholding"
  # The directory of the SSL certificate when both Ultipa server and client-end are in SSL mode
  crt: ""

# Configure node data
nodeConfig:
  - dir: /Data/importData
        
# Configure edge data
edgeConfig:
  - dir: /Data/importData
        
# Configure global settings
settings:
  batchSize: 10000
  importMode: insert
  # auto-create graph, schema, and properties if not existent
  yes: true

3. Execute import

./ultipa-importer --config ./import.sample.csv.yml

ID
Product
Status
Cores
Applied Validity Period(days)
Effective Date
Excpired Date
Mac Address
Apply Comment
Review Comment