Dynamic data import / export

datenbank

simply more productive
Up to 10,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.

TOPIC: From Excel to Excel Adapter

From Excel to Excel Adapter 3 years 9 months ago #2263

  • Herbert Berkley
  • Herbert Berkley's Avatar
  • Offline
  • New Member
  • Posts: 15
I need to take a spreadsheet that organizes data by row format and have it create a single spreadsheet from one field, the work order, and all the associated fields and append into column b of a spreadsheet. Then to the next row to column, and next row to column and so forth until the process is finished. It would be creating unique xls files based on the workorder number.

I have included the source file from which the row data should be placed into column b during the append process.

Thanks,

Herb
The administrator has disabled public write access.

Re:From Excel to Excel Adapter 3 years 9 months ago #2264

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 239
Hi Herbert,

I'm afraid this feature currently works only with the TextFile Adapter. Soon I’ll adapt this feature also into the Excel Adapter.

By now you can use FlowHeater Parameters instead of a real file name just for the TextFile Adapter. I've made a little example to demonstrate this.

In the example an Excel spreadsheet are read and per each "Work Order" one CSV file are written. The CSV file names are dynamical build with the help of the Set Parameter Heater.

Attachment split_excel_data.zip not found

Attachments:
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.
The administrator has disabled public write access.

Re:From Excel to Excel Adapter 3 years 9 months ago #2265

  • Herbert Berkley
  • Herbert Berkley's Avatar
  • Offline
  • New Member
  • Posts: 15
This is great.. When it creates the files I'd like to have each field populate vertically rather than horizontally..

I have included a sample file.. Also the final destination format that the text needs to render into.


Thanks!

Attachment WorkOrder.txt not found

Attachments:
The administrator has disabled public write access.

Re:From Excel to Excel Adapter 3 years 9 months ago #2266

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 239
Hi Herbert,

Sorry I don’t understand your sample file? NOTE: If you want add more files you have to use a ZIP archive.

I guess what you want and made a new example. To do this you need a second step.

The first steps groups the data with the help of the GroupBy Heater based on the work order. A bit tricky is to put each group row from the READ side to one specific column on the WRITE side. For this you need for each column one IF-THEN-ELSE Heater to decide what row is the current group row. To count the group row you need an additional AutoID Heater with activated GroupBy option.

The second step is just the same as the first example. Read the CSV file where created in the first step and create the unique CSV files based on the work order.

Attachment group_and_split_excel_data.zip not found

Attachments:
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.
The administrator has disabled public write access.

Re:From Excel to Excel Adapter 3 years 9 months ago #2269

  • Herbert Berkley
  • Herbert Berkley's Avatar
  • Offline
  • New Member
  • Posts: 15
Great.. I think something in my setup is incorrect.. It seems to be stuffing a lot of data that should be on a new line into LINE 1 on the initial output file.

Check it out..

Thanks for all your help!!

Herb
The administrator has disabled public write access.

Re:From Excel to Excel Adapter 3 years 9 months ago #2270

  • Herbert Berkley
  • Herbert Berkley's Avatar
  • Offline
  • New Member
  • Posts: 15
Maybe I can add the other file in another post..
The administrator has disabled public write access.

Re:From Excel to Excel Adapter 3 years 9 months ago #2271

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 239
Hi Herbert,

There are no attachments available?
You could also send the attachments via email to support [-at-] flowheater.net.
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.
The administrator has disabled public write access.

Re:From Excel to Excel Adapter 3 years 9 months ago #2272

  • Herbert Berkley
  • Herbert Berkley's Avatar
  • Offline
  • New Member
  • Posts: 15
Thanks.. I think my file size exceeded your limitations.. I will email them.

Thanks,

Herb
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.086 seconds