Using transformers to modify data.
Recently active
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
Afternoon, Does anyone know a way of calculating working days between dates? I have used the DateTimeCalculator to work out the calendar days but the department that is asking for the work to be completed are asking for working days as it is linked to processing times. Thanks in advanceDarren
Hello, I need help. I got input data(points) with attributes: LONGITUDE, LATITUDE, AZIMUTH, AZIMUTH RADIUS AND AZIMUTH WIDTH. I need to get output polygons that look like a pie.
Hi!I have 2 attributes, one with the value to test and one with the test.I would like to do an automatic test based on this 2 attributes in order to keep or not entities.I tried expression evaluator and attribute validator but I don't find the good syntax.Indeed, on my second attribute I could have a mathematical test like ">50" or a range like "[50-60]".It work for ">50" on expression evaluator but I don't suceed with the range.Do you have an idea?Thanks!
Hello,I'm trying to convert an IFC file into a ArcGIS webscene, via I3S. This worked fine for other models in the past, but this time, the writer crashes after using up ~27 gb of RAM.It's a tiny IFC, just some ~40 Mb. Even weirder, I can convert the IFC solids into multipatches via SHP, or GDB. Just no I3S. :(I would really appreciate some hints.
Hello, Would anybody know if it possible to add hyperlinks to features when writing out to 3D PDF? We have tried using the PDF Styler, but this only appears to work with 2D GeoSpatial PDFs. Thanks
I have several workspaces that work with Caris CSARPC Point Cloud files, I have just upgraded to v2019 64bit from 2018 32bit. I also have had an OS upgrade from win7 to win10. I know a lot of changes...When I run the workspaces now, I get an error "The error was 'Caris error: 139764: Internal error" and "Error running translation", in 2018 I don't get this and it works fine. I can't find a reference to the Caris error number anywhere, does anyone know how to find this?(Note: If I run in Cache mode and step through all transformers I don't get the error???, Also I'm writing all fme temporary files to a file share that has plenty of space) general process at start of all workspaces is:- creator- FeatureReader (CSARPC)- PointCloud Coercer- CoordinateExtractor (just extracting z value)
Have you had the same problem with DuplicateFilter on FME 2018 I have 209/35k but on FME 2019.1 I have 12k/35k. I don't know how but it works not ok in 2019?
Hi,I have problem with FME 2018 where my workspace processing just stalls at one particular NeighborFinder transformer. The workspace has several NF transformers with fairly similar parameters, but only one is causing problems. It processes either one or none of the features after which nothing more happens, the processing just stalls.I don't get any errors, FME doesn't crash, the last line in the log is Processing base feature(s)... and even though the transformer should process the data in a couple of minutes, nothing happens even if I leave it running overnight.However the workspace runs just fine on both FME 2018 and 2018.1 (32 bit) if I reduce the processing area, but even running the workspace at full processing extent, I don't seem to have any memory issues. Furthermore, I have tried to run the same workspace on FME 2017.1 and 2019 beta (32 bit) and there I have no issues whatsoever. Is it perhaps a bug of sorts in FME 2018?The overview of the workspace in question:
I am trying to find an elegant way of reading content from an AES-encrypted zip-archive which is downloaded from a trusted source.If it were not encrypted or just used cryptozip, I would just use a pythoncaller and zipfile and process the results of a httpcaller. However, zipfile within python seems to be unable to deal with aes.Is there an elegent way around this? Will I have to save the file, run 7zip through a systemcaller and read the contents?
I need to extract the last two values for "rating" and "score" objects from the following JSON string. So I have an attribute 'rating' with value of 'Unclassified' and attribute 'score' with the value of '8.91'.[{"assessmentReference":"BREEAM-0052-9883","assetScores":{"assetScore":[{"categoryScores":{"categoryScore":[{"categoryCode":"Man","categoryName":"Management","creditsAvailable":"21.00","creditsAwarded":"5.00","score":"2.85","weighting":"12.00"},{"categoryCode":"Hea","categoryName":"Health and Wellbeing","creditsAvailable":"11.00","creditsAwarded":"0.00","score":"0.00","weighting":"15.00"},{"categoryCode":"Inn",&qu
Hi I don't understand how have to use the CCS to parse the HTML page http://www.comune.torino.it/albopretorio/alboordinanze.shtml to obtain as output a table with the 7 value (see the picture) I mean the goal is the parse the HTML page to have all value 1 in the first column the nu,ber 2 in the second column and so onthx Francesco
Hi everyone,I've had trouble with texturing surfaces of building such as wall surfaces, roof surfaces with specific images for each surface. I used AppearanceSetter for texturing surface, and simply all the surface will have the same image texture. My question is how do I texture a number of images to their surfaces. My idea is to create two equal IDs for each surface and its image texture but I don't really know how to do it with the FME transformers. Could anyone help me with it, please? Or any new suggestion or idea will be highly appreciated.Regards,
How to install NTv2 grid files? Following the instructions at http://docs.safe.com/fme/2019.0/html/FME_Desktop_Documentation/FME_Workbench/Workbench/options_coordinate_systems.htm I've copied the `NTV2_0.GSB` file I acquired from NRCAN into "C:\\Program Files\\FME\\Reproject\\GridData\\NTv2".From FME Options I select Coordinate Systems. Now what? Which of the listed items do I edit? I tried NAD83_to_CSRS. I'm able to use the down arrow to select the NTV2_0.GSB file from previous step, but the [OK] button remains disabled.