I have a client who uses FX for consolidations from about 12 companies. Each company has dozens of departments which is constantly growing because each department represents an employee. Using the AutoRetrieval function makes them add a new department for each new employee to the SelectedDepartments= line in the AFWININI file. Is there a way to use a wild card so that all departments are brought in without specifying each individual department? The manual Retrieval works fine for them but is cumbersome to select each subcompany and folders for the 12 companies. We are trading one tedious issue with another if we use AutoRetieval.

Here is a sample of the Retrieval sections currently used:
[Retrieve1]
Database=P:\Quantum\FX Imports\SUBDATA\glglob.sub
UserID=sys
Password=sys
SelectedDepartments=252236,303169
Department=101*
ReplaceDepartment=0
AppendData=0
UseExistingBudget=0
UseExistingGroups=0
UpperCase=0
LoginPrompt=0
RetrieveAllYears=1
[Retrieve2]
Database=P:\Quantum\FX Imports\MEXDATA\glglob.mex
UserID=sys
Password=sys
SelectedDepartments=306100,306101
Department=201*
ReplaceDepartment=0
AppendData=1
UseExistingBudget=0
UseExistingGroups=0
UpperCase=0
LoginPrompt=0
RetrieveAllYears=1

etc...

Thank you for any response.
RES

Bob:

One of my clients using FX also has a database where new departments are added all of the time. We use the auto retrieve:

[Retrieve11]
Database="G:\DATA\HYSCAL\CONST\GLGLOB.CAL"
UserID="FX"
Password="FX"
Department="CALC"
AppendData=1
RetrieveAllYears=1
ReplaceDepartment=1


For your purposes I wonder if this would work (changing our setup from creating a fixed department in FX to one that should create a variable department):

[Retrieve11]
Database="G:\DATA\HYSCAL\CONST\GLGLOB.CAL"
UserID="FX"
Password="FX"
Department=CALC*
AppendData=1
RetrieveAllYears=1
ReplaceDepartment=1

We are not using 'SelectedDepartment' at all, which (I assume) means that we retrieve them all.

Doug

I will test it without the SelectedDepartment and let you know my results.

RES

Isn't it self-evident that "SeletedDepartment" means you want only the departments specified to be selected and that the retrieve would normally retrieve all the departments?

Andrew:

I think that what is not self evident is that fact that you don't need to use all of the auto retrieve options (as evident from Bob's post where is using every possible option when only a few are really required).

If the OPTION is NOT there then it is the same as OPTION=0

Gang

I adjusted my autoretrievals in the AFWININI file by eliminated the SelectedDepartment option. I got the result as Andrew indicated of all accounts and departments from the respective GL datasets with the proper assigned prefix. I think I asked tech support about a year ago about using a wild card with the SelectedDepartment option but they said no it would not do what I wanted. They did not tell me that eliminating it or giving the option =0 would do what I wanted.

It was not self evident that I could remove the command option. I thought that since it was there I had to use it.

I think this will make my client very happy.

Thanks,

RES

That's what we're looking for - happy clients!

Gang

Final results were tested today and the auto retrieve worked perfectly for the client. Thank all of you for your help.

My next question is there a document explaining the Retrieve options and how or when to use them?

Thanks,

RES

Gang

Final results were tested today and the auto retrieve worked perfectly for the client. Thank all of you for your help.

My next question is there a document explaining the Retrieve options and how or when to use them?

Thanks,

RES