We must import old datas from the previous support websites.

• User are created as is from the user databases first
• Adresses are the same, they're imported as is. We might end up with a lot of them.
• Pledges are a bit trickier
  • Status 1, are validated single pledges. We should link them to the SystemPay payment. And to a user if they have an existing email adresses matching one of our user
  • Status 101 gives us the creation_date of a recurring pledge (which is then created in a 'processed' state). They gave us the account_id for the recurring pledge.
  • Status 102 gaves us the number of iteration, as well as expiration_date and the last time the pledge has been updated. If they're not updated for the last 6 months, have them in 'canceled' state.
  • Each pledge in 1 or 101 is associated to a free piplome if some field are provided, use them to create the ClaimedBonus object linked to the Bonus with a 0 threshold and to prepare the piplome, extract the decimals from the data.
• Counterparts are the worst since there is no bonus system
  • Get all the counterparts existing for a user.
  • Create a ClaimedBonus of the highest threshold for any hoopie asked by a user.
  • Create a ClaimedBonus of the second highest threshold for any pishirt minus any ClaimedBonuses(threshold>0) asked by a user
  • Create a ClaimedBonus of the third highest threshold for any pibag minus any ClaimedBonuses(threshold>0) asked by a user
  • Create a ClaimedBonus of the fourth highest threshold for any printed piplome minus any ClaimedBonuses(threshold>0) asked by a user
• For each item created, flag them as sent.

We need some management commands for that

• Empty database is used to clear the database of anything in it

The following ones need some mysql parameters to connect to a database

• Import donor

• Import addresses

• Import pledges

• Import counterparts

• Import everything (execute the four previous one in this order)

• Generate piplome. This command will take any piplome in error, flag them as new, then call the generate function on each non generated piplome.

ALl of the commande should have a progress bar.