search

Snowflake-Labs / Excelerator

This is an Excel Addin for Windows that reads and writes data to Snowflake
Apache License 2.0
78 stars 22 forks source link

Excelarator Add-in crashing when trying to use upload feature #28

Open KattaRci opened 2 years ago

KattaRci commented 2 years ago

When I try to use Excelerator upload feature, it crashes my excel and reloads it. I have traced it back and it goes as far as creating a temporary stage and the put command in snowflake. but doesn't really put the file in the temporary stage or load the data to the snowflake table.

ssegal100 commented 2 years ago

I believe you are using Excel 2013 correct? If so is there someone else that can try with a newer version? When you like at the History in Snowflake, is the 'Put' command the last thing you see? Steve

KattaRci commented 2 years ago

Most of us have Excel 2013 as a standard, but i can ask around and see if someone has a different version. Yes, out command is the last successful command as it shows in History Amar

ssegal100 commented 2 years ago

Would you increase the log level for the ODBC driver and upload the log files. The details can be found here: https://community.snowflake.com/s/article/How-to-generate-log-file-on-Snowflake-connectors#ODBC

KattaRci commented 2 years ago

I had one of my team member try the addin on excel 2016 and he was able to get little further than we were able to. He was getting all sorts of column and key issues while updating

ssegal100 commented 2 years ago

Let me know if you want to review the errors your colleague is getting. About your error, it looks like it will be a 2013 issue, but if there is anything in the odbc error logs, that might help also.

KattaRci commented 2 years ago

Sure, for 2016, let us know when you are available and I can have Bijo from my team join a session to work out the issues

KattaRci commented 2 years ago

I will send you the log details from 2013 as well in a little bit

KattaRci commented 2 years ago

Here are the logs from excel 2013 32-bit run...

KattaRci commented 2 years ago

files

KattaRci commented 2 years ago

Hi Steven, not sure if you received the log files as I do not see a upload button after attaching the files

ssegal100 commented 2 years ago

No I didn't get it. Try again and if I don't get it I'll send you my email.

KattaRci commented 2 years ago

No I wasn’t able to upload. Please share your email and I can share the details

From: Steven Segal @. Sent: Friday, November 12, 2021 6:45 PM To: Snowflake-Labs/Excelerator @.> Cc: Katta, Amarender @.>; State change @.> Subject: Re: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

This e-mail is from an external source. Use caution when opening attachments or clicking on links.

No I didn't get it. Try again and if I don't get it I'll send you my email.

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHubhttps://github.com/Snowflake-Labs/Excelerator/issues/28#issuecomment-967731063, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AWMV3UIDWORLBTP4BTHZR4DULWRJPANCNFSM5HTEXO4A. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

This email message (including all attachments) is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information, or may otherwise be protected by work product or other legal rules. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Unless otherwise indicated in the body of this email, nothing in this communication is intended to operate as an electronic signature and this transmission cannot be used to form, document, or authenticate a contract. Wyndham Destinations, Inc., and/or its affiliates may monitor all incoming and outgoing email communications, including the content of emails and attachments, for security, legal compliance, training, quality assurance and other purposes.

The sender believes that this email and any attachments were free of any virus, worm, Trojan horse, malicious code and/or other contaminants when sent. Email transmissions cannot be guaranteed to be secure or error-free, so this message and its attachments could have been infected, corrupted or made incomplete during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for any viruses or other defects that may arise, and for taking remedial action relating to such viruses and other defects. Neither Wyndham Destinations, Inc., nor any of its affiliated entities is liable for any loss or damage arising in any way from, or for errors or omissions in the contents of, this message or its attachments.

KattaRci commented 2 years ago

no I am not able to upload. Tried it again. Please share your email

ssegal100 commented 2 years ago

@KattaRci Thank you for sending the logs. I'm seeing 3 items: 1 - Crashing after the PUT command. There is nothing in the log files that is helping me. We haven't tested in with Excel 2013 so I would recommend upgrading if possible. 2 - "Check file key and master key" error. Jason will work with you on this one. You will have to open up a ticket with Snowflake Support. While the Excelerator is not directly supported, the ODBC driver is. This is an encryption issue and some mismatch with keys. 3 - 'Please set the data type by...' This issue is occuring because you will need to define the data types for all new columns. In the Snowflake section of the Excel ribbon you will see a button called 'Define Data Types'. Click that and a new row will be inserted at the top of the spreadsheet. Each cell will contain a drop down where you can select the data type.

Hope this helps. Steve

KattaRci commented 2 years ago

Thanks Steven.

We will work with Jason on option#2 and give it a try.

We also sent the 2016 logs to Jason and think we are close. Is it something you are someone can help us identify the issue and fix it.

@Bijo, can you have Alka or Sabith try the below in 2013 and see if these help.

-Amar

From: Steven Segal @. Sent: Monday, November 15, 2021 5:08 PM To: Snowflake-Labs/Excelerator @.> Cc: Katta, Amarender @.>; Mention @.> Subject: Re: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

This e-mail is from an external source. Use caution when opening attachments or clicking on links.

@KattaRcihttps://github.com/KattaRci Thank you for sending the logs. I'm seeing 3 items: 1 - Crashing after the PUT command. There is nothing in the log files that is helping me. We haven't tested in with Excel 2013 so I would recommend upgrading if possible. 2 - "Check file key and master key" error. Jason will work with you on this one. You will have to open up a ticket with Snowflake Support. While the Excelerator is not directly supported, the ODBC driver is. This is an encryption issue and some mismatch with keys. 3 - 'Please set the data type by...' This issue is occuring because you will need to define the data types for all new columns. In the Snowflake section of the Excel ribbon you will see a button called 'Define Data Types'. Click that and a new row will be inserted at the top of the spreadsheet. Each cell will contain a drop down where you can select the data type.

Hope this helps. Steve

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/Snowflake-Labs/Excelerator/issues/28#issuecomment-969367576, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AWMV3UMA4SQVUEXQICMXJ3DUMGAF3ANCNFSM5HTEXO4A. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

This email message (including all attachments) is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information, or may otherwise be protected by work product or other legal rules. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Unless otherwise indicated in the body of this email, nothing in this communication is intended to operate as an electronic signature and this transmission cannot be used to form, document, or authenticate a contract. Wyndham Destinations, Inc., and/or its affiliates may monitor all incoming and outgoing email communications, including the content of emails and attachments, for security, legal compliance, training, quality assurance and other purposes.

The sender believes that this email and any attachments were free of any virus, worm, Trojan horse, malicious code and/or other contaminants when sent. Email transmissions cannot be guaranteed to be secure or error-free, so this message and its attachments could have been infected, corrupted or made incomplete during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for any viruses or other defects that may arise, and for taking remedial action relating to such viruses and other defects. Neither Wyndham Destinations, Inc., nor any of its affiliated entities is liable for any loss or damage arising in any way from, or for errors or omissions in the contents of, this message or its attachments.

ssegal100 commented 2 years ago

@KattaRci From the documents you sent, it looks like #2 and #3 are from the 2016 version. Is that not the case?

KattaRci commented 2 years ago

Jason, can we setup a quick 30mins call to go over #2 and #3 so we can get this resolved.

-Amar

From: Katta, Amarender Sent: Tuesday, November 16, 2021 7:59 AM To: Snowflake-Labs/Excelerator @.>; Snowflake-Labs/Excelerator @.> Cc: Mention @.>; Jason Merenda @.>; James, Bijo @.>; Singh, Alka @.> Subject: RE: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

Thanks Steven.

We will work with Jason on option#2 and give it a try.

We also sent the 2016 logs to Jason and think we are close. Is it something you are someone can help us identify the issue and fix it.

@Bijo, can you have Alka or Sabith try the below in 2013 and see if these help.

-Amar

From: Steven Segal @. Sent: Monday, November 15, 2021 5:08 PM To: Snowflake-Labs/Excelerator @*.**@*.>> Cc: Katta, Amarender @*.**@*.>>; Mention @*.**@*.***>> Subject: Re: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

This e-mail is from an external source. Use caution when opening attachments or clicking on links.

@KattaRcihttps://github.com/KattaRci Thank you for sending the logs. I'm seeing 3 items: 1 - Crashing after the PUT command. There is nothing in the log files that is helping me. We haven't tested in with Excel 2013 so I would recommend upgrading if possible. 2 - "Check file key and master key" error. Jason will work with you on this one. You will have to open up a ticket with Snowflake Support. While the Excelerator is not directly supported, the ODBC driver is. This is an encryption issue and some mismatch with keys. 3 - 'Please set the data type by...' This issue is occuring because you will need to define the data types for all new columns. In the Snowflake section of the Excel ribbon you will see a button called 'Define Data Types'. Click that and a new row will be inserted at the top of the spreadsheet. Each cell will contain a drop down where you can select the data type.

Hope this helps. Steve

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/Snowflake-Labs/Excelerator/issues/28#issuecomment-969367576, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AWMV3UMA4SQVUEXQICMXJ3DUMGAF3ANCNFSM5HTEXO4A. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

This email message (including all attachments) is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information, or may otherwise be protected by work product or other legal rules. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Unless otherwise indicated in the body of this email, nothing in this communication is intended to operate as an electronic signature and this transmission cannot be used to form, document, or authenticate a contract. Wyndham Destinations, Inc., and/or its affiliates may monitor all incoming and outgoing email communications, including the content of emails and attachments, for security, legal compliance, training, quality assurance and other purposes.

The sender believes that this email and any attachments were free of any virus, worm, Trojan horse, malicious code and/or other contaminants when sent. Email transmissions cannot be guaranteed to be secure or error-free, so this message and its attachments could have been infected, corrupted or made incomplete during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for any viruses or other defects that may arise, and for taking remedial action relating to such viruses and other defects. Neither Wyndham Destinations, Inc., nor any of its affiliated entities is liable for any loss or damage arising in any way from, or for errors or omissions in the contents of, this message or its attachments.

KattaRci commented 2 years ago

We have sent two sets of emails, one was from 2013 excel and other was 2016. Let me know if you want me to resend them.

-Amar

From: Steven Segal @. Sent: Tuesday, November 16, 2021 8:04 AM To: Snowflake-Labs/Excelerator @.> Cc: Katta, Amarender @.>; Mention @.> Subject: Re: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

This e-mail is from an external source. Use caution when opening attachments or clicking on links.

@KattaRcihttps://github.com/KattaRci From the documents you sent, it looks like #2https://github.com/Snowflake-Labs/Excelerator/issues/2 and #3https://github.com/Snowflake-Labs/Excelerator/issues/3 are from the 2016 version. Is that not the case?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/Snowflake-Labs/Excelerator/issues/28#issuecomment-970253038, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AWMV3UNXOZ2TXDJM5R5SYN3UMJJENANCNFSM5HTEXO4A. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

This email message (including all attachments) is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information, or may otherwise be protected by work product or other legal rules. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Unless otherwise indicated in the body of this email, nothing in this communication is intended to operate as an electronic signature and this transmission cannot be used to form, document, or authenticate a contract. Wyndham Destinations, Inc., and/or its affiliates may monitor all incoming and outgoing email communications, including the content of emails and attachments, for security, legal compliance, training, quality assurance and other purposes.

The sender believes that this email and any attachments were free of any virus, worm, Trojan horse, malicious code and/or other contaminants when sent. Email transmissions cannot be guaranteed to be secure or error-free, so this message and its attachments could have been infected, corrupted or made incomplete during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for any viruses or other defects that may arise, and for taking remedial action relating to such viruses and other defects. Neither Wyndham Destinations, Inc., nor any of its affiliated entities is liable for any loss or damage arising in any way from, or for errors or omissions in the contents of, this message or its attachments.

KattaRci commented 2 years ago

Sure. How about 3:00 EST?

For 2. If the log files that you sent have that error then you can open a case and add those log files to them. But Support will want the ODBC log for sure.

For 3. You should see a button in the Excel ribbon. Click that button and you will see row 1 appear that will let you define the data types on the columns.

As an aside I also asked Steven about your stages question on using a pre-existing stage. The answer is yes and you set it up in the config.

[image: Screen Shot 2021-11-15 at 4.37.56 PM.png]

As an aside I also asked Steven about your stages question on using a pre-existing stage. The answer is yes and you set it up in the config.

[image: Screen Shot 2021-11-15 at 4.35.24 PM.png]

On Wed, Nov 17, 2021 at 9:52 AM Katta, Amarender < @.***> wrote:

Jason, can we setup a quick 30mins call to go over #2 and #3 so we can get this resolved.

-Amar

From: Katta, Amarender Sent: Tuesday, November 16, 2021 7:59 AM To: Snowflake-Labs/Excelerator < @.>; Snowflake-Labs/Excelerator @.> Cc: Mention @.>; Jason Merenda < @.>; James, Bijo @.>; Singh, Alka @.> Subject: RE: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

Thanks Steven.

We will work with Jason on option#2 and give it a try.

We also sent the 2016 logs to Jason and think we are close. Is it something you are someone can help us identify the issue and fix it.

@Bijo, can you have Alka or Sabith try the below in 2013 and see if these help.

-Amar

From: Steven Segal @. @.>] Sent: Monday, November 15, 2021 5:08 PM To: Snowflake-Labs/Excelerator @.> Cc: Katta, Amarender @.>; Mention < @.**> Subject:* Re: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

This e-mail is from an external source. Use caution when opening attachments or clicking on links.

@KattaRci https://github.com/KattaRci Thank you for sending the logs. I'm seeing 3 items: 1 - Crashing after the PUT command. There is nothing in the log files that is helping me. We haven't tested in with Excel 2013 so I would recommend upgrading if possible. 2 - "Check file key and master key" error. Jason will work with you on this one. You will have to open up a ticket with Snowflake Support. While the Excelerator is not directly supported, the ODBC driver is. This is an encryption issue and some mismatch with keys. 3 - 'Please set the data type by...' This issue is occuring because you will need to define the data types for all new columns. In the Snowflake section of the Excel ribbon you will see a button called 'Define Data Types'. Click that and a new row will be inserted at the top of the spreadsheet. Each cell will contain a drop down where you can select the data type.

Hope this helps. Steve

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/Snowflake-Labs/Excelerator/issues/28#issuecomment-969367576, or unsubscribe https://github.com/notifications/unsubscribe-auth/AWMV3UMA4SQVUEXQICMXJ3DUMGAF3ANCNFSM5HTEXO4A . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub. [image: Image removed by sender.]

This email message (including all attachments) is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information, or may otherwise be protected by work product or other legal rules. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Unless otherwise indicated in the body of this email, nothing in this communication is intended to operate as an electronic signature and this transmission cannot be used to form, document, or authenticate a contract. Wyndham Destinations, Inc., and/or its affiliates may monitor all incoming and outgoing email communications, including the content of emails and attachments, for security, legal compliance, training, quality assurance and other purposes.

The sender believes that this email and any attachments were free of any virus, worm, Trojan horse, malicious code and/or other contaminants when sent. Email transmissions cannot be guaranteed to be secure or error-free, so this message and its attachments could have been infected, corrupted or made incomplete during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for any viruses or other defects that may arise, and for taking remedial action relating to such viruses and other defects. Neither Wyndham Destinations, Inc., nor any of its affiliated entities is liable for any loss or damage arising in any way from, or for errors or omissions in the contents of, this message or its attachments.

-- Jason merenda Senior Sales Engineer MOBILE +1 813 842 4295 EMAIL @.***

Snowflake Inc. Tampa, FL

KattaRci commented 2 years ago

Yes, Bijo tried #3 and now he is running into #2 error(Check file key and master key). Bijo works out of India office, so 3pm EST might be late night for him. Can we do little earlier.

From: Jason Merenda @. Sent: Wednesday, November 17, 2021 10:05 AM To: Katta, Amarender @.> Cc: Snowflake-Labs/Excelerator @.>; Snowflake-Labs/Excelerator @.>; Mention @.>; James, Bijo @.>; Singh, Alka @.***> Subject: Re: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

This e-mail is from an external source. Use caution when opening attachments or clicking on links.

Sure. How about 3:00 EST?

For 2. If the log files that you sent have that error then you can open a case and add those log files to them. But Support will want the ODBC log for sure.

For 3. You should see a button in the Excel ribbon. Click that button and you will see row 1 appear that will let you define the data types on the columns.

As an aside I also asked Steven about your stages question on using a pre-existing stage. The answer is yes and you set it up in the config.

[Screen Shot 2021-11-15 at 4.37.56 PM.png]

As an aside I also asked Steven about your stages question on using a pre-existing stage. The answer is yes and you set it up in the config.

[Screen Shot 2021-11-15 at 4.35.24 PM.png]

On Wed, Nov 17, 2021 at 9:52 AM Katta, Amarender @.**@.>> wrote: Jason, can we setup a quick 30mins call to go over #2 and #3 so we can get this resolved.

-Amar

From: Katta, Amarender Sent: Tuesday, November 16, 2021 7:59 AM To: Snowflake-Labs/Excelerator @.**@.>>; Snowflake-Labs/Excelerator @.**@.>> Cc: Mention @.**@.>>; Jason Merenda @.**@.>>; James, Bijo @.**@.>>; Singh, Alka @.**@.>> Subject: RE: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

Thanks Steven.

We will work with Jason on option#2 and give it a try.

We also sent the 2016 logs to Jason and think we are close. Is it something you are someone can help us identify the issue and fix it.

@Bijo, can you have Alka or Sabith try the below in 2013 and see if these help.

-Amar

From: Steven Segal @. Sent: Monday, November 15, 2021 5:08 PM To: Snowflake-Labs/Excelerator @*.**@*.>> Cc: Katta, Amarender @*.**@*.>>; Mention @*.**@*.***>> Subject: Re: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

This e-mail is from an external source. Use caution when opening attachments or clicking on links.

@KattaRcihttps://github.com/KattaRci Thank you for sending the logs. I'm seeing 3 items: 1 - Crashing after the PUT command. There is nothing in the log files that is helping me. We haven't tested in with Excel 2013 so I would recommend upgrading if possible. 2 - "Check file key and master key" error. Jason will work with you on this one. You will have to open up a ticket with Snowflake Support. While the Excelerator is not directly supported, the ODBC driver is. This is an encryption issue and some mismatch with keys. 3 - 'Please set the data type by...' This issue is occuring because you will need to define the data types for all new columns. In the Snowflake section of the Excel ribbon you will see a button called 'Define Data Types'. Click that and a new row will be inserted at the top of the spreadsheet. Each cell will contain a drop down where you can select the data type.

Hope this helps. Steve

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/Snowflake-Labs/Excelerator/issues/28#issuecomment-969367576, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AWMV3UMA4SQVUEXQICMXJ3DUMGAF3ANCNFSM5HTEXO4A. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

This email message (including all attachments) is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information, or may otherwise be protected by work product or other legal rules. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Unless otherwise indicated in the body of this email, nothing in this communication is intended to operate as an electronic signature and this transmission cannot be used to form, document, or authenticate a contract. Wyndham Destinations, Inc., and/or its affiliates may monitor all incoming and outgoing email communications, including the content of emails and attachments, for security, legal compliance, training, quality assurance and other purposes.

The sender believes that this email and any attachments were free of any virus, worm, Trojan horse, malicious code and/or other contaminants when sent. Email transmissions cannot be guaranteed to be secure or error-free, so this message and its attachments could have been infected, corrupted or made incomplete during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for any viruses or other defects that may arise, and for taking remedial action relating to such viruses and other defects. Neither Wyndham Destinations, Inc., nor any of its affiliated entities is liable for any loss or damage arising in any way from, or for errors or omissions in the contents of, this message or its attachments.

-- Jason merenda Senior Sales Engineer MOBILE +1 813 842 4295 EMAIL @.**@.>

[Image removed by sender.]

Snowflake Inc. Tampa, FL

This email message (including all attachments) is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information, or may otherwise be protected by work product or other legal rules. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Unless otherwise indicated in the body of this email, nothing in this communication is intended to operate as an electronic signature and this transmission cannot be used to form, document, or authenticate a contract. Wyndham Destinations, Inc., and/or its affiliates may monitor all incoming and outgoing email communications, including the content of emails and attachments, for security, legal compliance, training, quality assurance and other purposes.

The sender believes that this email and any attachments were free of any virus, worm, Trojan horse, malicious code and/or other contaminants when sent. Email transmissions cannot be guaranteed to be secure or error-free, so this message and its attachments could have been infected, corrupted or made incomplete during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for any viruses or other defects that may arise, and for taking remedial action relating to such viruses and other defects. Neither Wyndham Destinations, Inc., nor any of its affiliated entities is liable for any loss or damage arising in any way from, or for errors or omissions in the contents of, this message or its attachments.

KattaRci commented 2 years ago

Yeah that will difficult for him. How about 9:00 AM tomorrow?

On Wed, Nov 17, 2021 at 10:39 AM Katta, Amarender < @.***> wrote:

Yes, Bijo tried #3 and now he is running into #2 error(Check file key and master key). Bijo works out of India office, so 3pm EST might be late night for him. Can we do little earlier.

From: Jason Merenda @. Sent: Wednesday, November 17, 2021 10:05 AM To: Katta, Amarender @.> Cc: Snowflake-Labs/Excelerator < @.>; Snowflake-Labs/Excelerator @.>; Mention < @.>; James, Bijo @.>; Singh, Alka @.**> Subject:* Re: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

This e-mail is from an external source. Use caution when opening attachments or clicking on links.

Sure. How about 3:00 EST?

For 2. If the log files that you sent have that error then you can open a case and add those log files to them. But Support will want the ODBC log for sure.

For 3. You should see a button in the Excel ribbon. Click that button and you will see row 1 appear that will let you define the data types on the columns.

As an aside I also asked Steven about your stages question on using a pre-existing stage. The answer is yes and you set it up in the config.

[image: Screen Shot 2021-11-15 at 4.37.56 PM.png]

As an aside I also asked Steven about your stages question on using a pre-existing stage. The answer is yes and you set it up in the config.

[image: Screen Shot 2021-11-15 at 4.35.24 PM.png]

On Wed, Nov 17, 2021 at 9:52 AM Katta, Amarender < @.***> wrote:

Jason, can we setup a quick 30mins call to go over #2 and #3 so we can get this resolved.

-Amar

From: Katta, Amarender Sent: Tuesday, November 16, 2021 7:59 AM To: Snowflake-Labs/Excelerator < @.>; Snowflake-Labs/Excelerator @.> Cc: Mention @.>; Jason Merenda < @.>; James, Bijo @.>; Singh, Alka @.> Subject: RE: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

Thanks Steven.

We will work with Jason on option#2 and give it a try.

We also sent the 2016 logs to Jason and think we are close. Is it something you are someone can help us identify the issue and fix it.

@Bijo, can you have Alka or Sabith try the below in 2013 and see if these help.

-Amar

From: Steven Segal @. @.>] Sent: Monday, November 15, 2021 5:08 PM To: Snowflake-Labs/Excelerator @.> Cc: Katta, Amarender @.>; Mention < @.**> Subject:* Re: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

This e-mail is from an external source. Use caution when opening attachments or clicking on links.

@KattaRci https://github.com/KattaRci Thank you for sending the logs. I'm seeing 3 items: 1 - Crashing after the PUT command. There is nothing in the log files that is helping me. We haven't tested in with Excel 2013 so I would recommend upgrading if possible. 2 - "Check file key and master key" error. Jason will work with you on this one. You will have to open up a ticket with Snowflake Support. While the Excelerator is not directly supported, the ODBC driver is. This is an encryption issue and some mismatch with keys. 3 - 'Please set the data type by...' This issue is occuring because you will need to define the data types for all new columns. In the Snowflake section of the Excel ribbon you will see a button called 'Define Data Types'. Click that and a new row will be inserted at the top of the spreadsheet. Each cell will contain a drop down where you can select the data type.

Hope this helps. Steve

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/Snowflake-Labs/Excelerator/issues/28#issuecomment-969367576, or unsubscribe https://github.com/notifications/unsubscribe-auth/AWMV3UMA4SQVUEXQICMXJ3DUMGAF3ANCNFSM5HTEXO4A . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub. [image: Image removed by sender.]

This email message (including all attachments) is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information, or may otherwise be protected by work product or other legal rules. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Unless otherwise indicated in the body of this email, nothing in this communication is intended to operate as an electronic signature and this transmission cannot be used to form, document, or authenticate a contract. Wyndham Destinations, Inc., and/or its affiliates may monitor all incoming and outgoing email communications, including the content of emails and attachments, for security, legal compliance, training, quality assurance and other purposes.

The sender believes that this email and any attachments were free of any virus, worm, Trojan horse, malicious code and/or other contaminants when sent. Email transmissions cannot be guaranteed to be secure or error-free, so this message and its attachments could have been infected, corrupted or made incomplete during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for any viruses or other defects that may arise, and for taking remedial action relating to such viruses and other defects. Neither Wyndham Destinations, Inc., nor any of its affiliated entities is liable for any loss or damage arising in any way from, or for errors or omissions in the contents of, this message or its attachments.

--

*Jason *merenda

Senior Sales Engineer MOBILE +1 813 842 4295 EMAIL @.***

[image: Image removed by sender.]

Snowflake Inc. Tampa, FL

This email message (including all attachments) is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information, or may otherwise be protected by work product or other legal rules. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Unless otherwise indicated in the body of this email, nothing in this communication is intended to operate as an electronic signature and this transmission cannot be used to form, document, or authenticate a contract. Wyndham Destinations, Inc., and/or its affiliates may monitor all incoming and outgoing email communications, including the content of emails and attachments, for security, legal compliance, training, quality assurance and other purposes.

The sender believes that this email and any attachments were free of any virus, worm, Trojan horse, malicious code and/or other contaminants when sent. Email transmissions cannot be guaranteed to be secure or error-free, so this message and its attachments could have been infected, corrupted or made incomplete during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for any viruses or other defects that may arise, and for taking remedial action relating to such viruses and other defects. Neither Wyndham Destinations, Inc., nor any of its affiliated entities is liable for any loss or damage arising in any way from, or for errors or omissions in the contents of, this message or its attachments.

-- Jason merenda Senior Sales Engineer MOBILE +1 813 842 4295 EMAIL @.***

Snowflake Inc. Tampa, FL

KattaRci commented 2 years ago

Bijo might be out in the evening(IST) tomorrow. Bijo, can you let us know what might work for you(tomorrow or Friday)

-Amar

From: Jason Merenda @. Sent: Wednesday, November 17, 2021 10:41 AM To: Katta, Amarender @.> Cc: Snowflake-Labs/Excelerator @.>; Snowflake-Labs/Excelerator @.>; Mention @.>; James, Bijo @.>; Singh, Alka @.***> Subject: Re: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

This e-mail is from an external source. Use caution when opening attachments or clicking on links.

Yeah that will difficult for him. How about 9:00 AM tomorrow?

On Wed, Nov 17, 2021 at 10:39 AM Katta, Amarender @.**@.>> wrote: Yes, Bijo tried #3 and now he is running into #2 error(Check file key and master key). Bijo works out of India office, so 3pm EST might be late night for him. Can we do little earlier.

From: Jason Merenda @.**@.>] Sent: Wednesday, November 17, 2021 10:05 AM To: Katta, Amarender @.**@.>> Cc: Snowflake-Labs/Excelerator @.**@.>>; Snowflake-Labs/Excelerator @.**@.>>; Mention @.**@.>>; James, Bijo @.**@.>>; Singh, Alka @.**@.>> Subject: Re: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

This e-mail is from an external source. Use caution when opening attachments or clicking on links.

Sure. How about 3:00 EST?

For 2. If the log files that you sent have that error then you can open a case and add those log files to them. But Support will want the ODBC log for sure.

For 3. You should see a button in the Excel ribbon. Click that button and you will see row 1 appear that will let you define the data types on the columns.

As an aside I also asked Steven about your stages question on using a pre-existing stage. The answer is yes and you set it up in the config.

[Screen Shot 2021-11-15 at 4.37.56 PM.png]

As an aside I also asked Steven about your stages question on using a pre-existing stage. The answer is yes and you set it up in the config.

[Screen Shot 2021-11-15 at 4.35.24 PM.png]

On Wed, Nov 17, 2021 at 9:52 AM Katta, Amarender @.**@.>> wrote: Jason, can we setup a quick 30mins call to go over #2 and #3 so we can get this resolved.

-Amar

From: Katta, Amarender Sent: Tuesday, November 16, 2021 7:59 AM To: Snowflake-Labs/Excelerator @.**@.>>; Snowflake-Labs/Excelerator @.**@.>> Cc: Mention @.**@.>>; Jason Merenda @.**@.>>; James, Bijo @.**@.>>; Singh, Alka @.**@.>> Subject: RE: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

Thanks Steven.

We will work with Jason on option#2 and give it a try.

We also sent the 2016 logs to Jason and think we are close. Is it something you are someone can help us identify the issue and fix it.

@Bijo, can you have Alka or Sabith try the below in 2013 and see if these help.

-Amar

From: Steven Segal @. Sent: Monday, November 15, 2021 5:08 PM To: Snowflake-Labs/Excelerator @*.**@*.>> Cc: Katta, Amarender @*.**@*.>>; Mention @*.**@*.***>> Subject: Re: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

This e-mail is from an external source. Use caution when opening attachments or clicking on links.

@KattaRcihttps://github.com/KattaRci Thank you for sending the logs. I'm seeing 3 items: 1 - Crashing after the PUT command. There is nothing in the log files that is helping me. We haven't tested in with Excel 2013 so I would recommend upgrading if possible. 2 - "Check file key and master key" error. Jason will work with you on this one. You will have to open up a ticket with Snowflake Support. While the Excelerator is not directly supported, the ODBC driver is. This is an encryption issue and some mismatch with keys. 3 - 'Please set the data type by...' This issue is occuring because you will need to define the data types for all new columns. In the Snowflake section of the Excel ribbon you will see a button called 'Define Data Types'. Click that and a new row will be inserted at the top of the spreadsheet. Each cell will contain a drop down where you can select the data type.

Hope this helps. Steve

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/Snowflake-Labs/Excelerator/issues/28#issuecomment-969367576, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AWMV3UMA4SQVUEXQICMXJ3DUMGAF3ANCNFSM5HTEXO4A. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

This email message (including all attachments) is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information, or may otherwise be protected by work product or other legal rules. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Unless otherwise indicated in the body of this email, nothing in this communication is intended to operate as an electronic signature and this transmission cannot be used to form, document, or authenticate a contract. Wyndham Destinations, Inc., and/or its affiliates may monitor all incoming and outgoing email communications, including the content of emails and attachments, for security, legal compliance, training, quality assurance and other purposes.

The sender believes that this email and any attachments were free of any virus, worm, Trojan horse, malicious code and/or other contaminants when sent. Email transmissions cannot be guaranteed to be secure or error-free, so this message and its attachments could have been infected, corrupted or made incomplete during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for any viruses or other defects that may arise, and for taking remedial action relating to such viruses and other defects. Neither Wyndham Destinations, Inc., nor any of its affiliated entities is liable for any loss or damage arising in any way from, or for errors or omissions in the contents of, this message or its attachments.

-- Jason merenda Senior Sales Engineer MOBILE +1 813 842 4295 EMAIL @.**@.>

[Image removed by sender.]

Snowflake Inc. Tampa, FL

This email message (including all attachments) is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information, or may otherwise be protected by work product or other legal rules. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Unless otherwise indicated in the body of this email, nothing in this communication is intended to operate as an electronic signature and this transmission cannot be used to form, document, or authenticate a contract. Wyndham Destinations, Inc., and/or its affiliates may monitor all incoming and outgoing email communications, including the content of emails and attachments, for security, legal compliance, training, quality assurance and other purposes.

The sender believes that this email and any attachments were free of any virus, worm, Trojan horse, malicious code and/or other contaminants when sent. Email transmissions cannot be guaranteed to be secure or error-free, so this message and its attachments could have been infected, corrupted or made incomplete during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for any viruses or other defects that may arise, and for taking remedial action relating to such viruses and other defects. Neither Wyndham Destinations, Inc., nor any of its affiliated entities is liable for any loss or damage arising in any way from, or for errors or omissions in the contents of, this message or its attachments.

-- Jason merenda Senior Sales Engineer MOBILE +1 813 842 4295 EMAIL @.**@.>

[Image removed by sender.]

Snowflake Inc. Tampa, FL

This email message (including all attachments) is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information, or may otherwise be protected by work product or other legal rules. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Unless otherwise indicated in the body of this email, nothing in this communication is intended to operate as an electronic signature and this transmission cannot be used to form, document, or authenticate a contract. Wyndham Destinations, Inc., and/or its affiliates may monitor all incoming and outgoing email communications, including the content of emails and attachments, for security, legal compliance, training, quality assurance and other purposes.

The sender believes that this email and any attachments were free of any virus, worm, Trojan horse, malicious code and/or other contaminants when sent. Email transmissions cannot be guaranteed to be secure or error-free, so this message and its attachments could have been infected, corrupted or made incomplete during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for any viruses or other defects that may arise, and for taking remedial action relating to such viruses and other defects. Neither Wyndham Destinations, Inc., nor any of its affiliated entities is liable for any loss or damage arising in any way from, or for errors or omissions in the contents of, this message or its attachments.

ssegal100 commented 2 years ago

You won't be able to insert or update any data from the ODBC driver until #2 is fixed. So looks like you solved the issue from #3 but #2 is preventing you from completing it. A Snowflake support ticket will need to be opened to solve this one.

KattaRci commented 2 years ago

Hi Jason, I am fine with Friday 9AM EST.

Thanks,

Bijo James Manager - Data Engineering C: +91 9986573431 @.**@.>

RCI India Pine Valley, First Level, Embassy Golf Links Business Park, Off Intermediate Ring Road, Bengaluru, Karnataka 560071 @.***<new%20logo>

From: Katta, Amarender @.> Sent: 17 November 2021 21:14 To: Jason Merenda @.> Cc: Snowflake-Labs/Excelerator @.>; Snowflake-Labs/Excelerator @.>; Mention @.>; James, Bijo @.>; Singh, Alka @.***> Subject: RE: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

Bijo might be out in the evening(IST) tomorrow. Bijo, can you let us know what might work for you(tomorrow or Friday)

-Amar

From: Jason Merenda @. Sent: Wednesday, November 17, 2021 10:41 AM To: Katta, Amarender @*.**@*.>> Cc: Snowflake-Labs/Excelerator @*.**@*.>>; Snowflake-Labs/Excelerator @*.**@*.>>; Mention @*.**@*.>>; James, Bijo @*.**@*.>>; Singh, Alka @*.**@*.***>> Subject: Re: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

This e-mail is from an external source. Use caution when opening attachments or clicking on links.

Yeah that will difficult for him. How about 9:00 AM tomorrow?

On Wed, Nov 17, 2021 at 10:39 AM Katta, Amarender @.**@.>> wrote: Yes, Bijo tried #3 and now he is running into #2 error(Check file key and master key). Bijo works out of India office, so 3pm EST might be late night for him. Can we do little earlier.

From: Jason Merenda @.**@.>] Sent: Wednesday, November 17, 2021 10:05 AM To: Katta, Amarender @.**@.>> Cc: Snowflake-Labs/Excelerator @.**@.>>; Snowflake-Labs/Excelerator @.**@.>>; Mention @.**@.>>; James, Bijo @.**@.>>; Singh, Alka @.**@.>> Subject: Re: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

This e-mail is from an external source. Use caution when opening attachments or clicking on links.

Sure. How about 3:00 EST?

For 2. If the log files that you sent have that error then you can open a case and add those log files to them. But Support will want the ODBC log for sure.

For 3. You should see a button in the Excel ribbon. Click that button and you will see row 1 appear that will let you define the data types on the columns.

As an aside I also asked Steven about your stages question on using a pre-existing stage. The answer is yes and you set it up in the config.

[Screen Shot 2021-11-15 at 4.37.56 PM.png]

As an aside I also asked Steven about your stages question on using a pre-existing stage. The answer is yes and you set it up in the config.

[Screen Shot 2021-11-15 at 4.35.24 PM.png]

On Wed, Nov 17, 2021 at 9:52 AM Katta, Amarender @.**@.>> wrote: Jason, can we setup a quick 30mins call to go over #2 and #3 so we can get this resolved.

-Amar

From: Katta, Amarender Sent: Tuesday, November 16, 2021 7:59 AM To: Snowflake-Labs/Excelerator @.**@.>>; Snowflake-Labs/Excelerator @.**@.>> Cc: Mention @.**@.>>; Jason Merenda @.**@.>>; James, Bijo @.**@.>>; Singh, Alka @.**@.>> Subject: RE: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

Thanks Steven.

We will work with Jason on option#2 and give it a try.

We also sent the 2016 logs to Jason and think we are close. Is it something you are someone can help us identify the issue and fix it.

@Bijo, can you have Alka or Sabith try the below in 2013 and see if these help.

-Amar

From: Steven Segal @. Sent: Monday, November 15, 2021 5:08 PM To: Snowflake-Labs/Excelerator @*.**@*.>> Cc: Katta, Amarender @*.**@*.>>; Mention @*.**@*.***>> Subject: Re: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

This e-mail is from an external source. Use caution when opening attachments or clicking on links.

@KattaRcihttps://github.com/KattaRci Thank you for sending the logs. I'm seeing 3 items: 1 - Crashing after the PUT command. There is nothing in the log files that is helping me. We haven't tested in with Excel 2013 so I would recommend upgrading if possible. 2 - "Check file key and master key" error. Jason will work with you on this one. You will have to open up a ticket with Snowflake Support. While the Excelerator is not directly supported, the ODBC driver is. This is an encryption issue and some mismatch with keys. 3 - 'Please set the data type by...' This issue is occuring because you will need to define the data types for all new columns. In the Snowflake section of the Excel ribbon you will see a button called 'Define Data Types'. Click that and a new row will be inserted at the top of the spreadsheet. Each cell will contain a drop down where you can select the data type.

Hope this helps. Steve

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/Snowflake-Labs/Excelerator/issues/28#issuecomment-969367576, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AWMV3UMA4SQVUEXQICMXJ3DUMGAF3ANCNFSM5HTEXO4A. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

This email message (including all attachments) is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information, or may otherwise be protected by work product or other legal rules. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Unless otherwise indicated in the body of this email, nothing in this communication is intended to operate as an electronic signature and this transmission cannot be used to form, document, or authenticate a contract. Wyndham Destinations, Inc., and/or its affiliates may monitor all incoming and outgoing email communications, including the content of emails and attachments, for security, legal compliance, training, quality assurance and other purposes.

The sender believes that this email and any attachments were free of any virus, worm, Trojan horse, malicious code and/or other contaminants when sent. Email transmissions cannot be guaranteed to be secure or error-free, so this message and its attachments could have been infected, corrupted or made incomplete during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for any viruses or other defects that may arise, and for taking remedial action relating to such viruses and other defects. Neither Wyndham Destinations, Inc., nor any of its affiliated entities is liable for any loss or damage arising in any way from, or for errors or omissions in the contents of, this message or its attachments.

-- Jason merenda Senior Sales Engineer MOBILE +1 813 842 4295 EMAIL @.**@.>

[Image removed by sender.]

Snowflake Inc. Tampa, FL

This email message (including all attachments) is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information, or may otherwise be protected by work product or other legal rules. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Unless otherwise indicated in the body of this email, nothing in this communication is intended to operate as an electronic signature and this transmission cannot be used to form, document, or authenticate a contract. Wyndham Destinations, Inc., and/or its affiliates may monitor all incoming and outgoing email communications, including the content of emails and attachments, for security, legal compliance, training, quality assurance and other purposes.

The sender believes that this email and any attachments were free of any virus, worm, Trojan horse, malicious code and/or other contaminants when sent. Email transmissions cannot be guaranteed to be secure or error-free, so this message and its attachments could have been infected, corrupted or made incomplete during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for any viruses or other defects that may arise, and for taking remedial action relating to such viruses and other defects. Neither Wyndham Destinations, Inc., nor any of its affiliated entities is liable for any loss or damage arising in any way from, or for errors or omissions in the contents of, this message or its attachments.

-- Jason merenda Senior Sales Engineer MOBILE +1 813 842 4295 EMAIL @.**@.>

[Image removed by sender.]

Snowflake Inc. Tampa, FL

This email message (including all attachments) is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information, or may otherwise be protected by work product or other legal rules. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Unless otherwise indicated in the body of this email, nothing in this communication is intended to operate as an electronic signature and this transmission cannot be used to form, document, or authenticate a contract. Wyndham Destinations, Inc., and/or its affiliates may monitor all incoming and outgoing email communications, including the content of emails and attachments, for security, legal compliance, training, quality assurance and other purposes.

The sender believes that this email and any attachments were free of any virus, worm, Trojan horse, malicious code and/or other contaminants when sent. Email transmissions cannot be guaranteed to be secure or error-free, so this message and its attachments could have been infected, corrupted or made incomplete during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for any viruses or other defects that may arise, and for taking remedial action relating to such viruses and other defects. Neither Wyndham Destinations, Inc., nor any of its affiliated entities is liable for any loss or damage arising in any way from, or for errors or omissions in the contents of, this message or its attachments.

KattaRci commented 2 years ago

Sure Steven. Bijo is working on opening the support ticket. Will forward you the ticket# once we have it.

From: Steven Segal @. Sent: Wednesday, November 17, 2021 11:34 AM To: Snowflake-Labs/Excelerator @.> Cc: Katta, Amarender @.>; Mention @.> Subject: Re: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

This e-mail is from an external source. Use caution when opening attachments or clicking on links.

You won't be able to insert or update any data from the ODBC driver until #2https://github.com/Snowflake-Labs/Excelerator/issues/2 is fixed. So looks like you solved the issue from #3https://github.com/Snowflake-Labs/Excelerator/issues/3 but #2https://github.com/Snowflake-Labs/Excelerator/issues/2 is preventing you from completing it. A Snowflake support ticket will need to be opened to solve this one.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/Snowflake-Labs/Excelerator/issues/28#issuecomment-971750550, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AWMV3UMKLPQMFMU7BKM2W43UMPKPDANCNFSM5HTEXO4A. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

This email message (including all attachments) is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information, or may otherwise be protected by work product or other legal rules. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Unless otherwise indicated in the body of this email, nothing in this communication is intended to operate as an electronic signature and this transmission cannot be used to form, document, or authenticate a contract. Wyndham Destinations, Inc., and/or its affiliates may monitor all incoming and outgoing email communications, including the content of emails and attachments, for security, legal compliance, training, quality assurance and other purposes.

The sender believes that this email and any attachments were free of any virus, worm, Trojan horse, malicious code and/or other contaminants when sent. Email transmissions cannot be guaranteed to be secure or error-free, so this message and its attachments could have been infected, corrupted or made incomplete during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for any viruses or other defects that may arise, and for taking remedial action relating to such viruses and other defects. Neither Wyndham Destinations, Inc., nor any of its affiliated entities is liable for any loss or damage arising in any way from, or for errors or omissions in the contents of, this message or its attachments.

KattaRci commented 2 years ago

Here’s the support ticket# 00284970

From: Katta, Amarender Sent: Wednesday, November 17, 2021 11:41 AM To: Snowflake-Labs/Excelerator @.>; Snowflake-Labs/Excelerator @.> Cc: Mention @.>; James, Bijo @.> Subject: RE: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

Sure Steven. Bijo is working on opening the support ticket. Will forward you the ticket# once we have it.

From: Steven Segal @. Sent: Wednesday, November 17, 2021 11:34 AM To: Snowflake-Labs/Excelerator @*.**@*.>> Cc: Katta, Amarender @*.**@*.>>; Mention @*.**@*.***>> Subject: Re: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

This e-mail is from an external source. Use caution when opening attachments or clicking on links.

You won't be able to insert or update any data from the ODBC driver until #2https://github.com/Snowflake-Labs/Excelerator/issues/2 is fixed. So looks like you solved the issue from #3https://github.com/Snowflake-Labs/Excelerator/issues/3 but #2https://github.com/Snowflake-Labs/Excelerator/issues/2 is preventing you from completing it. A Snowflake support ticket will need to be opened to solve this one.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/Snowflake-Labs/Excelerator/issues/28#issuecomment-971750550, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AWMV3UMKLPQMFMU7BKM2W43UMPKPDANCNFSM5HTEXO4A. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

This email message (including all attachments) is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information, or may otherwise be protected by work product or other legal rules. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Unless otherwise indicated in the body of this email, nothing in this communication is intended to operate as an electronic signature and this transmission cannot be used to form, document, or authenticate a contract. Wyndham Destinations, Inc., and/or its affiliates may monitor all incoming and outgoing email communications, including the content of emails and attachments, for security, legal compliance, training, quality assurance and other purposes.

The sender believes that this email and any attachments were free of any virus, worm, Trojan horse, malicious code and/or other contaminants when sent. Email transmissions cannot be guaranteed to be secure or error-free, so this message and its attachments could have been infected, corrupted or made incomplete during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for any viruses or other defects that may arise, and for taking remedial action relating to such viruses and other defects. Neither Wyndham Destinations, Inc., nor any of its affiliated entities is liable for any loss or damage arising in any way from, or for errors or omissions in the contents of, this message or its attachments.

KattaRci commented 2 years ago

I am sorry to ask you guys this but does 8:30 work on Friday?

On Wed, Nov 17, 2021 at 11:34 AM James, Bijo < @.***> wrote:

Hi Jason,

            I am fine with Friday 9AM EST.

Thanks,

Bijo James

Manager - Data Engineering

C: +91 9986573431

@.***

RCI India

Pine Valley, First Level, Embassy Golf Links Business Park,

Off Intermediate Ring Road, Bengaluru, Karnataka 560071

[image: @.*** http://new%20logo

From: Katta, Amarender @.> Sent: 17 November 2021 21:14 To: Jason Merenda @.> Cc: Snowflake-Labs/Excelerator < @.>; Snowflake-Labs/Excelerator @.>; Mention < @.>; James, Bijo @.>; Singh, Alka @.**> Subject:* RE: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

Bijo might be out in the evening(IST) tomorrow. Bijo, can you let us know what might work for you(tomorrow or Friday)

-Amar

From: Jason Merenda @. @.>] Sent: Wednesday, November 17, 2021 10:41 AM To: Katta, Amarender @.> Cc: Snowflake-Labs/Excelerator < @.>; Snowflake-Labs/Excelerator @.>; Mention < @.>; James, Bijo @.>; Singh, Alka @.> Subject: Re: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

This e-mail is from an external source. Use caution when opening attachments or clicking on links.

Yeah that will difficult for him. How about 9:00 AM tomorrow?

On Wed, Nov 17, 2021 at 10:39 AM Katta, Amarender < @.***> wrote:

Yes, Bijo tried #3 and now he is running into #2 error(Check file key and master key). Bijo works out of India office, so 3pm EST might be late night for him. Can we do little earlier.

From: Jason Merenda @. Sent: Wednesday, November 17, 2021 10:05 AM To: Katta, Amarender @.> Cc: Snowflake-Labs/Excelerator < @.>; Snowflake-Labs/Excelerator @.>; Mention < @.>; James, Bijo @.>; Singh, Alka @.**> Subject:* Re: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

This e-mail is from an external source. Use caution when opening attachments or clicking on links.

Sure. How about 3:00 EST?

For 2. If the log files that you sent have that error then you can open a case and add those log files to them. But Support will want the ODBC log for sure.

For 3. You should see a button in the Excel ribbon. Click that button and you will see row 1 appear that will let you define the data types on the columns.

As an aside I also asked Steven about your stages question on using a pre-existing stage. The answer is yes and you set it up in the config.

[image: Screen Shot 2021-11-15 at 4.37.56 PM.png]

As an aside I also asked Steven about your stages question on using a pre-existing stage. The answer is yes and you set it up in the config.

[image: Screen Shot 2021-11-15 at 4.35.24 PM.png]

On Wed, Nov 17, 2021 at 9:52 AM Katta, Amarender < @.***> wrote:

Jason, can we setup a quick 30mins call to go over #2 and #3 so we can get this resolved.

-Amar

From: Katta, Amarender Sent: Tuesday, November 16, 2021 7:59 AM To: Snowflake-Labs/Excelerator < @.>; Snowflake-Labs/Excelerator @.> Cc: Mention @.>; Jason Merenda < @.>; James, Bijo @.>; Singh, Alka @.> Subject: RE: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

Thanks Steven.

We will work with Jason on option#2 and give it a try.

We also sent the 2016 logs to Jason and think we are close. Is it something you are someone can help us identify the issue and fix it.

@Bijo, can you have Alka or Sabith try the below in 2013 and see if these help.

-Amar

From: Steven Segal @. @.>] Sent: Monday, November 15, 2021 5:08 PM To: Snowflake-Labs/Excelerator @.> Cc: Katta, Amarender @.>; Mention < @.**> Subject:* Re: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

This e-mail is from an external source. Use caution when opening attachments or clicking on links.

@KattaRci https://github.com/KattaRci Thank you for sending the logs. I'm seeing 3 items: 1 - Crashing after the PUT command. There is nothing in the log files that is helping me. We haven't tested in with Excel 2013 so I would recommend upgrading if possible. 2 - "Check file key and master key" error. Jason will work with you on this one. You will have to open up a ticket with Snowflake Support. While the Excelerator is not directly supported, the ODBC driver is. This is an encryption issue and some mismatch with keys. 3 - 'Please set the data type by...' This issue is occuring because you will need to define the data types for all new columns. In the Snowflake section of the Excel ribbon you will see a button called 'Define Data Types'. Click that and a new row will be inserted at the top of the spreadsheet. Each cell will contain a drop down where you can select the data type.

Hope this helps. Steve

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/Snowflake-Labs/Excelerator/issues/28#issuecomment-969367576, or unsubscribe https://github.com/notifications/unsubscribe-auth/AWMV3UMA4SQVUEXQICMXJ3DUMGAF3ANCNFSM5HTEXO4A . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub. [image: Image removed by sender.]

This email message (including all attachments) is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information, or may otherwise be protected by work product or other legal rules. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Unless otherwise indicated in the body of this email, nothing in this communication is intended to operate as an electronic signature and this transmission cannot be used to form, document, or authenticate a contract. Wyndham Destinations, Inc., and/or its affiliates may monitor all incoming and outgoing email communications, including the content of emails and attachments, for security, legal compliance, training, quality assurance and other purposes.

The sender believes that this email and any attachments were free of any virus, worm, Trojan horse, malicious code and/or other contaminants when sent. Email transmissions cannot be guaranteed to be secure or error-free, so this message and its attachments could have been infected, corrupted or made incomplete during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for any viruses or other defects that may arise, and for taking remedial action relating to such viruses and other defects. Neither Wyndham Destinations, Inc., nor any of its affiliated entities is liable for any loss or damage arising in any way from, or for errors or omissions in the contents of, this message or its attachments.

--

*Jason *merenda

Senior Sales Engineer MOBILE +1 813 842 4295 EMAIL @.***

[image: Image removed by sender.]

Snowflake Inc. Tampa, FL

This email message (including all attachments) is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information, or may otherwise be protected by work product or other legal rules. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Unless otherwise indicated in the body of this email, nothing in this communication is intended to operate as an electronic signature and this transmission cannot be used to form, document, or authenticate a contract. Wyndham Destinations, Inc., and/or its affiliates may monitor all incoming and outgoing email communications, including the content of emails and attachments, for security, legal compliance, training, quality assurance and other purposes.

The sender believes that this email and any attachments were free of any virus, worm, Trojan horse, malicious code and/or other contaminants when sent. Email transmissions cannot be guaranteed to be secure or error-free, so this message and its attachments could have been infected, corrupted or made incomplete during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for any viruses or other defects that may arise, and for taking remedial action relating to such viruses and other defects. Neither Wyndham Destinations, Inc., nor any of its affiliated entities is liable for any loss or damage arising in any way from, or for errors or omissions in the contents of, this message or its attachments.

--

*Jason *merenda

Senior Sales Engineer MOBILE +1 813 842 4295 EMAIL @.***

[image: Image removed by sender.]

Snowflake Inc. Tampa, FL

This email message (including all attachments) is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information, or may otherwise be protected by work product or other legal rules. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Unless otherwise indicated in the body of this email, nothing in this communication is intended to operate as an electronic signature and this transmission cannot be used to form, document, or authenticate a contract. Wyndham Destinations, Inc., and/or its affiliates may monitor all incoming and outgoing email communications, including the content of emails and attachments, for security, legal compliance, training, quality assurance and other purposes.

The sender believes that this email and any attachments were free of any virus, worm, Trojan horse, malicious code and/or other contaminants when sent. Email transmissions cannot be guaranteed to be secure or error-free, so this message and its attachments could have been infected, corrupted or made incomplete during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for any viruses or other defects that may arise, and for taking remedial action relating to such viruses and other defects. Neither Wyndham Destinations, Inc., nor any of its affiliated entities is liable for any loss or damage arising in any way from, or for errors or omissions in the contents of, this message or its attachments.

-- Jason merenda Senior Sales Engineer MOBILE +1 813 842 4295 EMAIL @.***

Snowflake Inc. Tampa, FL

KattaRci commented 2 years ago

Yes, 8:30 am est works for us.

From: Jason Merenda @. Sent: Wednesday, November 17, 2021 12:46 PM To: James, Bijo @.> Cc: Katta, Amarender @.>; Snowflake-Labs/Excelerator @.>; Snowflake-Labs/Excelerator @.>; Mention @.>; Singh, Alka @.***> Subject: Re: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

This e-mail is from an external source. Use caution when opening attachments or clicking on links.

I am sorry to ask you guys this but does 8:30 work on Friday?

On Wed, Nov 17, 2021 at 11:34 AM James, Bijo @.**@.>> wrote: Hi Jason, I am fine with Friday 9AM EST.

Thanks,

Bijo James Manager - Data Engineering C: +91 9986573431 @.**@.>

RCI India Pine Valley, First Level, Embassy Golf Links Business Park, Off Intermediate Ring Road, Bengaluru, Karnataka 560071 @.***http://new%20logo

From: Katta, Amarender @.**@.>> Sent: 17 November 2021 21:14 To: Jason Merenda @.**@.>> Cc: Snowflake-Labs/Excelerator @.**@.>>; Snowflake-Labs/Excelerator @.**@.>>; Mention @.**@.>>; James, Bijo @.**@.>>; Singh, Alka @.**@.>> Subject: RE: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

Bijo might be out in the evening(IST) tomorrow. Bijo, can you let us know what might work for you(tomorrow or Friday)

-Amar

From: Jason Merenda @. Sent: Wednesday, November 17, 2021 10:41 AM To: Katta, Amarender @*.**@*.>> Cc: Snowflake-Labs/Excelerator @*.**@*.>>; Snowflake-Labs/Excelerator @*.**@*.>>; Mention @*.**@*.>>; James, Bijo @*.**@*.>>; Singh, Alka @*.**@*.***>> Subject: Re: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

This e-mail is from an external source. Use caution when opening attachments or clicking on links.

Yeah that will difficult for him. How about 9:00 AM tomorrow?

On Wed, Nov 17, 2021 at 10:39 AM Katta, Amarender @.**@.>> wrote: Yes, Bijo tried #3 and now he is running into #2 error(Check file key and master key). Bijo works out of India office, so 3pm EST might be late night for him. Can we do little earlier.

From: Jason Merenda @.**@.>] Sent: Wednesday, November 17, 2021 10:05 AM To: Katta, Amarender @.**@.>> Cc: Snowflake-Labs/Excelerator @.**@.>>; Snowflake-Labs/Excelerator @.**@.>>; Mention @.**@.>>; James, Bijo @.**@.>>; Singh, Alka @.**@.>> Subject: Re: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

This e-mail is from an external source. Use caution when opening attachments or clicking on links.

Sure. How about 3:00 EST?

For 2. If the log files that you sent have that error then you can open a case and add those log files to them. But Support will want the ODBC log for sure.

For 3. You should see a button in the Excel ribbon. Click that button and you will see row 1 appear that will let you define the data types on the columns.

As an aside I also asked Steven about your stages question on using a pre-existing stage. The answer is yes and you set it up in the config.

[Screen Shot 2021-11-15 at 4.37.56 PM.png]

As an aside I also asked Steven about your stages question on using a pre-existing stage. The answer is yes and you set it up in the config.

[Screen Shot 2021-11-15 at 4.35.24 PM.png]

On Wed, Nov 17, 2021 at 9:52 AM Katta, Amarender @.**@.>> wrote: Jason, can we setup a quick 30mins call to go over #2 and #3 so we can get this resolved.

-Amar

From: Katta, Amarender Sent: Tuesday, November 16, 2021 7:59 AM To: Snowflake-Labs/Excelerator @.**@.>>; Snowflake-Labs/Excelerator @.**@.>> Cc: Mention @.**@.>>; Jason Merenda @.**@.>>; James, Bijo @.**@.>>; Singh, Alka @.**@.>> Subject: RE: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

Thanks Steven.

We will work with Jason on option#2 and give it a try.

We also sent the 2016 logs to Jason and think we are close. Is it something you are someone can help us identify the issue and fix it.

@Bijo, can you have Alka or Sabith try the below in 2013 and see if these help.

-Amar

From: Steven Segal @. Sent: Monday, November 15, 2021 5:08 PM To: Snowflake-Labs/Excelerator @*.**@*.>> Cc: Katta, Amarender @*.**@*.>>; Mention @*.**@*.***>> Subject: Re: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

This e-mail is from an external source. Use caution when opening attachments or clicking on links.

@KattaRcihttps://github.com/KattaRci Thank you for sending the logs. I'm seeing 3 items: 1 - Crashing after the PUT command. There is nothing in the log files that is helping me. We haven't tested in with Excel 2013 so I would recommend upgrading if possible. 2 - "Check file key and master key" error. Jason will work with you on this one. You will have to open up a ticket with Snowflake Support. While the Excelerator is not directly supported, the ODBC driver is. This is an encryption issue and some mismatch with keys. 3 - 'Please set the data type by...' This issue is occuring because you will need to define the data types for all new columns. In the Snowflake section of the Excel ribbon you will see a button called 'Define Data Types'. Click that and a new row will be inserted at the top of the spreadsheet. Each cell will contain a drop down where you can select the data type.

Hope this helps. Steve

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/Snowflake-Labs/Excelerator/issues/28#issuecomment-969367576, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AWMV3UMA4SQVUEXQICMXJ3DUMGAF3ANCNFSM5HTEXO4A. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

This email message (including all attachments) is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information, or may otherwise be protected by work product or other legal rules. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Unless otherwise indicated in the body of this email, nothing in this communication is intended to operate as an electronic signature and this transmission cannot be used to form, document, or authenticate a contract. Wyndham Destinations, Inc., and/or its affiliates may monitor all incoming and outgoing email communications, including the content of emails and attachments, for security, legal compliance, training, quality assurance and other purposes.

The sender believes that this email and any attachments were free of any virus, worm, Trojan horse, malicious code and/or other contaminants when sent. Email transmissions cannot be guaranteed to be secure or error-free, so this message and its attachments could have been infected, corrupted or made incomplete during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for any viruses or other defects that may arise, and for taking remedial action relating to such viruses and other defects. Neither Wyndham Destinations, Inc., nor any of its affiliated entities is liable for any loss or damage arising in any way from, or for errors or omissions in the contents of, this message or its attachments.

-- Jason merenda Senior Sales Engineer MOBILE +1 813 842 4295 EMAIL @.**@.>

[Image removed by sender.]

Snowflake Inc. Tampa, FL

This email message (including all attachments) is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information, or may otherwise be protected by work product or other legal rules. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Unless otherwise indicated in the body of this email, nothing in this communication is intended to operate as an electronic signature and this transmission cannot be used to form, document, or authenticate a contract. Wyndham Destinations, Inc., and/or its affiliates may monitor all incoming and outgoing email communications, including the content of emails and attachments, for security, legal compliance, training, quality assurance and other purposes.

The sender believes that this email and any attachments were free of any virus, worm, Trojan horse, malicious code and/or other contaminants when sent. Email transmissions cannot be guaranteed to be secure or error-free, so this message and its attachments could have been infected, corrupted or made incomplete during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for any viruses or other defects that may arise, and for taking remedial action relating to such viruses and other defects. Neither Wyndham Destinations, Inc., nor any of its affiliated entities is liable for any loss or damage arising in any way from, or for errors or omissions in the contents of, this message or its attachments.

-- Jason merenda Senior Sales Engineer MOBILE +1 813 842 4295 EMAIL @.**@.>

[Image removed by sender.]

Snowflake Inc. Tampa, FL

This email message (including all attachments) is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information, or may otherwise be protected by work product or other legal rules. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Unless otherwise indicated in the body of this email, nothing in this communication is intended to operate as an electronic signature and this transmission cannot be used to form, document, or authenticate a contract. Wyndham Destinations, Inc., and/or its affiliates may monitor all incoming and outgoing email communications, including the content of emails and attachments, for security, legal compliance, training, quality assurance and other purposes.

The sender believes that this email and any attachments were free of any virus, worm, Trojan horse, malicious code and/or other contaminants when sent. Email transmissions cannot be guaranteed to be secure or error-free, so this message and its attachments could have been infected, corrupted or made incomplete during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for any viruses or other defects that may arise, and for taking remedial action relating to such viruses and other defects. Neither Wyndham Destinations, Inc., nor any of its affiliated entities is liable for any loss or damage arising in any way from, or for errors or omissions in the contents of, this message or its attachments.

-- Jason merenda Senior Sales Engineer MOBILE +1 813 842 4295 EMAIL @.**@.>

[Image removed by sender.]

Snowflake Inc. Tampa, FL

This email message (including all attachments) is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information, or may otherwise be protected by work product or other legal rules. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Unless otherwise indicated in the body of this email, nothing in this communication is intended to operate as an electronic signature and this transmission cannot be used to form, document, or authenticate a contract. Wyndham Destinations, Inc., and/or its affiliates may monitor all incoming and outgoing email communications, including the content of emails and attachments, for security, legal compliance, training, quality assurance and other purposes.

The sender believes that this email and any attachments were free of any virus, worm, Trojan horse, malicious code and/or other contaminants when sent. Email transmissions cannot be guaranteed to be secure or error-free, so this message and its attachments could have been infected, corrupted or made incomplete during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for any viruses or other defects that may arise, and for taking remedial action relating to such viruses and other defects. Neither Wyndham Destinations, Inc., nor any of its affiliated entities is liable for any loss or damage arising in any way from, or for errors or omissions in the contents of, this message or its attachments.

KattaRci commented 2 years ago

Amar,

Responding to your question. See second screenshot below for the stages.

Jason

On Wed, Nov 17, 2021 at 10:05 AM Jason Merenda @.***> wrote:

Sure. How about 3:00 EST?

For 2. If the log files that you sent have that error then you can open a case and add those log files to them. But Support will want the ODBC log for sure.

For 3. You should see a button in the Excel ribbon. Click that button and you will see row 1 appear that will let you define the data types on the columns.

As an aside I also asked Steven about your stages question on using a pre-existing stage. The answer is yes and you set it up in the config.

[image: Screen Shot 2021-11-15 at 4.37.56 PM.png]

As an aside I also asked Steven about your stages question on using a pre-existing stage. The answer is yes and you set it up in the config.

[image: Screen Shot 2021-11-15 at 4.35.24 PM.png]

On Wed, Nov 17, 2021 at 9:52 AM Katta, Amarender < @.***> wrote:

Jason, can we setup a quick 30mins call to go over #2 and #3 so we can get this resolved.

-Amar

From: Katta, Amarender Sent: Tuesday, November 16, 2021 7:59 AM To: Snowflake-Labs/Excelerator < @.>; Snowflake-Labs/Excelerator @.> Cc: Mention @.>; Jason Merenda < @.>; James, Bijo < @.>; Singh, Alka @.> Subject: RE: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

Thanks Steven.

We will work with Jason on option#2 and give it a try.

We also sent the 2016 logs to Jason and think we are close. Is it something you are someone can help us identify the issue and fix it.

@Bijo, can you have Alka or Sabith try the below in 2013 and see if these help.

-Amar

From: Steven Segal @. @.>] Sent: Monday, November 15, 2021 5:08 PM To: Snowflake-Labs/Excelerator @.> Cc: Katta, Amarender @.>; Mention < @.**> Subject:* Re: [Snowflake-Labs/Excelerator] Excelarator Add-in crashing when trying to use upload feature (Issue #28)

This e-mail is from an external source. Use caution when opening attachments or clicking on links.

@KattaRci https://github.com/KattaRci Thank you for sending the logs. I'm seeing 3 items: 1 - Crashing after the PUT command. There is nothing in the log files that is helping me. We haven't tested in with Excel 2013 so I would recommend upgrading if possible. 2 - "Check file key and master key" error. Jason will work with you on this one. You will have to open up a ticket with Snowflake Support. While the Excelerator is not directly supported, the ODBC driver is. This is an encryption issue and some mismatch with keys. 3 - 'Please set the data type by...' This issue is occuring because you will need to define the data types for all new columns. In the Snowflake section of the Excel ribbon you will see a button called 'Define Data Types'. Click that and a new row will be inserted at the top of the spreadsheet. Each cell will contain a drop down where you can select the data type.

Hope this helps. Steve

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/Snowflake-Labs/Excelerator/issues/28#issuecomment-969367576, or unsubscribe https://github.com/notifications/unsubscribe-auth/AWMV3UMA4SQVUEXQICMXJ3DUMGAF3ANCNFSM5HTEXO4A . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub. [image: Image removed by sender.]

This email message (including all attachments) is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information, or may otherwise be protected by work product or other legal rules. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Unless otherwise indicated in the body of this email, nothing in this communication is intended to operate as an electronic signature and this transmission cannot be used to form, document, or authenticate a contract. Wyndham Destinations, Inc., and/or its affiliates may monitor all incoming and outgoing email communications, including the content of emails and attachments, for security, legal compliance, training, quality assurance and other purposes.

The sender believes that this email and any attachments were free of any virus, worm, Trojan horse, malicious code and/or other contaminants when sent. Email transmissions cannot be guaranteed to be secure or error-free, so this message and its attachments could have been infected, corrupted or made incomplete during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for any viruses or other defects that may arise, and for taking remedial action relating to such viruses and other defects. Neither Wyndham Destinations, Inc., nor any of its affiliated entities is liable for any loss or damage arising in any way from, or for errors or omissions in the contents of, this message or its attachments.

-- Jason merenda Senior Sales Engineer MOBILE +1 813 842 4295 EMAIL @.***

Snowflake Inc. Tampa, FL

-- Jason merenda Senior Sales Engineer MOBILE +1 813 842 4295 EMAIL @.***

Snowflake Inc. Tampa, FL