span8
span4
span8
span4
Hi,
I've been given a set of 20+ MapInfo tables, of which most have a period (.) in the file names.
I need to convert these tables into MS/SQL, but this presents a problem, since periods are no-go in MS/SQL, and I need to control the schema.
I'm trying to write using a dynamic writer, but I simply cannot figure out the combination of parameters, that'll allow me to replace the periods with underscores before writing into the database.No matter what I do, I loose the connection to the "schema", and nothing gets converted.
Please help me out.This ought to be a no-brainer, but I'm stumped.
Cheers.
Create a copy of fme_feature_type (e.g."fixed_fme_feature_type") in which you replace the period with something else.
On the output feature type, specify "fixed_fme_feature_type" as the table name and set "fme_feature_type" as the schema definition name.
I solved it in a different way.
I added a reader of schemas, and did a string replacement in its "fme_feature_type" attribute.
Then I did the same string replacement in the dynamic writer, and pointed its schema input to the schema reader output instead.
That seems to work, although I end up with a small and unwanted table "schema".
I'll try your suggestion for future implementations though.Thanks.
Cheers
Dynamic excel feature writer skips first row1 Answer
How can i write data to excel and build a chart from one column into several sheets?2 Answers
PostGIS dynamic writer forces lowercase attribute (column) names1 Answer
how to update metadata in file geodatabase with multiple feature classes with feature writer2 Answers
Zeroes Dynamic Excel Writer3 Answers
© 2019 Safe Software Inc |Legal