Skip to main content
Solved

excel sheets to MYSQL

  • July 1, 2015
  • 1 reply
  • 13 views
J
Hello everyone,

 

i think i got a simple task but i seem stuck on it

 

 

i have an excel workbook with 100 sheets, with every sheet i would like to create a table in MYSQL 

 

every table has different headers and amount of headers,

 

i can read every sheet as an "indivudual feature type" and connect/dis-connect the wires from the MariaDB writer and this works,

 

but when i use a merged feature type i only get one element,

 

i am fanning out by fme_feature_type to get the correct naming of the table 

 

 

any help on working with this would be great, thanks!

Best answer by gio

You maybe want to use dynamic schema on the writer.

 

Activate Dynamic properties and set schema sources and schema definition to feature_type_name (wich is default if u use it.) Together with fan_out on featuretype_name you should get what you want.

 

 

Should also work even if you use a merged reader on the excel. (as the featuretype_name holds the sheetname)

 

 
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

gio
Contributor
Forum|alt.badge.img+15
  • gioContributor
  • Contributor
  • Best Answer
  • July 3, 2015
You maybe want to use dynamic schema on the writer.

 

Activate Dynamic properties and set schema sources and schema definition to feature_type_name (wich is default if u use it.) Together with fan_out on featuretype_name you should get what you want.

 

 

Should also work even if you use a merged reader on the excel. (as the featuretype_name holds the sheetname)

 

 

Community Stats

32,154
Posts
122,043
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.