Using readers and writers to extract and load data.
Recently active
I am having problems translating a dgn with a custom line style to another dgn. no matter what I try in the FMW file the line style ends up with the line style saying "Not Found" and is a solid line. I made sure that the seed file had the .rsc file attached. perhaps it is the way I am creating the FMW. Any help would be appreciated
Hi....an easy one for you....i have features with list attributes ...list{0....list{1 etc....now i want to write it in an excel..... one feature per row.....every list attribute in a column...how can i do that?GreetzFranco
Hello!I encountered a bug in the AIXM 4.5 writer. The feature type "AIRSPACE_DERIVED_GEOMETRY" is mixing up the order of the elements in the resulting AIXM file. Therefor the output file is not valid against the AIXM 4.5 schema.The XML fragment which looks like this in the source file (AseUid and codeOpr are alternating):<Adg> <AdgUid mid="1"> <AseUid mid="1"> <codeType>RAS</codeType> <codeId>ABCD</codeId> </AseUid> </AdgUid> <AseUidBase mid="2"> <codeType>PART</codeType> <codeId>ABCD_1</codeId> </AseUidBase> <codeOpr>UNION</codeOpr> <AseUidComponent mid="3"> <codeType>PART</codeType> <codeId>ABCD_2</codeId> </AseUidComponent> <codeOpr>UNION</codeOpr> <AseUidComponent mid="4"> <codeType>PART</codeType> <codeId>
I'm trying to represent our city in a Minecraft world with the following data:dem (geotiff)ground cover (polygon shapefile)rails (polyline shapefile)buildings (obj)trees (point shapefile)Now, in the final Minecraft world the trees (and rails) are always "swallowed" by the surrounding ground cover. The thing is, I can see that the block ID is correct in the point cloud just before it enters the Minecraft writer. But after, they disappear and are replaced by the surrounding block IDs. I tried buffering the tree points up to 1m (because of the 1m block size in Minecraft) and cutting holes in the ground cover, but still the result is the same.Does anyone have an idea where the problem is? Do you need some screenshots for clarification?Thanks a lot! Natalie
This is data that have been received from client. They mention this data in Strumap format. I try to convert it to personal geodatabase but it failed.
Good Day FME'ers,I am having trouble writing to SalesForce. I understand the FME writes the features out to temporary CSV file before using the SalesForce Bulk API to load the data. The problem I am having is FME is dropping fields when writing the CSV file. Particularity, FME is dropping an ID field which is required in the SalesForce App. This ID field is Master-Detail data type (1:n parent-child relationship) and it set to read/write.What's frustrating is, if I export the records as a CSV field then upload them manually, it works fine. The log file and help are rather useless too.Thanks,David
If $(FME_MF_DIR) references "C:/project1/overview/tasks", is there a simple way to reference one directory up, ie: "C:/project1/overview" ? The way I am thinking is to process $(FME_MF_DIR) with some string functions, based on occurrences of the slash - is this the best way forward, or is there is more elegant or simple solution?Thanks
I have a Geodatabase Feature Class in ArcSDE/Oracle. Using ArcGIS software I published an ArcGIS Online Hosted Feature Service. The Geodatabase Feature Class will be editied manually, and I want to periodically send any inserts/updates/deletes to the ArcGIS Hosted Feature Service. (I don't want to truncate and append all data because that is too slow.)My .fmw file looks like below: (1)read the feature class and the feature service, (2)detect any inserts/updates/deletes , (3) write those to the feature service. I think the error I get suggests something is not quite right with my OBJECTID field: "ArcGIS Online Feature Service Writer: 'updateResults' error for a feature in '<feature class name>'. The error code from the server was '1019' and the message was: 'The specified feature could not be updated or does not exist.'" Does somebody have a working example of this secenario that you don't mind sharing? (Screenshots would probably
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