MYOB export help

[tyroneneous]

Hi,

After a bit of testing today and recoding I have managed to get it to work in my version of MYOB. Currently I've only tested it on MYOB Accounting v17.

Basically it exports any new orders to a file in the MYOB directory, which you create in your Zencart directory.

With this file you can import it directly into the MYOB accounting software. Additionally it has an option to allow you to import customers as well.

The instructions should give you an idea of how it works.

Thanks.

Tyrone.

[car86l]

once i import the file into MYOB what do i do then, do i manually delete the file? otherwise wont i just keep reimporting the same data?

[tyroneneous]

Hi,

Yes you can manually delete the file. Though each file has a date stamp on the end of it, so it won't overwrite the previous days one. Also if an order is placed on the same day, it will append it to the file and not overwrite the data. Therefore you will only need to import the file once a day and it will be sufficient enough to update your accounting software.

Tyrone

[simondale123]

OOPS - IGNORE THE BELOW - I MISSED THE PROGRESS ABOVE! I WILL DOWNLOAD AND INSTALL THE LATEST VERSION NOW!

I emailed the authors mentioned in the script and got this response from Steve:

Hi Simon,

I downloaded myob.zip and had a quick look at the code. It has been ##############ized all to hell from what I wrote six years ago

I see that one variable is $DOCUMENT_ROOT but that used to be a php variable, since deprecated. Maybe that is the problem, so renaming the variable could help.

I also see usage of the now deprecated php array $HTTP_POST_VARS, so those need to be renamed to $_POST

Other than that, and making sure the path is correct that it is writable by the web-server user (usually "nobody" or "apache"), I see no obvious reason for it to fail.

Best Regards,
Steve

Unfortunately I have tried to make those changes but I still have the same problem. What a shame.

Simon

[simondale123]

Hi Tyroneneous,

I have tried this now and lots and lots of fiddling but I can't get it to produce a file at all!

I've tried running includes/myob_cust.php directly and it produces a file in my MYOB directory with the field headings so I reckon I've got the path and permissions correct.

I've included a ZIP file with my myob_cust.php, myob_sale.php, application_top.php and header_php.php. I think those are all the relevant files?

Could you please please take a quick look and see where I'm being stupid?! I'd really appreciate it!

Many thanks for all of your help

Regards

Simon

[tyroneneous]

Hi Simon,

I had a quick look at your code and fixed it up. You had placed the code to run before the "process checkout" line was to be finished. Now I've put it into the right place for you. I've attached the files in the structure of the correct directories for it to run. It should work now.

Also I'm very disappointed for the author to say that we've basterized his file. I'll clarify that, I only changed the names of the functions to fit for Zencart, so that it would call to the right function. I have not even added anything to it, so he can't blame us for us mucking his code up. Additionally his code was very messy as well and that's not the way I would program. Anyway let's see if there can be additional improvements to it. e.g:

1. Add an option to click a button in the admin controls to d/l the files or for it to automatically email us all the files at the end of the day when all the transactions have been done.
2. Add a surcharge function so that it can include it in the MYOB journal entries. (For people like me who are charging a CC surcharge to a customer on any CC transaction).

Thanks.

Tyrone.

[simondale123]

Hi Tyrone,

I wouldn't worry about what Steve said. I think the changes that he means probably happened before you came across the code, when it was translated from Quickbooks, etc.

Thanks for much fox fixing my code! That's really kind of you! Unfortunately it doesn't work...

Strangely the first couple of times that I tried it I got to the NoChex part (the checkout pages on my payment provider's servers) and a username and password prompt came up for [email protected].

It doesn't do that now, but it doesn't produce a file either! Doh!

What else could it be?!?!?!

Thanks Tyrone

Simon

[gee38l]

Sorry to revive an old thread didnt want to start a new one.

Has anyone got this working on the later versions of MYOB?

[gee38l]

Sorry to revive an old thread didnt want to start a new one.

Has anyone got this working on the later versions of MYOB?

I have decided to work on this module myself. I currently have the customer import side of things working with accountright premier v19, I have a few more things to alter then i will work on the sales order side of it. Whilst working on it the last few days i think i may also create something to automate the process into MYOB but that will come later. If anyone is interested send me a message.