Support forumCategory: BugsCSV export not working
Amy Edwards asked 5 years ago

Hi, 
When I export the appointment information to a CSV file, it is missing out information and placing information under incorrect columns on the spreadsheet. Please help!

3 Answers
Nikola Loncar Staff answered 5 years ago

Hi Amy,

can you please paste here current content of CSV file and expected version that should be there?

Best regards,
Nikola

Amy Edwards replied 5 years ago

Hello Nikola? Have you seen my response below?

Nikola Loncar Staff answered 5 years ago

Hi Amy,

can you please tell me if you were adding or removing custom fields? Thanks for the images I will need to test that locally.

Best regards,
Nikola

Amy Edwards replied 5 years ago

I added the custom fields which you can see on the website link I sent, i.e. consultation type, Skype address, Extra info, where did you hear about us? and the remortgage and refinance date.
Will you need to login to the site to test?

Nikola Loncar Staff replied 5 years ago

Hi, can you please create that temp account so I can access admin part.

Best regards,
Nikola

Amy Edwards replied 5 years ago

Please see login details in private response below.

Amy Edwards replied 5 years ago

Hi Nikola, have you been able to look into this yet?

Nikola Loncar Staff replied 5 years ago

Hi, there will be big update in next 48h so after that there will be time for that one. Sorry for waiting 🙁

Best regards,
Nikola

Amy Edwards replied 5 years ago

So this will be corrected in this update coming out in 48 hrs?

Nikola Loncar Staff replied 5 years ago

Hi Amy yes it will be solved in next version.

Best regards,
Nikola

Amy Edwards replied 5 years ago

Hi Nikola,

I am still having issues with the CSV exporting. The file used to export with data in the following order:
id, location, service, worker, name, email, phone, date, start, end, description, status, user, created, price, ip, session, skype-address-if-applicable, consultation-type, renewalrefinanceremortgage-date-if-applicable-ddmmyy, if-other-please-elaborate, how-did-you-hear-about-us, extra-information

Since the update to the plugin, the columns now go:
location, service, worker, date, start, end, end_date, status, user, price, ip, session, skype-address-if-applicable, consultation-type, renewalrefinanceremortgage-date-if-applicable-ddmmyy, if-other-please-elaborate, how-did-you-hear-about-us, extra-information, phone name, email

Can we have the columns export in the same sequence as before? The temp login is still active if you need access to investigate.

Amy Edwards replied 5 years ago

Also, would we be able to include a “print” function next to each appointment entry so that individual record information can be printed, in the next plugin update? So where you have options next to the appointment for “Edit” “Delete” and “Clone”, could there be another button saying “Print”? Thanks.

Nikola Loncar Staff replied 5 years ago

I had to change order of columns so it doesn’t mismatch the data. Because you have appointments that are created before adding new custom fields etc.

Regarding print you want to print just one Appointments?

Best regards,
Nikola

Amy Edwards replied 5 years ago

Could the columns not follow the order on the form? The issue is more that the user’s name and contact details are right at the end which makes it difficult for my client to use in a practical setting.

Yes that’s right, just one appointment at a time. Thank you.

Amy Edwards replied 5 years ago

Hi, I haven’t had a response for this yet?

Amy Edwards replied 5 years ago

Hello Nikola? Still not had an answer…

Nikola Loncar Staff answered 5 years ago

Hi Amy,

I am not sure that I can alter order of fields because this is only way of having all columns. I can only add option so each user can choose order and save it. Something like you have it now for custom fields?

Best regards,
Nikola

Amy Edwards replied 5 years ago

OK, can you explain a bit more as to how that would look? Also, are you able to add the print function we discussed? Thank you.

Amy Edwards replied 5 years ago

Hi Nikola, I need this resolving urgently please, and my client has been waiting for over 2 weeks now.

Nikola Loncar Staff replied 5 years ago

Hi it will be like option on that page so you can save order of columns of export. Then it will have any order that you want. Also you will be able to save it so you don’t have to do that every time. I will put this to prio.

Best regards,
Nikola

Amy Edwards replied 5 years ago

That would be great, do you have a time frame for when this will be released? Thank you

Nikola Loncar Staff replied 5 years ago

Hi I am working on that. It should be done in next 2-3 days.

Best regards,
Nikola

Amy Edwards replied 5 years ago

Brilliant, thank you.

Amy Edwards replied 5 years ago

Hi Nikola,

Thank you for the update to the system export function, this is great! Just wondering when we will get the print function we discussed? Thanks.

Nikola Loncar Staff replied 5 years ago

Hi it will be added but I can’t say exact moment.

Best regards,
Nikola