Importing professional sales

HVE

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?

Haydes

@HVE 

 

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?