Fixing the "Unable to translate bytes..." Error When Using the "CSV via Upload" Connector in StarfishETL
This error message is generally caused by “unknown, unrecognized, or unrepresentable characters”. You can find out if there is an issue with your file by opening the file in a text editor.Continue reading
The wait is over! We are happy to announce a new connector for StarfishETL: the Exchange Graph API connector is now available. This will be a faster, more-secure connector for your Microsoft 365 integrations using StarfishETL.Continue reading
The connection is what allows you to have read/write access to the modules you need. It tells your connecting solutions, “Hey! I want StarfishETL to be able to access your data. Grant it the permissions it needs to do this migration or integration correctly.” Once the connection is in place, you can create your data map or use a pre-built map to build your project the way you prefer. The data map is the plumbing that determines how your data flows.Continue reading
Using CSV files for customer data may be an old school strategy, but many businesses still prefer the format. Before we get into how StarfishETL can help manage CSV file sharing, especially over the cloud, let’s take a moment to understand why businesses choose these types of files over another medium, and the challenges they must overcome to effectively put them to work.Continue reading
Many companies want full Cloud adoption, but simply aren’t “there” yet, so they must strike a balance between their locally hosted systems and the Cloud software. However, when it’s time to integrate the two, things can get complicated. Your only options to integrate ERP through a firewall are to either work locally or expose the software over the firewall – neither of which are desirable approaches.
Try as we may, many of us still run into unexpected errors when executing integrations. In the world of unpredictable data, these errors are inevitable. They can occur from human miscalculations, incorrect information, malfunctioning systems, or any other number of random events.
Everyone loves options, right? As you prepare for your data project, you may notice StarfishETL offers several options for moving your data. How do you know which version of the platform is right for what you need, though? The first thing you must consider is what you’re using StarfishETL for: integration, migration, data clean up, process automation, or other uses. Here are some descriptions and guidelines to help you choose the best StarfishETL instance for your next project.Continue reading
When using Starfish to migrate from Microsoft Dynamics CRM to a different CRM system, you may need to create cross reference files that translate picklist codes to actual text values. This is particularly true if you don’t have a full Dynamics CRM instance setup for the database you are migrating from. In such as situation, the database returns numeric codes for picklist values instead of their actual text. This makes it hard to work with because of the need to manually translate each number to…Continue reading
When importing data into SugarCRM using Starfish, users will generally want to disable the Assignment Notification functionality in the Admin -> Email Settings area of SugarCRM.
One of the benefits of StarfishETL is that it's Engine (where all the magic happens) is Web-services based. This means not only can StarfishETL itself run in the cloud, but you can control it programmatically through it's SOAP interface.Continue reading