Search found 122 matches
- Fri Dec 18, 2015 3:31 pm
- Forum: Integration Development
- Topic: Extracting an attachment regardless of storage mechanism
- Replies: 8
- Views: 1168
Re: Extracting an attachment regardless of storage mechanism
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...
- Thu Dec 17, 2015 5:14 pm
- Forum: Integration Development
- Topic: Extracting an attachment regardless of storage mechanism
- Replies: 8
- Views: 1168
Re: Extracting an attachment regardless of storage mechanism
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...
- Tue Dec 15, 2015 12:39 pm
- Forum: Integration Development
- Topic: Extracting an attachment regardless of storage mechanism
- Replies: 8
- Views: 1168
Re: Extracting an attachment regardless of storage mechanism
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...
- Fri Dec 11, 2015 9:43 am
- Forum: Integration Development
- Topic: Extracting an attachment regardless of storage mechanism
- Replies: 8
- Views: 1168
Re: Extracting an attachment regardless of storage mechanism
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...
- Tue Dec 08, 2015 3:40 pm
- Forum: Integration Development
- Topic: Extracting an attachment regardless of storage mechanism
- Replies: 8
- Views: 1168
Extracting an attachment regardless of storage mechanism
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...
- Thu Sep 24, 2015 1:34 pm
- Forum: Shell (User Interface)
- Topic: Insert Custom Order Rule on the fly
- Replies: 2
- Views: 722
Re: Insert Custom Order Rule on the fly
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...
- Wed Sep 23, 2015 4:11 pm
- Forum: Shell (User Interface)
- Topic: Insert Custom Order Rule on the fly
- Replies: 2
- Views: 722
Insert Custom Order Rule on the fly
(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...
- Fri Aug 14, 2015 3:32 pm
- Forum: General
- Topic: proper use of SelectDb.pfm.Entity
- Replies: 3
- Views: 875
Re: proper use of SelectDb.pfm.Entity
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?
- Fri Aug 14, 2015 3:20 pm
- Forum: General
- Topic: proper use of SelectDb.pfm.Entity
- Replies: 3
- Views: 875
proper use of SelectDb.pfm.Entity
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...
- Thu Jul 23, 2015 3:04 pm
- Forum: Integration Development
- Topic: What is new syntax for URL on start page to open an order
- Replies: 3
- Views: 559
Re: What is new syntax for URL on start page to open an orde
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...