Data

Hello,   I am wondering if something is possible to be done using FME. I have an Excel table that has many cells and entries. I need to manipulate with certain cell entries.  One cell contains many entries. For example in one cell I have multiple parcel numbers and the name of cadastre municipality. I need to separate those values. They should make new row and copy all the cell values the same as previous but in that cell it should keep only for example cadastre municipalitys name and put the parcel number in new column.  Any hints and help?

Hi,I'm reading an IFC file with an user-defined property set (PSET - Atrributs Mensura). I would like to check the values of those attributes. I don't understand why the DataInspector is able to read them (A_THEMATIQUE, B_TYPE, ...) but I can't reach them in the Workbench...any idea ?I'm using the "Industry Foundation Class STEP Files (IFC)" format with hierarchical data model and read property sets as Features.

I'm having an FME Workbench 2017 error reading my R datafile (.rda) with the RDATA reader and the licensed, installed StatTransfer 12 necessary to enable the RDATA reader. The error message reads: "'The signature of the input file is not recognized.'" What does this mean? How do I fix it?

Want To Connect ArcGis 10.5 Sde Mssql Database from Client Machine . It is Mandatory ArcGIS 10.5 at Client ? at client side 10.2 is already install .

Hi,I'm new to FME and just wondering if there's any support or other plug-ins in FME for ArcGIS Pro .lyrx-files. I wish to tranform a lyrx-file to open in ArcGIS desktop.

How can I set the precision for individual points in a point cloud? After applying a 3D Rotation on my point cloud, I end up with x and y values with a precision of 13 and 14 digits, when my source has only 6 digits. I've used a PointCloudCoercer to get individual points that I can then pass through a CoordinateRounder before recombining them with a PointCloudCombiner. It works, but the process is much longer than before.

I am trying to convert hundreds of Bentley Microstation RDL files to either shapefiles or a file geodatabase but have only been able to convert geometries and no useful attributes. All the RDL files have accompanying MDB files, which I believe hold the attributes. How do you complete the conversion while maintaining the attributes?Thank you!

Is there a transformer that can pull pipelines off a PDF and convert them into SHP files?

Hi,i have two readers:personal geodatabaseInterlis ITFI filter object from reader 1 and i need to filter reader 2 if an attribute is the same between 1 and 2.It's possible? Best regardsGiacomo

Hi!Does any one know of a good resource on formating FME output in excelfiles? I have, for example, an excel writer where I don't manage to get the rows that get written to land inside the table in my excel template. Instead the rows write themselves outside of the table, and then I have to go in manually to cut out and paste the rows into the table. There are many other small things and fine tuning I would like to do with the way my excel file gets written. Another couple of formatting things I want to learn how to do are hiding columns, filtering on certain values (while making the data still available in the sheet) etc. If you know of any, please recommend a good website,video or document where I can read more on these kinds of formatting tips and tricks!

Hi all,A simple question for you but I am blocked...I have a dwg file containing multiple layers. I want to rename some of autocad_layer.Example : 1ROADS in the writer must be renamed in WAYSThank you for your help.

Good afternoon,I'm trying to write data to our companies Microsoft Azure SQL Database Non-Spatial database, but I keep getting an error saying "Microsoft Azure SQL Database Non-Spatial Writer: Existing table for feature type `Roads' does not have attribute with name `id'. Cannot continue" However, when I open up the Roads table inside the SQL database, I can see the field id. I've set the data type in the writer to match the SQL database type, and I still get the error. David

Hello ,I think this is the right place to get answer for my question I have Batch of Revit Files which are converted in to .rvz through FME Exporter Now i need to convert them in to .gdb using FME SoftwareI have a knowledge converting single files from .rvz to .gdb But am trying to do that in Batch processPlease help me to find out this process..Thanks in advance..

I am trying to convert a set of GML files (KuntaGML) to Shape but am slowly developing a head ache. The source files are each covering a part of the total area, lets call them blocks. Within these "XML-blocks" are a number of features/tables. I want to convert everything to Shape with one shape file for each feature . What is causing me problems is passing on the schema for each feature/table to the shape file, they are all different and there is upwards of 90 of them. The dynamic writer will pick the first schema it encounters and then run with that, but I need it to update for the subsequent files being written. I tried inserting a feature reader to detect the schema, but that was incredibly slow so I gave up. There is no .xsd-file so I can not go that route. Any ideas on how to solve this?

Hello,I have a building model in dwg format. Inside the DWG it contains layers(roads, walkways, buildings etc). When I convert this to SKP it all looks great, but it merges all the layers. Is there a way I can keep the layers seperate within the model?Thanks in advnace.Ash

The GEOM column in not read by the FME MSSQL Reader, and therefore it has been recommended to use the SQLExecutor to obtain the geometry. The transformer executes the SQL Statement for every row in the table, meaning that in my case with 1400 rows, the result is 1400*1400 in size.What is the easyest way to just get the GEOM column from an mssql databse?

Hi,So we had a sharepoint list reader working in 2017.0.1.1 on a local machine and from within a VM in Azure. We had to get the VM set up to allow the authentication to work, but it all worked in the end. Recently, upon coming back to this bit of work, we are getting 403 errors in both environments when trying to load the table list. I even tried off work network with 2017.1.2.0 and also get the 403 Error.We have people looking into it, but wondered if anyone else was experiencing issues, whether this could be a Microsoft patch issue for SharePoint Online, or if anyone knew how to resolve it? It could be a work configuration issue too, so will report back if anyone finds anything.Kind regards, John

Hi, I am trying to read some data that is stored in several subfolders in the FME share resource data folder. It seems like the process didn't like the wild card ie.. Data\\foldername\\**\\*.csvAny pointers/ work arounds?Thank you in advanced for any help you can provide.

I am new to FME. Although I can deduce how to use @value(Attribute) in a text editor in the workspace, I am not sure how the $ symbol is used and how it can be chained to say @value. Also are there other keywords with the @ symbol. Where in the documentation are all these symbols and their usage comprehensively defined and illustrated? Thanks.

It seems like core isn’t starting because the web interface is complaining about not being able to connect to core and running `sudo ./startServer.sh` results in this error:  ```Cannot open log file /opt/fmeserver/resources/logs/core/current/fmeprocessmonitorcore.log for writing, defaulting to standard error output```

Hi Everyone,I am writing to the AVF writer and then using the AVF reader in separate workbench. However, I noticed that there are two different naming conventions for Level _Ids under Sections category. See attached pictures. Is there a reason why they are different? I know that in the AVF Writer, it is a list, but the AVF Reader does not show it as a list. When I run the AVF reader in my workbench, level_id does not exist. I am using FME 2018. Thanks!David

Hi Guys,Did any one tried converting DRW files to DWG/DXF?Pratap

If we use a shape file reader in FME desktop we only need to pick the shp-file but not the other parts like dbf, shx etc. FME desktop recognizes all parts of the shape file and we can start our workflow.If we publish the same workspace to the server and use a published parameter for the shape file then we need to upload all parts of the shape file as a temporary data upload to FME server. If one of the parts is missing then our workflow will not run. How can we check (in advance?) if all necessary parts of a shape file were temporary uploaded to FME server?Best regards,Frank

Hello,I have a DGN file (Microstation v8) which stores spatial data elements (elements with XY coordinates). The elements are linked to an external database. I need to export the data from DGN file and join the exported data with its associated data in external database. I am using FME workbench with reader format as "Bentley MicroStation Design (V8)" and writer format as GeoJSON.When I redirect my output to FME data inspector, I see the linkage data in a field called "igds_linkage{0}.blob (encoded: fme-binary)". Sample value for this field is E06E00000000000000000000. The actual link value in the external database for this element is 28384 which is 6EE0 in Hex. I can get the same value by swapping the first two bytes of igds_linkage data i.e. from E06E to 6EE0.Now, my issue is that this data is visible in data inspector only. How do I export it into my output GeoJSON file?The field "igds_linkage{0}.blob" is a Format attribute of type char(255). I've c