Data

I'm trying to determine if a dataset, one of many, has already been processed so my workspace won't repeat that dataset but rather move on to the next dataset.  If the dataset has been done there will be file that I can test for.   If I use AttributeFileReader on an existing file it is OK but if the file doesn't exist it halts the workspace.  I can check using a PythonCaller but can't pass the result back to the workspace to use in a tester transformer.  Any help would be much appreciated, Alan

Hello! I'm trying to write the values from several attributes into an excel file. I want all values on the same row, now I'm getting them in one row after another. Any ideas on how to do this? Regards, Louise

Is it possible to turn off / disable the "Borrow license" on FME Desktop? Or limit the number of days?

I am trying to take zero-length type 3 (Line) data from a microstation v8 file to a .las file. I am able to read, but I keep getting the flollowing response in the log:"DESIGN READER: Failed to read XFM feature store element. Skipping element read GeometryCoercer: Cannot coerce from IFMEPoint to fme_point ... Last line repeated 2498 times ..."What would be the best way to get these zero-length type 3 lines over to a .las file? Thanks!

Hi,I have a folder with 60 shapefiles, they need to be renamed based on a list. I tired file copy with AttributeValueMapper , but it dosenot keep the special letter in swedish ("ö","ä","å") in the shp attribute.I donot understand why when I use copy file it will change the shp attribute.Is there any good solutions

I have a problem to insert a gdb-Reader (ArcObject) in FME2017:new WorkbenchInsert Reader properties are not relevantrun workbenchTranslation stop with Message: 1 parameters (number values) were provided for the SEARCH_FEATURE keyword. An even number of parameters must be providedA fatal error has occurred. Check the logfile above for detailsIt's a bug?

Hello,I'm reading a GML file which contains <roadName> tags as shown below:<roadName>ROAD NAME IN ENGLISH</roadName><roadName xml:lang='xx'>ROAD NAME IN OTHER LANGUAGE</roadName>The application schema only recognizes RoadName field - output would be a comma separated list of values "ROAD NAME IN ENGLISH, ROAD NAME IN OTHER LANGUAGE". I'm wondering how to extract the language into an attribute as well?Any help much appreciated. Thanks

Hi,Im having problem with my workbench while using pointcloudcombiner. Im making 2d vector to simple 3d buildings with walls and without roof. Everything goes fine till I try to make pointcloud from walls with pointcloudcombiner. Workbench log gives only 'Error running translation', no warnings or anything else to see why there is error.. I've tried with extruded area walls, polygon walls, surface walls.. Everything gives error..As seen in picture I can't follow any reason for this error.I've readed that there is crashing with spesific graphic card and its updates. But can it be here when it only crashes with this transformer?

A customer of SBS has upgraded the ESRI client to 10.4.1FME 2014 (they use that version) is not supporting this ESRI client.Can anybody inform me about the minimum required FME version compatible with ARCGis 10.4.1?Thanks.

Hi there!  In a generic export workbench, I need to use a FeatureWriter to filter when a JPEG2000 output is selected. No problem to export in JPEG2000. It works perfectly. Althought in this case, I need to generate a world file after so I added a RasterPropertiesExtractor transformer, but Ive got a error: "@RasterProperties: Failed to obtain raster from feature. Only features with raster geometry are expected" ? Obviously it's raster geometry: the image has been exported. I added a GeometryFilter to filter on Raster but still got the error Could it be a limitation to the new FeatureWriter transformer?

There are, say, 600 records (this number is variable) in an Excel document. I would like to concatenate an attribute value with a URL, 4 records at a time (e.g. [first portion of URL]1,2,3,4[second portion of URL]). Is there a way to accomplish this?

My goal is a colored 3D DWG. This is my current workflow:Read a SHP (containing polygon features) and an Excel fileJoin them to give the SHP features a color attributeUse the color attribute with DWGStyler to color the featuresSave as DWGThis works.. somewhat. When I don't color anything, the result turns out as expected. When I color just the lines, I get the expected result as well. However when I fill the polygons, some of them end up flat at height 0. What could be causing this?

I am trying to insert an object into Smallworld that needs a point. I have done this successfully many time but this particular object or set of objects is more dificult. I need to be able to save a point that is coming in from microstation to be used for more than one object in Smallworld. The error I am currently receiving is "Trail must contain at least 1 point" Any suggestions/help would be appretiated.

How can I access a database that is part of my local network or running on a RDS instance in my Virtual Private Cloud (VPC) on AWS?

This is a new feature in civil 3D allowing you to attach any data template to all objects and entities in civil3D. Not only alignments, corridors, surfaces... but all plain Autocad Entities as well. Are there any plans to support reading and writing these in the futur?Civil 2017 - Property set definitions

Hi ,I'm converting from Microstation V7 to V8 and I have a problem , the elements type 33 (Dimension element) are separated in diferent elements , Text + Line/s , and not are agruped in a unique element of type 33.thanks in advanced for your help ....!!!

Hello All,I am using Oracle SQL query to extract data of my interest from the Oracle database. Please advise. I am trying to use SQL Creator and SQL Executor but no luck. Please advise. Thanks

I want is create (even) an non-spatial index in the Oracle-spatial writer. So i tried the "SQL Statement to execute After Translation" with the next SQL: CREATE INDEX GBKN_ALLES_TST_INDEX ON GBKN_ALLES_TST(DWGLAYER, KLS_KLASSE)LOGGINGSTORAGE ( BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT )NOPARALLEL;But it failed... error was `ORA-00911: invalid character'What is wrong?

Hi everybody ,One question , anybody knows how could I create feature class that are included in the diagram FME but , like no transform elements of that featureClass , don't create the feature class in the output.I'll explain better , in my actual FME I have diferent feature class of output line VegeLin , etc. I have seen that if the transformation don't send elements to this feature class in the GDB of output I haven't this feature class , and only are created the feature classes that has take elements from the transformation.Thanks in advanced for your help.Regards !!!

Hello,I am reading in DGN files using the Bentley MicroStation Design (V8) Reader and am writing to PDF's. For some reason, FME is converting the dimension text to decimal numbers as it reads the DGN (i.e. 3'-6" is read as 3.5) - I can't even get it to appear correctly in Data Inspector. I tried bringing in the dimensions as an aggregate (Unchecked "Drop Dimensions" parameter on the writer), but when I exploded igds_dim_text{}, the text_string attribute was still a decimal number... I have attached screenshots below - the image on the left is viewed within MicroStation, and the image on the right is from FME Data Inspector. Does anyone know how I can get the dimension text to come into FME exactly as is appears in MicroStation? As seen in the images above, the lines are also in different locations in FME... If you can figure this out too, you get bonus points :-)Below is a screenshot of my reader parameters. I also tried changing input units to IGDS_UORS,

Hello all,I have a Excel file with dates and i would like to read this XLS and take the Min and Max values dates.I didnt find a transformer that make this.Thanks in Advance,

Hey all!You all have helped me out a lot last time and today I again came across a problem which is why I'm posting again. The situationBasically there is a report that has to be created through exporting data from a database and putting it into an excel sheet. I want to automate this through FME.So I added in two 'sqlcreators' which grab the neccesary data from the database. In the excel writer I want to write the data into specific columns. The issue is that again its going to stack the data on top of each other. I tried to use a featurmerger but obviously it does duplicating checks and thats not necessary. The only thing FME has to do is putting data from 'SQLCreator' in collumns A, B and C and putting the data from 'SQLCreator' into the columns E, F and G without stacking the data.So how fme does it like this now:How I want the resultNow I have a solution which is creating a workspace for each sql creator and using the output files of the previous sqlcre

Hi All, we are using Smallworld 5.1 and we need to import data to Smallworld with FME. I have downloaded and installed FME 2016.1 , after that i have copied "sworldswaf.dll", "sworldswaf.fmf" files from Smallworld installation path to FME path (dll file to C:\\Program Files\\FME and fmf file to C:\\Program Files\\FME\\metafile). After that when i opened FME Work Bench and trying to add the Smallworld reader, it is not showing the Smallworld reader. Please help me in this regard. Thanks in advance.