An export from elementool does not provide the attachments. This fixes that.
- Install node (if you haven't already).
- Export your elementool database (if you haven't already).
- Open it in excel.
- When prompted to select a table, choose
- Delete the columns except the first column.
- "Save As" "text (tab-delimited) .txt". For convenience, name the file
- Move that file,
attachments.txt, into this project's root folder,
- Open a command prompt and navigate to this project's root folder,
npm install request.
node app "account name" "username" "password".
Depending on your internet connection speed, how busy elementool's servers are (time of day helps),
and of course, how many attachments, how large they are -- the time to complete could be minutes or hours.
If it ends with
Complete., it worked. Your attachments are in the attachments folder.
Attachment filenames are prefixed with their elementool issuenumber.
If that is already your practice, the filenames will become doubly prefixed with the issue number.
Note: If the program does not end with
Complete., then it did not process all attachments.
Look at the output to see where it left off and add that number as a fourth parameter:
node app "account name" "username" "password" "# to resume from". Repeat as needed.
Surprisingly, I obtained the best results from node on windows (v0.6.19). It processed all 1200 attachments in one go.