Service Desk Practitioners Forum
cancel

Data Exchange: com/hp/ifc/wf/AppEntitySet

SOLVED
Go to solution
Highlighted
Michael Yandow
Super Contributor.

Data Exchange: com/hp/ifc/wf/AppEntitySet

I'm trying to use Data Exchange to import an additional Role for some existing Application Accounts. (The source is an Excel spreadsheet.)

The import is giving me a message for the existing Application Accounts I'm trying to update: com/hp/ifc/wf/AppEntitySet.

Here is the contents to my ini file:
--
-- This data exchange configuration file has been generated
-- by the data exchange configuration file wizard.
-- Mon Jan 09 18:04:59 EST 2006
--

[DSN]
NAME=AADSN
USR=DIMPORT
PWD=password

[SYSTEM]
LOG=TRUE
XML=TRUE
DUMP=FALSE
TXT=FALSE
LOG_FILE=AA.log
XML_OUTPUT_FILE=AA.xml
APPLICATION_NAME=Application Accounts 010906.xls

[CLASSES]
NAME=ACCOUNTS

[ACCOUNTS]
SOURCE=[ACCOUNTS]
ATT=[LOGINNAME], [ROLENAME]
COLUMNS=[LOGINNAME], [ROLENAME]
LOADTABLE=TRUE
MAXRECORDS=9
ORDERBY=[ACCOUNTS].[LOGINNAME] ASC, [ACCOUNTS].[ROLENAME] ASC

I've attached the Excel data that I'm using as the source.

Any clue what I'm doing wrong? What is the msg trying to tell me?
4 REPLIES
lionheart
Regular Contributor.
Solution

Re: Data Exchange: com/hp/ifc/wf/AppEntitySet

pls use item when you are setting the import mapping.
Jasper Verweij
Acclaimed Contributor.

Re: Data Exchange: com/hp/ifc/wf/AppEntitySet

I have used this as well, but at the end I linked the same application account twice to the same role!!!!!

Please, use ACES for this purpose.

Jasper
Michael Yandow
Super Contributor.

Re: Data Exchange: com/hp/ifc/wf/AppEntitySet

Roles per account! Of course!!

Thanks for the help. Once I screwed my head on right, I was successful.
Michael Yandow
Super Contributor.

Re: Data Exchange: com/hp/ifc/wf/AppEntitySet

Thanks for the help!