How can i set payments status?

Thyx tha would be nice. I havent understand your answer of the first question. Where can i set the subription day manually.

Extendend Question is: How can create a costum field with information of the expired day of a plan or and the payment status? So i can visualize within this list the day of expired day. And i will this do so for the payment status. Payed or unpayed. Nice would be a srcipt thats marks the expired day in red for the future or in red for in the past of today.

Thyx tha would be nice. I havent understand your answer of the first question. Where can i set the subription day manually.

Navigate to CBSubs > Import. The formats available describe how you need to format your import file. Using "File (each line: userid,planid,status,subscription date)" mode lets you specify their subscription date individually. The expiration date is based off the duration of the plan you're subscribing them to so you can not set that specifically.

Extendend Question is: How can create a costum field with information of the expired day of a plan or and the payment status? So i can visualize within this list the day of expired day. And i will this do so for the payment status. Payed or unpayed. Nice would be a srcipt thats marks the expired day in red for the future or in red for in the past of today.

See the below topic regarding displaying a plans expiration date as a field.

www.joomlapolis.com/forum/153-professional-member-support/240517-membership-registration-and-cbsubs?start=6#310601

Thx I do this so, but no output of the date. Ive rename the id of the plan. Hope it was the first column # thats include the id.
To solve the payment status of last payed date ive try a sql query with following query: (SELECT `time_paid_date` FROM `#__cbsubs_payment_baskets` ) but this is not happend. Anything is wrong to let it work. Do you have a solution for me?
Sry but i am not a programmer

You need to use the import feature in CBSubs > Import. You are not going to be able to import from another system into CBSubs directly in the database unless your other system is already CBSubs in which case you'd just directly export and import those database tables. If the other system isn't CBSubs then please read the CBSubs Manual carefully on how to use the import feature.

For example when using CBSubs > Import set "Import users from" to "File (each line: userid,planid,status,subscription date)". Now you need to supply it a text file with the following format.

userid,planid,status,subscription date

Separate each import with a linebreak. Example as follows.

63 is the user the subscription is being imported to. 1 is the plan that is being imported to the user. A is the status of that plan (Active). The date is the date the subscription was activated. Expiration and everything else will be calculated based off the plans settings.

OK but i dont want more import user data. Can u explain why my SQL query want work? Ive tryed this: (SELECT `time_paid_date` FROM `#__cbsubs_payment_baskets` ) I thing i need the right userid of the visit profile but havent any idea?

If you're using that in a query field provided by CB Query Field then it supports substitutions. You can substitute in the user id with [user_id]. Example as follows.