Asset Manufacturers and other System tables without GUI - Support, Bugz & Troubleshooting

Welcome Guest

Search | Active Topics | Members | Log In | Register

VersaDev Community Forum » versaSRS » Support, Bugz & Troubleshooting » Asset Manufacturers and other System tables without GUI

Asset Manufacturers and other System tables without GUI

Options

Previous Topic · Next Topic

milde

Posted: Saturday, February 21, 2009 9:22:41 AM

Rank: Newbie
Groups: Member

Joined: 2/17/2009
Posts: 2
Points: 6
Location: Melbourne

Referring to the solution in the thread http://www.versadev.com/forums/default.aspx?g=posts&t=3

I am wondering what the method is for adding more manufacturers and changing of other tables. I need to use the Asset functionality quite extensively, and will require addition of many AssetTypes (already resolved by above thread) and Manufacturers. I have added the manufacturer in tbl_AssetManufacturer but it does not show up in VersaSRS. I then tried to add in tbl_VersaAssetManufacturer. Seeing that all previous records have negative AssetManufacturerID and my new one would have a positive one, I am not sure if this is the correct thing to do.

Can anyone shed some light on the system tables and how they work?

Kind regards,

Eddie

Chean

Posted: Friday, February 27, 2009 10:35:40 AM

Rank: Administration
Groups: Administration , Member

Joined: 5/5/2008
Posts: 5
Points: 15
Location: Adelaide, Australia

Hi Eddie

Please note, Assets information are stored in database table with prefix of "tbl_VersaAsset...".

You can make Asset Manufacturer editable via the user interface "Manage System Tables". To do this you need to add tbl_VersaAssetManufacturer details in table tbl_SystemTables. The negative values are just the default data for versaSRS. Positive or negative values, it will still work fine.

Let me know if you have further questions.

Cheers

Chean

Chean Phu
Senior Software Architect

VersaDev Group
www.versadev.com

134 Gilbert Street
Adelaide, South Australia, 5000
Tel: +61 8 8463 1914
Fax: +61 8 8212 8447
Sales: sales@versadev.com
Support: support@versadev.com

Australia : Singapore : India :
United Kingdom : Belgium :
United States : Venezuela

milde

Posted: Tuesday, March 03, 2009 4:30:03 PM

Rank: Newbie
Groups: Member

Joined: 2/17/2009
Posts: 2
Points: 6
Location: Melbourne

Thanks Chean. That worked a treat.

Users browsing this topic

Guest

VersaDev Community Forum » versaSRS » Support, Bugz & Troubleshooting » Asset Manufacturers and other System tables without GUI

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.