Using readers and writers to extract and load data.
Recently active
Hello Guys, I am reading a csv file through a CSV Reader and loading the contents in another excel file placed at different location. Finally the source file is supposed to be moved to another location inside the same workbench but i am unable to do so with the help of FileCopy Writer as the CSV reader creates a lock on the file which doesn't allow its moving. It merely copies it without showing any error. Can anybody suggest an another way around?
I have a string af lines in a DXF with two vertices, top and bottom. What I need is an export to excel that shows top and bottom of the line X,Y,Z in order according to location. It's linework of a sheetwall scan. Customer needs an excel spreadsheet with X,Y,Z for top and bottom of the wall. My problem is I need it sorted/relabelled in some way first, as the lines are not drawn in order from end to end. Is there a way to sort, then export the lines in FME? Maybe by placement in x axis direction. I'm new to FME so it's a learning process for me :)
Hi allI´m working with a point cloud with the following schemax|y|gridnum|col0|col1|col2|.....|colN 10|22|121212|12|23|.....|234 10|22|121212|0|12|.....|234 The number of components will vary and I can´t tell a fixed numberAs output I want to remove the 0 values from the col(x) components 10|22|121212||12|.....|234I´m using an iterator to go through all the componentsUsing PointCloudFilter I´m achieving it but only with fixed components. I can also use a user parameter to set component. But again, I cannot update modify. As I cannot use attributes in PointCloudFilter, Is there any way to update the value of the user parameter dynamically within the workspace? I´ve also considered JobSubmitter but I don´t have FME Server....I think that an iterator is needed because I can´t say in advance how many components I will have.Thanks so much in advance
I want to have RGB color out put from Autodesk DWG file. After exposing fme_color attribute the output contains different value. e.g. AutoCAD Color Index(ACI) value 92 and after reading it in FME I get value of (0,0.65,0) . If you look in AutoCAD the value should be (0,165,0)
Yes - another XML question - however - taking the XML below - how do I extract the values just from the 'details_view' - i.e. I want the 'USER' data. I tried the flattening which could work, but I don't know how to differentiate between the two 'views'. <?xml version="1.0" encoding="utf-8" standalone="yes"?><file> <views> <view type="summary_view"> <nodes> <node> <properties> <property type="field_name">DATE_CREATED</property> <property type="field_data" year="2019" month="3" day="12" hour="11" minute="21" second="52" millisecond="938" offsetMinutes="0" normalized="True">2019-03-12T11:21:52.938+00:00</property> </properties> </node> </nodes> </view> <view type="details_view"> <nodes> <node> <properties> &l
Can't find a clear answer on this - is there a way to read from AGOL and write all data including attachments to a local gdb? I found the bit about the dropdown to include attachment and expose as an attribute but this isn't really helping. Does anyone have guidance or a workbench they can send that brings this data through with the actual image or file attachments on the feature itself as it appears in AGOL?Thanks!
Hi, I would like to use a .dgnlib file in the DGNStyler when specifying the 'Cell Library File' but when I do this the translation fails. Does DGNStyler only work with the .cel files for the Cell Libararies? Is there any way to use a .dgnlib instead?Thanks,
Is there a work flow for reading only 1 feature data set in an esri geodatabse reader? I am trying to read only 1 feature dataset, not the entire esri geodatabse so that i can clip the polygons in this particular feature dataset
Good morning all, i am trying to work out how to get the mapinfo (mapinfo_extended, MITAB or MAPINFO) writer to output a .ind file. when writing to mapinfo i get dat, id, map and tab but not ind file. with the MITAB i have made sure that build optimal spatial index is YES but there appers to be no option for any of the mapinfro witters to produce a index file. cheers edit version, fme 2018.1.0.1 build 18528 win 32
Hi, I'm struggling with processing Geodatabase Attachments. My workflow takes polygon features with attachments, test for an attribute and then converts them to points. Pretty simple. However, keeping the attachments isn't working. I know there are other help examples using attachments but I'm not able to get this to work. My workflow and sample data is attached. If someone could please take a look and let me know what I'm missing?
I keep on getting this error: ArcGIS Online Feature Service Writer: Could not find a layer/table matching feature type 'count'What does it mean? How can I resolve it?
Using FME Desktop 2018.1.0.2 build 18547 - Win32 in Citrix environment and trying to upload a folder from enterprise file system to an Amazon S3 bucket. I have a simple creator connected to an S3Uploader transformer and an inspector. When I run the workspace in desktop it rejects the upload and gives an error. I can successfully read from the S3 bucket using S3ObjectLister so I know the credentials are working. Here is the logfile: Even tried running this from a local non-Citrix version of FME 2018.1 same build and get the same error.Also, when trying to upload a single file I get the same error.fme_rejection_code =0 ERROR_INVALID_REQUEST"java.lang.Exception: S3Uploader_<Rejected>: Termination Message: 'S3Uploader output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation''Translation FAILED with 4 error(s) a
@mmccart and I have noticed that Esri did something to how ArcGIS Desktop 10.6.1 (aka ArcMap) publishes services to ArcGIS Online. We have tested ArcGIS Pro 10.6.1 and ArcMap 10.5 and both are able to be written to with FME 2018.1 (18547). When trying to write to a service published from ArcMap 10.6.1, we get the following error:ArcGIS Online Feature Service Writer: Could not find a layer/table matching feature type 'LAYER_NAME'
Hello AllI could easily revert to my Python comfort zone but in the spirit of learning can anyone tell me the most FMEic way to extract Total Features, Add, Mods and Del attributes from the attached XML? Many thanks.
I am new to FME (my first post!). So, I am just playing around trying to learn the software a little (we are planning on using it to load a large amount of CAD data into GIS). I am using FME 2018.1 to write (insert) into one versioned feature class within a 10.2 esri SDE in Oracle. Everything looks fine when I look at the version in ArcMap. But I am getting an error at the end of the process.A BADNEWS error shows up in debug logging -- similar to the one in this post :https://knowledge.safe.com/questions/76727/error-running-translation-after-what-appears-to-be.html I am using FME 2018.1 32 bit on win 7 Suggestions?
Hi, I have a dwg file with layer names, is it possible to include this layernames as an attribute in a dgnv7 fiel? It is not possible to keep the layer names as a string in dgnv7, it needs to be a number. So now I try to include it as an attribute. It seams to be possible with tags in the dgnv8 format, but that is not supported in dgnv7. Anyone knows about this? Best/ Johan
I am trying to write to a file geodatabase and I need the strings stored as 8 bit characters. When I write to the gdb they being written as utf-16. I have tried using the attribute encoder to set the encoding to utf-8 but it still get written as utf-16. I am using a feature writer with the DEFAULTS keyword which should store text as utf-8 according to the documentation. Is there a way to enforce that text data be written as UTF8.Thanks
Hello FME guru's! I'm looking for a way to seperate a single page pdf with multiple layers so I can input a reduced raster dataset into Potrace to improve the vectorising results. Can anyone point me in the right direction?Pdf example here:
I am a new user to FME, I followed the Revit to Sketchup tutorial, but I am getting an errorISO10303-21: Unknown entity or type name 'ÐÏ'.ISO10303-21: Invalid file format, unable to continue readingA fatal error has occurred. Check the logfile above for detailsTranslation FAILED with 3 error(s) and 0 warning(s) (0 feature(s) output)Not sure the path forward, I cannot see any similar issues, and the tutorial does not address something like this.Thanks
When running the sheduled job in FME Server, we are encountering this error from time to time. Today, FME Server 2016 cannot connect to ArcGIS Online.ArcGIS Online Feature Service Writer: Encountered an unexpected error. The error code from the server was '403' and the message was: 'You do not have permissions to access this resource or perform this operation.'. Details: 'However, I tried running this in ArcGIS Desktop 2017.1 and it was able to connect and write the features to ArcGIS Online. I'm using the same ArcGIS Online account for both.
Hi all, I'm trying to query an API and convert a json file which contains nested geojson as a trip route. My final output is going to be a shapefile or feature class ESRI. I'd like to have each "route" associated with the trip_id, duration, distance etc.here is the response below, each route is a series of point files, I'm thinking I need to convert this to some sort of line to make this work. Any ideas? what I have so far:
hi ! is there anyone out there willing to show me tutorial or example on how to use the database updater transformer. im currently working on a project that need to use this transfromer. ive look into the help section but i dont quite understand how to use it. thnk you !
Hi all, I would like to building facade texturing from images.I've WallSurfaces and RoofSurfaces.But each WallSurfaces has own image jpeg file.And there are so many surfaces and images (~ 2000 maybe much more) .So how can i match between the surfaces and images?.How can i follow the right path? Could you help with this case? Thanks and Regards
HelloI am trying to create a point cloud with a string column. The value of the component depends on the value of another component. I am using PointCloudExpressionEvaluatot but this doesn´t allow string components. I could use PointCloudComponentAdder to create string components but it doesn´t work because it creates constant strings which is not what I need.For example:If I have the following PointCloud:x|y|gid|col0|col12653000|2565400|147729036548|0|2552654000|2565400|147729036548|0|12 I´d like this outputx|y|gid|col0|col12653000|2565400|147729036548|0|2654000|2565400|147729036548|0|12Replacing 255 with empty string I am using FeatureReader and String concatenator but it´s very slow for about 200millionpoints Any help woud be appreciatedThanksOskar
I've tried to export a las file to 3dtiles (i.e., a pnts file) with fme, but the color was missing afterward in cesium. I could not find that I can choose to include RGB or something like that. What am I doing wrong?