Dynamic data import / export

datenbank

simply more productive
Up to 100,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.
  • Page:
  • 1

TOPIC: text file adapter to access

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

  • mark
  • mark's Avatar Topic Author
  • Offline
  • New Member
  • 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"

Please Log in or Create an account to join the conversation.

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

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 275
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?

Please Log in or Create an account to join the conversation.

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.

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

  • mark
  • mark's Avatar Topic Author
  • Offline
  • New Member
  • 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:

Please Log in or Create an account to join the conversation.

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

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 275
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:

Please Log in or Create an account to join the conversation.

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.

Re:text file adapter to access 5 years 4 weeks ago #2248

  • mark
  • mark's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 5
thanks I have it now

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Moderators: FlowHeater-Team
Time to create page: 0.097 seconds