Custom Import routine

Ask any support / help / issues / problem or question related to any of our other products
User avatar
martin@rootjazz
Site Admin
Posts: 34360
Joined: Fri Jan 25, 2013 10:06 pm
Location: The Funk
Contact:

Custom Import routine

Post 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
User avatar
martin@rootjazz
Site Admin
Posts: 34360
Joined: Fri Jan 25, 2013 10:06 pm
Location: The Funk
Contact:

Re: Custom Import routine

Post 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
User avatar
martin@rootjazz
Site Admin
Posts: 34360
Joined: Fri Jan 25, 2013 10:06 pm
Location: The Funk
Contact:

Re: Custom Import routine

Post 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
User avatar
martin@rootjazz
Site Admin
Posts: 34360
Joined: Fri Jan 25, 2013 10:06 pm
Location: The Funk
Contact:

Re: Custom Import routine

Post 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
papamax
Posts: 55
Joined: Sat Nov 26, 2022 6:20 pm

Re: Custom Import routine

Post 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"}]
User avatar
martin@rootjazz
Site Admin
Posts: 34360
Joined: Fri Jan 25, 2013 10:06 pm
Location: The Funk
Contact:

Re: Custom Import routine

Post 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
papamax
Posts: 55
Joined: Sat Nov 26, 2022 6:20 pm

Re: Custom Import routine

Post by papamax »

Like so then?

username|password|email|cookies
dave6235467|p455word1|dave6235467@gmail.com|W3siZG9tYWluIjoiLmV4cGVkaWEuZGUiLCJleHBpcmF0aW9uRGF0ZSI6MTcwNDA0NTcxNy42NTE3NjIsImh0dHBPbmx5Ijp0cnVlLCJuYW1lIjoiQ1JRUyIsInBhdGgiOiIvIiwic2VjdXJlIjp0cnVlLCJzZXNzaW9uIjpmYWxzZSwidmFsdWUiOiJ0fDZgc3w2YGx8ZGVfREVgY3xFVVIiLCJzYW1lU2l0ZSI6Im5vX3Jlc3RyaWN0aW9uIn0seyJkb21haW4iOiIuZXhwZWRpYS5kZSIsImV4cGlyYXRpb25EYXRlIjotMTE2NDQ0NzM2MDAsImh0dHBPbmx5Ijp0cnVlLCJuYW1lIjoiQ1JRU1MiLCJwYXRoIjoiLyIsInNlY3VyZSI6dHJ1ZSwic2Vzc2lvbiI6dHJ1ZSwidmFsdWUiOiJlfDAiLCJzYW1lU2l0ZSI6Im5vX3Jlc3RyaWN0aW9uIn0seyJkb21haW4iOiIubWVldHVwLmNvbSIsImV4cGlyYXRpb25EYXRlIjoxNzA0MDQ1NzE4Ljg2OTExNiwiaHR0cE9ubHkiOmZhbHNlLCJuYW1lIjoiTUVFVFVQX0JST1dTRVJfSUQiLCJwYXRoIjoiLyIsInNlY3VyZSI6dHJ1ZSwic2Vzc2lvbiI6ZmFsc2UsInZhbHVlIjoiaWQ9M2E1ZjE1NzAtMjMxMS00MzVlLWFmOTEtMWIzYmNhYTQ5NWRmIiwic2FtZVNpdGUiOiJub19yZXN0cmljdGlvbiJ9LHsiZG9tYWluIjoiLnBheXBhbC5jb20iLCJleHBpcmF0aW9uRGF0ZSI6LTExNjQ0NDczNjAwLCJodHRwT25seSI6dHJ1ZSwibmFtZSI6IngtcHAtcyIsInBhdGgiOiIvIiwic2VjdXJlIjp0cnVlLCJzZXNzaW9uIjp0cnVlLCJ2YWx1ZSI6ImV5SjBJam9pTVRZMk9UWTFPRGcwTURjeE5DSXNJbXdpT2lJd0lpd2liU0k2SWpBaWZRIiwic2FtZVNpdGUiOiJub19yZXN0cmljdGlvbiJ9LHsiZG9tYWluIjoiLnR3aXR0ZXIuY29tIiwiZXhwaXJhdGlvbkRhdGUiOjE3MDM4NzMzMTcuNzAyNzIzLCJodHRwT25seSI6ZmFsc2UsIm5hbWUiOiJndWVzdF9pZF9hZHMiLCJwYXRoIjoiLyIsInNlY3VyZSI6dHJ1ZSwic2Vzc2lvbiI6ZmFsc2UsInZhbHVlIjoidjElM0ExNjY5NDg1NzE2NDY0MTI0NSIsInNhbWVTaXRlIjoibm9fcmVzdHJpY3Rpb24ifSx7ImRvbWFpbiI6Ii50d2l0dGVyLmNvbSIsImV4cGlyYXRpb25EYXRlIjoxNzAzODczMzE3LjcwMjc1NSwiaHR0cE9ubHkiOmZhbHNlLCJuYW1lIjoiZ3Vlc3RfaWRfbWFya2V0aW5nIiwicGF0aCI6Ii8iLCJzZWN1cmUiOnRydWUsInNlc3Npb24iOmZhbHNlLCJ2YWx1ZSI6InYxJTNBMTY2OTQ4NTcxNjQ2NDEyNDUiLCJzYW1lU2l0ZSI6Im5vX3Jlc3RyaWN0aW9uIn0seyJkb21haW4iOiIudHdpdHRlci5jb20iLCJleHBpcmF0aW9uRGF0ZSI6MTcwMzg3MzMxNy43MDI3NjQsImh0dHBPbmx5IjpmYWxzZSwibmFtZSI6InBlcnNvbmFsaXphdGlvbl9pZCIsInBhdGgiOiIvIiwic2VjdXJlIjp0cnVlLCJzZXNzaW9uIjpmYWxzZSwidmFsdWUiOiJcInYxX28wemhiQTIyNnV4R2lZM2M1UDV3dz09XCIiLCJzYW1lU2l0ZSI6Im5vX3Jlc3RyaWN0aW9uIn1d
User avatar
martin@rootjazz
Site Admin
Posts: 34360
Joined: Fri Jan 25, 2013 10:06 pm
Location: The Funk
Contact:

Re: Custom Import routine

Post 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
papamax
Posts: 55
Joined: Sat Nov 26, 2022 6:20 pm

Re: Custom Import routine

Post 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
User avatar
martin@rootjazz
Site Admin
Posts: 34360
Joined: Fri Jan 25, 2013 10:06 pm
Location: The Funk
Contact:

Re: Custom Import routine

Post by martin@rootjazz »

correct
Post Reply