Hello,

Our accounting department to update our accout list in Adagio GL. We have created an excel spreadsheet with the following fields:
Account Code
Department Code
Description
Account Type.

Once the informat is correct we save the file as a CSV format. We do import accounts. The window opens, we select type of file, file name. Next we pick the 4 fields we want imported. Next we go to last tab and select the 4 fields and click Import. We then receive an error:
" is not a valid integer value
The colnums are formated as:
Account Code 6 spaces Right Justifed
Department Code 6 spaces
Description 30 spaces
Account Type 1 space.

All are formated as general.

About 4 months ago I did a small import and made the above notes in case I had to do another import again. This happened yesterday. Now I can not do it again.

We are using 6.8B 030131
We are using Win XP SP1 (Last time it was NT SP6a)
I'm doing it as myself (domain admin, last time may have been Administrator)

I've also used CSV formatted files for imports because most programs offer that as an option.

Hi Jeff,

You are using Ledger 6.8B, and should be aware that the newest version 8.0A has had all import functions improved. Are you trying to import new accounts, update existing accounts, or both?

There are 3 screens you can visit when import either accounts or batches in Adagio Ledger. Let me describe each one briefly and perhaps this may shed light on what's happening.

The first screen allows you to select the file name and location, the file type, and some options specific to what you are importing.If you are importing new accounts, then there are a minimum number of required fields that must either be imported or defaulted. For Excel formatted files, you might have column labels in the first row, and need to select the 'Header included' to ignore row 1.

The second screen allow you to match up the fields that exist in your (Excel) import file. As you said your 4 fields are account, department, description, and account type, those should be the only 4 fields in the Selected box on the right, in the proper order.

The third screen allows you to set default values for fields that don't exist in your import file. This would be useful if every account will have the same value for a certain field; you can default it here rather than repeat it for every record in the Excel file. An example would be setting Consolidated to No.

Does the error message you are receiving indicate a record number or a field? This might help narrow things down. You probably should format the account and department codes as Text in the Excel file (if you haven't already).

Hopefully this will help narrow things down.

The error does not indicate record so I beleive it is the first Record. Yes we have version 8 of GL but will not update until the Yearend is completed.

I will try to format the cells as text and try importing without the a header row in an excel format.

Let you know what happens