Starting with Argos 7.4.3, importing billing codes from CSV files has been drastically simplified. While the method outlined here still works, we recommend using the new CSV File Import feature directly in Argos Manager.
On 32-bit versions of Microsoft operating systems, there are a wide range of ODBC drivers available for connecting to external data sources, such as MS Access, Excel, CSV, Foxpro, Paradox, etc. On 64-bit versions of Microsoft operating systems, such as Server 2008 R2 and Windows 7 x64, the default ODBC options are limited to SQL connections only.
In the past, this has meant that any import of billing codes into Argos from a non-SQL source required a 32-bit computer.
Using the Microsoft Access Database Engine
Microsoft has released an Access Database Engine driver for 64-bit operating systems, which allows billing code import from non-SQL sources, with some caveats:
- Only supports MS Access, Excel and text file (CSV, tab or other delimiters)
- Cannot be accessed automatically by a service
This means that billing codes can be imported from MS Access and Excel and text files on a 64 bit computer, but the import cannot be scheduled - it must be run manually through the Argos Manager.
Follow these steps to enable the driver and import billing codes
- Download AccessDatabaseEngine_x64.exe from http://www.microsoft.com/en-us/download/details.aspx?id=13255
- Run the file and follow prompts to install
- Create a System DSN using these instructions: Importing Billing Codes from a CSV file using a System DSN
- Run Billing Code import manually by clicking "Run Now" button
- Take note that the "Scheduling" section of the import routine do not apply when using the 64-bit Access ODBC driver pack
Example of DSN data source selection tab on 64 bit computer with Access Database Engine installed:
Automated Import from CSV on a 64 bit computer
The Access Database Engine driver cannot be run by a Windows service. However, the Argos Integration Service, which is responsible for the scheduled billing code import, can access 32 bit drivers. For a project import task to run on a schedule, a second System DSN must be created using the 32-bit ODBC text driver.
- Make sure the standard Data Sources (ODBC) dialog is not currently open
- Browse to c:\Windows\SysWow64
- Open odbcad32.exe
- Create a new System DSN using the Microsoft Text Driver (*.txt,*.csv)
- Use exact same name and settings as that were used in the Microsoft Access Text Driver configuration
- Click OK
The Argos Manager, which runs in 64-bit mode, will use the 64-bit ODBC driver to run the import. The Argos Integration service, which runs in 32-bit mode, will use the 32-bit ODBC driver.
Need to import from another data source that is not supported by the 64-bit Access Database Engine?
- Install Argos Manager and Argos Integration Service on a 32-bit computer. This computer does not need to host the main Argos components, but would be configured to handle only the import.
- If using the full version of SQL Server, create a Linked Server connection to the data source and bring the billing codes into a temporary SQL table. Sepialine Technical Support can assist with this method as a professional service.