About DEG Spreadsheet

DEG Spreadsheet is a Google Spreadsheet template used for capturing structure of entities, Use DEG sample template for creation of new Google spreadsheet with same structure to generate different Drupal entities as per requirements.

Overview

This sheet is used to keep track of numbers of entities used in different sheets.

Overview

Column

Specifications

Specification

List of different entity sheets

Done

Number of entities(rows) ‘Implemented and done(x)’ as per status of column X of that sheet.

Total

Number of entities(rows) defined.

%

Percentage of entities(rows) ‘Implemented and done(x)’.

Bundles

A list of bundles of different entity types in Drupal.

Bundles

Column

Creation support

Update support

Specifications

ID

No

No

An optional identifier for references in external documents.

Name

Yes

Yes

To keep name of entity types like Article, Page etc.

Machine name

Yes

No

Unique machine name for Drupal bundles.

X

Yes

Yes

Implementation status for bundles, a = Approved and ready to implement , w = Wait to implement, x = Implemented and done, - c = Changed since implemented, d = To be deleted

Dev

No

No

Developer initials, signifying that the row has been implemented as specified.

QA

No

No

Tester initials, signifying that the row has been validated.

Description

Yes

Yes

Description about the bundles.

Example(s)

No

No

One or more relevant examples, optionally hyperlinked.

Mod.

No

No

Moderated (Content moderation is enabled), for example: y = Yes, n = No

Layout

No

No

Layout-enabled, via Core Layout Builder or via Panels, for example: y = Yes, n = No

Trns.

No

No

Translatable, for example: y = Yes, n = No

Migr.

No

No

Migrated (Content will be populated via migration)

Cmnt.

No

No

Commenting is enabled, for example: y = Yes, n = No

Meta.

No

No

Meta tags are enabled, for example: y = Yes, n = No

Sched.

No

No

Schedulable (Scheduled updates are enabled), for example: y = Yes, n = No

Type

Yes

No

Entity type, for example: Content type, Vocabulary, Paragraph type, Media type, Custom block type

URL alias pattern

Yes

No

To configure URL alias pattern.

Settings/notes

Yes

No

To configure settings/notes related to bundle, for example: ‘Image’ for media type image

Fields

A list for fields which is required for bundles.

Fields

Column

Creation support

Update support

Specifications

Bundle

Yes

No

Name of bundles like Article (Content type), Page (Content type) etc.

Field label

Yes

Yes

Field label of fields.

Machine name

Yes

No

Unique machine name for Drupal bundles, (use prefix + underscore: ‘field + underscore’ for field, for ‘group + underscore’ for group type fields)

X

Yes

Yes

Implementation status for bundles, a = Approved and ready to implement , w = Wait to implement, x = Implemented and done, - c = Changed since implemented, d = To be deleted

Dev

No

No

Developer initials, signifying that the row has been implemented as specified.

QA

No

No

Tester initials, signifying that the row has been validated.

Field group

Yes

Yes

Field group to which field comes

Field type

Yes

No

To define field type like Text (formatted, long), Text (plain) etc.

Ref. bundle

Yes

No

Reference of bundle, for example: Article categories (Vocabulary)

Req

Yes

Yes

Is field mandatory or not, for example: y = Yes, n = No

Vals.

Yes

Yes

Allowed number of values, Asterisk (*) means unlimited, for example: 1, 2, 3

Form widget

Yes

No

To define field Form widget, like Text area (multiple rows), Textfield

Trns.

No

No

Translatable, for example: y = Yes, n = No

Settings/notes

Yes

No

To configure settings/notes related to bundle, for example: ‘Image’ for media type image

Help text

Yes

Yes

Notes about the field

User roles

Defines a list of user roles in Drupal.

User roles

Column

Creation support

Update support

Specifications

ID

No

No

An optional identifier for references in external documents.

Name

Yes

Yes

To keep name of user roles like Administrators, Content Editor, Content Manager etc.

Machine name

Yes

No

Unique machine name for Drupal bundles.

X

Yes

Yes

Implementation status for bundles, a = Approved and ready to implement , w = Wait to implement, x = Implemented and done, - c = Changed since implemented, d = To be deleted

Dev

No

No

Developer initials, signifying that the row has been implemented as specified.

QA

No

No

Tester initials, signifying that the row has been validated.

Notes

No

No

Notes about the field

Workflows

Defines a list of Drupal Workflows types.

Workflows

Column

Creation support

Update support

Specifications

ID

No

No

An optional identifier for references in external documents.

Label

Yes

Yes

To keep name of Drupal workflow like Editorial, Administrator etc.

Machine name

Yes

No

Unique machine name for Drupal bundles.

X

Yes

Yes

Implementation status for bundles, a = Approved and ready to implement , w = Wait to implement, x = Implemented and done, - c = Changed since implemented, d = To be deleted

Dev

No

No

Developer initials, signifying that the row has been implemented as specified.

QA

No

No

Tester initials, signifying that the row has been validated.

Type

Yes

No

Workflow type Content Moderation

Notes

No

No

Notes on workflow

Workflow states

Defines a list of Workflow states for workflows.

Workflow states

Column

Creation support

Update support

Specifications

Workflow

Yes

No

Defines name of Workflow like Editorial, Administrator etc.

Label

Yes

Yes

To keep name of Drupal workflow state like Draft, In review, Published etc.

Machine name

Yes

No

Unique machine name for Drupal bundles.

X

Yes

Yes

Implementation status for bundles, a = Approved and ready to implement , w = Wait to implement, x = Implemented and done, - c = Changed since implemented, d = To be deleted

Dev

No

No

Developer initials, signifying that the row has been implemented as specified.

QA

No

No

Tester initials, signifying that the row has been validated.

Notes

No

No

Notes on workflow states

Workflow transitions

Defines a list of Workflow transitions.

Workflow transitions

Column

Creation support

Update support

Specifications

ID

No

No

An optional identifier for references in external documents.

Workflow

Yes

No

Name of Workflow like Editorial, Administrator etc.

Label

Yes

Yes

Name of Workflow transitions like Create New Draft, Send to review, Send to Publish etc.

Machine name

Yes

No

Unique machine name for Drupal bundles.

X

Yes

Yes

Implementation status for bundles, a = Approved and ready to implement , w = Wait to implement, x = Implemented and done, - c = Changed since implemented, d = To be deleted

From state

Yes

No

From state, example Draft, In review, Published etc.

To state

Yes

No

To state, example Draft, In review, Published etc.

Dev

No

No

Developer initials, signifying that the row has been implemented as specified.

QA

No

No

Tester initials, signifying that the row has been validated.

Notes

No

No

Notes on workflow states

Image styles

Defines a list of image styles in Drupal.

Image styles

Column

Creation support

Update support

Specifications

Style name

Yes

Yes

Name of image style name like Crop thumbnail, Thumbnail (100×100), Medium (220×220), Large (480×480) etc.

Machine name

Yes

No

Unique machine name for Drupal bundles.

X

Yes

Yes

Implementation status for bundles, a = Approved and ready to implement , w = Wait to implement, x = Implemented and done, - c = Changed since implemented, d = To be deleted

Notes

No

No

Notes on workflow states

Image effects

Defines a list of image style effects in Drupal.

Image effects

Column

Creation support

Update support

Specifications

Image style

Yes

No

Name of image style name like Crop thumbnail, Thumbnail (100×100), Medium (220×220), Large (480×480) etc.

Effect

Yes

No

Image style effects, example- Scale, Manual crop etc.

X

Yes

No

Implementation status for bundles, a = Approved and ready to implement , w = Wait to implement, x = Implemented and done, - c = Changed since implemented, d = To be deleted

Summary

Yes

No

Summary about image style effects like width, height of image, example - width 400, uses Freeform crop type, 480×480

Notes

No

No

Notes on workflow states