mnBLzBRW

1ValueError at /api/v2/transactions/import/
2time data 'card' does not match format '%m/%d/%y'
3
4Request Method: POST
5Request URL: http://local-crm.webcase-dev.site/api/v2/transactions/import/
6Django Version: 1.10.3
7Python Executable: /home/local_moving/local_moving/local_moving/server/app/env/bin/python3.6
8Python Version: 3.6.7
9Python Path: ['/home/local_moving/local_moving/local_moving/server/app', '/home/local_moving/local_moving/local_moving/server/app/env/bin', '/home/local_moving/local_moving/local_moving/server/app/env/lib/python36.zip', '/home/local_moving/local_moving/local_moving/server/app/env/lib/python3.6', '/home/local_moving/local_moving/local_moving/server/app/env/lib/python3.6/lib-dynload', '/usr/lib/python3.6', '/home/local_moving/local_moving/local_moving/server/app/env/lib/python3.6/site-packages', '/home/local_moving/local_moving/local_moving/server', '/home/local_moving/local_moving/local_moving/server/app']
10Server time: Fri, 29 Mar 2019 14:19:55 +0200
11Installed Applications:
12['api',
13 'preferences',
14 'markup',
15 'accounting',
16 'staff',
17 'workflow',
18 'notifier',
19 'cloud_backup',
20 'v2.dashboard',
21 'v2.orders',
22 'v2.quotes',
23 'v2.transactions',
24 'django.contrib.admin',
25 'django.contrib.auth',
26 'django.contrib.sites',
27 'django.contrib.contenttypes',
28 'django.contrib.sessions',
29 'django.contrib.messages',
30 'django.contrib.staticfiles',
31 'trigon',
32 'trigon.contrib.reversion_',
33 'easy_thumbnails',
34 'rest_framework',
35 'rest_framework_swagger',
36 'django_jinja',
37 'django_jinja.contrib._easy_thumbnails',
38 'django_jinja.contrib._humanize',
39 'reversion',
40 'sorl.thumbnail',
41 'rosetta',
42 'notifications',
43 'django_filters',
44 'treebeard']
45Installed Middleware:
46['django.middleware.security.SecurityMiddleware',
47 'django.contrib.sessions.middleware.SessionMiddleware',
48 'django.middleware.locale.LocaleMiddleware',
49 'django.middleware.common.CommonMiddleware',
50 'django.middleware.csrf.CsrfViewMiddleware',
51 'django.contrib.auth.middleware.AuthenticationMiddleware',
52 'django.contrib.auth.middleware.SessionAuthenticationMiddleware',
53 'django.contrib.messages.middleware.MessageMiddleware',
54 'django.middleware.clickjacking.XFrameOptionsMiddleware',
55 'django.contrib.admindocs.middleware.XViewMiddleware']
56
57
58Traceback:  
59
60File "/home/local_moving/local_moving/local_moving/server/app/env/lib/python3.6/site-packages/django/core/handlers/exception.py" in inner
61  39.             response = get_response(request)
62
63File "/home/local_moving/local_moving/local_moving/server/app/env/lib/python3.6/site-packages/django/core/handlers/base.py" in _get_response
64  187.                 response = self.process_exception_by_middleware(e, request)
65
66File "/home/local_moving/local_moving/local_moving/server/app/env/lib/python3.6/site-packages/django/core/handlers/base.py" in _get_response
67  185.                 response = wrapped_callback(request, *callback_args, **callback_kwargs)
68
69File "/home/local_moving/local_moving/local_moving/server/app/env/lib/python3.6/site-packages/django/views/decorators/csrf.py" in wrapped_view
70  58.         return view_func(*args, **kwargs)
71
72File "/home/local_moving/local_moving/local_moving/server/app/env/lib/python3.6/site-packages/django/views/generic/base.py" in view
73  68.             return self.dispatch(request, *args, **kwargs)
74
75File "/home/local_moving/local_moving/local_moving/server/app/env/lib/python3.6/site-packages/rest_framework/views.py" in dispatch
76  477.             response = self.handle_exception(exc)
77
78File "/home/local_moving/local_moving/local_moving/server/app/env/lib/python3.6/site-packages/rest_framework/views.py" in handle_exception
79  437.             self.raise_uncaught_exception(exc)
80
81File "/home/local_moving/local_moving/local_moving/server/app/env/lib/python3.6/site-packages/rest_framework/views.py" in dispatch
82  474.             response = handler(request, *args, **kwargs)
83
84File "/home/local_moving/local_moving/local_moving/server/app/v2/transactions/api/views/transaction/file_import.py" in post
85  22.         TransactionCsvConverter().load(file)
86
87File "/home/local_moving/local_moving/local_moving/server/app/v2/transactions/helpers/converters/csv.py" in load
88  43.                 'performed_at': datetime.strptime(row['performed_at'], "%m/%d/%y"),
89
90File "/usr/lib/python3.6/_strptime.py" in _strptime_datetime
91  565.     tt, fraction = _strptime(data_string, format)
92
93File "/usr/lib/python3.6/_strptime.py" in _strptime
94  362.                          (data_string, format))
95
96Exception Type: ValueError at /api/v2/transactions/import/
97Exception Value: time data 'card' does not match format '%m/%d/%y'
98Request information:
99USER: admin
100
101GET: No GET data
102
103POST: No POST data
104
105FILES: No FILES data
106
107COOKIES:
108csrftoken = 'XeFVQ4QRI9IxgfDu7Iwl7AS9ffPe7efly99g47do4Tjpa3oU1b0iHYuUCwK0f0zK'
109sessionid = 'xjq4vhklvr5abv2u12eilzmv9qe8nq9h'
110
111META:
112CONTENT_LENGTH = '3082'
113CONTENT_TYPE = 'multipart/form-data; boundary=----WebKitFormBoundaryiq6ATClQHaDd9DCF'
114CSRF_COOKIE = 'XeFVQ4QRI9IxgfDu7Iwl7AS9ffPe7efly99g47do4Tjpa3oU1b0iHYuUCwK0f0zK'
115HTTP_ACCEPT = 'application/json, text/plain, */*'
116HTTP_ACCEPT_ENCODING = 'gzip, deflate, br'
117HTTP_ACCEPT_LANGUAGE = 'en'
118HTTP_CONNECTION = 'close'
119HTTP_COOKIE = 'csrftoken=XeFVQ4QRI9IxgfDu7Iwl7AS9ffPe7efly99g47do4Tjpa3oU1b0iHYuUCwK0f0zK; sessionid=xjq4vhklvr5abv2u12eilzmv9qe8nq9h'
120HTTP_HOST = 'local-crm.webcase-dev.site'
121HTTP_ORIGIN = 'https://local-crm.webcase-dev.site'
122HTTP_REFERER = 'https://local-crm.webcase-dev.site/v2/statistics/transactions/list/?offset=0&money_type=&group=&performed_at_0=03%2F01%2F2019'
123HTTP_USER_AGENT = 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.86 Safari/537.36'
124HTTP_X_CSRFTOKEN = 'XeFVQ4QRI9IxgfDu7Iwl7AS9ffPe7efly99g47do4Tjpa3oU1b0iHYuUCwK0f0zK'
125HTTP_X_FORWARDED_FOR = '185.248.130.27'
126HTTP_X_REQUESTED_WITH = 'XMLHttpRequest'
127PATH_INFO = '/api/v2/transactions/import/'
128QUERY_STRING = ''
129RAW_URI = '/api/v2/transactions/import/'
130REMOTE_ADDR = ''
131REQUEST_METHOD = 'POST'
132SCRIPT_NAME = ''
133SERVER_NAME = 'local-crm.webcase-dev.site'
134SERVER_PORT = '80'
135SERVER_PROTOCOL = 'HTTP/1.0'
136SERVER_SOFTWARE = 'gunicorn/19.9.0'
137gunicorn.socket = <gevent._socket3.socket object, fd=14, family=1, type=2049, proto=0>
138wsgi.errors = <gunicorn.http.wsgi.WSGIErrorsWrapper object at 0x7fae8ff4fd68>
139wsgi.file_wrapper = ''
140wsgi.input = <gunicorn.http.body.Body object at 0x7fae8ff747f0>
141wsgi.multiprocess = True
142wsgi.multithread = True
143wsgi.run_once = False
144wsgi.url_scheme = 'http'
145wsgi.version = 
146
147Settings:
148Using settings module app.settings
149ABSOLUTE_URL_OVERRIDES = {}
150ADMINS = []
151ALLOWED_HOSTS = ['104.248.226.3', 'local-crm.webcase-dev.site']
152APPEND_SLASH = True
153AUTHENTICATION_BACKENDS = 
154AUTH_PASSWORD_VALIDATORS = '********************'
155AUTH_USER_MODEL = 'auth.User'
156BASE_DIR = '/home/local_moving/local_moving/local_moving/server/app/app'
157BROKER_URL = 'redis://localhost:6379/0'
158CACHES = {'default': {'BACKEND': 'django_redis.cache.RedisCache', 'LOCATION': 'redis://127.0.0.1:6379/1', 'TIMEOUT': 600, 'OPTIONS': {'CLIENT_CLASS': 'django_redis.client.DefaultClient', 'IGNORE_EXCEPTIONS': True, 'CONNECTION_POOL_KWARGS': {'max_connections': 100}, 'MAX_ENTRIES': 100000}, 'KEY_PREFIX': '********************'}}
159CACHE_MIDDLEWARE_ALIAS = 'default'
160CACHE_MIDDLEWARE_KEY_PREFIX = '********************'
161CACHE_MIDDLEWARE_SECONDS = 600
162CELERY_ACCEPT_CONTENT = ['json']
163CELERY_RESULT_SERIALIZER = 'json'
164CELERY_TASK_SERIALIZER = 'json'
165CSRF_COOKIE_AGE = 31449600
166CSRF_COOKIE_DOMAIN = None
167CSRF_COOKIE_HTTPONLY = False
168CSRF_COOKIE_NAME = 'csrftoken'
169CSRF_COOKIE_PATH = '/'
170CSRF_COOKIE_SECURE = False
171CSRF_FAILURE_VIEW = 'django.views.csrf.csrf_failure'
172CSRF_HEADER_NAME = 'HTTP_X_CSRFTOKEN'
173CSRF_TRUSTED_ORIGINS = []
174DATABASES = {'default': {'ENGINE': 'django.db.backends.postgresql_psycopg2', 'NAME': 'local_moving_db', 'USER': 'local_moving_db', 'PASSWORD': '********************', 'HOST': 'localhost', 'PORT': '', 'CONN_MAX_AGE': 60, 'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'OPTIONS': {}, 'TIME_ZONE': None, 'TEST': {'CHARSET': None, 'COLLATION': None, 'NAME': None, 'MIRROR': None}}}
175DATABASE_ROUTERS = []
176DATA_UPLOAD_MAX_MEMORY_SIZE = 2621440
177DATA_UPLOAD_MAX_NUMBER_FIELDS = 1000
178DATETIME_FORMAT = '%m/%d/%Y %H:%M:%S'
179DATETIME_INPUT_FORMATS = ['%m/%d/%Y %H:%M:%S', '%m/%d/%Y %I:%M:%S %p']
180DATE_FORMAT = '%m/%d/%Y'
181DATE_INPUT_FORMATS = ['%m/%d/%Y', '%m/%d/%y']
182DEBUG = True
183DEBUG_PROPAGATE_EXCEPTIONS = False
184DECIMAL_SEPARATOR = '.'
185DEFAULT_CHARSET = 'utf-8'
186DEFAULT_CONTENT_TYPE = 'text/html'
187DEFAULT_EXCEPTION_REPORTER_FILTER = 'django.views.debug.SafeExceptionReporterFilter'
188DEFAULT_EXTENSIONS = ['jinja2.ext.do', 'jinja2.ext.loopcontrols', 'jinja2.ext.with_', 'jinja2.ext.i18n', 'jinja2.ext.autoescape', 'django_jinja.builtins.extensions.CsrfExtension', 'django_jinja.builtins.extensions.CacheExtension', 'django_jinja.builtins.extensions.TimezoneExtension', 'django_jinja.builtins.extensions.UrlsExtension', 'django_jinja.builtins.extensions.StaticFilesExtension', 'django_jinja.builtins.extensions.DjangoFiltersExtension']
189DEFAULT_FILE_STORAGE = 'django.core.files.storage.FileSystemStorage'
190DEFAULT_FROM_EMAIL = 'admin@admin.admin'
191DEFAULT_INDEX_TABLESPACE = ''
192DEFAULT_TABLESPACE = ''
193DISALLOWED_USER_AGENTS = []
194EMAIL_BACKEND = 'django.core.mail.backends.smtp.EmailBackend'
195EMAIL_HOST = 'smtp.gmail.com'
196EMAIL_HOST_PASSWORD = '********************'
197EMAIL_HOST_USER = 'mail_user'
198EMAIL_PORT = 587
199EMAIL_SSL_CERTFILE = None
200EMAIL_SSL_KEYFILE = '********************'
201EMAIL_SUBJECT_PREFIX = '[Django] '
202EMAIL_TIMEOUT = None
203EMAIL_USE_SSL = False
204EMAIL_USE_TLS = True
205FILE_CHARSET = 'utf-8'
206FILE_UPLOAD_DIRECTORY_PERMISSIONS = None
207FILE_UPLOAD_HANDLERS = ['django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler']
208FILE_UPLOAD_MAX_MEMORY_SIZE = 2621440
209FILE_UPLOAD_PERMISSIONS = None
210FILE_UPLOAD_TEMP_DIR = None
211FIRST_DAY_OF_WEEK = 0
212FIXTURE_DIRS = []
213FORCE_SCRIPT_NAME = None
214FORMAT_MODULE_PATH = None
215GOOGLE_MAPS_API_KEY = '********************'
216IFRAME_TEST_MODE = True
217IGNORABLE_404_URLS = []
218INSTALLED_APPS = ['api', 'preferences', 'markup', 'accounting', 'staff', 'workflow', 'notifier', 'cloud_backup', 'v2.dashboard', 'v2.orders', 'v2.quotes', 'v2.transactions', 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.sites', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'trigon', 'trigon.contrib.reversion_', 'easy_thumbnails', 'rest_framework', 'rest_framework_swagger', 'django_jinja', 'django_jinja.contrib._easy_thumbnails', 'django_jinja.contrib._humanize', 'reversion', 'sorl.thumbnail', 'rosetta', 'notifications', 'django_filters', 'treebeard']
219INTERNAL_IPS = []
220LANGUAGES = [('en', <django.utils.functional.lazy.<locals>.__proxy__ object at 0x7fae9adb7048>)]
221LANGUAGES_BIDI = ['he', 'ar', 'fa', 'ur']
222LANGUAGE_CODE = 'en'
223LANGUAGE_COOKIE_AGE = None
224LANGUAGE_COOKIE_DOMAIN = None
225LANGUAGE_COOKIE_NAME = 'django_language'
226LANGUAGE_COOKIE_PATH = '/'
227LOCALE_PATHS = ['/home/local_moving/local_moving/local_moving/server/app/app/app/locale']
228LOGGING = {'version': 1, 'disable_existing_loggers': False, 'handlers': {'console': {'level': 'DEBUG', 'class': 'logging.StreamHandler'}, 'logfile': {'level': 'DEBUG', 'class': 'logging.FileHandler', 'filename': '/home/local_moving/local_moving/local_moving/server/app/app/../logfile.log'}}, 'root': {'level': 'INFO', 'handlers': ['console', 'logfile']}}
229LOGGING_CONFIG = 'logging.config.dictConfig'
230LOGIN_REDIRECT_URL = '/'
231LOGIN_URL = '/auth/login/'
232LOGOUT_REDIRECT_URL = None
233MANAGERS = []
234MEDIA_ROOT = '/home/local_moving/local_moving/local_moving/server/app/app/uploads'
235MEDIA_URL = '/uploads/'
236MESSAGE_STORAGE = 'django.contrib.messages.storage.fallback.FallbackStorage'
237MIDDLEWARE = ['django.middleware.security.SecurityMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.locale.LocaleMiddleware', 'django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.auth.middleware.SessionAuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware', 'django.contrib.admindocs.middleware.XViewMiddleware']
238MIDDLEWARE_CLASSES = ['django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware']
239MIGRATION_MODULES = {}
240MONTH_DAY_FORMAT = 'F j'
241NUMBER_GROUPING = 0
242PASSWORD_HASHERS = '********************'
243PASSWORD_RESET_TIMEOUT_DAYS = '********************'
244PREFERENCES_DEFAULT = 'global'
245PREPEND_WWW = False
246PROJECT_APPS = ['api', 'preferences', 'markup', 'accounting', 'staff', 'workflow', 'notifier', 'cloud_backup', 'v2.dashboard', 'v2.orders', 'v2.quotes', 'v2.transactions']
247RECAPTCHA_PRIVATE_KEY = '********************'
248REST_FRAMEWORK = {'DEFAULT_PERMISSION_CLASSES': ('rest_framework.permissions.IsAuthenticated',), 'DEFAULT_AUTHENTICATION_CLASSES': ('rest_framework.authentication.SessionAuthentication',)}
249ROOT_URLCONF = 'app.urls'
250ROSETTA_CACHE_NAME = 'default'
251ROSETTA_ENABLE_TRANSLATION_SUGGESTIONS = True
252ROSETTA_STORAGE_CLASS = 'rosetta.storage.CacheRosettaStorage'
253SECRET_KEY = '********************'
254SECURE_BROWSER_XSS_FILTER = False
255SECURE_CONTENT_TYPE_NOSNIFF = False
256SECURE_HSTS_INCLUDE_SUBDOMAINS = False
257SECURE_HSTS_SECONDS = 0
258SECURE_PROXY_SSL_HEADER = None
259SECURE_REDIRECT_EXEMPT = []
260SECURE_SSL_HOST = None
261SECURE_SSL_REDIRECT = False
262SERVER_EMAIL = 'root@localhost'
263SESSION_CACHE_ALIAS = 'default'
264SESSION_COOKIE_AGE = 43200
265SESSION_COOKIE_DOMAIN = None
266SESSION_COOKIE_HTTPONLY = True
267SESSION_COOKIE_NAME = 'sessionid'
268SESSION_COOKIE_PATH = '/'
269SESSION_COOKIE_SECURE = False
270SESSION_ENGINE = 'django.contrib.sessions.backends.cache'
271SESSION_EXPIRE_AT_BROWSER_CLOSE = False
272SESSION_FILE_PATH = None
273SESSION_SAVE_EVERY_REQUEST = True
274SESSION_SERIALIZER = 'django.contrib.sessions.serializers.JSONSerializer'
275SETTINGS_MODULE = 'app.settings'
276SHORT_DATETIME_FORMAT = 'm/d/Y P'
277SHORT_DATE_FORMAT = 'm/d/Y'
278SIGNING_BACKEND = 'django.core.signing.TimestampSigner'
279SILENCED_SYSTEM_CHECKS = []
280SITE_ID = 1
281STATICFILES_DIRS = []
282STATICFILES_FINDERS = ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder']
283STATICFILES_STORAGE = 'django.contrib.staticfiles.storage.StaticFilesStorage'
284STATIC_ROOT = '/home/local_moving/local_moving/local_moving/server/app/app/static'
285STATIC_URL = '/static/'
286TEMPLATES = [{'BACKEND': 'trigon.core.backends.jinja2.Jinja2', 'NAME': 'django_jinja2', 'APP_DIRS': True, 'DIRS': [], 'OPTIONS': {'environment': 'trigon.core.env.jinja2.environment', 'match_extension': '.jinja', 'newstyle_gettext': True, 'auto_reload': True, 'undefined': <class 'jinja2.runtime.Undefined'>, 'debug': True, 'filters': {}, 'globals': {}, 'context_processors': ['django.contrib.auth.context_processors.auth', 'django.template.context_processors.debug', 'django.template.context_processors.i18n', 'django.template.context_processors.media', 'django.template.context_processors.static', 'django.template.context_processors.tz', 'django.contrib.messages.context_processors.messages'], 'extensions': ['jinja2.ext.do', 'jinja2.ext.loopcontrols', 'jinja2.ext.with_', 'jinja2.ext.i18n', 'jinja2.ext.autoescape', 'django_jinja.builtins.extensions.CsrfExtension', 'django_jinja.builtins.extensions.UrlsExtension', 'django_jinja.builtins.extensions.CacheExtension', 'django_jinja.builtins.extensions.StaticFilesExtension', 'django_jinja.builtins.extensions.TimezoneExtension'], 'bytecode_cache': {'name': 'default', 'backend': 'django_jinja.cache.BytecodeCache', 'enabled': True}}}, {'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': [], 'APP_DIRS': True, 'OPTIONS': {'context_processors': ['django.template.context_processors.media', 'django.template.context_processors.static', 'django.template.context_processors.debug', 'django.template.context_processors.request', 'django.contrib.messages.context_processors.messages', 'django.contrib.auth.context_processors.auth']}}]
287TEST_NON_SERIALIZED_APPS = []
288TEST_RUNNER = 'django.test.runner.DiscoverRunner'
289THOUSAND_SEPARATOR = ','
290THUMBNAIL_PROCESSORS = 
291TIME_FORMAT = '%H:%M:%S'
292TIME_INPUT_FORMATS = ['%H:%M:%S', '%H:%M:%S.%f', '%H:%M', '%I:%M:%S %p', '%I:%M:%S.%f %p', '%I:%M %p']
293TIME_ZONE = 'Europe/Kiev'
294USE_ETAGS = False
295USE_I18N = True
296USE_L10N = True
297USE_THOUSAND_SEPARATOR = False
298USE_TZ = False
299USE_X_FORWARDED_HOST = False
300USE_X_FORWARDED_PORT = False
301WSGI_APPLICATION = 'app.wsgi.application'
302X_FRAME_OPTIONS = 'SAMEORIGIN'
303YEAR_MONTH_FORMAT = 'F Y'
304
305
306You're seeing this error because you have DEBUG = True in your
307Django settings file. Change that to False, and Django will
308display a standard page generated by the handler for this status code.