SoftPro Developer Forum

I would beg to differ: there is a bug and it's this--the Select user interface is allowing people to add attachments and/or edit existing attachment names without limitation. They are allowed to enter characters that will later preclude the extraction of that attachment's content via the API. In ess...

After some more research I found the problem--some of my staff have entered document names that contain human-formatted dates (E.g. "Revised Commitment 11/03/15 12:45PM") and I gather that the API is seeing the slashes and interpreting them as parts of a path statement, not merely as the n...

Bob, Thanks for the response. While you are exactly right and I will make that change, it actually doesn't address our specific case. The order in question has no folders in its attachments collection and yet my code fails to open 1 out of the 9 existing attachments. So your recommendation will cert...

I've stripped down my code (no real error handling, no application-specific code) and here it is: ConnectToSoftPro(); IOrderInfo search = os.Orders.Where(t => t.Number == "15AT018864").FirstOrDefault(); IOrder currentOrder = os.OpenOrder(search, true); string strAttachmentSourcePath = &quo...

I'm in 4.0 (4.0.30302.1069) and have orders that predate our 2.6 to 4.0 migration. We've implemented no new archives of our own since the 4.0 migration which means we have some attachments as .fss files and some as in-database blobs. Here's my question/issue: I'd like one way to extract the file ass...

At present the only way orders are created is through manual initiation--we don't create orders via the API or any other means. Does that lessen the concern? Our biggest worries are a) introducing instability or corruption into the individual orders and/or server process and b) a race condition that...

(Background for non-SoftPro Support readers) In an effort to make every order essentially a self-contained snapshot SoftPro maintains,among other things, a copy of Custom Order Rules for each order that is independent of any other order. As mentioned in another post (see "Manage Custom Order Ru...

Thanks--good to know. But I'm also looking for a more generic solution. So if I want the GUID for a property could I simply replace pfm.Property for pfm.Order in my query and achieve that?

Select 4.0 I've read elsewhere that all the GUIDs that used to be in the entity tables now reside in the SelectDb.pfm.Entity table. I believe I've got the correct join syntax to get the GUID for any entity in the database but want to be sure. Would this be the correct way to get the GUID for a Selec...

John, Thanks for the response. Perhaps I'm just being dense but I thought in 3.0/4.0 Orders used the int Id# field in place of a GUID? Also, how would I enclose your provided sample code on the actual HTML page? Like this: <a href="javascript:openOrder('sp-select://./ordertracking/order?id=c2b3...