KenM Posted June 13, 2017 Share Posted June 13, 2017 I have been so far been singularly unsuccessful with Importing CSV data, say customer lists etc. Being an engineer I have gone back to simpler analysis skills. 1: Let's see what format NCH actually creates for a CSV, so I added to customers by hand in NCH Express Invoice, which worked OK, then Exported the list to a CSV file with defaults etc. The result I got you can see below: "Customer","Contact","FirstName","Address","Shipping Address","Phone","Phone2","Fax","EMail","Notes","Salesperson","Additional Info" "Joe Bloggs","Joe Bloggs","Joe","","","011 888 1957","","","kenm@openworldit.co.za","","","" "Mary JANE","Mary JANE","Mary","","","011 888 1957","","","kenmurd@gmail.com","","","" I think the key is to ensure the correct format of the CSV, please note the " [ quotes ] around the data fields etc. My next step is to confirm this by re-importing from the above 2 line export file. If it works then we have a 'Template' showing clearly how our foreign data should be formatted to be handled correctly by Express Invoice. As i confirm my suspicions to be true or not I will feedback my results to this topic on this Forum. I welcome all comments and shared experiences to be added. Otherwise have a great day all. Link to comment Share on other sites More sharing options...
KenM Posted June 13, 2017 Author Share Posted June 13, 2017 UPDATE: I SUCCESSFULLY imported from the simple 2 line CSV I had exported from Express Invoice, the Field assignment process works 100%, so if we stick to the CSV rules a detailed above then I believe all should work as expected. For foreign data we need to a bit of bulk editing to ensure the data meets the requirements. Onwards and upwards... Link to comment Share on other sites More sharing options...
gsw Posted June 17, 2017 Share Posted June 17, 2017 How did you export the data from Invoice Express? I want to export all of the "Items" data from Invoice Express and then import it into the Inventoria app and then allow the the sync process manage the items between both Invoice Express and Inventoria Link to comment Share on other sites More sharing options...
Mammonist Posted April 26, 2019 Share Posted April 26, 2019 I have a similar question to the one posed by gsw. How do I export all my Express Invoice data to csv or Excel? Thanks. Link to comment Share on other sites More sharing options...
Jsalgado Posted April 30, 2019 Share Posted April 30, 2019 There is no way to export the whole data to CSV, you can only export your customer list. Go to "Customer list" highlight all your customers, click on "Customers" located on the top left and then "Export to CSV (for mail merge)". Link to comment Share on other sites More sharing options...
ashyranky@gmail.com Posted February 19, 2020 Share Posted February 19, 2020 @gsw, Its not good news the vibes I'm getting here regarding exporting to csv, you found a solution? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now