Thanks!
Half way there. 
26 10/10/2021 08:41:38 am
Re: Private Messages (16 replies, posted in Announcements)
27 10/09/2021 08:46:09 am
Re: Sage 100 Data Import (6 replies, posted in Setup)
Thanks!
That makes sense.
28 10/09/2021 07:55:53 am
Re: Sage 100 Data Import (6 replies, posted in Setup)
I created a new company 1_ and decided I wanted to start over. I deleted the company and tried to use 1_ again but my only option is 2_ or None. Where is this drop down getting its data from so I can reset it?
29 10/07/2021 08:24:55 am
Re: Private Messages (16 replies, posted in Announcements)
Joe,
How about allowing attachments? It would be great to attach screens shots and code as text.
30 10/06/2021 07:20:43 am
Re: Withdraw the cash directly from the company for personal use (10 replies, posted in Banking and General Ledger)
Is the owner taking a paycheck or only doing cash withdraws from the business bank account?
31 10/06/2021 07:12:59 am
Re: Agricultural accounting (5 replies, posted in Misc. Charts of Accounts)
I have been thinking about using FA for the cannabis industry for growers. I worked with the WA LEAF seed to sale state tracking software testing their API for developers. I also own the CannabisSoftware.US domain that is dormant. The biggest problem I've encounter is getting financial institutions (banks) to work with you. The SAFE banking act seems stalled.
I would be interested in talking to private investors that would like to see an open source direction for producers bound by strict state tracking requirements.
32 09/25/2021 03:27:17 am
Re: Sage 100 Data Import (6 replies, posted in Setup)
Does FA do rollups on G/L account number segments?
I'm assuming I can use Dimensions as a substitute for Sage 100 Divisions?
33 09/25/2021 12:54:06 am
Re: Sage 100 Data Import (6 replies, posted in Setup)
Thanks kvvaradha!
That was very helpful. I must of missed it in my last peek at the wiki.
34 09/24/2021 04:38:06 am
Topic: Sage 100 Data Import (6 replies, posted in Setup)
I'm seriously thinking about doing a Sage 100 to FA data migration utility. Sage has transitioned to a subscription model which prices keep rising every time I check. Many of the MAS90 / Sage 100 users that bought the software aren't happy about buying it again on subscription.
Is there any FA schema docs that might help me with my mapping and translation effort?
Thanks!
John
35 04/25/2018 06:23:54 pm
Re: Company Table (6 replies, posted in Setup)
That was just what I was looking for.
Thanks for your help and guidance with my questions using FrontAccounting.
My goal is to provide data conversions and theme enhancements for Sage 100 (MAS90) and Intuit Enterprise users. Trying to host these packages in the cloud using RDP is hybrid garbage. Not to mention the high cost of going that direction.
36 04/23/2018 07:34:53 pm
Re: Company Table (6 replies, posted in Setup)
What I'm confused about which isn't well explained is the format of the Dimension Code. Can I just use 01 as a my division code with no trailing /?
37 04/23/2018 04:46:30 am
Re: Company Table (6 replies, posted in Setup)
Thanks!
If I have division with a code of 01, 02, ... , what would my Dimension look like if I ignore the start/stop dates?
38 04/22/2018 07:18:27 pm
Topic: Company Table (6 replies, posted in Setup)
I'm unable to find the table that contains the company information used when doing company setup.
I'm trying import data from another accounting package and surprised there was't a company table.
*Wish List*
It would be nice to be able to define a permanent dimension for divisions. Having them based on date ranges have limited use IMHO.
39 11/03/2015 05:33:04 am
Re: Script BASIC (17 replies, posted in Announcements)
Script BASIC is an interpreter like php. You can compile Script BASIC applications to C which allow statically linking in its C extensions modules.
I forgot the mention Script BASIC has a GUI desktop debugger/IDE and a remote socket based debugger that is great for debugging a client's web application.
I'll keep you in the loop if a Front Accounting php to Script BASIC port becomes a project.
40 11/03/2015 03:32:39 am
Re: Script BASIC (17 replies, posted in Announcements)
Front Accounting is very well written and would be an easy port to Script BASIC due to everything being class based. I'm seriously thinking of porting it to Script BASIC to attract the Sage 100 (MAS90) crowd. They are Business BASIC centric so a FA in Script BASIC would make sense to them.
41 11/03/2015 02:49:05 am
Re: Script BASIC (17 replies, posted in Announcements)
I use the Apache config (sites-enabled) for the mod_rewrite additions pointing to the /home web directory to forward the request to the sbhttpd server.
42 11/02/2015 04:18:13 pm
Re: Script BASIC (17 replies, posted in Announcements)
If the recommended way to use ScriptBASIC is as a proxy to Apache and Apache runs on port 80 and the proxy runs on say port 8080, must the client then use port 8080 to access the application?
Just standard access on port 80 for the user. In my example, anything out of /home is sbhttpd related.
43 11/02/2015 08:10:28 am
Re: Script BASIC (17 replies, posted in Announcements)
apmuthu wrote:
Hence ScriptBASIC in it's final use case would be to replace the entire Apache/PHP/MySQL stack with a pure ScriptBASIC compiled (or intermediate compiled) alternative and no advantage in using both together.
sbhttpd is a proxy server. It only runs Script BASIC scripts. Apache handles the media, load levelling, security, ... and uses a mod_rewrite for communication with SB.
apmuthu wrote:
What is it that can be done in ScriptBASIC that cannot be just as easily done in PHP?
php is fine for a single instance application. It's resource heavy and interfacing with C is a PITA. Script BASIC works great as a cloud SaaS engine and glue to everything else.
apmuthu wrote:
The reason why PHP in general and FA in particular became popular is that it is in open text form and loosely typed and easy to program for the non programmer. "Protecting / Obfuscating" code will mitigate against the userbase. Proprietary code and compiled applications can hold users to ransom. Those who wish to retain independance in the code they use will run away from it! When acceptable alternatives like ScriptBASIC arrive, there must be a compelling reason to undertake a fresh learning curve and migrate to it.
BASIC is the basis for all other languages following it including php. If you don't know traditional BASIC than you shouldn't be able to to code in the first place.
apmuthu wrote:
With the arrival of Triggers, Procedures and Functions in MySQL, most PHP code can be replaced by them in getting logically directed computed storage done.
A simple Script BASIC MySQL example.
' MySQL Test Program
INCLUDE mysql.bas
dbh = mysql::RealConnect("localhost","root","the_password","classicmodels")
mysql::query(dbh,"SELECT * FROM products")
WHILE mysql::FetchHash(dbh,column)
PRINT column{"productCode"}," - ",column{"productName"},"\n"
WEND
PRINTNL
PRINT "The database handle is: ",dbh,"\n"
PRINT "Affected rows by SELECT: ",mysql::AffectedRows(dbh),"\n"
PRINT "Character set name is: ",mysql::CharacterSetName(dbh),"\n"
PRINT "Last error is: ",mysql::ErrorMessage(dbh),"\n"
PRINT "Client info is: ",mysql::GetClientInfo(),"\n"
PRINT "Host info is: ",mysql::GetHostInfo(dbh),"\n"
PRINT "Proto info is: ",mysql::GetProtoInfo(dbh),"\n"
PRINT "Server info is: ",mysql::GetServerInfo(dbh),"\n"
PRINT "PING result: ",mysql::Ping(dbh),"\n"
PRINT "Thread ID: ",mysql::ThreadId(dbh),"\n"
PRINT "Status is: ",mysql::Stat(dbh),"\n"
mysql::Close(dbh)Output
scriptbasic: ~/sb22/test $ time scriba testmysql.sb
S32_1268 - 1980s GM Manhattan Express
S32_1374 - 1997 BMW F650 ST
S32_2206 - 1982 Ducati 996 R
S32_2509 - 1954 Greyhound Scenicruiser
S32_3207 - 1950's Chicago Surface Lines Streetcar
S32_3522 - 1996 Peterbilt 379 Stake Bed with Outrigger
S32_4289 - 1928 Ford Phaeton Deluxe
S32_4485 - 1974 Ducati 350 Mk3 Desmo
S50_1341 - 1930 Buick Marquette Phaeton
S50_1392 - Diamond T620 Semi-Skirted Tanker
S50_1514 - 1962 City of Detroit Streetcar
S50_4713 - 2002 Yamaha YZR M1
S700_1138 - The Schooner Bluenose
S700_1691 - American Airlines: B767-300
S700_1938 - The Mayflower
S700_2047 - HMS Bounty
S700_2466 - America West Airlines B757-200
S700_2610 - The USS Constitution Ship
S700_2824 - 1982 Camaro Z28
S700_2834 - ATA: B757-300
S700_3167 - F/A 18 Hornet 1/72
S700_3505 - The Titanic
S700_3962 - The Queen Mary
S700_4002 - American Airlines: MD-11S
S72_1253 - Boeing X-32A JSF
S72_3212 - Pont Yacht
The database handle is: 1
Affected rows by SELECT: 110
Character set name is: latin1
Last error is:
Client info is: 5.5.44
Host info is: Localhost via UNIX socket
Proto info is: 10
Server info is: 5.5.44-0ubuntu0.14.04.1
PING result: -1
Thread ID: 0
Status is: Uptime: 5375236 Threads: 1 Questions: 19980 Slow queries: 0 Opens: 627 Flush tables: 1 Open tables: 400 Queries per second avg: 0.003
real 0m0.014s
user 0m0.004s
sys 0m0.002s
scriptbasic: ~/sb22/test $ apmuthu wrote:
As your sbhttpd is a proxy, does it still depend on the availability of a real web server like Apache?
sbhttpd can run standalone for HTTP (non-media) based applications but typically it's a proxy to Apache.
44 11/01/2015 11:51:06 pm
Re: Script BASIC (17 replies, posted in Announcements)
sbhttpd supports in memory sessions with static read/write lockable shared variables between threads and runs as a service. If using ODBC for database access, connection pooling is supported. Appropriate extension modules used on the desktop are usable with sbhttpd.
I'm working on a php to Script BASIC translator but it's not a priority at the moment. I use Ultra Edit search and replace macros to do most of my php to SB conversion now.
I'm just about to release a QuickBooks Online connection to SuiteCRM running as SaaS with sbhttpd mirroring the QBO database in MySQL for instant access and unlimited users.
45 11/01/2015 11:02:01 pm
Re: Script BASIC (17 replies, posted in Announcements)
apmuthu wrote:
Please post some php source interacting with ScriptBASIC source code.
The Script BASIC sbhttpd proxy server is a replacement for PHP. The syntax is traditional BASIC with a sprinkle of Perl and Python syntax mixed in.
Here is the code to the echo example I posted previously.
global const nl = "\n"
Const NumberOfCookies = 3
include cgi.bas
option cgi$Method cgi::Get or cgi::Upload
' cgi::RequestBasicAuthentication "Test Realm"
cgi::Header 200,"text/html"
'
' We are setting several cookies. The expiry time is ten seconds so you can test that
' the cookies are sent by the browser if you press some of the buttons fast enough,
' but it does not if you are slow
'
for i=1 to NumberOfCookies
' cookie(i) is i, no domain is defined, path is /, expires after 5 seconds, not secure
cgi::SetCookie "cookie" & i,i,undef,"/",gmtime()+10,false
next i
cgi::FinishHeader
'-------------------------------------------------------
print """<HTML>
<HEAD>
<title>CGI parameter testing</title>
</HEAD>
<BODY><font face="VERDANA" size="2">
<H1>View CGI Parameters</H1>
This page shows the cgi parameters the way it was uploaded.
<!-- here is the result of the previous HTTP request -->
<FONT SIZE="3">
<PRE>
CGI system variables
--------------------
"""
'-------------------------------------------------------
print "ServerSoftware = ",cgi::ServerSoftware(), nl
print "ServerName = ",cgi::ServerName(), nl
print "GatewayInterface= ",cgi::GatewayInterface(),nl
print "ServerProtocol = ",cgi::ServerProtocol(), nl
print "ServerPort = ",cgi::ServerPort(), nl
print "RequestMethod = ",cgi::RequestMethod(), nl
print "PathInfo = ",cgi::PathInfo(), nl
print "PathTranslated = ",cgi::PathTranslated(), nl
print "ScriptName = ",cgi::ScriptName(), nl
print "QueryString = ",cgi::QueryString(), nl
print "RemoteHost = ",cgi::RemoteHost(), nl
print "RemoteAddress = ",cgi::RemoteAddress(), nl
print "AuthType = ",cgi::AuthType(), nl
print "RemoteUser = ",cgi::RemoteUser(), nl
print "RemoteIdent = ",cgi::RemoteIdent(), nl
print "ContentType = ",cgi::ContentType(), nl
print "ContentLength = ",cgi::ContentLength(), nl
print "UserAgent = ",cgi::UserAgent(), nl
print "Cookie = ",cgi::RawCookie(), nl
print "Referer = ",cgi::Referer(),nl
print "Password = ",Environ("HTTP_PASSWORD"),nl
print "Full auth string= ",Environ("HTTP_AUTHORIZATION"),nl
print "\nCookies:\n"
for i=1 to NumberOfCookies
print "cookie" & i," ",cgi::Cookie("cookie" & i),"\n"
next i
print "Text field using Param(\"TEXT-FIELD\") is ",cgi::Param("TEXT-FIELD"),nl,nl
if cgi::RequestMethod() = "GET" then
print "GET text field using GetParam(\"TEXT-FIELD\") is ",cgi::GetParam("TEXT-FIELD"),nl
end if
if cgi::RequestMethod() = "POST" then
print "POST text field using PostParam(\"TEXT-FIELD\") is ",cgi::PostParam("TEXT-FIELD"),nl
if cgi::ContentType() like "multipart*" then
print "Original file name is ",cgi::FileName("FILE-UPLOAD-NAME"),nl
if cgi::FileLength("FILE-UPLOAD-NAME") > 0 then
print "File of length ",cgi::FileLength("FILE-UPLOAD-NAME")," bytes is saved\n"
on error goto NoSave
cgi::SaveFile "FILE-UPLOAD-NAME","/home/jrs/sb/upload.txt"
else
print "There is no uploaded file."
end if
end if
end if
print """</PRE><TABLE><TR><TD BORDER=0 BGCOLOR="EEEEEE"><PRE>
A simple form to POST parameters:<BR>
<FORM METHOD="POST" ACTION="/home/echo">
<INPUT TYPE="TEXT" VALUE="DEFAULT TEXT" NAME="TEXT-FIELD">
<INPUT TYPE="SUBMIT" NAME="SUBMIT-BUTTON" VALUE=" POST ">
</FORM>
</PRE></TD><TD BORDER=1 width="20"> </TD><TD BORDER=0 BGCOLOR="EEEEEE"><PRE>
A simple form to GET parameters:<BR>
<FORM METHOD="GET" ACTION="/home/echo">
<INPUT TYPE="TEXT" VALUE="DEFAULT TEXT" NAME="TEXT-FIELD">
<INPUT TYPE="SUBMIT" NAME="SUBMIT-BUTTON" VALUE=" GET ">
</FORM>
</PRE></TD></TR></TABLE><PRE>
<hr>
</FORM>
</BODY>
</HTML>
"""
stop
NoSave:
print "An error has happened saving the file. Code =",error(),nl
resume next46 11/01/2015 10:39:09 pm
Re: Script BASIC (17 replies, posted in Announcements)
Here is a cool project a Script BASIC sbhttpd user did. It uses the GD extension module to create live buoy weather data graphics overlayed on satellite images. They use the Script BASIC sbhttpd server for the task.
47 11/01/2015 09:29:27 pm
Re: Script BASIC (17 replies, posted in Announcements)
I have an echo example of the Script BASIC multi-thread HTTP application proxy server running on my www.Koding.com account if you would like to take a peak. (750 KB total) php core starts at 3 MB per session. A painted elephant. 
Script BASIC web server - echo (scales like nothing else out there)
It supports MySQL, (unix)ODBC, SQLite, Curl, ... as extension modules that seamlessly extend the language.
I'll post a few more examples if there is interest.
48 11/01/2015 07:01:33 pm
Re: Script BASIC (17 replies, posted in Announcements)
Found your project interesting - recalled fond '80s memories of the ZX81 BASIC on the TV and tape recorder!
It's an embeddable scripting language written in ANSI C and runs on everything. It's thread safe with unlimited expansion through it C extension API. You should have a second look. ;-)
49 11/01/2015 01:07:43 am
Topic: FA Themes (1 replies, posted in FA Modifications)
I would like to try and create a new theme for Front Accounting. Is there any documentation on the theme framework?
Thx!
50 11/01/2015 12:06:37 am
Topic: Script BASIC (17 replies, posted in Announcements)
Hi FA Forum Members,
I manage the Script BASIC open source project and support the language on the commercial front. I think FA is an outstanding foundation ERP that can go in just about any direction. I'm looking forward to work with it.
I just wanted to say hi and will be following the forum closely.
John Spikowski
support@scriptbasic.org
www.scriptbasic.org