DEV Community: Joysankar Majumdar

Importing Ghost Blog Users to Appwrite

Joysankar Majumdar — Tue, 25 Oct 2022 09:31:57 +0000

In Appwrite 1.0, a new feature has been added to allow users to migrate from other platforms like Firebase, WordPress, Ghost, Supabase, etc. to Appwrite. So in this tutorial we are going to migrate all the users(members) from Ghost Blog to Appwrite, and this is going to be super easy!

Let's do it 🦾

Step 1: Export users(members) from Ghost Blog

Firstly, login to your Ghost admin and go to the Settings page, and then scroll down and go to the Labs section.

Now in Labs, export your content into a json file by clicking the Export button.

You'll get a json file of all your contents like this

This json file contains all the users' data. Now we need to import all the data into the Appwrite.

Step 2: Import Users to Appwrite

To import users into Appwrite, we can use any Server SDK to access the Users API. For this example, we will use the NodeJS SDK.

Newly added functions let you create a user with one of seven different hashing algorithms. Ghost uses the Bcrypt algorithm for saving passwords. So we will use Bcrypt Password in the Appwrite Server SDK to import users.

async createBcryptUser(
        userId,
        email,
        password,
        name
      );

Going through the function parameters one by one:

userId: The ID to assign to the new user in Appwrite. It can be custom, or you can use the SDK's new ID.unique() function to assign a randomly generated ID.
email: Corresponds to the email value from the json file.
password: Corresponds to the passwordHash value from json file.
name: The name to assign to the user. Can be null.

Putting this all together, we could import all of the exported users into Appwrite like so:

const outfile = "cozblog.ghost.2022-10-24-17-31-47.json";
  const json = await fs.readFile(outfile, { encoding: "utf8" });
  const exported = JSON.parse(json).db[0].data.users;
  await Promise.all(
    exported.map(async (user) => {
      await users.createBcryptUser(
        ID.unique(),
        user.email,
        user.password,
        user.name
      );
    })
  );

After all the user export the Appwrite dashboard looks like this

So now the whole code looks like this


const sdk = require("node-appwrite");
const { ID } = require("node-appwrite");
const fs = require('fs/promises');

let client = new sdk.Client();

const users = new sdk.Users(client);

const endPoint = "Your End Point";
const projectId = "Your Project Id";
const apiKey = "Your Api Key";
client
  .setEndpoint(endPoint)
  .setProject(projectId)
  .setKey(apiKey)
  .setSelfSigned();

const migrate = async () => {
  const outfile = "cozblog.ghost.2022-10-24-17-31-47.json";
  const json = await fs.readFile(outfile, { encoding: "utf8" });
  const exported = JSON.parse(json).db[0].data.users;
  await Promise.all(
    exported.map(async (user) => {
      await users.createBcryptUser(
        ID.unique(),
        user.email,
        user.password,
        user.name
      );
    })
  );
};

migrate()
  .then((r) => console.log("Done!"))
  .catch((e) => console.log(e));

Hope you learn how to migrate users from WordPress to Appwrite.
Don't forget to follow me @joysankar2001

Migrate Wordpress Users to Appwrite

Joysankar Majumdar — Tue, 11 Oct 2022 07:32:10 +0000

In Appwrite 1.0, a new feature has been added to migrate users from other platforms like Firebase, WordPress, Supabase etc to Appetite. So in this tutorial we are going to migrate all the users from WordPress to Appwrite and this is going to be super easy!

Let's do it 🦾

Step 1: Login to your WordPress website and install plugin

Firstly login to your WordPress website's admin panel and install the free plugin named Import and export users and customers

Step 2: Export users from WordPress

Now in your WordPress dashboard go to Tools>Export>Users (in CSV format) and then Download Export File

Then download the csv file according to your preferred settings

Step 3: Import Users to Appwrite

To import users into Appwrite, we can use any Server SDK to access the Users API. For this example, we will use the NodeJS SDK.

Newly added functions let you create a user with one of 7 different hashing algorithms. Wordpress uses PHPass Password. So we will use PHPass Password in Appwrite Server SDK to import users.

async createPHPassUser(
        userId,
        email,
        password,
        name
      );

Going through the function parameters one by one:

userId: The ID to assign to the new user in Appwrite. It can be custom, or you can use the SDK's new ID.unique() function to assign a randomly generated ID.
email: Corresponds to the email value from the csv file.
password: Corresponds to the passwordHash value from csv file.
name: The name to assign to the user. Can be null.

Putting this all together, we could import all of the exported users into Appwrite like so:

const userslist = await CSVToJSON().fromFile("users.csv");
  await Promise.all(
    userslist.map(async (user) => {
      await users.createPHPassUser(
        ID.unique(),
        user.user_email,
        user.user_pass,
        user.display_name
      );
    })
  );

additionally you need to install csvtojson package to parse CSV data using the command below

npm i csvtojson

After all the user export the Appwrite dashboard looks like this

So now the whole code looks like this

const sdk = require("node-appwrite");
const { ID } = require("node-appwrite");
const CSVToJSON = require("csvtojson");

let client = new sdk.Client();

const users = new sdk.Users(client);

client
  .setEndpoint("Your Api Endpoint")
  .setProject("Your Project Key")
  .setKey("Your Api Key")
  .setSelfSigned();

const migrate = async () => {
  const userslist = await CSVToJSON().fromFile("users.csv");
  await Promise.all(
    userslist.map(async (user) => {
      await users.createPHPassUser(
        ID.unique(),
        user.user_email,
        user.user_pass,
        user.display_name
      );
    })
  );
};

migrate()
  .then((r) => console.log("Done!"))
  .catch((e) => console.log(e));

Hope you learn how to migrate users from WordPress to Appwrite.
Don't forget to follow me @joysankar2001

Suggest me : College/ University management system

Joysankar Majumdar — Thu, 29 Sep 2022 07:07:42 +0000

What is best free or open source college/ university management system? Please suggest me in the comments

Watery : A water delivery solution android app

Joysankar Majumdar — Sun, 01 May 2022 10:32:28 +0000

Overview of My Submission

Watery is an android e-com app for water supply where user can order required water bottle or jars and delivery boys will deliver the waters. It is a native android app build on Kotlin.

Apps process

After entering the app you'll have two option of login

as a customer
as a delivery partner

Now if you join as a customer the you need to create account or need to login.
Here I have used Appwrite's authentication flow to create account or to create a new seassion.

Login	Create account

After successful login you'll be redirect to the main dashboard page where you will get all the list of water products.
In the dashboard I have Google Play Loction to get user location and Appwrite's Database to fetch all products' info and Storage to fetch all the images.

Then you need to cart your desired products and go to cart page and pick your location and mobile number.
In this page the user's all carted products information is collected and using Google Map the loction is selected.

Now you can pay via Cash On Delivery Or Online. Here I have integrate Razorpay to accept online payments. After successful payment your order will be placed.
When payment is successful the date is saved as a Order object in Appwrite's Database.

Now from the dashboard you can check your order and track your orders.
Hare the orders list is fetched from Appwrite's Database.

Order list	Tracking order

Now on the other hand if you join as a delivery partner then you need to login.

After login you will be redirect to the dashboard where the delivery partner can see all the orders from all user and now he can set order status e.g. Order Accepted, Order Shipped, Order Delivered etc.

Here a delivery partner update that order status in Appwrite's Databse which is reflected on user's order list.

Submission Category:

Mobile Moguls

This app is made with Appwrite's Android SDK.

Link to Code

JoyMajumdar2001 / Watery

Watery : An water delivery android app using Appwrite

Watery

Watery is an android app to deliver water to customer like an e-com app. The backend of this app is fully made with Appwrite. From Authentication to Database, the Appwrite powers this app.

Apps process

After entering the app you'll have two option of login

as a customer
as a delivery partner

Now if you join as a customer the you need to create account or need to login Here I have used Appwrite's authentication flow to create account or to create a new seassion.

After successful login you'll be redirect to the main dahboard page where you will get all the list of water pdoducts. In the dashboard I have Google Play Loction to get user location and Appwrite's Database to fetch all products' info and Storage to fetch all the images.

Then you need to cart your desired products and go to cart page and pick…

View on GitHub

Additional Resources / Info

Used tech

Emotion Badge for Github

Joysankar Majumdar — Wed, 23 Feb 2022 14:50:23 +0000

Overview of My Submission

EmotionBadge is a service of choice. It extracts the emotion from your Github profile photo using Azure Face Api and gives you a bagde using Shields.io for your README.md file.

Submission Category:

AI Aces

Link to Code on GitHub

JoyMajumdar2001 / EmotionBadge

Rate your Github profile picture emotion using badges

EmotionBadge 😊

EmotionBadge is a service of choice. It extracts the emotion from your Github profile photo using Azure Face Api and gives you a bagde using Shields.io for your README.md file.

Usage

It is too easy to use and insert in your README.md

https://emotionbadge.onrender.com/emotion/<Your github username>/<emotion>

Avilable emotion types are

auto
smile
anger
contempt
disgust
fear
happiness
neutral
sadness
surprise

In auto emotion, the emotion which have the most probable value will be displayed automatically.

Example

Scoring system

In this project we are using Azure Face Api to detect emotions from the profile picture. It scores the emotion between 0 to 1 upon the Face Api model confidence. It is based on AI so the score may not be satisfatory everytime to users.

If it does not find any face of any user profile picturec then it shows and error badge like

Used Tech

View on GitHub

Usage

It is too easy to use and insert in your README.md

https://emotionbadge.onrender.com/emotion/<Your github username>/<emotion>

Avilable emotion types are

auto
smile
anger
contempt
disgust
fear
happiness
neutral
sadness
surprise

In auto emotion, the emotion which have the most probable value will be displayed automatically and if no face is detected then it'll show this badge

Example

Scoring system

If it does not find any face of any user profile picturec then it shows and error badge like

Used Tech

TeleIn

Joysankar Majumdar — Sat, 19 Feb 2022 20:41:06 +0000

Overview of My Submission

I have build an authentication system where user can login in the application(android) with the help of Telegram (Bot service). In this system , any user has not to go through any hassel. Any user just need to follow the steps to login the TeleIn app

Go to TeleIn app's login page
Click Login and it will redirect to Telegram app
Now in Telegram , just click start
The TeleIn Telegram Bot will provide a link
Click the link and you will be redirect to the TeleIn
By default it'll take your Telegram name, you can change it now and Submit.

That's it. Its too simple. No OTP no email comfirmation no extra auth flow! Just simple!

Cosmos DB is the place where I store the data of user safely using the Node server.

Submission Category:

Wacky Wildcards

Link to Code on GitHub

Server

JoyMajumdar2001 / telein-server

Telein Server

This is the backend of TeleIn Android App The backend server is based on NodeJs and it uses Telegraf to make conection with Telegram Bot This backend is hosted on Render.

Code snippets

async function login(keyid, res) {
  resourcesMain = await container.items
    .query({
      query: "SELECT * from c WHERE c.tempuid = @Uid",
      parameters: [{ name: "@Uid", value: keyid }],
    })
    .fetchAll();

  resources = await container2.items
    .query({
      query: "SELECT * from c WHERE c.tid = @Tid",
      parameters: [{ name: "@Tid", value: resourcesMain.resources[0].tid }],
    })
    .fetchAll();

    if(resources.resources.length == 0){
        var crtAcc =

…

View on GitHub

Android

JoyMajumdar2001 / TeleIn-Android

TeleIn-Android

Go to TeleIn app's login page
Click Login and it will redirect to Telegram app
Now in Telegram , just click start
The TeleIn Telegram Bot will provide a link
Click the link and you will be redirect to the TeleIn
By default it'll take your Telegram name, you can change it now and Submit.

That's it. Its too simple. No OTP no email comfirmation no extra auth flow! Just simple!

Used Tech

Cosmos DB
Okhttp3
Coroutine

Demo

https://bafybeigudm4ljexyo6qrjwpumkw6t4kblgyau7hjv7raqfycvmvjmpogce.ipfs.dweb.link/Record_2022-02-20-01-32-15.mp4

View on GitHub

Additional Resources / Info

Tech Used

Demo

Your browser does not support the video tag.

DisasterAlerter

Joysankar Majumdar — Wed, 12 Jan 2022 13:39:40 +0000

Overview of My Submission

DisasterAlerter is an alerting system on android where an admin can create an alert and immediately an notification will pop up in the users' phone.

Submission Category:

Action Star

Link to Code

JoyMajumdar2001 / DisasterAlerter

An notfication alert sending and receiving system using android

DisasterAlerter

This is an android application for alerting people by some govt boy by pushing notifications in users' device. This app is made for AtlasHackathon contest using MongoDb Atlas, Triggers, Realm function and FCM.

Screenshots

Images	Images

Realm function

exports = function(changeEvent) {
const cred = {
 // FCM credentials
};
var admin = require("firebase-admin");
admin.initializeApp({
    credential: admin.credential.cert(cred)
});
var alertData = changeEvent.fullDocument;

const topic = '/topics/dis-topic';

    const message = {
        notification: {
            title: alertData.type + ' alert at ' + alertData.time,
            body: alertData.msg
        },
        topic: topic
    };
    return admin.messaging().send(message)
        .then((response) => {

            console.log('Successfully sent message:', response);
        })
        .catch((error) => {
            console.log('Error sending message:', error);
        });
};

Used Technology

In this android application , I have used the technologies given below -

Kotlin In this project kotlin is used to code the full application on Android Studio
Mongodb-atlas Database Mongodb-atlas database is used to store all the data…

View on GitHub

Screenshots

Images	Images

Realm function

exports = function(changeEvent) {
const cred = {
 // FCM credentials
};
var admin = require("firebase-admin");
admin.initializeApp({
    credential: admin.credential.cert(cred)
});
var alertData = changeEvent.fullDocument;

const topic = '/topics/dis-topic';

    const message = {
        notification: {
            title: alertData.type + ' alert at ' + alertData.time,
            body: alertData.msg
        },
        topic: topic
    };
    return admin.messaging().send(message)
        .then((response) => {

            console.log('Successfully sent message:', response);
        })
        .catch((error) => {
            console.log('Error sending message:', error);
        });
};

Used Technology

In this android application , I have used the technologies given below -

Kotlin: In this project kotlin is used to code the full application on Android Studio
Mongodb-atlas Database: Mongodb-atlas database is used to store all the data admin send for alert
Mongodb Data-Api: Data-Api is used to read and write data from Mongodb Database in the android application through network call
Mongodb Triggers: When a new document is created via Data-Api, a Realm Function is called to send a request in FCM to send notifications to user end.
FCM: Firebase Cloud Messaging is used to send topic wise notifications using Realm function.

Logistics app for android using Mongodb-atlas data api and triggers

Joysankar Majumdar — Sun, 26 Dec 2021 06:42:43 +0000

Overview of My Submission

An logistics android app for client and delivery partners using Mongodb-atlas data api and triggers

Submission Category:

Action Star

Link to Code

JoyMajumdar2001 / DeliveryGo

An android app using Mongodb for logistics tracking system.

DeliveryGo

An android application for logistics tracking.

Used technology

Kotlin: In this project kotlin is used to code the full application on Android Studio
Mongodb-atlas Database: Mongodb-atlas database is used to store all the data used in this application
Mongodb Data-Api: Data-Api is used to read and write data from Mongodb Database in the android application through network call
Mongodb Triggers: In this project I use Mongodb Database trigger to send emails to recipients when shipment is created and order is delivered using Sendgrid

View on GitHub

Additional Resources / Info

Screenshots

Images	Images

Used technology

Kotlin: In this project kotlin is used to code the full application on Android Studio
Mongodb-atlas Database: Mongodb-atlas database is used to store all the data used in this application
Mongodb Data-Api: Data-Api is used to read and write data from Mongodb Database in the android application through network call
Mongodb Triggers: In this project I use Mongodb Database trigger to send emails to recipients when shipment is created and order is delivered using Sendgrid

MathRenderer for Android

Joysankar Majumdar — Thu, 16 Dec 2021 10:28:40 +0000

What is MathRenderer ?

MathRenderer is a simple and easy to use kotlin library for rendering mathematical equations or formulas in your android application. It is based on the MathJax javascript library. It renders all the equations or formulas in a WebView as MathRendererView.

How it works ?

MathRenderer library uses the MathJax cdn javascript file to render the formulas or equations in a browser, so the app works when it is only connected with internet. Basically this library generate a html Base64 string and load it via WebKit WebView.

Customization

This library still now offers only four types of customization -

text
textColor
textAlignment
mathBackgroundColor

text

You need to give the LaTex or TeX string with proper syntax to the text field.

textColor

You need to pass the hex color code as a string here to change the colour of text.

textAlignment

You need to just set the proper TextAlign. There are three types of TextAlign - TextAlign.CENTER TextAlign.START TextAlign.END

mathBackgroundColor

You need to pass the colour code as a string to change the whole background colour of the MathRendererView.

A demo code

    binding.mathRenderView.apply {
                text = "This is an equation \\(x^2+6x-9\\)"
                textAlignment = TextAlign.CENTER
                textColor = "#FFFFFF"
                mathBackgroundColor = "#000000"
            }

Installation

Add below lines to app's build.gradle

repositories {
    maven { url 'https://jitpack.io' }
}

dependencies {
    implementation 'com.github.quantaDot:MathRenderer:1.0.3'
}

And don't forget to add Internet permission in your app's AndroidManifest.xml file

    <uses-permission android:name="android.permission.INTERNET"/>