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

Report generation (WRITE Fixed Width) format problems/suggested improvements

  • Alan Frostick
  • Topic Author
  • Offline
  • User
  • User
More
3 years 9 months ago - 3 years 9 months ago #3606 by Alan Frostick
My experiment was taking data from a MySQL database on the READ side and TextFile Adapter on the WRITE side with Fixed Width in the General tab to create a report of fields in the database.
1. All widths in the TextFile Adapter are assigned a default of 10, regardless of the transcribed MySQL field sizes from "Automatically connect fields". This can be adjusted by hand and is OK for most Decimal fields, but the Date (and more so the DateTime) formats are already over 10 and that could be better.
2. All field types (including numeric Decimal, Integer) are given Text Alignment=Left. Again, these can be adjusted manually, but for numeric data types it is better Right aligned by default and Date fields are generally best Center aligned by default.
3. A new option in the Adapter is needed to pad fixed width columns with an extra space. This is especially problematic when a Left aligned String column follows a Right aligned Decimal column. It is tricky to stop the columns being adjoined, but I found a workaround with SPACE as a delimiter (under Delimiter tab, User Defined (space and space) with options checked for Only apply to String and Also use for Column Headings, but with the Option unchecked Automatically mask...in Field Content.
Last edit: 3 years 9 months ago by Alan Frostick.

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

More
3 years 9 months ago #3607 by FlowHeater-Team
Hi Alan,

Thank you very much for your suggestions. I´ll put the improvements onto our TextFile Adapter feature list. In further versions of FlowHeater we´ll try to implement this features. Thanks again.

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.

Time to create page: 0.248 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.