Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Nico876

    Receiving Assets in AssetCenter via Connect-It

    I have a Request in AssetCenter with one request line of 1000 assets. Now, I have a text file with 1000 assets, as a result of the receipt, which was done already in realty. My goal is now to import the text file with the 1000 assets via Connect-It, and to trigger the receiving funcionality in...
  2. Nico876

    Experiences with Crystal Reports 11?

    I'm wondering if anyone is using Crystal Reports 11 with ServiceCenter or AssetCenter? We do use ServiceCenter 5.1.2 and AssetCenter 4.3.2 and want to use Crystal Reports 11 also. Any experiences?
  3. Nico876

    How to modify a query?

    If I use the sendDocQuery-Function in Get-Resources, I got e.g. a query like this: SELECT lPortfolioItemId FROM amPortfolio WHERE lPortfolioItemId = 123456 This statement works. But, if I try to grab more then 1 lPortfolioItemId's, because they are softwareinstallations related to the asset, I...
  4. Nico876

    Entitiy Relationship Modell of AssetCenter-Database

    Thanks wrueckert, but I knew the dbase.txt already. It's not what I'm searching for. I would like to have a graphical Data Model (ERM). And to create one with the dbase.txt is very exhausting. Bye, Nic
  5. Nico876

    Entitiy Relationship Modell of AssetCenter-Database

    Thank you jjoensuu! But, in the document "PhysicalDataModels.pdf" are only parts of the hole Datamodell. I'm searching for a hole one. I'v just seen it for ServiceCenter. And I asked already PRGN for a AC-Datamodell, but they say that such a Datamodell doesn's exists. I can't really believe...
  6. Nico876

    Entitiy Relationship Modell of AssetCenter-Database

    I'm searching for a Databasemodell (Entity Relationship Modell) of the AssetCenter-Database (out of the box-version). Anyone knows if exists a kind of? Thanks, Nick
  7. Nico876

    SQLstates & ERRORs

    When I try to update a record in the db, I get an ERROR. "SQLstate 12001 - UNABLE TO UPDATE RECORD" What kind of error this is? What can I do now? And what is this SQLstate 12001? Anyone knows a list, where I can find all the SQLstates (with a description)? E.g., I wanna know what this...

Part and Inventory Search

Back
Top