Filemaker SAGE data import
I am trying to get data imported from Sage Line 50 into Filemaker. I need a number of tables. I understand that I need an ODBC connection. Can anybody point me to some scripts that do this ? thanks
OS Version? Filemaker Version? SAGE single user or networked?
A Google indicates many people have done this. https://www.google.com/search?q=Sage+import+filemaker
There are very expensive plugins that have speed complaints.
This thread is recent and indicates a forum with someone knowledgable about SAGE database structure.http://forum.makingithappen.co.uk/viewtopic.php?f=1&t=2049
The first three or five links are FM's ODBC documentation https://www.google.com/search?q=odbc+filemaker+pro+driver
These are threads on this forum about ODBC https://www.google.com/search?q=odbc+filemaker+site%3Aforums.filemaker.com
You just need to install the ODBC driver that comes with Sage. Then simply add the Sage DB as a source, and you can import from it like any other ODBC source.
I am running a Win 7 64 bit machine. Howevere both Filemaker 12 and SAGE 50 v14 are 32 bit apps. I cant seem to find a 64 bit odbc connection for SAGE.
I know that all 64 bit drivers are installed in C:\Windows\SysWow64\odbcad32.exe.
Ironically I can see SAGE here (which I admit goes against my second sentence) but not Filemaker.
SAGE are saying (typically) upgrade to the latest version of SAGE. However has anybody got any better suggestions ?
The Sage driver can be installed if you launch the 32-bit ODBC installer separately. You don't need to upgrade. It is pretty confusing - you've just stated that the 64-bit driver is called...odbcad32. Just wait to see what the 32-bit driver installer's called, and where it is stored...
If you google installing 32-bit ODBC drivers in Windows 7 you'll get plenty of hits of formerly-frustrated folk. The Microsoft Knowledge Base also has good instructions, from memory.
Managed to connect !!! Can now see all the tables from the SQL query table builder. However I cannot see the individual columns within the tables. Any thoughts ?
Try making the ODBC connection in Excel and using Microsoft Query's SQL Wizard.
Thanks. I tried using Excel and the columns were always there.
I also tried ESS and it said that I was not authorised to log onto the database.
Retrieving data ...