Using readers and writers to extract and load data.
Recently active
I have a CSV file that is downloaded from a source that I cannot edit. The CSV that is exported contains a character ("?") in its file name which results in FME (I'm using 2019.2.3) failing to read the file. Ultimately this workspace will run on FME Server and will access this CSV from an email that it receives.The filename is FILE_(?)_FILE.csv and this flags an error in FME Desktop (which I expect will be replicated on FME Server) on attempting to load the data into the workspace:CSV reader: Failed to open file 'C:\\FILE_(?)_FILE.csv' for reading. Please ensure that the file exists and you have sufficient privileges to read itIt looks like FME is incorrectly interpreting the file name string and is obviously then unable to find it.An obvious solution is to ask the end user to remove the "?" symbol from the file name before running the workspace but this is prone to error and I would much rather handle it in the FME workspace itself. Is this possible?Th
I'm having difficulties writing out the intensity of my point cloud pts after thinning them.I see the intensity in the XYZ input but can't see how to write it out.
Hello,I tested the solution proposed here to convert shp to dwg : https://knowledge.safe.com/articles/18703/how-to-convert-shp-to-dwg-esri-shapefile-to-autoca.htmlWhen I open the dwg in CAO software, I no longer have the attributes associated with the objects.Which transformers should be used for this ?Thanks you,
Hi - Does anyone have some pointers on how to handle special characters in layer names against ArcGIS Online when using the in-built writers?e.g. I have a layer on ArcGIS Online called Layer 1 (Addressing)FME changes this to Layer 1 _Addressing_ which in-turn will cause the transformation to fail.How does one handle this without changing the layer name as it has to be be this.Thanks
Is there a way to add fields from excel into a feature service field on ArcCollector?I'm hoping to take the items of a column on excel and place them in a form for their related attribute.i.e. fill in a field on multiple forms in an ArcCollector project using excel
I am having an issues listing the contents of a google drive folder. First I receive this warning "Google Drive: SSL certificate verification failed for host 'www.googleapis.com'. HTTPS connections may not be secure. Disabling verification of SSL certificates. Message: HTTPSConnectionPool(host='www.googleapis.com', port=443): Max retries exceeded with url: /drive/v3/files/14VXm0wlvHZuW9tkS46VAWE1MYeIJpkAP?fields=id%2Cname%2CmimeType%2Csize%2CwebViewLink%2CmodifiedTime%2Cparents&prettyPrint=false (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1051)" Then the translation continues and I receive this error:"ile "C:\Program Files\FME\python\requests\models.py", line 940, in raise_for_status raise HTTPError(http_error_msg, response=self)requests.exceptions.HTTPError: 400 Client Error: Bad Request for url:" click on the url in the python error and I recieve this message"{"error
Hi all, i need read "extended elements". And in reader dgn 8i i don´t see anything to read tihis elements. also when i read this dgn, this elements appear moved respect i read this file in microstation. You could see this in the captures. what can i do to read this well.microstationRead in fme with the "dgn v8" reader
HelloI could extract the IfcRelSpaceBoundary using the Deprecated reader. However, it doesn't have any geometry. There is an attribute (Connection geometry) which refers to the instance_name of the related geometry but I can't retrieve this geometry. Is there any way to extract the geometry of IfcRelSpaceBoundary in FME? @daveatsafe
Hi all, I am trying to make a .shp from the areas with a minimum slope (DEM). The picture shows the output of the RasterSlopeCalculator (its about areas around water). I need to find a way to identify the transitional value of slope where the colour white turns to black, and then filter out the black areas. If someone has an idea, or knows if this is even possible, please let me know! :) Thanks.
In Esri ArcGIS (AGOL) feature service writer, there is an option to view written data in fme.How can I access these written features in python ?
Hi!I´m trying to load a polygon layer (buildings) from a shapefile to a Smallworld Database and I got the following error message at the end of the process:“Smallworld Translator Error: Value 5848495342526991361 out of range for field new_key”I have done this before without any problem. Can you hlp me, please?Regards.
Hi! I have an Excel file with ID numbers of different train stops, 20 of them. I wanted to find all DWG files that are in the subfolder Z\\Modell\\.*03.dwg but it takes around 1 h to run, at this point is it faster just to find them manually and run the workspace. Is there any way to improve the search time? The "root" folder is a drive, but all files are within a folder is called "4\\_CAD" so I limit the search to only the subfolders of my starting folder. Trying to make it faster my only use the subfolder I know contain the other folders and files.I was thinking maybe change it to have 2 feature writers after eachother instead, one that only searches for the correct folder then look for the files within the found folders. Change allowed path type to only folders then only files. Other suggestions?Also I figured if I have 60 subfolders, for every feature read it will look in all 60 of them 20 times over, that's probably why it takes such a long time, is there a
Hello, I am new to this software, i have a bunch of KML Files that i have been successfully been able to edit. However when i go to run the software it combines them into the same file, is there a way to have the same number of output files as input? i.e. save individually not combine them
Working in a company with a variety of software packages, I have been tasked with making an unusual MapInfo layer available as read only in QGIS. The difficulty is that a lot of the data on the MapInfo layer has been added as text direct to the map, with a variety of font colours, rather than being held in the attributes table and applied as labels.Is there a way to convert the MapInfo layer into rasta layer to view in QGIS, almost as a photo of how it would appear in MapInfo?Thank you
i want to copy the first sheet that include name and number to new excel sheet and rename it to Roads and copy the second sheet to sheet called details and i want to add another sheet ,output of fme but i got it from another excel .so at the end i want to get 3 sheets ,roads,detail,result i did static calculator for the third sheet and get my output but from another excel so i should have three sheets in result excel two from roads and one output of fmebut my output from work space ,i want to change it to blank page and write my output ,looks like the another sheets. my filesThanks for help
Hi, I encounter the following problem with the XLSXWriter : When I have a TEST.fomula containing accents (for exemple é or É), the formula is not written in my output file.The following formula for example : =IFERROR(SEARCH(CONCATENATE("/";B@Value(LIGNE);"/");W@Value(LIGNE));"PAS TROUVÉ")Note : I do have a 2nd attribute called TEST, in addition to the TEST.formula attribute containing the formula.Any idea how to solve this and get my accent in the Excel output ?
Hi all,A very dumb question: below part gives me what I wanted which is to copy a file from a folder to another location. But how do I control the sequence so that this part is executed first, and then go to other part of the scripts. I meant both "Path" and "FileCopy" don't have a connector (to connect to previous step or to the next step after these are done).
I am creating a tool to clip a dataset (ESRI FGDB with multiple feature classes) then write the data to a dwg file with the following:1 - any point feature with a block name in the attributes to the corresponding block in the Template file.2 - any point feature without a block name in the attributes to be an ACAD point in the layer specified in the attributes3 - any line feature to be a 3d polyline / 3d line in the layer specified in the attributes.So far i have been able to achieve each of these separately but cannot get the required output in a single file.Sample workspace below:Below is an example output:Red arrow - shows the line represented as a block --> this needs to be a 3dpoly or lineGreen Square - shows the block attribute for the point with block value in attributes. --> this is correct
if only the machine is working i mean in case of Y make table 1 in the 3rd row in sheet called machine and include only in the table machine and working column if working no ,make second table under last row in the first table 7 rows down and also make new sheet called amountit will has table year and amount columns if the machine working is yThanks in advance
Hi,One of my FME projects is 90% done. The only thing that's stopping me from completing it (and putting it into automation) is the issue that I'm having with excel reader. FME seems giving me errors sometimes (not always) at the excel reader (Feature Reader) (which reads an excel file from our own Share Point site). It works fine if I go to the SharePoint site by myself before running the script (or poke around the transformers either by parameters button, or containing folders button, etc.), which for me it indicates the problem is about the access to the file/site. But how do I mitigate this problem. Can someone please help? Thanks.
Hi, I want to access the property sets a of a dwg in FME.I enabled the 'Civil 3D and CAD Entities' option in the Schema Mode of the Civil 3D Reader.When i attach an inspector to the reader, I get a fatal error.AutoCAD Reader: An error occurred for dataset 'C:\\Users\\wisbeja\\Documents\\AWV\\FME voor dataconversie DAVIE\\voorbeeld data\\DWG solid and prop set\\small_test.dwg', in function AutoCAD2004Reader::read. Exception thrown: 'Invalid ResBuf' (Invalid ResBuf)A fatal error has occurred. Check the logfile above for detailsdwg file is attached.When I read the dwg with a dxf/dwg reader the inspector works. But I guess I am not able to access the property sets with this reader. Any suggestions? Jasper
Unable to correctly convert DGN which contains MicroStation traditional curves and Bspline curves. The resulted curves are stroked incorrectly. What is needed that stroked line follows curves more accurate. The undocumented parameter for dgn reader "Number of interpolated curve vertices" works for curves but not for Bsplines.DGN reader :: Result is not as expected
I have a workbench to look at changes between a new worksheet and an old worksheet. These data populate three tabs in a workbook: "changed", "deleted", "updated". The intial run populated the deleted tab with a few records that had been deleted. I re-ran the workbench with matching data and the "deleted data" remained on the deleted tab. I would like the data on the tabs to be overwritten each time.
Hello all,Does anyone know how to determine if a layer in an autocad file is frozen in a viewport?I need to determine if model_space features are visible in a particular viewport. I have done this by reprojecting the viewport's geometry to model space and then testing if it contains the feature. This works well, however in autocad you can freeze a layer in a viewport, in which case that layer is not drawn in that viewport and I need to account for this. I can see the features have an "autocad_layer_frozen" attribute, however this seems to define if the layer as whole is frozen not if it is frozen in a particular viewport.The viewport's extended_data_list list include's the frozen layer's name: In this case "LSSA-DIST_ANNO". However I don't know how to parse the extended_data_list.I could just search the entire extended_data_list for the layer's name, however I am worried that there may be cases where the layer's name appears in the exten
I want to export some data to gml, and I see that I have some complex geometries, which results in different sets of coordinates for each polygon (after geometry extractor). I made a list and each element within the list contains the set of coordinates for each segment of the geometry, but not all the polygons have the extra dimensions. Therefore, I want to make an if-statement where only the extra xml-statement is shown when there is data in the list. I tried using this, but it does not work. Can anybody point out an error in the statement.Not only the line with the statement posList..., but also the other statements around them, I want to delete when the list element is not existing. If there is another way of doing this (e.g. with a loop), I am open to suggestions. </gml:exterior> If {(fme:has-attribute("interior_xy_l{0}.part")) then ( <gml:exterior> <gml:LinearRing> <gml:posList&g