General Programming Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community Forums > Programming > General Programming Help
Reload this Page

interfacing with MYOB data file

Discuss interfacing with MYOB data file in the General Programming Help forum on Dev Articles.
interfacing with MYOB data file General Programming Help forum discussing Perl, Python, Scripting and/or any languages that do not fit into any of the categories above.

Record onscreen activity, your voice & webcam video. Turn everyday presentations into HD-quality videos.

For perfectly clear screencasts every time.
At the IBM® developerWorks Developer Knowledge Center you'll find resources for FREE ekits, Tutorials, Webcasts, Trial Downloads and more.


We cover the world of technology like no one else, constantly updating you with the best information available on open source software, Microsoft technologies, hardware and news from around the world.

Try Camtasia Studio today!
Visit the IBM® Developer Knowledge Center today!
Sign up today!

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old November 20th, 2003, 07:54 PM
DDDooGGG DDDooGGG is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Dec 2002
Location: Melbourne, Australia
Posts: 97 DDDooGGG User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 23 m 33 sec
Reputation Power: 7
Question interfacing with MYOB data file
Is there anyway i can interface with a MYOB datafile, using php?
__________________
regards,


Fulton
Reply With Quote
  #2  
Old November 20th, 2003, 09:33 PM
stumpy's Avatar
stumpy stumpy is offline
May contain nuts.
Dev Articles Regular (2000 - 2499 posts)
  
Join Date: Aug 2002
Location: Sydney, AU
Posts: 2,058 stumpy User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 5 h 9 m 52 sec
Reputation Power: 10
Send a message via ICQ to stumpy Send a message via MSN to stumpy
Yes - it is possible. I looked into this a while ago. You need to purchase the MYOB Developer pack, which gives you the ODBC driver which allows you to query the data files like a database. (You might be able to get the ODBC driver from the more expensive business packs too... can't remember)... bottomline is YES!
__________________
DevArticles Moderator
BlueSix - Web Development and Consulting
Reply With Quote
  #3  
Old November 20th, 2003, 09:40 PM
DDDooGGG DDDooGGG is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Dec 2002
Location: Melbourne, Australia
Posts: 97 DDDooGGG User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 23 m 33 sec
Reputation Power: 7
Hi, i have the MYOB ODBC Direct driver installed, it came with version 12 of MYOB. But i only have limited access until i register the the odbc drivers.

Do you know what tables can be accessed for testing with the unregisterd version of MYOB ODBC?

I have been using the following code. It should work shouldn't it?
PHP Code:
# connect to a DSN "mydb" with a user and password
$connect = odbc_connect("test", "", "");

# query the users table for name and surname
$query = "SELECT * FROM Employees";

# perform the query
$result = odbc_exec($connect, $query) or die ("cannot find table");


# fetch the data from the database
while(odbc_fetch_row($result)){
  $name = odbc_result($result, 1);
  $surname = odbc_result($result, 2);
  print("$name $surname<br>\n");
} 
Reply With Quote
  #4  
Old November 20th, 2003, 09:57 PM
stumpy's Avatar
stumpy stumpy is offline
May contain nuts.
Dev Articles Regular (2000 - 2499 posts)
  
Join Date: Aug 2002
Location: Sydney, AU
Posts: 2,058 stumpy User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 5 h 9 m 52 sec
Reputation Power: 10
Send a message via ICQ to stumpy Send a message via MSN to stumpy
I've got no idea. We didn't end up going for it. I'd say the DeveloperPack would have all the doco you'd ever need tho... it'd want to for AUS$900!
Reply With Quote
  #5  
Old November 20th, 2003, 11:30 PM
DDDooGGG DDDooGGG is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Dec 2002
Location: Melbourne, Australia
Posts: 97 DDDooGGG User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 23 m 33 sec
Reputation Power: 7
Got it working, i had to change a few permissions on the MYOB data file and now i can access the data via DSN, thank god!
Reply With Quote
  #6  
Old December 18th, 2003, 07:55 PM
jimmybond jimmybond is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Dec 2003
Posts: 3 jimmybond User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
is it possable to leave some hints on how you achieved this?
Reply With Quote
  #7  
Old December 18th, 2003, 09:45 PM
DDDooGGG DDDooGGG is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Dec 2002
Location: Melbourne, Australia
Posts: 97 DDDooGGG User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 23 m 33 sec
Reputation Power: 7
i changed the permissions on the clrwtr.dat file so the IUSR_ had full rights

then i created i DSN to the clrwtr.dat using the MYOB DSN software that comes with MYOB version 12

Put the following in a file and it should work:

PHP Code:
# connect to a DSN "mydb" with a user and password 
$connect = odbc_connect("test", "", ""); 

# query the users table for name and surname 
$query = "SELECT * FROM Employees"; 

# perform the query 
$result = odbc_exec($connect, $query) or die ("cannot find table"); 


# fetch the data from the database 
while(odbc_fetch_row($result)){ 
  $name = odbc_result($result, 1); 
  $surname = odbc_result($result, 2); 
  print("$name $surname<br>\n"); 
} 
Reply With Quote
  #8  
Old February 19th, 2004, 11:33 AM
Blind Monk Blind Monk is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Feb 2004
Posts: 1 Blind Monk User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Anybody know what to use to connect to the Canadian version of Myob accounting plus? anything i download from the Myob site only works on US files.
Reply With Quote
  #9  
Old February 19th, 2004, 05:36 PM
jimmybond jimmybond is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Dec 2003
Posts: 3 jimmybond User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Quote:
Originally Posted by Blind Monk
Anybody know what to use to connect to the Canadian version of Myob accounting plus? anything i download from the Myob site only works on US files.



Not sure if this will work with "accounting plus".
I use open office to open up and modify data in MYOB Retail Manager, i just set up odbc to the file and then use the data-sources section in OO.o to make an odbc connection
then i can play around til my heart is content

Cheers
Jimmy
Reply With Quote
  #10  
Old February 19th, 2004, 05:48 PM
jimmybond jimmybond is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Dec 2003
Posts: 3 jimmybond User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Quote:
Originally Posted by Blind Monk
Anybody know what to use to connect to the Canadian version of Myob accounting plus? anything i download from the Myob site only works on US files.


sorry, i didnt pay attention to which forum we were in.

This is what i worked out in the end (for some stupid reason i never thought to go to myob's site and see if they had any tools)

I just used the 'com' side of Microsofts ADODB (not to be confused with the far superior ADODB for php )

PHP Code:
 $myob_conn = new COM("ADODB.Connection") or die("Cannot start ADO"); 
// Microsoft Access connection string.
$myob_conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\\ApacheRoot\\MYOBRM\\recent.mdb"); 
Reply With Quote
  #11  
Old April 30th, 2004, 06:21 PM
docsabre docsabre is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Apr 2004
Location: vancouver
Posts: 1 docsabre User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Send a message via Yahoo to docsabre
Question Will this enable you to save back into MYOB?
It's my understanding that the MYOB ODBCDirect driver will not allow you to save back into MYOB. Read-only access is not going to be sufficient for us, we need read/write. Will the above solution work (safely) to write back into the MYOB datafile, so that the inventory (for example) can be updated in real time? Thanks for your help!
Zal
Reply With Quote
  #12  
Old June 2nd, 2004, 06:08 PM
egganet egganet is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Jun 2004
Posts: 1 egganet User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Unhappy Why is it so slow?
I tried the code to link PHP with the MYOB direct driver and it worked. Thanks...

However, the connection is very slow. When I try to access more than a few items, it takes so long that the page times out. Has anyone else faced the same problem? Is there anything that can be done to improve the access speed?
Reply With Quote
  #13  
Old July 5th, 2004, 05:13 PM
Warren Walker Warren Walker is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Jul 2004
Posts: 1 Warren Walker User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
MYOB Canadian ODBC Driver
Do you have the ODBC driver for MYOB Canadian version 5.5.6 working?

Can more just name and address fields, such as invoice detail, be extracted?

Thanks

Warren




Quote:
Originally Posted by jimmybond
sorry, i didnt pay attention to which forum we were in.

This is what i worked out in the end (for some stupid reason i never thought to go to myob's site and see if they had any tools)

I just used the 'com' side of Microsofts ADODB (not to be confused with the far superior ADODB for php )

PHP Code:
 $myob_conn = new COM("ADODB.Connection") or die("Cannot start ADO"); 
// Microsoft Access connection string.
$myob_conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\\ApacheRoot\\MYOBRM\\recent.mdb"); 
Reply With Quote
  #14  
Old October 20th, 2004, 11:08 PM
josef josef is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Oct 2004
Posts: 1 josef User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
other ways to access the myob database
are there ways to access the data file other than php? i'm not familiar with the language. thanks
Reply With Quote
  #15  
Old May 7th, 2009, 08:12 PM
smartquin smartquin is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: May 2009
Posts: 1 smartquin User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 5 m 23 sec
Reputation Power: 0
DSN not working!
Hi Guys

I noticed your forum, and it relates directly to a project I'm doing. I'm using MYOB Accounting Plus v18, but when trying to create a DSN it says 'The library files "stmyob32.dll" and "MYOBSp32.dll" are missing for version 12.4. Please make sure you have the latest ODBC driver etc.

Has anyone come across this? All I want to do is read/write to the datafile, whether someone is logged into it or not, and change data via a web front end. It has to run on Windows. Any help will be appreciated.
Reply With Quote
  #16  
Old August 31st, 2009, 08:19 PM
Mistah_K Mistah_K is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Aug 2009
Posts: 2 Mistah_K User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 11 m 45 sec
Reputation Power: 0
Hi - PHP with MYOB
Quote:
Originally Posted by egganet
I tried the code to link PHP with the MYOB direct driver and it worked. Thanks...

However, the connection is very slow. When I try to access more than a few items, it takes so long that the page times out. Has anyone else faced the same problem? Is there anything that can be done to improve the access speed?


Hi, i've been searching for 2 days and trying different code. Are you able to post me the code you used to connect to your myob. Thanks
Reply With Quote
Reply

Viewing: Dev Articles Community Forums > Programming > General Programming Help > interfacing with MYOB data file

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump




 Free IT White Papers!
 
How to Present Effectively Online
This white paper offers practical and actionable advice on the key steps that any presenter should consider as they plan and execute a Webinar or online meeting.
Request Your Free Technology Downloads!
 
Open Source Security Myths
Open Source Software (OSS) is computer software whose source code is available to the general public with relaxed or non-existent intellectual property restrictions (or arrangement such as the public domain), and is usually developed with the input of many contributors.
Request Your Free Technology Downloads!
 
Power and Cooling Capacity Management for Data Centers
This paper describes the principles for achieving power and cooling capacity management.
Request Your Free Technology Downloads!
 
Scalable, Fault-Tolerant NAS for Oracle - The Next Generation
For several years NAS has been evolving as a storage alternative for Oracle databases, and for good reason: NAS is quite often the simplest, most cost-effective storage approach for Oracle. Learn about the benefits that HP's approach to scalable NAS brings to Oracle environments in this comprehensive white paper.
Request Your Free Technology Downloads!
 
Understanding Web Application Security Challenges
This white paper discusses many common threats and preventive measures for Web application security, and explains what you can do to help protect your organization.
Request Your Free Technology Downloads!
 

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 




© 2003-2009 by Developer Shed. All rights reserved. DS Cluster 5 Hosted by Hostway. 
Stay green...Green IT