Dynamic data import / export

datenbank

simply more productive
Up to 10,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.

TOPIC: FHbatch csv to psql DB

FHbatch csv to psql DB 2 years 4 months ago #2332

  • rajeev
  • rajeev's Avatar
  • Offline
  • New Member
  • Posts: 4
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


File Attachment:

File Name: csv_psql_ghp1.fhd
File Size:58 KB
Last Edit: 2 years 4 months ago by FlowHeater-Team.
The administrator has disabled public write access.

FHbatch csv to psql DB 2 years 4 months ago #2333

  • rajeev
  • rajeev's Avatar
  • Offline
  • New Member
  • Posts: 4
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. :)
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.071 seconds