How to migrate from CSV to KV store?

[tsawant]

I am trying to migrate from CSV to KV store following these steps:

1. Created collection.conf on the host in apps local directory as following:

[KV_collection]
enforceTypes = true
field.fieldname = string
field.fieldname = number
field.fieldname = number
field.fieldname = string
...

1. Created transform.conf on the host in apps local directory as following:

[KV_lookup]
external_type = kvstore
collection = KV_collection
fields_list = fieldname1, fieldname2...

1. Used following command to migrate from exciting CSV to KV store

| inputlookup lookup_tabl.csv | outputlookup KV_lookup

But getting error:
Error in 'outputlookup' command: The lookup table 'Permission denied for collection 'KV_collection'' is invalid

Can anyone help me where is the problem exactly?
Do I need any special permission to access the collection?
Also where can I find these collections that are created ?

[Atchyuth_P]

Hi @tsawant 

Please try to check the lookup definition permission whether it is in private or app.

Hoping this will resolve the issue

[duartet]

The file name should be collections.conf instead of collection.conf

[spyme72]

The KVStore could be present inside an app and you may be running the search from search app.
The search is not able to reach the kvstore. try running the search from the app where the kvstore is created.