# Enhancing file update loaded in a project

**URL:** <https://community.datagrok.ai/t/enhancing-file-update-loaded-in-a-project/821>\
**Category:** Questions\
**Tags:** datagrok\
**Created:** [December 4, 2023, 12:14am UTC](https://community.datagrok.ai/t/enhancing-file-update-loaded-in-a-project/821 "2023-12-04T00:14:36Z")\
**Posts on this page:** 16\
**Page:** 1

<div class="post-metadata">

**Author:** ![kosuketakeuchi0621](https://community.datagrok.ai/user_avatar/community.datagrok.ai/kosuketakeuchi0621/32/547_2.png) [@kosuketakeuchi0621](https://community.datagrok.ai/u/kosuketakeuchi0621)\
**Post date:** [December 4, 2023, 12:14am UTC](https://community.datagrok.ai/t/enhancing-file-update-loaded-in-a-project/821/1 "2023-12-04T00:14:36Z")

</div>

If a project saved in “Projects” is referencing files in a folder that is accessible from Datagrok, is it possible to configure it to reload the data when the loaded files are updated to the latest version?

As far as I have confirmed, when saving a project data is embedded stably not dynamiccaly, meaning that changes to the loaded files will not be reflected even if they are modified.

---

<div class="post-metadata">

**Author:** ![oahadzhanian.datagrok.ai](https://community.datagrok.ai/user_avatar/community.datagrok.ai/oahadzhanian.datagrok.ai/32/545_2.png) [@oahadzhanian.datagrok.ai](https://community.datagrok.ai/u/oahadzhanian.datagrok.ai)\
**Post date:** [December 4, 2023, 9:42am UTC](https://community.datagrok.ai/t/enhancing-file-update-loaded-in-a-project/821/2 "2023-12-04T09:42:58Z")

</div>

Hello, Kosuke Takeuchi,

Thank you for your feedback! To save a project with automatic data updating capability, enable the **Data sync** option when uploading the project.  
In the GIF, I upload the project with **Data sync** enabled and after that update the dataset. The changes to the dataset automatically update the project. This is noticeable in the scatterplot and the dataframe itself.  
 ![Data-sync](https://community.datagrok.ai/uploads/default/original/1X/c7706c7e2220d73ecb869d119f8deec6cd30229d.gif)

---

<div class="post-metadata">

**Author:** ![kosuketakeuchi0621](https://community.datagrok.ai/user_avatar/community.datagrok.ai/kosuketakeuchi0621/32/547_2.png) [@kosuketakeuchi0621](https://community.datagrok.ai/u/kosuketakeuchi0621)\
**Post date:** [December 4, 2023, 11:39pm UTC](https://community.datagrok.ai/t/enhancing-file-update-loaded-in-a-project/821/3 "2023-12-04T23:39:39Z")

</div>

Thank you for your quick response and also .gif image. It’s easy to understand, “Seeing is Believing.”  
Let me confirm an additional point. In my environment, Data-sync option does not appear. Do have any idea for this phenomenon? I should also ask my colleague in charge about it.

---

<div class="post-metadata">

**Author:** ![skalkin](https://community.datagrok.ai/user_avatar/community.datagrok.ai/skalkin/32/5_2.png) [@skalkin](https://community.datagrok.ai/u/skalkin)\
**Post date:** [December 5, 2023, 2:05am UTC](https://community.datagrok.ai/t/enhancing-file-update-loaded-in-a-project/821/4 "2023-12-05T02:05:40Z")

</div>

This option appears when you open a dataset from a reproducible source, like querying a database or opening a file from the file share in “Files”. But if you open a local file, this option won’t appear since you cannot “replay” it.

---

<div class="post-metadata">

**Author:** ![kosuketakeuchi0621](https://community.datagrok.ai/user_avatar/community.datagrok.ai/kosuketakeuchi0621/32/547_2.png) [@kosuketakeuchi0621](https://community.datagrok.ai/u/kosuketakeuchi0621)\
**Post date:** [December 5, 2023, 7:09am UTC](https://community.datagrok.ai/t/enhancing-file-update-loaded-in-a-project/821/5 "2023-12-05T07:09:25Z")

</div>

Hi, Andrew,  
Thank you for clarification. Unfortunately, I loaded .sdf file from “Files” but data-sync option didn’t show up. Windows file server is used and is conncected to “Files” in my environment. I guess there seems to be an internal configuration issue there, so I will let my collegue in charge know to check.  
On the other hand, I am good to hear that I will be able to use data-sync option when loading a synchronizable file once I can fix this issue.

---

<div class="post-metadata">

**Author:** ![kosuketakeuchi0621](https://community.datagrok.ai/user_avatar/community.datagrok.ai/kosuketakeuchi0621/32/547_2.png) [@kosuketakeuchi0621](https://community.datagrok.ai/u/kosuketakeuchi0621)\
**Post date:** [December 6, 2023, 9:40am UTC](https://community.datagrok.ai/t/enhancing-file-update-loaded-in-a-project/821/6 "2023-12-06T09:40:44Z")

</div>

Let me notify that I found that I can use data-sync option when loading .csv file. On the other hand, when loading .sdf file data-sync option disappeared. It would be helpful if I could know whether this issue can be fixed or not. I would appreciate your kind support. Thanks, Kosuke

---

<div class="post-metadata">

**Author:** ![oahadzhanian.datagrok.ai](https://community.datagrok.ai/user_avatar/community.datagrok.ai/oahadzhanian.datagrok.ai/32/545_2.png) [@oahadzhanian.datagrok.ai](https://community.datagrok.ai/u/oahadzhanian.datagrok.ai)\
**Post date:** [December 6, 2023, 12:15pm UTC](https://community.datagrok.ai/t/enhancing-file-update-loaded-in-a-project/821/7 "2023-12-06T12:15:08Z")

</div>

Thank you for bringing this to our attention. You can monitor the progress of the bug fix through this ticket:  
Projects: data-sync option is not shown for .sdf files [#2566](https://github.com/datagrok-ai/public/issues/2566)

---

<div class="post-metadata">

**Author:** ![kosuketakeuchi0621](https://community.datagrok.ai/user_avatar/community.datagrok.ai/kosuketakeuchi0621/32/547_2.png) [@kosuketakeuchi0621](https://community.datagrok.ai/u/kosuketakeuchi0621)\
**Post date:** [December 6, 2023, 2:31pm UTC](https://community.datagrok.ai/t/enhancing-file-update-loaded-in-a-project/821/8 "2023-12-06T14:31:38Z")

</div>

Thank you for your help to deal with it.

---

<div class="post-metadata">

**Author:** ![kosuketakeuchi0621](https://community.datagrok.ai/user_avatar/community.datagrok.ai/kosuketakeuchi0621/32/547_2.png) [@kosuketakeuchi0621](https://community.datagrok.ai/u/kosuketakeuchi0621)\
**Post date:** [January 6, 2024, 12:55am UTC](https://community.datagrok.ai/t/enhancing-file-update-loaded-in-a-project/821/9 "2024-01-06T00:55:38Z")

</div>

Hi,  
Was it difficult to fix the bug for loading the latest SDF file that I requested the other day? Thank you for considering it.

I have also been considering if there is any alternative solution without using SDF. I checked how to merge compound\_structure.csv including id and MolBlock data into the main\_table\_data.csv file. Although the datasync option appears when using two csv files, an error message, “NullError: method not found: ‘gv’ on null” was shown and I cannot display the merged data when opening the saved project. The behavior of not being able to load the data when using the Joining table may be a new bug. For your information, I could confirm the same error showing when using very simple mock csv files.

Currently, it may be appropriate to prepare a single csv file in advance including table data and structural data as MolBlock format in order to load the latest data without using SDF.

---

<div class="post-metadata">

**Author:** ![oahadzhanian.datagrok.ai](https://community.datagrok.ai/user_avatar/community.datagrok.ai/oahadzhanian.datagrok.ai/32/545_2.png) [@oahadzhanian.datagrok.ai](https://community.datagrok.ai/u/oahadzhanian.datagrok.ai)\
**Post date:** [January 8, 2024, 3:58pm UTC](https://community.datagrok.ai/t/enhancing-file-update-loaded-in-a-project/821/10 "2024-01-08T15:58:20Z")

</div>

Hi Kosuke,

I’m pleased to inform you that we’ve added the datasync option for SDF files in the 1.17.9 platform version, and you can now save SDF files to the projects with synchronization.

Additionally, I was able to reproduce the error you mentioned, and we will fix it soon. Thank you for the feedback.

---

<div class="post-metadata">

**Author:** ![seritaka.gmail.com](https://community.datagrok.ai/user_avatar/community.datagrok.ai/seritaka.gmail.com/32/482_2.png) [@seritaka.gmail.com](https://community.datagrok.ai/u/seritaka.gmail.com)\
**Post date:** [January 9, 2024, 12:00am UTC](https://community.datagrok.ai/t/enhancing-file-update-loaded-in-a-project/821/11 "2024-01-09T00:00:02Z")

</div>

Hi,  
Thank you for your information!  
We are using 1.17.10 platform now, and should we run update command to use datasync for SDF?  
And can we apply the option to the project which was made before the update?  
Thanks,  
Taka

---

<div class="post-metadata">

**Author:** ![kosuketakeuchi0621](https://community.datagrok.ai/user_avatar/community.datagrok.ai/kosuketakeuchi0621/32/547_2.png) [@kosuketakeuchi0621](https://community.datagrok.ai/u/kosuketakeuchi0621)\
**Post date:** [January 9, 2024, 9:19am UTC](https://community.datagrok.ai/t/enhancing-file-update-loaded-in-a-project/821/12 "2024-01-09T09:19:45Z")

</div>

Thank you for your wonderful information. I confirmed datasync behavior when reading SDF file. Great job.

Besides, thank you for checking unwanted behavior about a project using joining table between tables. That would be helpful for someone in future if it can be fixed.

---

<div class="post-metadata">

**Author:** ![oahadzhanian.datagrok.ai](https://community.datagrok.ai/user_avatar/community.datagrok.ai/oahadzhanian.datagrok.ai/32/545_2.png) [@oahadzhanian.datagrok.ai](https://community.datagrok.ai/u/oahadzhanian.datagrok.ai)\
**Post date:** [January 10, 2024, 7:32am UTC](https://community.datagrok.ai/t/enhancing-file-update-loaded-in-a-project/821/13 "2024-01-10T07:32:22Z")

</div>

Hi Taka,

There is no need to update 1.17.10 platform to use datasync for SDF. The data synchronization option is automatically available for projects created earlier if the method of obtaining their tables (the `.script` tag) is saved.

Best regards,  
Olena

---

<div class="post-metadata">

**Author:** ![kosuketakeuchi0621](https://community.datagrok.ai/user_avatar/community.datagrok.ai/kosuketakeuchi0621/32/547_2.png) [@kosuketakeuchi0621](https://community.datagrok.ai/u/kosuketakeuchi0621)\
**Post date:** [January 30, 2024, 1:41am UTC](https://community.datagrok.ai/t/enhancing-file-update-loaded-in-a-project/821/14 "2024-01-30T01:41:16Z")

</div>

Hi,

I would like to know current situation aobut unwanted behavior when using joinning table function. It is written just above your reply.

> …, an error message, “NullError: method not found: ‘gv’ on null” was shown and I cannot display the merged data when opening the saved project…

Hopefully, this will be fixed soon. If you have any questions or comments, please let me know.  
Best regards,  
Kosuke

---

<div class="post-metadata">

**Author:** ![alex.paramonov](https://community.datagrok.ai/user_avatar/community.datagrok.ai/alex.paramonov/32/9_2.png) [@alex.paramonov](https://community.datagrok.ai/u/alex.paramonov)\
**Post date:** [January 30, 2024, 10:23pm UTC](https://community.datagrok.ai/t/enhancing-file-update-loaded-in-a-project/821/15 "2024-01-30T22:23:58Z")

</div>

Hi,  
Unfortunately, there is no support for cross-table data-sync functions such as join tables.  
Datagrok still tries to capture everything that happens with tables and captures joinTable function, but it can’t be reproduced.

We planned to include this support in 1.19.0.

---

<div class="post-metadata">

**Author:** ![kosuketakeuchi0621](https://community.datagrok.ai/user_avatar/community.datagrok.ai/kosuketakeuchi0621/32/547_2.png) [@kosuketakeuchi0621](https://community.datagrok.ai/u/kosuketakeuchi0621)\
**Post date:** [January 30, 2024, 11:16pm UTC](https://community.datagrok.ai/t/enhancing-file-update-loaded-in-a-project/821/16 "2024-01-30T23:16:37Z")

</div>

Hi Alex,  
Thank you for your sincere effort to tackle this issue.
