500 error when setting up a task between sugar and hubspot

  • 18Views
  • Last Post 2 days ago
0
votes
Tony Guzman posted this 2 weeks ago

Hi there. I'm evaluating using skyvia for a sugar and hubspot integration. It's fairly straightforward of an integration. I just need to send certain (not all contacts) from sugar over to hubspot. We're new customers of hubspot.

Anyway, i setup the connections but when I go to add a task and choose the contacts objects for sugar, I get a https://app.skyvia.com/errors/500.html error & https://www.evernote.com/l/ATe1C0bE7OtCs7mHgp_WxsQ32NMTwPmTKaY

Any ideas why? I can't really evaluate the tool at all. Is it a timeout issue? Is our sugar instance too larger?

Would love some help. thanks!

Tony

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 2 weeks ago

Hi! We have detected the reason of the issue. The following error occurs when your are trying to select Contacts object - Unexpected SugarType 'mailchimprating'.

We will fix it and inform you as soon as any news is available.

 

Best regards,

Mariia

0
votes
Tony Guzman posted this 2 weeks ago

Hi Maria. Thanks for the quick response! If it helps, we have the Sugarchimp module for SugarCRM that connects to Mailchimp. That could explain what is throwing the error. 

 

While I have you, I was wondering if you or someone else you can forward me to could clarify how Skyvia pricing works.

I see it's based on contacts. But is it based on contacts that move over or contacts total in the database? Let me explain. We have over 140,000 contacts in our Sugar instance but only about 10,000 or if that will need to go over to hubspot. We'd define this based on certain field criteria. So would be be charged based off of 140,000 total records it needs to query or based off of the 10,000? Does that make sense? 

Let me know when you have a moment. Thanks so much!

Tony

 

0
votes
Mariia Zaharova posted this 5 days ago

We have fixed the "Unexpected SugarType 'mailchimprating'" error, we will inform you when Skyvia is updated with the fix.

 

The pricing is based on the number of processed records, not the records available in the source database. The price and limits are specified for one Skyvia account per month: https://skyvia.com/pricing

For import and replication, the number of records, successfully added/modified/deleted in the target objects or tables, is counted. 

For export we count the number of records added to CSV file. 

For synchronization, the total number of records, successfully added, modified, or deleted in both sources, is counted. 

For each package run, you can find the number of records used in the package Run History.

 

With the Free pricing plan you can process 5k records per month using replication, synchronization and import (not from the CSV source) packages and additionally 100k records per month for export packages and import from the CSV files. Additionally, you will be able to have 2 scheduled packages (Schedule - once a day).

With the Basic pricing plan you can process 25k records per month for replication, synchronization and import (not from the CSV source) packages and additionally 200k records per month for export packages and import from the CSV files. Additionally, you will be able to have 5 scheduled packages (Schedule - once a day).

In your case, records successfully added/modified/deleted in the HubSpot will be counted.

 

If you have any further questions, feel free to contact us.

 

Best regards,

Mariia

 

0
votes
Tony Guzman posted this 5 days ago

Hi Mariia. That's great to hear. One last question that I will test once the fix is applied but want to go head and ask now while I wait until the fix is applied.

I just want to make sure our use case can be supported by skyvia:

we have a subset of sugar records we'd want to send over to hubspot. It's based off of the values of at least two custom fields and if they are of value A and value B, we'd want them to go over. We estimate there are less than 10,000 contact records that fit this criteria. Once we determine which ones go over, we'd have x number of fields in sugar mapped to fields in hubspot. So if a value changes in sugar, then it would update in hubspot.

That's pretty much it. Does skyvia let us do what I described?

Again, i look forward to testing this once the bug you fixed is applied but if you can answer this for me now, it would be a huge help!

Thanks so much!

Tony

0
votes
Mariia Zaharova posted this 4 days ago

That's pretty much it. Does skyvia let us do what I described?

Yes, most likely, Skyvia will fit your needs. For this scenario Import package with the UPDATE/UPSERT operation can be used:

https://skyvia.com/resources/docs/index.html?import_package.htm

https://skyvia.com/resources/docs/index.html?performing_update_and_delete.htm

https://skyvia.com/resources/docs/index.html?performing_upsert_operation.htm

 

I will definitely inform you when Skyvia is updated with the fix, so that you are able to check it.

0
votes
Tony Guzman posted this 4 days ago

That's great to hear. And thank you for the links.

I'll standby to hear from you when that fix is updated. Thanks so much for your help!

0
votes
Mariia Zaharova posted this 2 days ago

We have updated Skyvia with the fix. 

0
votes
Tony Guzman posted this 2 days ago

Wonderful, thanks!

Close