Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
July 2020
July 2020
Why isn't there an option to import csv in MYOB? Who made the decision to put that project in the too hard basket? Do you want me to fix it for you?
Does anyone have a resolution to null value fields for a tab delimited txt file?
I want to import a sales invoice with commas in the description field. What are the options?
Solved! Go to Solution.
July 2020
July 2020
It's been a little while, but I do recall having the option to choose between tab delimited and comma delimited data format when importing, I had a quick read (and watch) of this article and that confirmed the data format selector options: Importing data
Although I do remember that anyone that has a .csv file it can't be seen by ARL by default, from memory you just need to change the File Type selector in the bottom-right of the File Browser to say "All Types" to be able to pick up the .csv file.
In terms of a null value, as I understand it; if there's a field that has no data it should be left empty in the import data. IIRC it will be considered an empty string. Or you can leave the field out altogether to avoid that scenario.
I am not up to speed on if there is a bug with null values on imports, did a quick search and couldn't see anything specific pop up. Is that what you're referring to?
And for having commas in the Description text in a comma-separated data import, you should be able to just surround the text with double quotations in the relevant description field to import it. Is this not working on your data imports?
Cheers,
Hayden
MYOB Product Team
Currently Working On:
Supplier Feeds | E-invoicing
In Tray
Previously Worked On:
MYOB Capture App | MYOB Invoices app
MYOB Support (2015-2019)
August 2020
August 2020
Out-effing-standing! CSV's should be the default option for Imorting field based data (in my opinion). The option to solve all my problems WAS an option all along, I just had to disregard all the current documentation and I'm good to go.
The article you and I both read, advised: "you'll need to export the data you want from the program you’ve used to create the data and save it in a tab-delimited or comma-separated text file."
But I thank you for providing information that should have been made readily available to anyone looking to import data.
4
|
654
|
|||
by
Hcbp
September
8
1646
|
8
|
1646
|
||
3
|
470
|
|||
1
|
1630
|
|||
1
|
587
|