+ Post New Thread
Results 1 to 11 of 11
MIS Systems Thread, FMS supplier import - blank database in Technical; Hi, Just setup a blank database in FMS 6.140 as a third option in database selector. Everything was going well ...
  1. #1

    Join Date
    Oct 2010
    Location
    Dorset
    Posts
    31
    Thank Post
    14
    Thanked 2 Times in 1 Post
    Rep Power
    8

    FMS supplier import - blank database

    Hi,

    Just setup a blank database in FMS 6.140 as a third option in database selector. Everything was going well until I tried to import supplier data from an existing database, apparently I need a licence patch to be applied in order to import supplier details into a blank database ? Has anyone come across this ?

    Many thanks for any help anyone can offer ....

  2. #2

    Join Date
    Sep 2007
    Location
    Somerset
    Posts
    62
    Thank Post
    5
    Thanked 15 Times in 12 Posts
    Rep Power
    17
    Yes, this does require a patch, and I believe this is a chargeable extra from Capita.

  3. Thanks to splattthecat from:

    drdos256 (23rd August 2011)

  4. #3

    Join Date
    Oct 2010
    Location
    Dorset
    Posts
    31
    Thank Post
    14
    Thanked 2 Times in 1 Post
    Rep Power
    8
    Thanks .... anyone done this by an sql script ?

  5. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    Yes, really easy bit of SQL code, but you need to purchase the license. If your supported by your LA, you should contact them. They might have already purchased an LA license, also they'll be able to help set it up. Not an easy thing.

    I also have a tool to allow you to edit the suppliers, one of the big thing it does is drop out the suppliers mark as in active - yes, otherwise you'll import supplers that you've marked as in active.

  6. #5

    Join Date
    Oct 2010
    Location
    Dorset
    Posts
    31
    Thank Post
    14
    Thanked 2 Times in 1 Post
    Rep Power
    8
    Hi Matt40k, I think we are ok now with the supplier import (although if you have an example of the sql code that may be very useful in the future) - you mention a tool to drop out inactive suppliers - this would be very useful - can I ask please where I can get a copy ? many thanks ....

  7. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    Again, you need to purchase the license otherwise you're breaking the law.

    And I'll send over the link to it once we've received you're order

  8. #7

    Join Date
    Oct 2010
    Location
    Dorset
    Posts
    31
    Thank Post
    14
    Thanked 2 Times in 1 Post
    Rep Power
    8
    Thanks Matt, sorry I thought it was something you had written ! Capita have agreed to transfer the suppliers for us next week (sending off the databases) but we would have liked to drop the inactive suppliers beforehand (I will ask them if it's something they can do).

  9. #8

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    Quote Originally Posted by drdos256 View Post
    Thanks Matt, sorry I thought it was something you had written !
    It is something I've written, but I wrote it in work time (unlike TidyBackups) and they're using as part of the service they provide.

    I'd be suprised if Capita couldn't take out the inactive suppliers.

  10. #9

    Join Date
    Oct 2010
    Location
    Dorset
    Posts
    31
    Thank Post
    14
    Thanked 2 Times in 1 Post
    Rep Power
    8
    I can but ask them - thanks for pointing me in the right direction.

  11. #10

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    Quote Originally Posted by matt40k View Post
    It is something I've written, but I wrote it in work time (unlike TidyBackups) and they're using as part of the service they provide.
    ...
    like that'll stand up in court!

  12. #11

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    All work is submitted to SVN, so it's timestamped, don't think they can claim ownership of work I did at 23:47 at night haha

    Plus they like us doing open source\charity work

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS FMS - Borland Database Engine
    By adamchapman in forum MIS Systems
    Replies: 8
    Last Post: 17th November 2010, 12:33 PM
  2. FMS: unsyncd database
    By Oops_my_bad in forum MIS Systems
    Replies: 3
    Last Post: 31st March 2010, 09:45 PM
  3. Restore FMS database
    By Outpost in forum MIS Systems
    Replies: 4
    Last Post: 16th June 2009, 02:21 PM
  4. Attaching FMS Database
    By mloveless in forum MIS Systems
    Replies: 0
    Last Post: 3rd June 2008, 03:39 PM
  5. Can't attach new blank SIMS database
    By Oops_my_bad in forum MIS Systems
    Replies: 3
    Last Post: 4th July 2007, 01:49 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •