Option 1. Map all data to custom fields in object - may have to create multiple fields and mapping and dump to excel file using tools like data loader
Option 2. Custom code
Option 3. Create manual reports and export
W will be happy to assist you if you need any such services.
Hi Kedar we meet again!
i am happy to create any custom fields and map them across but before i do i really want to make sure that when this service request is received i can automatically run a export (or report to export) of the fields out in a csv format to a network location.
please could you give me some pointers on that so i can try them in my sandbox
You can, as Kedar, mentioned create a report and schedule it to be send as XLS or as CSV (under Salesforce classic).
Or run this export via Apex code, and send it to an API or email.
Will this help?
great thanks i will try to build the report today and come back to you, just a question is this type of reporting not available in lightning not to worry more than happy to work in classic
The ‘scheduled future run’ option is not available in lightning. In lightning it’s just ‘subscribe’.
The report is visible in both, it’s just about the schedule so it’s send by email to you.
Going the apex route you could automatically push or send out the new info directly as a one off, and as update in the logic automatically close the task and/or Service Request without any manual effort.
ok i will look into, maybe a steep learning curve on APEX but im not doing much else at the moment!
wonder if Pentaho Kettle can be used for this? it could look for this type of ticket every 5 min and if one comes in export the data....
we currently use Pentaho to import users from AD, I wasn't aware we could export as well using it. I will have to investigate unless someone has some pointers
so i have managed to (i think) get Pentaho (7.0) working for updates (trail and error updated a users AD description!) but i am stuck on creating a user.
this is what i have a text file with:
"CN=Spoon Soup,OU=Other,OU=Users,OU=Business,DC=xxxx,DC=COM","Again Again","Spoon@xxxx.COM","Spoon01","Spoon","Soup","Spoon Soup"
to LDAP output
i think i must be missing certain fields, the user that is logging in is a Domain admin.
i dont get any errors
if anyone has done anything like this before any pointers would be very much appreciated as there seem to be very limited articles on the web
OK so i have made little or no progress but i think i know where it is going wrong.
I am now using a secure connection (using SSL) i am now binding to the OU rather than the new dn of the user (as it has not been created yet!).
I think it is now not working due to the password, im not sure what format it needs to be in Base64 or MD5 hash or which attribute to use unicodePwd or userPassword.
the Pentaho forums are how should i put it..... not up to the BMC standard! so no help there, so please if anyone has successfully created a AD user using Pentaho LDAP output (or other method) could you message me
would like to use Pentaho if i could have you used it to create an AD user from remedy?
i have found lots of resource the other was e.g. AD to salesforce which we currently do but for a full automated process it would be good to also create the AD user.
I would just like to know if it is possible, i seem very close as i can amend users details just the last step or creating them.
or if you know any other forum members that might have more knowledge in pentaho if you could point me in the right direction
thanking you in Advance
As far as I know – Pentaho cant be used to create AD record directly. Lot of logic is involved in middle layer. We have done projects like this from Onboardings to AD account creation assigning users to groups. Sending emails to end users.
-Execute power shell using Pentaho (Not validated but see some post around this)
- Use https://actionhub.io/ for integration with AD
-Use BMC Atrium Orchestrator
- Use Okta or other tools
Please check these options. Others may have more suggestions on Pentaho