Import/Export Assistant issue under 2020.1

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
DevanshiM
Contributing Cover User
6 Posts
Contributing Cover User
Australia
Contributing Cover User

6Posts

0Kudos

0Solutions

Re: Import/Export Assistant issue under 2020.1

Thanks a ton Chante and Judy Ann.

 

It worked and super efficient.

someone
Experienced Cover User
86 Posts
Experienced Cover User
Australia
Experienced Cover User

86Posts

36Kudos

1Solutions

Re: Import/Export Assistant issue under 2020.1

Adding @Steven_M  @Neil_M @Suja_P from MYOB to get it on their radar and escalated, as this is a breaking change

Chante
Contributing Cover User
7 Posts
Contributing Cover User
Australia
Contributing Cover User

7Posts

8Kudos

1Solutions

Re: Import/Export Assistant issue under 2020.1

hi

 

the excel file is not created by me, it is also a file that is generated from another system. and you are right, i do need to re-graogram it by deleting all the unnecesory columns and fill in the blank cells.

even it is fixed, it means that i need do extra work to make it work, unfortunitely.  Until MYOB makes some proper changes to its next version, we probably all need do the extra. 

leibholdqpbc
Experienced User
28 Posts
Experienced User
Experienced User

28Posts

4Kudos

0Solutions

Re: Import/Export Assistant issue under 2020.1

Yes. And unfortunately I have an issue with export. So creating a "template" file orm the company is impossible.

 

I am going through the process of creating the same accounts etc in clearwater so I can export to test.

 

Oh happy days.

 

 

Chante
Contributing Cover User
7 Posts
Contributing Cover User
Australia
Contributing Cover User

7Posts

8Kudos

1Solutions

Re: Import/Export Assistant issue under 2020.1

Good luck with that ^_^

 

I think people here should file an official complaint about this so that the issue can be accelerated and fixed in next version. I hope I have time to do this, but waiting on the phone for 2 hours or talking to some no one online support who does not even have an idea is not quite something I am capable of at this stage.

someone
Experienced Cover User
86 Posts
Experienced Cover User
Australia
Experienced Cover User

86Posts

36Kudos

1Solutions

Re: Import/Export Assistant issue under 2020.1


@Chante wrote:

Good luck with that ^_^

 

I think people here should file an official complaint


problem is that there is nowhere to lodge the complaint, cause if there was they would be bombarded and MYOB know it

gavin12345
Ultimate User
3,370 Posts
Ultimate User
Australia
Ultimate User

3,370Posts

2,351Kudos

470Solutions

Re: Import/Export Assistant issue under 2020.1

Hi @Chante 

 

Are you able to clarify what exactly is the issue caused by the update - most of what you wrote in your 'Accepted Solution' post above is normal behaviour, this is how importing has worked in the past, use {} and taking care with the mapping. The only difference is the 'delete blank columns' - is this the problem? the export is adding blank columns? Yet some users where the import file was not an export file are also having problems. 

 

I am keen to understand what has changed with imports in this update.

 

Regards

Gavin

Chante
Contributing Cover User
7 Posts
Contributing Cover User
Australia
Contributing Cover User

7Posts

8Kudos

1Solutions

Re: Import/Export Assistant issue under 2020.1

Hi Gavin

 

I am not from MYOB, nor do I have any IT or programming background. I just simply shared what has been done during the phone conversation with the MYOB support staff, and those actions make the Import work.

I do not use Export function, therefore I can not speak for that.

 

I suggest you contact MYOB, it is frustrating, yet I still got some help that works.

leibholdqpbc
Experienced User
28 Posts
Experienced User
Experienced User

28Posts

4Kudos

0Solutions

Re: Import/Export Assistant issue under 2020.1

I would have to say that it appears to be less forgiving

 

A $ in the amount might make it stop.

Or a space in front of the amount

An Extra Carrage or line feed makes it miss  all of the following lines with a amount incorrect -25 error

 

MYOB doesnt appear to be able to manage developers commits to production environment

boundtoimpress
Experienced Cover User
29 Posts
Experienced Cover User
Australia
Experienced Cover User

29Posts

37Kudos

0Solutions

Re: Import/Export Assistant issue under 2020.1

Still no word from support regarding this?


Come on guys we are paying good money for support of this product and you're really letting the side down by allowing things like this to creep in, it creates inordinate amounts of work for your loyal and paying customers when something that's been working for years suddenly breaks.

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post