Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: No CSV export on windows server

No CSV export on windows server 14 years 10 months ago #6052

  • definedbyeye
  • definedbyeye's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 4
  • Thank you received: 0
I have DT Register installed on a linux server and a windows server. The linux server will return rows in my export CSV. The windows server will not. Yes, everything is selected for download. :(

DT Donate exports fine (on both servers).

Could I have created a custom field that is interfering with the query? Right now, the query looks like this:
select if(a.user_id != 0 , a.user_id ,'' ) user_id, a.register_date, e.summary , e.summary title , e.dtstart publish_up, a.userId ,
if(a.userType='I','Individual','Group') as userType ,a.userFirstname,a.userLastname,a.userOrganization,a.userAddress,a.userCity,a.userState,a.userZip,a.userCountry,a.userEmail,a.userPhone,a.userTitle,a.userSuffix ,a.Individual_Golf_Players_Entry_Fee,a.hilton_head_individual_golf_tickets,a.golf_foursome,a.tournament_sponsorship,a.tournament_sponsor,a.pledge_of_future_glory_sponsorship,a.hilton_head_pfg_sonsorship,a.pledge_of_future_glory_sponsor,a.tee_sponsorship,a.hilton_head_tee_sponsorship,a.tee_sponsor,a.beverage_cart_sponsorship,a.attending_dinner,a.hilton_head_dinner_tickets,a.dinner_guests,a.hilton_head_dinner_table,a.dinner_guest_names,a.hilton_head_dinner_sponsorship,a.how_did_you_hear_about_us,a.comments,b.groupName,b.groupId,c.groupMemberId,c.groupUserId,c.title,c.firstname,c.lastname,c.suffix,c.organization,c.address,c.city,c.state,c.country,c.zip,c.email,c.phone,c.Individual_Golf_Players_Entry_Fee as m_Individual_Golf_Players_Entry_Fee,c.hilton_head_individual_golf_tickets as m_hilton_head_individual_golf_tickets,c.golf_foursome as m_golf_foursome,c.tournament_sponsorship as m_tournament_sponsorship,c.tournament_sponsor as m_tournament_sponsor,c.pledge_of_future_glory_sponsorship as m_pledge_of_future_glory_sponsorship,c.hilton_head_pfg_sonsorship as m_hilton_head_pfg_sonsorship,c.pledge_of_future_glory_sponsor as m_pledge_of_future_glory_sponsor,c.tee_sponsorship as m_tee_sponsorship,c.hilton_head_tee_sponsorship as m_hilton_head_tee_sponsorship,c.tee_sponsor as m_tee_sponsor,c.beverage_cart_sponsorship as m_beverage_cart_sponsorship,c.attending_dinner as m_attending_dinner,c.hilton_head_dinner_tickets as m_hilton_head_dinner_tickets,c.dinner_guests as m_dinner_guests,c.hilton_head_dinner_table as m_hilton_head_dinner_table,c.dinner_guest_names as m_dinner_guest_names,c.hilton_head_dinner_sponsorship as m_hilton_head_dinner_sponsorship,c.how_did_you_hear_about_us as m_how_did_you_hear_about_us,c.comments as m_comments, d.numberOfPerson ,d.amount ,payment_type ,
if(pay_later_paid=1 ,'Paid', if(payment_type!='Free' && payment_type!='','Not Paid',' ')) as paid ,a.confirmNum ,
dis.code from #__dtregister_user a inner join #__dtregister_group b on a.userId= b.useid left join #__dtregister_group_member c on b.groupId=c.groupUserId inner join #__dtregister_group_amount d on d.groupId=b.groupId inner join #__jevents_vevdetail As e on a.eventId=e.evdet_id left join #__dtregister_codes dis on dis.id = a.discount_code_id where a.eventId in (1,4,2,3,5,6,7) and a.payment_verified=1 order by a.register_date desc

** I modified the code to add the registrant title and suffix fields. My code works on Linux

Please Log in or Create an account to join the conversation.

No CSV export on windows server 14 years 10 months ago #6053

  • dthadmin
  • dthadmin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 5470
  • Thank you received: 3
Obviously we can provide very limited support for your local system. I would suggest checking these database tables:
jos_dtregister_user
jos_dtregister_group_member

Make sure both tables have an entry for EVERY custom field that you have created. It is possible that a field did not successfully add itself to one or both of those tables. Then if you're trying to export data from that field, it would cause a problem if it's not there.

You could also try limiting your export options until you find what works and what doesn't. Then you can maybe pinpoint where your problem is.

Please Log in or Create an account to join the conversation.

No CSV export on windows server 14 years 10 months ago #6055

  • definedbyeye
  • definedbyeye's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 4
  • Thank you received: 0
Very good suggestion - I'll check it out. Thanks for the quick reply too!

Please Log in or Create an account to join the conversation.

No CSV export on windows server 14 years 10 months ago #6056

  • definedbyeye
  • definedbyeye's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 4
  • Thank you received: 0
Ok, I don't get it... dtregister_group_member table is empty on both servers. We've only done individual registrations...?

Please Log in or Create an account to join the conversation.

No CSV export on windows server 14 years 10 months ago #6057

  • definedbyeye
  • definedbyeye's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 4
  • Thank you received: 0
No, I misread... still looking

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.140 seconds