Uploading creditors and debtors - spreadsheet format

Hi All

I have managed to work out the format for importing debtors and creditors into Turbocash. If you have many of these to create it might be easier to create them using a spreadsheet and then upload them rather than creating individual debtors/creditors.

Let me know if you would like a copy of the spreadsheets.

Best wishes from the UK

Alex

Views: 143

Reply to This

Replies to This Discussion

Hi Alex

I have just joined TurboCash (4.7 Build 838) to try it out and see if it will work for my needs, have started by entering some debtors then exported them, added to the resulting exported file then tried to import the csv or txt file but I get the error message "Field SACCOUNTCODE not found in import!", I would therefore greatly appreciate your spreadsheet(s) please

Thanks in Advance

Regards

Patrick

Hi Patrick

Yes I have solved this, was making up a demo file last night...

Will post it on my blog page when finished

Alex

Hi Patrick and Philip

Have just realised that I can post files here too. You can import debtors and creditors at the same time.

There are two files: an excel one with formulae to generate unique debtor and creditor codes (based on row number) and a tab separated file ready to import both debtors and creditors into Turbocash 4. The debtor account numbers start with D1 and creditors C2. You need to choose the 'tab separated' option or the import does not work.

I also noticed in doing the upload that 'separated' is spelled wrong in the import screens. It might be worth making this change in the current codebase (if not already done).

Any questions - let me know.

Alex

Attachments:
Just noticed on my mobile that the files are not visible: you might have to go on to your computer to see them.

A couple of images to help users new to this to find their way. Be sure to use Tab delimited, not comma separated.

Thanks Alex,

Will give it a try

Regards

Patrick

Al Brewer said:

Hi Patrick and Philip

Have just realised that I can post files here too. You can import debtors and creditors at the same time.

There are two files: an excel one with formulae to generate unique debtor and creditor codes (based on row number) and a tab separated file ready to import both debtors and creditors into Turbocash 4. The debtor account numbers start with D1 and creditors C2. You need to choose the 'tab separated' option or the import does not work.

I also noticed in doing the upload that 'separated' is spelled wrong in the import screens. It might be worth making this change in the current codebase (if not already done).

Any questions - let me know.

Alex

Reply to Discussion

RSS

Blog Posts

The Case against Bitcoin

Posted by Philip Copeman on December 5, 2017 at 16:44 0 Comments

Will blockchain be enduring? – of course. Will Bitcoin be enduring? - not likely.





Unless you are familiar with the terminology of blockchain, having an argument about its future is like arguing with a physicist about the Big Bang. Right now the myopia caused by ignorance centres the crpyto discussion on Bitcoin, store of value and speculative demand. The real delivery of money, the medium of exchange and the unit of account that blockchain brings to anything from IOT…

Continue

Crypto Currencies

Posted by Philip Copeman on October 25, 2017 at 11:53 3 Comments

Economist Dawie Roodt takes the typical neoliberal line on Crypto Currencies. This would be the expected response of an economist who's salary depends on pleasing his big business bosses.

Dawie, Crypto Currencies are not some parochial kids idea, they stand somewhere between a new internet protocol and a digital pitch fork revolution.…

Continue

A glimpse of the future

Posted by Philip Copeman on September 7, 2017 at 15:30 0 Comments

Open source software and economic inequality

Posted by Philip Copeman on May 4, 2017 at 14:00 1 Comment

Open source software offers Governments the opportunities to build the knowledge economy and built it inclusively.

The World Economic Forum roadshow is back in town again. Economic experts on sponsored trips with generous expense accounts check into the beach front hotels amid fan fair and flashing cameras. They are offering us more advice than President Trump gets. Exotic terms like “inclusi…

Continue

Events

Videos

  • Add Videos
  • View All

© 2017   Created by Philip Copeman.   Powered by

Badges  |  Report an Issue  |  Terms of Service