Forum Discussion
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.
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.
- MarnieMYOB2 years agoContributing User
Many thanks Samara
I've spoken to the client and we're still a little confused. Hoping you can help.
Currently we import Timesheets for payroll, which includes the Payroll categories of Base Hourly etc.
To then import the hours into a job for job costing (which is in a separate Company file), we were attempting to do this via the Activity Slip import. However haven't been successful so far (see above info). Are we supposed to first upload the timesheet file into the separate Company before uploading the Activity Slip?
Having a look at your last message and the information that we have in the initial Activity Slips import seems to be correct. For the Hourly Activity Types, we are entering this in the Units column.
Also confirming 'Activity ID' is the name eg Project Management, and not a unique numerica ID such as 12345. If it's the latter, the client has no visibility in the front end of this number.
Many thanks
- MarnieMYOB2 years agoContributing User
Hi Samara - if you could respond to the query below, I'd appreciate it.
Thanks