CSV Input but No Output

Questions & Answers
1

Hi there, I am doing a small internal Adalo app for timesheets. The issue I am having is with the CSV (advanced) module. My issue is that the csv appears to have data on the input but sends out nothing. As you can see in this series of images…adalo output, csv input and output. It is getting data. Just not outputting the csv that I want to send gmail to be emailed.

TS-1
TS-1447×823 26.2 KB

TS-2
TS-2430×704 22.9 KB

TS-3

2

Can you share me how you are mapping the data in CSV Module?

3

TS-4
TS-4729×724 67 KB

The Json is in this format.

{
“records”: {
“Name”: {
“type”: “string”
},
“LOCATION”: {
“type”: “string”
},
“ENDTIME”: {
“type”: “string”,
“format”: “date-time”
},
“PAYPERIOD”: {
“type”: “number”,
“example”: [
1,
2,
3
]
},
“TIMECARDHOURS”: {
“type”: “number”
},
“scale1”: {
“type”: “number”
},
“WORKDESC”: {
“type”: “string”
},
“scale2”: {
“type”: “number”
},
“TimeCardTotalHrs”: {
“type”: “number”
},
“CIRCLECHECK”: {
“type”: “string”
},
“EmployeeName”: {
“type”: “string”
},
“User”: {
“type”: “number”,
“example”: [
1,
2,
3
]
},
“STARTTIME”: {
“type”: “string”,
“format”: “date-time”
},
“LIVINGALLOW”: {
“type”: “string”
},
“TimeSheetDate”: {
“type”: “string”,
“format”: “date-time”
},
“MACHINE”: {
“type”: “string”
}
}
}

4

Try removing the starting parameters in JSON, i.e remove the records. You can regenerate new data structures using only,

{
“Name”: {
“type”: “string”
},
“LOCATION”: {
“type”: “string”
},
“ENDTIME”: {
“type”: “string”,
“format”: “date - time”
},
“PAYPERIOD”: {
“type”: “number”,
“example”: [
1,
2,
3
]
},
“TIMECARDHOURS”: {
“type”: “number”
},
“scale1”: {
“type”: “number”
},
“WORKDESC”: {
“type”: “string”
},
“scale2”: {
“type”: “number”
},
“TimeCardTotalHrs”: {
“type”: “number”
},
“CIRCLECHECK”: {
“type”: “string”
},
“EmployeeName”: {
“type”: “string”
},
“User”: {
“type”: “number”,
“example”: [
1,
2,
3
]
},
“STARTTIME”: {
“type”: “string”,
“format”: “date - time”
},
“LIVINGALLOW”: {
“type”: “string”
},
“TimeSheetDate”: {
“type”: “string”,
“format”: “date - time”
},
“MACHINE”: {
“type”: “string”
}
}

1 Like
5

I did and this was the output:

TS-5
TS-5444×731 24.6 KB

6

Sorry, My bad, I didn’t fully review the JSON while I was suggesting it to you, the problem with this is the Data Structure for CSV should be linear i.e key value, and the one that you have has it as a collection.

If it make sense, try your data structure like,

{
	"Name": "",
	"LOCATION": "",
	"ENDTIME": "",
	"PAYPERIOD": "",
	"TIMECARDHOURS": "",
	"scale1": "",
	"WORKDESC": "",
	"scale2": "",
	"TimeCardTotalHrs": "",
	"CIRCLECHECK": "",
	"EmployeeName": "",
	"User": "",
	"STARTTIME": "",
	"LIVINGALLOW": "",
	"TimeSheetDate": "",
	"MACHINE": ""
}

For multiple values, you can do a join to get it as a single value for eg. for User.

7

That did work. I had to redo my data structures but all in all it worked. Thanks a lot. I thought about what you suggested but I just assumed that the data would have no issues. I guess because it was looking at it as a collection of records and not just a template for one record.