CRM Program Help

[savagenoob]

I have created an online CRM type website designed for insurance agencies. All of the agencies that will be using it will also be using a certain program installed locally. This program allows you to create a "bridge" from that software to another, pushing client data via an xml file. When you click on the bridge, it creates a .zip file that includes the xml file with the client data. Other websites have created a batch file in a specified directory that pushes the xml data to their website, automatically filling in data so the user does not have to type the data twice. I need to accomplish this same thing but have a couple issues.

1. I dont know much about batch scripting but it looks quite easy and probably can figure it out. I dont know how I can extract the zip file automatically or figure out the zip file name since it changes based on the file you export, but can point it to export directly to the batch file. Maybe someone will know how to point me in the right direction.

2. How do I create the interface on my site (PHP Mysql) to accept the xml data, but require the user to login before it imports it completely. I'm not too good with XML either, maybe a push in the right direction from someone will help.

 

Thanks for the help.

[savagenoob]

OK, I found an example of how another website handles this... Here is the batch code...

@echo off

If '%1' == '' GOTO ERRNOARG
If NOT EXIST %1 GOTO ERRNOQUOTE

If EXIST %windir%\win.com GOTO WIN95

If %OS% == Windows_NT GOTO WINNT

echo System type unknown
pause
GOTO END

:WIN95
If NOT EXIST snap MKDIR snap
copy %1 snap
echo.
echo Launching Internet Explorer...
echo.
echo Please click the close button in the corner of this DOS window.
%windir%\command\START iexplore.exe "http://www.mysite.com/PHP-Login/uploadrater.php?fp=%1&ty=0"
GOTO END

:WINNT
If NOT EXIST snap MKDIR snap
copy %1 snap
cmd /c START iexplore.exe "http://www.mysite.com/PHP-Login/uploadrater.php?fp=%1&ty=0"
GOTO END

:ERRNOARG
Echo No Argument Passed or Found!
pause
GOTO END

:ERRNOQUOTE
Echo Quote File (%1) not found!
pause
GOTO END

:END
Exit

So it looks like they just put the file path in a GET request but how can I get the file or file info from this filepath? I probably have to upload the file, open it, then parse the data, which I can do, just dont know how to the file to a directory where I can open it automatically with this batch file.

[fooDigi]

*tip*... if you consolidate your post more, you have a better chance of being answered...