Autofill a Forum Post from a database or excel file data

[kendout]

I have 2 question:
1/ I need to post a few hundred  post to a forum with data in a excel or a database store on local drive. How can I do that?
2/ The post have an management ID and I want to trigger the autofill whenever I paste the ID to the field on Forum. e.g: a post have the ID 1235 - when I paste the ID to the title field, it will fill all the rest.

[Markus]

I don't think that it is possible to use Autofill in the way you describe it in point 1. 

However, in case this would work, I'd be curious to know how this works either. 

[thdoan]

This is possible, but you'd need to be well versed in JavaScript and web services, which is out of scope for this forum.

On a high level:

1. You'd need to save your data in a cloud that exposes an API to read this data (e.g., Google Cloud Storage, Pastebin), or as a plain text file (e.g., CSV) on a server which can be parsed using XMLHttpRequest.
2. Once you achieve #1, you'd then need to create a JavaScript rule that does two things:
   • load the data and convert it into an associative array (e.g., var data = { 'id123': 'value abc', 'id456': 'value def', ... };)
   • create an event handler that populates one forum field depending on what ID you entered in another forum field (e.g., someForumField.value = data['id123'];)

StackOverflow is your friend if you get stuck 8).

[Markus]

Thank you thdoan! :) That is really helpful and a good idea! 

[Jacksen Pierce]

It would mean the world if you would put together a best-case scenario tutorial for this process, or at least some more comprehensive documentation so it doesn't take people hours to find their answer. It's not clear on the help page beyond the header specifications what is necessary to create, host, or access a remote file. Anything would be helpful. 

Thanks for all the work so far!