Hi Yann,

Did you want your app to do the 30/60/90 calculations, or is it OK to have Adagio do this ahead of time with the Calculate Customer Aging function? If the latter choice would work, then all you need is the customer master file (without transactions), as the aged amounts are stored in fields titled 'Aged Current', Aged Bucket 1', 'Aged Bucket 2', etc.

"..small development project in Visual Studio 2013 using"

If you upload a backup VS2013 project or the "code snippet" that is causing the failure I will have R&D take a look.
Upload to www.softrak.com/dbr for Tech Support attention Michael

Thanks Michael,

Because I am not as familiar as I would like to be with the Adagio tables, I'm trying to use the Data Source Configuration Wizard in Visual Studio.

If you have an example of a Adagio Connection string and some DataAccess code, it could be helpful.

Can I use SqlCommand when querying your tables?

Thanks
Yann

Ok,

I was able to get all the records from the ARTranswCust__ar92a100 table by using the following code...
The Wizard does not seam to be compatible with the Adagio Data Source for some reason. Could be a problem similar to the Excel Query, where it won't display tables with more than 255 columns...

My Data Table was filled after a good 15-20 seconds (it wasn't very fast).
I'll try other tables as well as filter the results to see if I can speedup the process.



DataTable vendorTransactions = new DataTable();

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = "DSN=Adagio Data Source; ";
try
{
conn.Open();
OdbcCommand command = conn.CreateCommand();
command.CommandText = "select * from ARTranswCust__ar92a100";

OdbcDataAdapter adapter = new OdbcDataAdapter();
adapter.SelectCommand = command;
adapter.Fill(vendorTransactions);

// Process data here.
}
catch (Exception ex)
{
MessageBox.Show("Failed to connect to data source");
}
finally
{
conn.Close();
}

I would not use "Select *" from any table. In this case you are getting back 276 columns time # records in AR Transaction file.

Use ...\Softrak\system\DataDictionaryExporter.exe /ODBC to create an Excel Workbook that lists all the data elements in all the tables for a particular application.

With the AR 92 Sample data Select * From ARTRanswCust returned 185,000 data cells.

Yes, Thank you.
I had done the Data Dictionary Export already.

in response to the post from "Softrak Tech Support" it was suggested that I look in the 'Aged Current', Aged Bucket 1', 'Aged Bucket 2', etc.
but there is no data in there...

Even on my Customer screen, I do not have any data in the Current, 1-30, 31-45, 46-60, over 60 boxes at the bottom of the window...

Thanks

Hi,

Further to my last post, I noticed that if I want to pick columns by defining my own query, the column names do not match what came out of the Data Dictionary Export.
for example, i am able to do this: select cust, Name, Name2, BalanceOutstanding from AR92ACST where BalanceOutstanding > 0
But the columns are actually named as such in the Data Dictionary
cust # (with a space and a # sign)
Name
Name 2 (with a space)
Balance Outstanding (with a space)

How do I know what the column should be called?

Thanks
Yann

Use ...\Softrak\system\DataDictionaryExporter.exe /ODBC to create an Excel Workbook that lists all the data elements in all the tables for a particular application.

NOTE: /ODBC to create ODBC compliant names

You need to start the Data Dictionary Exporter with /ODBC on the command line to get the ODBC names. Otherwise you get the GridView Names.

You need to run "Calculate Customer Aging" to populate the fields in the customer master.

Thank you.

Is there any way to change the settings for the aged values?
If I wanted to 1-30, 30-60, 60-90 and over 90 in the fields of the Customer Master table?

AgedBucket1
AgedBucket2
AgedBucket3
AgedBucket4
AgedDays1
AgedDays2
AgedDays3

Thanks
Yann