FME Form

Hi all, I have been given a csv file containing a GeoSpan column representing line data. Any idea how I read this into FME and create the geometry from the GeoSpan? ThanksN

I have a large number of text files of traffic count locations that contain both header information with necessary attribute fields and 2 fixed width sets of data that I also need to bring in as attributes. I am looking to ultimately create a table where the info from each text file is one row/feature in the table so I can join it to an existing point feature class with the Reference Number being the join field. I could do multiple tables if I have to also. I can't seem to figure out a good way to get both the Header attributes as well as the fixed width attributes.  A sample of one of the text files:They are actually .tam, .tpm and .tms files (no idea what those file formats actually are and google was not really any help) but they can be read as .txt files. I have attached one that I saved as a .txt as a sample

Supports geolocation the new application for Android?

Hi folks, I was wondering, is there a way to intentionally write to FME's temp location?  I want to create a workbench that's portable and needs to write a lot of scratch data using a few workbench-runners (deleted at the end of the process).  Is it possible to intentionally write to it? There doesn't seem to be anything on http://fmepedia.safe.com/articles/FAQ/FME-TEMP-environment-variable . I've done some testing:  - %FME_TEMP% as the destination just means FME creates a directory called that. - <FMEDrive> in various guises just results in a workbench crash. - Not specifying a directory means that FME writes the file to wherever the workbench is saved. Only if it's an unsaved (new) workbench will this be the fme_temp directory itself.  Thoughts? Is this even possible? I'd prefer not to have to hard-code somewhere, or even bother with a user parameter.  Cheers, Jonathan

In the MapnikRasterizer settings, in the Raster Properties section, it is necessary to specify the number of columns and rows of the output raster.  When I enter this information manually, there is no problem. When I want these parameters to be filled in dynamically, i.e. using the number of columns and rows of the input raster (using a RasterPropertyExtractor beforehand to access the attributes), I get this error message:"MapnikRasterizer_2 (MapnikFactory): No values were specified for either NUM_ROWS and NUM_COLUMNS, or SPACING. One or the other must be specifiedMapnikRasterizer_2 (MapnikFactory): A fatal error has occurred. Check the logfile above for detailsAttributeManager_OUTPUT_-1_84_Player (RecorderFactory): A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for details". The number of columns and rows in the input raster are 32 bit unsigned integer. When I converted it to 64 bit integer via the Attribute

Hi. I would need to deal with a completely banal thing, but I'm stuck. I need to load this excel, but only the first line of attributes reads it to me on the reader. I need to load all the attribute rows. Nowhere in the settings can I find where I'm making a mistake. I would also need the first row to be already an attribute and not a column name.Thank you very much

Hello!I have a json text which I got from airtable HttpCaller.I want to read the attributes as normal attributes, and I have some hard time with that.I think I know what should I do:Format it, and then expose the attributes with JSONFragmenterBut It does not enter the attributes into my fileds:What should I do?I tried to do a lot of variations in the JSON Query, but noting helped.. I attached here the work sample..Thanks you all!

Hi I'm trying to download data from Ordnance Survey using their API. I've got this working successfully but the downloaded files do not have their correct filenames.  I've used JSONfragmenter to create a column called "url" for the download location and another called "fileName" for the filename. Can anyone help explain how I can rename the downloads with the name from fileName please? ThanksRob

 I have a basic list of guids to iterate over and get the related object, append to another list, then use in a function as one of the arguments. Here is my script:import fmeimport fmeobjectsimport uuidimport timeimport tempfileimport ifcopenshell class FeatureProcessor(object):        def input(self, feature):                create_guid = lambda: ifcopenshell.guid.compress(uuid.uuid1().hex)                 # Obtain references to master file        filename = FME_MacroValues['OUTPUT_FILE_PATH']        ifcfile = ifcopenshell.open(filename)                owner_history = ifcfile.by_type("IfcOwnerHistory")[0]        building_storey = ifcfile.by_guid(feature.getAttribute('storey_guid'))                   guids = feature.getAttribute('_guids{}._guid')               guids = [ifcfile.by_guid(x) for x in guids]                   # Relate the wall to the building storey        ifcfile.createIfcRelContainedInSpatialStructure(create_guid(), owner_history, "Building Storey Container", None, guids,

I'm trying to run a workspace in FME Server and I'm getting a message: "The workspace has Python Compatibility set to 'Esri ArcGIS Python 3.9' which requires ArcGIS Pro...." I have ArcGIS Pro installed. The workspace runs fine in FME Desktop.

Hi list.I have a dataset with mixed date/time formats in a single field.I want to create a cascade to transform these, i.e. "Try this format", and if it fails, "Try that format", etc.HOWEVER, when data are output on DateTimeConverter's rejected port (signalling a data error), the field value is cleared, rendering a cascaded approach impossible. Why is that ??Is there a way to avoid this unwarranted nulling of a possible valid field value ?Cheers.

Can anyone advise the most efficient way to bulk extract attribute string lengths?

I've used the AUTOCAD_OD Reader to get the table and Attribute Manager to add the column and this seems to work. I've even output to an Excel spreadsheet to see that the column has been added, but I can't figure out how to get the change back to the Original drawing. Any suggestions are appreciated.

I'm trying to create a conditional parameter value in a WorkspaceRunner, based on an attribute value. I can do this, as the WorkspaceRunner is allowing me to fill in conditional values for the parameters, however, every time I click OK and reopen my WorkspaceRunner, all these conditional values are reset and again replaced by their hard coded values, as read from the model that the WorkspaceRunner is calling.Is there a reason for this behaviour or is this just a bug?I'm using FME 2018.1 build 18547 WIN64.

Hello, I am looking for the equivalent to the "Append Fields" tool in Alteryx, where many rows from one table are replicated for each row of another table. For example:Table 1:Table 2:Target Table:I've searched and experimented, but can't seem to sort it out in FME. Any advice? Thanks!

I have an FTP Caller that keeps throwing the error: FTPCaller (FTPFactory): FTP info: Failure establishing ssh session: -43, Failed getting bannerFTPCaller (FTPFactory): FTP info: Closing connection 0FTPCaller (FTPFactory): HTTP/FTP transfer error: 'Failed initialization' I can access the file on the ftp site using other ftp clients, and I have tried different configurations of the FTPCaller but I can't get this to work and I can't find much info on the error. Has anyone seen this before? Thanks!

I have multiple tables and need to check if their schemas conform to specs which are specified in text files containing field names separated by line breaks. How can I compare if the field names are mapped correctly?

Hello!I have a challenging work to do. I have 3 differents vectors data (DataVector1, DataVector2 and DataVector3 ) which i've extracted from a pdf file. And, I have also from the same pdf file, the location of the three Datavectors (boundaries). The boundaries is also a vector data that i've extracted from the pdf. However, the boundaries boxes are smaller compared to the limit boundaries of the Datavectors. Now, I need to scale and shift all my 3 Datavectors into the boundaries boxes. How can i do this ? knowing that the coordinates are in local values ( fake coordinates from PDF). After that, I'll do a manual georeferencing, since I know real coordinates of 3 points over the whole 3 Datavectors.Anybody, have some hints ? Thank you in advance !

At first you get the warning: 2022-06-08 09:00:12|  1.4| 0.0|INFORM|Creating reader for format: Oracle Spatial Object2022-06-08 09:00:12|  1.5| 0.0|INFORM|Performing query against ORACLE_SPATIAL dataset ` ----'2022-06-08 09:00:12|  1.5| 0.0|INFORM|ORACLE Reader: Using Oracle Reader to read tables from database `', server type `ORACLE8i', server name `----', user name `----, password `***'2022-06-08 09:00:12|  1.5| 0.0|INFORM|ORACLE Reader: Using Rich geometry.2022-06-08 09:00:12|  1.5| 0.0|INFORM|Loaded module 'OCI' from file 'OCI.dll'2022-06-08 09:00:12|  1.6| 0.1|INFORM|Environment variable ORACLE_HOME is not set.2022-06-08 09:00:12|  1.6| 0.0|INFORM|Connecting to ORACLE database `----' with user name of `----' and password of `***'2022-06-08 09:00:13|  1.6| 0.1|WARN |Error connecting to Oracle database: message was `ORA-01017: invalid username/password; logon denied'. (serverType=`ORACLE8i', serverName=`----', userName=`---

Hello,I have a georeferenced dwg file with lines, polygons and text that I'd like to convert to kml for view in Google Earth complete with the AutoCAD layers. I have been successful with creating a KML file that opens in Google Earth but still some problems. when viewing in FME Inspector everything except the text shows and the layers are missing. When I open the file in Google Earth only the points show and on the Places bar each object is shown on a long list, I want to see the layers like in Autocad and do not want to see the individual objetcsLooks very promising otherwise.Thanks

Hi,I'm using the TopologyBuilder to create relationships between water mains (the edges) and the valve furniture (the nodes). Our corporate GIS (Gwater, Oracle based) has an start and end node for each feature to show connectivity, but ARCGIS does not . These values do not exist and I have to create them to align the two GIS systems.So far the results have been good, as the corporate GIS feature can only connect to two other features. This doesn't happen in ArcGIS for one particular type of feature called a cross valve, which connects 4 mains pipes.I can find the 4 pipes a cross connects to, but not the direction in which they connect to create the east-west and south-north connectivity. There's nothing in the topologybuilder output which suggests this relationship:  I was wondering if I can use the spatial location of the pipes that the cross connects to to determine which one is easterly of the cross, westerly and so on:Any idea how this might be achieved? I can then use

I have set up a http caller with query string parameters. It would appear that the server throws a 500 error when its finished returning the records. Does not appear to affect results but would like to get rid of error.

I can not access views in my oracle DB neither with the oracle non-spatial reader nor with a SQLExecutor.Is there a workaround?The FME Help also talks uniquely about tables, never views.Oracle Non-Spatial Reader Parameters (safe.com)

Hello Sir / Madam,​I have many files (more than a hundred of files in .json format - text). I would like to extract certain text from each of the .json files and put all the text in a single text / csv file for further study.​I am just wondering if it is possible to do it on FME? Or what transformer I would use?​Here is what I really want to get for my report.​File name; errors number (spacing for "no error"; it could even better if I can output "no error" instead of spacing)​Output sample as follow:banana_report.json;102;203;204;303;305;306;307;a_report.json; ;​My .json file sample is uploaded for your reference. Basically, the information that I need is at the "all_errors: []"​Hope somebody would give me a hand on this issue. I am really appreciate that.​Thank you very much!​Zach

I have been trying to change a file extension from .bil into .flt based off this link https://community.safe.com/s/question/0D54Q000080hEslSAE/how-to-change-filename-extension-via-fmeBut I cant get the FeatureMerged to merge what am doing wrong?There will be other files and different file types in the same Folder so not sure yet, if this process/workflow will change the other files as this would not be desired.But for now I'm just trying to get the FeatureMerger to work.