Mini Searches with Answers

These are links associated with recent searches I’ve done. They’re not difficult enough to warrant to their own posts but still super useful.

svn – Revision 4862: /xlwt/trunk/xlwt/examples
Useful examples of how to use the Python Excel library, xlwt.

The equivalent of Python’s repr in perl
use Data::Dumper;
$boo = ” test n”;
print Dumper($boo);

Preserving styles using python’s xlrd,xlwt, and xlutils.copy – Stack Overflow
Python Excel (xlrd, xlwt) – How to copy a style from one cell and put it on another:

newCell.xf_idx = previousCell.xf_idx

New JDBC Drivers for FileMaker 11
I was getting these errors trying to connect to FileMaker 11 via JDBC on DBVisualizer. It turns out you need this new JDBC driver.

Product: DbVisualizer Personal 7.1.5
Build: #1590 (2011/02/24 17:23)
Java VM: Java HotSpot(TM) 64-Bit Server VM
Java Version: 1.6.0_26
Java Vendor: Apple Inc.
OS Name: Mac OS X
OS Arch: x86_64
OS Version: 10.6.8

An error occurred while establishing the connection:

Long Message:
[DataDirect][SequeLink JDBC Driver]Internal network error, session aborted due to session protocol data unit format error, connection closed.

Details:
   Type: java.sql.SQLException
   Error Code: 2207
   SQL State: HY000

1) Nested Exception:

Long Message:
Session aborted due to IIOP problems.

Details:
   Type: java.sql.SQLException
   Error Code: 7772
   SQL State: HY000

2) Nested Exception:

Long Message:
IIOP error, invalid protocol identifier.

Details:
   Type: java.sql.SQLException
   Error Code: 7529
   SQL State: HY000

Mean and Standard Deviation in Python
8.3 meanstdv()

Summary
Mean and standard deviation of data

Usage
real, real = meanstdv(list)

“”" Calculate mean and standard deviation of data x[]: mean = {sum_i x_i over n} std = sqrt(sum_i (x_i – mean)^2 over n-1) “”" def meanstdv(x): from math import sqrt n, mean, std = len(x), 0, 0 for a in x: mean = mean + a mean = mean / float(n) for a in x: std = std + (a – mean)**2 std = sqrt(std / float(n-1)) return mean, std

File Requires “Full Access” to login. – FileMaker Forums – FileMaker Pro Help and Support Worldwide Community
How to fix FileMaker error:
“your access privileges do not allow you to perform this action” when logging in with a non-full-access account.

You simply want to add the extended privilege “Access via FileMaker Network (fmapp)” to make this work

Tags: , , , , , , ,

Comments are closed.