Member Avatar for GlockComa

I have a simple online credit application where customers put in their credit related data, i.e. Name, Address, SS #, Birthday, etc.

I have to use another program to pull credit that requires me to input all that info.

So currently I get my online app screen up and have to print it. Then manually type all the data into the second application.

Is there a program that anyone knows of that I can use to map the data from one to another by clicking a button or something?

Thanks so much for you help!

  • 3 Contributors
  • 2 Replies
  • 224 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by chrishea

Dani AI

Generated

Short answer: pick the right pattern for the job. If the credit-pull program offers an official import (CSV/JSON) or an API, build a small mapper that exports your online app’s fields in the required shape and submit server-to-server — that’s the most reliable and secure option. If no integration exists, automate the target UI with a scripting tool or browser automation. was right that scripting will handle this; ’s point about checking for an “official” input method is the right first step.

If an API or import exists, workflow checklist:

  • Discover required field names (check docs or capture the network POST while doing a manual submit).
  • Create a single mapping table (source field → target field).
  • Export or POST only the mapped values; test with a non-production sandbox account.

Example: write a mapped CSV or POST JSON (very small Python sketch):

# build a mapped payload and write CSV or POST if API exists
mapping = {"name":"app_name","address":"app_address","ssn":"app_ssn","dob":"app_dob"}
row = [source[k] for k in mapping.keys()]

import csv
with open('out.csv','w',newline='') as f:
    writer = csv.writer(f)
    writer.writerow(mapping.values())
    writer.writerow(row)

# or, if target has an API:
# requests.post("https://target.example/api/submit", json={mapping[k]:source[k] for k in mapping})

If no API, use UI automation (Selenium for web forms, AutoHotkey or RPA tools for desktop apps). Keep selectors stable, add explicit waits, retry logic, and a way to surface failures for manual review. Minimal AutoHotkey idea to paste pipe-separated clipboard fields into successive inputs:

^!v::
fields := StrSplit(Clipboard, "|")
SendInput % fields[1] "{Tab}" fields[2] "{Tab}" fields[3] "{Tab}" fields[4]
Return

Security & troubleshooting: never log full SSNs or other PII, use TLS, test with dummy data, run many small dry runs, and confirm the credit vendor’s terms and compliance requirements before automating live transfers.

Recommended Answers

All 2 Replies

Member Avatar for BestJewSinceJC

It sounds like pretty much any Scripting Language could do this task easily. I just started learning scripting languages though, so. . I digress. Either way though, this question would be better suited for the Computer Science forum, or you could go ahead and post it in one of the Web development forums where you'd get a faster, better answer.

Member Avatar for chrishea

The first question to answer is if there is an "official" way to get data into the second application (an API of some kind). If the answer is no, then you will need to automate the filling of the form for the second application. One way to possibly do this is the Snoopy class. I did some searching and found it. The link is below. I haven't used it myself but I'm going to do a bit of experimenting. You can also do it yourself using the PHP HTTP functions.

http://sourceforge.net/projects/snoopy/

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.