Best Answers

Hello, I'm trying to download a series of excel files that are on a website. There is a starting date of 9/19/2005 (its hyperlinked for each excel file) and it increments by 7 days (so its a page fill of hyperlinked dates). I'm guessing I need to create a list of all dates starting from 9/19/2005 so that I can use httpcaller to download each file. I'm having trouble creating the starting date so that I can use DateTimeConverter to create the range (and consequently create the full url's to each file). I tried using AttrubuteCreator with a new value of DateTimeCreate(2005,09,19) but this expression errors.Thoughts on this and I'm all ears if there is a cleaner approach. Thanks in advance

I have a CSV file where I need to read only the first line (or first column/line combo) of the file. Is there an easy way to do this with a reader? Or am I stuck reading the whole file? I've tried both the CSV reader and Text File reader. In both, I don't see anyway of isolating this first line of text/data. I'm forced to bring the entire table into the workspace. Thanks in advance!-Mark

When I make a GET request to /transformations/jobs/completed there are two objects returned that both include a 'status' element; the Job and the Result object. What are the differences between these two?Second, what status values can be returned and how are they defined?

Hello everyone.I have a .dwg file including substructure data of an area. I'm studying on creation a 3D city model with virtulacityPUBLISHER. To be able to create this, I'm transforming dwg file into a geojson file format via "bufferer" transformer (Buffer Type: Solid). But solid type creating a semi-sphere at the end of the line. And then, generating surfaces which consist of 6n^2 faces. If we think about an awful a lot details for all substructure details (e.g. gas or water tubes, cables etc.) it will be too much surfaces to publish (with a web browser interface) for a city model. So, how can i simplify the lines (especially end of the lines) which is using for creating goejson file types.Thanks.

Hello community,I'm trying to call the REST API in ajax from another application. In this call, I do a POST request to submit a workspace. The call works fine in Postman and I get a job id in return. However in the response headers, I only get the following parameters: Content-Length, Content-Type and Date. For the purpose of my application, I also need the Access-Control-Allow-Origin in the response headers.Any idea how I can make that happen?version used: FME server 19.1 over https (port 8443)Thanks in advance

Hi,  I am trying to build a workbench that performs certain checks irrespectively of the Input data. That means that it must accept data with different data types (.shp, .mdb...) and schemes (e.g. different attribute names and types). As far as I know, a generic dynamic reader is what I need. So I inserted one and tested it. Although this reader reads the (spatial) data and shows its polygons in the inspector, the attributes are lost. Instead of the original attributes, there is only one row in the table with the header <no schema>. In the feature information part of the inspector, however, the attributes are still listed. Since I want to write a log file including all the errors found by the checker, the attributes are important. What do I need to do, so that I can access the attributes of the generic dynamic reader?   Best regards André

Hello,I have summary output coming from the StatisticsCalculator that I would like to rearrange such that row values become column headings with values for these coming from the statscalc count output (see input and end result images below). I've tried AttributePivoter, AttributeTransposer without success.Thanks.Tony

 i have network of many lines in the map and i want to define start point from one line of different lines then i want to flow in each direction till the end as picture abovestart point will start then go in the first direction but it will find first intersection point with 3 directon so go one by one as example then it finds second intersection point with 3 direction then fo in first line till reach end line 1 and give me the coordinate of the last point (last vertices 1 ) then come bk to second intersection point and continue in the second line but it finds the third intersection point so go till end line 2 and extract vertices then come bk to third intersection point and go to end line 3 and extract vertices then come bk to second intersection point and go to last direct ion till end line 4 and give me coordintaes of last point and after finish it return back to the first intersection point and till reach end line 5 and so on . at the end i want to check the end coordinates of each

I am trying to setup a job in FME that reads a CSV file where the filename changes daily. The filename looks like this HHSVENDORS_02242020.txt. The HHSVENDORDS_ is always the same, but then it has the date appended in the format MMDDYYYY. Is there a way to dynamically create/read the input filename on a CSV reader? So when the job runs each evening, it will pull the correct file.

Hello!I would like to make a test on my datas. These are points , that have a _pontID and there is a _MIN, MAX and _MEAN values. I want to filter those points where _pontID = _MIN and _pontID = _MAX_uj and _pontID = _mean_pontssz. The problem is that the query only gives back the right solution with _MIN. Here is the definition:The values are like:Can you help me, what can be wrong?

Hi everyone, I'm currently updating some FME Workspaces from Python 2.7 to Python 3.6.The workspaces have a private parameter containing a python script which imports arcpy and reads data from a SDE DB. The first transformer is a feature reader which reads features from an arcGIS Server (10.7.1) in my organization.The python script containd in the private parameter is executed successfully.The workspace fails when executing the feature reader with following log : Loaded Python module `arcgisonlinefeatures' from file `C:\Program Files\FME\python\python36\arcgisonlinefeatures\__init__.pyc'Python Exception <ModuleNotFoundError>: No module named '_socket'Could not create Python Reader `ARCGISFEATURES'A fatal error has occurred. Check the logfile above for detailsThe python interpreter is set to use the dll installed with ArcGIS Pro : C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\python36.dll. the python home in the fme options is left blank.The python compatibility is set

Hello. So I'm currently having an issue with the excel reader and I'm not sure I'm missing something. If I drag and drop or add the dataset to the workspace and configure it, it will read correctly. In this case, I want it to start reading the data from row 6 (1 to 5 are the header) and go from there. This works for the initial file, but if I change the source data to pick up a different file with the exact same format, the settings are somehow reset and it starts reading from row 1, resulting in no attributes or features being read. I've tried updating the reader feature types and changing the Microsoft Excel Parameters for it, and while it works when inspecting the data, when I run it, it goes back to missing. What I need is to be able to feed different datasets into this reader but all with the same format, so there's no need for it to be dynamic. However I can't understand why the parameters only work for the first file it reads, despite it being fine when I

Hi Guys,i have excel file ,i want to make comparisonasif sum 1 < base A < sum 2 if yes ,so as give me the outputi want to check for every cell in base A is the value between sum1 and sum 2 in the each row or not .as example check the first cell of base A (65452 ) is between sum 1 and sum 2 at first row or not then continue to check 65452,first cell of base A with the second row of sum 1 and sum 2 or not . i want to check for each cell in base A ,if this value between sum1 and sum 2 for each row .after finish checking 65452 so start with 65438 and so on so it will check for each cell with 10 rows i want to do the same also for Base B ,if the value between sum 1 and sum 2 and if yes gives me output and continue check for this cell till the end till i finish with all field cells in base A and base B Thanks in advance FME version 2018 

Hello Team, Is arc SDE32 bit writer supports with FME Server 64 bit?, We have Arc SDE 10.1 with 32 bit and FME server 64bit with 32 and 64 bit engines installed in the same machine. Is it valid configuration to run a workspace?Thanks...

I need to transpose some of the attributes (with prefix "INTER"), but keep the other ones not transposed.Original data looks like this:The result should look like this:Except not transposed attributes should have values. Obviously AtributeExploder doesn't do the job in this case. How can it be done?

We have a DWG drawing where the arrow heads have been created as a block but the arrow heads are not coming into FME and hence I am not able to output the arrow heads to a PDF.   I have exploded the blocks into entities but still no luck. Is there a way to recreate the arrow heads when outputting to PDF or bringing the data in from the DWG.Attached is a sample drawing to help understand what I am trying to achieve.Any assistance would be appreciated.

I am trying to modify an existing workbench which reads features from an Oracle database using an SQLCreator and writes them to a feature class in a geodatabase. Currently there is a single query in the SQLCreator. I'm trying to add something to the output which requires a temporary table so I now need there to be three queries running in this SQLCreator:Create temp_table;Query to extract features from Oracle DB (and temp_table);Drop temp_table; Is it possible to run a series of queries in SQLCreator? If not is there some other way? The series of queries work fine when run directly against the database but I cannot get it to work in FME. My fallback is to create views in Oracle rather than using a temporary table but I'd rather not do that if I can avoid it. Thanks,Michael

Hello community, I'm quite new to fme and I've been stumbling on something that might be easier than i think. Basically i have a filled access database table and I'm trying to fit these filled records into a template table. This template has less column headers/attribute names than the source. I'm trying to get the values that do no longer have a place to be put into a string. I have managed that, however I'm trying to have this long string be readable by having the attribute value be preceeded by the attribute name. I'll give an example below: (sorry I'm currently only on mobile so writing it out is a bit harder)  OldFruits vegetables grains soup Apple cauliflower bread tomatosoup New:Fruits vegetables otherApple cauliflower grains: bread, soup: tomatosoup This is just an example. The real table has like 52 fields per records that has to fit into 30. I hope anyone can help me out.

I have a coarse raster where the pixel value indicates the number of points that should be generated within the confines of the pixel.  I have a fine raster (1 to 2 orders of magnitude higher resolution than coarse raster) where the pixel value indicates whether a point can be placed there. For simplicity purposes this can be a binary mask.  I would like to generate points according to these two rasters with the additional criteria of a minimum separation between points.  Thoughts on how to do this in an efficient manner? I'm hoping to avoid the brute force approach of generating a random point, checking the constraints and repeating until the desired number of points is reached.

 I have Oracle no spatial as a reader and when i am trying to read the coordinate ,i found the output is null and i have read many articles and i tried many hours but without any success . could someone help me ,how can i fix the problem for Geometry for Oracle non spatial  in inspector the output of oracle ,it looks like points and each point has his coordinate (x,y)  Thanks in advance

When trying to Batch Deploy my simple Geopackage files to AGOL the 'Next' button never gets possible. It wants a path to the files to be written. Is it not possible to use Batch Deploy to upload to AGOL or what am I missing?

When I try to write an ECW file of around 1 GB, I get the following error from the ECW writer:ECW writer: The ECWJP2 SDK only has 200.0 MB of memory allocated to it and this is not enough to compress this dataset. Please set the SDK's memory limit above 203.9 MBThat sounds fair enough. Does anyone know how to allocate more memory?Using FME Desktop 2019.2.

How to compare a series of tables across two databases? We use a setup that reads a .csv file that has two columns:- Column 1 is a query in database 1, and- Column 2 is a query in database 2Both queries should return the same and ordered list of values (basically, a list of identifiers) and are fed into an SQLExecutor. Both resulting streams are compared using a FeatureMerger, and the UnmergedRequestor and UnUsedSupplier ports report the features that are not present in both databases. This works nice for relatively small tables. If a table is queried that has more than a million records, performance drops. I solved this performance issue by using database readers. I specified the Number of Records To Fetch At A Time (ORACLE) and the Bulk Read Size (MSSQL) and set them so that 100.000 records are fetched each time. I could work this out using a WorkspaceRunner, however my question is: Where are these parameters on the SQLCreator/SQLExecutor transformers?Parameters available on the SQLE

I would like to use JSONTemplater to build nested text structers making use of the ROOT and SUB TEMPLATES but this are not valid JSON ... its  a Groovy syntax ... Beacause is not a valid JSON format the JSONTemplater gets offended and stops the translation. i cant find a way to skip the JSON validationsI tried disabling validation ,,, but nothing ... any alternatives ?   2020-02-21 17:22:01|   2.1|  0.0|WARN  |JSONTemplater(XMLTemplaterFactory): The following error occurred near line 1, column 11 of the query:2020-02-21 17:22:01|   2.1|  0.0|WARN  |JSONTemplater(XMLTemplaterFactory): invalid expression: syntax error, unexpected ExprSingle (missing comma "," between expressions?)2020-02-21 17:22:01|   2.1|  0.0|ERROR |JSONTemplater(XMLTemplaterFactory): An error occurred while parsing the ROOT template2020-02-21 17:22:01|   2.1|  0.0|ERROR |JSONTemplater(XMLTemplaterFactory): A fatal error has occurred. Check the logfile above for details  Thanks