koolit5665

Hi guys/gals, Hope you might be able to help out here. We're working on Windows version of FM/FMS. When I create a client record I manually create a folder within our documents folder on the network and copy/paste the folder path into the folder field. It normally looks something like this: "\\SVR\Documents\CustomerName" When we create a job on the system an order acknowledgement PDF is emailed out to the customer and a copy of the order ack placed in the customers root directory (as above). This wasn't a problem when we first started with the FM solution but now we have hundreds of customers with dozens of Order Acknowledgements cluttering up the root customer directory. What I'd like to do is have FM auto create a directory, such as "\\SVR\Documents\CustomerName\OrderAcks" when the record is created. This I think I'm fine with for new records. I can work that out with a script step. I can probably work out a looped script to create the directory in all the EXISTING customer's folders but how would I go about moving all the existing OA's into the new folder via FM? All the OA's have the same naming schema such as "OA-12345.pdf" so doing a wildcard select may be a possibility. I was thinking something along the lines of: Move OA*.pdf <OA Folder> Any ideas guys/gals? Rick.

Hi guys thank you for the replies... The infrastructure is basically a Dell Power Edge T110 Server (few years old now). Originally we were running normal hard drives in RAID1 configuration. The whole setup was very, very slow and when one of the hard drives failed I took the opportunity to upgrade to server grade SSD's and re-install the O/S on to a VM (incase anything went wrong with the server O/S - attack/virus/crash/etc it would be easy to restore it very quickly). We have 8 users in the office, gigabit networking and at the moment the FMS and data are all stored within the VM. Downsides to this, as I can tell, are that the VM contains everything to do with FMS including DB's/containers/etc. My thoughts were it would be better to just have a small VM file containing the O/S and services like FMS/Sage/etc and have the 'storage (with db's/documents/etc) stored elsewhere. It is absolutely possible for an attack to disrupt the shared drives/etc but it's, rightly or wrongly, another step down the line for someone else to attack. I just can't imagine server admins having VM's around the size that we now have that's all! Maybe a used SAN setup is the way forward? Rick.

Good evening all, We are currently running FMS15 within a VM on Server 2012 R2 with no issues. At the moment all our databases and documents/etc are stored within the same VM and not on separate drives (meaning that at the moment our VM file is around 650GB). I was thinking about worst case scenario that we have to restore the server after an attack but if that happened - at the moment we'd have to roll back to the previous nights backup (potentially losing 8 hrs x 8 peoples work). If the DB's were on a separate drive/storage/etc we wouldn't necessarily lose the DB data, just the server, (which could then be copied back very quickly from a previous backup). What is the general consensus for storing the DB's on another device (NAS/drive/physical disc) when operating in a VM environment and how would performance be affected? I would have thought that putting the DB's on a NAS drive would be too slow and SAN's are too expensive for us (we only have 8 local users). The performance is great at the moment as the VM is on an SSD drive and I don't really want to lose speed as a result of moving it away remotely. Any ideas would be greatly appreciated - we can't be the only ones with this scenario! Cheers, Rick.

Hi all, After tearing my hair out, what's little there was of it, for the last few days I have now been able to successfully manage to install FM Server 13 on Server 2012 Essentials. The main problem I had was that the program wouldn't install as ports 80 and ports 443 were being used. Here are the steps I used in order to successfully install the program. 1) If it's used then re-bind your Default Website in IIS to a different port than port 80 (port 81 for example) and port 443 to an alternative port - you can do this from Server Manager > IIS > Right Click on the Server List and select IIS > Open the Tree on SVR > Sites > Default Website. Under Edit Site select Bindings and do the re-map there. 2) Stop the Windows Server Office 365 Integration Service (as this uses port 443) - You can do this from Task Manager > Services > Right Click/Open Services 3) Stop the Routing and Remote Access Service - You can do this from Task Manager > Services > Right Click/Open Services 4) Download and install Application Request Routing from http://www.iis.net/downloads/microsoft/application-request-routing 5) Install FM Server 13 & complete the Deployment Assistant 6) Reboot the server and this will restart all the previously stopped services. 7) Job done. If the program still fails to install as ports 80 or 443 are still in use then use this command (from CMD prompt) to find out which programs are using ports 80 & 443. Reference the number on the right hand side against the ProcessIDnumber in TaskMgr and close the relevant services. To find out which processes are using port 80: netstat -a -n -o | findstr 80 To find out which processes are using port 443: netstat -a -n -o | findstr 443 I hope the above helps people through this traumatic task! It can be done! Cheers, Rick.

Perfect! Thank you, thank you! Works a treat now!

Hi Jbante, Thanks for your input... The mileage is showing wrong because my calculation field doubles the actual figure to get the a return (there and back) figure... What I'm struggling with is how to extract the time value (in seconds) from the data contained in the returned data ("value" line). The original example only extracted the numbers out of the 'hours and minutes' line whereas I'm just trying to get one figure... I'm sure it's possible using the custom function mentioned above but I don't know how! For example (using the code returned from Google); this: Filter ( Parse between (directions_googleAPI_inserted; "duration"; " min" ); "0123456789." ) Returns: 337 Which is, in essence, 3 hours 37 minutes with all the text removed. Cheers, Rick.

Hi John, I know I'm resurrecting an old thread here but could you help out here? I've followed your instructions and every things working apart from when the time to travel is over 59 minutes as google returns in the format of "3 hours 37 mins" and the custom function mentioned returns back 337. See screenshot below: Any ideas?! If I could extract the "value:" 12999 figure (which I believe is a seconds count) then this would be great as I can convert it to hours then... Cheers in advance... Rick.