Hello There
During a cleaning process, our work space failld process due to the reader attributes with value are 0.
we need to add a process to set the width and type of the atribute in order to avoide such issue
Solved
set writer attributes width and type
+11- Contributor
Best answer by tigerwoulds
There's a custom transformer called SchemaSetter that will allow you change the string length in your writer.
+45- Evangelist
Hi @boubcher
For the Width, you can use the transformer StringLenghCalculator by Attribute. This transformer create a new attribute to hold the results.
Thanks,
Danilo
+45- Evangelist
danilo_fme wrote:
Hi @boubcher
For the Width, you can use the transformer StringLenghCalculator by Attribute. This transformer create a new attribute to hold the results.
Thanks,
Danilo
+11- Contributor
danilo_fme wrote:
Hi @boubcher
For the Width, you can use the transformer StringLenghCalculator by Attribute. This transformer create a new attribute to hold the results.
Thanks,
Danilo
Hi @boubcher, if your requirement is to change the destination schema definition (attribute names and/or data types) for a dynamic writer feature type, you will have to derive the schema from an external dataset which has desired schema definition or a lookup table which you defined desired schema. See these links to learn more.
I cannot see any problem in the screenshot you have posted (I reposted below), and cannot understand correctly what is going on from your question. We need more specific and correct explanation on the conditions and the requirements.
(reposted)
+11- Contributor
takashi wrote:
I cannot see any problem in the screenshot you have posted (I reposted below), and cannot understand correctly what is going on from your question. We need more specific and correct explanation on the conditions and the requirements.
(reposted)
Thanks so much for your replay
we did solve the problem by open GeoDb in ARC and do all the adjustments there for now'
but we will see if this issue will be available for the next data provider
I have to get all this QC through FME
anyway thanks, we will advise
+7- Safer
@boubcher, I have just uploaded a custom transformer to the FME Hub which may solve your problem. It dynamically sets writer string attribute widths based on actual analysis of input attribute values. At the very least maybe the python code can be co-opted for your purposes.
Best,
Nathan
There's a custom transformer called SchemaSetter that will allow you change the string length in your writer.
takashi wrote:
Hi @boubcher, if your requirement is to change the destination schema definition (attribute names and/or data types) for a dynamic writer feature type, you will have to derive the schema from an external dataset which has desired schema definition or a lookup table which you defined desired schema. See these links to learn more.
Like most things in FME. The most mundane data transformations that could generally be accomplished by a few lines of SQL or R are ridiculously laborious and difficult. Unfortunately my organisation has chosen to use this software so I have to spend most of my days wading through a bewildering variety of transformers along with their associated documentation which give you little idea regarding what they are actually designed to do. I usually have to try a few out before I get anywhere near accomplishing anything like the desired result, returning again and again to this forum. This thing is like shooting cannonballs at sparrows. It sucks.
danilo_fme wrote:
Hi @boubcher
For the Width, you can use the transformer StringLenghCalculator by Attribute. This transformer create a new attribute to hold the results.
Thanks,
Danilo
That appears to work for one attribute. What if you have to change the width of them all?
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.