FlowHeater - The Data Import / Export Specialist
 
Welcome, Guest
Username: Password: Remember me
See also the existing examples of using the TextFile Adapter , which may answer your question: text file codepage converting 1 / 2 , processing of CSV header and footer rows , Import/Export vCard (line based) text files
  • Page:
  • 1

TOPIC:

Report generation (WRITE Fixed Width) format problems/suggested improvements 7 months 4 weeks ago #3606

  • Alan Frostick
  • Alan Frostick's Avatar Topic Author
  • Offline
  • Posts: 1
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.

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

Last edit: by Alan Frostick.

Report generation (WRITE Fixed Width) format problems/suggested improvements 7 months 3 weeks ago #3607

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.

  • Page:
  • 1
Time to create page: 0.121 seconds

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

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

Follow us on

twitter  facebook

YouTube

 de en