Import & export
Import reviews and UGC from a CSV file, export them as CSV or JSON, and follow each import and export under Activity.
The Import & export page brings reviews and UGC over from another platform with a CSV file, and exports what Cevoid has collected as a CSV or JSON file. Imports and exports run in the background, and the page lists each one under Activity.
Navigate to Settings → Import & export to import or export data.
Data types
The Import & export page has a row for each data type, with Import and Export. The steps, the columns, and what an import does with data already in your workspace are in each module's article.
| Data type | What it holds | Read more |
|---|---|---|
| Product reviews | Reviews of individual products, with their ratings, photos and videos, and replies | Import and export reviews |
| Company reviews | Reviews of your store and the buying experience | Import and export reviews |
| User-generated content | Photos and videos from social media or another UGC platform | Import and export UGC |
How imports and exports work
Every import and every export holds one data type.
- Imports: In the import editor, you select the Source platform your file comes from, upload a CSV file, map its columns to Cevoid's fields, and check a preview of the first 30 rows. Uploading the file saves the import as a draft, so you can finish it later. The draft keeps its data type and source platform: to change them, start a new import. Once you start the import, it runs in the background, and you can leave the page.
- Exports: In the export editor, you select a Format and a Date range, and the preview shows how many rows match and the first 30 of them. CSV files can be imported back into Cevoid, and JSON files keep nested data. When the file is ready, Cevoid emails you a link.
| Specification | Limit |
|---|---|
| File type | .csv, UTF-8 |
| File size | 50 MiB |
| Columns | 200 per file |
| Rows | 500,000 per file for reviews, 100,000 for UGC |
| Imports at a time | One per data type |
| Exports at a time | 3 waiting or running |
| Drafts and uploaded files | Kept for 7 days |
| Export files and error reports | Kept for 7 days |
| Activity | Lists each run for a year after it finishes |
Only the team member who created an import can change, start, stop, or delete it. Anyone on your team can open a run, download its files, and undo a review import.
Activity
Activity, below the data types, lists every import and export in your workspace, newest first. Select All, Imports, or Exports above the list to filter it.
| Column | What it shows |
|---|---|
| Job | The direction and the data type, such as Import · User-generated content |
| Rows | How many rows the run has processed |
| Status | The run's status. See Run statuses |
| When | When the run finished, or when it was created if it hasn't finished. Hover over it to see the date and time |
Click a run to open it. A draft opens in the import editor, and any other run opens its details.
The ... menu on a row holds the actions the run has: Download export, Download error report, Delete draft, and, for a review import, Undo import. See Undo an import.
Run details
A run's details open in a panel over the page. While the run is running, they show its progress: the current step, and how far it has come in percent.
| Row | What it shows |
|---|---|
| Source | The source platform of an import. Exports show Cevoid |
| File | The name of the imported file |
| Format | CSV or JSON |
| Initiated by | The team member who started the run |
| File expires | When the run's file can no longer be downloaded |
| Status | The run's status |
| Error | Why the run failed, if it did |
| Rows, Created, Updated, Skipped, Error items, Processed | For an import: the rows in the file, and what happened to them. Each count shows once it's above 0 |
| Exported | For an export: the rows in the file |
Below the details are the buttons the run has:
- Stop import: Ends an import that's queued or running. See Stop an import.
- Download export, Download error report: Download the run's files. See Download an export or an error report.
- View reviews, View posts: Open what a finished import brought in, filtered to that import
- Configure new import, Configure new export: Open a new run of the same data type, after a run failed or was cancelled. The old run stays as it is.
- Undo import: Deletes the reviews a review import created. See Undo an import.
Run statuses
A run's badge shows its status, under Activity and in its details. When a run failed, was cancelled, expired, or completed with errors, hover over the badge to see more.
| Status | What it means |
|---|---|
| Draft | An import that's saved and not started |
| Queued | Waiting to start |
| The current step, such as Importing posts and media | Running. The steps are in the table below |
| Completed | Finished: every row is imported or skipped, or the export file is ready |
| Completed with errors | Finished, but some rows couldn't be imported. The error report lists them |
| Expired | The export's file is no longer available to download |
| Failed | Stopped before it finished. Hover over the badge to see why |
| Cancelled | Someone stopped the import, or its draft expired before it was started |
While a run is running, its badge shows the step it's on:
| Data type | Import steps | Export steps |
|---|---|---|
| Product reviews, Company reviews | Validating reviews, Importing reviews, Checking review safety, Finishing import | Loading reviews, Building export file, Securing download, Finishing export |
| User-generated content | Validating posts, Importing posts and media, Finishing import | Loading posts, Building export file, Securing download, Finishing export |
Download an export or an error report
An export's file and an import's error report can be downloaded for 7 days, by anyone on your team. An import has an error report only when it skipped a row or left something out.
- Navigate to Settings → Import & export
- Click ... on the run under Activity
- Select Download export or Download error report. The download starts.
You can also open the run and click Download export or Download error report in its details. The email Cevoid sends when an export is ready opens the export's details. What an error report lists is in Import and export reviews and Import and export UGC.
Stop an import
Stop import ends an import that's queued or running. What it already imported stays, and you can start another import of the same data type. Only the team member who created the import can stop it.
- Navigate to Settings → Import & export
- Open the import under Activity. Its details open.
- Click Stop import. The status changes to Cancelled.
Stopping doesn't remove what the import brought in. To delete the reviews an import created, see Undo an import. A UGC import can't be undone: see Remove imported posts.
Delete an import draft
Deleting a draft takes it off Activity, and it can no longer be started. Reviews and posts from earlier imports stay as they are. Only the team member who created the draft can delete it.
- Navigate to Settings → Import & export
- Click ... on the draft under Activity
- Select Delete draft
- Click Delete draft to confirm
You can also delete a draft in the import editor, with More → Delete draft.