Can anyone assist with this issue occuring again? See thread 'Item Export Data Corrupt' for further info. No tabs located in data to push info into the incorrect columns, it is just exporting data incorrectly. Any help would be muchly appreciated as trying to complete a full price check. See screenshots below: Exported Data: MYOB Data: Export Data: MYOB Data:

Hi _Zentra Please send me your product serial number and company file name by Private Message, and I'll run the script to check if that resolves this issue. Update: Ran script to fix the issue

Item Export Data Corrupt - Recurring Issue

tbaalham
Experienced Cover User
3 years ago
Hey _Zentra just letting you know, your screen shots don't seem to be visible, at least not to me. Also cannot locate the thread you mentioned. Good luck!
- gavin12345
  Ultimate User
  3 years ago
  Hi _Zentra
  
  As mentioned by tbaalham , the images are blocked (until a moderator reviews and clears them). So difficult to know exact cause of the issue. Most likely cause is the Description field. Some fields such as Description allow a user to enter a 'new line' or a carriage return. This looks fine on screen however is known to mess exports. In the export file this new line causes a new line, throwing all subsequent columns out.
  
  If this is the cause, try exporting without and field that causes this issue.
  
  Regards
  Gavin
  - _Zentra
    Experienced User
    3 years ago
    Hi gavin12345 and tbaalham ,
    
    Thanks for your reply. It doesn't appear to be description issue as data is exporting to correct columns, just in the incorrect fields. I did have this as a solution previously (https://community.myob.com/t5/AccountRight-Sales-and-purchases/Item-Export-Data-Corrupt-Possible-Cause-of-Issue/m-p/748469) but unfortuately is not the case for this one. I did try exporting without extended description and same issue occurs.
    
    Previously, I have had a script run over the file and this has helped, but so far no contact from MYOB to assist with this. The only other option was a third party report (https://community.myob.com/t5/AccountRight-Sales-and-purchases/Item-Export-Data-Corrupt/td-p/584668/page/2) but this was also not feasable as had to be altered everytime an upgrade was completed. We did not want to continue spending additional money on a service that should work in the monthly rate we already pay to MYOB.
    
    All suggestions appreciated though, and happy to try any other ideas anyone may have! :)

Forum Discussion

Item Export Data Corrupt - Recurring Issue

Looking for something else?

Related content

CORRUPT EMPLOYEE CARD

how do I export and import recurring transactions

Employees corrupt card file

Corruption in the MYOB account right file

Corrupted Employee Card

Foreign Currency - Receivables Reports Corrupted!

Recurring Sales Order

Recurring transactions fault