Importing Accounts and Addresses - Revision history

Steve: Undo revision 6477 by Steve (talk)

2018-02-22T08:11:15Z

Undo revision 6477 by Steve (talk)

← Older revision	Revision as of 08:11, 22 February 2018
Line 1:	Line 1:
		== Importing Accounts and Addresses ==

		WARNING: You should trial out importing in test database first.

		Before you start importing anything make sure that you use the clearing procedure to clear down any old data first.

		You can either have accounts and addresses columns in a single file or separate files. Whichever way you go, importing accounts and addresses is a two step process and addresses can only be imported after accounts.

		The import file must be in tab delimited text format and its name must be a maximum of eight characters with no spaces and a three character extension.

		The import is done in the NEOSYS maintenance mode using F5 and all NEOSYS listening processes must be shutdown.

		=== ACCOUNT columns ===

		*ACCOUNT NO - required, alphanumeric plus "/" or "-" characters only.
		*ACCOUNT NAME - required
		*LEDGER CODE - required, must exist in Chart of Accounts File
		*ACCOUNT TERMS - optional positive integer days to to pay 0 for Cash, 30, 60, 90 etc
		*CURRENCY CODE - optional, must exist in Currency File
		*TAX CODE - optional, must exist in Taxes File

		=== ADDRESS columns ===

		*ACCOUNT NO - required, must preexist in a chart of accounts
		*ACCOUNT NAME - required
		*ADDRESS - required, should be up in one column containing to four lines in quotes and separated by cr/lf characters<br> OR four columns "ADDRESS 1" ... "ADDRESS 4".
		*COUNTRY - required, no restrictions
		*TEL - optional, free format so you can put multiple numbers and comments, appears on statements and forecast of payments.
		*EMAIL - optional (ditto)
		*FAX - optional (ditto)
		*COMPANY REG NO - optional
		*COMPANY TAX NO - optional

		In the following example the account and address data columns exist in a single file called ACCOUNTS.TXT.

		=== Importing Accounts ===

		First verify that accounts can be imported and correct any errors before proceeding.

		IMPORTX D:\ACCOUNTS.TXT ACCOUNTS

		Actually import the accounts with the C option (Create).

		IMPORTX D:\ACCOUNTS.TXT ACCOUNTS (C)

		Option O can be used to overwrite (destroy!) existing records. Use with extreme caution and at your own risk.

		Use NEOSYS, Finance, Ledgers, Chart of Accounts to check that the above has created accounts in the expected chart of accounts.

		=== Importing Addresses ===

		First verify the addresses can be imported and correct any errors before proceeding. Can only be done after importing the accounts.

		IMPORTX D:\ACCOUNTS.TXT ADDRESSES

		Actually import the addresses with the C (Create) option.

		IMPORTX D:\ACCOUNTS.TXT ADDRESSES (C)

		Option O can be used to overwrite (destroy!) existing records. Use with extreme caution and at your own risk.

Steve: Blanked the page

2018-02-22T08:10:40Z

Blanked the page

← Older revision		Revision as of 08:10, 22 February 2018
Line 1:		Line 1:
	~~== Importing Accounts and Addresses ==~~

	~~WARNING: You should trial out importing in test database first.~~

	~~Before you start importing anything make sure that you use the clearing procedure to clear down any old data first.~~

	You can either have accounts and addresses columns in a single file or separate files. Whichever way you go, importing accounts and addresses is a two step process and addresses can only be imported after accounts.

	~~The import file must be in tab delimited text format and its name must be a maximum of eight characters with no spaces and a three character extension.~~

	~~The import is done in the NEOSYS maintenance mode using F5 and all NEOSYS listening processes must be shutdown.~~

	~~=== ACCOUNT columns ===~~

	*ACCOUNT NO - required, alphanumeric plus "/" or "-" characters only.
	*ACCOUNT NAME - required
	*LEDGER CODE - required, must exist in Chart of Accounts File
	*ACCOUNT TERMS - optional positive integer days to to pay 0 for Cash, 30, 60, 90 etc
	*CURRENCY CODE - optional, must exist in Currency File
	*TAX CODE - optional, must exist in Taxes File

	~~=== ADDRESS columns ===~~

	*ACCOUNT NO - required, must preexist in a chart of accounts
	*ACCOUNT NAME - required
	*ADDRESS - required, should be up in one column containing to four lines in quotes and separated by cr/lf characters<br> OR four columns "ADDRESS 1" ... "ADDRESS 4".
	*COUNTRY - required, no restrictions
	*TEL - optional, free format so you can put multiple numbers and comments, appears on statements and forecast of payments.
	*EMAIL - optional (ditto)
	*FAX - optional (ditto)
	*COMPANY REG NO - optional
	*COMPANY TAX NO - optional

	~~In the following example the account and address data columns exist in a single file called ACCOUNTS.TXT.~~

	~~=== Importing Accounts ===~~

	~~First verify that accounts can be imported and correct any errors before proceeding.~~

	~~IMPORTX D:\ACCOUNTS.TXT ACCOUNTS~~

	~~Actually import the accounts with the C option (Create).~~

	~~IMPORTX D:\ACCOUNTS.TXT ACCOUNTS (C)~~

	~~Option O can be used to overwrite (destroy!) existing records. Use with extreme caution and at your own risk.~~

	~~Use NEOSYS, Finance, Ledgers, Chart of Accounts to check that the above has created accounts in the expected chart of accounts.~~

	~~=== Importing Addresses ===~~

	~~First verify the addresses can be imported and correct any errors before proceeding. Can only be done after importing the accounts.~~

	~~IMPORTX D:\ACCOUNTS.TXT ADDRESSES~~

	~~Actually import the addresses with the C (Create) option.~~

	~~IMPORTX D:\ACCOUNTS.TXT ADDRESSES (C)~~

	~~Option O can be used to overwrite (destroy!) existing records. Use with extreme caution and at your own risk.~~

Steve: /* ADDRESS columns */

2012-12-13T23:21:34Z

ADDRESS columns

← Older revision		Revision as of 23:21, 13 December 2012
Line 26:		Line 26:
	*ADDRESS - required, should be up in one column containing to four lines in quotes and separated by cr/lf characters<br> OR four columns "ADDRESS 1" ... "ADDRESS 4".		*ADDRESS - required, should be up in one column containing to four lines in quotes and separated by cr/lf characters<br> OR four columns "ADDRESS 1" ... "ADDRESS 4".
	*COUNTRY - required, no restrictions		*COUNTRY - required, no restrictions
	*~~TELEPHONE~~ - optional, free format so you can put multiple numbers and comments, appears on statements and forecast of payments.		*TEL - optional, free format so you can put multiple numbers and comments, appears on statements and forecast of payments.
	*EMAIL - optional (ditto)		*EMAIL - optional (ditto)
	*FAX - optional (ditto)		*FAX - optional (ditto)

Steve: /* ADDRESS columns */

2012-12-13T01:23:16Z

ADDRESS columns

← Older revision		Revision as of 01:23, 13 December 2012
Line 24:		Line 24:
	*ACCOUNT NO - required, must preexist in a chart of accounts		*ACCOUNT NO - required, must preexist in a chart of accounts
	*ACCOUNT NAME - required		*ACCOUNT NAME - required
	*ADDRESS ~~BODY~~ - required, should be up to four lines in quotes and separated by cr/lf characters.		*ADDRESS - required, should be up in one column containing to four lines in quotes and separated by cr/lf characters<br> OR four columns "ADDRESS 1" ... "ADDRESS 4".
	*COUNTRY - required, no restrictions		*COUNTRY - required, no restrictions
	*TELEPHONE - optional, free format so you can put multiple numbers and comments, appears on statements and forecast of payments.		*TELEPHONE - optional, free format so you can put multiple numbers and comments, appears on statements and forecast of payments.

Steve: /* Importing Accounts and Addresses */

2012-12-12T22:09:51Z

Importing Accounts and Addresses

← Older revision		Revision as of 22:09, 12 December 2012
Line 1:		Line 1:
	== Importing Accounts and Addresses ==		== Importing Accounts and Addresses ==

			WARNING: You should trial out importing in test database first.

	Before you start importing anything make sure that you use the clearing procedure to clear down any old data first.		Before you start importing anything make sure that you use the clearing procedure to clear down any old data first.

Steve: /* Importing Accounts */

2012-12-12T22:08:01Z

Importing Accounts

← Older revision		Revision as of 22:08, 12 December 2012
Line 42:		Line 42:
	IMPORTX D:\ACCOUNTS.TXT ACCOUNTS (C)		IMPORTX D:\ACCOUNTS.TXT ACCOUNTS (C)

	Option O can be used to overwrite (destroy!) existing records. Use with extreme caution.		Option O can be used to overwrite (destroy!) existing records. Use with extreme caution and at your own risk.

	Use NEOSYS, Finance, Ledgers, Chart of Accounts to check that the above has created accounts in the expected chart of accounts.		Use NEOSYS, Finance, Ledgers, Chart of Accounts to check that the above has created accounts in the expected chart of accounts.

Steve: /* Importing Addresses */

2012-12-12T22:07:37Z

Importing Addresses

← Older revision		Revision as of 22:07, 12 December 2012
Line 52:		Line 52:
	IMPORTX D:\ACCOUNTS.TXT ADDRESSES		IMPORTX D:\ACCOUNTS.TXT ADDRESSES

	~~Import~~ the addresses with the C (Create) option.		Actually import the addresses with the C (Create) option.

	IMPORTX D:\ACCOUNTS.TXT ADDRESSES (C)		IMPORTX D:\ACCOUNTS.TXT ADDRESSES (C)

	Option O can be used to overwrite (destroy!) existing records. Use with extreme caution.		Option O can be used to overwrite (destroy!) existing records. Use with extreme caution and at your own risk.

Steve: /* Importing Accounts */

2012-12-12T22:06:54Z

Importing Accounts

← Older revision		Revision as of 22:06, 12 December 2012
Line 38:		Line 38:
	IMPORTX D:\ACCOUNTS.TXT ACCOUNTS		IMPORTX D:\ACCOUNTS.TXT ACCOUNTS

	~~Import~~ the accounts		Actually import the accounts with the C option (Create).

	IMPORTX D:\ACCOUNTS.TXT ACCOUNTS (U)		IMPORTX D:\ACCOUNTS.TXT ACCOUNTS (C)

	Option O can be used to overwrite (destroy!) existing records. Use with extreme caution.		Option O can be used to overwrite (destroy!) existing records. Use with extreme caution.

Steve: /* Importing Addresses */

2012-12-12T22:05:59Z

Importing Addresses

← Older revision		Revision as of 22:05, 12 December 2012
Line 52:		Line 52:
	IMPORTX D:\ACCOUNTS.TXT ADDRESSES		IMPORTX D:\ACCOUNTS.TXT ADDRESSES

	Import the addresses		Import the addresses with the C (Create) option.

	IMPORTX D:\ACCOUNTS.TXT ADDRESSES (C)		IMPORTX D:\ACCOUNTS.TXT ADDRESSES (C)

			Option O can be used to overwrite (destroy!) existing records. Use with extreme caution.

Steve: /* Importing Accounts */

2012-12-12T22:05:05Z

Importing Accounts

← Older revision		Revision as of 22:05, 12 December 2012
Line 40:		Line 40:
	Import the accounts		Import the accounts

	IMPORTX D:\ACCOUNTS.TXT ACCOUNTS (C)		IMPORTX D:\ACCOUNTS.TXT ACCOUNTS (U)

			Option O can be used to overwrite (destroy!) existing records. Use with extreme caution.

	Use NEOSYS, Finance, Ledgers, Chart of Accounts to check that the above has created accounts in the expected chart of accounts.		Use NEOSYS, Finance, Ledgers, Chart of Accounts to check that the above has created accounts in the expected chart of accounts.