Questions

0
votes
1
answers
122 views

Category: Questions

Import CSV descriptions/template

Does anyone have a list of Skyvia's column/target descriptions.. I keep getting error messages but am not given (nor can I find) information on how to rectify the errors. I ....

Created by Sven Licht Sven Licht 25 April 2019.

Latest by Mariia Zaharova Mariia Zaharova 26 April 2019.

0
votes
6
answers
227 views

Category: Questions

Rest Connector Metadata Issue

Hi, I'm working on integration between SalesForce and Cloud App via REST connector. When I performed initial sync it was successful, according to history state column. Then I performed the Update operation on ....

Created by Vlad Shmulskyi Vlad Shmulskyi 16 April 2019.

Latest by Vlad Shmulskyi Vlad Shmulskyi 25 April 2019.

0
votes
1
answers
139 views

Category: Questions

Can I access my Skyvia Target Demo DB from Desktop SQL Client?

If so, is there documentation on how to connect? Thanks! ....

Created by Jonah Purinton Jonah Purinton 24 April 2019.

Latest by Mariia Zaharova Mariia Zaharova 24 April 2019.

0
votes
2
answers
132 views

Category: Questions

separate "last, first" values from csv

I'm trying to upsert a csv of Contacts from Cvent into Salesforce. The Contact names in the csv are formatted "last, first", and I need to separate them so they ....

Created by Peter Gutmann Peter Gutmann 13 April 2019.

Latest by Peter Gutmann Peter Gutmann 22 April 2019.

0
votes
29
answers
470 views

Category: Questions

Date fields query as '1-1-0001' even though data in source environment (ZOHO) displaying correctly

Hello, We are trying to integrate data from Zoho to an Azure Database. Several records keep failing due to the error 'SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and ....

Created by Sachin Dabrein Sachin Dabrein 04 February 2019.

Latest by Sachin Dabrein Sachin Dabrein 22 April 2019.

0
votes
1
answers
141 views

Category: Questions

Tab delimited CSV

I am trying to export to a CSV.  It needs to be tab delimited.  How do I change the delimiter to a tab? ....

csv

Created by Phelps Jackson Phelps Jackson 17 April 2019.

Latest by Dmitriy Muzurov Dmitriy Muzurov 18 April 2019.

0
votes
3
answers
131 views

Category: Questions

Assembly Items not syncing

I am setting up a sync between NetSuite and MS SQL. We have several hundred assembly items in NetSuite. When I run the sync, only 19 are loaded in SQL. ....

Created by David Weninger David Weninger 12 April 2019.

Latest by Dmitriy Muzurov Dmitriy Muzurov 17 April 2019.

0
votes
1
answers
119 views

Category: Questions

Record Sync

this is what i get when I try to sync data from sql server to crm     N:B i have granted create trigger permissions, please what do you advise ....

Created by Gidi cab Gidi cab 11 April 2019.

Latest by Mariia Zaharova Mariia Zaharova 12 April 2019.

0
votes
1
answers
120 views

Category: Questions

Data Integration

Hey, I am trying to connect Skyvia to the Tempo (Jira) Database but I can not see the tables available. Other question I have is: Why Can't I see all ....

Created by Ricardo Oliveira Ricardo Oliveira 09 April 2019.

Latest by Mariia Zaharova Mariia Zaharova 10 April 2019.

0
votes
1
answers
129 views

Category: Questions

Jira and MySQL Integration

Hi support, I created an integration to replicate data from jira to mysql. If I only select one of the Jira fields (i.e. issues), the job runs normally, but if ....

Created by Darwinex Tradeslide Darwinex Tradeslide 05 April 2019.

Latest by Mariia Zaharova Mariia Zaharova 05 April 2019.

0
votes
2
answers
140 views

Category: Questions

Trying to map invalid data type sql to dynamics 365

1. If I pull data from sql and exported to excel, upload it to skyvia and do upsert to dynamics 365, works fine. If I try to do it straight ....

Created by Andy Le Andy Le 03 April 2019.

Latest by Andy Le Andy Le 04 April 2019.

0
votes
1
answers
133 views

Category: Questions

Import Expressions: If field = Yes, insert date

Trying to import a csv file where, if column 1 = Yes, I insert todays date into a SF date field. This isn't working: () == "Yes" ?  (GETDATE) : ....

Created by Marc Kleefstra Marc Kleefstra 30 March 2019.

Latest by Dmitriy Muzurov Dmitriy Muzurov 01 April 2019.

0
votes
1
answers
10 views

Category: Questions

How can i filter rows before publishing using odata, with connect?

I want to publish using connect part of a table from salesforce... basically say to exclude records with a certian status.  how con i do that? ....

Created by Graham Parry Graham Parry 28 March 2019.

Latest by Dmitriy Muzurov Dmitriy Muzurov 01 April 2019.

0
votes
3
answers
20 views

Category: Questions

delete

how to set query Delete ; ....

Created by jeff santiago jeff santiago 27 March 2019.

Latest by Mariia Zaharova Mariia Zaharova 28 March 2019.

0
votes
1
answers
16 views

Category: Questions

Insert failed

 Error message when doing insert Account: id value of incorrect type: OIOI01;"CAD";"OIOI0101";"OIOI01";"479.52";"OIOI0101OIOI01" ....

Created by jeff santiago jeff santiago 26 March 2019.

Latest by Mariia Zaharova Mariia Zaharova 27 March 2019.

0
votes
10
answers
281 views

Category: Questions

Synchronization Integration won't allow Target to Source "Id" column synchronization

Hello there. I have successfully synced a SFDC object/table to a table in a PostgreSQL database. I added a new primary-key column (named "_id") and am able to sync records back ....

Created by Jacob Widmer Jacob Widmer 11 October 2018.

Latest by Mariia Zaharova Mariia Zaharova 21 March 2019.

0
votes
10
answers
76 views

Category: Questions

Mapping NetSuite Custom Fields

How do I map custom fields from NetSuite to SQL? For example we have many custom fields on the NetSuite Customer. When I map the NetSuite Customer to SQL, I only ....

Created by David Weninger David Weninger 11 March 2019.

Latest by Simon Bubnov Simon Bubnov 20 March 2019.

0
votes
3
answers
28 views

Category: Questions

DELETE ACCOUNT CANCEL SUBSCRIPTION

Hi! At this moment I want to delete my account because the backup service is no longer necessary. I await the opt-out confirmation. ACCOUNT: nina.s@germanonlineinstitute.com Thank you ....

Created by Nina Sauer Nina Sauer 15 March 2019.

Latest by Dmitriy Muzurov Dmitriy Muzurov 19 March 2019.

0
votes
1
answers
10 views

Category: Questions

Error query salesorder

Hello I am consulting a table of the connection "woOw" the table "sales order", but I am getting an error in the query   could you help me, please Server ....

Created by Avanxo  Colomba Avanxo Colomba 15 March 2019.

Latest by Mariia Zaharova Mariia Zaharova 19 March 2019.

0
votes
3
answers
145 views

Category: Questions

Pipedrive custom fields

We have several custom fields in our Pipedrive instance.  One of which is "Distribution List" which is under People.  However, I'm not able to find that field with data in ....

Created by Michael Richey Michael Richey 07 March 2019.

Latest by Mariia Zaharova Mariia Zaharova 18 March 2019.

Close