FlowHeater - The Data Import / Export Specialist
See also the existing examples of using the Access Adapter , which may answer your question: CSV import , generate test data , automated batch CSV import

text file adapter to access

More
10 years 9 months ago #2227 by mark
text file adapter to access was created by mark
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.

More
10 years 9 months ago #2228 by FlowHeater-Team
Replied by FlowHeater-Team on topic Re:text file adapter to access
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.

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

More
10 years 9 months ago #2229 by mark
Replied by mark on topic Re:text file adapter to access
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.

More
10 years 9 months ago #2230 by FlowHeater-Team
Replied by FlowHeater-Team on topic Re:text file adapter to access
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


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.
Attachments:

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

More
10 years 3 months ago #2248 by mark
Replied by mark on topic Re:text file adapter to access
thanks I have it now

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

Time to create page: 0.292 seconds

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

Copyright © 2009-2023 by FlowHeater GmbH.
All rights reserved.

Follow us on

twitter  facebook

YouTube

 de en