Jump to content
The site is updated on a beta version. Maintenance tasks are running so search and index may not function at this time. ×

Exporting text to MYOB


This topic is 5883 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I export financial data from FM which our accounts department imports into MYOB without any problem (on a daily basis). I export comma-separated text (.csv). I don't know if that would make a difference?

Link to post
Share on other sites

Tried .csv export/import. MYOB still does not read the file as separate records. Even when I edit the text file directly and add carriage returns, MYOB skips the records. The MYOB error log says that the cards don

Link to post
Share on other sites

Exactly what transactions are you importing into MYOB?

Have you doublechecked that your fields correspond with MYOB's fields? MYOB has a bad habit of occasionally adding/removing a field and not recording this in the help. Try exporting some of your transactions and then checking them aginst your data.

Link to post
Share on other sites

did you ever resolve those problems and find a way to get a carriage return between exported records on mac ?

I have been manually using simple text to put returns and MYOB was ok with that , now I switched to OSX the returns I put in with text edit are not working.

m

Link to post
Share on other sites

mbcookman, was that actually addressed to me? Sorry, I can remember problems not solutions. I have a sneaking suspicion the CRs was one of the reasons we converted from Mac to PC. So, no, we didn't ever resolve the problem.

Or did we? I have a vague recollection that MYOB wants NL/CR, not just CR and I tore my hair out trying to insert hex characters in FMP.

Sorry I can't be more help.

I'm not sure about this. I think if you import a CSV file into Excel it will do the job a line/record at a time. When you export, you should get CRs.

Link to post
Share on other sites

Wouldn't that be CR/NL? That's what I get if I save a text file as DOS format (in BBEdit, Mac). Or is MYOB odd? Are you on a Mac? I posted an example file that exported a Windows .csv file from Mac FileMaker on another forum. I could go find it if you want to try it.

Link to post
Share on other sites

I hope that means you've solved the problem. I am staying awake at night trying to remember details. Was about to suggest double CRs! Unfortunately, around the time we had the problem, my customer was playing around with moving from all Mac to Mac/PC. The following are idle remembrances -

Did I have a problem moving a .TAB from one platform to another?

Was MYOB giving the appearance of stripping off the CRs? I think the Mac version did this. I remember calling MYOB who were totally useless.

Link to post
Share on other sites

This topic is 5883 days old. Please don't post here. Open a new topic instead.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.