MYOB export help

[tyroneneous]

Hi,

I have some code that was copied from OsCommerce MYOB module and I have tried to implement it into Zen-Cart. At this point it seems to work, but it's not generating the files for downloading.

Could some one have a look at it and recommend or help with the code to get it to work?

I hope that we can have this code shared in the downloads section soon so that people who need this can also use it.

Thank you.

Tyrone.

[simondale123]

This sounds great. Did you manage to get it working?

I am backing up my Zen Cart and Zen Cart DB as we speak and then I will give it a try.

Thanks

Simon

[simondale123]

OK - I have now followed the instructions and installed this on my test server.

Alas, it doesn't error, and there's nothing in the logs, but no files are produced.

What a shame.

I wonder if anyone who knows what they are doing can help us out? I can give access to my test server if that helps.

Thanks

Simon

[tyroneneous]

Hi simondale123,

Thanks for trying the module. I have managed to get it to work. The problem I'm having is that the exported files are not doing what it suppose to. It's not generating a /n properly so I can import it into MYOB. I'll upload the modified files soon. Any ideas or suggestions as well?

Thanks.

[tyroneneous]

Hi simon,

I've got the code to finally work. Test to see if this works for you as well.

Thanks.

[car86l]

Tyroneneous, i'd love to get a more in depth description on how this mod actually works.

Also what MYOB packages it is compatible with.

[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