# Values of some fields not included in the csv export of a list of records (table view

**URL:** <https://community.forestadmin.com/t/values-of-some-fields-not-included-in-the-csv-export-of-a-list-of-records-table-view/2368>\
**Category:** Help me!\
**Created:** [April 23, 2021, 3:21pm UTC](https://community.forestadmin.com/t/values-of-some-fields-not-included-in-the-csv-export-of-a-list-of-records-table-view/2368 "2021-04-23T15:21:45Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![julien\_swan](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/julien_swan/32/7851_2.png) [@julien\_swan](https://community.forestadmin.com/u/julien_swan)\
**Post date:** [April 23, 2021, 3:21pm UTC](https://community.forestadmin.com/t/values-of-some-fields-not-included-in-the-csv-export-of-a-list-of-records-table-view/2368/1 "2021-04-23T15:21:45Z")

</div>

This is a template you can use to report issues. You can also drag images, videos and include `Preformatted text`

## Expected behavior

When hitting **export _collection name_** under the Actions button, we are supposed to get a csv with all the fields and values for the view. For example, if I have a list of transactions, with two fields amount and debtor name, I want to see in the csv these two fields and the same values as the ones displayed on the screen.  
I have a record showing 100 in the amount field, and HelloWorld in the debtor name field, but in the csv export, I can see the record but the debtor name field is empty whereas it is not in Forest..

Thanks for your help,  
Julien

---

<div class="post-metadata">

**Author:** ![anon16419211](https://avatars.discourse-cdn.com/v4/letter/a/7cd45c/32.png) [@anon16419211](https://community.forestadmin.com/u/anon16419211)\
**Post date:** [April 23, 2021, 3:44pm UTC](https://community.forestadmin.com/t/values-of-some-fields-not-included-in-the-csv-export-of-a-list-of-records-table-view/2368/2 "2021-04-23T15:44:18Z")

</div>

Hello @julien_swan,

I tried to export my collection data and I didn’t have any issues on my side, can you tell me the step to reproduce your issue, are the fields not present coming from related data? What are types of the fields involved?

Thanks,

---

<div class="post-metadata">

**Author:** ![julien\_swan](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/julien_swan/32/7851_2.png) [@julien\_swan](https://community.forestadmin.com/u/julien_swan)\
**Post date:** [May 3, 2021, 9:34am UTC](https://community.forestadmin.com/t/values-of-some-fields-not-included-in-the-csv-export-of-a-list-of-records-table-view/2368/3 "2021-05-03T09:34:39Z")

</div>

Hi @anon16419211,

This is a text field, and I simply hit the export button…  
This field is not coming from related data.

Is there any way I could share that in pm?  
Thanks,  
Julien

---

<div class="post-metadata">

**Author:** ![anon37102731](https://avatars.discourse-cdn.com/v4/letter/a/c6cbf5/32.png) [@anon37102731](https://community.forestadmin.com/u/anon37102731)\
**Post date:** [May 3, 2021, 9:54am UTC](https://community.forestadmin.com/t/values-of-some-fields-not-included-in-the-csv-export-of-a-list-of-records-table-view/2368/4 "2021-05-03T09:54:23Z")

</div>

Hi @julien_swan,

All info you could share might help some other people experiencing the same issue to find an answer. It would be appreciate to keep the most informations on this thread rather than through PMs.

As for your issue, I’d like to take a look at your project from our end to see if I can find any visible issues.

To do so would you mind sharing with me the project name, environment name and collection on which you’re experiencing the issue.

Plus are you only having issues with this `debtor` field when exporting or other ones are broken too?

Thank you

---

<div class="post-metadata">

**Author:** ![julien\_swan](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/julien_swan/32/7851_2.png) [@julien\_swan](https://community.forestadmin.com/u/julien_swan)\
**Post date:** [May 3, 2021, 10:15am UTC](https://community.forestadmin.com/t/values-of-some-fields-not-included-in-the-csv-export-of-a-list-of-records-table-view/2368/5 "2021-05-03T10:15:46Z")

</div>

Hi @anon37102731,  
I understand, but some of the info is confidential 🙂  
I’d like to share this privately please.

Thanks

---

<div class="post-metadata">

**Author:** ![anon37102731](https://avatars.discourse-cdn.com/v4/letter/a/c6cbf5/32.png) [@anon37102731](https://community.forestadmin.com/u/anon37102731)\
**Post date:** [May 3, 2021, 12:19pm UTC](https://community.forestadmin.com/t/values-of-some-fields-not-included-in-the-csv-export-of-a-list-of-records-table-view/2368/6 "2021-05-03T12:19:42Z")

</div>

You can share infos through DMs but I’ll keep answering on this thread (omitting confidential data)

---

<div class="post-metadata">

**Author:** ![louis](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/louis/32/4_2.png) [@louis](https://community.forestadmin.com/u/louis)\
**Post date:** [May 7, 2021, 12:00pm UTC](https://community.forestadmin.com/t/values-of-some-fields-not-included-in-the-csv-export-of-a-list-of-records-table-view/2368/7 "2021-05-07T12:00:02Z")

</div>

Hi @julien_swan 👋

After further investigation, it appears that your problem is related to the amount of exported records.

- If you export few records, all smart fields are present in the export ✅

- If you export ~6,000 records, some smart fields are missing in the export ❌

Unfortunately, we can’t solve this problem as it is related to a performance issue due to the way your smart fields have been implemented. Forest needs to calculate the smart fields of your 6,000 records independently before the export…

To improve your export, you can either:

- Implement a [custom export smart action](https://docs.forestadmin.com/woodshop/how-tos/export-related-data-as-csv) (select all records + trigger a smart action)

- Optimize the way smart fields are implemented, using [hooks](https://docs.forestadmin.com/woodshop/how-tos/load-smart-fields-using-sequelizes-afterfind-hook) for ex

Hope that helps!
