[Ma...] Posted February 17, 2021 Share Posted February 17, 2021 So I know I did this before using piweb, Generally I click piweb, click the 3 dots under output media for CNC run, and then name the location for the program individually, and export as an excel file. My question is, is there anyway that I can have piweb use an existing folder, or create one if there is not one. i.e. X:\xxx\xxx\xxx\part number\results\order number.xls That way when I program, I can set the part number and it will automatically input it where needed to put the file. Also how do I "turn on" piweb to output this form as well. It has been a few years since I have had to do this. Link to comment Share on other sites More sharing options...
[Ün...] Posted February 18, 2021 Share Posted February 18, 2021 Hello I've done a lot of research on changing the Excel filename, but I guess it's not possible without PCM. Link to comment Share on other sites More sharing options...
[To...] Posted February 18, 2021 Share Posted February 18, 2021 Please sign in to view this quote. Never say "it's not possible"....lol that's like shining the bat light in the sky, calling for BATMAN... Except you're summoning Laura J, otherwise known as "PIWEB WONDER WOMAN"..... 🤣 🤣 🤣 Link to comment Share on other sites More sharing options...
[La...] Posted February 18, 2021 Share Posted February 18, 2021 Please sign in to view this quote. OMG Tom 🤣 ..... Lol! You caught me lurking. I have to admit, I have no idea which 3 dots you're referring to with "Output media for CNC run". However, to my knowledge there is no way to automatically generate the Excel export filename through PiWeb. It's possible to define the naming convention using variables in the PiWeb action "Save all Pages as PDF" but the option isn't available under the Action screen to define the Excel export filename. Link to comment Share on other sites More sharing options...
[Th...] Posted February 18, 2021 Share Posted February 18, 2021 I'm gonna take a guess at it being this button Mark is referring to. Link to comment Share on other sites More sharing options...
[La...] Posted February 19, 2021 Share Posted February 19, 2021 Please sign in to view this quote. Thanks, that makes sense. To the OP, that is a function of Calypso, not PiWeb. Perhaps you'd have better traction in the Calypso forum. There are some talented people who have written PCM functions to do such tasks, but I am not one of those talented people. Link to comment Share on other sites More sharing options...
[Ma...] Posted February 19, 2021 Author Share Posted February 19, 2021 Thank you everyone for the response. Apparently I dreamt I have done it before because without PCM you can't export to excel via PiWeb/Calypso. I did however find out how to do with as a PDF which is totally not useful. 🤣 Either way, thanks for the heads up! Link to comment Share on other sites More sharing options...
[Jo...] Posted February 19, 2021 Share Posted February 19, 2021 Please sign in to view this quote. Do a search on Batch files, Jason Barry I think posted a way to copy and name files with it . It was selected in Multiple report mode. Link to comment Share on other sites More sharing options...
[La...] Posted February 19, 2021 Share Posted February 19, 2021 Please sign in to view this quote. Do you need the Excel export after every run? You can make a PiWeb report that queries the measurement data you're looking to export to Excel (ie. all of the parts that were ran under Lot #1234, or all of the parts that were ran between last Tuesday and today) and then do a bulk export. Just wondering if that would satisfy the end goal all the same. Link to comment Share on other sites More sharing options...
[Ün...] Posted February 20, 2021 Share Posted February 20, 2021 We measure 2000-3000 pieces per month from a piece. I am asked to make monthly process analysis by sending each measurement in excel. Piweb is unfortunately limited to 1000 measurements. (I haven't convinced the bosses to switch to SBS yet) I use a macro combining Excel files, but excel can pull file names mixed. Therefore, if I can change the file name while saving excel, I will avoid confusion. If I could add the date and time before the incremental track number, I would have solved my problem. I struggled with macros in the characteristic excel file, but I could not change the file name. PCM unfortunately does not exist Link to comment Share on other sites More sharing options...
[Ma...] Posted February 22, 2021 Author Share Posted February 22, 2021 Please sign in to view this quote. Yes! If I could do this, that would definitely help! Link to comment Share on other sites More sharing options...
[Te...] Posted April 29, 2021 Share Posted April 29, 2021 Have you looked into QC Calc to export your data o excel. Pretty easy to do. Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in