baseless
Fieldproxy Documentation
baseless
Fieldproxy Documentation
Features

icon picker
Import Data

Import Data using Excel File:

To Import data Into the Fieldproxy. You can click on Import option on any given module
⁠
image.png
⁠
⁠
On clicking on the import button, You can find the below option to upload your data file.
⁠
image.png
⁠
⁠
The Download Sample, gives you sample data format with the column name. In Order to import data into fieldproxy, you need to follow the following steps.

Prepare your excel file:

Ensure your files are prepared for import, so your team can start using Fieldproxy right away!
You have to make sure the given excel is in the following format
Excel: .xls, .xlsx
Comma-separated values (CSV): .csv

Supported Column Format:

Column Type
Instructions
Fromat
Example
1
Text
This column should be in Text Format.
Text
Johny
2
Date
This column should be in Text Format, while importing
YYYY-MM-DD
2024-02-12
3
Time
This column should be in Text Format, while importing
HH:MM
12:30
4
Date Time
This column should be in Text Format, while importing
YYYY-MM-DD HH:MM
2024-02-12 12:30
5
Multi Text
This column should be in Text Format, while importing
Text1,text2
Jonny,Rohit
6
Number
This column should be in Number Format
Number
1
7
User
This column should be in Text Format, and the value should be user id. The user id will be present in the userlist
Text
Ir001
8
Multi Users
This column should be in text seperated with comma
Text,text
lr001,lr002
9
Location
This column should containt Latitude, Longitude.
Longitude,Latitude
80.2838536,13.0437229
10
URL
This contains the hyperlink
Link
https://fieldproxy.com
11
Rating
This contains number with value from 0 - 10
Number
4
12
Multi URL
This contains the hyperlink with comma seperated values
Link,Link
https://fieldproxy.com,
https://forum.fieldproxy.com
⁠
⁠
13
File
This contains the file link
Link
https://fieldproxy.com
14
Multi File
This contains the hyperlink with comma seperated values, The Multiple URL has to be composed within URL() section
Link,Link
URL(https://www.google.com),URL(https://www.fieldproxy.com)
15
Image
This contains the file link
Link
https://fieldproxy.com
16
Multi Image
This contains the hyperlink with comma seperated values, The value has to be composed within URL()
Link,Link
URL(https://www.google.com),URL(https://www.fieldproxy.com)
17
Team
This contains teamId which is a text. You can find the team id in the teams screen.
Text
te124
18
Multi Team
This contains multiple teamids, seperated by comma
text,text
te13,te231
19
Phone
This contains phone number, needs to be entered with the country code. The phone number has to be valid.
PhoneNumber
+919940591332
20
Email
This contains the email Id
emailId
support@fieldproxy.com
There are no rows in this table
⁠

Video Walkthrough:

⁠
⁠
⁠

Sample Excel Format

⁠
Fieldproxy -All Columns Sample Format.xlsx
Fieldproxy -All Columns Sample Format.xlsx
8.9 kB
⁠
⁠


Import Data using Excel File:
Prepare your excel file:
Supported Column Format:
Video Walkthrough:
Sample Excel Format
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.