Mike
Forum Replies Created
-
Do you mean personal settings/views for each user?
We lost that on Firebird to Oracle database migration/upgrade.
Since that, all upgrades have kept the user settings, as far as I know.
-
What about using Screen Scripter code to only make the field required RO and WO ?
-
Good input, John, thank you. The Minix devices were purchased outside of my control. They are in the APU build area to be used for displaying manuals, and reference lookup.
I did a workstation install of Quantum, here is what I found.
While you can select the install location for the Quantum modules, the other components are hard coded to install on the C drive. (Oracle, BDE, etc).
The space needed was about 2-3 gig total both drives, so that was not an issue.
Running Quantum, the performance is reasonable and not much different from other workstations around the company.
I used Winaero WEI Tool to get a benchmark performance on the Minix units and they scored in the same range as our other, mostly 3+ year older, workstations. This tool gives you the old Windows Experience Index measurements.
-
It should not matter, if you can select the install directory, then the program should support it. Although that does depend on who programmed it and them keeping that in mind – especially in future releases.
I would also steer clear of the cheaper mini PC’s if possible.
Overall performance has always disappointed – unless they are being used for RDP – even then they still frustrating!
The Dell Optiplex Micro series is what we use everywhere in the company as a standard user PC. Of course they do cost a bit more but performance is outstanding in comparison. The small size makes them very versatile.
14cm sq vs 20cm sq – there is not a lot in it and there is just no comparison in performance. In 3 years the Minix will be in a bin and the Dell will still be in use… 😉
-
Thank you for the great feedback ! Does Quantum install need to be done to the C drive (where Windows is located) or can it be on a secondary D drive ?
-
Our Citrix VMs use to run on 30GB as an entire machine – with office without any probems. Although higher now due to windows updates.
Quantum client can’t be much more than than 2GB with Oracle included.
Overall, the ongoing issue will be Windows OS and updates eating up disk space.
-
Hi Pat.. perfect timing ! I am currently working on such a function with our system. We do not have Event Manager, which would do this for us. I have worked out and test a proof of concept for this and will be testing and implementing very soon.
-
Updated SQL- this shows updates to templates and templates being applied to the users.
select sysur.user_name, adt.descr, adt.stamptime
from audit_trail adt, sys_users sysur
where adt.stamptime > = sysdate -30
and ((adt.source_table = ‘STP’) or (source_table = ‘SYSUR’ and source_field=’STP_AUTO_KEY’) )
and adt.sysur_auto_key = sysur.sysur_auto_key
order by stamptime desc
-
We use Citrix which just works 100% all the time.
I did have a play with remote desktop services a few months ago.
had the same issues but ran out of time.
Main thing I found with our Citrix, from memory, was that the BC module was quite fussy about COM ports and even when redirected it must be a particular port, was is COM2 – that is a guess.
Also, would just urge caution to anyone opening up site to site VPN link to general servers from end points – that is generally a security risk that you should not take unless it is managed very well. It might be in your case but it is worth mentioning in case anyone else reads that and just does that without considering the consequences.
Your network/firewall/VPN is only ever as secure as your worst end point…
-
Have not seen this exact issue but …
Quantum does not as a general rule have record locking, there are some exceptions.
A simple example would be Ship Orders, which we see all the time on various fields, if two staff have the same elements open, the last one to close writes over – even if that is the original data. This is the workstation caching you mentioned.
Luckily we can see it in the audit trail – because those actions are part of the audit trail on those screens.
However, if where those changes are being made in the code it is not part of an audit trail you won’t see why it changed, which is why we keep adding items on audit trail to CP.
Also any large updates to tables, we never do in normal working hours as it risks either locking up on record updates or doing what you just mentioned – messing up the data.
May not be directly related to what you see though.
-
Stephen
Changes to the templates and user security are logged in audit.trail table. A simple query to show all template changes in the last 30 days is:
select sysur.user_name, adt.descr, adt.stamptime
from audit_trail adt, sys_users sysur
where adt.source_table = ‘STP’
and adt.stamptime > = sysdate -30
and adt.sysur_auto_key = sysur.sysur_auto_key
-
In the RPT_AP_PKG.FUNCTION GET_1099, i found this code. This function is called by the some other packages (SPR_1099) to build the data stream to print. The code below is towards the bottom, after setting up all the fields to be printed. There is some special sorting going on, and accounting for the fact there are 2 vendors per page (in the section below this one). The fields are all set up and then rows are added to cursor 3 times, hence the 3 copies.
Changing this code would not be trivial, plus altering packages is against the SMA agreement with CC. I would create your own copy of these packages and functions, modify and add them to your own version of the 1099 CR.
–TS – this will suspend each vendor 3 times and set the sort order to be
–venor1-venor2-venor1-venor2-venor1-venor2-venor3-venor4-venor3-venor4-venor3-venor4 etc.
IF I = 0 THEN I := I + 1; ELSE I := 0; V_ITEM.SORT_BY := V_ITEM.SORT_BY-4; END IF;
V_ITEM.SORT_BY := V_ITEM.SORT_BY + 1;
ADD_ITEM;
V_ITEM.SORT_BY := V_ITEM.SORT_BY + 2;
ADD_ITEM;
V_ITEM.SORT_BY := V_ITEM.SORT_BY + 2;
ADD_ITEM;
-
Jesse- i wanted to make a report showing the stock line history for that stock line series. That is, showing a stock line from when it was purchased, sent out on repair, added to a work order, etc..
-
I could not see how the 3 copies where being printed in the Crystal Report- where is the command or parameter that does this ?
-
We have a customer and an internal company web/app.
Focus has been on Customer app – they can browse inventory, create RFQs, place orders, request invoices and statements, browse their history, check their quality stats etc.
Then in the warehouse, receive, photos, relocate, process orders, dispatch.
Ultimately to replace the PCs and Barcodes guns used wherever possible.
To use a mobile app wherever possible as an alternative anywhere in Quantum.
-
What kind of mobile applications are companies developing and what Quantum data / functionality are you providing in the app? I am looking for ideas for our company.
-
Yes both mobile and web, a very open question though…
Provided the developer understands Oracle well, Quantum database design/coding, has access to a test database environment anything can be tried.
We use Xamarin for the mobile environment, which works very well.
Its a fairly big project though, I wouldn’t recommend any company going into production with their own app unless it is properly supported internally.
You also need to be careful with licensing, both with Oracle and with Quantum.
We also purchased the Quantum API license, although that hasn’t been quite as useful as we had hoped – for the money we paid and still pay for it.
-
This seems like a design flaw, i can’t believe they allow this to happen. It seems like not too difficult of a software change, since they do this correctly in all other modules.
Support said simply, working as designed, submit a feature request, which I did. They also said that this likely would be a very low priority and probably will never be changed.
-
Craig- the Receiver Reconciliation / Deferred Receiver is part of the Accounting Module, which is an optional module. There is information about it in the help window, but not on the CC website. Hope that helps!
-
Hi Abigail– not sure if you have found a solution to this or not, but I found this article that offered suggestions and links.. One person also indicated that the 12g driver worked for them..
-
We have had very good luck with the Brother printers like this one on Amazon. Our shipping dept uses this and it doe the duplex scanning and copying. We have several other Brother printers and scanners in use around the facility and have had no problems at all. https://www.amazon.com/Brother-MFCL2750DW-Monochrome-Wireless-Replenishment/dp/B0763X6TCW/
-
Anthony- thank you.. I restarted my Quantum and it stopped giving the modal error.
-
Leo- we have several exchange 365 accounts, hosted by Godaddy. They all use Outlook as their email client. Quantum emails are sent out via Outlook and there is really no difference or set up changes that we had to make for these users. Not sure if this helps you or not..
-
Yes they do assuming that you set up those accounts as replaceable segments. There is a section in the help file about setting up the segments and how they work.
-
Terri- we do this using replaceable segments in the account setup along with different PO number logs. Basically the number log is chosen by the user when creating the PO and each number log sets the different segment value. For example CPO number log (current PO) would set the segment to 1, FPO (future PO) would set that segment to 2. So the inventory account is set up as 1200-? where the ? is the replaceable segment. This works for inventory, WIP, Sales, etc for the various modules (PO, WO, SO, etc). We actually use 2 levels of segmentation and it works really well.
-
This looks like a bug in the software. It happens on our 10.9.38 version as well. Have you reported it to Component Control ?
-
What would you want it changed to ? Is it a fixed name or does it require user input ?
-
Create the field on the form for the term code. Create an OnGetText event handler and use this code. It will pull the term_code for the company in the work order header
var
qc : TOracleDataset;
begin
qc := TOracleDataset.Create(nil);
qc.SetSession;
qc.Sql.text :=’select term_code from companies cmp, term_codes tmc where cmp.tmc_auto_key = tmc.tmc_auto_key and cmp.cmp_auto_key = ‘+ WO_OPERATION[‘CMP_AUTO_KEY’];
qc.Open;
Text := qc.FieldByName[‘term_code’].AsString;
qc.Free;
end;
-
John- Does the form print when you select the STD form from the print settings ?
how did you create the revised form ? Did you open the STD version of the form and then do a “Save As” ? I have seen this error when I didn’t copy the STD form to a our own revised form name (we change the STD for ATS, our company abbreviation). I believe this error means either that the data pipeline in the report doesn’t match what is being sent to it, or that you have crossed up some entries in the forms designer report tables. I would suggest that you start over, open the STD form, do a Save As, then modify the Saved as form again with your changes.
-
Tammy- what is the error or issue when you run the report ? what report parameters are you using ? You can post screen shots here (don’t include any sensitive data)
-
Tammy- which version of Quantum did you upgrade to ? Does Component Control have an idea if this is a data or software issue?
-
William- does this give you the data you are looking for ?
Select POH.PO_NUMBER,
sum((pod.qty_ordered – pod.qty_rec) * pod.Unit_cost) cost_rem
From PARTS_MASTER PNM
Join PO_DETAIL POD ON POD.PNM_Auto_key = PNM.PNM_Auto_key
Join PO_HEADER POH ON POH.POH_Auto_key = POD.POH_Auto_key
Where POH.OPEN_FLAG=’T’
and POD.QTY_ORDERED>POD.QTY_REC
group By po_number
order by po_number
-
Jeff- unfortunately, you can’t modify or override the sort order for a report, as it is determined by the package that creates the datastream. One option is to recreate the report in Crystal Reports, where you can specify your own sort order for the data.
-
Brandon- this code will work if the repair detail item is the Main Component or a BOM item in the work order.
var
qc : TOracleDataset;
begin
qc := TOracleDataset.Create(nil);
qc.SetSession;
if RO_DETAIL[‘WOO_AUTO_KEY’] = 0 then
qc.Sql.text :=’select SI_NUMBER from WO_OPERATION where woo_auto_key = (select woo_auto_key from WO_BOM where ‘ + RO_DETAIL[‘WOB_AUTO_KEY’] + ‘ = WOB_AUTO_KEY)’
else
qc.Sql.text :=’select SI_NUMBER from WO_OPERATION where woo_auto_key = ‘ + RO_DETAIL[‘WOO_AUTO_KEY’];
qc.Open;
Text := qc.FieldByName[‘SI_NUMBER’].AsString;
qc.Free;
end;
-
Faye- I modified the PR Document to print the PR Detail Notes just below the detail line as a DBMEMO field, pointing to the PR Detail feed, Note field.. We are on version 10.9.38.
-
You could try this as a test…
On the report you could create a formula field as your HTTP link:
‘http://’ + {IMAGE_SERVER.SERVER_IP} + ‘:85/Select?Key=’ + cstr({IMAGE_LIST.IMAGE_KEY},0,””)
I have added Server Port Manually as all of ours are the same, but you could use the SERVER_PORT if needed – this is just easier to read.
An example report:
SELECT “IMAGE_LIST”.”DATE_CREATED”, “IMAGE_LIST”.”FILE_NAME”, “IMAGE_LIST”.”SOURCE_TABLE”, “IMAGE_SERVER”.”SERVER_IP”, “IMAGE_LIST”.”FILE_EXT”, “IMAGE_LIST”.”IMAGE_KEY”, “IMAGE_LIST”.”SOURCE_PK”, “IMAGE_SERVER”.”SERVER_PORT”, “IMAGE_SERVER”.”SERVER_TYPE”
FROM “QCTL”.”IMAGE_LIST” “IMAGE_LIST” INNER JOIN “QCTL”.”IMAGE_SERVER” “IMAGE_SERVER” ON “IMAGE_LIST”.”IMS_AUTO_KEY”=”IMAGE_SERVER”.”IMS_AUTO_KEY”
WHERE (“IMAGE_LIST”.”DATE_CREATED”>=TO_DATE (’01-10-2018 00:00:00′, ‘DD-MM-YYYY HH24:MI:SS’) AND “IMAGE_LIST”.”DATE_CREATED”
ORDER BY “IMAGE_LIST”.”DATE_CREATED”Filter the results on SOURCE_TABLE as needed.
The added detail line formula field on the report, format as Hyperlink using the same formula field data.
There might be a method to bring back the filename with the extension – on the URL link to work with the browser. But I don’t know what that is …at the moment… so if anyone else knows that would be helpful 🙂
Pics and PDFs are fine – but .msg or other file formats, the browser can’t determine the how to open the file.
-
A programmer can automate the import of images into document and imaging in Quantum – fairly easy to do – into any part of Quantum.
Please note that is not the same as using an external document & imaging product to be your storage instead of Quantum Document and Imaging.
So it depends what you are trying to achieve.
If you are trying to ‘replace’ the Quantum document and imaging servers the answer is no. Unless you have $50k to pay for some CP.
Although I would steer away from that idea because it could in theory break at any time if the external product changes.
Everything above is custom though, so be aware of the potential consequences/costs of supporting that ‘ongoing’. So maybe easy to implement some things but also easy to get in to trouble at some point too…
-
Jake- thank you! I didn’t think of setting the default program for qid to PDF reader. That helps me a LOT
-
Jake- How do you create the links to the image files so that they can be viewed / opened ? I have not been able to figure out how to do that as the files have a .qid file extension…
-
We don’t let our inventory people do inventory adjustments, so I am looking at a way to save the mfg date for a non-stock.
Am considering using the AP Ext Date that is on the PO detail line. Then make a crystal report that shows non-stock items with exp date flag set and PO detail lines with AP ext Date. When the item is used up, then they can open the PO and use the Misc, Ext Ap to remove the date, indicating that it is gone.
Any thoughts on this ?
-
I found a work-around for this. I use a “hot key” macro program called AutoHotKey all the time and created a macro that will edit the highlighted text field to lower case and remove the underline attribute as well. If anyone is interested in this, let me know.
I also use this hot key program to type out “_auto_key” for me when doing SQL (i just type the PNM and activate the hot key to get PNM_AUTO_KEY. I can never type _auto_key accurately, so this helps a lot. I also have them set up to type common topics i search for in google, like Crystal Reports, Oracle SQL, excel vba, etc..
-
I see this all the time. It seems to increase from 1 to 2 or 3 whenever Crystal Reports are run, but there may be other circumstances. Even if a user is “logged in 2 times”, they are still only using 1 license, per the “Connection Dashboard” (User, System System, System Options, Connection Dashboard, or the ocDBConnDash.exe program, which uses a connection).
-
Hi Tim- thank you so much for your help on this. Combining the command SQL statements makes sense. I have used two commands SQL for other reports and never had a problem, so again, thanks for your help ! I am tweaking this a little to show the date each kit was built in the parameter, allow multiple kits to be selected and also no kits to be selected.
Mike
-
Hello Tim– Here is the report. I prints a pick list for kits being built in a Stock Issue. We build multiple kits in a single stock issue but often cannot build the entire quantity due to part shortages. So the pick list needs to be able to only select the kits currently being picked / built, not the ones previously built.
The woo_auto_key is provided by the “print custom crystal” on the stock issue.
Thank you for any help with this !
-
Definitely a 10.10 build unless there is a specific reason not to.
We are on 10.10.5 which needed a bug fix. Which I assume is in 10.10.6.
-
The fields that can be hidden or displayed are in the FIELDS table and the fields are connected to the users in the USER_FIELDS table. Is this what you are looking for?
-
Tino- are you looking for the field name for the “released” checkbox? that is in the WO_OPERATION table, field name RELEASED
-
Jeff- it sounds like a network issue maybe. Look at how they are connected to your network and that the connection is stable. Something may be timing out or going to sleep or just interrupting the connection possibly. Are the time clock machines on the same network as Quantum server, or RDP or other remote connection ?
-
In PL/SQL, the statement to fetch the next auto_key for CQH_AUTO_KEY into a variable (NEW_AK):
SELECT G_CQH_AUTO_KEY.NEXTVAL INTO NEW_AK FROM DUAL ;
Then use the value in NEW_AK for CQH_AUTO_KEY on the insert.
Hope this helps…
-
Tino
Unfortunately, you cannot add tables to Forms Designer reports. They data input streams are fixed and cannot be changed. You have 2 options however.
1- you can convert your report to a Crystal Report, where you have complete control over the data sources.
2- you can pull data from other tables using code to set the value for a field in the report, based on a field in the existing data stream. For example this code will pull the consignment_code field based on the stock_reservation CNC_AUTO_KEY data field.
vAR
q : TOracleDataset;
begin
Text:=”;
q := TOracleDataset.Create(nil);
q.SetSession;
q.Sql.text :=’Select CONSIGNMENT_CODE from CONSIGNMENT_CODES where CNC_AUTO_KEY = ‘ + STOCK_RESERVATIONS’CNC_AUTO_KEY’];
q.Open;
Text := q.FieldByName[‘CONSIGNMENT_CODE’].AsString;
q.Free;
end;