Breaks Archives - Business Intelligence Info

Tag Archives: Breaks

Unexpected breaks in a smooth plot

March 3, 2019 BI News and Info

I have the following code leading to a broken plot. However, I physical intuition (based on the problem I am dealing with) says that there should be a continuous curve.

    A[\[Phi]_, \[CapitalOmega]_, \[Gamma]_] = \[Sqrt](1 - 
    2 \[CapitalOmega] Cos[\[Phi]] + \[CapitalOmega]^2 - \
\[Gamma]^2);(*= \[Sqrt](|1-\[CapitalOmega] Exp[I \
\[Phi]](|^2)-\[Gamma]^2)=\[Sqrt](J^2-\[Gamma]^2). If J>\[Gamma] \
system is PT symmetric, otherwise its not.*)
alpha[\[Phi]_, \[CapitalOmega]_, \[Gamma]_, t_] = 
 Cos[A[\[Phi], \[CapitalOmega], \[Gamma]]* t] - \[Gamma]/
   A[\[Phi], \[CapitalOmega], \[Gamma]] Sin[
    A[\[Phi], \[CapitalOmega], \[Gamma]] *t]; 
beta[\[Phi]_, \[CapitalOmega]_, \[Gamma]_, t_] = -I (
   1 - \[CapitalOmega]* Exp[-I \[Phi]])/
   A[\[Phi], \[CapitalOmega], \[Gamma]] Sin[
    A[\[Phi], \[CapitalOmega], \[Gamma]]* t];

rho[\[Phi]_, \[CapitalOmega]_, \[Gamma]_, 
   t_] = (1/(
    Abs[alpha[\[Phi], \[CapitalOmega], \[Gamma], t]]^2 + 
     Abs[beta[\[Phi], \[CapitalOmega], \[Gamma], t]]^2) ) {{Abs[
      alpha[\[Phi], \[CapitalOmega], \[Gamma], t]]^2, 
     alpha[\[Phi], \[CapitalOmega], \[Gamma], t]*
      Conjugate[
       beta[\[Phi], \[CapitalOmega], \[Gamma], 
        t]]}, {beta[\[Phi], \[CapitalOmega], \[Gamma], t]*
      Conjugate[alpha[\[Phi], \[CapitalOmega], \[Gamma], t]], 
     Abs[beta[\[Phi], \[CapitalOmega], \[Gamma], t]]^2}};
p[\[Phi]_, \[CapitalOmega]_, \[Gamma]_, t_] = 
  rho[\[Phi], \[CapitalOmega], \[Gamma], t][[2]][[2]];
x[\[Phi]_, \[CapitalOmega]_, \[Gamma]_, t_] = 
  rho[\[Phi], \[CapitalOmega], \[Gamma], t][[1]][[2]];

funQ\[Rho]out[\[Phi]_, \[CapitalOmega]_, \[Gamma]_, 
   t_] = -(((-1 + 
          p[\[Phi], \[CapitalOmega], \[Gamma], 
           t]) ((-1 + 
             p[\[Phi], \[CapitalOmega], \[Gamma], 
              t]) p[\[Phi], \[CapitalOmega], \[Gamma], t] + 
          Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2) Log[((-1 + 
            p[\[Phi], \[CapitalOmega], \[Gamma], 
             t]) ((-1 + 
               p[\[Phi], \[CapitalOmega], \[Gamma], 
                t]) p[\[Phi], \[CapitalOmega], \[Gamma], t] + 
            Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2))/(
         2 ((-1 + p[\[Phi], \[CapitalOmega], \[Gamma], t])^2 + 
            2 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], 
               t]]^2))])/(((-1 + 
            p[\[Phi], \[CapitalOmega], \[Gamma], t])^2 + 
          2 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2) Log[
         2])) - 1/
    Log[2] (-1 + 
      Sqrt[(-1 + p[\[Phi], \[CapitalOmega], \[Gamma], t])^2 + 
       2 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2]) Log[
     1/2 (1 - 
        Sqrt[(-1 + p[\[Phi], \[CapitalOmega], \[Gamma], t])^2 + 
         2 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2])] + 
   1/Log[2] (1 + 
      Sqrt[(-1 + p[\[Phi], \[CapitalOmega], \[Gamma], t])^2 + 
       2 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2]) Log[
     1/2 (1 + 
        Sqrt[(-1 + p[\[Phi], \[CapitalOmega], \[Gamma], t])^2 + 
         2 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2])] - ((1 - 
        5 p[\[Phi], \[CapitalOmega], \[Gamma], t] + 
        10 p[\[Phi], \[CapitalOmega], \[Gamma], t]^2 - 
        10 p[\[Phi], \[CapitalOmega], \[Gamma], t]^3 + 
        5 p[\[Phi], \[CapitalOmega], \[Gamma], t]^4 - 
        p[\[Phi], \[CapitalOmega], \[Gamma], t]^5 + 
        5 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2 - 
        13 p[\[Phi], \[CapitalOmega], \[Gamma], t] Abs[
          x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2 + 
        11 p[\[Phi], \[CapitalOmega], \[Gamma], t]^2 Abs[
          x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2 - 
        3 p[\[Phi], \[CapitalOmega], \[Gamma], t]^3 Abs[
          x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2 + 
        6 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^4 - 
        2 p[\[Phi], \[CapitalOmega], \[Gamma], t] Abs[
          x[\[Phi], \[CapitalOmega], \[Gamma], t]]^4 + 
        Sqrt[((-1 + p[\[Phi], \[CapitalOmega], \[Gamma], t])^2 + 
          2 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2)^5]) Log[
       1/(2 ((-1 + p[\[Phi], \[CapitalOmega], \[Gamma], t])^2 + 
           2 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2)^2) (1 - 
          5 p[\[Phi], \[CapitalOmega], \[Gamma], t] + 
          10 p[\[Phi], \[CapitalOmega], \[Gamma], t]^2 - 
          10 p[\[Phi], \[CapitalOmega], \[Gamma], t]^3 + 
          5 p[\[Phi], \[CapitalOmega], \[Gamma], t]^4 - 
          p[\[Phi], \[CapitalOmega], \[Gamma], t]^5 + 
          5 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2 - 
          13 p[\[Phi], \[CapitalOmega], \[Gamma], t] Abs[
            x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2 + 
          11 p[\[Phi], \[CapitalOmega], \[Gamma], t]^2 Abs[
            x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2 - 
          3 p[\[Phi], \[CapitalOmega], \[Gamma], t]^3 Abs[
            x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2 + 
          6 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^4 - 
          2 p[\[Phi], \[CapitalOmega], \[Gamma], t] Abs[
            x[\[Phi], \[CapitalOmega], \[Gamma], t]]^4 + 
          Sqrt[((-1 + p[\[Phi], \[CapitalOmega], \[Gamma], t])^2 + 
            2 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], 
               t]]^2)^5])])/(2 ((-1 + 
          p[\[Phi], \[CapitalOmega], \[Gamma], t])^2 + 
        2 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2)^2 Log[
       2]) + ((-1 + 5 p[\[Phi], \[CapitalOmega], \[Gamma], t] - 
        10 p[\[Phi], \[CapitalOmega], \[Gamma], t]^2 + 
        10 p[\[Phi], \[CapitalOmega], \[Gamma], t]^3 - 
        5 p[\[Phi], \[CapitalOmega], \[Gamma], t]^4 + 
        p[\[Phi], \[CapitalOmega], \[Gamma], t]^5 - 
        5 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2 + 
        13 p[\[Phi], \[CapitalOmega], \[Gamma], t] Abs[
          x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2 - 
        11 p[\[Phi], \[CapitalOmega], \[Gamma], t]^2 Abs[
          x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2 + 
        3 p[\[Phi], \[CapitalOmega], \[Gamma], t]^3 Abs[
          x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2 - 
        6 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^4 + 
        2 p[\[Phi], \[CapitalOmega], \[Gamma], t] Abs[
          x[\[Phi], \[CapitalOmega], \[Gamma], t]]^4 + 
        Sqrt[((-1 + p[\[Phi], \[CapitalOmega], \[Gamma], t])^2 + 
          2 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2)^5]) Log[-(
         1/(2 ((-1 + p[\[Phi], \[CapitalOmega], \[Gamma], t])^2 + 
            2 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], 
               t]]^2)^2)) (-1 + 
          5 p[\[Phi], \[CapitalOmega], \[Gamma], t] - 
          10 p[\[Phi], \[CapitalOmega], \[Gamma], t]^2 + 
          10 p[\[Phi], \[CapitalOmega], \[Gamma], t]^3 - 
          5 p[\[Phi], \[CapitalOmega], \[Gamma], t]^4 + 
          p[\[Phi], \[CapitalOmega], \[Gamma], t]^5 - 
          5 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2 + 
          13 p[\[Phi], \[CapitalOmega], \[Gamma], t] Abs[
            x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2 - 
          11 p[\[Phi], \[CapitalOmega], \[Gamma], t]^2 Abs[
            x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2 + 
          3 p[\[Phi], \[CapitalOmega], \[Gamma], t]^3 Abs[
            x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2 - 
          6 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^4 + 
          2 p[\[Phi], \[CapitalOmega], \[Gamma], t] Abs[
            x[\[Phi], \[CapitalOmega], \[Gamma], t]]^4 + 
          Sqrt[((-1 + p[\[Phi], \[CapitalOmega], \[Gamma], t])^2 + 
            2 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], 
               t]]^2)^5])])/(2 ((-1 + 
          p[\[Phi], \[CapitalOmega], \[Gamma], t])^2 + 
        2 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2)^2 Log[2]) + 
   1/Log[4] (-4 ArcTanh[
        Sqrt[(-1 + p[\[Phi], \[CapitalOmega], \[Gamma], t])^2 + 
         2 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2]] Sqrt[(-1 +
           p[\[Phi], \[CapitalOmega], \[Gamma], t])^2 + 
        2 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2] + 
      2 ArcTanh[
        Sqrt[(1 - 2 p[\[Phi], \[CapitalOmega], \[Gamma], t])^2 + 
         4 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2]] Sqrt[(1 - 
          2 p[\[Phi], \[CapitalOmega], \[Gamma], t])^2 + 
        4 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2] + Log[4] - 
      2 Log[1 - 
         Sqrt[(-1 + p[\[Phi], \[CapitalOmega], \[Gamma], t])^2 + 
          2 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2]] - 
      2 Log[1 + 
         Sqrt[(-1 + p[\[Phi], \[CapitalOmega], \[Gamma], t])^2 + 
          2 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2]] + 
      Log[1 - Sqrt[(1 - 
           2 p[\[Phi], \[CapitalOmega], \[Gamma], t])^2 + 
         4 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2]] + 
      Log[1 + Sqrt[(1 - 
           2 p[\[Phi], \[CapitalOmega], \[Gamma], t])^2 + 
         4 Abs[x[\[Phi], \[CapitalOmega], \[Gamma], t]]^2]]) ;

Plot[{Re[funQ\[Rho]out[0, 0.4, 0.5, t]]}, {t, 0, 10}, 
 PlotRange -> All, PlotStyle -> {Blue, Thick}, AxesOrigin -> {0, 0}]

How can one resolve the issue?
—————————Un-related text——————————
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa

Let’s block ads! (Why?)

Recent Questions – Mathematica Stack Exchange

USAFacts breaks down government financial data with Power BI

April 22, 2018 Self-Service BI

On tax day this year USAFacts is relying on Power BI to publish a 10-k report to provide a comprehensive view of the combined US federal, state and local governments’ revenues and expenditures. The data is collected from multiple government sources including the US Treasury Department, the Office of Management and Budget, the US Census Bureau, and the Federal Reserve.

The USAFacts team used Power BI to quickly and efficiently build interactive data visualizations that could be published directly to the web, without writing any code. Visitors to the site, across both web and mobile, can click through the charts of greatest interest to them and explore the various elements of the government budget.

The reports leverage some of our favorite Power BI features. For example, the Revenues report showcases the popular Bookmarking feature to toggle between a Table or Chart view. This provides the viewer with the option to increase the amount of detail, or to view only the charts instead of a table.

The Federal Land Ownership in the U.S. Total report has the same toggle button, but this time provides the option to show the data as a table vs. maps. The maps are interactive and display just the selected state data when marked.

The Combined Income Statements report features clean tables with a drop down filter on the top right. This approach gives viewers the flexibility to pick ‘inflation-adjusted’ or not for example, pending their financial reporting needs.

USAFacts is empowering their audience, journalists, academics, think tanks, and analysts alike to be able to reuse the visualizations hosted on USAFacts and even mash them up with their own data, or re-visualize the data discover new stories. USAFacts will share the Power BI content as embeddable links and the underlying Power BI files if you request them by email, so it’s easy for to include interactive reports in stories.

A growing number of media are adopting Power BI because it is a simple and scalable solution to discover, create and share data stories. In addition to individuals creating visuals for stories, organizations like the Associated Press and USAFacts are providing Power BI reports to journalists and others interested in sharing data online with Power BI publish to web to scale the distribution of the data they share. By providing pre-built Power BI reports, these organizations enable anyone to easily include an interactive report created in Power BI in an online story with just a few clicks.

There’s growing demand for collaborative, flexible, data journalism that empowers the audience to reuse, reinterpret, and repurpose data stories to reveal insights and establish a deeper connection with their own audience. By using Power BI, they’re ensuring the tooling required is low cost, easy to use and future-proof because it’s built and supported for core productivity scenario within Enterprises. They’re removing the technological barriers that prevented many from participating in data journalism.

With these choices, they’re showing how Power BI can democratize data journalism, bringing in more journalists, bloggers, and analysts.

Using a Power BI interactive visualization in your data story

If you are interested in using a Power BI embed code, follow the steps below to use the report in your own public story, blog or website. If you want to find out more about how to get started with Power BI to build your own reports, you can download the latest version of the free Power BI Desktop and sign up for the cloud service.

Often an organization providing a Power BI report for data journalism will offer two options:

An “embed code” that enables you to easily include the very same interactive graphic on your own site and offer your readers the ability to also “explore” the data. You can increase engagement from your site visitors by enabling them to uncover how the data relates to them personally. To include the interactive report on your site, simply copy-and-paste the several lines of Web code into your site’s content management system. Note that the embed code should be sized to fit the iFrame on your site, and when implemented correctly, will appear without any extra grey borders.
A “Power BI” file, which contains the data and interactive graphic in a single, editable “.pbix” format for use in Power BI Desktop. If you are interested in publishing the interactive graphic, but would like to make modifications to it first – perhaps changing its colors, fonts, other elements of style – then download the .pbix file and adjust it using Power BI Desktop. Once you have customized the report, you will be ready to add it to your website. Follow these instructions to publish into your service, and then learn how to create an embed code to publish the report to the web.

Where to from here?

If you want to learn more about Power BI we recommend the following resources:

Power BI Documentation – covers all aspects of Power BI.
Power BI Community – online forum where you can search for answers, learn from others and discuss Power BI with experts and peers. This is also a great resource to keep up to date with Power BI and new features and improvements that are continually being released.
Data Stories Gallery – find other reports and examples of data storytelling from members of our community.
If you have questions about to use Power BI for data journalism, check our website here or email us directly at MSFTDataJournalism@Microsoft.com.

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

American Breaks People

August 30, 2016 CRM News and Info

It’s easy to lose sight of people in a CRM discussion, focusing instead on the great technology and what it lets us do under optimum circumstances. We should keep the customer in mind at all times, however, for without them what are we?

Forgetting the customer is dangerous both for customers and vendors in this social age. Far from being a universal good, automation can make it hard to reach a human being when circumstances require a human to make sense of reality. It’s dangerous for vendors too, because that disconnect results in unhappy customers who have the ability to tell their stories in the most public forums.

United Breaks Guitars — the song, the book, and the YouTube series — provides a graphic example of how things can go bad and how some organizations are culturally misaligned with the era of customers.

For the uninitiated, UBG chronicles a months-long saga of one customer trying to get the airline to repair a guitar badly damaged in transit by baggage handlers — all to little avail. The customer, Dave Carroll shredded United’s reputation by writing songs about the incident, which were recorded on the way to going viral on YouTube.

[embedded content]

UBG might be the poster child for what not to do and how important it is to adapt to the customer era — but it is not the only example.

From Bad to Worse

I recently became aware of another incident involving an airline in which good CRM — the attitude and approach to business, if not the technology — was completely lacking. The Villaluz family of three, Americans of Filipino extraction, wanted to fly from Boston to Dallas on American Airlines in July. Through a series of missteps, they instead ended up broke, baggage-less and blacklisted in New York’s LaGuardia airport.

The original flight from Boston, American 2607, was delayed and ultimately canceled after about six hours. Passengers were given the option of taking AA 2172 Boston to LaGuardia for a connection to Dallas AA 1144 leaving at 7:59 p.m. The airline also gave them food vouchers.

The Villaluz family are the salt of the earth, sources have told me, known for volunteering and giving to their church and community. Their trip was to have been part vacation and part work. The father, Ken Villaluz, is a pastor who had been scheduled to perform two house blessings in Dallas. The remainder of the trip was to have been a family visit. His wife, Ruby, is a nurse. Their 12 year-old daughter has difficulty flying — she’s actually phobic, and one parent needed to be seated with her to reassure her during the flight.

In New York, the family needed a little assistance from the ground crew to help ensure that their daughter was accommodated. While they all had boarding passes, they weren’t given two seats together, thanks to the original cancellation.

Special needs such as theirs often are met on board by a flight attendant asking other passengers to volunteer switching seats. The Boston ground crew assured the family that their need would be taken care of by the New York crew — but even though the family was allowed to board early, they didn’t get the assistance they needed.

What happened next is the stuff of movies. Since the family was on board early and very polite, they didn’t simply take seats. Instead, they asked for assistance from the crew. The flight attendant instead demanded that the family ground-check their carry-ons — including a live lobster — and stand out of the way.

The Villaluzes were confused, because they’d arrived from Boston on a smaller plane with their bags in the overhead bins. It makes no sense that passengers boarding early were being told to check their bags — but a lot doesn’t make sense at this point.

Total Breakdown

The father, the pastor, asked to speak with a manager, and one Brady S. approached. Rather than helping the family, Brady S. insisted on getting their bags checked. When the minister complained about his demeanor, Brady S. escorted the family off the plane and told them to he’d deal with them after the flight left.

The daughter began to sob. The father, already humiliated, sobbed too. The plane left without the family — but with its gate-checked luggage, including the lobster.

The father tracked down a policeman to be present as a witness when he had his next encounter with Brady S., but after the facts were laid out, the cop excused himself from the conversation saying that it was not his jurisdiction and nothing criminal had happened. Nothing.

The family then sought to rebook on American yet again, hoping to exchange the value of their original tickets. Unfortunately, though they found another American flight, the agent told them they could not access it. Brady S. had blacklisted them, making it impossible to fly American and making the value of their tickets inaccessible.

The family was stranded. It was about 8 p.m., and all of their luggage was on a flight to Dallas. They didn’t have much money and had to call family to help them rebook on United for a flight the next morning. Meanwhile, the 12 year-old was in a highly disturbed state. The family had to get a hotel in New Jersey near the Newark airport, which required an expensive cab ride from LaGuardia.

United flight 1993 left Newark at 6:30 a.m., bound for Houston, meaning that the broke, bag-less, and blacklisted family got all of two hours sleep at their hotel. They reached Houston and eventually Dallas that day, but the father missed his house blessings. Naturally, the family is trying to get its money back — and unsurprisingly, American Airlines is doing its best imitation of see no evil, hear no evil, speak no evil.

Why Did This Happen?

There’s some evidence that American is doing what it can to speed up its boarding and aircraft turnarounds to help ensure that it gets the most productivity from every flight.

The speedup is an effort to improve on-time performance, but the Allied Pilots Association warned about the changes, according to a Bloomberg story: “The airline is directing that some flight plans increase air speeds to near plane limits and on routes expected to hit turbulence, as a means of making sure that crews comply with FAA guidelines on hours worked and avoiding the delays associated with assigning fresh personnel, the union said.”

The article goes on to quote a letter from union President Dan Carey: “‘APA pilots are now reporting that management is manipulating flight plans in order to keep an operation under duress from coming apart at the seams,'” the letter said. “‘These last-minute manipulations are used to make a flight appear legal when in reality it’s not or is, at best, on the ragged edge.'”

You can only wonder if the speedup prevented this family from getting the attention their simple request deserved. If their account of the ordeal is true, it suggests an almost total failure of what CRM should be about: customers and companies’ relationships with them. Moreover, this story suggests just how decrepit the airline business model is, at least for some.

This was not a technology failure — it was caused by a lack of empathy up and down American’s structure, from senior management who wanted faster turnarounds and greater profitability per flight to customer service people whose jobs have been corrupted to serve profits almost to the exclusion of customer service.

An airline focusing on on-time arrivals and departures might be able to say that it has its customers’ best interests in mind, but without attending to all of the other moments of truth involved in making air travel successful, that single focus is ultimately self-defeating.

Denis%20Pombriant American Breaks People Denis Pombriant is a well-known CRM industry researcher, strategist, writer and speaker. His new book, You Can’t Buy Customer Loyalty, But You Can Earn It, is now available on Amazon. His 2015 book, Solve for the Customer, is also available there. He can be reached at denis.pombriant@beagleresearch.com.

Let’s block ads! (Why?)

CRM Buyer

Migrating Email Body with Line Breaks

July 27, 2015 Microsoft Dynamics CRM

[unable to retrieve full-text content]

Microsoft Dynamics CRM allows users to send emails directly out of CRM itself. Those emails can absolutely be transferred over when migrating from a legacy system to Dynamics CRM. However, sometimes during a migration, if the body of the email in your legacy system is in plain text, the formatting is lost in the migration because CRM expects an HTML format. In today’s blog, we will discuss a few things to consider when migrating an email body during a data migration from legacy systems to Dynamics CRM.

Problem:

When the body of an email is in plain text, you lose its formatting after a migration because CRM is expecting an HTML format. By utilizing direct mapping, the email body gets imported into CRM without line breaks. Technically, at the CRM database level, the data will have line breaks. However, when presented in the CRM interface as shown below, all line breaks will be lost.

13 Migrating Email Body with Line Breaks

Solution:

By embedding the body in <PRE> </PRE> tags (which are used to define preformatted data), you are able to migrate the email data without losing the line breaks. As you can see in the image below, your email body is now formatted correctly.

21 Migrating Email Body with Line Breaks

This is how the source query would look:

SELECT ‘<PRE>’ + [emailBody] + ‘</PRE>’ FROM [toCRMEmail]

Another solution that will also work is to replace SQL Char(13) and Char(10) with <BR> tags, however, using <PRE> tags ensures that you won’t have to worry about any other formatting issues and performance issues that may arise.

That’s all for today! Remember that if you run into issues with this or any other CRM functionalities, you can always open a support request with PowerObjects. Thanks for stopping by our blog today!

Happy CRM’ing!