Looking for some advice. I have a customer who needs to upload data from iMIS to a 3rd party custom database.
I have initially created the extracts for testing purposes in MSAccess. So here are my questions.
1 -- has anyone automated uploading TXT files through FTP and having the file name to include todays date.
2 - Can it be done from MSAccess or does it have to be rewritten in SQL?
I am looking for someone who has found a solution to the public view dues payment process.
Here is the background information:
Dues are billed to a company by using BT_ID on the members record. iMIS backshop works perfectly and the outstanding dues are all on the Company record..
In Public View the Dues billed to the company ( for the members) do not show up. The dues still show up on the members record and there is no way a company can pay their members dues.
Well I have canvassed Tech Support and NiuG and cannot seem to get an answer or else no-one is using SQL Expressions with IQA reports.
Here is what I would like to do with an example:
1 -- Gender field has M or F
2 - Need to have a field Called Gender on my IQA which shows 2 if its an M and 1 if its an F
Surely that is something thats possible?
For sure someone out there has several ideas.
Some of my customers want to email the Statement of Account or other types of iMIS Standard Crystal reports. I am not that familiar with Crystal but I could not find anywhere to EMAIL the report.
Is this a feature thats availalbe in Crystal?
How are others sending out statements / invoices from iMIS ?
I am getting this error message when using the UDT iPART --- does anyone know why?
I am looking for someone who has some knowledge on how to show multi=instance tables on the public view. Apparently it needs iPARTS to work.
So if you are the GURU -- can you please let me know the following:
1. What do we need to do this
2. How can this be setup ?
3. Has anyone been able to get activity tables to work in Public view?
I am trying to determine where in iMIS15 an organization might use the Stored Procedure in Registrant Class of Public View.
I wonder if anyone has any ideas on how I might do the following in Public Events:
1 -- Give a discount for Events pricing when more the 3 people register
2 -- The pricing is determined on whether or not the customers have purchased insurance. We have setup INSURED & NONINSURED registrant classes which works when the registgration is processed in-house. How would this get selected when a member registers in Public Events?
Most of my customers want to change the name PURCHASE order that shows up in the public view shopping cart to BILL ME. Does anyone know where I can find that file and change the label ?
I have looked everywhere & Tech Support could not tell me either..............(go figure).
zz
I am trying to find the page in public view that says purchase order when going to shopping cart. I want to change this to CHEQUE. Can anyone tell me where I can find it/
zz
