Skip to main content
Released

Set Data Type option within the AttributeManager

Related products:FME Form
giapan85
quince
mohamad22
+207
  • giapan85
    giapan85
  • quince
    quince
  • mjahn
  • mnikosz
  • mohamad22
    mohamad22
  • emadera
  • rlundstrum
    rlundstrum
  • jnorriskit
    jnorriskit
  • nampreetatsafe
    nampreetatsafe
  • siennaatsafe
    siennaatsafe
  • hkingsbury
    hkingsbury
  • danilo_fme
    danilo_fme
  • caracadrian
    caracadrian
  • erik_jan
    erik_jan
  • jamal
    jamal
  • sigtill
    sigtill
  • asadamjad
  • warrendev
    warrendev
  • tcrossman
    tcrossman
  • vxn43
    vxn43
  • thijsknapen
    thijsknapen
  • jkr_wrk
    jkr_wrk
  • j.botterill
    j.botterill
  • bwn
    bwn
  • carmijo
    carmijo
  • oscard
    oscard
  • tomf
    tomf
  • runneals
    runneals
  • stalknecht
    stalknecht
  • bruceharold
    bruceharold
  • connecter
    connecter
  • mathiku
    mathiku
  • lorenrouth
    lorenrouth
  • nic_ran
    nic_ran
  • jelle
    jelle
  • arnovananrooij
    arnovananrooij
  • kennyo
    kennyo
  • chriswilson
    chriswilson
  • philippeb
    philippeb
  • wisegis
    wisegis
  • jackyd
    jackyd
  • canerakin
    canerakin
  • arthur_bazin
    arthur_bazin
  • cory
    cory
  • milo89
    milo89
  • lazarlubomir
    lazarlubomir
  • srg
    srg
  • lambertus
    lambertus
  • stefanh
    stefanh
  • courtney_m
    courtney_m
  • matthieuv
    matthieuv
  • bibold
  • koenterralytics
    koenterralytics
  • revesz
    revesz
  • richsnyder0
  • jpsalva
    jpsalva
  • cuckovic2206
  • drimbles
    drimbles
  • lanthar
    lanthar
  • bwill
  • rottens
  • vanhornsky
  • pi_hellz
    pi_hellz
  • vejaspink
    vejaspink
  • michael.prior
  • prmorrison
  • kgt_lena
  • northswejohan
  • ronk
    ronk
  • jesidas
  • huotari
    huotari
  • sheree
    sheree
  • ewoudvdc
    ewoudvdc
  • anna_w
  • jmoura
  • ml56067
    ml56067
  • supaustin
    supaustin
  • nathanherzog
    nathanherzog
  • kahlen
    kahlen
  • osmanbeg1980
    osmanbeg1980
  • fchevaillier
    fchevaillier
  • dmatranga
  • erooen
    erooen
  • hodelc
  • lindsay
    lindsay
  • momu
  • mholemans
    mholemans
  • travg
    travg
  • mdohm
    mdohm
  • geolassi
    geolassi
  • laydihacks
    laydihacks
  • littlefictions
    littlefictions
  • maryse_bucking
    maryse_bucking
  • gis_queen
    gis_queen
  • nixynoodle
    nixynoodle
  • mikev
    mikev
  • emeka_domingo
    emeka_domingo
  • nickyaclift
  • cwarren
    cwarren
  • paulbrandt73
  • simonl
    simonl
  • mwoj
    mwoj
  • woody
  • mikek
  • geoleo
    geoleo
  • lottegis
    lottegis
  • hsamor
    hsamor
  • cdeblonde
  • cwinfield
    cwinfield
  • mvanwie
    mvanwie
  • ziur
    ziur
  • balthasar
  • steinm
    steinm
  • mbz
    mbz
  • wizdatawizard
    wizdatawizard
  • robclark984
  • jvanravenswaaij
    jvanravenswaaij
  • tiler
    tiler
  • ec2020uk
  • geobroetchen
    geobroetchen
  • jobrien77
    jobrien77
  • pat_uow
    pat_uow
  • daniel.egger
    daniel.egger
  • gagankc
  • camtemple
    camtemple
  • rzickuhr
    rzickuhr
  • karc147
    karc147
  • mondeveloper
  • majid9
    majid9
  • mattia.deago
    mattia.deago
  • arturnowicki
  • eberkel
  • maayke
    maayke
  • ekkischeffler
    ekkischeffler
  • mmccart
    mmccart
  • lily
    lily
  • magi
    magi
  • paalpedersen
    paalpedersen
  • johnt
    johnt
  • marnickcle
    marnickcle
  • germang
    germang
  • danielkroon
    danielkroon
  • mferber
    mferber
  • cfvonner
    cfvonner
  • krien
    krien
  • michaelbreen
    michaelbreen
  • ngstoke
    ngstoke
  • clickingbuttons
  • neilhellas
  • dannymatranga
    dannymatranga
  • tara_he
    tara_he
  • jeroen
    jeroen
  • ronnie.utter
    ronnie.utter
  • mtaftferguson
    mtaftferguson
  • anari
    anari
  • gboquin
    gboquin
  • lorinda
    lorinda
  • bobw
    bobw
  • kim
  • joshuadamron
    joshuadamron
  • tim.rastall1
    tim.rastall1
  • bmdull
  • geoportalcartog
    geoportalcartog
  • ian_1spatial
    ian_1spatial
  • geoal
    geoal
  • tiztrain
    tiztrain
  • dellerbeck
    dellerbeck
  • thejando
    thejando
  • mariofederis
  • ileung_cnw
    ileung_cnw
  • mb_fdfa
    mb_fdfa
  • wicki
    wicki
  • mickael
    mickael
  • brianapeters
  • rudacsmap
    rudacsmap
  • kino
  • jmiddel
    jmiddel
  • joshb
  • tim.albert.vaa
    tim.albert.vaa
  • katrinaopperman
  • g_karssenberg
    g_karssenberg
  • _fabian_
    _fabian_
  • hrvoje
    hrvoje
  • jeand
    jeand
  • phoeffler
    phoeffler
  • joeri
    joeri
  • erlendraheim
  • brettjohnston
    brettjohnston
  • annie.barclay
  • kasiponnapalli
    kasiponnapalli
  • gisbradokla_t
  • jecollins
  • perfro
  • pragan
  • jac
  • susmar
    susmar
  • steven.bowden
  • oliverquirke
    oliverquirke
  • arielwin
  • gis_jo_1985
  • groschialeux
  • cdesisto
  • samuelvaldez
  • allasimon
    allasimon
  • michaeldawson
  • annalouii
  • momahmoud
  • johang68
  • haol
  • twermager
  • ogma
  • DanAtSafe
    DanAtSafe

courtney_m
Contributor

It would be helpful if a "Data Type" column was added to the AttributeManager, so we could view/change/set the data type of each attribute. Another option would be to allow the data type to be set manually when a new attribute is created.

I know it is possible to set the data types on the writer feature type, but I think this would be especially helpful when creating a new attribute. Additionally, if I am copying an existing AttributeManager (within the same workspace, or into a different one) it would be nice if I could set the data type for an attribute once, and that would be preserved when the transformer is copied - That way I wouldn't have to manually change the data type on every output feature type.

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.

17 replies

It would be so helpful to have this within the AttributeManager, instead of having to do this on every writer feature type (consider that there are many in there...). Besides, the transformer should preserve the input attribute field type and length alongside having the capability to define them for created fields.

Then, FME WB would become my favourite tool for remodelling ESRI GDB schemas. Right now, I'm going back to editing Workspace XML.


erooen
Contributor
Forum|alt.badge.img+1
  • Contributor
  • February 22, 2019

I agree with the previous poster. FME is reading the native data type format for the attributes populated from the reader so it should have no problem available in the AttributeManager.

Being able to define data type in the transformer is a better and more stable place to define the schema than at the writer stage. I often have workflows where there are multiple writers needed for various outputs.


bleutzinn

Just wanted to point out that this is possible within an AttributeManager. Just use the Math functions in the "Attribute Value" field.

For example use:

@double(@Value(temperature))

to set the data type to a double (64 bit real).


Forum|alt.badge.img

also being able to define domain/subtype on geodatabase attribute manager fields


mb_fdfa
Participant
Forum|alt.badge.img+7
  • Participant
  • July 22, 2020

This would be a major help as it is one of those things I seem to have to do almost in every workspace, often for multiple feature types.


fmelizard
Safer
Forum|alt.badge.img+19
  • Safer
  • July 24, 2020

We've put in the foundation to do this, thanks for keeping it front of mind. Agree that it will be very useful.


lily
Contributor
Forum|alt.badge.img+9
  • Contributor
  • November 29, 2020

Transformers creates additional attributes to my table. If I want these additional attributes in my writer, I see no option of copying attributes from transformer. I see only copy attributes from reader and others which I do not understand like manually, etc. Instead, I need to type each new attribute into the writer, set the data type (which I am not sure about) and drag in the attribute from the transformer to the writer. Is there any easy and safe way so I do not assign the wrong data type?


jamal
Forum|alt.badge.img+5
  • March 8, 2022

Sure. We need this option

for example, in Pro, when creating a field, we can specify its type

 

 

Clip_186


jamal
Forum|alt.badge.img+5
  • March 8, 2022

i tried the suggestion proposed by bleutzinn but appears not to work with me.

what could be the issue here?

 

Clip_188 

 

Clip_189 

 

 


runneals
Contributor
Forum|alt.badge.img+22
  • Contributor
  • January 30, 2023

Or better then this, have FME automatically change the type to the correct type (ie. if there's only numbers, then the output should be an integer or double depending on if there's a decimal or not, otherwise make it a varchar)...


fmelizard
Safer
Forum|alt.badge.img+19
  • Safer
  • March 30, 2023

This is in the latest 2023 betas (which will go live on or after April 13 2023) and I can advise that the AttributeManager now has an "Import->Data Types From Feature Cache" which will do a best fit data type scan with the outcome you describe above. It is a thing of beauty if I say so myself.


fmelizard
Safer
Forum|alt.badge.img+19
  • Safer
  • March 30, 2023

The way to get what you want is to set your writer feature type to "automatic" mode for the schema. Then the attributes that were added in transformers are just there. And if you use the all-new FME 2023 beta AttributeManager, you can ensure their types are what you want them to be.


fmelizard
Safer
Forum|alt.badge.img+19
  • Safer
  • March 30, 2023

Sadly that just affected the internal FME "transport" type, which is how we ferry the data from source to destination. It didn't actually affect how the output format would save the data. This is now made explicit in the FME 2023 AttributeManager.


fmelizard
Safer
Forum|alt.badge.img+19
  • Safer
  • March 30, 2023

Deeply agree.


Its only chages github, wiki codes to xlm, 64bse code…


LizAtSafe
Safer
Forum|alt.badge.img+15
  • Safer
  • June 21, 2023

We've updated our AttributeManager how-to article to utilize this new functionality in FME 2023.0! Check out Control Your Data's Attributes with the AttributeManager Transformer.

 

Mark and Dale also did a deep dive into Data Types and FME: FME 2023: What's Your Type? The AttributeManager Transformer Has the Answer!


jamal
Forum|alt.badge.img+5
  • July 2, 2023

great

 

Clip_10Clip_11 

 

 

 

 


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