hexagon logo
Register Sign in
  • Replies 17 replies
  • Subscribers 9 subscribers
  • Views 392 views
  • Users 0 members are here
Options
Related

Automate Generating Reports

acgarcia
Good Morning:

I've searched the forum but didn't find what I was looking for. Is there a way to automate generating reports in datapage? In know you can save queries with a specific date range. I can just update the date range for what i'm looking for. My problem is that the tolerances for the features are different. 0.001-0.015". From my experience, with using a saved query, it doesn't keep individual tolerances. So all features are 0.001 or 0.005 or 0.010 and so on.
  • I've never actually used it but my understanding is that the report delivery tool should should do what you want. I would look in the datapage help file to get more info on it.
  • The macro function may help, I'd look into that specifically. I haven't done anything with tolerances so I'm not sure but I've used it to set up charting at the end of a program run using queries to filter what we need.

    .02,

    TK
  • I realize this is almost a year old thread, I was wondering if you had any luck with the report delivery tool? I tried using it and after I set it up I cant get the settings to open so I can adjust a few things.
  • Everything is stored in the database DP querys it's data from, even the stuff you delete. Connect to the database you created in DP via Visual Studio you can download for free and read up on TSQL... you'll be querying anything and everything straight into your spreadsheet without ever touching DP. You still need a DP license, fyi.

    It takes me less than 10min to setup a report WITH RANGES (min/max) instead of single values with a custom function in excel just write it once and copy/paste function viola done, forever! Updating your Job# cell will query data for that job number. This is a small example of what you can do.

    $B$4 = Part#
    $M$4 = Job#
    "D"&$B24&"% = D10% = D10_1 thru D10_4
    "DF" = Dimensions extension for diameter from a True Position dimension command 

    =PERSONAL.XLSB!QuerySQL($B$4,$M$4,"D"&$B24&"%","DF")


    pulls D10.DF (Dimension #10) from 20 pcs
    Excel Spreadsheet:










    10 pg.1, Zone F.7 Diameter 4X Ø.129 +.005/-.001 THRU 0.139 0.119 .1291 - .1297

  • Everything is stored in the database DP querys it's data from, even the stuff you delete. Connect to the database you created in DP via Visual Studio you can download for free and read up on TSQL... you'll be querying anything and everything straight into your spreadsheet without ever touching DP. You still need a DP license, fyi.

    It takes me less than 10min to setup a report WITH RANGES (min/max) instead of single values with a custom function in excel just write it once and copy/paste function viola done, forever! Updating your Job# cell will query data for that job number. This is a small example of what you can do.
    ...


    Dude, I wonder if you can check something. Using Visual Studio to connect to the database, is it possible to adjust things like the MMC/RFS tags, or to modify bonus tolerance in a way that actually updates the values?

    For reference, if you import a TP dimension that has MMC set, the value that DataPage uses to calculate bonus tolerance (for reporting TP tolerance on the report) is the value that it receives on import. It will not update the bonus tolerance calculated on the report (changing the TP tolerance based on the feature MMC) if you change the values though the Data Editor tab. And DataPage techs confirmed that this is how it was programmed to function, and as usual, it will not be changed, because the DataPage people don't give a fk about their customers.


  • Dude, I wonder if you can check something. Using Visual Studio to connect to the database, is it possible to adjust things like the MMC/RFS tags, or to modify bonus tolerance in a way that actually updates the values?

    For reference, if you import a TP dimension that has MMC set, the value that DataPage uses to calculate bonus tolerance (for reporting TP tolerance on the report) is the value that it receives on import. It will not update the bonus tolerance calculated on the report (changing the TP tolerance based on the feature MMC) if you change the values though the Data Editor tab. And DataPage techs confirmed that this is how it was programmed to function, and as usual, it will not be changed, because the DataPage people don't give a fk about their customers.

    Vinni you're free to do whatever you can come up with SQL. I cannot see DP's query strings let alone modify them, so you're stuck with whatever they supply....or until I come across them. DP is a 'front end' that querys data from MSSQL server, you could build your own front end similar to DP and do what you feel like doing.

    I'm not knocking DP in any way, I finally see the good use it supplies. Though how do you build a piece of software that pleases everyone? Very difficult IMO we're a niche I would say so experimenting and tweaking the software is almost a MUST.

    Vinni, if you have DP I recommend installing Visual Studio and tapping in to your existing MSSQL server and take a look at all your data, it's fun.
  • in reply to Kp61dude!
    No worries. I just thought I'd ask before trying to dive into it myself. Slight smile
  • Vinni, on second thought I think I missed your request, my bad, what exactly should I try? Curious. Would this be something that would constantly run in the background or run 'on demand'? Expand a little more on what you would like to achieve so that I can start creating.

    Are you talking about the TP tolerance after bonus has been applied for example:

    callout:
    Ø.500 +.005 / -.001
    |POS|Ø.010(M)|A|B|C|

    actual:
    .502
    .011

    DP will not update POS Ø.010(M) to .013?
  • Vinni, on second thought I think I missed your request, my bad, what exactly should I try? Curious. Would this be something that would constantly run in the background or run 'on demand'? Expand a little more on what you would like to achieve so that I can start creating.

    Are you talking about the TP tolerance after bonus has been applied for example:

    callout:
    Ø.500 +.005 / -.001
    |POS|Ø.010(M)|A|B|C|

    actual:
    .502
    .011

    DP will not update POS Ø.010(M) to .013?

    Yes.

    When DataPage imports an XML, there are some values that are hidden and cannot be changed. One of them is for when you select the option to "Use calculated bonus tolerance" (or something to that effect). But, in the variables there are values like DF.B and TP.B. If you change those values, the calculated bonus tolerance doesn't change. So, the report will still show a TP of, for example, 1.100, for a 1.000 TP plus 0.100 bonus from feature. So, change the DF.B and TP.B to something like 0.200 and the calculated TP on the report is still 1.100.

    The value used is hidden, somewhere, that the DP front end cannot edit.

    So, i was just curious, before downloading, installing and spending any time looking, if I could use your experience. If it's possible, that would be a huge boon. Instead of having to delete transactions, and modify the XML file, and re-import the files, I could just open the Visual Studio, modify it, and go back to DP and be done.


  • Yes.

    When DataPage imports an XML, there are some values that are hidden and cannot be changed. One of them is for when you select the option to "Use calculated bonus tolerance" (or something to that effect). But, in the variables there are values like DF.B and TP.B. If you change those values, the calculated bonus tolerance doesn't change. So, the report will still show a TP of, for example, 1.100, for a 1.000 TP plus 0.100 bonus from feature. So, change the DF.B and TP.B to something like 0.200 and the calculated TP on the report is still 1.100.

    The value used is hidden, somewhere, that the DP front end cannot edit.

    So, i was just curious, before downloading, installing and spending any time looking, if I could use your experience. If it's possible, that would be a huge boon. Instead of having to delete transactions, and modify the XML file, and re-import the files, I could just open the Visual Studio, modify it, and go back to DP and be done.

    Yeah pretty sure you can modify the DF.B and TP.B and DataPage would have no other choice but to read in those values.

    Came across these guys In the DB:
















































































    dbo.Variable
    SID Dimension_SID Variable_Name Variable_Type Distributor_Type Description
    278 145 X 1202 NULL NULL
    279 145 Y 1203 NULL NULL
    280 145 DF 1206 NULL NULL
    281 145 DF.B NULL NULL NULL
    282 145 TP 1209 NULL NULL
    283 145 TP.B NULL NULL NULL
    284 145 B 1209 NULL NULL
    285 145 B.B NULL NULL NULL

    I would say give it a shot, you won't waste your time. You can PM me anytime for help.

    You can write a script to run a .sql file, I'm sure, and fire it before you look at DP.

    How would I go about replicating your scenario? I will modify them and report back what DP shows.
  • in reply to Kp61dude!
    Those values, at least modified via DataPage, do not affect the TP tolerance that is calculated.

    Any (legacy) TP dimension you send from PC-DMIS to DataPage (I use the DataImporter with XML) that has MMC selected. Then in DataPage Tools>Options, select the "Include Bonus Tolerance" option. If you have Tolerances shown on the Data Editor tab, you can see what happens in DataPage.

    Using my earlier example, a hole that gives 0.100 bonus tolerance when imported into DataPage with 1.000 TP, will then show 1.100 tolerance. If you change ANY of those values (DF.B, TP.B, B, or B.B) the TP value will still show 1.100. If you change the TP tolerance to 0.500, it will auto-calculate and show 0.600. It will always maintain that 0.100 MMC value, somewhere.

  • Those values, at least modified via DataPage, do not affect the TP tolerance that is calculated.

    Any (legacy) TP dimension you send from PC-DMIS to DataPage (I use the DataImporter with XML) that has MMC selected. Then in DataPage Tools>Options, select the "Include Bonus Tolerance" option. If you have Tolerances shown on the Data Editor tab, you can see what happens in DataPage.

    Using my earlier example, a hole that gives 0.100 bonus tolerance when imported into DataPage with 1.000 TP, will then show 1.100 tolerance. If you change ANY of those values (DF.B, TP.B, B, or B.B) the TP value will still show 1.100. If you change the TP tolerance to 0.500, it will auto-calculate and show 0.600. It will always maintain that 0.100 MMC value, somewhere.


    From your example, your goal is to edit or get rid of the .100 bonus? I will start playing with it as soon as time permits.
  • in reply to Kp61dude!
    My goal is to be able to edit the .100 bonus.
  • Vinni,

    It works. I changed values in DP and values from database matched. I changed values in db and DP matched.
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement