Transformers

recently?i have tried translate revit model to cesium tiles?but donot know how to translate with texture?how to set it in right geolocation which set in revit,anyone konws how to do this? Thanks in advance.

Fun fact, is that FeatureWriter writes to a database path of ":memory:" for SQLite and SpatiaLite formats (or seems to at least). For SQLite buffs, this is a virtual database instance written entirely in RAM so cuts down on disk/temporary file overheads and is highly performant. It is a feasible way of combining in an FME workspace non-SQL, procedural type transformers together with the power and lower overheads of the SQL engine contained in SQLite when your features also happen to be highly data relational and can be indexed (plus take advantage of the extensive spatial library functions that come with SpatiaLite as well)However, for the life of me I can't figure out any way to use an in-memory SQLite DB from there in a workspace, say with an SQLExecutor. It seems as soon as FeatureWriter finishes it closes the connection to a database written to ":memory:" and no further reference is held to it (and because the DB is volatile then the Transformer essentially

Per SQLite documentation, Real and Numeric are supported and Real is of a Float type. However in InLineQuerier Numeric is not an option, only Real and Float to pick. Due to precision issues of floating point, we would prefer to use Numeric in several cases. Please advise.

Hello!I've been having some issues with the cumulative output from StatisticsCalculator - it seems to be giving me the complete sum rather than cumulative sum of the chosen attribute. Simplified example:Anyone come across similar issues? Suspect this might be a bug.Cheers!

What does the "Blank Attribute Value" do? I am having a hard time finding it in the docs... 

Hi FME'erI have created a shape file of crime data and I also have a boundary shape file of the neighborhood. I want to create a heat map to analyze which neighborhood has the most number of crimes for which i will be needing the count of total number of crimes that have taken place in that particular neighborhood. But i don't know how should I proceed to be able to do a spatial join and to calculate the count of crime points in each neighborhood polygon such that the output polygon will have an attribute field of the sum of the crime count. Any help and guidance will be much appreciated. Thanks in advance

How do I transform from NAD83-Original (1994) to NAD83-CSRS for areas which don’t have a provincial grid shift file? (e.g. Yukon, NWT).All new incoming data are NAD83-CSRS and I want to bring our older holdings up to match. I don’t have confidence in the automatic methods chosen by ArcMap/Pro/others in project-on-the-fly situations. I’ve seen too many instances where different coordinates are reported for same points from different methods.With csmapReprojector the process fails with:CS-MAP Reprojector: Transformation will be automatically selected for 'UTM83-8' -> 'CSRS.UTM-8N', and is not guaranteed to remain the same in future releases of FMECSRS :: Referenced grid file does not exist or cannot be opened for reading.A fatal error has occurred. Check the logfile above for details...CsmapReprojector (TeeFactory): CsmapReprojector: Reproject: Could not reproject the geometry of the preceding feature: CS-Map Reprojector: Unable to load grid file for 'NAD83_to_CSRS' | CS-Map Reproject

@takashi Hello!I'm having difficulty to update a network lines with new survey points. I want to shift each vertex point of a line (in red) with unique nearest point (black). Can someone help me please? Thank you.

Hi, Having trouble describing my problem to Google it, so apologies if I've used the wrong term or missed something obvious here. I'm just starting to use FME so please be nice! :D I have a spreadsheet which contains owners of properties in this format:PropertyOwner 1 NameOwner 1 Addr1Owner 1 Addr2Owner 2 NameOwner 2 Addr 1Owner 2 Addr 2 And so on for up to 4 owners per property. Properties with one owner have blanks in the Owner 2/3/4 columns. I'd like to reformat this to individual records for each owner, like this: PropertyOwner 1 NameOwner 1 Addr 1Owner 1 Addr 2PropertyOwner 2 NameOwner 2 Addr 1 Owner 2 Addr 2 PropertyOwner 3 NameOwner 3 Addr 1 Owner 3 Addr 2 PropertyOwner 4 NameOwner 4 Addr 1 Owner 4 Addr 2  In the real file there are several property columns that I'd like to copy down to all other rows for that property, and obviously if there is blanks I don't want to create new rows.Is this possible in FME? Can anyone point me in the right direction? Thanks,

Hi,I know that numeric count only count the features which are integer or floating point, but I was wondering if an attribute has no value (only empty cells), does the numeric count return a zero?I'm trying to count the number of instance when a given attribute has an empty cell has a feature. thanks

Hi all. I'd like to populate a new attribute D with attribute C value from a feature of my table, where its attribute B is the same as attribute A of my target feature. So attr D and A, target feature, attr B and C referent feature. Is it possible? Im use to work with 2 readers, not sure how to do it with one. Many thanks!

Hi,I want to convert 1000 jpeg files to pdf format. I have almost managed to finish the script but the one thing that i smissing is that the PDFpageformatter that I am using cannot be adjusted for each jpeg picture. What I am trying to say here is that i want the pdf to be the same extent as the jpg file without doing this manually (since I need to convert 1000 files).Heres a picture of my script in FME

Hi,I would like to read data from a WCS service in a way that it reads only the part of my projectarea. It seems that the way to do this is using a Feature Reader and use an spatial filter in the Feature Reader. Unfortunatly this is not working. The URL created has the wrong bounding box value. The error I get is: "returned Content-Type 'application/vnd.ogc.se_xml; charset=UTF-8' is not supported". I can read the exact data using the WCS reader by using the search envelope, but this is not what I'd like.Another way is to compute the extents in one workspace and call another workspace with the workspace runner with the extents as parameters. But it should also be possible withe the Feature Reader.Anyone any idea how to fill the bouding box within the Feature Reader for a WCS service? Greetz,Arno 

Hello, I have a DWG file that has it lines in model space but the labels have been added to the drawing in paperspace in a viewport.I am trying to figure out the best way to validate that the length of the line in model space is the same length as the label in paperspace.Is this possible?I have attached a very simple test that I am trying but it is not reading from the viewport.  

Is the map attributes action impacted by a feature filter action? For example, say my schema mapping table looks something like this:And I have to actions set up:1) Filter Features on the filter columns2) Map Attributes on the map columnsIt the filter features action returns false, e.g. filter never equals X, will the map attribute actions still take place?

Hello All,I am seeking some advice on how other organisations have tackled Paper Space and Model Space validation from an incoming DWG.We are trying to come up with some drawing standards that will facilitate a cleaner / easier validation of the data and presentation of the drawing.We are suggesting that all elements be drawn in model space so that we can validate text labels against the actual line angles and distances. But the drafters need to use viewports in paperspace to generate enlargements of certain parts of the data and we need to validate that the data in the viewports is correct.Do any other organisations have standards on how drawings should be put together in both model and paper space so that data and presentation elements can be validated simply?

I try to extract values from a Postgresql 12 DB (to populate another pg table) by matching a feature attribute."pk_numart" (column)"editor"."articles" (schema.table)"codarticle" (column) The query : SELECT "pk_numart" FROM "editor"."articles" WHERE "codarticle" = @Value(Mesure) Then I get the following error : Executing custom data query: 'SELECT "pk_numart" FROM "editor"."articles" WHERE "codarticle" = 13.E'Error executing SQL command ('declare "editor_custom_query_crsr" cursor for SELECT "pk_numart" FROM "editor"."articles" WHERE "codarticle" = 13.E'): 'ERREUR:  erreur de syntaxe sur ou près de « E »LINE 1: ...k_numart" FROM "editor"."articles" WHERE "codarticle" = 13.ESeems that the point causes the query to fail. I've tried several combinations, with or without hyphen before query or delimiter, but still no luck. Thanks already for any help.

Hello, I have one dataset, the epoch time on that is approx. 5HzI have another dataset with epoch time and that is in 20Hz, it covers several different 5Hz datasetsThese two features do not share a perfect match in milliseconds.I want to merge the 5Hz attributes to the geometry of the 20Hz. NeighborFinder does not work since the 20Hz has geometry from several different datasets in close proximity.Both datasets contain timestamps which merges succesfully in FeatureMerger, however these matches are sporadic.I cannot round the milliseconds to more than 3 decimals, since that will degrade the solution of the 20Hz.I was thinking of an inlinequery with an SQL query that performs an epoch timematch based on a 0.005 second in range since that would be the unique identifier. However I do not know how to fully structure such a query. Regards,Robin

Hello everyone,I would like to move some points labels which overlaps each other. The source files is a DGN.You can see on this picture the overlapping :My wish is to move these labels so that they dont intersect each other or with the network below.I tried to parameter the transformer without success. I contacted Veremes and Safe without success too...Your are my last hope :) Thanks for your help and have a good day.BRNicolas

Hi there,I want to convert an attribute so it always has four digits, and two decimal places. As an example, if I have . 6.5 as the source, I want the output as 06.50.I've used the expression 04.2f in a string formatter, but this doesn't seem to be working for all of my attributesAs an example if my source attribute is 50.7, it recognizes the format and the output is 50.70. But if I have an attribute with one single digit before the decimal place like 7.28 the output is still 7.28 and not 07.28Let me know if you can help.-Reid

I want to read the contents of a SEGY file. FME has a SEGY reader which displays the content as Binary. I need help converting the binary content into something useful.

Hi, I attempted to use SchemaMapper for the migration of data. In general successful, however, in the Mapping Excelsheet I defined a rule to add an attribute, which uses a string function in the "NewValue" column. I can use the functions @Timestamp and @Value, however, the functions @ReplaceString or @ReplaceRegEx fail, and FME (2017.1 build 17652) is complaining "This FME edition does not recognize the `ReplaceRegEx' function." Is there a list of functions available that are recognized by SchemaMapper? The functions work fine from e.g. AttributeCreator.

Hello,  I have a bunch of polygons (grid squares) and points.Each point has an attribute to qualify its type (1, 2, 3, 4...).  First I tried to create in each square an attribute with the number of points it contains.This I achieved using a PointOnAreaOverlayer. Now I want to create on each square X attributes with the number of point by type.GRID_IDTYPE1_countTYPE2_countTYPE3_count...XXXXXXX0122 YYYYYYY1122 ZZZZZZZ1284  The thing is I don't know inadvance which type I'll get. I can have types 1/2/3 one time but then 1/3/4/6.Two questions I ask myself about this: How can I ventilate the features by type not knowing in advance the different types (with the testfilter I need to know the types in advance...)How to get my counts attributes ?Any help will be welcome :)

Subject says it all. Trying to determine if there's anything in it I want to test and/or evaluate.

Hello, let's say that I have 2 queues:  DefaultTest each of them has priority set to 5.  And I have 2 engines, each one has both queues assigned. Both engines are in use at the moment. In which order new jobs will be taken? I performed some tests and it wasn't taken based on jobid (this was my assumption).   Lets sayd that in queue there are jobs: JobId Queue 10 Default 11Test 12Default 13Default 14Test 15Default