Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Chart

V4.1.2 - Cannot create new DB in different structure

  • Keith Weatherhead
  • Topic Author
  • Offline
  • User
  • User
More
6 years 4 months ago #3439 by Keith Weatherhead
V4.1.2 - Cannot create new DB in different structure was created by Keith Weatherhead
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.

  • FlowHeater-Team
  • avatar
  • Away
  • Admin
  • Admin
More
6 years 4 months ago #3448 by FlowHeater-Team
Replied by FlowHeater-Team on topic V4.1.2 - Cannot create new DB in different structure
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 Definition 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 Definition 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.

  • Keith Weatherhead
  • Topic Author
  • Offline
  • User
  • User
More
6 years 4 months ago #3449 by Keith Weatherhead
Replied by Keith Weatherhead on topic V4.1.2 - Cannot create new DB in different structure
I was using the Folder Chooser Option (...) ....

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

  • FlowHeater-Team
  • avatar
  • Away
  • Admin
  • Admin
More
6 years 4 months ago - 1 year 1 week ago #3454 by FlowHeater-Team
Replied by FlowHeater-Team on topic V4.1.2 - Cannot create new DB in different structure
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.
Last edit: 1 year 1 week ago by FlowHeater-Team.

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

Time to create page: 0.269 seconds
FlowHeater Logo

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Legal information

Support & Contact

Contact

Phone:
0951 / 9933 9792

eMail:
This email address is being protected from spambots. You need JavaScript enabled to view it.


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