FlowHeater Demo Video
 
FlowHeater - The Data Import / Export Specialist
 
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: V4.1.2 - Cannot create new DB in different structure

V4.1.2 - Cannot create new DB in different structure 4 months 2 days ago #3439

  • Keith Weatherhead
  • Keith Weatherhead's Avatar Topic Author
  • Offline
  • Posts: 16
Greetings,

I have the 32bit version installed and am having some issues... I am reading from a folder on my D: drive that contains a series of DBF files.
This works fine as I can access them with no issues. I wanted to write out a new SQLite file in a parallel folder to where the DBF files exist.
However it seems that I can only generate a file in the C:\Program Files (x86)\FlowHeater v4\Examples\EN folder structure. They initially were
appearing in the HelloWorld folder (found my O/P fie after searching a bit) and I created a folder parallel to the HelloWorld folder and the O/P
will create there BUT NOT to the the folder I desired on my D: drive. This is a local partition as I have a 1TB SSD partitioned into C; & D: drives
on my local machine. Any ideas? I used the WriteAdapterConfiguration/General tab... using the chooser option (...) to the right of the DataBase
field. Is there a problem with the SQLite Adapter for Write Operations?

Keith

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

V4.1.2 - Cannot create new DB in different structure 4 months 2 days ago #3448

Hi Keith,

In case you just entered a SQLite database name without a path the database will be created in the folder where the FlowHeater Definition are located.

If you specified a realtive path (e.g. “..\database\sqlite.db”) to your SQLite database the path are always relativ form the current Defintion location you´re running.

If this not working please try to use a absolute path (e.g. “D:\database\sqlite.db”) for the database name in the SQLite Adapter Configurator.

I´ve made a few basic tests and it always creating the database in the expected folder. If this not solve your issue please post your created FlowHeater Defintion for more analytics.

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.

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.

V4.1.2 - Cannot create new DB in different structure 4 months 1 day ago #3449

  • Keith Weatherhead
  • Keith Weatherhead's Avatar Topic Author
  • Offline
  • Posts: 16
I was using the Folder Chooser Option (...) ....

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

V4.1.2 - Cannot create new DB in different structure 4 months 1 day ago #3454

Hi Keith,

Your screenshots from your other post here ( Example OF Issue Accessing File ) shows me that the problem is related to the OleDB Adapter and the using of dBase IV database tables and not to create a new SQLite database.

Ok, now I´ve made e few more test with using a dBase IV database table for exporting data. All my test has been completed successfully without an error message.

Attached you´ll find my simple test defintion including a small dBase IV database. Please extract this and make the three below descripted tests.
  1. Execute the Definition as it is.
  2. Move the 3 dBase IV table files to another location on dirve C:\ and modifiy the OleDB datasource on the read side to the new location and execute the Definition again.
  3. The same as 2) but you should use drive D:\ for the dBase IV files.

What are the results on your side?

Note: Please answer on this thread to post your results, Thanks.

File Attachment:

File Name: dbase-to-sqlite.zip
File Size:3 KB

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.

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.
  • Page:
  • 1

other Languages

en
GB | US

de
DE | AT | CH

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

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

Follow us on

twitter  facebook

YouTube

 de en