growerp

Description:

growerp

GrowERP utilities #
A command line utility to easy install/import/export
Activate local version:
dart pub global activate --source path ~/growerp/flutter/packages/growerp
copied to clipboard
Activate public version:
dart pub global activate growerp
copied to clipboard
The Basic global dart GrowERP command. #
Sub commands:
install: #

clone the repository from github into the local ~/growerp directory
start the backend and chat server
activate the dart melos global command.
build the flutter system
package 'admin' can now be started with flutter run.

import: #
will upload data like ledger(glaccount), customers products etc from the terminal
Also has a helper program convertToCsv to convert your files to the
GrowERP CSV format.
Parameters

-i input file or directory, if directory will process filenames according the [FileType]
-u -p user/password optional, will remember from last time
-url the base url of the backend, local host is default
-f optional filetype, is missing will process all filetype in the specified dir

finalize: #
After all imports, this will finalize the import

complete all documents which have been posted in the ledger
complete order of which the invoice is completed
complete past time periods

export: (partly developed) #
will create CSV files for growerp entities in the current 'growerp'
directory, if not exist will create it.
Parameters:

-f optional filetype, is missing will process all filetypes

flags: #

-dev if present uses development branch by installation
-i filename : input file
-u user : email address, with password create new company otherwise use last one
-p password : required for new company
-o outputDirectory : directory used for exported csv output files,default: growerp
-url for import/export backend url
-t receive timeout: default 60 seconds
-f optional filetype [FileType] like glAccount, product, category etc...

the convertToCsv command #
this command converts from your exported csv/ods/xlsx files to the GrowERP csv files to import. This command provides an example which was used for an existing customer previously using a SAGE50 system
input parameters:

mandatatory the input directory name
optional the filetype, if missing all filetypes

examples:
dart run ~/growerp/flutter/packages/growerp/bin/convertToCsv.dart inputDir transaction
copied to clipboard
or after the activate growerp at the top:
dart pub global run growerp:csvToCsv inputDir
copied to clipboard
will create a new directory: growerpOutput with the converted file(s).
The conversion workflow #

Extract csv/ods/xlsx files from the old system and put them in a single directory.
When importing images create an 'images' directory and a images.csv file in the format: filetype,id,filename
Specify the conversion rules.

specify the names of these files in the getFileNames function
specify any file wide changes in the convertFile function
specific the column to column conversion the convertRow function


convert the old system files to the GrowERP CSV format into the growerpOutput directory

execute activate:

dart pub global activate --source path ~/growerp/flutter/packages/growerp
copied to clipboard

run conversion for a single file type for testing (date optional)
for creating starting balances you need at least a start date for the transactions

dart pub global run growerp:csvToCsv inputDir -f fileType -start yyyy/mm/dd -end yyy/mm/dd
copied to clipboard

run conversion for all files

dart pub global run growerp:convertToCsv inputDir
copied to clipboard

Import the generated GrowERP csv files into the growerp system

execute activate

dart pub global activate growerp
copied to clipboard

import the generated files into the growerp system for a single file type

growerp import -i growerpOutput -d fileType -u username -p password
copied to clipboard

import all files

growerp import -i growerpOutput -u username -p password
copied to clipboard