Skip to main content
Solved

excel sheets to MYSQL

  • July 1, 2015
  • 1 reply
  • 6 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)

 

 
View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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)

 

 

Helpful Members This Week

Community Stats

30,921
Posts
117,181
Replies
38,725
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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.