Using readers and writers to extract and load data.
Recently active
I have been reading the 2018 Desktop Basic documentation. When introducing the Integration Transformers there is an example of workbench shown below :From the situation, I suppose the Dropbox contains only images with specific names. These names have to be contained in the ImageFile attribute of Parks. I am wondering about the set up of the connector which allows the join of the right feature with the right ParkImage. I believe a Download action from the connector might have been done and that the destination probably was set to Attribute, but I don't seem to make it work on my own.
When I translate from shapefile to DGN, inside Microstation the Element information for "Line Style Parameters" always comes across as 1.0000. Is there a way to set this during translation to a different value? Thanks. Bonus Question(s)Is there a way to set the Fill for any "Shapes" that come across to 'NO FILL' or 'None'.Is there a way to have point features which are translated to CELL come across as an annotation cell?These also need the is Annotation value set to False.
R4414A2.lazhello every oneMy name is Maher I am student at University of Oulu FinlandNow I am Working on modeling 3D City Model using FME .I have a GML file that have the information of buildings and everything .However I want to store the Building information from the gml file to a text file . And the data should be like<height> <number of corner> <coordinates of vertice1> <coordinate of vertice2>.........................<coordinate of verticeN>for each building I should have a line of information like this .Could someone help me to achieve this structure
I have a bunch of workbenches running and one feature class in particular is acting very peculiar.This data is simply being moved from one GDB to another, it is new data overwriting old data.Today (for example) it is just five features, the first feature in the list will not overwrite, but the rest do.I imported the first feature on it's own and it worked, I also tested it where I selected the tables in a different order, and that worked.I then deleted the reader and created a new one, and the feature ran and was successful on the feature class. The second time I tested it, it didn't work.This same thing happened on a different workbench with the same feature list, that first one did not work.Any ideas why it won't work sometimes? The only thing that I see is it is the first in the list of the feature list I'm running and it is the only name that shows in the "Feature Class or Table Name" in the transformer (see second image below), even though it's runnin
Hi,I would like to create a pointcloud (las file) from a csv. The csv has x, y, z and some other attributes. On one x,y coordinate I have different attributes per z value. How can I create a point cloud without loosing the attributes? I manage to create an pointcloud via an aggregator and geometrycoercer, but then I lost all the attributes. Any help is appreciated.Arno
While updating my sde geodatabase the writer in FME is really slow. Does anyone have expierence with speeding this up? The articles I find on performance are not enough to solve my problem.It updates as much as 1 object per second. And I need to update 30.000 records.It seems that the old version of the writer is working fine. However, now that I am using FME 2018.1, the writer is much slower. Edit: i must use edit sessions, because of a versioned database I hope that someone can help me!Kind regardsJelle
I have multiple features incoming so I need to make this a non-manual process. Currently I'm overwriting a number of features (but not all) in a gdb with updated data that is incoming. Some of the features are completely new data, so they need to import into the same GDB. I currently have my writer set to Truncate Existing, which works perfectly for overwriting. Any ideas how I can Overwrite and set it to import a new feature (if there is one) as well?Thanks
Hi, I'm attempting to use the FeatureWriter transformer to write intermediate data in my workspace. The issue I'm running into, is that unlike in Esri's ModelBuilder, I can't connect that output/writer to another transformer, which is what I need to do. Because I'm working with Esri feature classes (in file geodatabases and SDE geodatabases), the formatting of files needs to be just-so. If I'm starting with a .xlsx file and would like to eventually perform spatial analysis on the data, I need the ability to write it to an Esri-friendly format ( geodatabase table) before I can start editing fields, completing joins, etc. I can get the workspace to the point of writing the .xlsx table to a .gdb table, but I'm not sure how to use the FeatureWriter transformer to continue the analysis I need to do on the .gdb table in the same workspace since that transformer doesn't offer any output ports to connect the dataset to another transformer.
Hello, I downloaded a trial of FME desktop , and I was trying to extend it to Revit , it keeps saying I should run it as an administrator , which I did , but it still didn't work. please advise what should I do
Hi! I have been googling PostGIS-3D-solutions so hard that my finger tips are getting sore. Basically I need to create 3D solids and store them in PostGIS from mainly Autocad data (preferably with FME). Then I want to be able to store 3D points in the same database and query if they are inside the body of the solid or not. As simple as that. Any suggestions or links will be appreciated!
Hi,We are currently using AutoCAD Map 3D and use Oracle spatial database for storing spatial data. We are going through FME software like to know :1. Can FME support moving DWG to NOSQL database (like MongoDB support ) ?2. For Oracle spatial can FME handle and save blocks as well ?
I am using FME 2018.0 desktop, and writing to a DWG with the AutoCAD Writer (in a feature writer) with a template file which has a large number of blocks. However, not all the blocks are used by the output file that is being written. I have set the writer to "purge unused objects" in the hope it will remove the unused blocks when it writes the output CAD file. However, the unused blocks are still being included in the output file. Has anyone else experienced this issue and/or found a way to resolve it? Could it be an issue with my template file? Below is the information I found about this writer feature in the FME Documentation.PURGEThis directive can be used to turn on/off purging of unused objects or entities before the final drawing file is written out. Unused objects are those which are not referenced by other objects in the drawing. For example, for a layer to be eligible to be purged, there must be no entities on that layer. If turned on, the AutoCAD Writer will attemp
Hey Everyone,My group has a number of dwg files that are multi-vector diagrams of a structure. The final output would be a GDB environment. Writing to a GDB is easy enough but there is no coordinate information attached to it. The template is meant to be placed anywhere we desire on the planet. If there was a center point in the middle of the multiple vectors, is it possible to have FME reference everything to the coordinates point that are supplied by the user?
I need to write attributes in a custom tab, basically like any of the blue tabs that can be seen here:(the viewer used is Solibri MV; the model is the top example found here: http://www.ifcwiki.org/index.php?title=KIT_IFC_Examples ). I've tried the AttributeCreator, but the property set doesn't even get written. The method however does work, as standard properties like Identity Data do end up in the IFC:I also tried the IFCPropertySetDefinitionCreator, but this doesn't produce any empty propety set either (nor do I know how to write values to it). Can FME even write custom attributes?
Hi there, is it possible to use the pointcloud filter transformer with a a componenttype = string? I have a pointcloud (csv) with a component (RCx) that contains numeric values but there are also "N/A" string values (Nodata) in this component. In the pointcloud filter a made the expression "@Component(RCx) == N/A" but its not working. Has anyone an idea how to filter thes Nodata values with a pointcloudfilter expression?
Hi, I would like to know hot to define the texts beginnig and end.I have got : Attribute: Adressen_kalkuliert_drop_loc D-L-143245-143245-F-45--1xMICRO-DUCT-12x10-6MMD-F-422-F-471--1xMICRO-DUCT-12x10-6MM(a tousands of them) and need to define Attribute Value: L-143245 (from the first one) andF-422 (from the second one) the texts are always different, and have a different number of numbersBut beginns alway with "F", or "L" and ends always with "-" behind the number. thanks
Hi,I am new to FME and I try to generate several PDFs with map-content at once.I am struggeling with the creation of a dynamic scale bar. My Inputdataset is a Shapefile with a lot of polygons I want to iterate through. I need to zoom on every single feature and generate a PDF (for every single feature). Because of big differences in the size of the features, a static scalebar-Image would be no Option.Im thinking about a pythonscript to fill a mxd-template and generate the pdf with arcpy.Is there no fme-way to solve the whole problem without a workaround?Furthermore it would be great to zoom in steps to even scales.Thank u very much
Hi Everybody,I need to configure my shapefile output with No fill Color and Outline Color red automatically. How make this?Thank´s
I have an input excel file that is the source some HTTP calls are made to fill in columns in the spreadsheet using a template file and a defined output file overwritten. It runs in workbench but fails when published with an error that I can't locate the function or () it is complaining about. I have searched the error log for the text in the error and can't find a parameter with out a ()?Function `XLSXW_OUT_TEMPLATEFILE_XLSXW_1' must be called with any parameters enclosed in ( ), even if there are none Some details are:FME Server 2016.0.1.1 - Build 16177 - win32 Copyright (c) 1994 - 2016, Safe Software Inc.Direct Url Examplehttp://CODC1ITS8SGS984:8080/fmedatadownload/fmeservices/rlc_routecm2rpt.fmw?ExcelAnswerrtcm2rpt=G%3A%5CRFWorkspace%5Crlcupload%5CrlcUpload1Answer.xlsx&ExcelInputrtcm2rpt=G%3A%5CRFWorkspace%5Crlclrs%5CrlcUpload1.xlsx&RLCExcelTemplateFile=G%3A%5CRFWorkspace%5CrlcTemplateFile%5CrlcUpload1Template.xlsx&opt_showresult=false&opt_servicemode=as
Hi,I have a set of PDF survey templates that I have written a workspace for to extract the infilled data from. I want to be able to add individual readers for each PDF to keep each survey separate. However when i select multiple files, even when individual feature types are selected it still only inserts one reader.Has anyone any ideas how to make FME add multiple readers, one for each PDF?Thanks in advance :)
Hi everyone So I've come across a weird issue. When ever I try to overwrite polygons on ArcGIS online using the ArcGIS Online Writer with the truncate option set to Yes I get a weird error saying something likeArcGIS Online Feature Service Writer: Could not connect to server. Check that you are connected to the internet and that no firewall is blocking outbound connections. The error was 'HTTPSConnectionPool(host='services1.arcgis.com', port=443): Max retries exceeded with url: (HERE IS MY PRIVATE LINK TO THE FEATURE SERVICE AND TOKEN INFORMATION SO I TOOK THAT PART OUT) (Caused by ProtocolError('Connection aborted.', error(10053, 'An established connection was aborted by the software in your host machine')))' A fatal error has occurred. Check the logfile above for details Points go in fine. Polygons go in fine the first time (Where the Feature Layer and the Feature Service don't exists....it creates them and sends in the data perfectly). But
I have an MXD that has all the layers (3 feature classes) reading from one file geodatabase. I would like FME to change the "Data Source" in the MXD from one geodatabase to another geodatabase. Can FME do this?Thanks
Is their a way to set my file geodatabase writer to comress itself somehow?
Hi All, I am trying to update an SDE featureclass with a list containing a selection of records in that featureclass. I'm a little stuck as to how I can update just the records in the list - there is only one field that requires updating in the featureclass. I feel I need to push the list into a parameter and have that parameter in the "SQL To Run Before Write" feature in the Writer.Does this sound feasible or am I off track with this one? I'm sure there's a few ways to do this.Any help with this would be appreciated.Cheers,Mike
FME Server 2019.0.0.1 Build 19246 - linux-x64, JavaScript Library Version 3I noticed that the datetime format of timeStarted and timeFinished returned by the FMEServer.runDataDonwlod function is "%Y-%m-%d %I:%M:%S" without %p (AM/PM).Since "%I" is in the range 00-12, you cannot get correct started/finished datetime in afternoon.This is the result from a quick test.Could you please investigate the format of these timestamp members?{ "serviceResponse" : { "statusInfo" : { "mode" : mode, "status" : status }, "fmeTransformationResult" : { "fmeServerResponse" : { "id" : id, "jobStatus" : status, "result" : result_string, "resultSuccess" : true_or_false, "serviceMsg" : msg, "serviceSuccess" : true_or_false, "timeRequested" : timestamp, "timeStarted" : timestamp, "timeFinished" : timestamp, "requesterResultPort" :