Simple Invoices - Forum

thanks john looks great!!

http://imgur.com/dkp7I.png

only issue i had was with the IE debugger thing wouldn't go away

cheers

justin

fixed the above problem

refer below image

[IMG]http://imgur.com/Iq15j.png[/IMG]

cheers

justin

cool! i think what ill do is make a second button/method to start SI in the default browser instead of the my GUI so we can avoid some of these issues

and PDF export should work, its a little slow for some reason by i do eventually get a save file dialog

E-Mail should NOT work, i havnt looked into this, but i suspect i need to add in a smtp relay agent, however i worry that sending mail this way has a high chance of being flagged as spam due to it being of private origin.

thanks john

a second button to open in defautl browser would be great

cheers

justin

also any chance to make this cross platform?

not exactly, thats a little bit beyond me, but ill try to think of a way, however i could make it so if you open it on a windows system and then select an option to make it available on your network you could access it from other systems.

thanks john

cheers

justin

Updated! see first post/my site

Anyone who knows php/mysql well and would like to help with this project, im trying to come up with a way that data bases can be synced OR another idea:

You start the Offline app on a internet connected computer and would do the following

run a php script on the remote server that downloads the online database
run a php script on the local offline server that restores the the online database
run a php script on the remote server that adds a warning to the SI header telling the user that the database is currently being used offline

after user has done his offline tasks and returns to an internet connection:

run a php script on the remote server that creates a backup of the online database
run a php script on the local offline server that creates a backup of the database
my app uploads the updated database (unless this can be done easily with php)
run a php script on the remote server that restores the uploaded database

if a better way exists im all ears, im just not good enough with sql to create the needed queries in a secure and safe way.

thanks john

getting this symantec error

[IMG]http://imgur.com/qeMnb.png[/IMG]

can you point out the exact executable (need to scroll over)

ive updated the program, i re compiled using the latest version of AutoIT and without UPX compression, UPX can often be the cause to false positives, but autoit itself sometimes has issues because its hard for antivirus to differ between good and bad script due to the way autoit works, it might also be because the apache and mysql binaries are compressed, but i didnt use UPX i used PECompact2 which generally doesn't throw flags because its a pay for program, let me know how it goes

1.2.1.0

http://teammc.cc/silh

updated, all of the executables are new, ive updated the apache/mysql/php/autoit executables... fresh start, also ive added a few features, most notably that by changing the address in the settings.ini to blank, you can access simple invoices on other networked pcs (assuming proper firewall configuration)

thanks john

will test out 1.3.0.0 now

cheers

justin

Thank you.

Can't uncompress the file.

Jos

jeez im not having the best luck here lol, ok try again, re compressed it (this time using deflate and not lzma), now anything should be able to open it

**EDIT** in case anyone cares, i found out it was an issue with my webhost settings, all content was being compressed during delivery, and not just html/text

Thank you John.

Now it's fine. See you soon.

Jos

Updated!

1.4.0.0 - 2010.2 - Update 1

http://teammc.cc/simpleinvoices

Many new improvements & renamed to "Simple Invoices For Windows" in order to integrate this into the community.

If i can please get a few people to give it a good testing so that we can be sure this is stable and Justin can promote it on the website.

great work!!

any change you can also include a mini smtp server into it ?

cheers

justin

also email me your google account name and i'll add you to our google code dev site

that way - you can upload Simple Invoice for Windows to google code all the downloads are done on google servers - not your own

cheers

justin

Justin - Just sent you my google user name. as far as an smtp server goes, i certainly can, i havnt yet because of these reasons: (please correct me if im wrong)

--Some ISPs block outgoing smtp
--An email originating from an such an address has an increased chance of being flagged as spam
--An email with a From address using a domain thats not associated with the originating server has an increased chance of being flagged as spam

if i were to include it i think that due to 'best practices' we should have it disabled from the actual apache config, and consider it an advanced mail method.

the best way ive found so far is to use smtp server settings from gmail or your web host (whatever the senders domain is). for example i use a mail account i created on my web host exclusively for smtp ([email protected]). so in SI the from address is [email protected] and passes most checks because it has the same domain as [email protected].. the only issue i ran into i belive is with my ISP restricting SMTP, i had to use SSL to be able to get it to work.

thanks john

your probably right - smtp server could cause some issues - i'll add a page on our site for the windows version with details on how to edit the smtp server details etc.. to gmail

cheers

justin

Hello Justin,

I tried to update the settings file with my Google Apps SMTP information with no luck. I am running this Windows version and this would be perfect for a client of mine if I could get the email to work. Has anyone gotten this to work?

Fabrizio

sorry for the delay, i didnt notice this message some how, ill respond with a sample of how to configure it with gmail after i do some testing to be sure.

thanks john

E-Mail Configuration For Simple Invoices For Windows: (First Draft)

1. Using your e-Mail providers website, or information from your administrator find your
"e-Mail Client Configuration Information", or specificly "SMTP Settings".

Example SMTP Settings From Google's Gmail:
Outgoing Mail (SMTP) Server - requires TLS or SSL: smtp.gmail.com (use authentication)
Use Authentication: Yes
Port for TLS/STARTTLS: 587
Port for SSL: 465

2. In the simple invoices configuration file (located at "si\config\config.ini") find the options starting with "email."
3. Using the information in the example above you would set you config.ini to look like this:

email.host = smtp.gmail.com
email.smtp_auth = true
email.username = [email protected]
email.password = mypassword
email.smtpport = 465
email.secure = SSL
email.ack = false

Note: Be sure that SMTP/POP access is enabled in your email settings, and that your using the correct port,
the SSL port is recomended not just for security but because some ISPs and/or firewalls may interfer otherwise.

thanks john!!

Thanks for the tip, unfortunately had no luck though. Only ‘difference’ is I’m using Google Apps Gmail.

Using:

email.host = smtp.gmail.com
email.smtp_auth = true
email.username = [email protected]
email.password = password
email.smtpport = 465
email.secure = ssl
email.ack = true

I get “Zend Mail Protocol Exception: Connection timed out”.

Using:

email.host = smtp.gmail.com
email.smtp_auth = true
email.username = [email protected]
email.password = password
email.smtpport = 587
email.secure = tls
email.ack = false

I also get “Zend Mail Protocol Exception: Connection timed out”.

Tried various other combos and also tried using my @gmail.com address with no luck. POP is fully enabled on both account also.

Argh, really like using Google Apps for email at my domain but configuring gmail for this is annoying. Understandably the failure/exception info isn't specific enough to get an idea where it's falling over.

~mccrodp

This package is great. but is there anyway that we could change the help button in the gui?

lodperera - what did you have in mind, a user customizable entry?

mccrodp - are you still having this issue because im interested in a solution and whats causing this for you, have you tried using the gmail account settings on a standard web based install of SI?

yes... and how do we dump the database and start it as a fresh copy?

Right now you will need to open mysql admin. You can use the tray icon or navigate to /mysqladmin while using simple invoices from a browser

Simple Database management is something I want to include in the program so stay tuned for both your ideas

Has anyone been able to make the system work on a network cuz i've read through and tried the blank option for the address but still cant get it to work from other LAN pcs

hey max

does the PC SI is on have a firewall

need to allow access to the apache port from the rest of the network

let us know how you go

cheers

justin

I have a multi computer single user solution that seems to be working ok, I installed dropbox on my computers and put my SI folder in my dropbox. Dropbox keeps my simple invoices folder synced. I haven't tried to use it on two computers at once yet, but i have accessed the same install with three different computers.

I open SI, use it and then make sure to close and shut down SI before I use it on a different computer. Dropbox keeps it synced across computers.

If you sign up for dropbox, and don't mind using my referral link, here it is http://db.tt/QOohbuE

Another bonus is that computers can sync over the internet from behind firewalls.

thanks bertramt for the workaround

cheers

justin

JohnMC - Sorry, I didn't get notified of the replies to the thread. Yes, I'm still getting the "Zend Mail Protocol Exception: Connection timed out" error unfortunately. No I have not tried and online or Windows version with Google Apps Gmail address/smtp server. Does it definitely work with Google Apps Gmail Accounts? Thanks.

What about the configuration for a no SSL or TLS mail server.

I used the following settings for e-mail configuration with Google Apps and they worked fine:

email.host = smtp.gmail.com
email.smtp_auth = true
email.username = [email protected]
email.password = mypassword
email.smtpport = 465
email.secure = SSL
email.ack = false

I think the mail problem I had before was the email host, but it works now.

i used this code
email.host = smtp.gmail.com
email.smtp_auth = true
email.username = [email protected]
email.password = mypassword
email.smtpport = 465
email.secure = SSL
email.ack = false

but an error occurred 'Zend Mail Protocol Exception: Connection timed out '
please give me some subjugation.

what version of SI4WIN are you using? if its not the latest RC try it: http://teammc.cc/downloads/simpleinvoices/

This issue might be related to a PHP openssl plugin not beging installed/configured in SI4WIN

Hi Folks

I am having some trouble with getting the logo to show in the .pdf when I export using SI4WIN i have been around in circles trying to follow the fixes used when using SI on a server with no luck when I edit the php.ini file to allow_url the next time I start simple invoices it changes it back. I also tried adding
php_value allow_url_fopen on
php_value allow_url_include 1 to the .htacess file with no luck,

Can anyone help we have been using this software for a year with no problems and it recently stopped loading the 315 odd invoices we have so I downloaded the latest version of SI4WIN and imported the mysql database to bring the data from the old version across and now I am stuck.

Cheers Benn

Hi Benn, sorry for the delay, can you please update me on if you have made any progress.

If you download the latest RC http://teammc.cc/downloads/simpleinvoices/ and dont import your DB or make any changes and just use the sample date do you experience the same issue? (use one of the default/sample logos from the biller configuration)

Thanks for the Reply John

No progress yet will try what you suggested and get back to you.
*EDIT* Ok tried that and it worked, now I need to get all of the invoices allready created into the new version,

Any ideas will try again on my end,

Benn

Ok So I thought I had downloaded the latest version the first time but the link I had followed was the previous version, followed your link again after trying above and Followed the same protocol this time and it is all sorted thank's for your time,
Is importing the table via phpmyadim the best way to upgrade?

As far as i know, its the only way to upgrade.