Using readers and writers to extract and load data.
Recently active
Hello,I am trying to convert a DWG file with 12 separate solids to OBJ or DAE. The conversion is perfect, but the output is 12 separate files - is there a way to convert it into one OBJ file?I have just found another problem I can't resolve - in AutoCAD I have 6 layers, 2 solids in each layer. would it be possible to export each element as a separate object? (they are grouped) I would be grateful for some help ;)best regards
Hi experts,I had went through all the log files generated by the FME server but could not locate a log file that I could identify the following:1. Which user had logged on and hopefully include the duration.2. What had the user done in the server.Are there ways for me to obtain such information?Thanks.
Hi all,I am a FME begginer trying to load data into a Vertica DB.I am using the JDBC Writer to create table and load data. Table creation works perfectly, but then data are not loading, :JDBC Writer: Connected to 'Vertica Database' version '08.01.0001' using driver 'vertica.jar' version '08.01.0107' built against JDBC version '4.0'JDBC Writer: Connection class 'com.vertica.jdbc.VerticaJdbc4ConnectionImpl' is being loaded from '/C:/Program Files/FME/jre/lib/ext/vertica-jdbc-8.1.1-7.jar'JDBC Writer: Committing feature 0JDBC Writer: Creating table using SQL: CREATE TABLE "bi_core_staging"."events" ("Geometry_AreaInSquareMeters" double precision, "SeasonFieldId" integer, "Source_CallerLineNumber" integer, "Context_User__id" integer, "DateTime" timestamp, "EventType_ProtocolVersion" integer, "FieldExtIds__" date, "FieldId" inte
Does anyone have experience modifying a replica or version of a ArcSDE geodatabase in FME? After I make the necessary edits in FME, and write out to a new file geodatabase, Arc no longer recognizes that the newly created geodatabase is a replica to synchronize and reconcile with the original SDE.
Hi, we searching for a way to read or write .vwx VectorWorks Project Files. Is there a way with FME?
I'm trying to join a Shapefile to another table, but it fails.The joining attribute(encoded: utf-8) has value "41400562015" but during the prozessing it becomes "41400562015????????????????????????"I tried to change the attributetype of both fields into different types, including integer or varchar (12) - but the resulting string is still longer than 12 digits?... I also tried to calculate the string (left 12) into a new attribut or to use the trim-funktion. Nothing works?not to be misleading: the original connection attribute on both sides is a textstring like "BT-4209-0001-2018". No blancs.But the joining failed and i detected something like "BT-4209-0001-2018 ___________ " with empty spaces at the endBecause the connection with strings did not work, i changed it into numbers, so joining in FeatureMerger or InlineJoiner should be . (I have done the same connections thousands of times, thes
Hi, I'm wondering if there is a way to reconnect to a (sql server) DB if a connection problem has occurred. Here's our situation: Sometimes, very rarely, we are unable to connect to our SQL Server DB. It may work for 10 days straight, and then it fails one single time and will work again for a unknown timespan. The error message looks like the SQL Server is down (or the connection attempt is corrupted on it's way through our network):2018-03-21 07:01:18| 1.2| 0.0|ERROR |Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147155559'. The error message from ArcObjects is: {Failure to access the DBMS server} 2018-03-21 07:01:18| 1.2| 0.0|ERROR |Please ensure the connection parameters are correct (server=`......) 2018-03-21 07:01:18| 1.2| 0.0|ERROR |A fatal error has occurred. Check the logfile above for detailsWe've created a test environment where we run a FME job, which starts and connects to the DB, every single minute and
I have an autocad file with blocks that have rotation angles (flow arrows for example). I need to translate to igds and retatin the angle.
I am looking to use FME to load some data from a file geodatabase into an existing ArcSDE geodatabase feature class. I had done this in an older version of Desktop but can't figure out how to point the writer at an existing featureclass.
I am trying to access the GEOM column from a MSSQL 2012 Database using FME 2017. I have tried with the ADO, JDBC_Nonspatial und Spatial drivers. In table-view the column GEOM is never exposed. Do I have to manually expose the geometry column? If so, how?
Hi, I'm a Master's student using FME Workbench for my thesis project, and I'm using the Cesium 3D Tiles writer to convert CityGML files into Cesium 3D Tilesets. I am curious how the writer determines which features should go into which tiles? The Cesium 3D Tiles spec states that tiles are loaded roughly by distance to the camera; however, when I convert a large CityGML dataset to a 3D Tiles dataset, the writer scatters features over a large geographical area rather than clustering them together based on spatial location. I was also wondering how the writer calculates the bounding volume property of 3D tiles, as the bounding volume shows up as a very large box tilted at an angle. I would appreciate any insight anyone might have on how the 3D Tiles writer determines bounding volumes and how it determines which features are assigned to which tile. Thanks!
I am trying to update fields in a feature class that is attached to a geometric network. The feature class that I am writing to is a point geometry that is attached in the network to one end of a line. The error message is this: Error while updating feature in the table/feature class 'SDE.wServiceConnection'. The error number from ArcObjects is: '-2147217384'. The error message from ArcObjects is: {} I found a possible definition of the error online: (-2147217384) FDO_E_INVALID_CONNECTION_POINT_GEOMETRYThe geometry for a complex junction point is invalid.It appears that the issue is that my workspace errors out when the line length is less that 0.01 foot. I have tested this by finding one that erred out and then lengthening the line and rerunning the workspace with success. While there are only a handful of these in the feature class and they could be manually fixed, this workspace runs as a scheduled task and therein lies the problem. I wouldn't know when it err
I am running a simple read GDB Write GDB and adding a UUID in the process. I am getting this Error (-3). The source is a 3D line file 60K lines long and has four fields. (survey data). I've rerun the script several times and the error halts writing at different locations in the file.
The current way to convert revit files is to generate rvz files through ifc, but this process is very long and often not successful. Before I saw the official plan to do an exporter specifically for revit, but it seems that it has been a year and I wonder if the plugin will be released in the near future. Thank you.
Why does the shape file reader truncate the names attributes to 10 characters on loading / inserting the reader? I have fme version (FME(R) 2018.0.0.1 (20180328 - Build 18295 - WIN64)) installed.
Hi,Can someone please help me load this XLM file to FME?I am new to this tool and trying to convert this XML to Excel.
I'm trying to expose attribute only 'fill-opacity' from the below json.{"type":"FeatureCollection","features":[{"geometry":{"type":"Polygon","coordinates":[[[-81.0007,29.2057],[-81.0055,29.2029],[-81.0105,29.205],[-81.0107,29.2097],[-81.0059,29.2125],[-81.0009,29.2104],[-81.0007,29.2057]]]},"type":"Feature","properties":{"stroke-opacity":0.9,"fill-opacity":0.9,"hail_size_in_int":0.5,"hail_size_in":"0.5-0.9 inches","stroke-width":0,"fill":"#FFFFC0"}}]}It returns blank values. Can someone please help me ?
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