#community-help

Checking Imported Rows in Typesense Server

TLDR andy was uncertain about how to view imported rows on Typesense server. Jason guided them to use a GET /collections command and further clarified to use curl from the command line. Ultimately, andy successfully imported their json file.

Powered by Struct AI

2

Dec 02, 2022 (13 months ago)
andy
Photo of md5-8f2bc7de8159dde57045bf51154aed5b
andy
02:36 PM
is there a command to show how many 'rows' i have imported to the typesense server?
Jason
Photo of md5-8813087cccc512313602b6d9f9ece19f
Jason
02:43 PM
If you do a GET /collections that will show you the schema along with the number of documents in each collection
andy
Photo of md5-8f2bc7de8159dde57045bf51154aed5b
andy
02:48 PM
can i do that at the command line?

with

typesense-server --data-dir=/var/lib/typesense --api-key=bxxx
02:48
andy
02:48 PM
i am using php
02:48
andy
02:48 PM
for the client
Jason
Photo of md5-8813087cccc512313602b6d9f9ece19f
Jason
02:48 PM
You can use curl from the command line
andy
Photo of md5-8f2bc7de8159dde57045bf51154aed5b
andy
02:51 PM
ok, great
02:51
andy
02:51 PM
"name":"websites","num_documents":0,
03:06
andy
03:06 PM
it creates the schema, but doesnt import the json file
03:13
andy
03:13 PM
ok, great, it was the json file, i jq'd it to jsonl and

1

03:13
andy
03:13 PM
"name":"websites","num_documents":100,"
03:14
andy
03:14 PM
and it works 🙂
03:14
andy
03:14 PM
thanks

1

Typesense

Lightning-fast, open source search engine for everyone | Knowledge Base powered by Struct.AI

Indexed 3015 threads (79% resolved)

Join Our Community

Similar Threads

Issues with Importing Typesense Collection to Different Server

Kevin had problems migrating a Typesense collection between Docusaurus sites on different machines. Jason advised them on JSONL format, handling server hosting, and creating a collection schema before importing documents, leading to successful import.

3

35
3mo

Troubleshooting Typesense Document Import Error

Christopher had trouble importing 2.1M documents into Typesense due to memory errors. Jason clarified the system requirements, explaining the correlation between RAM and dataset size, and ways to tackle the issue. They both also discussed database-like query options.

3

30
10mo

Revisiting Typesense for Efficient DB Indexing and Querying

kopach experienced slow indexing and crashes with Typesense. The community suggested to use batch import and check the server's resources. Improvements were made but additional support was needed for special characters and multi-search queries.

1

46
9mo

Typesense Server Bulk Import/Upsert Issue Resolved

Adam was confused about the discrepancy between the successful responses and the actual indexed data while working with a custom WP plugin integrating with Typesense. The issue was a bug related to fetching documents in the wrong order, not a Typesense problem.

2

22
7mo

Handling Large JSON File for Typesense

Matt struggled with processing a large JSON file for Typesense. Kishore Nallan explained how to create a schema, convert to JSONL, and import the file. They also identified the necessary keys from the JSON.

1

19
8mo