Version HistoryThis page contains the version history of DataBridge |
Preparation for new subscription plans.
Changed Google Drive scopes in compliance with new Google security policy.
Exporting a SuperOffice selection of more than 1,000 quote lines could cause duplicates if the criteria included an OR operator.
Recent job logs were sometimes mistakenly deleted.
Upgraded third party components with vulnerabilities to patched versions.
Documents can now be imported when stored on OneDrive or Sharepoint.
Fixed importing document metadata without importing a file.
Number of files retrieved from an FTP server using a wildcard is now limited to 100.
Fetching many files from an FTP server is now interrupted when aborting the job using a wildcard in the file name.
Scheduled jobs only include weekdays by default.
Log files of some jobs used to be mistakenly deleted automatically.
License purchased via SuperOffice was not immediately active.
Fixed exporting data with non-printable characters to an XML file.
New Visma.net authentication with better security standards.
Change of SuperOffice tenant domain is now handled automatically.
Preparation for new subscription plans.
Export jobs and some imported lines used to fail when SuperOffice tenant was offline. Jobs are now stopped and resumed when tenant is online again.
Source files can now be imported from a Sharepoint library.
Exported files can now be sent to a Sharepoint library.
OneDrive credentials must be entered again for all profiles that use OneDrive.
Fixed error that occurred when overwriting an existing database row with a column set to NULL.
Profiles can now be given a description to detail their purpose.
Deduplication on custom tables now takes into account foreign keys to standard tables.
Improved handling of errors coming from the Visma.net API.
Transformation could not be applied if column content was null in the source database.
Instant job statistics used to be copied over to a cloned profile.
Some numbers coming from a Google Sheets file were not converted properly.
Data from SuperOffice or Visma.net can now be exported to a Microsoft SQL Server or Microsoft Azure SQL database. Available in preview for selected customers.
Name of the file selected in OneDrive can now be partially replaced with a wildcard to process multiple files or files with a nonfixed name.
File imported from OneDrive can now be deleted after it was successfully processed.
Transformation “Skip by date” is now also available when importing data from Google Sheets.
Fixed error message when the file path on an SFTP server is wrong.
Exporting manual fields of type Datetime from SuperOffice to file will now use the date format configured in the “Destination Settings”.
Error occurred while importing SuperOffice consents to EMarketeer has been fixed now.
New version of the Replace transformation that can find and replace all occurrences of a (special) character, word or phrase in a cell.
Comparison operators added to the Skip transformation in order to skip rows that partially match a specified value.
Phone of type “other” can now be imported into a person card.
Users can now stay logged in for more than one hour.
Importing documents into SuperOffice is now generally available.
Both the beginning and the end of log files are now directly visible in the job details page instead of just the beginning.
Large files exported to OneDrive could get corrupted.
Added retry mechanism to improve SFTP calls resiliency.
Fixed jobs stuck in working status when exporting to an FTP server.
Special characters were not displayed properly with encoding option “ANSI”.
New transformation “Skip by date” to import only the rows that changed since the last run.
Exported file format and source file format can now be changed when importing the profile.
Migration of the portal and background services to .NET 6. New IP address to whitelist: 20.123.176.149
Empty rows in Excel files are now automatically skipped.
Ensured existing file on SFTP server is cleared before exporting new version of the file.
Fixed export of interests for onsite versions lower than 8.5.
Removed call to get user-defined lists which failed for some onsite installations.
Added support for importing localized user-defined list items in Settings and Maintenance. Available in preview for selected customers.
Appointments can now be imported with a resource assigned as the owner.
Duplicate entities were created if the field checked for deduplication contained a “/” character.
HTML content was not escaped in some of the previews.
Added support for importing localized company categories and company businesses in Settings and Maintenance. Available in preview for selected customers.
Added support for exporting a person’s academic title.
Fixed export of a company’s email address in instant jobs.
Fixed error “Some of the settings in the profile have invalid data.”
Some errors and inconsistencies were caused by the same job running twice simultaneously.
Webhooks were not triggered if the source file was missing.
Emails stayed in the Processing folder if an error occurred before the emails to process were fetched.
Fixed error message “not-found” displayed on the Subscription page when the coupon had expired.
Fixed downloading files from SFTP servers with a one-time download policy.
Source files sent by email as a zip archive can now be password protected.
New option in “Append text value” transformation to append or prepend a value only to fields that are not empty.
Technical migration from SuperOffice WCF services to Web API in order to improve performance and reliability. SuperOffice Onsite versions lower than 8.4 R08 are no longer supported.
Last job date and status for each profile is now displayed in the profile overview page.
Added an error message in the logs in case the imported document could not be deleted from the FTP server.
Added an indication that a profile is disabled in the job overview page.
Webhook was not triggered if no selections were created during the job.
New contacts were created with the default consent legal base selected in SuperOffice instead of the one selected in DataBridge.
Cloning a profile used to incorrectly copy some dynamic information that belonged only to the original profile such as the last time it ran.
Amount of an invoice used to be left unchanged in Visma when the quantity of a line was updated.
Searching for a new field to export did not work after picking a different SuperOffice selection.
New folder picker to choose the folder to export files to for Google Drive, OneDrive and Dropbox.
Documents can now be automatically deleted from the FTP server after they have successfully been imported into SuperOffice.
Improvements
Job failure notification is now enabled by default.
Bug fixes
Deleted user-defined field is now automatically removed from export.
File type used to be checked too late when importing from an email inbox or an FTP server.
A webhook can be triggered after a job completes to call any endpoint with information about the job result as query parameters.
New “Reorder fields” transformation to change the order in which the fields will be rendered in the exported file or displayed in the Configure fields page.
Invoices can now be directly downloaded from DataBridge.
Text files can now be exported with either a .txt or .csv extension.
Error message is more explicit when trying to import a project member with an invalid project ID or person ID.
Error message is more explicit when trying to import a stakeholder with an invalid sale ID, company ID or person ID.
Enabling time zones in SuperOffice is no longer a prerequisite.
Fixed import from FTP when the file is not considered a regular file.
Fixed import from FTP when the file path starts with a backslash.
Jobs are no longer stuck with the Working status when the import file fails to be fetched from the FTP server.
File name on an FTP server can now be specified with a wildcard to process multiple files or files with a nonfixed name.
Number of processed rows per month is now visible in Subscription > Data usage. More information
Fixed Map list transformation that could not fetch the values from a source field deleted by a Remove fields transformation.
Faulty connection settings can now be fixed by support.
Default document template set in Destination settings was not taken into account.
File preview used to fail for password-protected Excel files.
Subscription plans are simplified and invoices are now based on usage (number of processed rows). More information
DataBridge licenses can now be purchased and invoiced via SuperOffice.
All distinct values from the source field are now automatically loaded in the Map list and Switch fields transformations.
A preview of the transformed columns is now available directly in the transformation window. More information
Jobs are now postponed or interrupted and restarted later if SuperOffice is offline for maintenance.
Added a link to the help page for creating regexes in the Find pattern transformation. More information
Impersonation automatically starts for support users when opening a link to view a profile or a job.
Visma.net attributes used as duplicate check fields did not always work due to a bug in the Visma API.
Creation of a new user used to fail in some cases.
Instant jobs and profile’s configure source preview failed while exporting specific columns from SuperOffice (e.g. SALE-STAGE).
Users of SuperOffice Online can now use the same email address to create multiple accounts for different tenants. SuperOffice Online users are now able to sign up with a tenant even if they already have a DataBridge user account for another tenant with the same email address. To do so, the username is now different from the email address. To make sure the username is unique, the username is the email address with the cust ID added as an email subaddress.
Users with admin rights in SuperOffice no longer need to be added as admin users by the account manager to be able to log in. Note: This only applies to SuperOffice online tenants. For onsite SuperOffice this article still applies
Users without a DataBridge account can now open the link to view the job details when they receive a job notification.
Stakeholder companies can now be imported without a person.
Added list “Associate” in Map list transformation.
Source files can now be retrieved from a nested folder in a zip attachment. More info
Jobs can be triggered every 5 minutes instead of every 15 minutes. More info
Fixed updating the company relation to a custom table.
Email attachments retrieved via IMAP failed to be imported as documents since release 115.
Coupon entered in the subscription page was not sent to the billing system since release 114.
Prevented jobs of the same profile from running in parallel to avoid creating duplicate entities and saving entities in the wrong selection.
List “General - Resource” in Map list transformation used to show associates instead of resources.
All emails that match the search criteria are now processed when a job runs instead of only the oldest one.
Imported requests can now be saved in a SuperOffice selection.
A default owner, category and status can now be set for new requests.
New drop-down menu “Manage Profile” in profile configuration pages for easier navigation.
Added a link in page “Configure source” to directly open the source file in OneDrive, Dropbox and Google Drive.
Google Drive folders are now visible in the file picker.
Actions to perform after completing a job are now described more accurately for source files sent by email.
Message for a missing field in a CSV file gives more explanations about the cause of the problem.
Users with insufficient privileges were redirected to the wrong error page.
Uploading the source file before setting up the SuperOffice or Visma.net connection used to require uploading the file a second time.
Two different selections of imported entities used to be created when a job was momentarily interrupted.
Documents to import into SuperOffice can be sent as email attachments. Available in preview for selected customers. More info
Source files can now be sent by email as a zip archive file.
Service requests can now be imported with a nested category.
Merge fields transformation supports tabs and new line characters as a delimiter. More info
Append text value transformation supports prefixing and suffixing tabs and new line characters. More info
Email address of the Visma.net, OneDrive, Microsoft 365, Google Sheets or Google Drive account that is used to set up the profile is now displayed in the configuration pages.
Job duration in the overview is now displayed in days, hours, minutes and seconds instead of the total number of seconds.
Technical upgrade of third-party payment component.
Fixed eMarketeer conflicting API calls that created a deadlock.
Requests import used to fail without explanation for restricted-access categories.
Profiles exported before release 113 can now be imported again without error.
Profiles with a faulty setting can now be opened to fix the setting, as well as copied or exported.
Visma.net connection button used to be displayed as “Connected” even when the authentication token was revoked.
Duration displayed in job detail used to be incorrect if it was longer than one day.
Transformations can now be chained together so the field created by a transformation can be further transformed. more info
Added support for importing into custom fields of companies, contacts, requests and request messages. more info
Sending the source files to an email inbox is now generally available. more info
Import into custom tables is now generally available.
All the transformations result in a new field to be able to reuse the untransformed value in multiple transformations.
Aligned the style of the forgotten password page with the rest of the portal.
Errors when importing data from Visma are now easier to understand and fix.
Transformation notes were not copied and imported. more info
Job used to fail if the CSV file did not contain any data to import.
Profile configuration with an empty source is now explicitly prevented instead of failing with unexpected errors.
Source files can now be sent by email to any IMAP-enabled inbox. Available in preview for selected customers. More info
New transformation (Find Pattern) to extract from a field data with the specified pattern. More info
Notes can be added to transformations to make their purpose clear. More info
The table to map target fields to source fields can now be rotated vertically to avoid horizontal scrolling. More info
The first few rows of an Excel file can now be skipped if they are not part of the data set. This can be done in the Advanced settings of the Configure Source page.
Errors related to transformations are now easier to identify and fix.
The job’s file name is now displayed as the full email attachment file name instead of the name with wildcards.
Job result notification recipients can now see the other recipients of the same email.
Technical upgrade of third-party components.
The file path set in the instant job parameter FTPFilePath is now displayed in the job notification instead of the default file path.
Fixed the error that occurred when no job notification recipient was set.
Source files can now be sent by email to an Outlook inbox. Available in preview for selected customers. More info
New “Switch fields” transformation to configure which field to import the value from depending on the value of another field. More info
Added live chat support.
Exporting data from SuperOffice without selecting any fields has been completely removed to improve overall performance. More info
Dropbox connection is now based on refresh tokens rather than long-lived tokens for better security. Before 30-09-2021 all customers who use Dropbox need to go to Configure profile > Dropbox > Authorization and click the “Connected” button to make sure the jobs will keep running successfully after the deadline.
New possibility to import entities related to the company that owns the SuperOffice license.
Job logs now indicates if the entity to update was found using the secondary duplicate match setting.
Changed email service provider to avoid blacklisting.
Country dependencies are now included in the list of countries in the sign up page.
New list items were not added if the new item was a number.
Importing a person or a company if the interest column in the source file was empty used to fail.
Jobs that fail due to a deleted profile or unavailability of SuperOffice no longer log error message “Object reference not set to an instance of an object.”
Sending the file resulting from an export by email is now generally available. Email the results of an export
Quote import in SuperOffice is now generally available.
Technical upgrade of third-party components.
Job no longer fails when it generates a lot of logs over a short time span.
Sale amount is now correctly updated when a discount is set on a quote alternative or a quote line.
Profiles are exported again as .ndb files instead of .zip files in Firefox.
New column “Person entity is main contact” to set the main contact of a company in SuperOffice.
Exporting data from SuperOffice without selecting any fields is now deprecated. This possibility will be removed after 31-03-2021 to improve overall performance. more info
Multiple quote alternatives with the default name were created when duplicate action was set to merge.
Confirmation page for account termination could not be opened, account termination was impossible
File resulting from an export can now be received by email. Available in preview for selected customers, more info
Reduced the waiting time before a job starts
Added error details in the source preview
Import of new persons failed when option “Skip associate update without error” was enabled
Transformations settings were not copied when cloning a profile
Import of a profile failed if it was based on a SuperOffice selection from another tenant
Invoices can be imported into Visma.net with a custom reference number
Simplified duplicate check for quote versions and alternatives
New instant job parameter “TicketId” to export one specific request, more info
Profile name is now displayed in every step of the configuration
Sale stage is now properly updated for sold and lost sales
Fixed permanent delete of cloned profiles with a deleted transformation
Service requests can now be exported from a SuperOffice selection
New button to copy an existing transformation
Status of a job in progress is now refreshed every 5 minutes
Implemented country lookup by ISO number, 2-letter or 3-letter code, English or translated name How to solve Countries not being imported into SuperOffice when using DataBridge
Implemented associate lookup by email address Link a record to an associate in SuperOffice
Fixed lookup of associate by username for user-defined fields
Patch to support the new "OR" capabilities of selections
Person consent’s legal base and source can now be imported into SuperOffice.
New option to only update existing entities and not create new ones. This can be achieved with a new setting "Skip if not found" for each duplicate entity group in the Destination Setting page of your Profile. See also
New option in clean field transformation to convert a value into a number without leading zeroes.
More info on import transformations
More info on export transformations
In ‘Configure fields’ page, columns show which transformations they result from.
After you select a transformation and go to the Configure Fields page in your DataBridge Profile you can easily see which columns the Transformation have been applied to. An icon has been added with a tooltip that shows all the transformations applied to the column, in the order in which they are applied.
A more explicit error message is shown when the SuperOffice selection to export no longer exists.
Source files with an uppercase file extension are no longer rejected.
New feature
Added support to retrieve Visma.net customer’s note and balance
Added support to retrieve Visma.net supplier’s balance
Improvements
Sales can now be imported without being linked to a company
XML source files can now have a more flexible format with multiple nested levels
Bug fix
Profile drafts are now cleaned up after profile import fails
Fixed import of a new user-defined list item
Import of SuperOffice Service requests and request messages is now generally available.
Email notifications are now also sent when instant jobs complete.
Person update can now be skipped instead of fail when it is an associate in SuperOffice.
Customers can now request a higher document size limit when importing documents into SuperOffice.
Latest modified entities retrieved from Visma.net were possibly processed twice or missed if a write back transformation was set.
Contacts can now be retrieved from Visma.net and exported to a file or to another system. Available with Visma Link preview.
A total list can be found on page Specifications of the Import fields in Visma.net
Aligned style and logo of the portal with the new SuperOffice G9 style.
JSON response for instant jobs reflects the actual status of the job and contains extra information.
Default values can now be set for columns Source and Legal Base for newly imported consents into eMarketeer.
Added support for new columns for Visma.net customers, suppliers, and customer invoices.
Fixed interrupted eMarketeer job due to API key collision.
Added support for importing contacts into Visma.net
Clarified setting labels for retrieving only new and changed entities
Import jobs can now be skipped without error if there is no file on the FTP server, Dropbox or OneDrive
Fixed decimal separator for decimal numbers imported into a text field when the first row of Excel file contains an integer
Multiple persons with the same email address can be updated at once in SuperOffice
New consents can now be created in eMarketeer
Wrong API key for eMarketeer is now explicitly indicated during configuration of the profile
Exported profiles now also include one-time settings
Improved description for skipping the withdrawn consents in eMarketeer
Sale profit and profit as percentage are now automatically calculated
Recurrence scheme for scheduled jobs is now correctly imported when importing a profile
A default currency and a default tax zone can be set when importing Visma.net customer invoices
Added deduplication options for Visma.net customer invoice lines
Visma.net customers and suppliers can now be imported with an ID that contains spaces or special characters
Fixed performance issue when loading the transformations list
Jobs for which all lines failed used to be shown as successful if some lines were skipped
Fixed memory leak for jobs that import a large number of entities in SuperOffice
Rename transformation is systematically applied for headers of exported files like it used to
Display name of static columns is automatically used in headers of exported files like it used to
Allowed quotes in non-quoted fields in CSV files
Optimized backend processes to improve performance
Fixed incremental export: modified entities that should have been synchronized during a failed job are now recovered during the next successful job.
Allowed only existing legal bases and sources to be imported in eMarketeer to prevent API error.
User-friendly names of columns exported from SuperOffice are now displayed in all the steps of profile configuration.
Headers in exported files can contain either the user-friendly name or the technical key of the column.
Job log now indicates original file line number or source entity ID.
Job log for eMarketeer now indicates consent purpose and contact email address.
Invoices can be imported into Visma.net. Alpha version available for selected customers.
Fixed mapping error that prevented update of Visma.net customers with direct debit lines
Fixed column order for entities exported from Visma.net now to match the order in Fields multi-select.
Notifications of successful jobs were not sent when importing data into SuperOffice on-premise.
Jobs can no longer be stuck in status Queued.
Added a warning in job logs if a mapping value is missing in the Map List transformation.
Fixed signing in with SuperOffice online for browser with the new default SameSite cookie attribute behavior.
Fixed export of contacts that included the Portrait field.
Updated DataBridge logo in Google Drive authorization pages.
Added a log viewer for admin users to diagnose problems faster.
Added support for synchronizing consents with eMarketeer. Available in preview for selected customers.
SuperOffice entities can now be exported incrementally.
User-friendly names of columns exported from SuperOffice are now displayed in all the steps of profile configuration
Column “email/emailAddress” from SuperOffice now always contains company email address, instead of person email address for instant jobs with parameter
Profiles that involve Google Drive can now be opened and fixed when authentication token is expired
User-friendly names of columns exported from SuperOffice are now displayed in all the steps of profile configuration
Updated DataBridge logo in third-party authorization pages
Person consent fields can now be exported from SuperOffice starting from NetServer endpoint version 86
Person consent for purpose “Sales and service” can now be mapped from any source and imported into SuperOffice
Search for source field in transformations is now case-insensitive
Export profiles used to break in case of column name change
Refactored architecture to improve performance and scalability
Improved UI for admin users to open new features to selected customers
Added support for custom tables relations, including relations to standard tables, more info
Importing quote lines in SuperOffice will now also trigger revalidation to update calculated fields.
There is a new ‘Write back to source’ transformation that allows to write an auto-generated value back to the source system. Note: This is only possible for directly linked systems. Not when you use a file.
The possibility to read from and write to Visma.NET Financials is available for a selected set of entities (behind a feature toggle).
The fields supportAssociate and ticketPriority are now available for import into SuperOffice.
The outdated Nebula label has been removed from various portal pages.
Several improvements have been made for future connectors to be released.
Backend improvements for InfoBridge employees to provide better service to our customers.
Updated payment components for better PSD2 compatibility.
FTP issue fixed that prevented reading from certain FTP servers.
Interests can also be linked the SuperOffice way now, having a corresponding text in your import data to turn them on. More info
Improvements for the support of new connectors in future releases.
Failed job e-mails not being send on error while initializing connections.
Error when updating a custom table record with an unmapped empty date field.
The maximum amount of assignable columns in the portal for import profiles has been extended to 400.
A lot of refactoring and optimization has been done to prepare for new functionality in future releases.
Issues with the import of quote and quote lines regarding product images and versions.
Excel rows containing empty cells are handled properly now, before this could lead to line errors in some cases.
A bug has been fixed causing a popup on the subscription page all the time in some cases.
The limit for the amount of items in instant export can be changed on demand. Please contact InfoBridge to request the limit change.
Preparations have been made for the support of SuperOffice service custom tables import.
Internal optimization
For the SuperOffice Settings and Maintenance destination the import of company and person interests is now available. Available in preview for selected customers.
Resolved an issue regarding converting Excel decimal values when the first line is empty.
Resolved an issue that prevented the working of the field rename transformation when exporting to XML.
Resolved an issue that prevented clicking the unlink field button when the label is too long in the configuration wizard.
Small enhancements on the subscription page.
New ‘Configure Fields’ screen is now generally available
Improved error message when creating a subscription with an invalid VAT number
Backend improvements
Added support for importing currencies. Available in preview for selected customers
Importing from and to Google Sheets is now generally available
Resolved issue that could cause imports of Excel-files with a bordered column to last days
Resolved issue that could cause a loss of transformation setting values when exporting and importing a profile
Resolved issue that prevented the status widgets to be shown on the forgot password page
Added support for importing documents. Available in preview for selected customers, more info
New logo
Improved explanatory text for onsite endpoint connection settings
Backend upgrades for improving performance
Fixed rare issue that could corrupt FTP server connection settings
Fixed an issue that could result in calls to the ShipmentType table that does not exist for SuperOffice Onsite customer running version 7.5
Added support for importing SuperOffice Service requests and request messages. Available in preview for selected customers
New ‘Configure Fields’ style to make field mapping easier, simpler and faster. Available in preview for selected customers
Fixed issue that could cause an error page to be shown on the transformation screen when there is no data in a selection for export
Fixed issue that could cause Excel decimal values to be parsed according to decimal format settings, instead of being used without parsing
Resolved issue that could cause dates to be formatted incorrectly
Resolved issue that could show unsupported features (such as consent options) when using SuperOffice 7.5
Improved error message when adding more columns to an existing Google Sheet when using the append option
New transformation: ‘map list’, more info
The ‘clean field’ transformation can now also clean strings
More info on import transformations
More info on export transformations
Resolved issue with importing a profile with 2 or more transformations of the same type
Resolved issue that incorrectly showed the subscription type picking dialog twice in a rare case
The ‘clean number’ transformation is now called ‘clean field’. There are now two cleaning options:
Clean number removes all non-digit characters.
Clean text removes all special characters like dashes and dots.
Technology stack updates
Added advanced option in destination settings for imports ‘Mark selections as completed’, more info
File used in wizard is no longer included in a downloaded (exported) profile
Fixed issue that could cause a profile to be reset to wizard mode after a new file is picked, even though the file was identical
Resolved issue with ‘Partner billing’ option when using a Safari browser
New features
Added ‘split field’ transformation, more info
Added business and category fields on the ‘person’ entity, more info
Changes
Option for billing via a partner is now more prominent, more info
Jobs without any successful lines are now marked as ‘failed’ and will trigger the ‘failure notification’ email
Jobs with one or more failed lines will now trigger the ‘failure notification’ email
Added support for person ‘e-marketing’ flag and marketing subscriptions, more info
The date and number format can now be selected for Text (csv) and XML exports, more info
Added navigation buttons in job overview and job details screens, more info
Removed person field ‘no-mailings’ for all customers using SuperOffice 8.2 R01 and higher
Resolved error that could occur when signing up with the new SuperId SuperOffice accounts
Added new schedule option: hourly jobs, more info
Renamed various labels in the profile settings and account pages
Resolved issue that could cause large export to OneDrive to fail
‘Unknown’ sale type date duration units no longer cause import the line to fail when using the default value for sale date ‘Use estimate from sale type’
Resolved issue that could cause a job to fail when scheduled during the switch from ‘standard time’ to ‘daylight saving time’
Import from and export to Google Sheets is now available in preview for selected customers
More info on import locations
More info on export locations
Added option to calculate sale date for new sales based on the sale types “Estimate time for sale process”, more info
Changes
Duplicate checking can now also be done on user defined fields of type ‘long text’
XML and Excel export is now generally available
The wizard back button now always goes back to the previous page, even when there are issues preventing a save action
Instant jobs cannot be triggered for disabled profiles anymore
Users that log in with SuperOffice can no longer create a DataBridge ‘password login’
Requests to the instant job endpoint are now subjected to a throttling policy
Profiles can now be exported and imported to other tenants, more info
Further improved engine resilience
Partial work-around for issue with exporting combined selections. Combined selections with 1000 members or less will be exported again. Larger selections cannot be exported due to issue 60636: https://community.superoffice.com/nl/bugs-wishes/product-issue/?bid=60636
Improved engine resilience
New ‘add conditional field’ transformation
New ‘remove fields’ transformation
More info on import transformations
More info on export transformations
Login page now shows product status widget in the footer
New options to also add updated entities to a new selection after a job is completed. More info
Added support for Product Type, Product Category and Product Family lists. These can now be selected in Lists and Default Values in the Destination Settings page of your profile.
New and updated quote lines can now also be added to a selection
New instant export parameter for quote lines: QuoteId. More info
Added export to Excel files. This feature is now available for selected pilot customers
Added export to XML files. This feature is now available for selected pilot customers
A DataBridge administrator can now add additional administrators here: https://my-databridge.infobridgeuniverse.com/Manage/Administrators/
More info
New transformation: skip line
More info on import transformations
More info on export transformations
A custom import date/time format can now be specified, more info
The profile transformation overview now also shows the name of added fields
The ‘name’ setting of the ‘Add field’ transformation is now required
The search text in the field picker for export profiles is now cleared after selecting a field
Quote and quote line import is now available for selected pilot customers
Resolved issue that could cause an error when configuring Excel files with multi-line column headers
Resolved display issue with redundant scroll bar in ‘Configure Fields’-screen
Resolved issue that could cause product import to fail in certain situations
Added support for importing price lists, more info
Added sorting options for the profile overview.
You now have the options to sort by: Date (Oldest or Newest first), Name (A-Z or Z-A) or Status
Added support for importing XML files, more info
Fixed parsing of incorrect language resources for sale stage ‘open’ for languages Czech, French, German, Norwegian, Polish and Swedish
Resolved an issue that could cause an empty export file in OneDrive after exporting a SuperOffice selection
Added support for setting person consents for persons created by DataBridge. Onsite customers need to update the Netserver endpoint from Services75 to Services84 which requires at least SuperOffice 8.2 R01 or higher. More info
SuperOffice Onsite: updating the connection settings at https://my-databridge.infobridgeuniverse.com/Manage/Connection will now update all profile connection settings too
Added link to SuperOfffice onsite registration page: https://my-databridge.infobridgeuniverse.com/Account/SignUp
Instant jobs are now generally available. More info
Updated third-party libraries for security reasons
Deleted profiles can now be deleted permanently
Improvements for GDPR compliance: right to erasure
Changes in back-end to prepare for new GDPR features
Small user-interface improvements to ‘instant settings’
Added profile type icon to profile overview
Resolved issue that could cause an unjustified removal of a SuperOffice export column from the export file
Instant jobs button is now only shown for profiles of type ‘triggered’
Added instant jobs. Instantly run a job and specify a file to import or the record id of the item to export. More info
Note that: this feature is currently in preview. Contact us to enable this in your environment.
The only way we can currently offer and allow unlimited triggers without additional cost is with a fair use policy of one trigger every 15 minutes per profile.
For processing changes faster we have developed the instant sync feature which processes 1 or a small amount of changes immediately, see below
Added advanced option to manually specify additional selection export fields, more info
Added Trim option to Format Text transformation. Trim will remove all leading and trailing white-space from the value in the fields
Added “Append text value” transformation to allow prepending and appending text to field values
More info on import transformations
More info on export transformations
Resolved issue that could cause a OneDrive for Business import to fail when file was overwritten using the client
Updates back-end toolchain
The email address field for notifications is now pre-filled with address of the logged in user for new profiles.
Resolved an issue that could prevent correct saving of the interval for daily and weekly schedules
Empty selections will no longer block the export profile wizard with an error
Resolved an issue that could cause 2 jobs to be scheduled when ‘save and process now’ was used for scheduled profiles
Added new profile type: Triggered. Jobs for triggered profiles can be started by calling a webhook URL. Both import and export profiles can be triggered. More info
Optimized database and back-end for overall better performance.
Improved back-end to deal with locked jobs
Added new transformation: current date time. This transformation can be used to fill a field with the current date and time in both import and exports.
Example use: fill a user defined field with the latest update by DataBridge. Or: add export date to each record in the export file.
More info on import transformations
More info on export transformations
Various back-end improvements for GDPR compliance
Added new transformation: copy field. This transformation can be used to make a copy of an existing field so it can be linked more than once; more info
The replace transformation will now convert Excel null-values to an empty string before matching
Transformations are now available for all customers
DataBridge is now a verified Google App
Consents are redesigned for GDPR compliance
Partners can create a subscription on behalf of the customer
Button 'Submit subscription' is now called 'Update subscription' or 'Create subscription' depending on the status
Resolved an issue that could cause sale probability to be set to 0% instead of the correct percentage for the new sale stage
Updated various libraries as recommended by supplier
Added new transformation: Merge fields
Added new transformation: Format text value
Added new transformation: Replace
More info on import transformations
More info on export transformations
Added 'nej' and 'nei' as valid 'False'-values for boolean-type fields such as interests
Added new default value option: Sale source
Resolved issue that could cause invalid export files when using SFTP as storage location
Added support for exporting interests as individual columns, more info
Added support for import and export transformations. For early access: contact support@infobridge.com
Added transformation: Rename field
Added transformation: Add field (static field)
Added transformation: Clean number
More info on import transformations
More info on export transformations
When a sale stage is set the corresponding probability percentage is now set too
When a custom sale stage is set for a new sale, the sale status is now also set
Background and deployment optimization.
Added support for importing products, more info
Added company and admin name to bottom of emails sent by DataBridge
Added copy profile button, more info
Changed name of selections created by DataBridge so they are sorted properly in the quick search of SuperOffice CRM, more info
The order of export columns can now be changed by dragging them to a new position, more info
Added 4 new duplicate check options for companies (based on address)
Added new date format: d-M-yyyy
Improved performance of large selection exports
Fixed issue that prevented exporting of file to Google Drive when a folder with the name 'DataBridge_Export' was shared with the account.
Error messages coming from Dropbox should be more clear now
Fixed an issue that could occur when importing into column 'earning percentage' on sale
Persons can now be imported without a company, the relation is no longer mandatory. This is especially handy for companies using SuperOffice Customer Service with customers only, no company needs to be attached.
Added field 'Language' to persons. This is a SuperOffice Service field, more info
Added support for importing stakeholders, more info
Added support for deleting the import file after a successful import. This is available for files imported from Dropbox, FTP and SFTP, more info
Jobs can now be scheduled to start from a specified date
Upgraded back-end servers for higher performance
Added fall-back duplicate check fields for all entities. If the first check cannot be executed due to an empty field, then the second field is used, more info
Added option to set default value for new appointments: follow-up (task) type
Added information regarding DataBridge not supporting self-signed and invalid ftp certificates
Fixed an issue that could cause 'required relations'-message not to be shown in interface when required fields were also not linked
A message is now shown when a SuperOffice CRM selection is empty
Added support for SFTP (SSH File Transfer Protocol)
You can select the protocol SFTP from the advanced FTP settings in the profile
Fixed an issue that caused multi-language list items to be exported from SuperOffice CRM incorrectly. The language used is now selectable in the profile.
Added SuperOffice CRM On-Premises support, more info
Added export field picker for specifying which fields are exported from SuperOffice CRM Online
Added import field Person: Former Employee
Added import field Person: Academic title
Added fall-back duplicate check field for companies. If the first check cannot be executed due to an empty field, then the second field is used
Added default value option for new projects: Project responsible
Added support for fixed export columns
Empty mandatory relations (for example: sale->company) no longer block wizard step 3, a warning is shown instead
Fixes issue that caused label helper texts to disappear after a save was unsuccessful
Fixed an issue that could cause 404 page when linking a SuperOffice account to a DataBridge login
Fixed issue for projects with duplicate action 'always add' that caused project members to be linked to existing project instead of new project
The subscription page will now properly show success and error messages
Improved log message when project member is imported without valid project
Added support for importing project members. More info
Added support for duplicate checking on user defined fields of type short text and number
Added support for importing from and exporting to Microsoft OneDrive and Microsoft OneDrive for Business
Added abort button for running jobs in the 'view job' screen to stop big imports. More info
Only mapped fields are now available for duplicate checking
Added default values for new sale list items. More info
Person first name or last name is required now, at least one of these fields must be filled out. Before last name was required
Fixed issue that caused sale 'open' stage not to be imported
Fixed issue that caused export 'append date time' to be in UTC. This is now the local time
Excel dates and decimals do no longer require conversion settings to be parsed correctly
Sale company relation is now correctly marked as 'required'
Fixed issue that prevented refresh of tax field in the subscription page when entering a VAT number
New import and export location: FTP and FTPS
New option: default 'our contact' for new companies. Located in destination settings->Advanced settings SuperOffice CRM Online->Default values
New export fields on sale: project number, company number, company code
Fixed issue that could cause dropdown lists to display incorrectly in Firefox and IE when scrolling
Sale date is now a required field for imports
Fixed and issue that caused and error when multiple email addresses were specified for error/success emails
Project responsible is now a required field for imports
Company duplicate check field renamed from VAT to VAT No
Added support for importing projects and appointments
It’s now possible to search for fields in the field selector
Added field ‘registered date’ to sales
Duplicate settings are now only shown for linked entities
Added option for lists to automatically create new list item if it’s not found