Skip to main content

Data

Using readers and writers to extract and load data.

  • 7,236 Posts
  • 26,610 Replies
7236 Posts
W
witos
asked in Data
A
ashish_m1
asked in Data
ottadini
Supporter
ottadiniSupporter
asked in Data
Temporary network path mapping (Windows)

Some UNC paths are very long (\\global\analysis\more\another\and\so\on\...), so it might be necessary to map the very long path to a drive letter for example. How can I do this and retain transportability across Windows platforms, and maybe other platforms?At the moment I use a SystemCaller, and simply assign a drive letter I pick to the UNC path, e.g., SUBST X: \\global\analysis\etc\.But, this is possibly going to be wrong at some stage, when X: is assigned by the admins without warning, well, maybe. In Windows there are various ways to get the next unused drive letter, one of which is PUSHD \\global\analysis\etc\but, then how do I get the drive letter that is assigned, using the system caller?Or, is there another way?

1102
david_r
Celebrity
A
Anonymous
asked in Data
P
philippe33
asked in Data
nielsgerrits
VIP
nielsgerrits
asked in Data
FME server path handling

Dear community, I have difficulties understanding the behavior of server handling (unc) paths. I'm quite new to server so this one might be simple but I don't get it.What I want to do is use a Directory Watch publication on a upload folder. Then let a workbench subscription react to a new upload. This works. I need the workbench directory file and pathnames reader to scan the upload folder, add the new files to a list and move the files to a queue folder.This is where the trouble comes in. The log tells me that the folder is not found. But the path is not the path I defined (\\\\fc01\\FMEdata\\KLIC\\upload) but local (D:\\Program Files\\FMEServer\\repositories\\KLIC\\01_scan\\upload).When I create the path dynamic (datapath = \\\\fc01\\FMEdata\\KLIC, dataset = @Value(datapath)\\upload) things works fine. So I got it working but I do not understand why... Can anyone give me a hint in the right direction?I know for sure server has read/write

1042
nielsgerrits
VIP
M
mhammond
asked in Data
Salesforce Writer appears to be stopping after 200 records

I have a transformation from Oracle Non Spatial to Salesforce that works fine until there are more than 200 records. At that point it errors. I can't tell from the error message what the issue is exactly. Is it some setting in Salesforce? Do I not have the parameters set correctly on my Reader/Writer? Any help would be appreciated. I do know that the records after 200 do not have data issues as I can write them only not when they are greater than feature 200.Salesforce Writer: Record 201 was not processed successfully: 'CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY:InternalServiceOrderTrigger: execution of AfterUpdate caused by: System.NullPointerException: Attempt to de-reference a null object Class.InternalServiceOrderTriggerHandler.emailRelatedServiceOrderSDC: line 668, column 1 Class.InternalServiceOrderTriggerHandler.triggerHandler: line 93, column 1 Trigger.InternalServiceOrderTrigger: line 4, column 1:--'

160
M
M
michaeltfl
asked in Data
G
greenroze
asked in Data
zzupljanin
Contributor
zzupljaninContributor
asked in Data
M
mattdoa2
asked in Data
Accessing FME_MacroValues['FME_JOB_ID']

I'm trying to figure out how to access the FME_MacroValues['FME_JOB_ID'] system parameter.  I'm trying to link this script to a writers destination. Basically want to include the job ID in the file name of the output. I've attempted this using the code below but am getting the error shown in this log:Starting translation...INCLUDE -- failed to evaluate Python script `def ParamFunc():  import fme  return '\\\\ServerLocation\\logging\\failed_logs\\' + 'failed_load_' + FME_MacroValues['FME_JOB_ID'] + '.xlsx'value = ParamFunc()macroName = 'DestDataset_XLSXW2'if value == None:  return { macroName : '' }else:  return { macroName : str(value) }'Program TerminatingTranslation FAILED.Traceback (most recent call last):  File "<string>", line 5, in MF_Include_1490921734471  File "<string>", line 4, in ParamFuncKeyError: 'FME_JOB

1905
takashi
Celebrity
gmbutler2
Contributor
gmbutler2Contributor
asked in Data
K
katiem
asked in Data
Issue with using the XMLUpdater transformer to manipulate Metadata

I'm using the Esri Geodatabase (ArcSDE Geodb) reader with Feature Read Mode set to Metadata, to read in GEMINI metadata from SDE. I'd like to manipulate certain elements before sending the updated metadata back to the SDE feature class. Using the XMLUpdater I've been able to amend the content for some elements, however I haven't had any success when trying to amend the revision date, as there are three different date strings all with the same XML path: metadata/gmd:GEMINI_Metadata/gmd:identificationInfo/gmd:MD_DataIdentification/gmd:citation/gmd:CI_Citation/gmd:date/md:CI_Date/gmd:date/gco:DateCurrently none of them are getting updated on the output XML. The different date types are differentiated in the gmd:dateType element, e.g: <gmd:dateType> <gmd:CI_DateTypeCode codeList="

1189
itay
Supporter
A
angela
asked in Data
E
eltigre333
asked in Data
How to Extract Coordinates from Oracle Spatial Object Table

Hello, I've searched all available online sources but none appear to have this issue.Very simple task: I've added an Oracle Spatial Reader, connected to desired table and now want to extract x/y but I get this error when running."Error - Cannot have NULL value for 'z coordinate'"I've looked at the table in Oracle developer and indeed the Z values are Null.I'm aware that this table has multiple Spatial columns so I've checked: Handle Multiple Spatial Columns: YesI've tried a SELECT statement to run before translation:SELECT c.GEOM.SDO_POINT.X AS X, c.GEOM.SDO_POINT.Y AS Y,  FROM A.ENTITIES c  WHERE ACCESS_CODE = 'O'I've tried to expose the attributes: oracle_sdo_point.x oracle_sdo_point.y oracle_sdo_point.zIs there a way to force this to 2D rather than looking at the Z values?Any ideas appreciated. 

7224
E
tim_wood
Contributor
tim_woodContributor
asked in Data
ciarab
Contributor
ciarabContributor
asked in Data
R
robyn_studts
asked in Data
M
mishenka
asked in Data
hlouie
Contributor
hlouieContributor
asked in Data
N
nickcarsn
asked in Data
B
bas_boers
asked in Data
courtney_m
Contributor
courtney_mContributor
asked in Data
Updating SDE Feature Classes That Are Involved in a Relationship Class

I have a series of workspaces that sync an Oracle Database with an SDE database every hour (ORACLE_SPATIAL and GEODATABASE_SDE Readers > GEODATABASE_SDE Writer). I created several relationship classes in the SDE database (via ArcCatalog), and now my workspace fails to update any of the feature classes that are involved in a relationship class.I am receiving the following error: Error while retrieving an ArcObjects update cursor for the table/feature class 'DBO.EL_SERVICE_POINT'. The error number from ArcObjects is: '-2147216556'. The error message from ArcObjects is: {Objects in this class cannot be updated outside an edit session}If I delete the relationship classes, the Feature Types update as expected.I tried setting geodb_feature_has_relationships to 'yes' before writing to SDE, but I still received the same error.Also, the Transaction Type on the SDE reader and writer is set to "Versioned Edit Session", a

2404
courtney_m
Contributor
K
kamyabshabrandi
asked in Data
S
stuartohara
asked in Data

Badge Winners

  • Online Training
    anghelahas earned the badge Online Training
  • FME Certified Professional
    stigloher2010has earned the badge FME Certified Professional
  • Welcome Back
    nantiandjhas earned the badge Welcome Back
  • Online Training
    harishhas earned the badge Online Training
  • English Speaker
    kahli_jacobshas earned the badge English Speaker
Show all badges

Community Stats

32,429
Posts
123,236
Replies
40,554
Members
Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.