task

CREATE - default data set

[previously]

  1. [REFERENCE]
    1. ] # 3714 default data set - example content outline
  2. [2014-05-03, 06] > i] 13:30 pomo-14 NEW task IN PRB/SOL
    1. i] FIX-PRB-3934 - ALL user dbs have/NEED 'default data set'
    2. *] new users can use as a reference for creating their own
    3. ]
  3. [2014-05-13]> i] 09:00 - pomo-6 NEW task IN prj/DB
    1. x]  # ### - CREATE db script -v-014 FROM rev. eng SVR public
  4. [2014-12-29]
    1. ] WRITE insert records script for default data set
  5. [*]
    1. ] communities table has feilds for email,dob,telephone, ??= NEED for community?
  6. [2014-12-29] top level
    1. x] new library - my library
    2. x] new warehouse - my warehouse
    3. x] new server - my server
    4. x] new community - my community
    5. x] new calendar - my calendar
    6. x] new atlas - my atlas
  7. [2014-12-29] library books =
    1. x] life == x] diet, x] entertainment x] fitness, x] health, x] money, x] templates
  8. [2014-12-29] warehouse inventories
    1. x] life == x] diet, x] entertainment, x] fitness, x] health, x] money, x] templates
  9. [2014-12-30] server apps 
    1. x] my server apps == x] diet, x] entertainment, x] fitness, x] health, x] money, x] templates
  10. [2014-12-30] community members
    1. x] my community members == x] family, x] friends, x] clients, x] servers
    2. +] diet, ent, fitness, ...
  11. [2014-12-30] calendar plans
    1. x] my calendar plans == ] plan-period, ] plan-projects, ] document-period, ] document-project
  12. [2014-12-30] atlas maps
    1. x] my atlas maps ]
    2. ] ?? == fam, fr, cli, svr OR diet,ent,fit, ...
      1. ] cli/svr - have diet, ent, fit AS sectors ALIGNED with
    3. ] ?? ==
    4. ] country/state/city
    5. ] nations
    6. ] sospep.cs, ] register, confirm, thanks
  13. [2015-mm-dd] NEW task IN CREATE-REFERENCE - default data set (STRUCTURE)
    1. ] # 3714 - LIST-default-data-set - records to include in default data set
  14. [2015-mm-dd] NEW task TESTING
    1. ] # # - ] test with new account creation 
    2. x] added records successfully BUT only subjects,objects records were added, NO SYSTEM /PEOPLE/PLACES records were added, 
    3. x] only 2 levels library, books, warehouse, inventories 
  15. [2015-09-18] NEW task IN ANA
    1. *] REVIEW= - where is 'add data' code executing? - ( looks like may have manually pasted SQL statements into empty db after running create script ) 
    2. ] likely in db create script -- DONT see it in current create script(v-16))
    3. ] MOVE to : call import_library('library'), import_warehouse('my_warehouse')
  16. [00:00] NEW task 
    1. x] manully re paste missing data IN db (apps, members, plans, maps )
    2. x] MODIFY data - ADD subject cats( diet, ent, fit, ..., ), to people
    3. x] MODIFY data - ADD subject cats(diet,ent,fit,...) to places, 
    4. x] ADD data - L3 - chapters - add 6 example chapters, 1 for each book, TEST = pass
    5. ] REMOVE/PROMOTE templates OR  
    6. ] append 'insert statements to db-create script
    7. ] 
  17. > [00:00] NEW task IN /pln
    1. ] review existing 'data' *] found in pln/db  
    2. x] # 3714 - example 'default data set - outline and includes SQL statements, outline records dont match existing sQL statements
    3. x] # 3986 - CREATE-default data set (this) - 
  18. [00:00] NEW task  # review db inv 
    1. i] 18 - has partial default data set, ?? ] ADD bal=defaultdataset, testing SQL 
    2. x] 19 - mt, 
    3. x] 20 - mt
  19. [00:00] NEW task
    1. x] # 3714 - default data set - SQL statements updated
  20. [2015-09-19]
    1. x] # 3715 - default data set - SQL statements added(chapters, itemCategories, procedures, membergroups, taskgroups, sectors)
  21. [00:00] NEW task IN TEST 
    1. x] correction to membergroups 0 using name_group, description_group NOT name_membergroup
    2. x] db-edit - BC of existing content in taskgroups, locations, HAD to edit parent_id values to put records into the right location
  22. [00:00] NEW -default-{article} locate in template
    1. x] article, 
    2. x] item
    3. x] step
    4. x] person
    5. x] task 
    6. x] location
  23. [sospep] NEW  
    1. x] # # - CREATE create-v017 - add url field to locations table
  24. [] NEW task IN TEST article
    1. ] PRB have to set values for fields, even though db hase defaults set,, fields = author, editor, created, 
    2. ] PRB website - pulls all priority articles, 
    3. ] PRB adding new article without changing title brings down website, priority SET to max OR duplicate 'default-article' titles 
    4. ] PRB adding new article with changing title also brings down webste, 
  25. [sospep] NEW task
    1. ] PAGE add/article - edit name of priorityIn 
  26. [00:00] NEW task 
    1. *] PRB current (db) - 
    2. ] ERROR on add new record (article, item, ...) ] NO 'default-article' record 
    3. ] imported complete 'templates' library for each S, O,Y, 
    4. x] had to delete bunch of extra records

[currently]

  1. [2015-mm-dd] build the example 'content' set (dapp)
    1. ] use user.ACCOUNT dons to CREATE records THEN export TO __, THEN import  INTO __ 
    2. ] create SQL script,
    3. ] SCRIPT default data ADD
      1. ] dapp import
    4. ] SCRIPT default data REMOVE
      1. ] dapp delete   
  2. + [enviro] NEW task
    1. ] restrict 'featurette' to priority=0 and BK= 

[next]

  1. ] DECISION - choosing "example content" for the default data set
    1. ] CHOICES =
    2. ] MORE / ADD = x] politics, x] humour,] motivation, ] inspiration ] religion ]> i] 09:30 - pomo-# NEW task IN prj/DB
    3. ] db_# - EDIT table /view  ( cc PRB no results for address book, user db_#)
  2. +] UPDATE db-create-script-v-Next
    1. ] ADD - default-data set || 
  3. +] inventory update rev-###
    1. ]
  4. [00:00] STRATEGY NEXT 
    1. ] call import (default dapp), ] ?? do we have import dapp *] HAVE = import lib, import wh, ... 
    2. *] USE 6 import VS 1 import DAPP statement
    3. ] default data content records - maintained in templates dapp VS in sql statements script
    4. ] dapp = my-library, my-warehouse, my-server, my-community, my-calender, my-atlas
    5. ] HAVE = my-library - data set in templates
    6. ] MIGRATION - using existing default-data-set to build next batch of db's(21-25)
Details Photos Edit more

Details

ID: 3986

NAME: DB-CREATE-default-data-set

DESCRIPTION: default data - records to initialize a new empty sospep with, for new users getting started

START DATE TIME: 2014-04-22 13:04:14

EST DURATION: 01:00:00

END DATE TIME: 2014-04-22 14:04:14

STATUS: To-Do

PRIORITY: -5

OWNER ID: 75

Content Photos Edit more

photos

photos for this task

actions

Agenda Email task SMS task Priorities