Forum Discussion
Hi there - it's been two weeks since I posted this query. If MYOB are able to get back to me, I'd appreciate it.
Thanks in advance
- SamaraM2 years agoFormer Staff
Hi MarnieMYOB
Sorry to see that no one has replied to you yet. I've had a look at the file you attached, and you have put the Activity Type as "Project Management" which should be either " " or "X", and the Customer has "(data removed)", which sounds odd; I am assuming there isn't a customer named "(data removed)"?For a list of the field formats please refer to our Help Article: Import and export fields
For help creating a template, I have also provided a Help Article on that: Using an import template.
If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.
- MarnieMYOB2 years agoContributing User
Thanks Samara for your response.
Just to clarify:
- For Activity Type - are you suggesting the column relating to Activity Type is left blank or an X? I thought for the Activity Slip import to work, Activity Type is a mandatory field and a key to importing the data correctly. FYI - there are a number of different Activity Types set up for employees in my customer's MYOB. This then assigns the appropriate cost. Please advise
- For Customer First Name - this information was deemed sensitive, therefore the info was deleted from the csv file and replaced with (data removed). Apologies for the confusion.
If you could assist, I'd appreciate it.
Thanks
- SamaraM2 years agoFormer Staff
Hi MarnieMYOB
For the Activity Type, there are only 2 options:
- If it was Non‑Hourly - you would put X under Non-hourly field.
- If it was Hourly - you would leave the Non-hourly field blank.
The Activity ID would be the field that is mandatory, as the software needs to know what activity to match it to.
As for the Name, thanks for clarifying. I would just double-check they are identical, so making sure the spelling is exactly the same and there isn't an extra character like a space at the end.
Hope that helps.
If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.