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: text file adapter to access

text file adapter to access 4 years 7 months ago #2227

  • mark
  • mark's Avatar
  • Offline
  • New Member
  • Posts: 5
I am trying to get it work but no luck so far.
Have csv data and trying to write access.
by test run I get read 24, Fitter 24, write 1 (!)
No warnings! So it simply refuses to write file
By execute I have almost same result exept write 0 and "Syntax error in UPDATE statment"
The administrator has disabled public write access.

Re:text file adapter to access 4 years 7 months ago #2228

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
Hi Mark,

If you want UPDATE records FlowHeater updates only records how can find matches. This is the reason why READ 24, Fitter 24 and WRITE 1. In this case FlowHeater has only found one match for UPDATE on WRITE side.

I don't know why the error occurs. Please try the follows. Open the Access Configurator on the WRITE side and switch on the “Generate SQL Script” property and execute the definition in test mode again. I need the generated SQL script and the FlowHeater definition file for more analytic. ZIP these two files into one archive and post it here.

One more question. Runs the example "Menu->Examples->AccessAdapter->CSV Import" without errors?
Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
The administrator has disabled public write access.

Re:text file adapter to access 4 years 7 months ago #2229

  • mark
  • mark's Avatar
  • Offline
  • New Member
  • Posts: 5
I got rid of error if removed primary key "auto increment" but probably it is not right thing to do.
Also noticed that despite the fact that it should write all new data for now it writes only the last row from csv file, regardless number of lines or actual data in that line.

haven`t tested example csv yet. (should probably do)

Most confusing in moment is lack of any warnings.

Attachment flowheat.zip not found

Attachments:
The administrator has disabled public write access.

Re:text file adapter to access 4 years 7 months ago #2230

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
Hi Mark,

I guess you have changed some data types on the WRITE side. Please try to read in the table schema on WRITE side again.

The reason why only one record writes to the write side is the GroubBy Heater on the default layer! Remove this Heater/Functions and the definition could be work fine.

I've modified your definition. Have a look to the attachment and try it again, please.

Attachment flowheat2.zip not found

Attachments:
Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
The administrator has disabled public write access.

Re:text file adapter to access 4 years 1 month ago #2248

  • mark
  • mark's Avatar
  • Offline
  • New Member
  • Posts: 5
thanks I have it now
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.078 seconds