Salesforce data migration: promoting data changes from a sandbox to production
By Dylan Wooters
November 24, 2021
Photo by Dylan Wooters, 2021
Intro
End Point recently completed a new e-commerce website built using Nuxt, Node.js, and Algolia and backed by Salesforce data. As part of the project, the client also wanted to re-categorize their products. They had already updated the data in a Salesforce sandbox and needed a way to move their changes to production in conjunction with the launch of the new website.
This data migration initially seemed like a simple request, but it ended up being one of the more challenging parts of the project. While there are clear instructions on how to migrate code changes from a sandbox to production (via change sets), there is very little information on how to migrate data.
Here I will outline the solution we developed, which involved writing a custom migration script using the JSForce library, testing using additional sandboxes, and planning for a rollback. This can serve as a blueprint for developers faced with the same task.
Why not use Data Loader to migrate?
The Salesforce Data Loader is a clunky yet reliable application that allows you to load large amounts of data directly into a Salesforce org. It will work to migrate data if the requirements are not …
salesforce typescript migration
From Liquid Galaxy to VisionPort
By Alejandro Ramon
November 23, 2021
We are rebranding! Meet the future of Liquid Galaxy: VisionPort.
We are proud to announce the official launch of VisionPort, the next phase for Liquid Galaxy. We have spent the past six months taking steps to rebrand, expand, and reposition our product to combine modern working necessities with the traditional kiosk-style, shared immersive experience familiar to our clients. Through these efforts have come a robust product encompassing an entire room of enhanced features, screens, and conference-enabling applications.
While our core product will remain consistent with what our clients know and love, current and future clients can look forward to significant updates to the content management system and user experience. We are also proud to announce advanced add-on features that will allow our current and future clients to make their systems more collaborative, interactive, and adaptable to their needs.
Our core offerings include:
- Extensive preparation and customization of screens, servers, and frames
- Google Earth, Cesium, Street View, etc.
- Content Management System
- Ongoing support service
- Custom installation, system, and content consulting
- Comprehensive system and content training …
visionport company
Forwarding Google Forms responses to an external API
By Afif Sohaili
November 16, 2021
Google Forms is a great form service that many people use for surveys, research, questionnaires, etc. It has an intuitive and flexible interface for building forms and is fairly easy to use for everyone. Once you get a response, you can view the results in the admin section of the form or in a Google Sheets document in which Google will automatically insert all your responses.
However, you may need to do something else with the responses. For example, what if you want to have the response printed in your Slack channel or Discord server? Or what if you want to use the raw data to make more complex visualizations than Google Sheets is capable of?
Google Apps Script to the rescue!
Google Apps Script is a development platform for building add-ons for Google products, such as Google Sheets, Google Docs, and Google Forms. You write your JavaScript in the code editor that Google provides for you, so there is nothing to install on your local machine to start developing. This code then gets executed on Google’s servers. These Google Apps Script projects can then be published as a Google Workspace add-on that others can use or shared within your organization.
Even though Google Apps …
google-apps-script javascript integration google-forms
Liquid Galaxy Media Stream Integration
By Alejandro Ramon
November 11, 2021
End Point’s Immersive and Geospatial Division is proud to announce the rollout of our new Media Stream Integration as an extension to the Liquid Galaxy platform’s capabilities. This additional hardware can be added to existing installations or included in a new solution provided by our sales team.
The Media Stream Integration (“MSI”) is a collection of hardware additions to the Liquid Galaxy that allows a user to stream from any HDMI capable device in up to a 4k (3840×2160 pixels) window on the main displays of the system.
With the MSI, a user can connect and share any media source directly to the system through the touchscreen. Examples include a video game console, cable TV box, DVR device, laptop or desktop computer, Plex server, and more. In other words, users can showcase media content that may not be natively supported on the Liquid Galaxy platform.
How it works
A user simply ensures that the device is on, and it will appear as an option to share to the Liquid Galaxy screens on the touchscreen. The stream can be overlaid on top of existing content in pre-defined windows on the display wall through which the content will be displayed. When finished, the overlay window can be …
visionport
New Jersey Liquid Galaxy Installation
By Ben Witten
November 10, 2021
End Point Dev installed a Liquid Galaxy system at the New Jersey office of one of our clients this past March. This marks the fifth office that our client is using to showcase a Liquid Galaxy, joining offices in 4 other states. This new seven-screen Liquid Galaxy system is built into a conference room wall, and will be used as a technological showpiece to allow their team and clients to view different locations, information, and datasets in an immersive and interactive environment.
As our team is headquartered in New York City, this was a relatively local installation. Our End Point Dev engineers initially spent three days installing this system at the client’s new office; however, due to unforeseen circumstances there were a couple of return trips made to finalize details and ensure the best possible product. We also provided one day of on-site system training, walking the team through using the system and creating presentations with the Content Management System.
All Liquid Galaxy content for this client has been prepared by their global marketing team, who build region-focused content for each of the different Liquid Galaxy systems. The team effectively builds interactive …
visionport clients
.NET/C# developer job opening
By Jon Jensen
November 9, 2021
This position has been filled. See our active job listings here.
Photo by #WOCinTech Chat · CC BY 2.0, modified
We are seeking a full-time .NET/C# software developer based in the United States to work with us on our clients’ applications.
End Point Dev is an Internet technology consulting company based in New York City, with 50 employees serving many clients ranging from small family businesses to large corporations. The company is going strong after 26 years in business!
Even before the pandemic most of us worked remotely from home offices. We collaborate using SSH, Git, project tracking tools, Zulip chat, video conferencing, and of course email and phones.
What you will be doing:
- Develop new web applications and support existing ones for our clients.
- Work together with End Point Dev co-workers and our clients’ in-house staff.
- Use your desktop operating system of choice: Windows, macOS, or Linux.
- Enhance open source software and contribute back as opportunity arises.
You’ll need professional development experience with:
- 3+ years of development with .NET and C#
- Databases such as SQL Server, PostgreSQL, Redis, Solr, Elasticsearch, etc.
- Front-end web development with HTML, CSS, JavaScript and frameworks such as Vue, React, Angular …
jobs-closed dotnet remote-work
DevOps & Kubernetes engineer job opening
By Jon Jensen
November 4, 2021
This position has been filled. See our active job listings here.
We are looking for a full-time, salaried DevOps / Kubernetes engineer to work on cloud hosting projects with our clients and our internal hosting team.
End Point Dev is an Internet technology consulting company based in New York City, with 50 employees serving many clients ranging from small family businesses to large corporations. We are going strong after 26 years in business!
Even before the pandemic most of us worked remotely from home offices. We collaborate using SSH, Git, project tracking tools, Zulip chat, video conferencing, and of course email and phones.
What you will be doing:
- Automate, set up, support, and maintain complex containerized applications in the cloud.
- Audit and improve security, backups, reliability, monitoring.
- Work together with End Point Dev co-workers and our clients’ in-house staff.
- Use your desktop operating system of choice: Linux, macOS, or Windows.
- Work with open source software and contribute back as opportunity arises.
You’ll need professional experience with:
- Production Kubernetes administration on Amazon EKS (2+ years)
- Linux and common distributions including Ubuntu, RHEL/CentOS
- Public clouds such as AWS, GCP, Azure, Linode, …
jobs-closed kubernetes devops remote-work docker containers
Java developer job opening
By Jon Jensen
November 3, 2021
This position has been filled. See our active job listings here.
We are seeking a full-time Java server-side software developer based in the United States to work with us on our clients’ applications.
End Point Dev is an Internet technology consulting company based in New York City, with 50 employees serving many clients ranging from small family businesses to large corporations. The company is going strong after 26 years in business!
Even before the pandemic most of us worked remotely from home offices. We collaborate using SSH, Git, project tracking tools, Zulip chat, video conferencing, and of course email and phones.
What you will be doing:
- Develop new web applications and support existing ones for our clients.
- Work together with End Point Dev co-workers and our clients’ in-house staff.
- Use your desktop operating system of choice: Linux, macOS, or Windows.
- Enhance open source software and contribute back as opportunity arises.
You’ll need professional development experience with:
- 4+ years of development with Java for server-side applications
- Frameworks and libraries such as Wildfly, Hibernate, Spring, Struts, Play
- Databases such as PostgreSQL, Redis, Solr, Elasticsearch, etc.
- Security consciousness, such as under HIPAA for safe …
jobs-closed java remote-work