📤Exporting your Cycle data

Cycle lets you get your data out of the system easily. Whether you need it for data analysis or any other purpose, we provide you with simple export CTA that will present your data in a CSV format.

You can export all the major objects and assets from Cycle:

• The Docs - Feedback, Quotes or Requests

• The Customers - People and Companies

• The Release notes - with their release and linked request

• The Members - with their current state and role

• The Assets - Video, Images or any other file

For any export, you'll receive an email with a link to a downloadable CSV file.

Export the Docs - Feedback, Quotes or Request

You can export from any View (Lists, Tables, Boards).

How to:

1. Open a view that lists your items.

2. Click ••• → Export in CSV.

3. Choose your format and confirm.

Tip: If you create a view (Feedback, Quotes or Requests) without any filters, the export will include all your data of that object. 🎯

If you need to script the export, use the following mutation:

exportDocs(boardId: ID!): Boolean

The columns in your CSV file:

Columns may vary depending on your properties and the type of docs you're exporting (i.e: Feedback, Quotes, Requests) but here are the common ones and their meaning.

Column	Meaning
uuid	uuid of the doc as referenced in the database
id	key of the doc
type	name of the doc type
title	title of the doc
content	content in html
assigneeName	name of the member assigned to the doc (for Feedback and Quote, this is the reporter)
assignee	email of the member assigned to the doc (for Feedback and Quote, this is the reporter)
aiState	Wether it was created by AI, verified or created by human (not present for Feedback)
status	status name value
source	url from where the doc was created
sourceType	type of source
creator	email of the user who created the doc
createdAt	creation date of the doc (ISO 8601 format)

Export the Customers - People & Companies

How to:

1. Navigate to your Customer view or your Customer settings

2. Click on the export icon on the top right of the screen

3. Confirm and wait for the email

If you need to script the export, use the following mutation:

exportCustomers(productId: ID!, withFeedback: Boolean): Boolean

The columns in your CSV file:

Column	Meaning
id	uuid of the customer as referenced in the database
createdAt	standard date format
email	email of the customer
name	name of the customer
nbFeedbacks	number of Feedback linked
nbQuotes	number of Quotes linked
companyId	uuid of the company associated
company	company name
companyCustomId	custom uuid used in an external CRM
attioId, hubspotId, intercomId, salesforceId, zendeskId, pipedriveId, snowflakeId	uuid in external CRM
arr	arr amount of the company
leadStatus	status of the lead
closeDate	date of the lead closing
industry	company industry
country	company country
numberOfEmployees	number of employees in the company

Export the Release notes

How to:

1. Navigate to your releases section

2. Click on the ••• → Export in CSV

3. Confirm and wait for the email

If you need to script the export, use the following mutation:

exportReleaseNotes(productId: ID!): Boolean

The columns in your CSV file:

Column	Meaning
id	uuid of the release note as referenced in the database
createdAt	standard date format of the creation date
releaseNoteTitle	title of the release note
releaseNoteContent	release note content in html
isPublished	whether or not this release note is part of the public changelog
releaseId	uuid of the corresponding release
releaseDate	date of the release
releaseTitle	title of the release
docId	uuid of the associated Request
docTitle	title of the associated Request
makers	list of makers
tags	list of tags
position	position of the release note
isOther	whether or not the release note is part of the bugs and improvements section
updatedAt	standard date format of the last update date

Export the Members

How to:

1. Navigate to your User settings (make sure you have a Maker role)

2. Click on the export icon on the top right of the screen

3. Wait for the email

If you need to script the export, use the following mutation:

exportMembers(productId: ID!): Boolean

The columns of your CSV file:

Column	Meaning
id	uuid of the user as referenced in the database
createdAt	creation date in ISO 8601 format
email	email of the member
firstName	first name
lastName	last name
jobTitle	job title as referenced during the onboarding
role	whether this user was a USER, COLLABORATOR or MAKER
onboarded	whether this user completed his onboarding
userJourney	stage of the onboarding

Export the Assets - Video, Images or any other file

Exporting the assets is a bit trickier than the rest of the objects as you'll need to download each file locally. Worry not, we've prepared a command line to download the assets you'll get from the CSV file.

How to:

1. Open the workspace dropdown

2. Click on the Export assets CTA

3. Wait for the email

If you need to script the export, use the following mutation:

exportAssets(productId: ID!): Boolean

You now have a list of the distant files hosted on Cycle's infrastructure. To download them locally, you'll need to generate an authentication cookie and curl them. See below:

1. Login to Cycle and create a Cycle API token from the API settings in Cycle

1. Use this token to generate a cookie that will give you access to the assets with the following mutation (replace yourToken with your actual Cycle token)

curl 'https://api.product.cycle.app/graphql' -H 'Authorization: Bearer yourToken' -H 'Content-Type: application/json' -d '{"query":"mutation { assetAccess }"}'

It should return something like "cld_token=exp=..."

1. Set up your cookie as an environment variable with COOKIE=cld_token=exp=...

2. Navigate to the folder where you saved your CSV file

3. Start downloading your files with the following command (replace your_csv_file.csv with your actual file name)

   awk -F, 'NR>1 {print $2}' your_csv_file.csv | tr -d '"' | xargs -n1 -P4 -I{} curl --progress-bar -L --retry 3 --retry-delay 5 --continue-at - -b "$COOKIE" -O {}

   It usually takes 2 minutes to download 5Gb depending on you internet connexion.

The columns of your CSV file:

Column	Meaning
id	the public id of the asset
url	the url to reach your asset
type	type of asset. Can be video image or raw
tags	uuid of the product and/or the doc where this asset is used
bytes	size in bytes
height	height of the asset in px
width	width of the asset in px
hasAudio	whether or not this asset has audio

FAQ

Why didn't I receive my email yet?

Depending on the number of elements to export and the number of files being generated, an export can be queued and delayed several minutes. If the mail didn't land in your inbox after 1 hour reach out at [email protected]

How long can I access my data?

The data will be accessible until the 31st of October. After this date, it will be permanently deleted. Make sure to export every object you may need in the future before that date.

Why should I download my assets?

Your assets will stay reachable until the 31st of October. After this date, they will be permanently deleted. You should therefore download them safely either locally or on a distant machine.

I don't have access to the member/customer settings. How can I export them?

To access the settings, you need to be a MAKER. Either ask a MAKER of your workspace to update your role from COLLABORATOR to MAKER or use the API method to receive the email.