Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Created work_orders_signs object table #138

Closed
7 tasks done
dianamartin opened this issue Jun 12, 2019 · 5 comments
Closed
7 tasks done

Created work_orders_signs object table #138

dianamartin opened this issue Jun 12, 2019 · 5 comments
Assignees
@dianamartin
Labels
Project: Signs Migration Signs migration to Knack Service: Apps Application support Type: Data Generating and delivering datasets and reports Workgroup: DTS Data and Technology Services
Milestone
Sprint 1

Comments

@dianamartin
Copy link
Collaborator

dianamartin commented Jun 12, 2019 •
edited by johnclary

John and I decided to split signs and markings from one object table to their own

Recreate all connections
Create all connections – to new work_order _signs

  • - Accounts
  • - Signs fleet
  • - Signs materials
  • - Comments
  • - Attachments
  • - Signs spatial (new!)
  • - Signs Asset Spec (new!) - have to import this
@dianamartin dianamartin self-assigned this Jun 12, 2019
@dianamartin dianamartin added Project: Signs Migration Signs migration to Knack Service: Apps Application support Type: Data Generating and delivering datasets and reports Workgroup: DTS Data and Technology Services labels Jun 12, 2019
@dianamartin
Copy link
Collaborator Author

dianamartin commented Jun 12, 2019 •
edited

  • exported work_orders_signs_markings.csv
  • saved as .xslx, removed markings records
  • imported work_orders_signs_20190612.csv
    • Kept only records 5/1/2019 (7 records)
  • Created work_orders_signs object table

Spent some hours configuring this table

@dianamartin
Copy link
Collaborator Author

  • Need to delete test records before we deploy everything

@dianamartin
Copy link
Collaborator Author

Emailed Christina

Was wondering when you’d be able to get me those spreadsheets? I have today, tomorrow and Monday afternoon to import them in and do some testing. I’m hoping to do it by the end of the week

@johnclary johnclary added this to the Sprint 1 milestone Jun 30, 2019
@johnclary
Copy link
Member

this is all done right? closing.

@dianamartin
Copy link
Collaborator Author

we just need to delete the test records from the table.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@dianamartin dianamartin

Labels
Project: Signs Migration Signs migration to Knack Service: Apps Application support Type: Data Generating and delivering datasets and reports Workgroup: DTS Data and Technology Services
Projects
None yet
Milestone
Sprint 1
Development

No branches or pull requests
2 participants
@johnclary @dianamartin