<commit_before><!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org" xmlns:layout="http://www.ultraq.net.nz/thymeleaf/layout"
	  layout:decorator="layouts/main">
	<head>
		<title>Migrating</title>
		<link th:href="@{/assets/pages/admin/help/migrate.css}" rel="stylesheet"/>
	</head>
	<body>
		<div layout:fragment="content">
			<h1 id="data">Migrating Existing Data</h1>
			<p>
				If you have existing signatures, the you will want to migrate them into the new tooling.
			</p>
			<p>
				All imports are done in the form of SQL statements.
				Once  you have the data available, you can contact <a href="mailto:<EMAIL>"><EMAIL></a>
			</p>
			<p>
				Below are the steps to migrate the existing signatures data.
				<ul>
					<li><a href="#cla">Migrating Contributor License Agreements</a></li>
					<li><a href="#icla">Migrating Individual Signatures</a></li>
					<li><a href="#ccla">Migrating Corporate Signatures</a></li>
					<li><a href="#email">Emailing Users</a></li>
				</ul>
			</p>
			<h2 id="cla">Migrating Contributor License Agreements</h2>
			<p>
				The first step is to ensure that your existing Contributor License agreement is imported.
				You can find an example insert below with detailed description of each field below.
			</p>
			<pre>
insert into contributor_license_agreement (
	superseding_cla_id,
	name,
	description,
	primary_cla,
	created,
	individual_markdown,
	individual_html,
	corporate_markdown,
	corporate_html)
values (
	1,
	'greenplum',
	'Some optional description that you care to have',
	true,
	'Agreement on file.',
	'Agreement on file.',
	'Agreement on file.',
	'Agreement on file.'
);
</pre>
			<ul>
				<li>
					<span class="define">superseding_cla_id</span> - will be 1.
						This is the id of the new pivotal CLA.
						It means that if the user hasn't signed the greenplum agreement, check to see if they have signed the Pivotal one.
						If not, the Pivotal agreement is presented to the user (i.e. Pivotal CLA replaces the legacy Greenplum CLA).
				</li>
				<li><commit_msg>Fix doc migrate SQL sample<commit_after><!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org" xmlns:layout="http://www.ultraq.net.nz/thymeleaf/layout"
	  layout:decorator="layouts/main">
	<head>
		<title>Migrating</title>
		<link th:href="@{/assets/pages/admin/help/migrate.css}" rel="stylesheet"/>
	</head>
	<body>
		<div layout:fragment="content">
			<h1 id="data">Migrating Existing Data</h1>
			<p>
				If you have existing signatures, the you will want to migrate them into the new tooling.
			</p>
			<p>
				All imports are done in the form of SQL statements.
				Once  you have the data available, you can contact <a href="mailto:<EMAIL>"><EMAIL></a>
			</p>
			<p>
				Below are the steps to migrate the existing signatures data.
				<ul>
					<li><a href="#cla">Migrating Contributor License Agreements</a></li>
					<li><a href="#icla">Migrating Individual Signatures</a></li>
					<li><a href="#ccla">Migrating Corporate Signatures</a></li>
					<li><a href="#email">Emailing Users</a></li>
				</ul>
			</p>
			<h2 id="cla">Migrating Contributor License Agreements</h2>
			<p>
				The first step is to ensure that your existing Contributor License agreement is imported.
				You can find an example insert below with detailed description of each field below.
			</p>
			<pre>
insert into contributor_license_agreement (
	superseding_cla_id,
	name,
	description,
	primary_cla,
	created,
	individual_markdown,
	individual_html,
	corporate_markdown,
	corporate_html)
values (
	1,
	'greenplum',
	'Some optional description that you care to have',
	true,
	'2010-11-30',
	'Agreement on file.',
	'Agreement on file.',
	'Agreement on file.',
	'Agreement on file.'
);
</pre>
			<ul>
				<li>
					<span class="define">superseding_cla_id</span> - will be 1.
						This is the id of the new pivotal CLA.
						It means that if the user hasn't signed the greenplum agreement, check to see if they have signed the Pivotal one.
						If not, the Pivotal agreement is presented to the user (i.e. Pivotal CLA replaces the legacy Greenplum CLA).
				</li>
				<li>
{'fraction_non_alphanumeric': 0.12707317073170732, 'fraction_numerical': 0.004878048780487805, 'mean_word_length': 3.6975945017182132, 'pattern_counts': {'":': 0, '<': 105, '<?xml version=': 0, '>': 105, 'https://': 0, 'lorem ipsum': 0, 'www.': 4, 'xml': 4}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5007301', 'n_tokens_mistral': 1627, 'n_tokens_neox': 1362, 'n_words': 444}