Sage 100

Sage 100 vs 2014 PU 4 Is there a way to import task permission detail? A long story short, we need to get around some data definition file corruption. The easiest way to do this is to is to re-install Sage 100, create a company and then copy our company shell back in. The only issue is that we have a 308 page Role Report with Task Permissions Detail that we would REALLY like to avoid re-entering. There's no option for this in VI. I am hoping someone has a really cool idea on how we can import this rather than keying it in. Otherwise, you can call me ""Data Entry R Us!"" Thanks all.

Can you put the information (import) in Access, then import into the tables via writable ODBC providex driver?

Michelle, that might be an option. Ever tried it before? Don't want to mess the security up cleaning up the data definition files. Also, who / where to go to get writable ODBC drivers for Providex?

You can download the writable ODBC driver from the Providex website. (I just google when I need it.) Do you know the file(s) that hold the Role information in Sage 100? (I'm looking, but never had to identify before, so not so familiar.)

Dumb question - drag and drop of those role files don't work? Ie - drag out of one install into another?

I found the tables - there are 4! It can be read in Crystal, so (in theory) it should be doable.

Are you saying @ShawnSlavin that the 308 pages of tasks are company code specific? Wonder if you can copy and thenjust change the company code to ""all companies"" more easily through a script or boi

Task security is tied to a roll, not to a company. There is an entry for every task and option per roll. 20 rolls. Extrapolates to a big number.

Hey Michell, what are the table names? I'm going to give Waynes drag and drop approach a try. Just need to make sure I get all the appropriate files so the id's are the same. Wayne, will I end with some kind of messed up counters for roll id's? Thinking there might be some kind of ""Next ID"" field in some system control table I'm not thinking of.

Hi Shawn! The files are SY_Role, SY_RoleSecurity, SY_Task, and SY_TaskType. Best of luck! Let me know if I can help more :)

There is also Sy_Context (the one that has the Next ID fields) and Sy_ODBCSecurity. But be careful with this whole thing.

@AlnoorCassim in the end, I reentered the security roles rather than copy files. I didn't want to take a chance.