Devart Forums

dm-m

Hi,

Thank you for contacting our Devart Team.

We are not able to run macros locally for security reasons. Also, it is not clear what specific product Excel Add-in you use, and error message you received.

We would appreciate if you record a short video and show us the issue.

We are looking forward to hearing from you.

dm-m

Hello,

Thank you for posting on our Devart forums!

Please set 'True' for Unicode parameter in the Advanced parameters of your MySQL connection:
https://www.screencast.com/t/dxfVhFHSBR

It should fix the error.

Should you have any questions, do not hesitate to contact us back.

dm-m

AlexBrown wrote: ↑Thu 15 Oct 2020 11:48 hi there,
I need to edit the billing address in the checkout page to add some custom drop down and text fields, is there a way to do that?

Hi,

You can enter any details you require in the Devart checkout page.

dm-m

Hello,

Thank you for getting back to us.

It seems that WS RDS PostgreSQL is configured for only TLS protocol 1.2. Our PostgreSQL provider is using TLS Protocol=1.1 for backwards compatibility with old servers.

Please enable "SSL TLS Protocol=1.2" parameter in the connection details for PostgreSQL:
https://www.screencast.com/t/OzpcmMhapku

We are looking forward to hearing from you, should you have any questions.

dm-m

Hello,

Thank you for contacting us.

We raised a ticket with our development team to investigate this.

Once there are any details, we will let you know.

dm-m

KPM wrote: ↑Fri 21 Aug 2020 00:01 HI,

Here my SQL Query lines code :

SELECT t.Id,
t.Name,
t."État du locataire",
OrganizationId.Name AS "OrganizationId.Name"
FROM User AS t
LEFT OUTER JOIN Organization AS OrganizationId ON t.OrganizationId = OrganizationId.Id

I would like to see the column Organizationid.Name after the t.Name as third column and not the last one

Thanks

Hello,

Thank you for contacting us!

To change the order you can set the required column right after t.Name in your query. Here is what it will look like:

Code: Select all

SELECT t.Id, 
       t.Name, 
       OrganizationId.Name AS "OrganizationId.Name",
       t."État du locataire"
FROM User AS t
LEFT OUTER JOIN Organization AS OrganizationId ON t.OrganizationId = OrganizationId.Id

Should you have any questions, do not hesitate to contact us back.

dm-m

Hi,

Thank you for contacting us.

Our development team will investigate the possibility of editing views and we will post here about the results. To our regret we have no ETA so far.

dm-m

Hi Jennifer,

Thank you for submitting a post!

Currently, it's not possible to edit view because it does not have columns that uniquely identify rows (primary key or non-nullable unique index columns).

We will investigate the possibility of editing views and post here once have any results. We have no ETA at the moment.

dm-m

Hello,

Thank you for creating a post with us.

Let us know the Freshdesk object that you are trying to update and the query. You can copy it from "SQL Query" tab:
https://www.screencast.com/t/1Jq4TsEs2

We are looking forward to hearing from you.

dm-m

Hi,

Thank you for contacting us.

The task to work with Devart Excel Add-ins with the help of VBA scripts has been set for implementation.

We don't have any ETA for now, however the task was prioritized.

Once it is done, we will update this thread.

dm-m

Dear David,

The issue is fixed in the new release of Excel Add-in for Zoho CRM 2.3.314.

It's fully operational now. You can download Excel Add-ins installation file from our site: https://www.devart.com/excel-addins/download.html

We are looking forward to hearing from you, should you have any questions.

dm-m

Hello,

Thank you for submitting a ticket with us.

We have replied to your email. Please check the inbox.

dm-m

Hello David,

Thank you for your post.

We managed to reproduce the issue and raised a ticket with our development team.

Once there is any result, we will update the post.

dm-m

Hello Karl,

Thank you for contacting us.

We have answered to your email.

Looking forward to hearing from you.

dm-m

Dear David,

Thank you for getting back to us.

Sorry for confusion, we did not fully understand your initial question.

Correct, it's possible to specify a condition in SELECT for creating a column to distinguish results between different tables, even if it can't be translated to QuickBooks API. In that case it is executed in cache locally.

Since the Excel Add-ins are using the same providers for cloud applications as dotConnect, you can refer to this knowledgebase article:
https://www.devart.com/dotconnect/quick ... ation.html

Should you have any questions, do not hesitate to contact us back.

Devart Forums

Search found 17 matches

Re: Excel Add-ins Erorr

Re: MySQL update row value: Error, incorrect string value

Re: BigCommerce Custom Fields

Re: SSL connection to AWS RDS Postgres

Re: SSL connection to AWS RDS Postgres

Re: Switch column within 2 tables

Re: Edit table view with DevArt Excel Add-in

Re: Edit table view with DevArt Excel Add-in

Re: Freshdesk - Updating Time Entries

Re: Possibly to refresh data programmatically from VBA?

Re: Excel Zoho Crm addon showing blank rows after update

Re: Excel add-in with updateable views

Re: Excel Zoho Crm addon showing blank rows after update

Re: ExactTarget error: Data Extension does not exist

Re: Add Column with "Static" info - like table name