- Posts: 4
FHbatch csv to psql DB
- rajeev
- Topic Author
- Offline
- User
-
Less
More
10 years 11 months ago - 10 years 11 months ago #2332
by rajeev
FHbatch csv to psql DB was created by rajeev
Hi,
Before my question I want to thank Robert Stark for being so helpful and for this great tool.
So,
Following the tutorials and one of the forum post I generated this CMD script to run batch import to psql db. the fhd file has the login details and still the script opens up for few milliseconds and closes without any display on screen. What could be wrong? I have admin right on my WIN 7 enterprise machine. Kindly help.
@echo off
REM adapt the following to the actual path of FHBatch.exe
set FHBATCH="C:\Program Files (x86)\FlowHeater V3\BIN\FHBatch.exe"
%FHBATCH% /ReadFileName C:\temp\*.csv C:\temp\FHbatch\csv_psql_ghp1.fhd
if %ERRORLEVEL% LSS 0 goto error
echo OK
goto end
:error
echo error
:end
Before my question I want to thank Robert Stark for being so helpful and for this great tool.
So,
Following the tutorials and one of the forum post I generated this CMD script to run batch import to psql db. the fhd file has the login details and still the script opens up for few milliseconds and closes without any display on screen. What could be wrong? I have admin right on my WIN 7 enterprise machine. Kindly help.
@echo off
REM adapt the following to the actual path of FHBatch.exe
set FHBATCH="C:\Program Files (x86)\FlowHeater V3\BIN\FHBatch.exe"
%FHBATCH% /ReadFileName C:\temp\*.csv C:\temp\FHbatch\csv_psql_ghp1.fhd
if %ERRORLEVEL% LSS 0 goto error
echo OK
goto end
:error
echo error
:end
Attachments:
Last edit: 10 years 11 months ago by FlowHeater-Team.
Please Log in or Create an account to join the conversation.
- rajeev
- Topic Author
- Offline
- User
-
Less
More
- Posts: 4
10 years 11 months ago #2333
by rajeev
Replied by rajeev on topic FHbatch csv to psql DB
I think I fixed the issue, The issue was that my psql had a ID column set to not null but my source did not have that column.Once I removed that column the script is running.

Please Log in or Create an account to join the conversation.
Time to create page: 0.264 seconds