Page 1 of 3

Custom Import routine

Posted: Mon Mar 07, 2022 5:07 pm
by martin@rootjazz
Custom import accounts with custom CSV format, including custom separator

Note you must user the Custom Import link, not the normal import button

Image



Format must be CSV (comma)

Format:

Code: Select all

line1:<spec>
line2+: <accs>
or CUSTOM separator char.
Format:

Code: Select all

line1: <sep>
line2: <spec>
line3+: <accs>
 
where <sep> is the separator char used:

Code: Select all

,
:
| 


Columns can be:
username
password
proxy
email
pop
phone
notes
tags
cookiesbase64
cookiescookies
cookieskv2
WARNING: notes cannot contain a comma
For multiple tags use a space




POP Format: Use a : separation CSV

Code: Select all

email:password:server:port:ssl
example:

Code: Select all

john@outlook.com:pa550wrd1:pop.outlook.com:995:true
You can manually specify the order, example

Code: Select all

username,password,email
dave6235467,p455word1,dave6235467@gmail.com
dave123678,p455word1,dave123678@gmail.com
dave9326867,p455word1,dave9326867@gmail.com


or with custom sep char

Code: Select all

|
username|password|email
dave6235467|p455word1|dave6235467@gmail.com
dave123678|p455word1|dave123678@gmail.com
dave9326867|p455word1|dave9326867@gmail.com


or

Code: Select all

username,password,phone,notes,tags
dave6235467,p455word1,+1 72362563, a new account for testing, testing niceh1
dave123678,p455word1,44 867378463784,established account, moneyacc
dave9326867,p455word1,93 987436437,aged acc, moneyacc

so whatever order you specify the <spec> line is how the import lines are read in





Regards,
Martin

Re: Custom Import routine

Posted: Fri Jun 24, 2022 1:17 pm
by martin@rootjazz
Cookie spec supported via token

cookiesbase64


Cookies should be JSON formatted list then base64 encoded. This seems to be becoming a sort of standard spec for cookies in import files. Not everywhere uses, to be honest most don't but it is probably the best and used more often than other custom specs


so cookies:

Code: Select all

[
{
    "domain": ".twitter.com",
    "expirationDate": 1718727529.0,
    "hostOnly": true,
    "httpOnly": false,
    "name": "guest_id_marketing",
    "path": "/",
    "sameSite": "None",
    "secure": true,
    "session": false,
    "storeId": null,
    "value": "v1%3A165123123127144419",
    "id": 1
  },
  {
    "domain": ".twitter.com",
    "expirationDate": 1718727529.0,
    "hostOnly": true,
    "httpOnly": false,
    "name": "guest_id_ads",
    "path": "/",
    "sameSite": "None",
    "secure": true,
    "session": false,
    "storeId": null,
    "value": "v1%3A161231231212317144419",
    "id": 1
  },
  {
    "domain": ".twitter.com",
    "expirationDate": 1718727529.0,
    "hostOnly": true,
    "httpOnly": false,
    "name": "personalization_id",
    "path": "/",
    "sameSite": "None",
    "secure": true,
    "session": false,
    "storeId": null,
    "value": "\"v1_Iskis12312312N3SQ==\"",
    "id": 1
  }
}
]
then base64 encoded become

Code: Select all

ewogICAgImRvbWFpbiI6ICIudHdpdHRlci5jb20iLAogICAgImV4cGlyYXRpb25EYXRlIjogMTcxODcyNzUyOS4wLAogICAgImhvc3RPbmx5IjogdHJ1ZSwKICAgICJodHRwT25seSI6IGZhbHNlLAogICAgIm5hbWUiOiAiZ3Vlc3RfaWRfbWFya2V0aW5nIiwKICAgICJwYXRoIjogIi8iLAogICAgInNhbWVTaXRlIjogIk5vbmUiLAogICAgInNlY3VyZSI6IHRydWUsCiAgICAic2Vzc2lvbiI6IGZhbHNlLAogICAgInN0b3JlSWQiOiBudWxsLAogICAgInZhbHVlIjogInYxJTNBMTY1MTIzMTIzMTI3MTQ0NDE5IiwKICAgICJpZCI6IDEKICB9LAogIHsKICAgICJkb21haW4iOiAiLnR3aXR0ZXIuY29tIiwKICAgICJleHBpcmF0aW9uRGF0ZSI6IDE3MTg3Mjc1MjkuMCwKICAgICJob3N0T25seSI6IHRydWUsCiAgICAiaHR0cE9ubHkiOiBmYWxzZSwKICAgICJuYW1lIjogImd1ZXN0X2lkX2FkcyIsCiAgICAicGF0aCI6ICIvIiwKICAgICJzYW1lU2l0ZSI6ICJOb25lIiwKICAgICJzZWN1cmUiOiB0cnVlLAogICAgInNlc3Npb24iOiBmYWxzZSwKICAgICJzdG9yZUlkIjogbnVsbCwKICAgICJ2YWx1ZSI6ICJ2MSUzQTE2MTIzMTIzMTIxMjMxNzE0NDQxOSIsCiAgICAiaWQiOiAxCiAgfSwKICB7CiAgICAiZG9tYWluIjogIi50d2l0dGVyLmNvbSIsCiAgICAiZXhwaXJhdGlvbkRhdGUiOiAxNzE4NzI3NTI5LjAsCiAgICAiaG9zdE9ubHkiOiB0cnVlLAogICAgImh0dHBPbmx5IjogZmFsc2UsCiAgICAibmFtZSI6ICJwZXJzb25hbGl6YXRpb25faWQiLAogICAgInBhdGgiOiAiLyIsCiAgICAic2FtZVNpdGUiOiAiTm9uZSIsCiAgICAic2VjdXJlIjogdHJ1ZSwKICAgICJzZXNzaW9uIjogZmFsc2UsCiAgICAic3RvcmVJZCI6IG51bGwsCiAgICAidmFsdWUiOiAiXCJ2MV9Jc2tpczEyMzEyMzEyTjNTUT09XCIiLAogICAgImlkIjogMQogIH0KfQ==

https://www.base64encode.org/





--------------------------------


Token
cookies

namevalue pair with cookie separator : and namevalue format
n=v

Code: Select all

cookie1_name=cookie1_value:cookie2_name=cookie2_value:cookie3_name=cookie3_value


cookieskv2
A key value pair separated by a ;.

Code: Select all

name=value;name2=value2;name3=value3

Re: Custom Import routine

Posted: Tue Sep 27, 2022 3:09 pm
by martin@rootjazz
Twitter allows

Code: Select all

auth

Code: Select all

ct0
to specify authtoken cookie and ct0 for login

username,password,auth,ct0




WARNING. Username is required as a minimum
username,auth


Regards,
Martin

Re: Custom Import routine

Posted: Mon Oct 31, 2022 10:12 pm
by martin@rootjazz
CUSTOM separator char added
Format:

Code: Select all

line1: <sep>
line2: <spec>
line3+: <accs>
 

example:

Code: Select all

|
username|password|email
dave6235467|p455word1|dave6235467@gmail.com
dave123678|p455word1|dave123678@gmail.com
dave9326867|p455word1|dave9326867@gmail.com

Re: Custom Import routine

Posted: Tue Nov 29, 2022 7:36 pm
by papamax
I have a question about JSON cookies importing... would the format below be imported fine? or do I actually need to modify it to base64?

username|password|email|cookies
dave6235467|p455word1|dave6235467@gmail.com|[{"domain":".expedia.de","expirationDate":1704045717.651762,"httpOnly":true,"name":"CRQS","path":"/","secure":true,"session":false,"value":"t|6`s|6`l|de_DE`c|EUR","sameSite":"no_restriction"},{"domain":".expedia.de","expirationDate":-11644473600,"httpOnly":true,"name":"CRQSS","path":"/","secure":true,"session":true,"value":"e|0","sameSite":"no_restriction"},{"domain":".meetup.com","expirationDate":1704045718.869116,"httpOnly":false,"name":"MEETUP_BROWSER_ID","path":"/","secure":true,"session":false,"value":"id=3a5f1570-2311-435e-af91-1b3bcaa495df","sameSite":"no_restriction"},{"domain":".paypal.com","expirationDate":-11644473600,"httpOnly":true,"name":"x-pp-s","path":"/","secure":true,"session":true,"value":"eyJ0IjoiMTY2OTY1ODg0MDcxNCIsImwiOiIwIiwibSI6IjAifQ","sameSite":"no_restriction"},{"domain":".twitter.com","expirationDate":1703873317.702723,"httpOnly":false,"name":"guest_id_ads","path":"/","secure":true,"session":false,"value":"v1%3A16694857164641245","sameSite":"no_restriction"},{"domain":".twitter.com","expirationDate":1703873317.702755,"httpOnly":false,"name":"guest_id_marketing","path":"/","secure":true,"session":false,"value":"v1%3A16694857164641245","sameSite":"no_restriction"},{"domain":".twitter.com","expirationDate":1703873317.702764,"httpOnly":false,"name":"personalization_id","path":"/","secure":true,"session":false,"value":"\"v1_o0zhbA226uxGiY3c5P5ww==\"","sameSite":"no_restriction"}]

Re: Custom Import routine

Posted: Wed Nov 30, 2022 3:44 pm
by martin@rootjazz
papamax wrote: Tue Nov 29, 2022 7:36 pm I have a question about JSON cookies importing... would the format below be imported fine? or do I actually need to modify it to base64?

username|password|email|cookies
dave6235467|p455word1|dave6235467@gmail.com|[{"domain":".expedia.de","expirationDate":1704045717.651762,"httpOnly":true,"name":"CRQS","path":"/","secure":true,"session":false,"value":"t|6`s|6`l|de_DE`c|EUR","sameSite":"no_restriction"},{"domain":".expedia.de","expirationDate":-11644473600,"httpOnly":true,"name":"CRQSS","path":"/","secure":true,"session":true,"value":"e|0","sameSite":"no_restriction"},{"domain":".meetup.com","expirationDate":1704045718.869116,"httpOnly":false,"name":"MEETUP_BROWSER_ID","path":"/","secure":true,"session":false,"value":"id=3a5f1570-2311-435e-af91-1b3bcaa495df","sameSite":"no_restriction"},{"domain":".paypal.com","expirationDate":-11644473600,"httpOnly":true,"name":"x-pp-s","path":"/","secure":true,"session":true,"value":"eyJ0IjoiMTY2OTY1ODg0MDcxNCIsImwiOiIwIiwibSI6IjAifQ","sameSite":"no_restriction"},{"domain":".twitter.com","expirationDate":1703873317.702723,"httpOnly":false,"name":"guest_id_ads","path":"/","secure":true,"session":false,"value":"v1%3A16694857164641245","sameSite":"no_restriction"},{"domain":".twitter.com","expirationDate":1703873317.702755,"httpOnly":false,"name":"guest_id_marketing","path":"/","secure":true,"session":false,"value":"v1%3A16694857164641245","sameSite":"no_restriction"},{"domain":".twitter.com","expirationDate":1703873317.702764,"httpOnly":false,"name":"personalization_id","path":"/","secure":true,"session":false,"value":"\"v1_o0zhbA226uxGiY3c5P5ww==\"","sameSite":"no_restriction"}]
No, as above
Token
cookies

namevalue pair with cookie separator : and namevalue format
n=v
I suppose with custom separator now, we could potentially import pure json cookies. But it is NOT supported at this time, you would need base64 it

Re: Custom Import routine

Posted: Wed Nov 30, 2022 4:19 pm
by papamax
Like so then?

username|password|email|cookies
dave6235467|p455word1|dave6235467@gmail.com|W3siZG9tYWluIjoiLmV4cGVkaWEuZGUiLCJleHBpcmF0aW9uRGF0ZSI6MTcwNDA0NTcxNy42NTE3NjIsImh0dHBPbmx5Ijp0cnVlLCJuYW1lIjoiQ1JRUyIsInBhdGgiOiIvIiwic2VjdXJlIjp0cnVlLCJzZXNzaW9uIjpmYWxzZSwidmFsdWUiOiJ0fDZgc3w2YGx8ZGVfREVgY3xFVVIiLCJzYW1lU2l0ZSI6Im5vX3Jlc3RyaWN0aW9uIn0seyJkb21haW4iOiIuZXhwZWRpYS5kZSIsImV4cGlyYXRpb25EYXRlIjotMTE2NDQ0NzM2MDAsImh0dHBPbmx5Ijp0cnVlLCJuYW1lIjoiQ1JRU1MiLCJwYXRoIjoiLyIsInNlY3VyZSI6dHJ1ZSwic2Vzc2lvbiI6dHJ1ZSwidmFsdWUiOiJlfDAiLCJzYW1lU2l0ZSI6Im5vX3Jlc3RyaWN0aW9uIn0seyJkb21haW4iOiIubWVldHVwLmNvbSIsImV4cGlyYXRpb25EYXRlIjoxNzA0MDQ1NzE4Ljg2OTExNiwiaHR0cE9ubHkiOmZhbHNlLCJuYW1lIjoiTUVFVFVQX0JST1dTRVJfSUQiLCJwYXRoIjoiLyIsInNlY3VyZSI6dHJ1ZSwic2Vzc2lvbiI6ZmFsc2UsInZhbHVlIjoiaWQ9M2E1ZjE1NzAtMjMxMS00MzVlLWFmOTEtMWIzYmNhYTQ5NWRmIiwic2FtZVNpdGUiOiJub19yZXN0cmljdGlvbiJ9LHsiZG9tYWluIjoiLnBheXBhbC5jb20iLCJleHBpcmF0aW9uRGF0ZSI6LTExNjQ0NDczNjAwLCJodHRwT25seSI6dHJ1ZSwibmFtZSI6IngtcHAtcyIsInBhdGgiOiIvIiwic2VjdXJlIjp0cnVlLCJzZXNzaW9uIjp0cnVlLCJ2YWx1ZSI6ImV5SjBJam9pTVRZMk9UWTFPRGcwTURjeE5DSXNJbXdpT2lJd0lpd2liU0k2SWpBaWZRIiwic2FtZVNpdGUiOiJub19yZXN0cmljdGlvbiJ9LHsiZG9tYWluIjoiLnR3aXR0ZXIuY29tIiwiZXhwaXJhdGlvbkRhdGUiOjE3MDM4NzMzMTcuNzAyNzIzLCJodHRwT25seSI6ZmFsc2UsIm5hbWUiOiJndWVzdF9pZF9hZHMiLCJwYXRoIjoiLyIsInNlY3VyZSI6dHJ1ZSwic2Vzc2lvbiI6ZmFsc2UsInZhbHVlIjoidjElM0ExNjY5NDg1NzE2NDY0MTI0NSIsInNhbWVTaXRlIjoibm9fcmVzdHJpY3Rpb24ifSx7ImRvbWFpbiI6Ii50d2l0dGVyLmNvbSIsImV4cGlyYXRpb25EYXRlIjoxNzAzODczMzE3LjcwMjc1NSwiaHR0cE9ubHkiOmZhbHNlLCJuYW1lIjoiZ3Vlc3RfaWRfbWFya2V0aW5nIiwicGF0aCI6Ii8iLCJzZWN1cmUiOnRydWUsInNlc3Npb24iOmZhbHNlLCJ2YWx1ZSI6InYxJTNBMTY2OTQ4NTcxNjQ2NDEyNDUiLCJzYW1lU2l0ZSI6Im5vX3Jlc3RyaWN0aW9uIn0seyJkb21haW4iOiIudHdpdHRlci5jb20iLCJleHBpcmF0aW9uRGF0ZSI6MTcwMzg3MzMxNy43MDI3NjQsImh0dHBPbmx5IjpmYWxzZSwibmFtZSI6InBlcnNvbmFsaXphdGlvbl9pZCIsInBhdGgiOiIvIiwic2VjdXJlIjp0cnVlLCJzZXNzaW9uIjpmYWxzZSwidmFsdWUiOiJcInYxX28wemhiQTIyNnV4R2lZM2M1UDV3dz09XCIiLCJzYW1lU2l0ZSI6Im5vX3Jlc3RyaWN0aW9uIn1d

Re: Custom Import routine

Posted: Wed Nov 30, 2022 4:55 pm
by martin@rootjazz
the default separator char is ,

You can use the custom separator char, but you must specify it. Info here:
viewtopic.php?p=72705#p72705

Re: Custom Import routine

Posted: Wed Nov 30, 2022 5:09 pm
by papamax
So, the correct way would be this with default method:

username,password,email,cookies
dave6235467,p455word1,dave6235467@gmail.com,W3siZG9tYWluIjoiLmV4cGVkaWEuZGUiLCJleHBpcmF0aW9uRGF0ZSI6MTcwNDA0NTcxNy42NTE3NjIsImh0dHBPbmx5Ijp0cnVlLCJuYW1lIjoiQ1JRUyIsInBhdGgiOiIvIiwic2VjdXJlIjp0cnVlLCJzZXNzaW9uIjpmYWxzZSwidmFsdWUiOiJ0fDZgc3w2YGx8ZGVfREVgY3xFVVIiLCJzYW1lU2l0ZSI6Im5vX3Jlc3RyaWN0aW9uIn0seyJkb21haW4iOiIuZXhwZWRpYS5kZSIsImV4cGlyYXRpb25EYXRlIjotMTE2NDQ0NzM2MDAsImh0dHBPb



or char

|
username|password|email|cookies
dave6235467|p455word1|dave6235467@gmail.com|W3siZG9tYWluIjoiLmV4cGVkaWEuZGUiLCJleHBpcmF0aW9uRGF0ZSI6MTcwNDA0NTcxNy42NTE3NjIsImh0dHBPbmx5Ijp0cnVlLCJuYW1lIjoiQ1JRUyIsInBhdGgiOiIvIiwic2VjdXJlIjp0cnVlLCJzZXNzaW9uIjpmYWxzZSwidmFsdWUiOiJ0fDZgc3w2YGx8ZGVfREVgY3xFVVIiLCJzYW1lU2l0ZSI6Im5vX3Jlc3RyaWN0aW9uIn0seyJkb21haW4iOiIuZXhwZWRpYS5kZSIsImV4cGlyYXRpb25EYXRlIjotMTE2NDQ0NzM2MDAsImh0dHBPb




I will give it a try. Tks

Re: Custom Import routine

Posted: Mon Dec 05, 2022 9:43 pm
by martin@rootjazz
correct