SharePoint tips, #1
June 2nd, 2010
Leroy is a Zend PHP Certified Engineer from Crestview FL. He has been computing for over two decades, drag-racing for 13 years and spent a year with a band as a guitarist
Leroy LeeseWeb Programmer/DeveloperProgrammer
We’ve been doing alot development with SharePoint these days. Mostly our work has centered around Lists. Added a few workflows, a few statuses that manage the views and it is working well. Pushing data into the lists has been a little bit of a struggle, but here is what we learned:
If you want to figure out what field names to run a “query” on, and they aren’t always named the same as the name the field was created with, then you’ll need to dig into the list details. I recommend running a query that looks something like this:
SELECT tp_Title, tp_Description,
CAST(tp_Fields AS xml) AS Fields
FROM DS_SP_WSSContent.dbo.AllLists
WHERE (tp_ID = 'LIST_GUID')
This way you can see the columns that are used and really get a feel for what the column name is called “under-the-hood”. This will be useful to you when you get the results in “rs:data” and have a “z:row” item with an attribute that is prepended with “ows_”.
Another tip is that if you are updating or adding new items to a list, make sure the fields you need to query are part of the view that you pass in. If you query a view that doesn’t have the right fields, you won’t get those fields in the results and they may be vital to the logic.
SEO – Bridging the gaps
April 16th, 2010Leroy is a Zend PHP Certified Engineer from Crestview FL. He has been computing for over two decades, drag-racing for 13 years and spent a year with a band as a guitarist
Leroy LeeseWeb Programmer/DeveloperProgrammer
I haven’t talked about SEO in a while – but it is getting more and more complex. Not so much in the common sense side of things – from that perspective it is all good. But there is alot of different technologies involved in creating a full-scope SEO round of updates.
lats/lons and geocoding? Only the techies.
has little, to nothing, to do with the writers and content makers. If you use WordPress
- you are relying on other people. albeit they are highly qualified and highly skilled, but we
have to recognize that we are not in complete control (unless you hire your own programmer to
cut out the parts you don’t need from that system)
business/website owner might not have. Or will spend a fortune learning.
The list could go on. There are so many technologies to learn about that it can be overwhelming. Even for us proclaimed SEO guys and gals.
iPhone App
April 13th, 2010Leroy is a Zend PHP Certified Engineer from Crestview FL. He has been computing for over two decades, drag-racing for 13 years and spent a year with a band as a guitarist
Leroy LeeseWeb Programmer/DeveloperProgrammer
Well, tonight we are submitting our first iPhone App. Its actually not the first one we have been involved with – we have tested several and even had one developed for one of our companies. But tonight, we are submitting our own creation and boy is it exciting. It might be a little late for it considering how heavily we are involved in programming but that is okay. There are no time constraints and we’ll just keep doing the best we can. I expect about 3 cycles of corrections until we get this right. And that will be okay – just hoping the iterations are slightly quicker than they were a year ago.
SSD
March 26th, 2010Leroy is a Zend PHP Certified Engineer from Crestview FL. He has been computing for over two decades, drag-racing for 13 years and spent a year with a band as a guitarist
Leroy LeeseWeb Programmer/DeveloperProgrammer
I have a couple laptops sitting around but I just took ownership of a new SSD drive and even though it is only 32 Gigs, i think it is really going to serve me well. The other bad thing is it is probably not as fast – but what IS good, I am going to try to make it so that it keeps the whole laptop cool enough to stay running. Yeah, the silly thing keeps cutting off after about 10 minutes. I think it is related to the super huge, high speed, power sucking, hot HD that I put in there. Its been doomed from the start. We’ll see – if it doesn’t solve it, I’ll give up on it – or maybe try pulling out the extra memory. Whatever, its time for an upgrade – but before we invest in that depreciating asset, we’ll give this a shot.
Sharepoint, Ax, X++, Dynamics, Solomon (GP)
February 25th, 2010Leroy is a Zend PHP Certified Engineer from Crestview FL. He has been computing for over two decades, drag-racing for 13 years and spent a year with a band as a guitarist
Leroy LeeseWeb Programmer/DeveloperProgrammer
New services for LeeseIT! We have been taking classes in all these Microsoft products. Not only that, but we have been working on doing integrations with all of them! Including web services and data sharing. Anyone can do interfaces, but getting your inventory data to properly couple with your accounting and lead generating software – now that is the challenge! And what about your support staff who needs to effectively run your business and provide numbers and stats for your management team? We are here to serve you all – because with these tools, we are convinced that we can make a solution work for you! Email us for pricing and more information about how we can help.
Operating System does not support the encryption mode provided
January 22nd, 2010Leroy is a Zend PHP Certified Engineer from Crestview FL. He has been computing for over two decades, drag-racing for 13 years and spent a year with a band as a guitarist
Leroy LeeseWeb Programmer/DeveloperProgrammer
It is an error that can drive you MAD!
Recently, working with a client we had to call Microsoft in order to find out what this error message meant, and what the solution might be. I’m happy to say, it had nothing to do with the Operating System, the Encryption Mode or any kind of support. It turned out to be a SECURITY issue.
Here are the parameters: (we are doing some things a little weird, or at least, very niche so this won’t apply to everyone)
Running SqlCE 3.5 on a Windows 7 machine.
Running IIS 7 to serve pages on “localhost” from a website that resides locally, and a db that resides on the local machine.
Everyone knows that if you are going to access a SQL CE database from within a webpage, you need to call the:
method.
But our problem was that we could open the database from within an application yet, not from within the webpage. We had identical connection strings so that couldn’t be it.
What was the solution? Easy. The application pool (“DefaultAppPool” for us) had an identity property set differently on the Windows 7 box than it did by default on the Vista box. We had to change it from ApplicationPoolIdentity to NetworkService and viola – success.
It was like magic. Hopefully this entry helps you solve this problem if you suddenly find your self with Windows 7 machines out in the field that used to be able to access their Sql Ce databases and suddenly are not able to access it because of handled (or in our case, unhandled) exceptions.
iPhone Dev
December 28th, 2009Leroy is a Zend PHP Certified Engineer from Crestview FL. He has been computing for over two decades, drag-racing for 13 years and spent a year with a band as a guitarist
Leroy LeeseWeb Programmer/DeveloperProgrammer
We are entering the iPhone App development arena. Pretty cool stuff. What is especially fun is watching the iPhone App development class in iTunes University on my iPhone. Unofficially, our team is attending Stanford. Cool! Looking forward to submitting an app by the end of January. We’ll keep you posted on that effort.
Recent updates
September 9th, 2009Leroy is a Zend PHP Certified Engineer from Crestview FL. He has been computing for over two decades, drag-racing for 13 years and spent a year with a band as a guitarist
Leroy LeeseWeb Programmer/DeveloperProgrammer
There have been so many websites that we have been working on lately that it seems we haven’t had any time to write or update our own. Here are some client websites we have had the privilege to help out recently:
- destincharitywineauction.org
- marriagevine.com
- shirtandsimple.com
- condosaletrends.com
- awardconcepts.net
- sendaduck.com
- elarcoiris.net
- yxta.net
- nicevillechamber.org
It has been a great summer – thanks to all who have helped support these efforts.