How to import Expense Lines

[david_pinheiro]

Hi Everyone,

I am trying to import Expense lines but I keep getting an error. The error is on the Source ID field. I can't figure out how to import to that, does anyone know how to do this

Thanks

[Community Alums]

I checked on this: The source ID is mandatory and needs to be populated with something. You can use contract, individual asset or CI, a software installation, a contract, a user, or a group. I don't know what is best for your particular import. I do suggest making sure that whatever you reference in the source already exists before you import your expense line.

[Community Alums]

Randy,

I know we covered a few items via Webex to get you going, but John Andersen just posted a very timely blog about import sets to his blog that can help you: Integration Best Practices - Import Sets-John James Andersen

Of specific interest might be how he sets up the "Correlation Display" beginning at around 10:45 (though I would watch the entire thing leading up to this point for context). This could be a possible solution to configure something static or that varies based on another value defined in your source as the source ID for your import.

I hope this helps.

ben

[tangcov]

Ben...   Thank you for the video you shared.   It is good.   I tried to add a new field in the transform map that goes something like this:

sourceinfo => sourceid

When I ran the transform task I got a "transform stopped due to error: java.lang.NullPointerException" error.   Below is the rest of the error log:

java.lang.NullPointerException

  at com.glide.db.TableDescriptorProviderFactory.get(TableDescriptorProviderFactory.java:12)

  at com.glide.db.TableDescriptor.getProvider(TableDescriptor.java:701)

  at com.glide.db.TableDescriptor.getSchema(TableDescriptor.java:187)

  at com.glide.db.TableDescriptor.get(TableDescriptor.java:76)

  at com.glide.db.impex.transformer.TransformReferenceResolver.getReferenceLookupField(TransformReferenceResolver.java:204)

  at com.glide.db.impex.transformer.TransformReferenceResolver.getReference(TransformReferenceResolver.java:189)

  at com.glide.db.impex.transformer.ReferenceCoercion.setReference(ReferenceCoercion.java:36)

  at com.glide.db.impex.transformer.ReferenceCoercion.coerceValue(ReferenceCoercion.java:19)

  at com.glide.db.impex.transformer.ATransformCoercion.coerce(ATransformCoercion.java:42)

  at com.glide.db.impex.transformer.TransformerField.coerceValue(TransformerField.java:108)

  at com.glide.db.impex.transformer.TransformerField.setValue(TransformerField.java:103)

  at com.glide.db.impex.transformer.TransformerField.transformField(TransformerField.java:77)

  at com.glide.db.impex.transformer.TransformRow.transformCurrent(TransformRow.java:80)

  at com.glide.db.impex.transformer.TransformRow.transform(TransformRow.java:53)

  at com.glide.db.impex.transformer.Transformer.transformBatch(Transformer.java:140)

  at com.glide.db.impex.transformer.Transformer.transform(Transformer.java:76)

  at com.glide.system_import_set.ImportSetTransformerImpl.transformEach(ImportSetTransformerImpl.java:148)

  at com.glide.system_import_set.ImportSetTransformerImpl.transformAllMaps(ImportSetTransformerImpl.java:73)

  at com.glide.system_import_set.ImportSetTransformerWorker.startWork(ImportSetTransformerWorker.java:40)

  at com.glide.worker.ProgressWorker.startAndWait(ProgressWorker.java:83)

  at com.glide.worker.ProgressWorkerThread.run(ProgressWorkerThread.java:42)