Hi,
I'm trying to export data to Postgres.
I get the following error when running this command (note that I've editied the below to hide my passwords - was run with actual passwords inserted)
C:\Users\andre.vanzyl\Documents\PROLIFE\PROLIFE DATA\DATA EXPORTS>commcare-export --output-format sql --output postgresql://postgres:<mypassword>@http://127.0.0.1:5432/testprolife --project prolife --query commcareexports.xlsx --username <myuser> --password <mypwd>
Traceback (most recent call last):
File "C:\Users\andre.vanzyl\AppData\Local\Programs\Python\Python37\Scripts\commcare-export-script.py", line 11, in <module>
load_entry_point('commcare-export==1.0.2', 'console_scripts', 'commcare-export')()
File "C:\Users\andre.vanzyl\AppData\Local\Programs\Python\Python37\lib\site-packages\commcare_export\cli.py", line 291, in entry_point
main(sys.argv[1:])
File "C:\Users\andre.vanzyl\AppData\Local\Programs\Python\Python37\lib\site-packages\commcare_export\cli.py", line 124, in main
exit(main_with_args(args))
File "C:\Users\andre.vanzyl\AppData\Local\Programs\Python\Python37\lib\site-packages\commcare_export\cli.py", line 228, in main_with_args
writer = _get_writer(args.output_format, args.output, args.strict_types)
File "C:\Users\andre.vanzyl\AppData\Local\Programs\Python\Python37\lib\site-packages\commcare_export\cli.py", line 182, in _get_writer
return writers.SqlTableWriter(output, strict_types)
File "C:\Users\andre.vanzyl\AppData\Local\Programs\Python\Python37\lib\site-packages\commcare_export\writers.py", line 314, in __init__
super(SqlTableWriter, self).__init__(db_url, poolclass=poolclass)
File "C:\Users\andre.vanzyl\AppData\Local\Programs\Python\Python37\lib\site-packages\commcare_export\writers.py", line 261, in __init__
self.engine = sqlalchemy.create_engine(db_url, poolclass=poolclass)
File "C:\Users\andre.vanzyl\AppData\Local\Programs\Python\Python37\lib\site-packages\sqlalchemy\engine\__init__.py", line 425, in create_engine
return strategy.create(*args, **kwargs)
File "C:\Users\andre.vanzyl\AppData\Local\Programs\Python\Python37\lib\site-packages\sqlalchemy\engine\strategies.py", line 50, in create
u = url.make_url(name_or_url)
File "C:\Users\andre.vanzyl\AppData\Local\Programs\Python\Python37\lib\site-packages\sqlalchemy\engine\url.py", line 211, in make_url
return _parse_rfc1738_args(name_or_url)
File "C:\Users\andre.vanzyl\AppData\Local\Programs\Python\Python37\lib\site-packages\sqlalchemy\engine\url.py", line 267, in _parse_rfc1738_args
return URL(name, **components)
File "C:\Users\andre.vanzyl\AppData\Local\Programs\Python\Python37\lib\site-packages\sqlalchemy\engine\url.py", line 60, in __init__
self.port = int(port)
ValueError: invalid literal for int() with base 10: ''```
Can anyone help me to resolve this error?