daily 07/23/2017

July 23, 2017 Leave a comment
  • tags: scraping databaseexpansion

    • Web Crawling: What’s the simplest way of extracting email addresses from a website?
    • I use JavaScript here as if used directly in the Chrome Web Inspector, but any language with good HTML parsing library that supports CSS3 selectors will do.
    • the merge process is supposed to ignore the duplicates because one of the records is being deactivated.
    • the answer is the mentioning of the entity key in the message
    • When alternate key is present, the unique index is created by SQL Server and that index trumps any business layer rules and duplicate detections that Dynamics 365 might have in place.
      • man I don’t know what is an alternate key
    • Subordinate record will be deactivated but the value of the alternate key still there (and in the index) so any attempt to add the same value in the master record breaks the merge process.
    • Manually remove the value from the alternate key from the subordinate record and add it to the master.
    • “Swap” master and subordinate and merge into the record that contains the correct key value.
    • Tip #928: When CRM monthly charts won’t render
    • In Dynamics 365/CRM on premises, if you create a chart and group by month and find that it doesn’t render, you may need some additional SQL permissions.
    • Just type *dumble into the search box.
    • Wildcard at the end of the string is implied, i.e. there is no difference between searching for *Lebowski or *Lebowski*, both will find “Big Lebowski, The Dude” just fine (including “Small Lebowski, Not The Dude” in the process).
    • When you put your SQL Server hat on, you’ll find that leading wildcard search is “expensive” and ineffective.
    • Lastly, you already have a leading wildcard when you use Contains operator in Advanced Find
    • I don’t believe it’s possible without unsupported customizations and it’s better to empower users by teaching them to judiciously use “*” as part of their search term instead.
    • “If a President should pardon an accomplice, that accomplice then would be an unexceptionable witness,” Iredell wrote.
    • “If the President can be connected, in any suspicious manner, with any person, and there be grounds to believe he will shelter him, the House of Representatives can impeach him,”
    • It’s clear the Founding Fathers felt impeachment was the safeguard against using the pardon as an attempted criminal cover-up.
    • even if the Republican-controlled legislature failed to initiate impeachment proceedings, a future Justice Department could prosecute cases based on a former president’s use of the pardon.
    • Writing in the New York Times on Friday, constitutional scholars Eric Posner and Daniel Hemel agreed that Trump could be prosecuted for any such pardons were they to constitute obstruction of justice. They wrote:
    • “If he pardoned for money or pardoned corruptly, I would think that that could be prosecuted,” she told me. “I don’t think that he could do whatever he wants with the pardon power. He obviously can’t accept money for a pardon.”

Posted from Diigo. The rest of my favorite links are here.

Categories: Uncategorized

daily 07/19/2017

July 19, 2017 Leave a comment
    • Abbeville Christian Academy
    • Melanie Carlisle
    • Melanie.carlisle @acagenerals.org
    • Advent Episcopal School
    • W. Palmer Kennedy
    • pkennedy@adventepiscopalschool.org
    • Autauga Academy
    • Gene R. Canavan
    • agibbons@autaugaacademy.com
    • Bayside Academy
    • Michael Papa
    • mpapa@baysideacademy.org
    • Bessemer Academy
    • Julie Kelly
    • cperry@bessemeracademy.com
    • Cahawba Christian Academy
    • Gail Sammons
    • ahawbamail@yahoo.com
    • Central Christian School
    • Tim Shelton
    • central@gulftel.com
    • Central Park Christian School
    • Dr. Levan Parker
    • centralparkchristianschool@yahoo.com
    • Chambers Academy
    • Dr. John M. Mehaffey
    • jmehaffey@chambersacademy.com
    • Clarke Preparatory School
    • Doug Bradford
    • clarkeprep@tds.net
    • Coosa Christian School
    • Amanda Justus
    • ajustus@coosachristian.com
    • Coosa Valley Academy
    • Pamela Lovelady
    • info@coosavalleyacademy.org
    • Cornerstone Christian School
    • Cottage Hill Christian Academy
    • Mr. Jimmy Messer
    • messerj@chbss.org
    • Crenshaw Christian Academy
    • Gary D. Driver
    • driver.cca@gmail.com
    • East Memorial Christian Academy
    • Eastwood Christian School

Posted from Diigo. The rest of my favorite links are here.

Categories: Uncategorized

daily 07/15/2017

July 15, 2017 Leave a comment

Posted from Diigo. The rest of my favorite links are here.

Categories: Uncategorized

daily 07/11/2017

July 11, 2017 Leave a comment

Posted from Diigo. The rest of my favorite links are here.

Categories: Uncategorized

daily 07/10/2017

July 10, 2017 Leave a comment
    • Building a Marketing List Based on Page Views
    • In our example, we have created a form asking which specific ClickDimensions web content feature people are interested in learning more about: forms, surveys or landing pages. We want to add people to a specific marketing list based on which answer they choose in the drop-down menu. We also want to assign their record to a specific user based on their answer.
    • One of the problems I recently encountered, was that I would like to send a ClickDimensions e-mail to the contact’s secondary emailadress from a workflow, known as EmailAdress2 in Dynamics CRM.
    • So, time to make a work around. We will do this by a combination of workflows, marketing lists and ClickDimensions marketing automation.
    • This extends CRM’s native behavior by creating only the records that aren’t listed in the system already and by taking action on both new and old Leads or Contacts.
    • The import tool is designed to help speed data entry and is ideal for situations where you collect names and email addresses, such as a sign-in sheet at an in-person event, or a list of registrants sent to you from an external vendor. However, for more complex scenarios such as loading large amounts of data from external systems, you should consider enterprise data migration tools such as SSIS, Scribe or Kingswaysoft which are designed to provide data cleansing, transformation and multi-threading.
    • Create Privilege for the ClickDimensions Import record.
    • n order to map the data into your system properly, the row headers cannot be changed.
    • For Owner, type the full name of the desired Owner record as it appears in CRM. Once your data is ready, upload your completed template and click Next.
    • If the email address already exists in your system, you can choose whether to pull over the other information listed for that person and overwrite the data already in the Lead or Contact record.
    • Choose Lead or Contact as the record type for any new records to be created. New records will be created when there are email addresses that don’t match any existing records.
    • Add all to Marketing List

       

      Everyone on the uploaded file will be added to these Marketing Lists in CRM. We recommend specifying two Marketing Lists here, one for Leads and one for Contacts. Please note that these Marketing Lists will need to be Static. You can select multiple Lead or Contact Marketing Lists as well.

    • You can see Leads and Contacts imported in Import Logs as well as detailed activity on your Actions in Events List, Marketing Lists to Attach to, and Marketing Lists to Detach from.

Posted from Diigo. The rest of my favorite links are here.

Categories: Uncategorized

daily 07/05/2017

July 5, 2017 Leave a comment

Posted from Diigo. The rest of my favorite links are here.

Categories: Uncategorized

daily 07/02/2017

July 2, 2017 Leave a comment

Posted from Diigo. The rest of my favorite links are here.

Categories: Uncategorized