A working D7 to D8 node migration

Submitted by barnettech on Wed, 01/30/2019 - 09:40
source:
  plugin: d7_node
  node_type: market_center
  key: d7finra
  constants:
    uid_root: 1
    node_article: 'article'
destination:
  plugin: entity:node
process:
  # Hardcode the destination node type (bundle) as 'migrate_example_beer'.
  id: nid
  type:
    plugin: default_value
    default_value: article
  title: title
  field_mm_mcid: field_mm_mcid
  field_mm_url:
    plugin: iterator
    source: field_mm_url
    process:
      uri: url
      title: title
      options: attributes
  field_core_content_type_tax:
    plugin: sub_process
    source: field_core_content_type_tax

If you can't enable your migrate module due to already active configuration

Submitted by barnettech on Wed, 01/23/2019 - 17:08

This was my error message:

complinetmigration already exists in active configuration

This was the solution:

drush sqlq 'SELECT * FROM config WHERE name LIKE "%complinet%";'
drush sqlq 'DELETE FROM config WHERE name LIKE "%complinet%";'
drush sqlq 'DELETE FROM config WHERE name LIKE "%to_D8%";'

also https://www.drupal.org/project/drupal/issues/2877922

Install pip3 for python3

Submitted by barnettech on Thu, 11/08/2018 - 16:29

worked on a mac book pro on 11/08/18

# download and install setuptools
curl -O https://bootstrap.pypa.io/ez_setup.py
python3 ez_setup.py
# download and install pip
curl -O https://bootstrap.pypa.io/get-pip.py
python3 get-pip.py

To stay leveraged or not?

Submitted by barnettech on Thu, 10/11/2018 - 00:52

To stay leveraged or not? That is the question that fires up passions in so many BiggerPockets forum discussions!

Most real estate investors start with some debt (although an all-cash plan is possible, too). But eventually you’ll hit a fork in the road when you must decide how to invest excess cash flow:

Should you continue to save cash for more down payments?
Or should you begin paying off your mortgages?
As I explain in the book, a lot depends upon your personal risk preferences and how big you want to grow your portfolio.

insert into temporary table in sql server

Submitted by barnettech on Thu, 08/09/2018 - 18:33


DECLARE @result1 TABLE(subtype VARCHAR(5), total INT)

INSERT INTO @result1(subtype, total)
select DISTINCT top 2 t.subtype, t.total
from [test] t, [person] p
where (t.[record] = 'fc2765f2-ca90-48c2-a705-d2526c92d56d')
and p.[id] = t.[record]
and (t.[type] = 'SATII')
/*and (t.[rank_confirmed_subtype] = 1)*/
and (confirmed != 0 or confirmed IS NULL)
order by t.[total] desc

select total from @result1