Challenge Overview
Node.js SFTP! Heroku! Postgres! BOOM!
Here's a light and easy one using everyone's favorite technologies! (well...maybe not SFTP). You're going to use Node.js on Heroku to get a file from a FTP server. After you get the file, you'll parse through it and insert the data into a target Postgres table. There's one caveat: As you are parsing the file, you'll need to do a lookup from another table and insert that into the target Postgres table.
Detailed Overview:
1. Node.js SFTP client to get CSV file from server
2. Parse the file
3. Use the "User ID" field from the file to get the "Id" field from the table "CONN_User". You'll match on the "UserId" field from the "CONN_User" table.
4. Take the result and use the map below to insert into the "CONN_User_Pref__c" table:
2. A video demo'ing your app. You may annotate the video with text if you do not wish to speak.
3. A video showing your code. Not required, but very helpful!
Here's a light and easy one using everyone's favorite technologies! (well...maybe not SFTP). You're going to use Node.js on Heroku to get a file from a FTP server. After you get the file, you'll parse through it and insert the data into a target Postgres table. There's one caveat: As you are parsing the file, you'll need to do a lookup from another table and insert that into the target Postgres table.
Detailed Overview:
1. Node.js SFTP client to get CSV file from server
2. Parse the file
3. Use the "User ID" field from the file to get the "Id" field from the table "CONN_User". You'll match on the "UserId" field from the "CONN_User" table.
4. Take the result and use the map below to insert into the "CONN_User_Pref__c" table:
CONN_User_Pref__c Field || CSV Field
CONN_key__c || "MyApp"
CONN_Value__c || Status
CONN_User__c || "Id" from "CONN_User" lookup
CONN_key__c || "MyApp"
CONN_Value__c || Status
CONN_User__c || "Id" from "CONN_User" lookup
5. The ftp host /username and password along with any other variable should all be included in a config file so your solution can modifed without deploying new code.
6. Profit???
To help things along, there's a forum post with the SFTP information and Postgres table DMLs.
You'll need to setup a Heroku app and a Postgres database to host the table.
6. Profit???
To help things along, there's a forum post with the SFTP information and Postgres table DMLs.
You'll need to setup a Heroku app and a Postgres database to host the table.
Final Submission Guidelines
1. All files must be in a single ZIP file2. A video demo'ing your app. You may annotate the video with text if you do not wish to speak.
3. A video showing your code. Not required, but very helpful!