Transformers

Bonjour,J'utilise un Jsontemplater pour integrer des données dans une base <Mongodb.Le format date est requis pour effectuer des calculs ultérieurs.Probleme: toutes mes dates sont en string.Est il possible de forcer le format date dans je _result ?Merci

Hye, I want to ask on how to delete areas with certain size ya? The data I use is vector data. I hope u guys can help me. Thank you so much

I have an old but simple workspace with one private parameter defined as return FME_MacroValues['pEvent_Attributes'].replace(',',' ') + ' ' + FME_MacroValues['pEvent_Route_ID']When I dug it up and run it under 2019.1.2.0 (20190829 - Build 19630 - linux-x64), it failed with the following msg:Python version 3.6 loaded successfullyTraceback (most recent call last):  File "<string>", line 5, in MF_Include_1574806112377  File "<string>", line 4, in ParamFuncKeyError: 'LRS_EventMerger_pEvent_Attributes'INCLUDE -- failed to evaluate Python script `def ParamFunc():  return FME_MacroValues[FME_MacroValues['LRS_EventMerger_WORKSPACE_NAME'] + '_' + 'pEvent_Attributes'].replace(',',' ') + ' ' + FME_MacroValues[FME_MacroValues['LRS_EventMerger_WORKSPACE_NAME'] + '_' + 'pEvent_Route_ID']value = ParamFunc()macroName = FME_MacroValues['LRS_EventMerger_WORKSPACE_NAME'] + '_pAttributes_Merge'if value == None:  return { macroName : u'' }else:  import six  try:    value = six.text_type(value) 

Hello GIS Expert what coordinate system is more accurate on the ground, is it the geographic coordinate or the Project one ( UTM wgs84 ) , 2- if we convert from Geographic LAT/LG coordinate system to UTM, are we losing the accuracy of the geometry on the ground  Thanks, Guys '

Morning...looking for assistance with FME desktop and its CartoDB writer. I have a workspace which writes several thousand planning application points to our CartoDB account. One field in that dataset is a URL for each planning case linking back to details on respective websites. Quite a few of these records contain URLs which have ampersands separating the query parameters.If I write the records to CartoDB using the CartoDB uploader transformer the ampersands get mangled into %26amp; This isn't even a correct encoding. Ampersands should either be one of the following... %26 OR &  .....and never a mix of both!! If I write the records out to a CSV file instead everything is fine. If I manually upload the CSV file to CartoDB everything is fine....it just seems to be the CartoDB uploader transformer.Sample URLs below. The top one is coming out of the CartoDB uploader transformer (thanks to the extra inspection button in FME 2016 this output is easy to see now). The second URL is corre

Dear All , How to do statistic report on on rolling 12 month basis , e.g on 1/1/2019 , we need the sum and count from 1/1/2018 till 1/1/2019 and so on . Thanks ,

This is a follow up to a question I asked yesterday, https://knowledge.safe.com/questions/103101/intersector-behaving-really-strange.htmlSource B is a road network and source A is overlaying lines with aditional info on the roads. I would like to transfer the attributes, and some non overlaping features from A to B. Some of the features in B already have these attributes so there is a empty cell causing trouble when I try a spatial join like the LineOnline. If B gets read first no attribute will be transfered from A and a empty cell will be output. I have then moved on to trying to do this with Lists, but have run out of ideas. The LineOnline transformer above is set to gather lists for the attributes I need. In some places there are multiple overlays which makes it tricky to merge the data. See illustration below. NN OO MM 1 X   2  Y  3   Z  How do I merge the attributes in the table above? Also some of the features have conflicting data, but that is a later headache.

We are using an existing DWG drawing as a template to write out to a new DWG. The template was created Zone 54 but some new drawings are in Zone 52 or Zone 53. Unfortunately we are finding that the output DWG is retaining the original Zone 54 even if we set the drawing to be another zone. Interestingly the output .prj shows that the projection is in the new zone but when we open it into AutoCAD the template Zone 54 is used. Any ideas? 

I would like to replace all <missing> values with a default value. Incoming attributes are not known before (dynamic input).NullAttributeMapper should solve this problem, but the option "map: all attributes" does only exist for Null and Empty values.Do you know another helpful transformer or workaround?Thanks for your comments. 

Hello,  I would like to migrate data from Intergraph FRAMME format to G/Tech data model. How should I go about it?  Cheers, John

Hello partners,As mentioned in our November 2019 Partner Bulletin, we are introducing a new licensing status and a walkthrough for adding new processes for ELA and subscription assets.What’s new?Introducing a new license status, ‘Term’. This will be used to provide temporary licenses for all assets acquired under ELA and subscriptions. More information can be found in the accompanying document.  We have streamlined the process for partners when adding assets for accounts under ELA or subscription contracts. Watch the video below or read this document for the updated process. If you have any questions, please get in touch with your Channel Account Manager or the at any time.

I am creating a legend for my pdf and using the PDFStyler to create the different line colors. Based on a certain value in an attribute, I am setting the rgb for the legend line. It looks ok in inspector after the PDFStyler, but when it goes through the PDFPageFormatter, all the lines are blue. If I were to set the color for the data individually, it is fine, it is just when I attempt to set the color from an attribute that it doesn't work. Would appreciate any help.some of the types are not defined which is why they are black.all blue  

This is my dataset:ZwemplekVoorzieningAanwezigAAAAToilettenjaAAAAHorecajaAAAADouchesneeAAAAEHBOjaAAAAParkeerplaatsneeBBBBToilettenneeBBBBHorecaneeBBBBDouchesneeBBBBEHBOjaBBBBParkeerplaatsneeCCCCHorecajaCCCCDouchesjaCCCCEHBOjaCCCCParkeerplaatsja The number of rows in the input dataset may vary or the order of the rows may change.How do I transpose the rows to columns?My resulting dataset should be like this: ZwemplekToilettenHorecaDouchesEHBOParkeerplaatsAAAAjajaneejaneeBBBBneeneeneejaneeCCCCjajajajaja 

I have created a polygon layer from a numeric raster. RastertoPolygonCoercer shows a _label attribute to be created and this appears in inspector as the values from the raster. Perfect - but - I want to ensure this is carried through and written out to shapefile - except I can't "see" the attribute in subsequent transformers. So I thought attribute creator and map the attribute to a new field, or attribute exposer and ensure it appears, or even attribute mapper sounds a possibility. Except when it comes to picking the attribute you want to make available (_label) it doesn't appear in any list of available attributes. It doesn't appear in a shapefile written out and I don't know how else to access it - Help.....

Hi all, I'm running into this error when I try to run some queries inside SQLExecutor. Select * into * not allowed in sql executoris there any other way around? Thanks.  

I have been trying to use transformers Sorter and ListSorter to sort multiple attributes with numeric values without success. Any help will be deeply appreciated. Thanks!

I need to check a lot PDF file with energy bills, look the barcode and get the numbers to make the payment.So, with FME is it possible? Check this barcodes and convert to a text file or xls with all the numbers in a column.

X, Y, Z coordinates of point cloud.

Hi guysI am looking to create a buffer where I have a rectangle. I would like the north and south to have a scale range of 1km and the east and west to have 2km. Then to have it all in one shape to show the buffer area. What would the best way to do this with the buffer tool in fme. I have seen something with python which is possible but is there anything similar in FME.Thanks

I'm having an issue writing vector data and an image together into a pdf. The vector data is coming from a sql database, the image is from a web source. I'm using the ImageFetcher to clip the piece of image I need. The bounding box of the image comes from a buffered of all the vector data I'm writing to the pdf layer.The vector data are pushed off into the corner when I attempt to write both the image and the vector together. I'm following the example of how to create the pdf from a sample workflow from Safe. The only difference is that the image in the sample comes from a file and mine comes from a web source. Would appreciate help with this. Below are the workspace image, and the image of the pdf with and without the background image.

Hi,I'm having this error sometimes (not always, that's the weird part) when I try to convert an attribute that has 3 possible values (0, 1, null). what is the best way of solving this problems.Value of attribute 'isReg' could not be converted to type 'int2'. Feature will be logged and skipped... Last line repeated 1229 times ...

Hello everyone,I have a workspace where I'm trying to extract the two different 'styles' out of two attributes. In both attributes there are some strings that have 9 values, and some that have 11. I tried to use a TestFilter to extract these four separate styles into their own output. I've attached a photo of the statements I used. One problem I was noticing was that there was no attributes being cached at one of the outputs, even though the prior transformer output had the attributes present. Inspecting some of the cached features seems to be misleading, and sometimes shows missing values. Could someone tell me what I'm doing wrong? I can attach the workspace if needed. Thanks,Reid

Hi all,  I have two different datasets and both are consist of line string. I would like to insert new nodes in the green line at the projection of the last/first node of the red lines. The desired new nodes are presented by red points in the following picture. Any idea? Thanks in advance.  

Enterpirse geodatabase in oracle. Exisiting column has a datatype of double with values of 1,2,3 etc. I want to use ValueAttributeMapper toremap these values to sphere, board, cube etc. If I change the datatype in arcmap from Double to VarChar2 does it need to be empty or will the workbench take care of this? TheWriter currently has Drop Table: No and truncate Table: yes

I have got an amount of points which are the locations of fire hydrants. Each of it can deliver a certain amount of water (Liters / Minute) in a radius of 300m for firefighting purposes.I have created a buffer around each point and now I want to calculate the amount of water for firefighting purposes in the buffers an in the overlap areas and in the non-overlap-areas.  Example: I have Hydrant #1, which can deliver 2000 l / Min, and I have Hydrant #2, which can deliver 3000 l / Min. In the overlapping area, I have 5000 l/min of water supply, in the non-overlapping-area I have a water supply of 2000 l/Min (Hydrant #1) or 3000 l/min (Hydrant#2) respectively. Of course, there are many more hydrants to look at, and in some cases we have a dozen or more hydrant areas which are overlapping. I have used the "area-on-area-overlayer", which seems to work properly, but I don't know how to calculate the sum of water supply in the overlapping area. Is there anyone who can help?