Import Existing Work Orders Prior to Launch

[GoogleCodeExporter]

All previously-imported work order items should be dropped prior to final 
upload.

Please import Work Orders from the Requests tab, and also all locations and 
fields from "Command Center & Shelters."

The import should occur as the last step prior to launch, as we will have to 
coordinate the workflow transfer.

Note: 
https://sandy-disaster-recovery.appspot.com/import

Internal Server Error

The server has either erred or is incapable of performing the requested 
operation.

Traceback (most recent call last):
  File "/base/python27_runtime/python27_lib/versions/third_party/webapp2-2.5.1/webapp2.py", line 1536, in __call__
    rv = self.handle_exception(request, response, e)
  File "/base/python27_runtime/python27_lib/versions/third_party/webapp2-2.5.1/webapp2.py", line 1530, in __call__
    rv = self.router.dispatch(request, response)
  File "/base/python27_runtime/python27_lib/versions/third_party/webapp2-2.5.1/webapp2.py", line 1278, in default_dispatcher
    return route.handler_adapter(request, response)
  File "/base/python27_runtime/python27_lib/versions/third_party/webapp2-2.5.1/webapp2.py", line 1102, in __call__
    return handler.dispatch()
  File "/base/python27_runtime/python27_lib/versions/third_party/webapp2-2.5.1/webapp2.py", line 572, in dispatch
    return self.handle_exception(e, self.app.debug)
  File "/base/python27_runtime/python27_lib/versions/third_party/webapp2-2.5.1/webapp2.py", line 570, in dispatch
    return method(*args, **kwargs)
  File "/base/data/home/apps/s~sandy-disaster-recovery/1.362985061765465316/base.py", line 44, in get
    self.AuthenticatedGet(org)
  File "/base/data/home/apps/s~sandy-disaster-recovery/1.362985061765465316/import_handler.py", line 41, in AuthenticatedGet
    notes = str(s))
  File "/base/python27_runtime/python27_lib/versions/1/google/appengine/ext/db/__init__.py", line 974, in __init__
    prop.__set__(self, value)
  File "/base/python27_runtime/python27_lib/versions/1/google/appengine/ext/db/__init__.py", line 614, in __set__
    value = self.validate(value)
  File "/base/python27_runtime/python27_lib/versions/1/google/appengine/ext/db/__init__.py", line 2827, in validate
    % (self.name, len(value), self.MAX_LENGTH))
BadValueError: Property notes is 4929 characters long; it must be 500 or less.

Original issue reported on code.google.com by v...@aarontitus.net on 6 Nov 2012 at 7:13

[GoogleCodeExporter]

Original comment by v...@aarontitus.net on 6 Nov 2012 at 7:43

• Added labels: Priority-High, Type-Task

[GoogleCodeExporter]

Original comment by rostovp...@gmail.com on 6 Nov 2012 at 9:42

[GoogleCodeExporter]

Original comment by rostovp...@gmail.com on 7 Nov 2012 at 12:28

• Changed state: Fixed

[GoogleCodeExporter]

I'm fixing the data right now. I discovered and fixed several errors in my 
icons and the Lat/Long that I'm fixing right now.
Were you able to import the shelters and command centers also?  I'll take a 
look in a few minutes. Scrambling to fix the data.  Some CT addresses ended up 
in NJ.

Can I send you new icons and can we try the import again a little later?
Also, I noticed that the case numbers were very high. Is there a way to start 
from 1?

Original comment by v...@aarontitus.net on 7 Nov 2012 at 12:38

[GoogleCodeExporter]

I just validated a TON of data, and I asked people to NOT add anything more.  
Would you mind doing a fresh import?

Original comment by v...@aarontitus.net on 7 Nov 2012 at 4:26

• Changed state: Started

[GoogleCodeExporter]

Done.

Original comment by rostovp...@gmail.com on 7 Nov 2012 at 4:40

• Changed state: Fixed

[GoogleCodeExporter]

One request: Could you please re-start the auto-increment?  The work order 
numbers are in the 3,000s.

Original comment by v...@aarontitus.net on 7 Nov 2012 at 5:47

[GoogleCodeExporter]

Original comment by v...@aarontitus.net on 7 Nov 2012 at 5:47

• Changed state: Started

[GoogleCodeExporter]

If we absolutely must have the smaller work IDs, we're going to have to use a 
very different process to generate them. The built-in auto-increment cannot be 
restarted.

If you need small IDs, that increment exactly once for each item inserted, 
please file a request.

I'd personally rather just change the term from "case number" to "case ID".

Original comment by rostovp...@gmail.com on 7 Nov 2012 at 6:18

[GoogleCodeExporter]

Original comment by rostovp...@gmail.com on 7 Nov 2012 at 6:18

[GoogleCodeExporter]

I'll issue a new ticket under "Human-Friendly IDs"

Original comment by v...@aarontitus.net on 7 Nov 2012 at 1:20

[GoogleCodeExporter]

Original comment by rostovp...@gmail.com on 9 Nov 2012 at 3:31

• Changed state: Fixed