iamguyster
Technical User
Hi,
I am trying to automate the Organizational Chart Wizard running it from the command line. I have succesfully run it against an xls file containing data and an ODBC DSN for an access database. The problem is, the data actually sits in a table in a SQL Server DB. I have created an ODBC DSN for this datasource and tried the same things as I did with the Access datasource. It never works! It tells me 'UnitName' or 'UnitID' is not present in the datasource. Here is the command I am using:
"_organization chart wizard.exe" /datasource=GOB ,table=Units /name-field=UnitName /manager-field=ParentID /unique-field=UnitID
I have not included dbqualifier for two reasons. One is that it worked without for the access DB and two, is (and forgive me for my ignorance) but I havent got a clue what to put in there! Maybe this will sort it?
Thanks for any help you can give.
Cheers,
iamguyster
I am trying to automate the Organizational Chart Wizard running it from the command line. I have succesfully run it against an xls file containing data and an ODBC DSN for an access database. The problem is, the data actually sits in a table in a SQL Server DB. I have created an ODBC DSN for this datasource and tried the same things as I did with the Access datasource. It never works! It tells me 'UnitName' or 'UnitID' is not present in the datasource. Here is the command I am using:
"_organization chart wizard.exe" /datasource=GOB ,table=Units /name-field=UnitName /manager-field=ParentID /unique-field=UnitID
I have not included dbqualifier for two reasons. One is that it worked without for the access DB and two, is (and forgive me for my ignorance) but I havent got a clue what to put in there! Maybe this will sort it?
Thanks for any help you can give.
Cheers,
iamguyster