Spy Push for Asset Trees removed existing worksheets

[John Holland]

Hi all,

Just want to check if I am seeing something unexpected.

I had a workbook with 6 existing worksheets.

After I pushed an Asset Tree to this workbook, I had the new worksheet created by the push, but no other worksheets.

Previous items created by anaylsis in this workbook still existed.

Is this expected behaviour? I didn't see it called out in the documentation.

 

Thanks.

 

 

[John Cox]

Hello John,

Sorry for the delay in responding. This is not expected behavior. When you have a chance, please document this as well as you can in an "IT support" ticket by going to https://support.seeq.com/, then clicking on Contact Support at the top right. This is something that our support team will want to diagnose. Thank you!

John

[Nick Blum]

I'm experiencing the same behavior. Curious if the Seeq team has been able to reproduce this? Should I also submit a ticket? 

[Dak Kanner]

Hello,

This should be fixed in SPy version 193.17 and above. You can run spy.upgrade() or pip install seeq-spy to get the latest version immediately.

As a workaround without updating, this can be prevented by specifying the ID of the workbook or including the folder path (E.G. workbook='Folder 01 >> Analysis Jan 1...') instead of using just the workbook's name.

 

You can get your incorrectly trashed worksheets back using the below code block.

from seeq import sdk, spy
items_api = sdk.ItemsApi(spy.client)
wb = spy.workbooks.pull('https://your.seeq.host/workbook/.../worksheet/...', include_archived=True, include_referenced_workbooks=False)
for worksheet in wb[0].worksheets:
    if 'Archived' in worksheet and worksheet['Archived']:
        items_api.delete_property(id=worksheet.id, property_name='Archived')
        print(f'Unarchived worksheet "{worksheet.name}" {worksheet.id}')

 

Please let me know if you encounter any problems with that.

Edited yesterday at 03:16 PM by Dak Kanner