How to allow importing of data in excel file

Hi @cheekeat,

You cannot upload Excel files directly, but you can upload csv files:
– Open your Excel file
– Save as (select csv file type)

After converting your Excel file to csv, you can upload it, map your columns to a database table and import the data. Here is a link to the tutorial:
https://wpdataaccess.com/docs/documentation/data-explorer/import-csv-file/

Does this helps?

Best regards,
Peter

• This reply was modified 4 years, 6 months ago by Passionate Programmer Peter.

Hi @peter,

Thanks for your reply! I have came across the link that you posted when I tried to search for file importing guide in your website. But, I found that it is different. It is Data Explorer, which I think is for admin use only. I am looking at the Data Projects side, where the user can login and upload.

In Data Projects, I have create a project named as Order & Shipping. In the “Order & Shipping”, I created 2 pages, 1 for administrator and author role only (appear at the backend menu), another 1 for the login user (role = subscriber) (appear in the frontend menu). I need to allow the login user to upload an excel or csv file from the frontend. If frontend upload is not allow, then backend is also fine with me. Is that possible?

Another thing that I tried to do is to allow the login user to only able to see what they have uploaded. I managed to use your guideline to “aa11plus” (7 months ago) to setup the connection with wp_users table. The login user can now see their own uploaded data. Yet, when they want to upload a new data, it won’t capture the login session/login id automatically into the wp_user_id column. Also, in the Table Option for the data entry form, the checkbox to hide the wp_user_id is disable. So, I can only hide wp_user_id in list table, but not data entry form.

Appreciate your help! Many thanks!

• This reply was modified 4 years, 6 months ago by cheekeat.

Hi @cheekeat,

>>> I need to allow the login user to upload an excel or csv file from the frontend. If frontend upload is not allow, then backend is also fine with me. Is that possible?

Sorry, this is not (yet) possible. CSV uploads are only available from the Data Explorer, and the Data Explorer is only available for admin users.

I got this request from another user some time ago. To allow non admin users to upload csv files I need to change the upload procedure. This is on my to do list, but that list is long.

If you know how to use WordPress hooks and filters, you can write your own code to allow specific users to upload csv files on specific pages. Would that be an alternative for you?

Best regards,
Peter

Hi @peterschulznl,

Any temporary solutions will be good for me. I learnt about WordPress hooks, but never really used them. I will read further about hooks and filters.

Maybe you can provide me some ideas or point me some direction on how to start this. Then, I can try to figure out the details by myself.

FYI, I know a little on child theme creation and put script into function.php.

Thanks for your patience. I really appreciate you help.

Hi @cheekeat,

Let me think about this. This might an interesting alternative for other plugin users as well. I’ll see if I can find a solution and let you know…

Best regards,
Peter

Hi @peterschulznl,

I managed to create a little plugin, which enable users to upload csv file to database table. So, I am good for now. Let me know if you have anything I can help. Thank you so much for this awesome plugin.

Best regards,
cheekeat

Hi @cheekeat,

>>> I managed to create a little plugin, which enable users to upload csv file to database table.

Great! ?? Can you share it? You might save me a lot of time… ??

You can use the contactform on the website if you prefer to share in private…

Thanks,
Peter

Hi @peterschulznl,

I have just sent the contactform on your website. I have zipped my plugin folder. Maybe after you reply me, I can attach the zip folder to you.

Thanks,
cheekeat

Thank you for sharing! ??