alohaakamai3
IS-IT--Management
Does anyone have any experience for exporting Aloha data for ADP? They are asking us to set up a bridge and they seem kinda clueless.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ADP Export for Aloha
- Thread starter alohaakamai3
- Start date
- Status
You just create a file.
If you want to use winhook to automate it, use something like this:
%IBERDIR%\BIN\RPT.EXE /DATE %1 /RD
Then it needs to be moved (maybe)to the ADP working location, something like this:
COPY %IBERDIR%\PCPERS\EXTPAY*.* C:\ADP\PCPERS
If you want to use winhook to automate it, use something like this:
%IBERDIR%\BIN\RPT.EXE /DATE %1 /RD
Then it needs to be moved (maybe)to the ADP working location, something like this:
COPY %IBERDIR%\PCPERS\EXTPAY*.* C:\ADP\PCPERS
- Thread starter
- #3
alohaakamai3
IS-IT--Management
Thanks rockstar. That's kind of the direction I was headed.
I guess the command line switches you have to add will be a mile long and conform to the order the ask for in their sample template?
I am assuming it will be a lot more involved than what you wrote there in terms of out, correct?
I guess the command line switches you have to add will be a mile long and conform to the order the ask for in their sample template?
I am assuming it will be a lot more involved than what you wrote there in terms of out, correct?
I don't remember, but I think it's standard output.
Last time I did it, we used the winhook line above, and then we just transferred the file elsewhere using FTP.
The file itself I believe is generated from aloha and there aren't very many, if any, parameters.
Last time I did it, we used the winhook line above, and then we just transferred the file elsewhere using FTP.
The file itself I believe is generated from aloha and there aren't very many, if any, parameters.
- Thread starter
- #5
alohaakamai3
IS-IT--Management
Hey Rokstar-
I messed around with this and didn't get very far- can you be a a little more particular about the syntax? Are you saying it should just be a batch file run from the bin directory that runs: %IBERDIR%\BIN\RPT.EXE /DATE %1 /R ??
I'm a little confused as to the implementation, I would appreciated a nudge in the right direction.
I messed around with this and didn't get very far- can you be a a little more particular about the syntax? Are you saying it should just be a batch file run from the bin directory that runs: %IBERDIR%\BIN\RPT.EXE /DATE %1 /R ??
I'm a little confused as to the implementation, I would appreciated a nudge in the right direction.
Sure.
I was showing you how it could be run from a batch file, such as winhook, to run automatically or remotely or whatever...
If you don't need that, then just go in aloha manager to Functions...create ADP Export.
The batch file doesn't have to be in BIN, or anywhere, it just needs to point to bin to run the rpt.exe (the report applet) with the switches: "/DATE %1" (means 'yesterday') and "/RD" which means to create the "export" report which will be an ADP export file in the PCPERS folder.
But I also just realized you could be looking for an "HR Bridge". This is available through Enterprise/Insight. If you're an enterprise customer, open a support ticket and they'll get you the information, or maybe even set it all up for you.
These are two different animals. I was showing you how to create the export, not a 'bridge'.
If you aren't an enterprise user, then you'll have to speak with ADP about where this file needs to be or where it needs to go, like an FTP transfer to them, or an ADP software piece for you. In this case the previous instructions will help you create the file needed.
Sorry if this got confusing.
I was showing you how it could be run from a batch file, such as winhook, to run automatically or remotely or whatever...
If you don't need that, then just go in aloha manager to Functions...create ADP Export.
The batch file doesn't have to be in BIN, or anywhere, it just needs to point to bin to run the rpt.exe (the report applet) with the switches: "/DATE %1" (means 'yesterday') and "/RD" which means to create the "export" report which will be an ADP export file in the PCPERS folder.
But I also just realized you could be looking for an "HR Bridge". This is available through Enterprise/Insight. If you're an enterprise customer, open a support ticket and they'll get you the information, or maybe even set it all up for you.
These are two different animals. I was showing you how to create the export, not a 'bridge'.
If you aren't an enterprise user, then you'll have to speak with ADP about where this file needs to be or where it needs to go, like an FTP transfer to them, or an ADP software piece for you. In this case the previous instructions will help you create the file needed.
Sorry if this got confusing.
- Thread starter
- #7
alohaakamai3
IS-IT--Management
No apologies necessary, I very much appreciate your assistance.
In response to a few of your comments:
We are not an enterprise customer... that is, our stores are not on an enterprise version of Aloha.
On the other hand, the ADP guy did call it a bridge. Not an "HR Bridge"... but a bridge. They were not extremely helpful or clear. But the impression that I got was that they wanted what you originally said- an export file.
I am a little frusrtated with them, the guy can't seem to answer much.
In response to a few of your comments:
We are not an enterprise customer... that is, our stores are not on an enterprise version of Aloha.
On the other hand, the ADP guy did call it a bridge. Not an "HR Bridge"... but a bridge. They were not extremely helpful or clear. But the impression that I got was that they wanted what you originally said- an export file.
I am a little frusrtated with them, the guy can't seem to answer much.
- Thread starter
- #8
alohaakamai3
IS-IT--Management
Also, when I try to create ADP export, I select a date, and it says Now Run the ADP Validation Program....??
- Thread starter
- #9
alohaakamai3
IS-IT--Management
Sorry, I didn't mean to post that last message just yet, wasn't finished...
but anyway, I talked to the guy at ADP and he said all they need is a output file in csv in format, similar to a sample her sent me.
Hopefully, that will shed some light on what type of bridge this is... it certainly sounds like an simple export.
but anyway, I talked to the guy at ADP and he said all they need is a output file in csv in format, similar to a sample her sent me.
Hopefully, that will shed some light on what type of bridge this is... it certainly sounds like an simple export.
- Thread starter
- #10
alohaakamai3
IS-IT--Management
I should mention that I do get output when I run the report as you suggested, but it's not a csv file, it looks like this inbs PCPERS folder:
A001 00201z 6
B00300989400410080000060110150000 0120000450 z
B00300783600410080000060110150000 0120000450 z
z
B00300455800410080000060110200000 0120000440
Follow the few previous threads there were regarding this topic, the results are not very encouraging.
A001 00201z 6
B00300989400410080000060110150000 0120000450 z
B00300783600410080000060110150000 0120000450 z
z
B00300455800410080000060110200000 0120000440
Follow the few previous threads there were regarding this topic, the results are not very encouraging.
- Thread starter
- #12
alohaakamai3
IS-IT--Management
Yeah, one of the most recent posts I saw about it was yours, and it was while back. And that's not a good sign considering you worked (or work) for dealer, didn't you?
I thought TransManager was just for Quickbooks.
I thought TransManager was just for Quickbooks.
I may have been a dealer, run a dealership, worked for one or all of the above. I will not go into detail in a public forum.
TransManger is the only way to bridge to ADP that I am aware of. The CVS export file is not in the format ADP wants to my knowledge. It worked years ago but ADP updated their systems and the export file never changed unless that was done in fairly new versions.
TransManger is the only way to bridge to ADP that I am aware of. The CVS export file is not in the format ADP wants to my knowledge. It worked years ago but ADP updated their systems and the export file never changed unless that was done in fairly new versions.
- Thread starter
- #14
alohaakamai3
IS-IT--Management
Well, it's not like we know who you are 
but fair enough, I just thought I heard you openly mention that once in the years you've been contributing on this forum. My only point being, if you had access to Aloha support, etc... and still couldn't get it to work without TransMan, that's not a good sign.
Yeah, they have for sure said the csv file will be the output and uploaded to their site, and that the bridge has to be create by us.
I wonder if they still make Transmanager.
but fair enough, I just thought I heard you openly mention that once in the years you've been contributing on this forum. My only point being, if you had access to Aloha support, etc... and still couldn't get it to work without TransMan, that's not a good sign.Yeah, they have for sure said the csv file will be the output and uploaded to their site, and that the bridge has to be create by us.
I wonder if they still make Transmanager.
posknowitall
Technical User
There's icontrolpos.com. I have a few customers who worked with him and like the product. Nice guy to work with also which makes it nice. Something like $500 to start up though.
- Thread starter
- #17
alohaakamai3
IS-IT--Management
Thanks for the tip. Is icontrolpos a product/person who can build the bridge from Aloha to ADP? Looked a little online, but what I was coming across looked like a POS system.
posknowitall
Technical User
It's a bridge to Adp. He does everything remotely. Uses Gotomeeting and that stuff. Give him a call.
- Status
Similar threads