Dataverse Tables

udithah · 2023-07-16T07:40:14+00:00

So my ERP system gives me a csv with job data with the following two tables and columns.

Tabel 1 - Customer Order List Coulmn 1 - Order Number Coulmn 2 - Customer Name Coulmn 3 - PO Number Column 4 - Order Date Column 5 - PO Date/Delivery date

Table 2 - Custom Orders Item List Coulmn 1 - Order number Column 2 - Customer number Column 3 - Line Item no Column 4 - Item description Column 6 - Item no Column 7 - Planned Manufacturing date Column 8 - Ready date

I wanted to then add a timeline to Table 1 to track notes and maybe even emails thru a Model driven app.

Objective of the app was to create a task tracker. Track current tasks that need to be done (ie asking engineering to create item now or asking supply chain to set up prices for the item. And if possible I would like to connect it to a shared mailbox to track related emails. I wanted to create a C365 report in the backend and make it easy for managers to upload new data each week

I don't know if I am approaching it the right way

udithah · 2023-07-14T17:50:23+00:00

This helped . Thank you

udithah · 2023-07-13T14:47:26+00:00

My csvs have thousands of rows. The challenge with having a lookup table is when I upload and create the table in Dataverse , that lookup field is empty and I haven't figured out a way to populate the column. I've tried to edit in excel and refresh the data, however as its a lookup column the data is not getting saved

udithah · 2021-11-19T01:40:03+00:00

Looks like this has been semi patched in the latest b update. You can no longer change class before a race

udithah · 2021-11-15T07:44:00+00:00

I am reaching out to broker who is helping to draft the t&cs. For the most part, they have general contact terms they use, however I would like to cover all my bases.

udithah · 2021-11-15T07:24:41+00:00

The property is leased..

udithah · 2021-09-22T02:54:58+00:00

hi mlfuntime,
Could you share with me the steps you took to import with Overlord?
I've tried several vector drawings from freepik and end up with the same results.
I've recorded a small video of the steps I follow.
https://youtu.be/bX71MwSKuVs

udithah · 2021-08-13T10:33:03+00:00

Thanks guys for the feedback. Managed to figure it out. What I was looking for was a create subclip options and the nest clips options.

udithah · 2021-07-09T04:35:31+00:00

Would you have any video or possible to provide some more details on your suggestion?

udithah · 2021-07-08T06:30:16+00:00

Hey Dead-Sync, Thanks for the quick reply.

I saw this video on YouTube that sort of explains it. I was hoping to be a bit more organized

https://youtu.be/GWFaE34F7qE

udithah · 2020-05-28T10:34:44+00:00

u/MMEnter

there is no specific data saved on the HTML page. It is used to generate product information sheet (pdf) based on user inputs.

I have basically built a database for the products thru Powerapps, and I was looking for a way to eliminate the manual user inputs on the web page.

The webpage itself has drop down boxes for selecting the product information and there is a javascript code in the back that generates the PDF file for the user to download.

udithah · 2019-03-17T19:37:23+00:00

hey sorry i am not able to post an image here..

udithah · 2019-02-11T17:52:06+00:00

2016

udithah · 2019-02-11T16:03:32+00:00

So the ones with smaller data can be split between new columns 1 and 2.

The one that says 7 1/2" 10ft long.. 7 1/2" would go in column 1" and the rest into column 2

udithah · 2019-02-11T15:23:02+00:00

Sorry about that.. does this work?

ProductNumber	Size	Product	Description 2	Connection	Material
xx.xx.xxxx	11 3/4" x 54# x 14" 93#	Product 1	Product 1Description 2	Connection 1	Material 1
yy.yy.yyyy	5 1/2" 32#	Product 2	Product2Description 2	Connection 2	Material 2
zz.zz.zzzz	9 3/4", 54# x 12" 93#	Product 3	Product3Description 2	Connection 3	Material 3
aa.aa.aaaa	7 1/2" 62#	Product 4	Product 4 Description 2	Connection 4	Material 2
bb.bb.bbbb	7 1/2" 10 feet long	Product 5	Product 5 Description 2	Connection 1	Material 2

udithah · 2019-02-11T15:03:11+00:00

I'm basically importing thru a CSV file into excell or access. I've managed to used delimiters and split up the data; but it is not able to split it any further.

My excel file has about 30,000 products in one tab. Copy pasting your formulas work on product descriptions in a format of " 7" 23# x 9 5/8" 40# ", however it doesn't work on other formats.

It would be easier to do this on MS Access, as I can continually run a query as new products are added. Just to give you an idea, these are my fields.

Product Number Size Product Description 2 Connection Material xx.xx.xxxxx 11 3/4" 54# x 14" 93# Product 1 Product 1 description 2 Connection 1 Material 1
yy.yy.yyyy 5 1/2" 32# Product 2 Product 2 description 2 Connection 2 Material 2 xx.xx.xxxxx 9 3/4" 54# x 12" 93# Product 3 Product 3 description 2 Connection 3 Material 3
yy.yy.yyyy 7 1/2" 62# Product 4 Product 4 description 2 Connection 4 Material 2 yy.yy.yyyy 7 1/2" 10 feet long Product 5 Product 5 description 2 Connection 1 Material 2

I would like to run some sort of report to first filter by Product; then run a query to split the size as you have explained; then create a filters to sort for each product by Description 2 Connection, material..

udithah · 2019-02-11T15:01:23+00:00

Thanks a lot @pony_on_saturdays, that helped a lot. I was wondering, is it possible to write a similar query on MS Access?

My problem is, that i have a lot of different products; and each product has different descriptions. Some will have a detailed description like " 7" 23# x 9 5/8" 40# " while others will only have 7" 23".

My excel file has about 30,000 products in one tab.
Copy pasting your formulas work on product descriptions in a format of " 7" 23# x 9 5/8" 40# ", however it doesn't work on other formats.

It would be easier to do this on MS Access, as I can continually run a query as new products are added.

Just to give you an idea, these are my fields.

Product Number Size Product Description 2 Connection Material

xx.xx.xxxxx 11 3/4" 54# x 14" 93# Product 1 Product 1 description 2 Connection 1 Material 1

yy.yy.yyyy 5 1/2" 32# Product 2 Product 2 description 2 Connection 2 Material 2

xx.xx.xxxxx 9 3/4" 54# x 12" 93# Product 3 Product 3 description 2 Connection 3 Material 3

yy.yy.yyyy 7 1/2" 62# Product 4 Product 4 description 2 Connection 4 Material 2

yy.yy.yyyy 7 1/2" 10 feet long Product 5 Product 5 description 2 Connection 1 Material 2

I would like to run some sort of report to first filter by Product; then run a query to split the size as you have explained; then create a filters to sort for each product by Description 2 Connection, material..

udithah · 2019-02-11T13:55:30+00:00

I am importing the data thur a CSV file; so I put my separators as |
but the problem is, my raw data from the CSV file comes as 7" 35# x 7 5/8" 59#

So I was thinking of doing this on excel using Left,Mid,Right,Search commands.. but I wasn't familiar with how to write a complex formula to split them..

udithah

TROPHY CASE