Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

Filemaker sage import

Sage 50 general help forum - Free help and support for all general issues
Post Reply
Kaps
User
User
Posts: 7
Joined: 14 Oct 2012, 13:01
Sage Version: v2008 14 UK/Europe/Africa

Filemaker sage import

Post by Kaps » 14 Oct 2012, 13:23

I am trying to import data from Sageline50 v14 into Filemaker.

I am using a standard Filemaker ODBC import.

However what user name and password should I be using ? I keep getting told that I dont have the correct username /password.

I am trying to connect to the demonstration database in Sage50 v14. I have inadvertently put a password on this.

can anybody help ? thanks

regards

Kaps
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: Filemaker sage import

Post by brucedenney » 15 Oct 2012, 11:21

The Username and password are the Sage Username and Sage Password for that user.

If you do not use a username to log in to Sage 50 then the username is MANAGER
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Top
Kaps
User
User
Posts: 7
Joined: 14 Oct 2012, 13:01
Sage Version: v2008 14 UK/Europe/Africa

Re: Filemaker sage import

Post by Kaps » 21 Oct 2012, 20:58

Thanks.

I have realised that my problem is that both SAGE line 50 (v14) and Filemaker 12 are win 32 bit appliocations. However I am running a Win 7 machine with 64 bit app. There does not appear to be a 64 bit ODBC connection for SAGE Line 50. Am I correct ? Has anybody done this ?

I understand that all 64 bit drivers are located in c:\windows\syswow64\odbcad32.exe.

Curiously I can see SAGE line 50 v14 here (which I admit contradicts my earlier statement)- but not Filemaker. Any thoughts ? thanks

Kaps
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: Filemaker sage import

Post by brucedenney » 23 Oct 2012, 11:57

You might not be able to see the 32bit odbc admin to set up a dsn

try this at the command line to launch the 32bit ODBC admin

c:\windows\sysWOW64\odbcad32.exe.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Top
Kaps
User
User
Posts: 7
Joined: 14 Oct 2012, 13:01
Sage Version: v2008 14 UK/Europe/Africa

Re: Filemaker sage import

Post by Kaps » 23 Oct 2012, 20:34

Thanks - now got it working.
Top
Post Reply

Return to “Sage 50 UK version General Help”

Who is online

Users browsing this forum: No registered users and 2 guests